¡@
OpenStack Study: 040_drop_grant_tables.py**** CubicPower OpenStack Study **** def recreate_grant_tables(meta, migrate_engine): sql.Table('user', meta, autoload=True) sql.Table('group', meta, autoload=True) sql.Table('project', meta, autoload=True) sql.Table('domain', meta, autoload=True) user_project_metadata_table = sql.Table( USER_PROJECT_TABLE, meta, sql.Column( 'user_id', sql.String(64), primary_key=True), sql.Column( 'project_id', sql.String(64), sql.ForeignKey('project.id'), primary_key=True), sql.Column('data', sql.Text())) user_project_metadata_table.create(migrate_engine, checkfirst=True) group_project_metadata_table = sql.Table( GROUP_PROJECT_TABLE, meta, sql.Column( 'group_id', sql.String(64), primary_key=True), sql.Column( 'project_id', sql.String(64), sql.ForeignKey('project.id'), primary_key=True), sql.Column('data', sql.Text())) group_project_metadata_table.create(migrate_engine, checkfirst=True) user_domain_metadata_table = sql.Table( USER_DOMAIN_TABLE, meta, sql.Column( 'user_id', sql.String(64), primary_key=True), sql.Column( 'domain_id', sql.String(64), sql.ForeignKey('domain.id'), primary_key=True), sql.Column('data', sql.Text())) user_domain_metadata_table.create(migrate_engine, checkfirst=True) group_domain_metadata_table = sql.Table( GROUP_DOMAIN_TABLE, meta, sql.Column( 'group_id', sql.String(64), primary_key=True), sql.Column( 'domain_id', sql.String(64), sql.ForeignKey('domain.id'), primary_key=True), sql.Column('data', sql.Text())) group_domain_metadata_table.create(migrate_engine, checkfirst=True)
**** CubicPower OpenStack Study **** def upgrade(migrate_engine): meta = sql.MetaData() meta.bind = migrate_engine for table_name in GRANT_TABLES: grant_table = sql.Table(table_name, meta, autoload=True) grant_table.drop(migrate_engine, checkfirst=True)
**** CubicPower OpenStack Study **** def downgrade(migrate_engine): meta = sql.MetaData() meta.bind = migrate_engine recreate_grant_tables(meta, migrate_engine)
|