OpenStack Study: 012_add_attach_host_column.py
**** CubicPower OpenStack Study **** def upgrade(migrate_engine): """Add attach host column to volumes.""" meta = MetaData() meta.bind = migrate_engine volumes = Table('volumes', meta, autoload=True) attached_host = Column('attached_host', String(255)) volumes.create_column(attached_host) volumes.update().values(attached_host=None).execute()
**** CubicPower OpenStack Study **** def downgrade(migrate_engine): """Remove attach host column from volumes.""" meta = MetaData() meta.bind = migrate_engine volumes = Table('volumes', meta, autoload=True) attached_host = Column('attached_host', String(255)) volumes.drop_column(attached_host)
|