/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

4 votes71 views2 answers
Check installed django version
Python Django
0 vote104 views1 answer
Jupyter notebook not opening
Python
0 vote161 views1 answer
Default stride value in keras
Python
0 vote133 views1 answer
Max value indices
Python
0 vote114 views1 answer
How to install packages offline? Ask Question
Python
0 vote101 views1 answer
Fibonacci in list python
Python
5 votes101 views4 answers
Pathlib get extension
Python
0 vote95 views1 answer
Mediafileupload python example
Python
0 vote109 views1 answer
Exec eval python
Python
-1 vote99 views1 answer
TypeError: 'tuple' object does not support item assignment
Python