/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 vote144 views1 answer
Liste in python
Python
0 vote131 views1 answer
Dateien mit modul requests herunterladen python
Python
2 votes142 views2 answers
Numpy count where
Python
0 vote108 views1 answer
Error: getaddrinfo ENOTFOUND www.python.org www.python.org:443 Downloading Python failed. Error: { Error: getaddrinfo ENOTFOUND www.python.org www.python.org:443
Python
91 votes153 views5 answers
How to delete file in python
Python
0 vote158 views1 answer
Custom pylatex command
Python
0 vote131 views1 answer
Tkinter change button text
Python
1 vote149 views1 answer
Add year to id django
Python
0 vote137 views1 answer
Load local data to django
Python
73 votes145 views6 answers
Reverse the string in python
Python