Changeset 37917 for trunk/ippToPsps/jython/diffbatch.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/diffbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/diffbatch.py

@@ -327 +327 @@
         self.logger.infoPair("need to cull"," nulls objid")
         results= self.scratchDb.reportAndDeleteRowsWithNULLS("DiffDetection", "diffObjID")
+        self.logger.infoPair("Adding 'row' columns to", "DiffDetection tables")
+        # diff has a primary key, so use this instead
+        self.scratchDb.addRowCountColumnNoKey("DiffDetection", "row")
         self.logger.infoPair("adding","uniquePSPSDFid")
         self.updatePspsUniqueIDs("DiffDetection")
+        self.logger.infoPair("Dropping row column from", "DiffDetection table")
+        self.scratchDb.dropColumn("DiffDetection", "row")
+ 
 
     '''
@@ -424 +430 @@
 
     def updatePspsUniqueIDs(self,table):
-        sql = "UPDATE "+table+" join (select @r:=@r+1 rownum, diffobjID from \
-        (select @r:=0) r, "+table+" t) as foo using (diffobjID) set \
-        uniquePspsDFid = ((" +str(self.batchID)+ "*1000000000 ) + rownum)"
+        #sql = "UPDATE "+table+" join (select @r:=@r+1 rownum, diffobjID from \
+        #(select @r:=0) r, "+table+" t) as foo using (diffobjID) set \
+        #uniquePspsDFid = ((" +str(self.batchID)+ "*1000000000 ) + rownum)"
+        sql = "UPDATE DiffDetection set uniquePspsDFid = (("+str(self.batchID)+"*1000000000 ) + row)"
         try: self.scratchDb.execute(sql)
         except: