/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 vote103 views1 answer
What is *args and **kwargs in django
Python
5 votes110 views2 answers
How to plot pie chart in python
Python
20 votes122 views6 answers
Python generate random password
Python
75 votes146 views6 answers
Working directory python
Python
0 vote104 views1 answer
Anaconda-navigator command not found
Python
2 votes110 views2 answers
Django-admin command not found
Python
1 vote113 views1 answer
Python program for swapping position of two numbers
Python
0 vote107 views1 answer
Go to line in python
Python
2 votes112 views1 answer
Python convert a string to a list of words
Python
13 votes111 views5 answers
Finding the maximum value in a list python
Python