Block subtractive schema changes

Registered by Abhishek Kekane on 2016-03-24

Drop and alter are the two main db migration operations which usually breaks the schema upgrades. To ensure smooth schema upgrades its beneficial to block subtractive operations in schema migration.

So, we need a mechanical filter to restrict subtractive schema changes by writing a simple unit test which would fail if it detects drop or alter db schema changes in the newly added migration scripts. Also, a provision will be made to take any exceptions which would allow certain subtractive schema migration changes after careful deliberation.

Cinder [1] and Nova [2] are already supporting blocking of subtractive schema operations. Would like to add similar support here.

[1] https://github.com/openstack/cinder/commit/0d4bd0dc79d54b3c739c09668335a23ca498a1ba
[2] https://github.com/openstack/nova/commit/43ccfc84f5cc8f0f7d25d025e17c4a5ed993b2f3

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
Abhishek Kekane
Direction:
Needs approval
Assignee:
Abhishek Kekane
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.