/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 vote324 views1 answer
Form valid django created by
Python
2 votes316 views1 answer
Pychamrfind and replace
Python
35 votes357 views6 answers
Python for in range
Python
0 vote327 views1 answer
Fibonacci series recursive python
Python
1 vote352 views1 answer
How to recurse a function
Python
0 vote338 views1 answer
Casting float value to an integer in Python
Python
-2 votes325 views1 answer
How to pass function parameter in decorator
Python
22 votes323 views2 answers
Python remove last element from list
Python
0 vote323 views1 answer
OfficeApi
Python
0 vote407 views1 answer
Twitter api ("Connection broken: Invalid Chunk Length(got length b'', 0 bytes read)"
Python