/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

2 votes362 views1 answer
Flask minimul app
Python Flask
1 vote357 views1 answer
How to config your flask for gmail
Python Flask
-1 vote356 views1 answer
Flask set mime type
Python Flask
0 vote360 views1 answer
Flask stream with data/context
Python Flask
0 vote346 views1 answer
From flask_paginate import get_page_parameter
Python Flask
1 vote366 views1 answer
Flask redirect to url
Python Flask
1 vote388 views1 answer
Flask send client to another web page
Python Flask
0 vote317 views1 answer
Python flask how to remove last character from string
Python Flask
1 vote344 views1 answer
Requirements.txt flask
Python Flask
10 votes382 views6 answers
Flask – Environment
Python Flask