Changeset 10019 for trunk/Mars

Timestamp:

10/19/10 13:22:54 (14 years ago)

Author:

Daniela Dorner

Message:

added check if there are runs in the DB

File:

• trunk/Mars/datacenter/scripts/writemcsequencefile (modified) (1 diff)

trunk/Mars/datacenter/scripts/writemcsequencefile

@@ -65 +65 @@
    sequencefile=$sequencepath/sequence$no2.txt
    
+   # data runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
    datruns=`sendquery`
+   if [ "$datruns" = "" ]
+   then 
+      printprocesslog "ERROR data runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
+   # pedestal runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
    pedruns=`sendquery`
+   if [ "$pedruns" = "" ]
+   then 
+      printprocesslog "ERROR pedestal runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
+   # calibration runs
    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
    calruns=`sendquery`
+   if [ "$calruns" = "" ] 
+   then 
+      printprocesslog "ERROR calibration runs for sequence "$sequence" are missing in the database "
+      check=2
+   fi
    
    printprocesslog "INFO writing sequencefile $sequencefile"