/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 vote151 views1 answer
Python how to delete from dictionary a nan key
Python
0 vote108 views1 answer
Data where values in column starts with particular value
Python
0 vote101 views1 answer
Pandas df filter by time hour
Python
0 vote105 views1 answer
Python close a socket
Python
0 vote136 views1 answer
Hostname python
Python
0 vote113 views1 answer
Change value in excel in python
Python
0 vote118 views3 answers
Python remove text between parentheses
Python
0 vote134 views1 answer
Python split clever looping
Python
147 votes113 views6 answers
Python if file exists
Python
43 votes114 views5 answers
Pandas iterrows
Python