/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

81 votes105 views6 answers
String to date python
Python
0 vote94 views1 answer
Is Cross policy an issue with puppeteer / headless chrome?
Python
14 votes101 views4 answers
Pandas get index of max value in column
Python
1 vote141 views1 answer
Django genericforeignkey null
Python Django
23 votes91 views6 answers
Check if a value is nan pandas
Python
0 vote120 views1 answer
PermissionError: [Errno 13] Permission denied on flask
Python
0 vote107 views1 answer
Python tar a directory
Python
26 votes112 views3 answers
Python string generator
Python
1 vote125 views1 answer
Django gmail smtp
Python Django
1 vote99 views1 answer
Set size of button tkinter
Python