Changeset 37935 for trunk/ippToPsps/jython/detectionbatch.py

Timestamp:

Feb 25, 2015, 1:59:43 PM (11 years ago)

Author:

heather

Message:

forced warp batches for sas37 are now working!

File:

• trunk/ippToPsps/jython/detectionbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/detectionbatch.py

@@ -401 +401 @@
         # XXX EAM 2014072 : Is this still a problem?
         sql = "UPDATE " + pspsTableName + " SET psfFlux = 1e20 WHERE psfFlux <= 0.0"
-        self.scratchDb.execute(sql)
-        
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.infoPair("failed sql",sql)
+            raise
         sql = "UPDATE " + pspsTableName + " SET apFlux = 1e20 WHERE apFlux <= 0.0"
-        self.scratchDb.execute(sql)
-
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.infoPair("failed sql",sql)
+            raise
         sql = "UPDATE " + pspsTableName + " SET kronFlux = 1e20 WHERE kronFlux <= 0.0"
-        self.scratchDb.execute(sql)
-
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.infoPair("failed sql",sql)
+            raise
         # we don't delete these anymore
         results['NULLINSTFLUX'] = 0;
@@ -604 +610 @@
                AND b.imageID = " + str(imageID)
 
-        self.scratchDb.execute(sql)
-
+        try: self.scratchDb.execute(sql)
+        except:
+            self.logger.InfoPair("failed sql",sql)
+            raise
     '''
     Updates table and generates pspsuniqueids