Changeset 31398 for trunk/ippToPsps/jython/dvoToMySQL.py

Timestamp:

Apr 28, 2011, 3:45:48 PM (15 years ago)

Author:

rhenders

Message:

Working version: used to create MD04.merged database

File:

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

trunk/ippToPsps/jython/dvoToMySQL.py

@@ -58 +58 @@
         # insert into dvoMetaFull
         self.logger.info("Inserting all image meta data into database")
-        sql = "INSERT INTO dvoMetaFull ( \
+        sql = "INSERT INTO dvoMetaNew ( \
                sourceID, \
                imageID, \
+               externID, \
                flags, \
                photcode \
@@ -66 +67 @@
                SOURCE_ID, \
                IMAGE_ID, \
+               EXTERN_ID, \
                FLAGS, \
                PHOTCODE \
                FROM " + imagesTableName
         self.scratchDb.stmt.execute(sql)
-        
+
         subdirs = ['n0000']