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

Timestamp:

Jul 24, 2014, 10:12:36 AM (12 years ago)

Author:

heather

Message:

current version

File:

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

trunk/ippToPsps/jython/stackbatch.py

@@ -1 @@
-#!/usr/bin/env jython
+q#!/usr/bin/env jython
 
 import os.path
@@ -215 +215 @@
        self.scratchDb.dropTable("StackObject")
        self.logger.infoPair("dropping table:","StackModelFit")
-              
+       self.scratchDb.dropTable("SkinnyObject")
        self.scratchDb.dropTable("StackModelFit")
        self.logger.infoPair("dropping table:","StackApFlx")
@@ -785 +785 @@
         self.logger.infoPair("Deleting", "entries with StackObject.objID = 0")
         # response = raw_input("deleted objID is 0 ")
-        
+    '''
+    Populates the SkinnyObject table
+    '''
+    def populateSkinnyObject(self):
+
+        self.logger.infoPair("Procesing table", "SkinnyObject")
+
+        sql = "INSERT INTO SkinnyObject (\
+               objID \
+               ,ippObjID \
+               ,projectionCellID \
+               ) \
+               SELECT \
+               DISTINCT objID \
+               ,ippObjID \
+               ,projectionCellID \
+               FROM StackDetection"
+        self.scratchDb.execute(sql)
+
+        self.scratchDb.updateAllRows("SkinnyObject", "surveyID", str(self.surveyID))
+        self.scratchDb.updateAllRows("SkinnyObject", "dataRelease", str(self.skychunk.dataRelease))
+         
 
     '''
@@ -1307 +1328 @@
 
         ##if self.totalDetections < 1: 
+        #self.logger.infoPair("populating","SkinnyObject") 
+        self.populateSkinnyObject()
 
             ##self.logger.error("No detections to publish")
@@ -1314 +1337 @@
         self.tablesToExport.append("StackModelFit")
         self.tablesToExport.append("StackApFlx")
-
+        self.tablesToExport.append("SkinnyObject")
         self.logger.infoPair("finishing","populatePspsTables"); 
         return True