Changeset 20104 for trunk/Mars/hawc/processing/DiskToDB/write-calibration-query.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/write-calibration-query.sh (modified) (2 diffs)

trunk/Mars/hawc/processing/DiskToDB/write-calibration-query.sh

@@ -97 +97 @@
 UPDATE DataOnDisk 
 SET DataOnDisk.calibration = 6
-WHERE DataOnDisk.header != 0;
+WHERE DataOnDisk.header != 0
+AND NIGHT=${NIGHT}
+AND Telescope=${TEL};
 
 CREATE TEMPORARY TABLE Calibration_tmp
@@ -205 +207 @@
 UPDATE DataOnDisk 
 SET DataOnDisk.calibration = 0
-WHERE DataOnDisk.header = 0;
+WHERE DataOnDisk.header = 0
+AND NIGHT=${NIGHT}
+AND Telescope=${TEL};
 
 -- Set Status to 2 if there was no drs file with step = 1 in the NIGHT
 UPDATE DataOnDisk
 SET DataOnDisk.calibration = 2
-WHERE EXISTS(SELECT * FROM Calibration WHERE NIGHT=${NIGHT}) = 0;
+WHERE EXISTS(
+        SELECT * FROM Calibration
+        WHERE NIGHT=${NIGHT}
+        AND Telescope=${TEL}
+        ) = 0;
 "\ >> ${OUTPUT}