/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

9 votes278 views2 answers
Flask template
Python Flask
3 votes268 views1 answer
Default argument in flask route
Python Flask
4 votes211 views1 answer
Cannot import name 'flask' from partially initialized module 'flask' (most likely due to a circular import)
Python Flask
0 vote242 views1 answer
Mail.send_message flask not working, SSL ==> 465
Python Flask
1 vote248 views1 answer
Requirements.py for flask
Python Flask
0 vote243 views1 answer
Flask wtforms multiple select
Python Flask
0 vote256 views3 answers
Flask models
Python Flask
1 vote242 views1 answer
Requirements.txt flask
Python Flask
0 vote263 views2 answers
How to get value from txtbox in flask
Python Flask
12 votes275 views4 answers
Flask debug
Python Flask