/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 vote145 views1 answer
Flask new response style with `make_response`
Python Flask
0 vote231 views1 answer
Flask request file upload to dropbox
Python Flask
0 vote183 views1 answer
Change form type flask from text to selection flask admin
Python Flask
0 vote184 views2 answers
Flask api abort
Python Flask
14 votes280 views3 answers
Flask link stylesheet
Python Flask
0 vote166 views1 answer
Last executed query in flask api
Python Flask
4 votes115 views1 answer
Flask image
Python Flask
1 vote206 views1 answer
Flask render error template
Python Flask
0 vote173 views1 answer
Flask No application found. Either work inside a view function or push an application context
Python Flask
0 vote210 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask