/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

-2 votes302 views3 answers
Count substring in string python
Python
19 votes337 views2 answers
Python datetime string
Python
0 vote362 views1 answer
Can't import flask login
Python Flask
55 votes338 views4 answers
List len python
Python
0 vote337 views1 answer
All Combinations
Python
0 vote301 views1 answer
Timeout python
Python
1 vote343 views1 answer
R2 score sklearn
Python
0 vote297 views1 answer
500 dollars to naira
Python
0 vote293 views1 answer
The process of delivery of any desisered data
Python
0 vote315 views1 answer
A int and float. python
Python