Bug 1041777

Summary: [RFE][glance]: Clean up db code in glance
Product: Red Hat OpenStack Reporter: RHOS Integration <rhos-integ>
Component: RFEsAssignee: RHOS Maint <rhos-maint>
Status: CLOSED UPSTREAM QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: markmc, yeylon
Target Milestone: ---Keywords: FutureFeature
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://blueprints.launchpad.net/glance/+spec/db-cleanup
Whiteboard: upstream_milestone_next upstream_status_unknown upstream_definition_approved
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-03-19 17:11:46 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 19:16:48 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/glance/+spec/db-cleanup.

Description:

This is the base BP for others BP, that should collect all other BPs around DB.

This work was done in nova and should be done in Glance also:

1) use oslo db code 
2) provide unique constraints
3) shadow tables, to remove deleted rows from table
4) migration tests on all backends with real data
in feature (after nova implementation):
5) sync db models with real tables after db-migrations and add tests that checks this.
6) check indexes (add or remove for better performance)




Specification URL (additional information):

None