/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

4 votes191 views4 answers
Recursion python examples
Python
3 votes176 views2 answers
How to change value of categorical variable in python
Python
0 vote189 views1 answer
** (ArgumentError) lists in Phoenix.HTML and templates may only contain integers representing bytes, binaries or other lists, got invalid entry:
Python
0 vote188 views1 answer
Python detect warning
Python
0 vote188 views1 answer
How to get scrapy output file in xml file
Python
4 votes181 views2 answers
Pandas replace values with only whitespace to null
Python
0 vote189 views1 answer
How to update image in django
Python
0 vote182 views1 answer
Adding extra fields to user model django
Python
79 votes180 views6 answers
String reverse in python
Python
0 vote216 views1 answer
Get all subsets of a list python
Python