test suite doesn't work with sqlalchemy v7

[Monty Taylor]

When we tried aligning the glance pip-requires with nova in terms of sqlalchemy versions, we got a bunch of funky errors from sqlalchemy (which was installing 7.0.3) These may just be how the test suite runs, as people seemed to think it should have worked.

In any case - I'd really like to get us aligned on versions there - so we should probably fix this.

[Andrew Hutchings (linuxjedi)]

Problem 1:
test_bad_sql_connection fails and breaks _ENGINE for the rest of the SQL Alchemy based tests

Problem 2:
test_walk_versions also breaks

Not figured out the cause of these two yet.

[Andrew Hutchings (linuxjedi)]

My own notes so far:

Problem 1 I have a patch for (going to attach here until I have set everything up to do workflow)

Problem 2 migration_api.downgrade(options, version) version 9->8 failing.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/3814
Committed: http://github.com/openstack/glance/commit/e4db87ce4c2757b734b5fc62a82e1076c3367af0
Submitter: Jenkins
Branch: master

commit e4db87ce4c2757b734b5fc62a82e1076c3367af0
Author: Andrew Hutchings <email address hidden>
Date: Mon Feb 6 18:35:49 2012 +0000

    Make Glance work with SQLAlchemy 0.7

    Fix execption caught during tests
    Fix test failure wiping out engine in use

    Fixes bug 892754

    Change-Id: I9de6f077af656730c95bc715c2b765b0c49c7d3c