/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

0 vote111 views1 answer
Hover 777-286
Python
0 vote116 views1 answer
Max sum slice python 1 - autopilot
Python
1 vote121 views1 answer
A list inside a list python
Python
1 vote128 views1 answer
Django loop index
Python Django
7 votes115 views3 answers
Sum of a numpy array
Python
6 votes145 views4 answers
Code fibonacci python
Python
-1 vote142 views1 answer
Count duplicates in one column pandas
Python
0 vote122 views1 answer
If function has no argument python
Python
26 votes121 views2 answers
Python time library
Python
-1 vote92 views2 answers
Model deployment with flask
Python Flask