/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 votes429 views4 answers
Flask page
Python Flask
0 vote379 views1 answer
Flask google analytics
Python Flask
0 vote502 views1 answer
Import flask session
Python Flask
0 vote409 views1 answer
At=error code=h10 desc= app crashed python flask
Python Flask
3 votes408 views1 answer
How to make downloadable file in flask
Python Flask
0 vote380 views1 answer
Flask request post with json
Python Flask
1 vote407 views2 answers
Run flask in background
Python Flask
1 vote346 views1 answer
Flask run app reset on change
Python Flask
0 vote366 views1 answer
Flask multuple parameters
Python Flask
-1 vote362 views4 answers
Flask docs
Python Flask