Changeset 34631 for trunk

Timestamp:

Oct 31, 2012, 12:50:01 PM (14 years ago)

Author:

bills

Message:

rename column dec_ to dec

Location:

trunk/ippToPsps/jython

Files:

• detectionbatch.py (modified) (1 diff)
• stackbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/detectionbatch.py

@@ -648 +648 @@
             if not self.getIDsFromDVO(): return False
 
+        # dec is reserved in MySQL, so STILTS replaces if with dec_, which is not the name of 
+        # the column in PSPS
+        self.scratchDb.execute("ALTER TABLE DetectionCalib CHANGE dec_ `dec` double")
+
+
+
         return True
 

trunk/ippToPsps/jython/stackbatch.py

@@ -664 +664 @@
         self.scratchDb.createIndex("StackModelFit", "ippDetectID")
 
+        # dec is reserved in MySQL, so STILTS replaces if with dec_, which is not the name of 
+        # the column in PSPS
+        self.scratchDb.execute("ALTER TABLE StackDetectionCalib CHANGE dec_ `dec` double")
+
+
+
         return True