/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 vote119 views1 answer
Capitalize first word of a phrase in python
Python
15 votes128 views2 answers
Delete the duplicates in python
Python
0 vote113 views1 answer
Flask get uploaded file size
Python
0 vote202 views1 answer
Pandas calculate same day 3 months ago dateoffset
Python
1 vote133 views1 answer
Error popup in django not visible
Python Django
2 votes122 views3 answers
Insert numpy array to column
Python
3 votes120 views1 answer
Csrf token exempt django
Python
49 votes75 views3 answers
Web scraping python
Python
1 vote62 views3 answers
Python is float function
Python
5 votes119 views2 answers
Converting decimal to hex in python
Python