/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 vote135 views1 answer
Flask files not updating
Python Flask
0 vote181 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask
0 vote160 views1 answer
Disable console messages in Flask server
Python Flask
0 vote157 views1 answer
Quill get content flask
Python Flask
0 vote159 views1 answer
Flask admin forgeign keys show literal
Python Flask
23 votes262 views6 answers
Flask getting started
Python Flask
1 vote176 views1 answer
Flask send client to another web page
Python Flask
0 vote153 views1 answer
Flask migrate multiple heads
Python Flask
-2 votes150 views1 answer
Jwt authentication python flask
Python Flask
0 vote144 views1 answer
How to import flask restful using pip
Python Flask