Ignore:
Timestamp:
10/19/10 13:22:54 (14 years ago)
Author:
Daniela Dorner
Message:
added check if there are runs in the DB
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Mars/datacenter/scripts/writemcsequencefile

    r9592 r10019  
    6565   sequencefile=$sequencepath/sequence$no2.txt
    6666   
     67   # data runs
    6768   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
    6869   datruns=`sendquery`
     70   if [ "$datruns" = "" ]
     71   then
     72      printprocesslog "ERROR data runs for sequence "$sequence" are missing in the database "
     73      check=2
     74   fi
     75   # pedestal runs
    6976   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
    7077   pedruns=`sendquery`
     78   if [ "$pedruns" = "" ]
     79   then
     80      printprocesslog "ERROR pedestal runs for sequence "$sequence" are missing in the database "
     81      check=2
     82   fi
     83   # calibration runs
    7184   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
    7285   calruns=`sendquery`
     86   if [ "$calruns" = "" ]
     87   then
     88      printprocesslog "ERROR calibration runs for sequence "$sequence" are missing in the database "
     89      check=2
     90   fi
    7391   
    7492   printprocesslog "INFO writing sequencefile $sequencefile"
Note: See TracChangeset for help on using the changeset viewer.