/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 vote168 views1 answer
Remove occurence of character from string python
Python
3 votes185 views1 answer
Discord.py how to use permissions
Python
1 vote223 views1 answer
Python pickle save and load multiple variables
Python
-1 vote166 views1 answer
Receipt parsing
Python
5 votes176 views2 answers
Write in entry() in tkinter
Python
1 vote188 views2 answers
Where
Python
7 votes179 views2 answers
Cv2 load image
Python
0 vote169 views1 answer
Remove inner list from outer list python
Python
5 votes164 views1 answer
Python allowed variable caracters
Python
0 vote186 views1 answer
Dict itterator python recursive
Python