Changeset 35183 for trunk/ippToPsps/jython/ipptopspsdb.py

Timestamp:

Feb 20, 2013, 9:49:30 AM (13 years ago)

Author:

eugene

Message:

box.ingested value is now the hostname

File:

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

trunk/ippToPsps/jython/ipptopspsdb.py

@@ -1097 +1097 @@
     Inserts new box into box table. If it already exisits, it returns existing box id 
     '''
-    def setIngestedBox(self, id):
+    def setIngestedBox(self, id, host):
 
         # set the field 'ingested' to 1 for this box
-        sql = "update box set ingested = 1 where id = " + str(id)
+        sql = "update box set ingested = '" + host + "' where id = " + str(id)
         try:
             self.execute(sql)
@@ -1108 +1108 @@
 
     '''
-    Inserts new box into box table. If it already exisits, it returns existing box id 
-    '''
-    def clearIngestedBoxes(self):
+    Clear ingested flag for boxes owned by this host
+    '''
+    def clearIngestedBoxes(self, host):
 
         # set the field 'ingested' to 1 for this box
-        sql = "update box set ingested = 0"
+        sql = "update box set ingested = 'none' where ingested = '" + host + "'"
         try:
             self.execute(sql)
         except:
-            print "failed to clear boxes as ingested"
+            print "failed to clear ingested state for boxes owned by host ", host
             raise