Changeset 32836 for trunk/ippToPsps

Timestamp:

Nov 30, 2011, 11:08:44 AM (15 years ago)

Author:

rhenders

Message:

New method to 'reset' a batch, basically, pretend it was never loaded to the datastore so that it can be reloaded

File:

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

trunk/ippToPsps/jython/ipptopspsdb.py

@@ -107 +107 @@
     want to load a test batch to PSPS
 
-    ALSO, check that these batches are more than 4 HOURs old, so that we don't attempt to 
-    publish something simulataneously with the client that it producing them
+    We also check that these batches are more than 4 HOURs old, so that we don't attempt to 
+    publish something simulataneously with the client that it producing it
     '''
     def getProcessedButFailedDatastoreBatchIDs(self, epoch, dvoGpc1Label, batchType):
@@ -662 +662 @@
         self.execute(sql)
 
+    '''
+    Resets a batch ready for re-loading to the datastore
+    '''
+    def resetBatch(self, batchID):
+
+        sql = "UPDATE batch SET \
+               loaded_to_datastore = 0, \
+               loaded_to_ODM = 0, \
+               deleted_datastore = 0, \
+               deleted_dxlayer = 0, \
+               comment = 'This batch was reset, ready for re-load to datastore' \
+               WHERE batch_id = " + str(batchID)
+
+        self.execute(sql)
 
     '''