/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 vote278 views1 answer
List object attributes python
Python
1 vote254 views1 answer
For loop counting down python
Python
1 vote278 views3 answers
Convert timedelta to days
Python
1 vote260 views1 answer
Import open3d Illegal instruction (core dumped)
Python
0 vote292 views1 answer
Numpy add
Python
0 vote259 views1 answer
Python one line key increment or add
Python
9 votes280 views1 answer
Except as Exception:
Python
0 vote255 views3 answers
Captcha.image install in python
Python
1 vote285 views1 answer
Random question generator python
Python
0 vote265 views2 answers
Numpy reg ex delete words before a specific character
Python