/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

2 votes332 views1 answer
How to redirect in flask to the same page
Python Flask
1 vote323 views1 answer
Flask clear session
Python Flask
4 votes314 views2 answers
Flask arguments in url
Python Flask
1 vote356 views1 answer
Flask cors policy no 'access-control-allow-origin'
Python Flask
0 vote324 views1 answer
Python flask models user
Python Flask
1 vote305 views1 answer
Flask return error response
Python Flask
8 votes342 views2 answers
Flask.pocoo.org quickstart
Python Flask
6 votes378 views4 answers
Flask get with parameters
Python Flask
9 votes348 views2 answers
Flask how to run app
Python Flask
0 vote378 views1 answer
Problems with flask bootstrap
Python Flask