asyncpgsa icon indicating copy to clipboard operation
asyncpgsa copied to clipboard

Since 2.0 sqlalchemy doesn't support py-postgresql. Unavailable to use library: ImportError

Open mixa2130 opened this issue 1 year ago • 0 comments

Hello! Today I've installed asyncpgsa==0.27.1 which in turn installed asyncpg==0.27.0 In project I have sqlalchemy==2.0.9 When I'm doing basic import asyncpgsa get error

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/gree/PycharmProjects/web_api/venv/lib/python3.10/site-packages/asyncpgsa/__init__.py", line 1, in <module>

    from .pool import create_pool
  File "/home/gree/PycharmProjects/web_api/venv/lib/python3.10/site-packages/asyncpgsa/pool.py", line 6, in <module>

    from .connection import SAConnection as _SAConnection
  File "/home/gree/PycharmProjects/web_api/venv/lib/python3.10/site-packages/asyncpgsa/connection.py", line 3, in <module>

    from sqlalchemy.dialects.postgresql import pypostgresql
ImportError: cannot import name 'pypostgresql' from 'sqlalchemy.dialects.postgresql'

According sqlalchemy 2.0 docs pypostgresql dialecrt is no longer supported and was deleted

mixa2130 avatar Apr 22 '23 12:04 mixa2130