Merge "[SQLite] Ensure change is addressed for limit table"

This commit is contained in:
Zuul 2019-02-15 13:49:34 +00:00 committed by Gerrit Code Review
commit d263c022ac
1 changed files with 14 additions and 0 deletions

View File

@ -24,3 +24,17 @@ def upgrade(migrate_engine):
'registered_limit_id', sql.String(64),
sql.ForeignKey(registered_limit_table.c.id))
limit_table.create_column(registered_limit_id)
if migrate_engine.name == 'sqlite':
meta = sql.MetaData()
meta.bind = migrate_engine
# "limit_new" is the table created in 047 expand script for SQLite
# case.
try:
limit_table_new = sql.Table('limit_new', meta, autoload=True)
registered_limit_id = sql.Column(
'registered_limit_id', sql.String(64),
sql.ForeignKey(registered_limit_table.c.id))
limit_table_new.create_column(registered_limit_id)
except sql.exc.NoSuchTableError:
pass