How to fix: AttributeError: 'MySQLDialect_pymysql' object has no attribute 'case_sensitive'

[0106WeiWeiDeng]

Hi, all

I run the following code:

from aiomysql.sa import create_engine
import asyncio

async def go():
    engine = await create_engine(
        user="user",
        db="db",
        host="localhost",
        password="passwd",
    )
    async with engine.acquire() as conn:
        res = await conn.execute("SELECT * FROM user;")
        row = await res.fetchone()
        print(row["name"])
    engine.close()
    await engine.wait_closed()

asyncio.run(go())

but an error occurs, the error info is:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/asyncio/runners.py", line 44, in run
    return loop.run_until_complete(main)
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/asyncio/base_events.py", line 647, in run_until_complete
    return future.result()
  File "<stdin>", line 9, in go
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/site-packages/aiomysql/sa/connection.py", line 179, in _execute
    ret = await create_result_proxy(
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/site-packages/aiomysql/sa/result.py", line 14, in create_result_proxy
    await result_proxy._prepare()
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/site-packages/aiomysql/sa/result.py", line 250, in _prepare
    self._metadata = ResultMetaData(self, cursor.description)
  File "/home/deng/miniconda3/envs/shaoxia/lib/python3.9/site-packages/aiomysql/sa/result.py", line 116, in __init__
    assert dialect.case_sensitive, \
AttributeError: 'MySQLDialect_pymysql' object has no attribute 'case_sensitive'

MySQL version: 8.0.29
System: Ubuntu 22.04 LTS
Python: 3.9.16
aiomysql: 0.1.1
PyMySQL: 1.0.2
SQLAlchemy: 2.0.5.post1

Does anyone has a clue to fix the error? Thanks in advance!

[0106WeiWeiDeng]

Additional info: when I use SQLAlchemy to connect mysql and excute SQLs, no error occurs!

[0106WeiWeiDeng]

Additional info: use aiomysql to connect mysql and excute SQLs, no error occurs.

[0106WeiWeiDeng]

just delete two line of code in aiomysql/sa/result.py, the code works fine! The code info:

aiomysql/aiomysql/sa/result.py

Line 116 in bb8697d

assert dialect.case_sensitive, \

aiomysql/aiomysql/sa/result.py

Line 117 in bb8697d

"Doesn't support case insensitive database connection"

[jurschreuder]

Is there a way to fix this without changing the library files? Else other developers cannot just pip install it anymore.

[0106WeiWeiDeng]

It seems like that aiomysql.sa module has not been updated for a long time, I think maintainers should fix this error...

[Nothing4You]

SQLAlchemy 2.0 is not yet supported, unfortunately we don't even support 1.4 yet.
See #818

[0106WeiWeiDeng]

oh, SQLAlchemy is a popular and convenient library, and aio-mysql has asyncio features. aiomysql.sa module is a very nice one which combined them together! I would appreciate it very much if this model can get updates.