/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

1 vote219 views1 answer
Flask define template folder
Python Flask
4 votes139 views1 answer
Flask image
Python Flask
2 votes151 views2 answers
Flask hello world get
Python Flask
0 vote187 views1 answer
From flask import Flask app = Flask(__name__) @app.route('/',methods = ('GET')) def home(): return ('Hello World!!1') if __name__== '_main_': app.run()
Python Flask
0 vote198 views2 answers
Flask abort
Python Flask
1 vote138 views1 answer
Flask click submit button
Python Flask
0 vote209 views1 answer
Shutdown flask server with request
Python Flask
0 vote187 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python Flask
0 vote210 views1 answer
Disable console messages in Flask server
Python Flask
2 votes189 views1 answer
How to redirect in flask to the same page
Python Flask