Changeset 33164

Timestamp:

Jan 26, 2012, 4:05:27 PM (14 years ago)

Author:

rhenders

Message:

method to drop all DVO detections from database, but not Images and SkyTables

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -225 +225 @@
     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 +326 @@
 
     '''
+    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...
     '''