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

Timestamp:

Aug 11, 2014, 7:06:25 AM (12 years ago)

Author:

eugene

Message:

changes to match schema mods

File:

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

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

@@ -324 +324 @@
 
         sqlLine.group("objID",           "EXT_ID") 
-        # 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("randomID",        "FLOOR(RAND()*9223372036854775807)") # XXX where does this number come from??
         sqlLine.group("batchID",         "'" + str(self.batchID) + "'")
-        sqlLine.group("dvoRegionID",     "DVO_REGION") # XXX add to dvopsps output for cpt
+        sqlLine.group("dvoRegionID",     "CAT_ID") 
         sqlLine.group("dataRelease",     "'" + str(self.skychunk.dataRelease) + "'")
         sqlLine.group("objInfoFlag",     "FLAGS") 
@@ -343 +341 @@
         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("posMeanChisq",    "CHISQ_POS")
         sqlLine.group("nStackObjectRows", "'0'") # XXX I need to add / define this in dvopsps
         sqlLine.group("nStackDetections", "'0'")