From 867d1db7373df4a85422e2461866c98ad362b711 Mon Sep 17 00:00:00 2001
From: Tony Mack <tmack@paris.CS.Princeton.EDU>
Date: Fri, 30 Nov 2012 21:16:42 -0500
Subject: [PATCH 1/1] added set_allocations() and delete_allocations()

---
 sfa/storage/model.py | 41 ++++++++++++++++++++++++++++++++++++++---
 1 file changed, 38 insertions(+), 3 deletions(-)

diff --git a/sfa/storage/model.py b/sfa/storage/model.py
index 972040e6..e490251b 100644
--- a/sfa/storage/model.py
+++ b/sfa/storage/model.py
@@ -316,9 +316,11 @@ class SliverAllocation(Base,AlchemyObj):
     sliver_id           = Column(String, primary_key=True)
     allocation_state    = Column(String)
 
-    def __init__(self, sliver_id, allocation_state):
-        self.sliver_id = sliver_id
-        self.allocation_state = allocation_state
+    def __init__(self, **kwds):
+        if 'sliver_id' in kwds:
+            self.sliver_id = kwds['sliver_id']
+        if 'allocation_state' in kwds:
+            self.allocation_state = kwds['allocation_state']
 
     def __repr__(self):
         result = "<sliver_allocation sliver_id=%s allocation_state=%s" % \
@@ -331,6 +333,39 @@ class SliverAllocation(Base,AlchemyObj):
         assert state in allocation_states
         return state
 
+    @staticmethod    
+    def set_allocations(self, sliver_ids, state):
+        from sfa.storage.alchemy import dbsession
+        if not isinstance(sliver_ids, list):
+            sliver_ids = [sliver_ids]
+        sliver_state_updated = {}
+        constraint = SliverAllocation.sliver_id.in_(sliver_ids)
+        sliver_allocations = dbsession.query (SliverAllocation).filter(constraint)
+        sliver_ids_found = []
+        for sliver_allocation in sliver_allocations:
+            sliver_allocation.allocation_state = state
+            sliver_ids_found = sliver_allocation.sliver_id
+
+        # Some states may not have been updated becuase no sliver allocation state record
+        # exists for the sliver. Insert new allocation records for these slivers and set
+        # it to geni_allocated.
+        sliver_ids_not_found = set(sliver_ids).difference(sliver_ids_found)
+        for sliver_id in sliver_ids_not_found:
+            record = SliverAllocation(sliver_id=sliver_id, allocation_state=state)
+            dbsession.add(record)
+        dbsession.commit()
+
+    @staticmethod
+    def delete_allocations(self, sliver_ids):
+        from sfa.storage.alchemy import dbsession
+        if not isinstance(sliver_ids, list):
+            sliver_ids = [sliver_ids]
+        constraint = SliverAllocation.sliver_id.in_(sliver_ids)
+        sliver_allocations = dbsession.query(SliverAllocation).filter(constraint)
+        for sliver_allocation in sliver_allocations:
+            dbsession.delete(sliver_allocation)
+        dbsession.commit()
+
 ##############################
 # although the db needs of course to be reachable for the following functions
 # the schema management functions are here and not in alchemy
-- 
2.45.2