/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 vote155 views1 answer
Round up
Python
0 vote168 views1 answer
Seaborn modificar o tamanho dos graficos
Python
0 vote111 views1 answer
Python get colorscale
Python
0 vote145 views1 answer
Get duplicate and remove but keep last in python df
Python
39 votes137 views6 answers
Python float precision
Python
0 vote155 views1 answer
Change x axis frequency
Python
0 vote148 views1 answer
Santhal paragana
Python
0 vote144 views1 answer
Python second interval
Python
-1 vote168 views1 answer
How to create templates in python
Python
0 vote149 views1 answer
Ros python service server
Python