Get sqlalchemy-exasol working with 2.0.45

[ArBridgeman]

Summary

Currently, when we try to run the tests with 2.0.45. We get an output like what's shown below for both test:exasol and test:sqla. This is worrisome as the traceback says involves:

INTERNALERROR> sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:exa
nox > Command coverage run -a --rcfile=/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/pyproject.toml -m pytest --dropfirst --db exasol-websocket /home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/test/integration/exasol failed with exit code 3

Run poetry run -- nox -s test:exasol
/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/noxfile.py:173: FutureWarning: The session 'test:integration' has already been registered; this will be an error in a future version of nox. Overriding the old session for now.
  def integration_tests_for_sqlalchemy_exasol(session: Session) -> None:
/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/noxfile.py:266: FutureWarning: The session 'matrix:all' has already been registered; this will be an error in a future version of nox. Overriding the old session for now.
  def full_matrix(session: Session) -> None:
nox > Running session test:exasol
nox > coverage run -a --rcfile=/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/pyproject.toml -m pytest --dropfirst --db exasol-websocket /home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/test/integration/exasol
=========================== sqlalchemy installation ============================
SQLAlchemy 2.0.45 (user site loaded)
Path: /home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/__init__.py
compiled extension enabled, e.g. /home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/cyextension/util.cpython-310-x86_64-linux-gnu.so 
INTERNALERROR> Traceback (most recent call last):
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/_pytest/main.py", line 287, in wrap_session
INTERNALERROR>     config.hook.pytest_sessionstart(session=session)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/pluggy/_hooks.py", line 512, in __call__
INTERNALERROR>     return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/pluggy/_manager.py", line 120, in _hookexec
INTERNALERROR>     return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/pluggy/_callers.py", line 167, in _multicall
INTERNALERROR>     raise exception
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/_pytest/logging.py", line 780, in pytest_sessionstart
INTERNALERROR>     return (yield)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/pluggy/_callers.py", line 121, in _multicall
INTERNALERROR>     res = hook_impl.function(*args)
INTERNALERROR>   File "/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/test/integration/exasol/conftest.py", line 47, in pytest_sessionstart
INTERNALERROR>     _pytest_sessionstart(session)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/plugin/pytestplugin.py", line 171, in pytest_sessionstart
INTERNALERROR>     asyncio._assume_async(plugin_base.post_begin)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/asyncio.py", line 58, in _assume_async
INTERNALERROR>     return _async_util.run_in_greenlet(fn, *args, **kwargs)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/util/concurrency.py", line 64, in run_in_greenlet
INTERNALERROR>     return self.runner.run(greenlet_spawn(fn, *args, **kwargs))
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 282, in run
INTERNALERROR>     return self._loop.run_until_complete(coro)
INTERNALERROR>   File "/opt/hostedtoolcache/Python/3.10.19/x64/lib/python3.10/asyncio/base_events.py", line 649, in run_until_complete
INTERNALERROR>     return future.result()
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 190, in greenlet_spawn
INTERNALERROR>     result = context.switch(*args, **kwargs)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/plugin/plugin_base.py", line 296, in post_begin
INTERNALERROR>     fn(options, file_config)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/plugin/plugin_base.py", line 466, in _engine_uri
INTERNALERROR>     cfg = provision.setup_config(
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/provision.py", line 101, in setup_config
INTERNALERROR>     cfg = config.Config.register(eng, db_opts, options, file_config)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/config.py", line 367, in register
INTERNALERROR>     cfg = Config(db, db_opts, options, file_config)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/config.py", line 338, in __init__
INTERNALERROR>     self.is_default_dialect = provision.is_preferred_driver(self, db)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/provision.py", line 73, in __call__
INTERNALERROR>     return self.fns["*"](cfg, *arg, **kw)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/testing/provision.py", line 228, in is_preferred_driver
INTERNALERROR>     )._get_entrypoint()
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 772, in _get_entrypoint
INTERNALERROR>     cls = registry.load(name)
INTERNALERROR>   File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.10/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 453, in load
INTERNALERROR>     raise exc.NoSuchModuleError(
INTERNALERROR> sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:exa
nox > Command coverage run -a --rcfile=/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/pyproject.toml -m pytest --dropfirst --db exasol-websocket /home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/test/integration/exasol failed with exit code 3
nox > Session test:exasol failed.