SQLAlchemy backend do not list resource correctly with timestamp

[Julien Danjou]

The following test:

        data = self.get('/projects/project-id/resources',
                        start_timestamp=datetime.datetime(
                            2012, 7, 2, 10, 40).isoformat(),
                        end_timestamp=datetime.datetime(
                            2012, 7, 2, 10, 41).isoformat())

Doesn't return good values with MySQL backend. The problem is that the impl_sqlalchemy code tries to use the 'timestamp' field of the Resource model, but that's just the timestamp of the last receive Meter, and comparing against this is wrong.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/23534
Committed: http://github.com/openstack/ceilometer/commit/98ac1d30f59f725cdbcb886501f08d3921a232a5
Submitter: Jenkins
Branch: master

commit 98ac1d30f59f725cdbcb886501f08d3921a232a5
Author: Julien Danjou <email address hidden>
Date: Mon Mar 4 18:33:39 2013 +0100

    api: run list_resources test against SQL

    This led me to discover and fix bug #1144837, which makes the SQL engine
    returns correctly the list of resources when asked.

    This also fixes a bug in the /resources listing in MongoDB driver: it used
    to filter on the resource db, which only contains the most recent up to date
    version of some fields, and returns wrong results.

    This also fixes bug #1131349

    Change-Id: I7441a8f2839c7db198c80de75f5c39f0dd219813
    Signed-off-by: Julien Danjou <email address hidden>