Changeset 39133

Timestamp:

Nov 13, 2015, 11:05:41 AM (11 years ago)

Author:

eugene

Message:

do not modify negative fluxes to be 1e20

File:

• trunk/ippToPsps/jython/detectionbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/detectionbatch.py

@@ -553 +553 @@
         # cause problems for sql queries which work in mags as SQL cannot do
         # something like (f < 0.0) ? -999 : -2.5*log10(f)
-        # as a result, the negative fluxes here result in floating point errors
-
-        # XXX EAM 20140724 : Is this still a problem?
-        # XXX EAM 20150925 : do this after inst flux -> Jy conversion?
-
-        sql = "UPDATE " + pspsTableName + " SET psfFlux = 1e20 WHERE psfFlux <= 0.0"
-        try: self.scratchDb.execute(sql)
-        except:
-            self.logger.infoPair("failed sql",sql)
-            raise
-        sql = "UPDATE " + pspsTableName + " SET apFlux = 1e20 WHERE apFlux <= 0.0"
-        try: self.scratchDb.execute(sql)
-        except:
-            self.logger.infoPair("failed sql",sql)
-            raise
-        sql = "UPDATE " + pspsTableName + " SET kronFlux = 1e20 WHERE kronFlux <= 0.0"
-        try: self.scratchDb.execute(sql)
-        except:
-            self.logger.infoPair("failed sql",sql)
-            raise
+
+        # users need to use something like mag = -2.5*log10(abs(f)) and save a flag value (f > 0 as posDetection)
+
         # we don't delete these anymore
         results['NULLINSTFLUX'] = 0;
+
         return True