/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

20 votes120 views6 answers
List input python
Python
0 vote120 views1 answer
Add legend to colorbar
Python
6 votes120 views1 answer
Python in godot
Python
6 votes121 views2 answers
Check if numpy arrays are equal
Python
1 vote123 views2 answers
Subtract from dataframe column
Python
0 vote136 views1 answer
Python replace accented characters code
Python
10 votes143 views1 answer
Python turtle
Python
4 votes118 views2 answers
Dataframe to tf data
Python
-1 vote122 views1 answer
Restricting user access to web pages
Python
8 votes124 views2 answers
Python local server command
Python