/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

0 vote197 views1 answer
Flask windows auto reload
Python Flask
0 vote214 views1 answer
Get flask version
Python Flask
0 vote193 views1 answer
From flask_paginate import get_page_parameter
Python Flask
0 vote213 views1 answer
Set allowed methods flask
Python Flask
0 vote203 views1 answer
Flask return 404
Python Flask
0 vote194 views1 answer
Python update flask
Python Flask
0 vote214 views1 answer
Flask remove file after send_file
Python Flask
1 vote239 views2 answers
Run flask app windows
Python Flask
0 vote186 views1 answer
Can't import flask login
Python Flask
4 votes196 views1 answer
Render audio content without page view in flask
Python Flask