openstack
/
designate
Code Issues Proposed changes

Merge "Add FK's from Record/RecordSet to domain.id" into stable/liberty

This commit is contained in:
Jenkins 2016-01-11 17:50:33 +00:00 committed by Gerrit Code Review
parent 6c6a5e7c8b 483c3767d3
commit b36140c961
1 changed files with 19 additions and 3 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

22
designate/storage/impl_sqlalchemy/migrate_repo/versions/057_placeholder.py → designate/storage/impl_sqlalchemy/migrate_repo/versions/057_add_r_domain_FK.py
View File

@ -21,10 +21,26 @@
# See https://blueprints.launchpad.net/nova/+spec/backportable-db-migrations
# http://lists.openstack.org/pipermail/openstack-dev/2013-March/006827.html
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table
# This migration adds back the FKs removed in migration 80, as sqlalchemy
# migrate seems to need to wait to add FKs to renamed tables.
meta = MetaData()
def upgrade(migrate_engine):
pass
meta.bind = migrate_engine
domains_table = Table('domains', meta, autoload=True)
recordsets_table = Table('recordsets', meta, autoload=True)
records_table = Table('records', meta, autoload=True)
def downgrade(migration_engine):
pass
fks = []
fks.append(ForeignKeyConstraint([recordsets_table.c.domain_id],
[domains_table.c.id], ondelete='CASCADE'))
fks.append(ForeignKeyConstraint([records_table.c.domain_id],
[domains_table.c.id], ondelete='CASCADE'))
for fk in fks:
fk.create()