Changeset 37873 for trunk/ippToPsps/jython/objectbatch.py

Timestamp:

Jan 23, 2015, 2:28:11 PM (11 years ago)

Author:

heather

Message:

small necessary changes

File:

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

trunk/ippToPsps/jython/objectbatch.py

@@ -92 +92 @@
     
     def updatePspsUniqueIDs(self):
-        sql = "UPDATE ObjectThin join (select @r:=@r+1 rownum, objID from \
-        (select @r:=0) r, ObjectThin t) as foo using (objID) set \
-        uniquePspsOBid = ((" +str(self.batchID) +"*1000000000 ) + rownum)";
+ #       sql = "UPDATE ObjectThin join (select @r:=@r+1 rownum, objID from \
+ #       (select @r:=0) r, ObjectThin t) as foo using (objID) set \
+ #       uniquePspsOBid = ((" +str(self.batchID) +"*1000000000 ) + rownum)";
+
+        sql = "UPDATE ObjectThin set uniquePspsOBid = (("+str(self.batchID)+"*1000000000 ) + row)"
         try: self.scratchDb.execute(sql)
         except:
@@ -437 +439 @@
             return False
 
+        ##Don't do this till after MeanObject
+        ##self.dvoObjects.purgeRegion(self.region)
+        self.logger.infoPair("updatePspsUniqueIDs","start")
+        self.updatePspsUniqueIDs()
+        self.logger.infoPair("updatePspsUniqueIDs","end")
         self.logger.infoPair("Dropping row column from", "ObjectThin table")
         self.scratchDb.dropColumn("ObjectThin", "row")
         ##self.logger.infoPair("Purging from scratch Db", self.region + " region")
-
+        self.logger.infoPair("Dropped row column", "objectThin")
         ##Don't do this till after MeanObject
-        ##self.dvoObjects.purgeRegion(self.region)
-
-        self.updatePspsUniqueIDs()
-        
+
         self.setMinMaxObjID(["ObjectThin"])