/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

9 votes229 views2 answers
Default flask app
Python Flask
-1 vote229 views1 answer
Flask run on ip and port
Python Flask
12 votes381 views6 answers
Python flask
Python Flask
0 vote259 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask
15 votes362 views6 answers
Install flask
Python Flask
2 votes240 views1 answer
Flask import jsonify
Python Flask
3 votes242 views2 answers
Flask db migrate
Python Flask
6 votes235 views2 answers
Get client ip flask
Python Flask
0 vote236 views1 answer
Star rating form in flask
Python Flask
8 votes231 views3 answers
How to import flask
Python Flask