/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 vote263 views1 answer
How to get images on flask page
Python Flask
4 votes196 views1 answer
Flask image
Python Flask
0 vote260 views2 answers
Where should favicon.ico be placed in flask app
Python Flask
6 votes240 views1 answer
Selectfield flask wtf
Python Flask
0 vote248 views1 answer
Flask migrate multiple heads
Python Flask
3 votes224 views3 answers
Flask migrate install
Python Flask
0 vote235 views1 answer
Flask buildspec.yml
Python Flask
14 votes287 views3 answers
Flask link stylesheet
Python Flask
2 votes254 views1 answer
Flask session timeout
Python Flask
6 votes240 views1 answer
Button in flask
Python Flask