glance db purge util

Registered by Abel Lopez on 2014-10-30

Adding functionality to `glance-manage db` to safely purge "deleted" data. This will have non-optional argument of nDays.
For example `glance-manage db purge 60` will go into the glance db, and delete from each table where 'deleted =! 0 and deleted_at > date_sub(NOW(), interval 60 day);'

This is a useful feature as Openstack matures and operators/admins are upgrading over time.

Blueprint information

Status:
Started
Approver:
Flavio Percoco
Priority:
Undefined
Drafter:
Martin Mágr
Direction:
Needs approval
Assignee:
Martin Mágr
Definition:
New
Series goal:
None
Implementation:
Needs Code Review
Milestone target:
None
Started by
Flavio Percoco on 2015-11-27

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bp/database-purge,n,z

Addressed by: https://review.openstack.org/216782
    Add db purge command

NOTE [2015-10-07 nikhil]: Please create a glance-spec for documenting this BP more clearly: https://github.com/openstack/glance-specs . The process for submitting a merge proposal for the spec is same as other openstack projects. http://docs.openstack.org/infra/manual/developers.html . Also, please specify the link to the spec here https://blueprints.launchpad.net/glance/+spec/database-purge/+edit . Thank you!

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.