Changeset 37156 for branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py

Timestamp:

Jul 31, 2014, 10:59:37 AM (12 years ago)

Author:

eugene

Message:

adding stack mags to dvopsps detection output; adding option to reset the dvoDetections table; adding makeEquals to sqlUtilities; intelligently(?) select photcode ranges for dvopsps; massive re-work of stackbatch.py

File:

• branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py (modified) (1 diff)

branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py

@@ -123 +123 @@
             # XXX EAM : test output
             rs = self.executeQuery(sql)
-            while (rs.next()): 
-               rows.append([rs.getInt(1), rs.getFloat(2), rs.getFloat(3)])
-            rs.close()
+
         except:
             self.logger.exception("Can't query for ids in DVO")
             self.logger.infoPair("failed sql:", sql)
-            return rows
+            sys.exit(1)
+
+        while (rs.next()): 
+            rows.append([rs.getInt(1), rs.getFloat(2), rs.getFloat(3)])
+
+        rs.close()
 
         self.logger.debug("Found %d items in DVO database '%s' for stage='%s'" % (len(rows), dvoDb, stage))