Usable with Pyright?

[chrisstpierre]

If this cannot be used with pyright (isntead of mypy), then what needs to happen so that it can be used with pyright?

[JukkaL]

Maybe somebody can give it a try and report your findings? None of the maintainers are familiar with pyright. At least functionality provided by the mypy plugin wouldn't be there, but the stubs might still be of some value.

[killthekitten]

Just to get it started: there are some mentions of sqlalchemy and sqlalchemy-stubs in the pyright issue tracker.

Most notable being:

• SQL Alchemy and pyright microsoft/pyright#626 suggests how to enable the VSCode plugin to look for types in libraries ("python.analysis.useLibraryCodeForTypes": true, is what you are looking for, the suggestion in the PR is deprecated) . I couldn't find a similar config for a CLI version of the tool, which can't pick it up automatically with error: Import "sqlalchemy" could not be resolved.
• Plugins OR mypy integration OR ideas for custom classes: Pydantic support microsoft/pyright#637 mentioning that support for mypy plugins in pyright is not possible.
• Property accessor hack for SQLAlchemy columns microsoft/pyright#444 suggesting to add sqlalchemy-stubs to the typingsPath config variable.

I haven't experimented with the config file so far, so I get a lot of import-related errors for the project that passes the checks with mypy.

From the first glance, with the pyright plugin enabled, the typechecks are not catching what they should.

I might be missing something, but it seems it can't pick up sqlalchemy-stubs out of the box.

[killthekitten]

It is simple to try it yourself:

npm install --global pyright
pyright --help

Then, do the usual:

pyright yourfile.py

[zeronone]

Just installing sqlalchemy-stubs worked for me.

From pyright docs (https://github.com/microsoft/pyright/blob/master/docs/import-resolution.md)

For a given package, try to resolve first using a stub package. Stub packages, as defined in PEP 561, are named the same as the original package but with “-stubs” appended.

[killthekitten]

@zeronone that's nice to hear! Could you elaborate which features worked for you? I'm concerned about plugins in the first place, i.e. this

sqlalchemy-stubs/sqlmypy.py

Line 292 in ea93332

def column_hook(ctx: FunctionContext) -> Type:

[zeronone]

Oh sorry, I misunderstood. Yes the plugins don't work. Only the basic inference works.