Open Stack

We are chuffed to announce the release of:

oslo.db 11.0.0: Oslo Database library

This release is part of the xena 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.

11.0.0
^^^^^^


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

* Checks specific to the DB2 database have been removed. This
  database has not been supported by any OpenStack project for many
  years.

* The "check_foreign_keys" helper of the
  "oslo_db.sqlalchemy.test_migrations.ModelsMigrationsSync" base test
  class has been removed. This was deprecated in 1.4.1 as alembic now
  supports this capability.

* The "_walk_versions", "_migrate_down", and "_migrate_up" methods
  of the "oslo_db.sqlalchemy.test_migrations.ModelsMigrationsSync"
  base test class have been removed. These were deprecated in 0.5.0 in
  favour of their non-private equivalents, "walk_versions",
  "migrate_down", and "migrate_up" respectively.


Deprecation Notes
*****************

* The "oslo_db.concurrency.TpoolDbapiWrapper" class and supporting
  "[database] use_tpool" config option are now deprecated. This
  feature never graduated from experimental status and is slated for
  removal due to lack of maintenance and test coverage. Users should
  switch to "oslo_db.api.DBAPI.from_config" and remove references to
  the deprecated config option from their documentation.

Changes in oslo.db 10.0.0..11.0.0
---------------------------------

ad4729d requirements: Bump sqlalchemy lower constraint
8e7454c Don't use plain string SQL statements
0816efc Update import of declarative_base()
6a013c6 Replace use of Table.autoload parameter
38c2eff Replace use of update.values parameter
d2f101c Replace use of update.whereclause parameter
6dc4b1c Replace use of insert.values parameter
d949861 Add missing bind argument to calls
872bc1d Don't pass strings to Connection.execute()
22b44ee Remove use of MetaData.bind argument
8d76072 Remove legacy calling style of select()
4c1eb96 tests: Enable SQLAlchemy 2.0 deprecation warnings
da002a8 utils: Deprecate sqlalchemy-migrate-related functions
40bce5a tests: Enable SADeprecationWarning warnings
a6007a9 tests: Use common base class
538e0a2 tests: Enfeeble 'oslo_db.tests.utils.BaseTestCase'
73e376d tests: Clean up base test
bd69e86 Drop checks for IBM DB2
f048068 tox: Simplify test running
4f9df08 tests: Remove 'ModelsMigrationsSync.check_foreign_keys'
74c6bf2 concurrency: Deprecate 'TpoolDbapiWrapper'
a778f2d sqlalchemy: Remove checks for older deps


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

oslo_db/concurrency.py                             |  31 ++-
oslo_db/sqlalchemy/engines.py                      |   8 +-
oslo_db/sqlalchemy/exc_filters.py                  |  43 +---
oslo_db/sqlalchemy/migration_cli/ext_alembic.py    |   5 -
oslo_db/sqlalchemy/provision.py                    |  32 +--
oslo_db/sqlalchemy/test_migrations.py              | 109 +--------
oslo_db/sqlalchemy/update_match.py                 |   8 +-
oslo_db/sqlalchemy/utils.py                        | 174 ++++++++++-----
...precate-TpoolDbapiWrapper-2ce78aa7cbb9e585.yaml |   9 +
.../notes/drop-db2-support-6e70fe42268d2238.yaml   |   5 +
...nsSync-check_foreign_keys-467e0dbeb65a8c86.yaml |  12 +
requirements.txt                                   |   2 +-
tox.ini                                            |   6 +-
35 files changed, 614 insertions(+), 813 deletions(-)


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

diff --git a/requirements.txt b/requirements.txt
index bf998e1..8842a41 100644
--- a/requirements.txt
+++ b/requirements.txt
@@ -11 +11 @@ oslo.utils>=3.33.0 # Apache-2.0
-SQLAlchemy>=1.2.0 # MIT
+SQLAlchemy>=1.4.0 # MIT