/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 vote180 views1 answer
Create array with unknown size in python
Python
0 vote196 views2 answers
Is login a class in python
Python
2 votes175 views1 answer
Death stranding
Python
0 vote177 views1 answer
Str to tuple of float
Python
0 vote179 views1 answer
Pygame do you need to use int() for positions
Python
7 votes173 views3 answers
Python print exception type and message
Python
0 vote192 views1 answer
How to detect language python
Python
0 vote165 views1 answer
Create app
Python
1 vote225 views1 answer
How to open cmd at specific location usng python
Python
1 vote201 views1 answer
How to kill tkinter
Python