/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 vote324 views1 answer
All objects and constants needed to use the ldap3 library can be imported from the ldap3 namespace
Python
0 vote306 views1 answer
What is a console in pythonanywhere
Python
1 vote324 views1 answer
Using-len-for-text-but-discarding-spaces-in-the-count
Python
1 vote314 views1 answer
Draw line from 2 mouse event in image python
Python
6 votes325 views5 answers
Python while True
Python
67 votes335 views6 answers
Open file python
Python
0 vote339 views1 answer
How to make every item compare the rest items of list in python
Python
0 vote318 views1 answer
Delete file in django terminal
Python
0 vote321 views1 answer
Python: Sending a variable to another script
Python
29 votes474 views3 answers
Django admin create project
Python Django