Changeset 33177 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

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

Author:

rhenders

Message:

changes to keep track of, and purge, ingested-but-out-of-date regions

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (1 diff)

trunk/ippToPsps/jython/scratchdb.py

@@ -184 +184 @@
 
     '''
+    Do we have an out-of-date version of this file?
+    '''
+    def haveOutOfDateVersionOfThisDvoTable(self, path):
+
+        fileStat = os.stat(path)
+
+        sql = "SELECT COUNT(*) FROM " + self.dvoDoneTable + " WHERE path = '" + path + "' AND modifiedDate != " + str(fileStat.st_mtime) 
+
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            if rs.getInt(1) > 0:
+                self.logger.debugPair("Have out-to-date version of",  path)
+                return True
+            else:
+                return False
+        except:
+            self.logger.exception("Unable to check whether this DVO table is out-of-date")
+
+    '''
     Have we already imported this DVO table?
+    Checks path and modified date to be sure
     '''
     def alreadyImportedThisDvoTable(self, path):