/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

1 vote155 views1 answer
Procfile for flask app
Python Flask
15 votes344 views6 answers
Install flask
Python Flask
0 vote229 views1 answer
Open a python script on click flask
Python Flask
2 votes164 views2 answers
Flask hello world get
Python Flask
0 vote232 views1 answer
Setting flask app environment variable
Python Flask
1 vote274 views2 answers
Simple flask hello world
Python Flask
1 vote153 views1 answer
Flask click submit button
Python Flask
0 vote226 views1 answer
Shutdown flask server with request
Python Flask
0 vote210 views1 answer
Flask No application found. Either work inside a view function or push an application context
Python Flask
0 vote227 views1 answer
Flask put request example
Python Flask