/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

15 votes343 views3 answers
Python flask sample application
Python Flask
0 vote250 views1 answer
Flask remove file after send_file
Python Flask
0 vote226 views1 answer
Import mongodatetime flask
Python Flask
0 vote263 views1 answer
Flask recive list
Python Flask
-2 votes241 views1 answer
Jwt authentication python flask
Python Flask
14 votes371 views3 answers
Flask link stylesheet
Python Flask
6 votes227 views2 answers
Flask get ip address of request
Python Flask
0 vote244 views1 answer
Set environment variable flask app
Python Flask
1 vote167 views1 answer
Flask click submit button
Python Flask
-1 vote225 views1 answer
Flask run on ip and port
Python Flask