Changeset 20104 for trunk/Mars/hawc/processing/DiskToDB/run-root2sql2.sh

Timestamp:

09/05/21 07:13:17 (3 years ago)

Author:

maslowski

Message:

Added Telescope as command line parameter. And fixed some bugs.

File:

• trunk/Mars/hawc/processing/DiskToDB/run-root2sql2.sh (modified) (2 diffs)

trunk/Mars/hawc/processing/DiskToDB/run-root2sql2.sh

@@ -28 +28 @@
 
 # Path to the executable
-readonly ROOT2SQL="/home/frankm/Dateien/FACT++/build/root2sql"
+readonly ROOT2SQL="/home/hawc/Desktop/FACT++/root2sql"
 readonly PROGRAM=${0}
 
@@ -128 +128 @@
         fi
 
-        mysql --defaults-file=${CRED} \
-                --compress \
-                -e "UPDATE DataOnDisk \
-                SET DataOnDisk.${col} = 6 \
-                WHERE DataOnDisk.Telescope = ${tel} \
-                AND DataOnDisk.NIGHT = ${night} \
-                AND DataOnDisk.calibration != 0;"
-
+        # Set col to 3 if the file is a DRS run
         mysql --defaults-file=${CRED} \
                 --compress \