/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

22 votes268 views4 answers
Join two numpy arrays
Python
32 votes346 views6 answers
Get list of folders in directory python
Python
1 vote290 views1 answer
How to remove b in front of python string
Python
1 vote309 views1 answer
'charmap' codec can't decode byte 0x98 in position
Python
0 vote302 views1 answer
Python plot axis labels
Python
1 vote264 views1 answer
Get attribute in selenium python
Python
1 vote307 views3 answers
Accessing data on django sessionstore
Python
15 votes288 views2 answers
How to get user ip in python
Python
1 vote285 views1 answer
Django clear db
Python
1 vote278 views1 answer
Compute mfcc python
Python