Changeset 34165 for trunk

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.

Location:

trunk/ippToPsps/jython

Files:

• plot.py (modified) (1 diff)
• stackbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/plot.py

@@ -40 +40 @@
             OUTPUTFILE = self.config.name + "_" + batchType + "_" + timestamp + ".png"
 
-        f = os.popen('gnuplot', 'w')
+        f = os.popen('/home/panstarrs/ipp/local/bin/gnuplot', 'w')
             
         if 0:

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")