sfa/storage/migrations/versions/003_sliver_allocations.py

   1 from sqlalchemy import Table, MetaData, Column
   2 from sqlalchemy import Integer, String
   3
   4 metadata = MetaData()
   5
   6 sliver_allocation_table = \
   7     Table ( 'sliver_allocation', metadata,
   8             Column('sliver_id', String, primary_key=True),
   9             Column('client_id', String),
  10             Column('component_id', String),
  11             Column('slice_urn', String),
  12             Column('allocation_state', String),
  13           )
  14
  15 def upgrade(migrate_engine):
  16     metadata.bind = migrate_engine
  17     sliver_allocation_table.create()
  18
  19 def downgrade(migrate_engine):
  20     metadata.bind = migrate_engine
  21     sliver_allocation_table.drop()