Changeset 9909 for trunk/Mars/datacenter

Timestamp:

08/30/10 12:36:57 (14 years ago)

Author:

Daniela Dorner

Message:

bugfix for insert of runs with new ceres keys

File:

• trunk/Mars/datacenter/scripts/insertmc (modified) (5 diffs)

trunk/Mars/datacenter/scripts/insertmc

@@ -37 +37 @@
 # to really insert information set insert="yes"
 insert="yes"
-#insert=
+insert=
 
 
@@ -44 +44 @@
 #  make sure that the information on the setup (i.e. table CeresSetup) 
 #  has been inserted before
-#cereskeys=( 2 3 ) 
-cereskeys=( 1 ) 
+cereskeys=( 2 3 4 5 6 ) 
+#cereskeys=( 1 ) 
 
 
@@ -55 +55 @@
 #  protons: files 2000-2399 i.e. runs 633-750
 #  protons: files 3000-3099 i.e. runs 933-960
-#runmin=423
-#runmax=960
-runmin=
-runmax=
+runmin=423
+runmax=960
+#runmin=
+#runmax=
 
 
@@ -190 +190 @@
    echo "Do you really want to insert the following cereskey(s)?"
    echo "  run number range:  "$runmin" - "$runmax
-   query="SELECT fRunNumber FROM CorsikaInfo WHERE fRunNumber BETWEEN "$runmin" AND "$runmax
+   query="SELECT fRunNumber FROM CorsikaInfo WHERE fRunNumber BETWEEN "$runmin" AND "$runmax" GROUP BY fRunNumber"
    runs=( `sendquery` )
    echo "    i.e. the following runs: "${runs[@]}
@@ -270 +270 @@
    for cereskey in ${cereskeys[@]}
    do
-      for (( i=1 ; i<=$numfile ; i++ ))
+      query="SELECT fFileNumber FROM CorsikaInfo WHERE fRunNumber="$drun
+      files=`sendquery`
+      for file in ${files[@]}
       do
-         query="INSERT CeresInfo SET fSequenceNumber="$drun", fRunNumber="$drun", fFileNumber="$i", fCeresSetupKEY="$cereskey", fRunTypeKEY=2"
+         query="INSERT CeresInfo SET fSequenceNumber="$drun", fRunNumber="$drun", fFileNumber="$file", fCeresSetupKEY="$cereskey", fRunTypeKEY=2"
          sendquery2 
       done