/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 vote168 views1 answer
Error: The file/path provided (flaskr) does not appear to exist. Please verify the path is correct. If app is not on PYTHONPATH, ensure the extension is .py
Python Flask
6 votes171 views2 answers
Flask get ip address of request
Python Flask
1 vote184 views1 answer
Flask set cookie
Python Flask
6 votes181 views3 answers
Flask get ip of user
Python Flask
9 votes171 views2 answers
Flask how to run app
Python Flask
0 vote173 views1 answer
Dev.to flask heroku
Python Flask
0 vote169 views1 answer
Can't import flask login
Python Flask
18 votes257 views5 answers
Flask minimal app
Python Flask
0 vote190 views1 answer
Flask buildspec.yml
Python Flask
9 votes217 views2 answers
Flask flash
Python Flask