Changeset 9919

Timestamp:

09/03/10 16:18:04 (14 years ago)

Author:

Daniela Dorner

Message:

fixed queries for change from file based to run based processing

File:

• trunk/Mars/datacenter/scripts/runceres (modified) (3 diffs)

trunk/Mars/datacenter/scripts/runceres

@@ -55 +55 @@
 setupfile=$setuppath/$program/`printf %03d $cereskey`/ceres.rc
 
-query="SELECT fRunTypeKEY FROM CeresInfo WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey
+query="SELECT fRunTypeKEY FROM CeresInfo WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey" GROUP BY fRunNumber"
 runkey=`sendquery`
 
@@ -61 +61 @@
    2) printprocesslog "INFO run $run is a data run (key="$runkey")"
       printprocesslog "INFO getting file numbers for run "$run
-      query="SELECT CONCAT('"$mcpath"/corsika/', RIGHT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4),"
-      query=$query" '"$mcpath"/corsika/', LEFT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4), '/cer000'"
+      query="SELECT CONCAT('"$mcpath"/corsika/', LEFT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4),"
+      query=$query" '/', RIGHT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4), '/cer000', "
       query=$query" RIGHT(LPAD(CeresInfo.fFileNumber, 6, '0'), 3)) from CeresInfo "
       query=$query" WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey
@@ -94 +94 @@
       check1=$?
       ;;
-   *) printprocesslog "WARN not valid fRunTypeKEY ("$runkey")was queried from the DB."
-      finish
+   *) printprocesslog "WARN not valid fRunTypeKEY ("$runkey") was queried from the DB."
+      check="no"
       ;;
 esac