/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 votes104 views3 answers
What is input function in python
Python
0 vote138 views1 answer
Autopy in python install
Python
0 vote135 views1 answer
Pandas continues update csv with exception
Python
-1 vote231 views1 answer
Matplotlib unable agg
Python
14 votes152 views1 answer
Filter list with python
Python
0 vote149 views1 answer
Dictionary Loop thru a dictionary's keys.
Python
17 votes94 views5 answers
Read data from csv python
Python
7 votes176 views1 answer
Change value in pandas dataframe cell
Python
0 vote136 views1 answer
Plt.hist using bins
Python
0 vote170 views1 answer
How to draw a square pygame
Python