Changeset 15593 for trunk/DataCheck/Processing/CheckRawData.sh

Timestamp:

05/13/13 10:46:37 (12 years ago)

Author:

Daniela Dorner

Message:

added creating of row in table RatesFileAvailISDCStatus

File:

• trunk/DataCheck/Processing/CheckRawData.sh (modified) (1 diff)

trunk/DataCheck/Processing/CheckRawData.sh

@@ -85 +85 @@
       printprocesslog "INFO insert "$date2" to DriveFileAvailISDCStatus"
       query="INSERT DriveFileAvailISDCStatus SET fNight="$date2", fPriority="$date2
+      sendquery >/dev/null 2>&1
+   fi
+   night=
+   query="SELECT fNight FROM RatesFileAvailISDCStatus WHERE fNight="$date2
+   night=`sendquery`
+   if [ "$night" == "" ] && ls /loc_data/zipraw/$date >/dev/null 2>&1
+   then
+      printprocesslog "INFO insert "$date2" to RatesFileAvailISDCStatus"
+      query="INSERT RatesFileAvailISDCStatus SET fNight="$date2", fPriority="$date2
       sendquery >/dev/null 2>&1
    fi