/Python/Flask/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 votes125 views1 answer
Video streaming flask
Python Flask
1 vote125 views1 answer
Flask redirect to url
Python Flask
0 vote120 views1 answer
Flask files not updating
Python Flask
1 vote149 views1 answer
Debug flask powershel
Python Flask
0 vote182 views1 answer
Flask request file push request(uploadedfile= request.file) uploadedfile.read()
Python Flask
15 votes211 views6 answers
Flask setup
Python Flask
0 vote135 views1 answer
Production mode flask
Python Flask
0 vote131 views1 answer
Flask remove file after send_file
Python Flask
0 vote142 views1 answer
Flask admin forgeign keys show literal
Python Flask
0 vote125 views1 answer
Flask session auto logout in 5 mins
Python Flask