/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

-1 vote364 views1 answer
Flask set mime type
Python Flask
0 vote359 views1 answer
Flask put request example
Python Flask
0 vote337 views1 answer
Flask multuple parameters
Python Flask
0 vote358 views1 answer
Flask read form data
Python Flask
0 vote355 views1 answer
Flash not defined python flask
Python Flask
0 vote324 views1 answer
Python flask how to remove last character from string
Python Flask
0 vote340 views1 answer
Docker-compose.yml for flask celery rabbitmq
Python Flask
0 vote366 views2 answers
How to get value from txtbox in flask
Python Flask
1 vote366 views1 answer
Creating an apis with python and flask
Python Flask
0 vote324 views10 answers
Sqlite3 with flask web application CRUD pdf
Python Flask