Changeset 37917 for trunk/ippToPsps/jython/forcedwarpbatch.py

Timestamp:

Feb 20, 2015, 1:19:35 PM (11 years ago)

Author:

heather

Message:

current state of ipptopsps / sas37 - ob/p2/st/df work

File:

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

trunk/ippToPsps/jython/forcedwarpbatch.py

@@ -224 +224 @@
         self.generateRandomIDs()
 
+        self.logger.infoPair("Adding 'row' columns to", "ForcedWarpMeasurement")
+        self.scratchDb.addRowCountColumn("ForcedWarpMeasurement", "row")
+        self.logger.infoPair("Adding unique ids to", "ForcedWarpMeasurement")
         self.generateUniquePspsIDs()
+        self.logger.infoPair("Dropping row column from", "ForcedWarpMeasurement table")
+        self.scratchDb.dropColumn("ForcedWarpMeasurement", "row")
            
         # add indexes ForcedWarpMeasurement
@@ -342 +347 @@
 
     def generatePspsUniqueIDs(self):
-        sql = "UPDATE ForcedWarpMeasurement join (select @r:=@r+1 rownum, objID from \
-        (select @r:=0) r, ForcedWarpMeasurement t) as foo using (objID) set \
-        uniquePspsFWid = ((" +str(self.batchID)+ "*1000000000 ) + rownum)"
+#        sql = "UPDATE ForcedWarpMeasurement join (select @r:=@r+1 rownum, objID from \
+#        (select @r:=0) r, ForcedWarpMeasurement t) as foo using (objID) set \
+#        uniquePspsFWid = ((" +str(self.batchID)+ "*1000000000 ) + rownum)"
+        sql = "UPDATE ForcedWarpMeasurement set uniquePspsFWid = (("+str(self.batchID)+"*1000000000 ) + row)"
+
         try: self.scratchDb.execute(sql)
         except: