/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 vote233 views1 answer
Scrape email in a list from website python
Python
1 vote234 views5 answers
Delete csr python
Python
0 vote243 views1 answer
Python add new line from textarea
Python
0 vote226 views2 answers
Python list to string with spaces
Python
81 votes240 views6 answers
Python write to file
Python
0 vote211 views1 answer
Python sys.argv exception
Python
57 votes319 views6 answers
How to make a class in python
Python
15 votes251 views3 answers
Python flask sample application
Python
0 vote232 views2 answers
Convert pdf folder to excell pandas
Python
2 votes237 views2 answers
Choice random word in python from a text file
Python