/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 vote232 views1 answer
Trello class
Python
0 vote247 views1 answer
DJANGO model instance get by variable
Python Django
1 vote227 views2 answers
Python print utf-8
Python
0 vote222 views1 answer
How to create numpy array using two vectors
Python
2 votes239 views1 answer
Make a script run itself again python
Python
1 vote199 views2 answers
Np.argsort reverse
Python
0 vote223 views1 answer
1. write a program to multiply two numbers using function python
Python
39 votes197 views6 answers
Pyplot python
Python
0 vote179 views1 answer
Download textdocuments with python
Python
0 vote205 views3 answers
Pyqt message box set information text
Python