Changeset 33763

Timestamp:

Apr 11, 2012, 1:36:57 PM (14 years ago)

Author:

rhenders

Message:

using default of 0 for varFlag as stupid PSPS 'null' value of -999 does not fit in a byte

File:

• trunk/ippToPsps/jython/objectbatch.py (modified) (3 diffs)

trunk/ippToPsps/jython/objectbatch.py

@@ -81 +81 @@
         self.scratchDb.makeColumnUnique("Object", "objID")
 
-        # dec is reserved in MySQL, so STILTS replaces if with dec_, which PSPS doesn't like. so, force it back again
+        # dec is reserved in MySQL, so STILTS replaces if with dec_, which PSPS doesn't like. so, force it back again using ``
         self.scratchDb.execute("ALTER TABLE Object CHANGE dec_ `dec` double")
 
@@ -162 +162 @@
         self.logger.infoPair("Populating", "ObjectCalColor")
         self.logger.infoPair("Inserting objects from", "cpt file")
+
+        # note `` around dec here, as this is a reserved word in MySQL
         sql = "INSERT IGNORE INTO Object (\
                objID \
                ,ippObjID \
                ,objInfoFlag \
+               ,varFlag \
                ,surveyID \
                ,ra \
@@ -178 +181 @@
                ,CAT_ID*1000000000 + OBJ_ID \
                ,FLAGS \
+               ,0 \
                ," + str(self.surveyID) + " \
                ,RA \