/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

3 votes207 views2 answers
Locale library python 3
Python
2 votes212 views1 answer
Matplotlib plot adjust margins
Python
0 vote191 views1 answer
Uppy tus
Python
0 vote207 views1 answer
Docker opencv python libGL.so.1: cannot open shared object file: No such file or directory
Python
1 vote201 views1 answer
How to remove microseconds from datetime in python
Python
0 vote191 views1 answer
Summation django queryset
Python
0 vote206 views1 answer
How to get the current line number in python
Python
0 vote200 views2 answers
Dice Roller in Python
Python
1 vote213 views4 answers
Get python script path
Python
0 vote196 views2 answers
Switching versions of python
Python