Changeset 18771 for trunk/DataCheck

Timestamp:

02/20/17 13:58:55 (8 years ago)

Author:

Daniela Dorner

Message:

treat ratescan files specially in function check_file_avail

File:

• trunk/DataCheck/Sourcefile.sh (modified) (1 diff)

trunk/DataCheck/Sourcefile.sh

@@ -603 +603 @@
       # only for aux files check of DB is needed
       filenight=`basename $1 | cut -c 1-8`
+      # treat ratescan files 
+      checkratescan=`echo $1 | grep -E -o RATE_SCAN_DATA`
+      if [ "$checkratescan" = "RATE_SCAN_DATA" ] &&  [ $filenight -gt 20130408 ]
+      then
+         #query="SELECT fMeasurementTypeKey from MeasurementType WHERE fMeasurementTypeName like 'Ratescan%'"
+         #ratescantypes=`sendquery`
+         query="SELECT COUNT(*) FROM Schedule WHERE fStart BETWEEN "$scheduletart" AND "$schedulestop" AND fMeasurementTypeKey IN (5,8) "
+         numratescans=`sendquery`
+         if [ $numratescans -gt 0 ]
+         then 
+            printprocesslog "ERROR "$1" not found."
+         else
+            printprocesslog "INFO "$1" not found."
+         fi
+         return 1
+      fi
       query="SELECT COUNT(*) FROM RunInfo WHERE fNight="$filenight" AND fRunTypeKey=1"
       numdatruns=`sendquery`