Changeset 34992

Timestamp:

Jan 19, 2013, 6:57:48 AM (13 years ago)

Author:

eugene

Message:

always create the basic images and detection tables, the latter is used for dvoDetectionsFull

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py (modified) (2 diffs)

branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py

@@ -355 +355 @@
     def createDvoTables(self):
     
+        dvoImagesTable = "dvoImages"
+        dvoDetectionTable = "dvoDetections"
+
         # drop and create Images table
-        self.logger.debugPair("Creating DVO table", self.dvoImagesTable)
-        sql = "DROP TABLE " + self.dvoImagesTable
+        self.logger.debugPair("Creating DVO table", dvoImagesTable)
+        sql = "DROP TABLE " + dvoImagesTable
+
         try: self.execute(sql)
         except: pass
         
-        sql = "CREATE TABLE " + self.dvoImagesTable + " ( \
+        sql = "CREATE TABLE " + dvoImagesTable + " ( \
                SOURCE_ID SMALLINT, \
                IMAGE_ID INT, \
@@ -375 +379 @@
 
         # now detection table
-        self.logger.debugPair("Creating DVO table", self.dvoDetectionTable)
-        sql = "DROP TABLE " + self.dvoDetectionTable
+        self.logger.debugPair("Creating DVO table", dvoDetectionTable)
+        sql = "DROP TABLE " + dvoDetectionTable
         try: self.execute(sql)
         except: pass