[FIXED] Why does mypy does not work with sqlalchemy?

Issue

I have the following code (snippet):

from sqlalchemy.orm import declarative_base

Base = declarative_base()

with pip I installed

$ pip install -U sqlalchemy[mypy] sqlalchemy-stubs mypy
$ pip list | egrep -i '(sqlal|mypy)'
mypy                          0.982
mypy-extensions               0.4.3
SQLAlchemy                    1.4.42
sqlalchemy-stubs              0.4
SQLAlchemy-Utils              0.38.3
sqlalchemy2-stubs             0.0.2a29

Still, when running mypy file.py, I'm getting:

$ python3 -mmypy test.py 
test.py:1: error: Module "sqlalchemy.orm" has no attribute "declarative_base"
Found 1 error in 1 file (checked 1 source file)

I'm using Python 3.10.5 from within a virtualenv.

What can I do to debug more?

Solution

I think its a problem of sqlalchemy.

sqlalchemy.ext.declarative package is now integrated into the sqlalchemy.orm namespace

https://docs.sqlalchemy.org/en/14/changelog/migration_14.html#change-5508

Seems like its not working correctly with mypy, but I didnt dig deeper.

It is working fine, when I import declarative_base "the old way" like this:

from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

Answered By - bitflip