/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 vote210 views1 answer
Flask decoding base 64 image
Python Flask
0 vote232 views1 answer
Flask echo server
Python Flask
1 vote283 views1 answer
Flask render error template
Python Flask
0 vote224 views1 answer
Flask sqlalchemy case insensitive like
Python Flask
1 vote212 views2 answers
Flask bootstrap
Python Flask
6 votes212 views4 answers
Flask get with parameters
Python Flask
0 vote235 views1 answer
Flask admin forgeign keys show literal
Python Flask
1 vote293 views2 answers
Simple flask hello world
Python Flask
9 votes221 views1 answer
Flask tutorials
Python Flask
4 votes158 views1 answer
Cannot import name 'flask' from partially initialized module 'flask' (most likely due to a circular import)
Python Flask