/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 vote253 views1 answer
Can't import flask login
Python Flask
1 vote248 views1 answer
Flask redirect to url
Python Flask
14 votes279 views6 answers
What is flask
Python Flask
0 vote233 views1 answer
PermissionError: [Errno 13] Permission denied on flask
Python Flask
0 vote203 views1 answer
Flask current_app config
Python Flask
1 vote270 views1 answer
Flask sending post request
Python Flask
2 votes272 views3 answers
Run flask in debug mode
Python Flask
0 vote209 views1 answer
Python flask how to remove last character from string
Python Flask
14 votes298 views3 answers
Flask link stylesheet
Python Flask
1 vote240 views1 answer
Procfile flask
Python Flask