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

Timestamp:

Jun 5, 2015, 5:09:21 PM (11 years ago)

Author:

heather

Message:

schema 21 / sas 39 ipptopsps - random now float/double, forced object column names changed to be less confusing

File:

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

trunk/ippToPsps/jython/forcedwarpbatch.py

@@ -340 +340 @@
         sqlLine.group("forcedWarpID",            str(forcedWarpID))
         print " got here too, num", num
-        sqlLine.group("randomWarpID",     "FLOOR(RAND("+str(self.batchID)+")*9223372036854775807)") 
+        sqlLine.group("randomWarpID",     "RAND("+str(self.batchID)+")") 
         print "here"  
         sqlLine.group("filterID",        str(self.filterID[num]))
@@ -676 +676 @@
 
     def generateRandomIDs(self,forcedWarpID):
-        sql = "UPDATE ForcedWarpMeasurement_"+forcedWarpID+" set randomWarpID = FLOOR(RAND("+str(self.batchID)+")*9223372036854775807)"
+        sql = "UPDATE ForcedWarpMeasurement_"+forcedWarpID+" set randomWarpID = RAND("+str(self.batchID)+")"
         try: 
             self.scratchDb.execute(sql)