/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 vote212 views2 answers
Error: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable, and a "wsgi.py" or "app.py" module was not found in the current directory.
Python Flask
0 vote195 views1 answer
Flask read form data
Python Flask
8 votes227 views3 answers
How to import flask
Python Flask
0 vote186 views1 answer
Flask echo server
Python Flask
4 votes213 views2 answers
Flask get variable from url
Python Flask
1 vote209 views1 answer
Delete a record by id in flask sqlalchemy
Python Flask
0 vote178 views1 answer
Flask wtforms multiple select
Python Flask
1 vote181 views2 answers
Flask console log
Python Flask
27 votes207 views4 answers
Flask tutorial
Python Flask
1 vote218 views1 answer
Flask blueprints
Python Flask