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

Timestamp:

Nov 12, 2014, 2:58:40 PM (12 years ago)

Author:

heather

Message:

cleaning up the schema, and adding uniquePsps()id to all tables. Populated in
all except FO/FW/DF/DO (those are still in progress)

File:

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

trunk/ippToPsps/jython/objectbatch.py

@@ -87 +87 @@
         return True
 
+    '''
+    Updates table and generates pspsuniqueids
+    '''
+    
+    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 \
+        uniquePspsP2id = ((" +str(self.batchID) "*1000000000 ) + rownum)";
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.errorPair('failed sql',sql)
+            return
+        
+
+    
     '''
     Applies indexes to the IPP tables
@@ -429 +444 @@
         ##self.dvoObjects.purgeRegion(self.region)
 
+        self.updatePspsUniqueIDs()
+        
         self.setMinMaxObjID(["ObjectThin"])
 
@@ -439 +456 @@
         cptTableName = self.scratchDb.getDbFriendlyTableName(self.region + ".cpt")
         cpsTableName = self.scratchDb.getDbFriendlyTableName(self.region + ".cps")
-        self.logger.infoPair("Populating MeanObject from ", "ObjectThin")
-
-        sql = "INSERT INTO MeanObject ( objID ) SELECT objID FROM ObjectThin"
+        self.logger.infoPair("Populating MeanObject.objid and pspsUniqueOBid from ", "ObjectThin")
+
+        sql = "INSERT INTO MeanObject ( objID, pspsUniqueOBid ) SELECT objID, pspsUniqueOBid FROM ObjectThin"
         try:
             self.scratchDb.execute(sql)
@@ -450 +467 @@
         self.logger.infoPair("Adding 'row' columns to", "MeanObject table")
         self.scratchDb.addRowCountColumn("MeanObject", "row")
- 
+
+
+
+        
 
         ##self.scratchDb.addRowCountColumn(cpsTableName, "row")