db: Final cleanups

Some things that were missed in previous patches and are thrown together
here:

- Add alembic as an explicit dependency (we were getting it transitively
  from oslo.db). We also bump the sqlalchemy dependency to a 1.4.x
  release, which is the minimum supported by our chosen version of
  alembic (more on this below)
- Remove tooling related to the old migrations
- Fix the tox whitelisting of the flaky MySQL tests

On the SQLAlchemy front, we opt for 1.4.13. Technically alembic should
support anything from 1.4.0, however, with SQLAlchemy >= 1.4.0, < 1.4.13
we see errors like the following in some tests:

  sqlalchemy.exc.InvalidRequestError: Entity namespace for
  "count(instance_mappings.id)" has no property "queued_for_delete"

There's nothing specific about this in the release notes for 1.4.13 [1]
but it definitely fixes things.

[1] https://docs.sqlalchemy.org/en/14/changelog/changelog_14.html#change-1.4.13

Change-Id: I4c8eb13f11aa7471c26a5ba326319aef245c9836
Signed-off-by: Stephen Finucane <stephenfin@redhat.com>

1 files changed, 2 insertions, 5 deletions

diff --git a/requirements.txt b/requirements.txt
index b4eb37f5d6..a8bed744fb 100644
--- a/requirements.txt
+++ b/requirements.txt
@@ -1,9 +1,5 @@
-# The order of packages is significant, because pip processes them in the order
-# of appearance. Changing the order has an impact on the overall integration
-# process, which may cause wedges in the gate later.
-
 pbr>=5.5.1 # Apache-2.0
-SQLAlchemy>=1.2.19 # MIT
+SQLAlchemy>=1.4.13 # MIT
 decorator>=4.1.0 # BSD
 eventlet>=0.30.1 # MIT
 Jinja2>=2.10 # BSD License (3 clause)
@@ -19,6 +15,7 @@ PasteDeploy>=1.5.0 # MIT
 Paste>=2.0.2 # MIT
 PrettyTable>=0.7.1 # BSD
 sqlalchemy-migrate>=0.13.0 # Apache-2.0
+alembic>=1.5.0 # MIT
 netaddr>=0.7.18 # BSD
 netifaces>=0.10.4 # MIT
 paramiko>=2.7.1 # LGPLv2.1+