Changeset 13158 for trunk/DataCheck/Processing

Timestamp:

03/21/12 13:50:08 (13 years ago)

Author:

Daniela Dorner

Message:

added insert to nightly status tables, removed insert for status tables for runs (done with mysql trigger now)

File:

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

trunk/DataCheck/Processing/CheckRawData.sh

@@ -51 +51 @@
 dates=( `date +%Y/%m/%d --date="-12hour"` `date +%Y/%m/%d --date="-36hour"` `date +%Y/%m/%d --date="-60hour"` )
 #dates=( `find /loc_data/zipraw/ -mindepth 3 -type d | sort | sed -e 's/\/loc_data\/zipraw\///g'` ) #all available dates in /loc_data/zipraw
+#dates=( `find /loc_data/aux/ -mindepth 3 -type d | sort | sed -e 's/\/loc_data\/aux\///g'` ) #all available dates in /loc_data/zipraw
 
 # do check for rawfiles of these dates
 for date in ${dates[@]}
 do 
+   date2=`echo $date | sed -e 's/\///g'`
+   query="SELECT fNight FROM AuxFilesAvailISDCStatus WHERE fNight="$date2
+   night=`sendquery`
+   if [ "$night" == "" ]
+   then
+      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 AuxDataInsertStatus WHERE fNight="$date2
+   night=`sendquery`
+   if [ "$night" == "" ]
+   then
+      printprocesslog "INFO insert "$date2" to AuxDataInsertStatus"
+      query="INSERT AuxDataInsertStatus SET fNight="$date2", fPriority="$date2
+      sendquery >/dev/null 2>&1
+   fi
    ziprawdir=/loc_data/zipraw/$date
    # check if data are available from that night
@@ -321 +340 @@
       if [ "$result3" == "" ]
       then 
-         query="INSERT RawFileAvailISDCStatus SET fNight="$runnumber", fPriority="$runnumber", fRunID="$filenumberfromname
-         sendquery >/dev/null
-         query="INSERT RawFileRsyncedISDCStatus SET fNight="$runnumber", fPriority="$runnumber", fRunID="$filenumberfromname
-         sendquery >/dev/null
-         query="INSERT RawFileAvailWueStatus SET fNight="$runnumber", fPriority="$runnumber", fRunID="$filenumberfromname
-         sendquery >/dev/null
          query="INSERT"
          querymid=" fNight="$runnumber", fRunID="$filenumberfromname", "