db function snapsht_get_active_by_window required

[Ollie Leahy]

The db function volume_get_active_by_window() is used generate a list of volumes that exist during a specified time period. The list is then used to generate notifications for billing purposes.

A similar function is required to generate a list of snapshots that exist during a specified time period, so that snapshots can also be billed.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/24806

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/24806
Committed: http://github.com/openstack/cinder/commit/f117a0e22a30136ec20661a65020004c38e55f93
Submitter: Jenkins
Branch: master

commit f117a0e22a30136ec20661a65020004c38e55f93
Author: Michael Kerrin <email address hidden>
Date: Tue Mar 19 18:04:39 2013 +0000

    Add snapshots to the volume usage audit report

    * Added tests for db api call volume_get_active_by_window called by the volume
    usage audit report.

    * Added new db api called snapshot_get_active_by_window & test it. This is
    similar to the volume_get_active_by_window method but returns the snapshots
     active the supplied time window.

    * Integrate the above into the cinder-volume-usage-audit script to report on
      all the active snapshots as well as volumes in the specified time frame.

    Fixes: bug #1157110

    Change-Id: I7597da20c62150a8f6c74cbfeec159f68064d2a6