/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 vote251 views1 answer
Flask on gevent over https
Python Flask
1 vote302 views2 answers
Flask print to console
Python Flask
12 votes252 views6 answers
Flask
Python Flask
5 votes261 views1 answer
Flask boiler plate
Python Flask
0 vote233 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python Flask
3 votes257 views2 answers
Flask db migrate
Python Flask
2 votes235 views1 answer
How to redirect in flask to the same page
Python Flask
0 vote249 views2 answers
How to get value from txtbox in flask
Python Flask
0 vote266 views1 answer
Flask send email gmail
Python Flask
6 votes261 views1 answer
Selectfield flask wtf
Python Flask