Changeset 13287 for trunk/DataCheck/Processing

Timestamp:

03/29/12 11:09:21 (13 years ago)

Author:

Daniela Dorner

Message:

added nightly insert for new table DriveFileAvailISDCStatus

File:

• trunk/DataCheck/Processing/CheckRawData.sh (modified) (2 diffs)

trunk/DataCheck/Processing/CheckRawData.sh

@@ -57 +57 @@
 do 
    date2=`echo $date | sed -e 's/\///g'`
+   night=
    query="SELECT fNight FROM AuxFilesAvailISDCStatus WHERE fNight="$date2
    night=`sendquery`
@@ -63 +64 @@
       printprocesslog "INFO insert "$date2" to AuxFilesAvailISDCStatus"
       query="INSERT AuxFilesAvailISDCStatus SET fNight="$date2", fPriority="$date2
+      sendquery >/dev/null 2>&1
+   fi
+   night=
+   query="SELECT fNight FROM DriveFileAvailISDCStatus WHERE fNight="$date2
+   night=`sendquery`
+   if [ "$night" == "" ]
+   then
+      printprocesslog "INFO insert "$date2" to DriveFileAvailISDCStatus"
+      query="INSERT DriveFileAvailISDCStatus SET fNight="$date2", fPriority="$date2
       sendquery >/dev/null 2>&1
    fi