Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 33163)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 33164)
@@ -225,5 +225,5 @@
     def getTotalSizeOfIngestedDvoFiles(self):
 
-        sql = "SELECT SUM(size) FROM " + self.dvoDoneTable + " where path LIKE '%cpm' OR path LIKE '%cpt'"
+        sql = "SELECT SUM(size) FROM " + self.dvoDoneTable + " WHERE path LIKE '%cpm' OR path LIKE '%cpt'"
         try:
             rs = self.executeQuery(sql)  
@@ -326,4 +326,25 @@
 
     '''
+    Resets only the detection table info from DVO ingest
+    '''
+    def resetOnlyDetectionDvoTables(self):
+
+       self.logger.infoPair("Deleting detections from", self.dvoDoneTable)
+       sql = "DELETE FROM " + self.dvoDoneTable + " WHERE path LIKE '%cpm' OR path LIKE '%cpt'"
+       try: self.execute(sql)
+       except: 
+           self.logger.errorPair("Unable to delete from", self.dvoDoneTable)
+           return False
+
+       self.logger.infoPair("Deleting detections from", self.dvoDetectionTable)
+       sql = "DELETE FROM " + self.dvoDetectionTable
+       try: self.execute(sql)
+       except: 
+           self.logger.errorPair("Unable to delete from", self.dvoDetectionTable)
+           return False
+
+       return True
+
+    '''
     Drops and recreates tables necessary for dvoToMySQL program. Be very careful before using this...
     '''