/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 vote246 views1 answer
Production mode flask
Python Flask
3 votes216 views1 answer
Default argument in flask route
Python Flask
0 vote220 views1 answer
Flask print request headers
Python Flask
0 vote253 views1 answer
Flask extends two base.html
Python Flask
3 votes233 views1 answer
How to make downloadable file in flask
Python Flask
0 vote278 views1 answer
Flask python use specified port
Python Flask
8 votes241 views3 answers
How to import flask
Python Flask
1 vote236 views2 answers
Python flask api
Python Flask
0 vote231 views2 answers
Call javascript function flask
Python Flask
3 votes222 views1 answer
Flask upload
Python Flask