taskflow doesn't work with SQLAlchemy 1.4.23

[Thomas Goirand]

Hi,

This is a report when trying to build the Xena Taskflow package for Debian.

Oslo.db wants SQLAlchemy >= 1.4. So the whole OpenStack Xena must be compatible with it. Unfortunately, it looks like Taskflow fails with SQLA 1.4.

=========================
Failures during discovery
=========================
--- import errors ---
Failed to import test module: taskflow.tests.unit.persistence.test_sql_persistence
Traceback (most recent call last):
  File "/usr/lib/python3.9/unittest/loader.py", line 436, in _find_test_path
    module = self._get_module_from_name(name)
  File "/usr/lib/python3.9/unittest/loader.py", line 377, in _get_module_from_name
    __import__(name)
  File "/<<PKGBUILDDIR>>/taskflow/tests/unit/persistence/test_sql_persistence.py", line 46, in <module>
    from taskflow.persistence.backends import impl_sqlalchemy
  File "/<<PKGBUILDDIR>>/taskflow/persistence/backends/impl_sqlalchemy.py", line 35, in <module>
    from taskflow.persistence.backends.sqlalchemy import tables
  File "/<<PKGBUILDDIR>>/taskflow/persistence/backends/sqlalchemy/tables.py", line 22, in <module>
    import sqlalchemy_utils as su
  File "/usr/lib/python3/dist-packages/sqlalchemy_utils/__init__.py", line 1, in <module>
    from .aggregates import aggregated # noqa
  File "/usr/lib/python3/dist-packages/sqlalchemy_utils/aggregates.py", line 372, in <module>
    from .functions.orm import get_column_key
  File "/usr/lib/python3/dist-packages/sqlalchemy_utils/functions/__init__.py", line 1, in <module>
    from .database import ( # noqa
  File "/usr/lib/python3/dist-packages/sqlalchemy_utils/functions/database.py", line 11, in <module>
    from .orm import quote
  File "/usr/lib/python3/dist-packages/sqlalchemy_utils/functions/orm.py", line 14, in <module>
    from sqlalchemy.orm.query import _ColumnEntity
ImportError: cannot import name '_ColumnEntity' from 'sqlalchemy.orm.query' (/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py)

[Thomas Goirand (thomas-goirand)]

Hi,

Sorry for the noise, I needed to upgrade sqlalchemy-utils. After that, everything is fine.