Changeset 37433 for trunk/ippToPsps

Timestamp:

Sep 25, 2014, 3:00:58 PM (12 years ago)

Author:

heather

Message:

stack fix

Location:

trunk/ippToPsps/jython

Files:

• ippjython (modified) (1 diff)
• stackbatch.py (modified) (3 diffs)

trunk/ippToPsps/jython/ippjython

@@ -27 +27 @@
 if (! -r $JYTHON) then
   echo "jython jar file not found, check jython installation"
+  echo $JYTHON  
   exit 2
 endif

trunk/ippToPsps/jython/stackbatch.py

@@ -284 +284 @@
         self.selectDvoObjIDs()
 
+        self.generateRandomIDs()
+
         # add indexes StackObjectThin
         self.scratchDb.createIndex("StackObjectThin", "objID")
@@ -932 +934 @@
         return True
 
+    def generateRandomIDs(self):
+        sql = "UPDATE StackObjectThin set randomStackObjID = FLOOR(RAND()*9223372036854775807)";
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.errorPair('failed sql',sql)
+            return
+
+
     '''
     select objID (psps object ID) from dvo restricted to this set of imageIDs. also insert
@@ -951 +961 @@
         sqlLine.group("skyCellID",        "'" + str(self.skycellID) + "'")
         sqlLine.group("dataRelease",      "'" + str(self.skychunk.dataRelease) + "'")
-        sqlLine.group("randomStackObjID", "FLOOR(RAND()*9223372036854775807)")
+   #     sqlLine.group("randomStackObjID", "FLOOR(RAND()*9223372036854775807)")
 
         whereClause = " WHERE ("