/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

29 votes327 views4 answers
Basic flask app python
Python Flask
0 vote295 views1 answer
Pycharm flask invalid or missing encoding declaration
Python Flask
0 vote292 views1 answer
Star rating form in flask
Python Flask
5 votes307 views1 answer
Flask boiler plate
Python Flask
0 vote265 views1 answer
Flask development mode
Python Flask
5 votes286 views3 answers
How to add images in hml while using flask
Python Flask
0 vote305 views1 answer
Save changes flask sqlalchemy
Python Flask
9 votes344 views2 answers
Flask template
Python Flask
0 vote283 views1 answer
Flask Upload file to local s3
Python Flask
4 votes317 views2 answers
Flask get variable from url
Python Flask