/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

0 vote145 views1 answer
Unable to import flask pylint
Python Flask
0 vote175 views1 answer
Flask put request example
Python Flask
1 vote230 views1 answer
Flask clear session
Python Flask
12 votes165 views6 answers
Flask
Python Flask
0 vote161 views1 answer
Flash not defined python flask
Python Flask
0 vote168 views2 answers
Flask upload file to s3
Python Flask
-1 vote150 views1 answer
Fro flask import Flask, request, render_template, url_for, redirect, session
Python Flask
23 votes282 views2 answers
Flask or django
Python Flask
4 votes160 views3 answers
How to change port in flask app
Python Flask
0 vote171 views2 answers
Flask api abort
Python Flask