/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 votes267 views3 answers
Flask cors
Python Flask
0 vote281 views2 answers
Install socketio flask
Python Flask
2 votes307 views1 answer
Run flask application in development mode stack overflow
Python Flask
0 vote285 views2 answers
Flask socket io
Python Flask
0 vote286 views1 answer
Form is undefined flask
Python Flask
3 votes286 views1 answer
Default argument in flask route
Python Flask
0 vote290 views1 answer
Flask extends two base.html
Python Flask
1 vote299 views1 answer
Delete a record by id in flask sqlalchemy
Python Flask
0 vote310 views1 answer
Flask minimal install
Python Flask
1 vote219 views1 answer
Flask app route in different files
Python Flask