Changeset 33777 for trunk

Timestamp:

Apr 12, 2012, 4:41:25 PM (14 years ago)

Author:

rhenders

Message:

now setting to NULL all MeanMagErr > 0.5

File:

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

trunk/ippToPsps/jython/objectbatch.py

@@ -105 +105 @@
         filterCount = len(filters)
 
-        self.logger.infoPair("Available filters", filters)
+        self.logger.infoPair("Available filters in Photcodes", filters)
 
         # the 'code' now defines the order in the cps file that the mags are listed for a given filter
+        self.logger.infoPair("Adding magnitudes from", "cps table")
         for filter in filters:
 
@@ -123 +124 @@
             self.scratchDb.execute(sql)
 
+        # now set to null all MeanMagErr values > 0.5 (cut set by Gene, 2012-04-12)
+        cut = 0.5
+        self.logger.infoPair("Setting to NULL all MeanMagErr value >", "%f" % cut)
+        for filter in filters:
+
+            sql = "UPDATE Object \
+                   SET " + filter[1] + "MeanMagErr = null \
+                   WHERE " + filter[1] + "MeanMagErr > " + str(cut)
+            self.scratchDb.execute(sql)
+
     '''
     Inserts colors
@@ -128 +139 @@
     def updateColors(self):
 
+        self.logger.infoPair("Calculating", "colors")
         sql = "UPDATE Object \
                SET \
@@ -189 +201 @@
             return False
 
-
         # add row count columns so we can perform joins to get colors
         self.logger.infoPair("Adding 'row' columns to", "Object and cps tables")
@@ -195 +206 @@
         self.scratchDb.addRowCountColumn(cpsTableName, "row")
 
-        self.logger.infoPair("Adding magnitudes from", "cps table")
         self.insertMags(cpsTableName)
 
-        self.logger.infoPair("Calculating", "colors")
         self.updateColors()