/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

1 vote224 views1 answer
Python screen recorder
Python
-1 vote216 views2 answers
Dataframe multiindex
Python
17 votes230 views6 answers
Install flask
Python
186 votes243 views6 answers
Pip upgrade command
Python
0 vote238 views1 answer
Best scraping package in python
Python
1 vote246 views1 answer
Count number of zeros in a number python
Python
6 votes216 views1 answer
Django desc order
Python
-2 votes239 views2 answers
Python program to find n prime numbers
Python
0 vote212 views1 answer
Pandas read csv skip until expression found
Python
6 votes218 views2 answers
Check if numpy arrays are equal
Python