/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 vote249 views1 answer
Supervisor gunicorn virtualenv flask
Python Flask
0 vote209 views1 answer
Flask download pandas dataframe as csv
Python Flask
0 vote275 views1 answer
CACHE_TYPE flask
Python Flask
6 votes234 views3 answers
Flask cors
Python Flask
1 vote273 views1 answer
Flask enumerate index
Python Flask
2 votes252 views1 answer
Flask form
Python Flask
12 votes343 views4 answers
Flask debug
Python Flask
8 votes258 views2 answers
Flask.pocoo.org quickstart
Python Flask
0 vote251 views1 answer
Form is undefined flask
Python Flask
4 votes223 views2 answers
Flask arguments in url
Python Flask