/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

8 votes217 views2 answers
Show image jupyter notebook
Python
5 votes243 views4 answers
Turtle example in python
Python
0 vote215 views1 answer
Open link in tab new trong selenium python
Python
0 vote211 views1 answer
Python paragraph Pypi
Python
0 vote205 views1 answer
Discord.py find voice channel by name
Python
1 vote212 views1 answer
Numpy slice array into chunks
Python
9 votes208 views2 answers
Any in if python stack overflow
Python
0 vote241 views1 answer
Generate random numbers following Poisson distribution, Geometric Distribution, Uniform Distribution, and Normal Distribution, and plot them
Python
5 votes230 views3 answers
TypeError: sequence item 1: expected str instance, NoneType found
Python
0 vote201 views1 answer
How to set learning rate in keras
Python