/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 vote261 views1 answer
Python app to deb
Python
7 votes240 views3 answers
How to add multiple commands to tkinter button
Python
-1 vote230 views1 answer
Python data first column indices
Python
33 votes231 views2 answers
Find a largest number in function list python
Python
13 votes251 views2 answers
Ipykernel install
Python
0 vote250 views1 answer
Check if file already existing
Python
-2 votes246 views9 answers
Django
Python Django
-1 vote253 views1 answer
How to remove last character from a list in python
Python
10 votes307 views5 answers
Zip python
Python
0 vote250 views1 answer
How to type using selenium python
Python