Changeset 37577 for trunk/ippToPsps/jython/stackbatch.py

Timestamp:

Nov 10, 2014, 3:00:51 PM (12 years ago)

Author:

heather

Message:

many fixes, mostly fixing bugs pointed out by pspswg, including missing
objects, random numbers, ext_nsigma

missing objects - (things which have detections and stacks) - these are caused
when we cull objects outside the dvo range. Gene says there is a buffer of
about .09 arcmins and suggests we cull things outside of .2 arcmins. This has
been implemented

random ids are not so random due to not setting a seed for the loaders. Random
numbers for a batch are seeded with the batch_ID

requests for sgSep / ExtNSigma as we had back in the good ol' days. This has
been added back for stack

File:

• trunk/ippToPsps/jython/stackbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/stackbatch.py

@@ -942 +942 @@
 
     def generateRandomIDs(self):
-        sql = "UPDATE StackObjectThin set randomStackObjID = FLOOR(RAND()*9223372036854775807)";
+        sql = "UPDATE StackObjectThin set randomStackObjID = FLOOR(RAND("+str(self.batchID)+")*9223372036854775807)";
         try: self.scratchDb.execute(sql)
         except: