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

Timestamp:

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

Author:

heather

Message:

current version

File:

• trunk/ippToPsps/jython/detectionbatch.py (modified) (3 diffs)

trunk/ippToPsps/jython/detectionbatch.py

@@ -547 +547 @@
 
         self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.skychunk.dataRelease))
+    '''
+    Populates the SkinnyObject table for this OTA
+    '''
+    def populateSkinnyObjectTable(self, ota):
+
+        tableName = "SkinnyObject_" + ota
+        
+        # drop then re-create table
+        self.scratchDb.dropTable(tableName)
+        sql = "CREATE TABLE " + tableName + " LIKE SkinnyObject"
+        try: self.scratchDb.execute(sql)
+        except: pass
+
+        # insert all detections into table
+        sql = "INSERT INTO " + tableName + " ( \
+               objID \
+               ,ippObjID \
+               ,surveyID \
+               ) \
+               SELECT \
+               objID \
+               ,ippObjID \
+               ,surveyID \
+               FROM Detection_" + ota
+        self.scratchDb.execute(sql)
+
+        self.scratchDb.updateAllRows(tableName, "dataRelease", str(self.skychunk.dataRelease))
+
+
 
     '''
@@ -854 +883 @@
         
         #self.logger.info("updated imagedata")
-        
+        self.populateSkinnyObjectTable(chipname)
+        self.logger.info("updated skinnyobject")
+ 
         self.populateDetectionCalibTable(chipname)
         #self.logger.info("updated detectioncalibtable")
@@ -865 +896 @@
         self.logger.info("export Detection")
 
-        
+        self.tablesToExport.append("SkinnyObject_" + chipname)
+        self.logger.info("export Skinny")
+
+
         tables.append("Detection_" + chipname)
         self.logger.info("updated detectioncalibtable")