Bug 1042118

Summary: [RFE][oslo]: Common test for checking models with migrations
Product: Red Hat OpenStack Reporter: RHOS Integration <rhos-integ>
Component: RFEsAssignee: RHOS Maint <rhos-maint>
Status: CLOSED UPSTREAM QA Contact:
Severity: high Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: markmc, yeylon
Target Milestone: Upstream M3Keywords: FutureFeature
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://blueprints.launchpad.net/oslo/+spec/sync-models-with-migrations
Whiteboard: upstream_milestone_none upstream_status_started upstream_definition_approved
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-03-19 17:28:21 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description RHOS Integration 2013-12-12 21:05:22 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/oslo/+spec/sync-models-with-migrations.

Description:

All component from Openstack uses models as python representation and migrations as database creation tools.
There is no check for equality of models with databse state.
In fact we have differences in models. We are working on syncing models with migrations, but it will be better to have common test that will check any differences. It can be used in any components of OpenStack.
For checking mysql and postgress should be used.
Objects for testing:
- columns (type, length, default values, nullable),
- constraints (foreign key, unique key, indexes).

Specification URL (additional information):

None