Changeset 38837 for trunk/ippToPsps/jython/setupScratchDb.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/setupScratchDb.py (modified) (2 diffs)

trunk/ippToPsps/jython/setupScratchDb.py

@@ -88 +88 @@
         self.logger.infoPair("Installing", "initialization tables")
         tablepath = self.config.configDir + "tables.IN.vot"
-        tables = stilts.treads(tablepath)
+        try:
+            tables = stilts.treads(tablepath)
+        except Exception, e:
+            print "--- problem reading tables.IN.vot"
+            print "--- " + str(e)
+            os._exit(3)
 
         for table in tables:
@@ -94 +99 @@
             self.logger.infoPair("Creating IN table: ", table.name)
             self.logger.debug("Creating IN table: " + table.name)
-            table.write(self.scratchDb.url + '#' + table.name)
+            try: table.write(self.scratchDb.url + '#' + table.name)
+            except Exception, e: print "--- " + str(e)
 
         # create basic DVO tables