/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

2 votes384 views1 answer
Flask for loops
Python Flask
1 vote371 views1 answer
Requirements.py for flask
Python Flask
0 vote364 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python Flask
1 vote398 views1 answer
Creating an apis with python and flask
Python Flask
0 vote425 views1 answer
How to set up flash message in html template in flask app
Python Flask
2 votes364 views1 answer
Flask import jsonify
Python Flask
0 vote431 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
0 vote366 views3 answers
Flask models
Python Flask
3 votes356 views3 answers
Flask migrate install
Python Flask
15 votes438 views6 answers
How to install flask
Python Flask