/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 vote121 views1 answer
Pytohn reset all dictionary values to 0
Python
0 vote118 views1 answer
Python convert png to jpg
Python
0 vote134 views1 answer
Pip install dal
Python
8 votes123 views2 answers
Windows 10 python path
Python
0 vote132 views1 answer
Add vertical line to horizontal graph
Python
1 vote161 views1 answer
How to restart loop python
Python
0 vote127 views1 answer
Longueur array python
Python
0 vote133 views1 answer
Docstrinfs pyt
Python
0 vote132 views1 answer
How to apply labelencoder on multiple columns at once
Python
0 vote97 views1 answer
How to use spacy
Python