/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 vote347 views1 answer
How to get the top 100 frequent words on a python dataframe colummn
Python
15 votes365 views6 answers
How to print
Python
46 votes345 views4 answers
Rename file python
Python
0 vote310 views2 answers
Python remove empty lines
Python
10 votes344 views3 answers
Fibonacci series python recursion
Python
5 votes361 views1 answer
Window size cv2
Python
1 vote341 views2 answers
Writer.writerow in python
Python
0 vote339 views1 answer
How to search dictionaryfor lowest value
Python
66 votes342 views6 answers
Python for loop index
Python
3 votes364 views1 answer
Annotation type of collection python
Python