/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

6 votes179 views2 answers
Docker flask
Python Flask
0 vote189 views1 answer
Check if key exists in sesson python flask
Python Flask
0 vote176 views1 answer
Flask mongoengine getting started
Python Flask
1 vote233 views1 answer
Flask app route in different files
Python Flask
0 vote171 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python Flask
0 vote203 views1 answer
Flask extends two base.html
Python Flask
0 vote185 views1 answer
Dev.to flask heroku
Python Flask
8 votes197 views2 answers
Flask.pocoo.org quickstart
Python Flask
1 vote197 views1 answer
Flask set cookie
Python Flask
0 vote169 views1 answer
Linking bootstrap in flask
Python Flask