/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

18 votes290 views3 answers
Export flask app
Python Flask
0 vote198 views1 answer
Check if key exists in sesson python flask
Python Flask
1 vote203 views1 answer
How to get images on flask page
Python Flask
0 vote210 views1 answer
Flask wtforms multiple select
Python Flask
1 vote189 views3 answers
Python venv flask
Python Flask
3 votes179 views1 answer
Flask upload
Python Flask
0 vote198 views1 answer
How to install flask module in vscode
Python Flask
26 votes287 views6 answers
Flask run
Python Flask
0 vote182 views1 answer
Flask files not updating
Python Flask
4 votes132 views1 answer
Flask image
Python Flask