/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 vote175 views1 answer
Df select custom index
Python
12 votes165 views3 answers
Python efficiently find duplicates in list
Python
0 vote191 views1 answer
Non venomous snakes
Python
19 votes188 views1 answer
Change list to int in python
Python
0 vote162 views1 answer
Query json array
Python
22 votes198 views7 answers
Remove special characters from string python
Python
0 vote166 views1 answer
Import pygame module in pycharm
Python
1 vote199 views8 answers
Fadaei
Python
0 vote166 views1 answer
Caqch làm app chatbot python
Python
0 vote339 views1 answer
Deep copy a dataframe
Python