Changeset 38090 for trunk/ippToPsps/jython/forcedobjectbatch.py

Timestamp:

Apr 6, 2015, 4:38:40 PM (11 years ago)

Author:

heather

Message:

shcema20 first

File:

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

trunk/ippToPsps/jython/forcedobjectbatch.py

@@ -328 +328 @@
         sqlLine.group("ippObjID",        "OBJ_ID + (CAT_ID << 32)") # NOTE: shift by 32 bits exactly
         sqlLine.group("batchID",         "'" + str(self.batchID) + "'")
+        sqlLine.group("randomForcedObjID",        "FLOOR(RAND("+str(self.batchID)+")*9223372036854775807)")
         sqlLine.group("nDetections",      "'0'")
         sql = sqlLine.makeRaw(") SELECT ", " FROM " + cptTableName)
@@ -354 +355 @@
         sqlLine.group("objID",           "objID")
         sqlLine.group("uniquePspsFOid","uniquePspsFOid")
+        sqlLine.group("randomForcedObjID","randomForcedObjID")
         sqlLine.group("ippObjID",        "ippObjID")
         sqlLine.group("batchID",         "batchID")
         sqlLine.group("nDetections",      "nDetections")
-        sqlLine.group("gStackID",      "gStackID")
-        sqlLine.group("rStackID",      "rStackID")
-        sqlLine.group("iStackID",      "iStackID")
-        sqlLine.group("zStackID",      "zStackID")
-        sqlLine.group("yStackID",      "yStackID")
 
         sql = sqlLine.makeRaw(") SELECT ", " FROM ForcedMeanObject")