/Python/SQLAlchemy Users to JSON code snippet

SQLAlchemy Users to JSON code snippet

@app.route('/results/')
def results():
    cols = ['id', 'url', 'shipping']
    data = Table.query.all()
    result = [{col: getattr(d, col) for col in cols} for d in data]
    return jsonify(result=result)

Source: stackoverflow.com

SQLAlchemy Users to JSON code snippet

@app.route('/results/')
def results():
    data = Table.query.all()
    result = [d.__dict__ for d in data]
    return jsonify(result=result)

Source: stackoverflow.com

Similar codes

1 vote229 views3 answers
How to get today weekday in python
Python
0 vote226 views2 answers
How to fix def multiply(a ,b): a*b
Python
2 votes218 views1 answer
How to check weather my model is on gpu in pytorch
Python
0 vote229 views1 answer
Python Split list into chunks using itertools Method
Python
2 votes214 views1 answer
Mulitplication symbo for unpacking in python
Python
20 votes216 views6 answers
List input python
Python
0 vote234 views1 answer
Python set day of date to 1
Python
0 vote234 views4 answers
Comprehension list iloc pandas
Python
35 votes210 views2 answers
How to do the sum of list in python
Python
-1 vote211 views1 answer
Python key
Python