Changeset 34165 for trunk/ippToPsps/jython/stackbatch.py

Timestamp:

Jul 13, 2012, 6:34:51 PM (14 years ago)

Author:

heather

Message:

stackbatch should drop things which exist in cmf but not dvo.

File:

• trunk/ippToPsps/jython/stackbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/stackbatch.py

@@ -397 +397 @@
 
         self.scratchDb.execute(sql)
+        #it is possible to drop some detections from dvo (that are present in the cmf). when that happens we get a 0 for objid
+        #we drop those...
+        sql="DELETE FROM StackDetection where objID = 0"
+        self.scratchDb.execute(sql)
+        self.logger.infoPair("Deleting", "entries with StackDetection.objID = 0")
 
         self.scratchDb.updateAllRows("StackDetection", "surveyID", str(self.surveyID))
@@ -421 +426 @@
         self.scratchDb.reportAndDeleteRowsWithNULLS("StackDetection", "instFlux")
         self.scratchDb.reportAndDeleteRowsWithNULLS("StackDetection", "objID")
+        sql="DELETE FROM StackDetection where objID = 0"
+        self.scratchDb.execute(sql)
+        self.logger.infoPair("Deleting", "entries with StackDetection.objID = 0")