/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

0 vote201 views1 answer
Python file back to beginning
Python
0 vote169 views1 answer
How to show installed tkinter fonts
Python
1 vote161 views1 answer
Flask authentication user without database
Python
0 vote168 views1 answer
Scrape email in a list from website python
Python
22 votes181 views6 answers
Python average
Python
0 vote164 views1 answer
If short for python
Python
1 vote180 views2 answers
Django get settings
Python
1 vote171 views1 answer
Python write text file on the next line
Python
0 vote163 views2 answers
Python downsampling
Python
0 vote210 views1 answer
Python returned non-zero exit status 1.
Python