/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

15 votes106 views2 answers
Is_integer() python
Python
1 vote151 views1 answer
How to get the live website html in python
Python
2 votes148 views1 answer
OPENCV GET CONTOURS
Python
31 votes254 views1 answer
Flask vs django
Python Django
3 votes154 views1 answer
Python read file in string list
Python
0 vote161 views1 answer
Copyfile pyhon
Python
2 votes201 views2 answers
List to tensor
Python
1 vote152 views1 answer
Formula for compounding interest in python
Python
0 vote159 views1 answer
Object creation using class constructor
Python
1 vote151 views1 answer
Argparse accept only few options
Python