/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

1 vote193 views1 answer
Create numpy table with random values in range
Python
-2 votes212 views1 answer
How to get data from django session
Python Django
0 vote188 views2 answers
How to round to 3 significant figures in python
Python
0 vote182 views1 answer
Tf.io path copy
Python
0 vote194 views1 answer
Choose a random snippet of text
Python
1 vote213 views1 answer
Set time complexity python
Python
0 vote251 views1 answer
Install reportlab python
Python
42 votes181 views4 answers
Pickle.dump python
Python
2 votes178 views1 answer
How to make python3.9 active
Python
0 vote201 views1 answer
How to return value in new record to odoo
Python