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

Timestamp:

09/01/21 07:56:42 (3 years ago)

Author:

maslowski

Message:

Added better error handeling and tracking in the databas.

File:

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

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

@@ -89 +89 @@
 fi
 
+function UpdateStatus()
+{
+        local tel="${1}"
+        local night="${2}"
+        local runid="${3}"
+        local suf="${4}"
+        local stat="${5}"
+
+        if [ $suf = I ]
+        then
+                local col=star
+        elif [ $suf = Y ]
+        then
+                local col=callisto
+        fi
+
+        mysql --defaults-file=${CRED} \
+                --compress \
+                -e "UPDATE DataOnDisk \
+                SET DataOnDisk.${col} = ${stat} \
+                WHERE DataOnDisk.Telescope = ${tel} \
+                AND DataOnDisk.NIGHT = ${night} \
+                AND DataOnDisk.RUNID = ${runid};"
+}
+
+function PropagateStatus()
+{
+        local tel="${1}"
+        local night="${2}"
+        local suf="${3}"
+
+        if [ $suf = I ]
+        then
+                local col=star
+        elif [ $suf = Y ]
+        then
+                local col=callisto
+        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;"
+
+        mysql --defaults-file=${CRED} \
+                --compress \
+                -e "UPDATE DataOnDisk \
+                SET DataOnDisk.${col} = 3 \
+                WHERE DataOnDisk.Telescope = ${tel} \
+                AND DataOnDisk.NIGHT = ${night} \
+                AND DataOnDisk.calibration = 0 \
+                AND DataOnDisk.${col} IS NULL;"
+}
+
 # Get all runs that can (and should) be calibrated
 # Pipe the output to mysql and read the
@@ -95 +152 @@
 "\
 SELECT 
-        NIGHT, RUNID
+        Calibration.NIGHT,
+        Calibration.RUNID
 FROM 
         Calibration
+INNER JOIN
+        DataOnDisk
+ON
+        DataOnDisk.Telescope = Calibration.Telescope
+AND
+        DataOnDisk.NIGHT = Calibration.NIGHT
+AND
+        DataOnDisk.RUNID = Calibration.RUNID
 WHERE
-        Telescope = ${TEL}
+        Calibration.Telescope = ${TEL}
+AND     
+        Calibration.NIGHT = ${NIGHT}
 AND
-        NIGHT = ${NIGHT}
+        DataOnDisk.calibration = 0
 ORDER BY
-        NIGHT, RUNID\
-
+        Calibration.NIGHT, Calibration.RUNID;\
 "\
  |  mysql \
@@ -139 +206 @@
 
                 echo RC=${PIPESTATUS[0]} >> "${DIR}"/${PREFIX}-root2sql.log
+
+                UpdateStatus ${TEL} ${NIGHT} ${RUNID} ${SUFFIX} 0
+
         else
                 echo Skipped.
+                UpdateStatus ${TEL} ${NIGHT} ${RUNID} ${SUFFIX} 2
         fi
 
 done
+
+PropagateStatus ${TEL} ${NIGHT} ${SUFFIX}