Changeset 37204 for branches/eam_branches/ipp-20140717/ippToPsps/jython/objectbatch.py

Timestamp:

Aug 7, 2014, 2:27:23 PM (12 years ago)

Author:

eugene

Message:

only select Chip detections for simtest camera; only use XYnn for gpc1; fix insert for objects

File:

• branches/eam_branches/ipp-20140717/ippToPsps/jython/objectbatch.py (modified) (2 diffs)

branches/eam_branches/ipp-20140717/ippToPsps/jython/objectbatch.py

@@ -326 +326 @@
         # sqlLine.group("gcobjID",       "EXT_ID_GC")  # drop this one?
         sqlLine.group("ippObjID",        "OBJ_ID + (CAT_ID << 32)") # NOTE: shift by 32 bits exactly
-        sqlLine.group("surveyID",        str(self.surveyID))
-        sqlLine.group("skyCellID",       "-999") # XXX This does not make sense
+        sqlLine.group("surveyID",        "'" + str(self.surveyID) + "'")
+        sqlLine.group("skyCellID",       "'-999'") # XXX This does not make sense
         sqlLine.group("randomID",        "FLOOR(RAND()*9223372036854775807)") # XXX where does this number come from??
-        sqlLine.group("batchID",         str(self.batchID))
+        sqlLine.group("batchID",         "'" + str(self.batchID) + "'")
         sqlLine.group("dvoRegionID",     "DVO_REGION") # XXX add to dvopsps output for cpt
-        sqlLine.group("dataRelease",     str(self.skychunk.dataRelease))
+        sqlLine.group("dataRelease",     "'" + str(self.skychunk.dataRelease) + "'")
         sqlLine.group("objInfoFlag",     "FLAGS") 
         sqlLine.group("qualityFlag",     "FLAGS >> 24 & 0xFF")
-        sqlLine.group("consistencyFlag", "0") 
+        sqlLine.group("consistencyFlag", "'0'") 
         sqlLine.group("raStack",         "RA_STK")
         sqlLine.group("decStack",        "DEC_STK") 
@@ -343 +343 @@
         sqlLine.group("raMeanErr",       "RA_ERR")
         sqlLine.group("decMeanErr",      "DEC_ERR")
-        sqlLine.group("raMeanStd",       "-999") # XXX I do not calculate this, use chisq?
-        sqlLine.group("decMeanStd",      "-999")
-        sqlLine.group("nStackObjectRows", "0") # XXX I need to add / define this in dvopsps
-        sqlLine.group("nStackDetections", "0")
-        sqlLine.group("nDetections",      "0")
-        sql = sqlLine.make(") SELECT ", " FROM " + cptTableName)
+        sqlLine.group("raMeanStd",       "'-999'") # XXX I do not calculate this, use chisq?
+        sqlLine.group("decMeanStd",      "'-999'")
+        sqlLine.group("nStackObjectRows", "'0'") # XXX I need to add / define this in dvopsps
+        sqlLine.group("nStackDetections", "'0'")
+        sqlLine.group("nDetections",      "'0'")
+        sql = sqlLine.makeRaw(") SELECT ", " FROM " + cptTableName)
 
         try: