/Python/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 vote314 views1 answer
Scrapy pass string as html
Python
0 vote326 views1 answer
Python tabulate print only one row
Python
-1 vote315 views1 answer
How to fix speech recognition in python
Python
3 votes342 views3 answers
NameError: name ‘pd’ is not defined
Python
1 vote313 views1 answer
Count number of repeats in list python
Python
1 vote289 views1 answer
Download images python google
Python
1 vote300 views1 answer
Import scipy python
Python
0 vote340 views1 answer
Adding text on barplot using seabron
Python
3 votes324 views2 answers
Title() function in python
Python
0 vote340 views1 answer
Openign in browser python
Python