/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

17 votes247 views4 answers
Flask render_template
Python Flask
0 vote210 views1 answer
Flask python use specified port
Python Flask
1 vote243 views1 answer
Flask blueprints
Python Flask
1 vote202 views4 answers
Flask activ environment
Python Flask
0 vote224 views1 answer
Flask stream with data/context
Python Flask
2 votes237 views3 answers
Run flask in debug mode
Python Flask
9 votes215 views2 answers
Flask flash
Python Flask
0 vote217 views2 answers
Call javascript function flask
Python Flask
1 vote157 views1 answer
Flask click submit button
Python Flask
0 vote212 views1 answer
Flask files not updating
Python Flask