Changeset 35053

Timestamp:

Jan 25, 2013, 10:13:37 AM (13 years ago)

Author:

eugene

Message:

add imageID to the StackDetectionCalib update statement

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/stackbatch.py (modified) (2 diffs)

branches/eam_branches/ipp-20121219/ippToPsps/jython/stackbatch.py

@@ -737 +737 @@
         self.scratchDb.execute(sql)
 
+        imageID = self.scratchDb.getImageIDFromExternID(self.header['IMAGEID'])
+        self.logger.infoPair("obtained","imageID")
+
         # insert calibration information from dvoDetections into the Table
         sql = "UPDATE " + tableName + " AS a, "  + self.scratchDb.dvoDetectionTable + " AS b \
@@ -747 +750 @@
             a.expTime = b.expTime, \
             a.airMass = b.airMass   \
-            WHERE a.stackDetectID = b.detectID"
+            WHERE a.stackDetectID = b.detectID \
+            AND b.imageID = " + str(imageID)
         self.scratchDb.execute(sql)
         self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.config.dataRelease))