/Python/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 votes267 views3 answers
Steps in for loop python
Python
0 vote275 views1 answer
'}'
Python
30 votes286 views3 answers
Pandas add a total row to dataframe
Python
1 vote241 views1 answer
Print last output python
Python
47 votes282 views6 answers
Random float python
Python
1 vote276 views1 answer
Discord.py owner only commands
Python
0 vote288 views1 answer
Heroku how to access config vars django
Python
0 vote302 views1 answer
Pandas resamples stratified by columns values
Python
53 votes343 views3 answers
Add key to dictionairy
Python
0 vote271 views2 answers
Flask abort
Python