Index: /trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- /trunk/ippToPsps/jython/scratchdb.py	(revision 31385)
+++ /trunk/ippToPsps/jython/scratchdb.py	(revision 31386)
@@ -100,4 +100,30 @@
         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,4 +133,5 @@
 
         self.logger.info("Creating DVO meta and detection tables")
+
         sql = "DROP TABLE dvoMeta"
         try: self.stmt.execute(sql)
@@ -137,4 +164,7 @@
                PRIMARY KEY (sourceID, imageID, ippDetectID) \
                )"
+               #INDEX (sourceID), \
+               #INDEX (imageID), \
+               #INDEX (ippDetectID) \
 
         try: self.stmt.execute(sql)