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

Timestamp:

Dec 18, 2014, 6:00:15 PM (12 years ago)

Author:

heather

Message:

st/ob/p2/df/do batches all work but have minimal problems in teh columns

File:

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

trunk/ippToPsps/jython/detectionbatch.py

@@ -610 +610 @@
     '''
 
-    def updatePspsUniqueIDs(self,table):
+    def updatePspsUniqueIDs(self,table, ota):
         sql = "UPDATE "+table+" join (select @r:=@r+1 rownum, objID from \
         (select @r:=0) r, "+table+" t) as foo using (objID) set \
-        uniquePspsP2id = ((" +str(self.batchID)+ "*1000000000 ) + rownum)"
+        uniquePspsP2id = ((" +str(self.batchID)+ "*1000000000 ) \
+        + (" +str(ota) + "*10000000  )+rownum)"
         try: self.scratchDb.execute(sql)
         except:
             self.logger.errorPair('failed sql',sql)
-            return
+            raise
         
     '''
@@ -651 +652 @@
         #self.logger.info("deleted nulls")
         self.logger.info("add psps unique p2 ids")
-        self.updatePspsUniqueIDs("Detection_" + chipname, self.imageIDs[chipname])
+        ota = x*10+y
+        self.updatePspsUniqueIDs("Detection_" + chipname, ota)
         self.updateImageID("Detection_" + chipname, x, y)
         #self.logger.info("updateImageId")