Changeset 35077 for branches/eam_branches/ipp-20121219/ippToPsps/jython/ipptopspsdb.py

Timestamp:

Jan 31, 2013, 5:47:48 PM (13 years ago)

Author:

eugene

Message:

track the boxes for which dvo detections have been ingested

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/ipptopspsdb.py (modified) (2 diffs)

branches/eam_branches/ipp-20121219/ippToPsps/jython/ipptopspsdb.py

@@ -894 +894 @@
            if field == 'timestamp': continue
            if field == 'name': continue
+           if field == 'ingested_det': continue
+           if field == 'ingested_obj': continue
 
            # get current value for this field, if any
@@ -1075 +1077 @@
 
     '''
+    Inserts new box into box table. If it already exisits, it returns existing box id 
+    '''
+    def isBoxIngested(self, id):
+
+        # set the field 'ingested' to 1 for this box
+        sql = "select ingested from box where id = " + str(id)
+        try:
+            rs = self.executeQuery(sql)
+            if not rs.next():
+                print "no matching boxes for ", str(id)
+                raise
+            status = rs.getInt(1)
+        except:
+            print "failed to set box ", str(id), "as ingested"
+            raise
+
+        return status
+    '''
+    Inserts new box into box table. If it already exisits, it returns existing box id 
+    '''
+    def setIngestedBox(self, id):
+
+        # set the field 'ingested' to 1 for this box
+        sql = "update box set ingested = 1 where id = " + str(id)
+        try:
+            self.execute(sql)
+        except:
+            print "failed to set box ", str(id), "as ingested"
+            raise
+
+    '''
+    Inserts new box into box table. If it already exisits, it returns existing box id 
+    '''
+    def clearIngestedBoxes(self):
+
+        # set the field 'ingested' to 1 for this box
+        sql = "update box set ingested = 0"
+        try:
+            self.execute(sql)
+        except:
+            print "failed to clear boxes as ingested"
+            raise
+
+    '''
     Inserts new box ids into the pending table 
     '''