/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

2 votes265 views1 answer
Tk.destroy arguments
Python
1 vote271 views2 answers
Cv2 save video mp4
Python
0 vote251 views1 answer
Colorbar min max matplotlib
Python
0 vote306 views1 answer
Python install minio
Python
0 vote300 views2 answers
Python suppress exponential notation
Python
-2 votes252 views1 answer
Python IOError
Python
0 vote253 views1 answer
Pandas create column if equals
Python
3 votes284 views3 answers
Import flask
Python
25 votes269 views6 answers
Python online compiler
Python
8 votes277 views3 answers
Async sleep python
Python