Changeset 31804

Timestamp:

Jul 1, 2011, 8:38:57 AM (15 years ago)

Author:

rhenders

Message:

added externID column to dvoMeta table for DVO-on-the-fly mode to be consistent with tables for 'full' DVO tables generated from full DVO databases; improved some logging messages

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (5 diffs)

trunk/ippToPsps/jython/scratchdb.py

@@ -19 +19 @@
     Constructor
     '''
-    def __init__(self, logger, useFull=False):
+    def __init__(self, logger, useFull=0):
         super(ScratchDb, self).__init__(logger,"localdatabase")
 
@@ -65 +65 @@
             flags = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get flags from dvo table")
-
+            self.logger.exception("Unable to get flags from dvo table using " + sql)
         return flags
 
@@ -82 +81 @@
             imageID = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get imageID from dvo meta table")
+            self.logger.exception("Unable to get imageID from dvo meta table using " + sql)
 
         return imageID
@@ -118 +117 @@
         sql = "INSERT INTO dvoMeta ( \
                sourceID, \
-               imageID \
+               imageID, \
+               externID \
                ) VALUES (\
                " + str(sourceID) + ", \
+               " + str(imageID) + " ,   \
                " + str(imageID) + "    \
                )"
@@ -170 +171 @@
                sourceID INT, \
                imageID INT, \
+               externID INT, \
                flags INT, \
                photcode INT, \