Changeset 37754 for trunk/ippToPsps/jython/batch.py

Timestamp:

Dec 17, 2014, 1:24:02 PM (12 years ago)

Author:

heather

Message:

final on diff batches - they work, all columns I can fill are properly filled

File:

• trunk/ippToPsps/jython/batch.py (modified) (1 diff)

trunk/ippToPsps/jython/batch.py

@@ -382 +382 @@
         self.logger.infoPair("Min objID", "%ld" % self.minObjID)
         self.logger.infoPair("Max objID", "%ld" % self.maxObjID)
+
+
+    '''                                                                                            
+    Sets min and max obj ID using the provided table, or list of tables                            
+    '''
+    def setMinMaxDiffObjID(self, tables):
+        first = True
+        self.totalDetections = 0
+        for table in tables:
+            sql = "SELECT MIN(diffObjID), MAX(diffObjID), COUNT(diffObjID) FROM " + table
+            rs = self.scratchDb.executeQuery(sql)
+            rs.first()
+            self.totalDetections = self.totalDetections + rs.getLong(3)
+            if first:
+                self.minObjID = rs.getLong(1)
+                self.maxObjID = rs.getLong(2)
+            else:
+                if rs.getLong(1) < self.minObjID: self.minObjID = rs.getLong(1)
+                if rs.getLong(2) > self.maxObjID: self.maxObjID = rs.getLong(2)
+            first = False
+            rs.close()
+        self.ippToPspsDb.updateDetectionStats(self.batchID, self.minObjID, self.maxObjID, self.totalDetections)
+        self.logger.infoPair("Total detections", "%ld" % self.totalDetections)
+        self.logger.infoPair("Min objID", "%ld" % self.minObjID)
+        self.logger.infoPair("Max objID", "%ld" % self.maxObjID)
+
+
 
     '''