RFE: Use Alembic for database migrations

Bug #1816107 reported by Lance Bragstad on 2019-02-15
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Wishlist
Unassigned

Bug Description

Move from SQLALChemy-migrate to Alembic as the tool for maintaining SQL Repos.

Lance Bragstad (lbragstad) wrote :
tags: added: sql
tags: added: upgrades
Changed in keystone:
status: New → Triaged
importance: Undecided → Wishlist
Lance Bragstad (lbragstad) wrote :

Patches that work towards this initiative:

alembic initial support: https://review.openstack.org/150057
Do not add new 'db' command and subcommands for it: https://review.openstack.org/177219
Target Alembic for Liberty: https://review.openstack.org/177220
Use migration_cli for db migrations: https://review.openstack.org/147548

tags: added: rfe

Now we have two commands that are related to migrations -- db_sync to migrate and db_version to show the current version. It works OK with sqlalchemy-migrate, but not with Alembic that we will be using. What needs to be done is to create a set of commands - "db upgrade/downgrade/stamp/revision/version". It will comply with alembic commands and with oslo.db migration_cli interface.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers