/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 vote187 views1 answer
Procfile flask
Python Flask
0 vote201 views1 answer
Flask get uploaded file size
Python Flask
1 vote181 views3 answers
Python venv flask
Python Flask
0 vote122 views1 answer
Flask download pandas dataframe as csv
Python Flask
0 vote187 views1 answer
Flask on gevent over https
Python Flask
1 vote208 views1 answer
Flask send client to another web page
Python Flask
2 votes372 views1 answer
Minimal flask application import
Python Flask
-1 vote178 views1 answer
Flask run on ip and port
Python Flask
7 votes185 views3 answers
Python flask access-control-allow-origin
Python Flask
0 vote267 views1 answer
Import flask session
Python Flask