/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 votes335 views4 answers
How to Copy a File in Python?
Python
4 votes388 views2 answers
Flask get variable from url
Python Flask
4 votes336 views2 answers
How to print time python
Python
0 vote312 views1 answer
Python array remove new element
Python
0 vote324 views1 answer
Set path for another directory
Python
0 vote310 views1 answer
Ec2 ssh terminal hangs after sometime
Python
2 votes331 views1 answer
Get stats from array
Python
0 vote309 views1 answer
Pandas set column to value using mask
Python
1 vote335 views1 answer
Minimum-number-of-steps-to-reduce-number-to-1
Python
22 votes372 views3 answers
How to stop the program in python
Python