/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

15 votes285 views3 answers
How to get the current year in python
Python
0 vote296 views1 answer
With open python print file name
Python
0 vote296 views1 answer
Simplest flask memcached
Python
1 vote286 views1 answer
Pandas find median of non zero values in a column
Python
1 vote373 views2 answers
How to get user id django
Python Django
-1 vote314 views3 answers
Try using .loc[row_indexer,col_indexer] = value instead
Python
31 votes290 views1 answer
Control tor browser with python
Python
26 votes316 views5 answers
Is_integer Python
Python
0 vote307 views1 answer
Except FileNotFoundError
Python
5 votes328 views2 answers
Python all lowercase letters
Python