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 sliver_allocation_table = \
   6     Table ( 'sliver_allocation', metadata,
   7             Column('sliver_id', String, primary_key=True),
   8             Column('client_id', String),
   9             Column('component_id', String),
  10             Column('slice_urn', String),
  11             Column('allocation_state', String),
  12           )
  13
  14 def upgrade(migrate_engine):
  15     metadata.bind = migrate_engine
  16     sliver_allocation_table.create()
  17
  18 def downgrade(migrate_engine):
  19     metadata.bind = migrate_engine
  20     sliver_allocation_table.drop()