/Python/Flask/Flask sqlalchemy query specific columns

Flask sqlalchemy query specific columns

## You can use the with_entities() method to restrict which columns you'd like to return in the result. (documentation)

result = SomeModel.query.with_entities(SomeModel.col1, SomeModel.col2)

## Depending on your requirements, you may also find deferreds useful. They allow you to return the full object but restrict the columns that come over the wire.

Source: stackoverflow.com

Similar codes

0 vote158 views2 answers
Error: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable, and a "wsgi.py" or "app.py" module was not found in the current directory.
Python Flask
0 vote155 views1 answer
At=error code=h10 desc= app crashed python flask
Python Flask
0 vote167 views2 answers
Where should favicon.ico be placed in flask app
Python Flask
0 vote151 views2 answers
Flask conditional according to urrl
Python Flask
1 vote198 views1 answer
Requirements.txt flask
Python Flask
0 vote152 views1 answer
Flask print request headers
Python Flask
3 votes174 views2 answers
Install flask on linux mint for python3
Python Flask
2 votes112 views2 answers
Flask hello world get
Python Flask
0 vote144 views1 answer
How to return an html file in flask
Python Flask
1 vote162 views1 answer
Hot reloading flask
Python Flask