/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

5 votes265 views3 answers
ImportError: No module named flask
Python Flask
0 vote219 views1 answer
Flask python use specified port
Python Flask
0 vote204 views1 answer
Base64 python flask html
Python Flask
1 vote221 views1 answer
Flask clear session
Python Flask
1 vote252 views1 answer
How to get images on flask page
Python Flask
0 vote232 views1 answer
Why am i not able to import wtf flask
Python Flask
0 vote236 views1 answer
Flask stream with data/context
Python Flask
6 votes246 views4 answers
Flask get with parameters
Python Flask
5 votes242 views1 answer
Flask boiler plate
Python Flask
0 vote240 views1 answer
Gevent with flask
Python Flask