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
  16 def upgrade(migrate_engine):
  17     metadata.bind = migrate_engine
  18     sliver_allocation_table.create()
  19
  20
  21 def downgrade(migrate_engine):
  22     metadata.bind = migrate_engine
  23     sliver_allocation_table.drop()