def upgrade(): # These tables will be created even if the nuage plugin is not enabled. # This is fine as they would be created anyway by the healing migration. if migration.schema_has_table('routers'): # In the database we are migrating from, the configured plugin # did not create the routers table. op.create_table( 'nuage_floatingip_pool_mapping', sa.Column('fip_pool_id', sa.String(length=36), nullable=False), sa.Column('net_id', sa.String(length=36), nullable=True), sa.Column('router_id', sa.String(length=36), nullable=True), sa.ForeignKeyConstraint(['net_id'], ['networks.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['router_id'], ['routers.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('fip_pool_id'), ) if migration.schema_has_table('floatingips'): # In the database we are migrating from, the configured plugin # did not create the floatingips table. op.create_table( 'nuage_floatingip_mapping', sa.Column('fip_id', sa.String(length=36), nullable=False), sa.Column('router_id', sa.String(length=36), nullable=True), sa.Column('nuage_fip_id', sa.String(length=36), nullable=True), sa.ForeignKeyConstraint(['fip_id'], ['floatingips.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('fip_id'), ) migration.rename_table_if_exists('net_partitions', 'nuage_net_partitions') migration.rename_table_if_exists('net_partition_router_mapping', 'nuage_net_partition_router_mapping') migration.rename_table_if_exists('router_zone_mapping', 'nuage_router_zone_mapping') migration.rename_table_if_exists('subnet_l2dom_mapping', 'nuage_subnet_l2dom_mapping') migration.rename_table_if_exists('port_mapping', 'nuage_port_mapping') migration.rename_table_if_exists('routerroutes_mapping', 'nuage_routerroutes_mapping')
def downgrade(active_plugins=None, options=None): migration.drop_table_if_exists('nuage_floatingip_mapping') migration.drop_table_if_exists('nuage_floatingip_pool_mapping') migration.rename_table_if_exists('nuage_net_partitions', 'net_partitions') migration.rename_table_if_exists('nuage_net_partition_router_mapping', 'net_partition_router_mapping') migration.rename_table_if_exists('nuage_router_zone_mapping', 'router_zone_mapping') migration.rename_table_if_exists('nuage_subnet_l2dom_mapping', 'subnet_l2dom_mapping') migration.rename_table_if_exists('nuage_port_mapping', 'port_mapping') migration.rename_table_if_exists('nuage_routerroutes_mapping', 'routerroutes_mapping')
def downgrade(): migration.drop_table_if_exists('nuage_floatingip_mapping') migration.drop_table_if_exists('nuage_floatingip_pool_mapping') migration.rename_table_if_exists('nuage_net_partitions', 'net_partitions') migration.rename_table_if_exists('nuage_net_partition_router_mapping', 'net_partition_router_mapping') migration.rename_table_if_exists('nuage_router_zone_mapping', 'router_zone_mapping') migration.rename_table_if_exists('nuage_subnet_l2dom_mapping', 'subnet_l2dom_mapping') migration.rename_table_if_exists('nuage_port_mapping', 'port_mapping') migration.rename_table_if_exists('nuage_routerroutes_mapping', 'routerroutes_mapping')
def upgrade(active_plugins=None, options=None): # These tables will be created even if the nuage plugin is not enabled. # This is fine as they would be created anyway by the healing migration. op.create_table( 'nuage_floatingip_pool_mapping', sa.Column('fip_pool_id', sa.String(length=36), nullable=False), sa.Column('net_id', sa.String(length=36), nullable=True), sa.Column('router_id', sa.String(length=36), nullable=True), sa.ForeignKeyConstraint(['net_id'], ['networks.id'], ondelete='CASCADE'), sa.ForeignKeyConstraint(['router_id'], ['routers.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('fip_pool_id'), ) op.create_table( 'nuage_floatingip_mapping', sa.Column('fip_id', sa.String(length=36), nullable=False), sa.Column('router_id', sa.String(length=36), nullable=True), sa.Column('nuage_fip_id', sa.String(length=36), nullable=True), sa.ForeignKeyConstraint(['fip_id'], ['floatingips.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('fip_id'), ) migration.rename_table_if_exists('net_partitions', 'nuage_net_partitions') migration.rename_table_if_exists('net_partition_router_mapping', 'nuage_net_partition_router_mapping') migration.rename_table_if_exists('router_zone_mapping', 'nuage_router_zone_mapping') migration.rename_table_if_exists('subnet_l2dom_mapping', 'nuage_subnet_l2dom_mapping') migration.rename_table_if_exists('port_mapping', 'nuage_port_mapping') migration.rename_table_if_exists('routerroutes_mapping', 'nuage_routerroutes_mapping')