/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 vote412 views1 answer
Flask get uploaded file size
Python Flask
0 vote406 views1 answer
Flask - store object directly in a session [duplicate]
Python Flask
0 vote470 views1 answer
Rebinding a list stored in a Flask Session
Python Flask
9 votes476 views2 answers
Flask how to run app
Python Flask
0 vote426 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 vote423 views1 answer
Why am i not able to import wtf flask
Python Flask
24 votes478 views3 answers
Flask vs django
Python Flask
5 votes388 views3 answers
How to add images in hml while using flask
Python Flask
1 vote343 views1 answer
Flask app route in different files
Python Flask
14 votes490 views3 answers
Flask link stylesheet
Python Flask