/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

1 vote242 views1 answer
Remove all pyc files
Python
0 vote228 views1 answer
Python lvl up
Python
3 votes240 views1 answer
Drop all characters after a character in python
Python
-1 vote230 views2 answers
Decimal to octal in python
Python
0 vote238 views1 answer
Selection sort python
Python
0 vote238 views1 answer
Install pip with pacman linux
Python
5 votes267 views2 answers
How to reset username and password in django admin
Python Django
1 vote244 views1 answer
How does urllib.parse.urlsplit work in python
Python
0 vote235 views1 answer
Linux echo redirect output to python script
Python
0 vote263 views1 answer
Getting input from button python
Python