/Python/Flask/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 vote373 views1 answer
Use mark down with flask
Python Flask
1 vote412 views2 answers
Run flask app windows
Python Flask
6 votes385 views1 answer
Button in flask
Python Flask
6 votes368 views3 answers
Flask client ip
Python Flask
0 vote383 views1 answer
Import mongodatetime flask
Python Flask
4 votes360 views1 answer
Video streaming flask
Python Flask
0 vote354 views2 answers
Get request header flask
Python Flask
0 vote383 views1 answer
Flask migrate multiple heads
Python Flask
15 votes460 views6 answers
Flask setup
Python Flask
1 vote393 views1 answer
How to create routes in flask
Python Flask