/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 vote211 views1 answer
Get element from string with deliminator python
Python
3 votes250 views1 answer
Python list to tensor
Python
0 vote217 views1 answer
Jupyter notebook fancy print cross tab
Python
0 vote262 views1 answer
Set header in dataframe 2nd line
Python
0 vote208 views1 answer
Python create unreadable save file
Python
0 vote211 views1 answer
Resize image array python
Python
0 vote200 views1 answer
Load png to python
Python
-1 vote207 views1 answer
Create file in a specific directory python
Python
1 vote180 views1 answer
Change axis and axis label color matplotlib
Python
0 vote237 views1 answer
Module 'networkx' has no attribute 'graphviz_layout'
Python