/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

8 votes385 views3 answers
How to import flask
Python Flask
6 votes316 views3 answers
Flask client ip
Python Flask
0 vote321 views1 answer
Flask admin forgeign keys show literal
Python Flask
0 vote361 views1 answer
Flask minimal install
Python Flask
0 vote323 views1 answer
PermissionError: [Errno 13] Permission denied on flask
Python Flask
15 votes392 views6 answers
Flask setup
Python Flask
1 vote278 views1 answer
Procfile for flask app
Python Flask
0 vote309 views1 answer
Flask gunicorn get ip
Python Flask
0 vote330 views1 answer
Supervisor gunicorn virtualenv flask
Python Flask
10 votes358 views6 answers
Flask – Environment
Python Flask