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