Switch DB migration engine to Alembic

Registered by Alexei Kornienko

Please read similar similar blueprint in nova: https://blueprints.launchpad.net/nova/+spec/convert-to-alembic

In addition:
1) SQLAlchemy-migrate has several bugs related to sqllite backend. this project no longer maintained and doesn't accept bugfixes. Cause of this we have to use monkey patching and other workarounds to solve them in other projects.
2) It has compatibility issues with sqlalchemy >0.8.x (solved by a separate patch)

Ceilometer is currently relatively small and it should be easier to convert it to Alebmic migration engine. Such conversion will provide a good reference point for other projects that will soon follow.

Blueprint information

Status:
Complete
Approver:
Julien Danjou
Priority:
Low
Drafter:
Alexei Kornienko
Direction:
Needs approval
Assignee:
Alexei Kornienko
Definition:
Approved
Series goal:
Accepted for havana
Implementation:
Implemented
Milestone target:
milestone icon 2013.2
Started by
Julien Danjou
Completed by
Alexei Kornienko

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bp/convert-to-alembic,n,z

Addressed by: https://review.openstack.org/37223
    Added alembic migrations

Addressed by: https://review.openstack.org/37224
    Added functions to sync db in both alembic and migrate

Addressed by: https://review.openstack.org/37225
    Ported 1st migration to alembic

Addressed by: https://review.openstack.org/39076
    Call alembic migrations after sqlalchemy-migrate

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.