Changeset 31386

Timestamp:

Apr 27, 2011, 9:47:37 AM (15 years ago)

Author:

rhenders

Message:

getter/setter for dvoDone table

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -100 +100 @@
         self.stmt.execute(sql)
 
+    '''
+    Updates dvoDone table with this DVO table
+    '''
+    def setImportedThisDvoTable(self, name):
+
+        sql = "INSERT INTO dvoDone (name) VALUES ('" + name + "')"
+        self.stmt.execute(sql)
+        
+    '''
+    Have we already imported this DVO table?
+    '''
+    def alreadyImportedThisDvoTable(self, name):
+
+        sql = "SELECT COUNT(*) FROM dvoDone WHERE name = '" + name + "'"
+
+        try:
+            rs = self.stmt.executeQuery(sql)
+            rs.first()
+            if rs.getInt(1) > 0:
+                self.logger.error("DVO tables " + name + " have already been imported")
+                return True
+            else:
+                return False
+        except:
+            self.logger.exception("Unable to check whether this DVO table has been imported")
+
 
     '''
@@ -107 +133 @@
 
         self.logger.info("Creating DVO meta and detection tables")
+
         sql = "DROP TABLE dvoMeta"
         try: self.stmt.execute(sql)
@@ -137 +164 @@
                PRIMARY KEY (sourceID, imageID, ippDetectID) \
                )"
+               #INDEX (sourceID), \
+               #INDEX (imageID), \
+               #INDEX (ippDetectID) \
 
         try: self.stmt.execute(sql)