Changeset 38837 for trunk/ippToPsps/jython/mysql.py

Timestamp:

Oct 10, 2015, 12:40:44 PM (11 years ago)

Author:

eugene

Message:

make code less forgiving: sql execute aborts on failures; deal with various hidden problems: add IF EXISTS to drop table operations to avoid raising unneeded error, make sure tables exist before trying to add indexes, test for existence of the stack _xsrc, _xfit, etc tables (and skip if missing); fix sqlLine.group to cast inputs to string before performing string ops; getKeyFloat now returns a float value which is safe with sqlLine.group, but can be used in a math expression; use python math. operators as needed (sqrt, fabs); fulltest.sh runs for camera, stack, object stages; update dvoSkyTable to use REGION_ID instead of special word INDEX; add existsClient method (avoid using mysql failure as a test for table existence); no need to test for exceptions to sql.execute since we abort on failure; replace esoteric SQL with dropTable calls; trap errors in stilts.treads in setupScratchdb; drop StackObjecThin and StackDetOffMeta along with other stack scratch tables

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -230 +230 @@
     def dropTable(self, table):
 
-        sql = "DROP TABLE " + table
+        sql = "DROP TABLE IF EXISTS " + table
         try: self.execute(sql)
         except: return
@@ -334 +334 @@
 
         stmt = self.con.createStatement()
-        stmt.execute(sql)
+
+        try: stmt.execute(sql)
+        except Exception, e: 
+            print "--- Error calling mysql: "
+            print "--- sql: " + sql
+            print "--- " + str(e)
+            os._exit(2) 
         stmt.close()