Open Stack

We high-spiritedly announce the release of:

oslo.db 13.0.0: Oslo Database library

This release is part of the bobcat release series.

The source is available from:

    https://opendev.org/openstack/oslo.db

Download the package from:

    https://pypi.org/project/oslo.db

Please report issues through:

    https://bugs.launchpad.net/oslo.db/+bugs

For more details, please see below.

13.0.0
^^^^^^


New Features
************

* oslo.db now supports SQLAlchemy 2.0.

* A new "oslo_db.compat" module has been added. This provides a
  number of shims for handling differences between SQLAlchemy 1.x and
  2.x.


Upgrade Notes
*************

* The following test fixtures and base test classes were deprecated
  and have now been removed:

  * "oslo_db.sqlalchemy.test_base.DbFixture"

  * "oslo_db.sqlalchemy.test_base.DbTestCase"

  * "oslo_db.sqlalchemy.test_base.OpportunisticTestCase"

  * "oslo_db.sqlalchemy.test_base.MySQLOpportunisticFixture"

  * "oslo_db.sqlalchemy.test_base.PostgreSQLOpportunisticFixture"

  * "oslo_db.sqlalchemy.test_base.MySQLOpportunisticTestCase"

  * "oslo_db.sqlalchemy.test_base.PostgreSQLOpportunisticTestCase"

  They have all been replaced by equivalent test fixtures and test
  class mixins in "oslo_db.sqlalchemy.test_fixtures".

  In addition, the following test cases were being inadvertently used
  publicly despite being private to oslo.db. They were also deprecated
  and have now been removed:

  * "oslo_db.tests.sqlalchemy.base.DbTestCase"

  * "oslo_db.tests.sqlalchemy.base.MySQLOpportunisticTestCase"

  * "oslo_db.tests.sqlalchemy.base.PostgreSQLOpportunisticTestCase"

* The "oslo_db.sqlalchemy.migration" module and "migrate" backend
  for the "oslo_db.sqalchemy.migration_cli" module, both of which were
  first deprecated in the 8.5.0 release, have now been removed.
  "sqlalchemy-migrate" is no longer under active development, does not
  support SQLAlchemy 2.0, and has been effectively replaced by
  "alembic".

* The ability to create engine facades that used autocommit, first
  deprecated in 12.1.0, has now been removed. This is not supported in
  SQLAlchemy 2.x.

Changes in oslo.db 12.3.1..13.0.0
---------------------------------

af5392b Add release note for base test class removal
56d79bf Remove logic for SQLAlchemy < 1.4
7d62b36 Match exceptions with multiple lines
04acea8 Remove dead code
672dd05 Don't sleep in tests
481936a Moves supported python runtimes from version 3.8 to 3.10
99cba2d Run unit tests against main branch of sqlalchemy, alembic
64e5049 Use SQLAlchemy native pre-ping
1f003bc Get test suite to full pass with SQLAlchemy 2.0
da4f13e Do not convert to string ``url.URL`` objects
a609333 Remove legacy base test classes
94d6e24 Remove sqlalchemy-migrate
877bcfc Rollback the connection after server ping method
5cd7962 Update master for stable/2023.1
7d619ae Imported Translations from Zanata


Diffstat (except docs and test files)
-------------------------------------

.zuul.yaml                                         |  50 ++-
oslo_db/exception.py                               |  11 -
oslo_db/sqlalchemy/compat/__init__.py              |  38 +++
oslo_db/sqlalchemy/enginefacade.py                 |  26 +-
oslo_db/sqlalchemy/engines.py                      | 117 ++++---
oslo_db/sqlalchemy/exc_filters.py                  |  88 +++--
oslo_db/sqlalchemy/migration.py                    | 183 ----------
oslo_db/sqlalchemy/migration_cli/ext_migrate.py    |  79 -----
oslo_db/sqlalchemy/provision.py                    |  43 +--
oslo_db/sqlalchemy/test_base.py                    | 204 -----------
oslo_db/sqlalchemy/test_fixtures.py                |  10 +-
oslo_db/sqlalchemy/test_migrations.py              | 217 ------------
oslo_db/sqlalchemy/update_match.py                 |   4 +-
oslo_db/sqlalchemy/utils.py                        | 347 ++-----------------
.../remove-base-test-classes-557889ec4f072781.yaml |  24 ++
...remove-sqlalchemy-migrate-f69c805004e6bac1.yaml |   8 +
.../notes/sqlalchemy-20-0a193a01c70f805a.yaml      |  11 +
releasenotes/source/2023.1.rst                     |   6 +
releasenotes/source/index.rst                      |   1 +
.../locale/en_GB/LC_MESSAGES/releasenotes.po       |  43 ++-
requirements.txt                                   |   1 -
setup.cfg                                          |   5 +-
34 files changed, 756 insertions(+), 2230 deletions(-)


Requirements updates
--------------------

diff --git a/requirements.txt b/requirements.txt
index 8842a41..7764c23 100644
--- a/requirements.txt
+++ b/requirements.txt
@@ -12 +11,0 @@ SQLAlchemy>=1.4.0 # MIT
-sqlalchemy-migrate>=0.11.0 # Apache-2.0