Changeset 34217 for trunk/ippToPsps/jython/objectbatch.py

Timestamp:

Jul 27, 2012, 9:58:57 PM (14 years ago)

Author:

heather

Message:

schema change object batches

File:

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

trunk/ippToPsps/jython/objectbatch.py

@@ -118 +118 @@
                    SET \
                    n" + filter[1] + " = NCODE \
-                   ," + filter[1] + "MeanMag = MAG \
-                   ," + filter[1] + "MeanFlux = 3631 * POW(10.0, (-0.4*MAG)) \
-                   ," + filter[1] + "MeanMagErr = MAG_ERR \
-                   ," + filter[1] + "Min = MAG_20/1000 \
-                   ," + filter[1] + "Max = MAG_80/1000 \
+                   ," + filter[1] + "MeanPSFMag = MAG \
+                   ," + filter[1] + "MeanPSFMagErr = MAG_ERR \
+                   ," + filter[1] + "20pct = MAG_20/1000 \
+                   ," + filter[1] + "80pct = MAG_80/1000 \
                    "
             
@@ -133 +132 @@
 
             sql = "UPDATE Object \
-                   SET " + filter[1] + "MeanMagErr = null \
-                   WHERE " + filter[1] + "MeanMagErr > " + str(cut)
+                   SET " + filter[1] + "MeanPSFMagErr = null \
+                   WHERE " + filter[1] + "MeanPSFMagErr > " + str(cut)
             self.scratchDb.execute(sql)
 
@@ -211 +210 @@
         self.insertMags(cpsTableName)
 
-        self.updateColors()
+#don't do this as we removed those columns.. 
+#        self.updateColors()
 
         #objects can have out of range ra dec in dvo - need to find and kill them at the end