Instance of 'SQLAlchemy' has no 'Column' member (no-member)

Question

I'm currently trying to implement steam login into website. But I'm unable to get pass this error within the code. I've created the database object but it keeps showing the error I mentioned earlier. I'm not sure whether SQLAlchemy has changed or what since I used it.

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)

The message emitted by pylint is

E1101: Instance of 'SQLAlchemy' has no 'Column' member (no-member)

Possible duplicate of [Pylint can't find SQLAlchemy query member](https://stackoverflow.com/questions/28193025/pylint-cant-find-sqlalchemy-query-member) — kod kristoff, Nov 22 '19 at 09:20

Aditya · Answer 1 · 2021-06-01T02:22:37.400

71

EDIT: After read and try np8's answer my previous answer is wrong there is a package you have to install, which is pylint_flask_sqlalchemy

so the answer will be

on your project directory find folder .vscode (if you dont have it, just create it) then create file settings.json and add this line

{
    # You have to put it in this order to make it works
    "python.linting.pylintArgs": [
        "--load-plugins",
        "pylint_flask_sqlalchemy",
        "pylint_flask",                 # This package is optional
    ]
}

You also need to have pylint-flask-sqlalchemy and if you want to use pylint-flask install on your current python environment:

pip install pylint-flask-sqlalchemy
pip install pylint-flask

edited Jun 01 '21 at 02:22

answered Feb 29 '20 at 13:44

Aditya

1,075
1
14
24

Thanks mate, I already had a .vscode/settings.json, just added this vars and worked like a charm... – Gerardo Rosciano Sep 11 '20 at 12:04
Thanks. it works. This answer should be mark as answer. – Derick Oct 27 '20 at 15:25
This cannot work. The load module contains dashes which will result in error. You are completely disabling pyling in vscode. – bmakan Oct 29 '20 at 07:17
1

Is this config missing a comma after `"pylint_flask_sqlalchemy"`? – Nick.Mc Nov 29 '20 at 00:30
For me, it's "pylint-flask-sqlalchemy". Works on Python 3.9. – ibnɘꟻ Jan 15 '21 at 02:50
`pylint_flask_sqlalchemy`, with underscores not dashes. – Jack Deeth Mar 12 '21 at 17:04

score 21 · Answer 2 · edited Nov 16 '19 at 06:19

21

pip install pylint-flask

In case of Visual Studio Code: Open File > Preferences > Settings > Edit in settings.json as below:

"python.linting.pylintArgs": ["--load-plugins", "pylint_flask"]

edited Nov 16 '19 at 06:19

simhumileco

31,877
16
137
115

answered Oct 10 '19 at 15:12

Ranjita Shetty

597
5
8

6

For me, this doesn't work, but the following line does: `"python.linting.pylintArgs": ["--load-plugins", "pylint-flask"]` – kod kristoff Nov 22 '19 at 09:04
1

For me, this only worked when I entered it into my user settings: Command Palette: Preferences: Open Settings (JSON) – Brian Jan 19 '20 at 20:02
I also had to enable `"python.jediEnabled": true,` in order for the pylint_flask plugin to properly figure out `scoped_session.add`, `scoped_session.commit` members. I'm not sure why. Perhaps because I have my language server set to "jedi" via `"python.languageServer": "Jedi",`. – waterproofpatch Jan 01 '21 at 16:49

score 19 · Answer 3 · answered Feb 28 '19 at 14:45

19

Open the Command Palette (Command+Shift+P on macOS and Ctrl+Shift+P on Windows/Linux) and type in one of the following commands:

Python: Select Linter

Switch from PyLint to flake8 or other supported linters.

answered Feb 28 '19 at 14:45

fill_J

459
5
13

5

This will hide the error but will is not a solution. Potential duplicate of this: https://stackoverflow.com/questions/28193025/pylint-cant-find-sqlalchemy-query-member – leecbaker May 23 '19 at 08:12

Niko Föhr · Answer 4 · 2020-07-27T09:56:37.637

Summary of working and non-working configurations

^{It seems that this can be configured so many ways incorrectly, that I decided to write the different options down. I am assuming VS Code, but for command line or other editor, arguments and their order is the same. These were tested using the latest versions of all the packages (list in the bottom of this post)}

Working versions

# What you'll need is pylint_flask_sqlalchemy
"python.linting.pylintArgs": ["--load-plugins", "pylint_flask_sqlalchemy"]

# You can add pylint_flask but only if it is *AFTER* pylint_flask_sqlalchemy
"python.linting.pylintArgs": ["--load-plugins", "pylint_flask_sqlalchemy", "pylint_flask"]

Non-working versions

# pylint_flask does not help, but can break it (see below)
"python.linting.pylintArgs": ["--load-plugins", "pylint_flask"]

# You can NOT add pylint_flask *BEFORE* pylint_flask_sqlalchemy
"python.linting.pylintArgs": ["--load-plugins", "pylint_flask", "pylint_flask_sqlalchemy"]

# CAUTION: These will disable pylint silently altogether!
# Do not use dash (-) but underscore (_)!
"python.linting.pylintArgs": ["--load-plugins", "pylint-flask-sqlalchemy", "pylint-flask"]
"python.linting.pylintArgs": ["--load-plugins", "pylint-flask"]
"python.linting.pylintArgs": ["--load-plugins", "pylint-flask-sqlalchemy"]

Details for those who are interested

pylint_flask_sqlalchemy

The pylint-flask-sqlalchemy¹ was created specifically to fix this². You can enable it by adding it to --load-plugins of pylint. In command line this would be

python -m pylint --load-plugins pylint_flash_sqlalchemy <mymodule.py>

and in VS Code (Settings (JSON)):

"python.linting.pylintArgs": ["--load-plugins", "pylint_flask_sqlalchemy"]

¹Also mirrored to GitHub: https://github.com/anybox/pylint_flask_sqlalchemy
²See this comment on pylint Issue tracker.

pylint_flask

pylint-flask is pylint plugin for Flask. It has nothing to do with Flask-SQLAlchemy and it does not even try to solve the false positive issues pylint has with Flask-SQLAlchemy³. The only possibility to use pylint-flask to "make the errors disappear" is to load it with erroneusly with dashes, which makes the whole pylint to be disabled.

It seems that pylint-flask must be loaded after pylint-flas-sqlalchemy; I tested with my setup, and for some reason

"python.linting.pylintArgs": ["--load-plugins", "pylint_flask", "pylint_flask_sqlalchemy"]

will not work, but

"python.linting.pylintArgs": ["--load-plugins", "pylint_flask_sqlalchemy", "pylint_flask"]

will. So the order of loading plugins matters.

^{³ See the code for yourself: pylint-flask source & pylint-flask-sqlaclhemy source}

Caution: Do not remove your linting accidentally

As the documentation of pylint-flask and pylint-flask-sqlalchemy says, the names in the argument --load-plugins should be written with underscores; If you use

"python.linting.pylintArgs": ["--load-plugins", "pylint-flask", "pylint-flask-sqlalchemy"]

in VS Code, the errors will be gone, but so will be all of your linting as the pylint crashes silently in the background.

Installing pylint-flask-sqlalchemy

pip install pylint-flask-sqlalchemy

Used versions

Flask                   1.1.2  
Flask-SQLAlchemy        2.4.4 
pylint                  2.5.3
pylint-flask            0.6
pylint-flask-sqlalchemy 0.2.0