openstack
/
octavia
Code Issues Proposed changes

Merge "Fix broken database migration"

This commit is contained in:
Jenkins 2017-05-23 12:37:06 +00:00 committed by Gerrit Code Review
parent 612493d8ab 3cc3265743
commit c0a141989a
1 changed files with 45 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

45
octavia/db/migration/alembic_migrations/versions/034b2dc2f3e0_modernize_l7policy_fields.py
View File

@ -62,6 +62,26 @@ def upgrade():
u'operating_status', [u'operating_status'], [u'name']
)
op.drop_constraint('fk_health_monitor_provisioning_status_name',
'health_monitor',
type_='foreignkey')
op.drop_constraint('fk_l7policy_provisioning_status_name',
'l7policy',
type_='foreignkey')
op.drop_constraint('fk_l7rule_provisioning_status_name',
'l7rule',
type_='foreignkey')
op.drop_constraint('fk_member_provisioning_status_name',
'member',
type_='foreignkey')
op.drop_constraint('fk_pool_provisioning_status_name',
'pool',
type_='foreignkey')
# provisioning_status was mistakenly added as nullable, the fix is similar
op.alter_column(u'l7policy', u'provisioning_status', nullable=False,
existing_type=sa.String(16),
@ -94,3 +114,28 @@ def upgrade():
server_default=constants.ACTIVE)
op.alter_column(u'l7rule', u'provisioning_status',
existing_type=sa.String(16), server_default=None)
op.create_foreign_key(
u'fk_health_monitor_provisioning_status_name', u'health_monitor',
u'provisioning_status', [u'provisioning_status'], [u'name']
)
op.create_foreign_key(
u'fk_l7policy_provisioning_status_name', u'l7policy',
u'provisioning_status', [u'provisioning_status'], [u'name']
)
op.create_foreign_key(
u'fk_l7rule_provisioning_status_name', u'l7rule',
u'provisioning_status', [u'provisioning_status'], [u'name']
)
op.create_foreign_key(
u'fk_member_provisioning_status_name', u'member',
u'provisioning_status', [u'provisioning_status'], [u'name']
)
op.create_foreign_key(
u'fk_pool_provisioning_status_name', u'pool',
u'provisioning_status', [u'provisioning_status'], [u'name']
)