DB Migration: fix 003_sliver_allocations.py
authorMohamed Larabi <mohamed.larabi@inria.fr>
Mon, 25 Nov 2013 16:53:23 +0000 (17:53 +0100)
committerMohamed Larabi <mohamed.larabi@inria.fr>
Mon, 25 Nov 2013 16:53:23 +0000 (17:53 +0100)
sfa/storage/migrations/versions/003_sliver_allocations.py

index 21c8511..c1534db 100644 (file)
@@ -1,13 +1,20 @@
-from sqlalchemy import Table, MetaData, Column, ForeignKey
+from sqlalchemy import Table, MetaData, Column
 from sqlalchemy import Integer, String
-from sfa.storage.model import SliverAllocation
 
 metadata=MetaData()
+sliver_allocation_table = \
+    Table ( 'sliver_allocation', metadata,
+            Column('sliver_id', String, primary_key=True),
+            Column('client_id', String),
+            Column('component_id', String),
+            Column('slice_urn', String),
+            Column('allocation_state', String),
+          )
 
 def upgrade(migrate_engine):
     metadata.bind = migrate_engine
-    SliverAllocation.create()
+    sliver_allocation_table.create()
 
 def downgrade(migrate_engine):
     metadata.bind = migrate_engine
-    SliverAllocation.drop()
+    sliver_allocation_table.drop()