/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

5 votes469 views3 answers
How to run flask in port 80
Python Flask
1 vote344 views1 answer
Flask form errors
Python Flask
0 vote376 views2 answers
Flask conditional according to urrl
Python Flask
0 vote359 views1 answer
Use mark down with flask
Python Flask
0 vote344 views1 answer
Flask multuple parameters
Python Flask
0 vote374 views1 answer
At=error code=h10 desc= app crashed python flask
Python Flask
2 votes363 views1 answer
Flask for loops
Python Flask
0 vote389 views2 answers
Flask lazy response style with `make_response`
Python Flask
1 vote400 views1 answer
Flask cors policy no 'access-control-allow-origin'
Python Flask
0 vote371 views1 answer
Flask sqlalchemy case insensitive like
Python Flask