/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 vote386 views1 answer
Check if key exists in sesson python flask
Python Flask
0 vote368 views1 answer
Disable console messages in Flask server
Python Flask
0 vote332 views1 answer
Flask download pandas dataframe as csv
Python Flask
6 votes378 views1 answer
Button in flask
Python Flask
0 vote423 views1 answer
Flask No application found. Either work inside a view function or push an application context
Python Flask
4 votes384 views1 answer
Render audio content without page view in flask
Python Flask
0 vote370 views1 answer
Can't import flask login
Python Flask
0 vote371 views1 answer
Linking bootstrap in flask
Python Flask
1 vote371 views1 answer
Flask api response code
Python Flask
34 votes422 views6 answers
Flask example
Python Flask