/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

3 votes132 views3 answers
Flask migrate install
Python Flask
3 votes95 views1 answer
Display flask across network
Python Flask
0 vote136 views2 answers
How to get value from txtbox in flask
Python Flask
0 vote134 views1 answer
Flask decoding base 64 image
Python Flask
0 vote146 views1 answer
Import mongodatetime flask
Python Flask
0 vote148 views1 answer
PermissionError: [Errno 13] Permission denied on flask
Python Flask
1 vote131 views1 answer
Flask enumerate index
Python Flask
2 votes90 views2 answers
Flask hello world get
Python Flask
0 vote147 views1 answer
Flask read form data
Python Flask
1 vote148 views1 answer
Flask sending post request
Python Flask