/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 vote308 views2 answers
Install cairo python
Python
0 vote295 views1 answer
Pyplot new figure
Python
0 vote327 views1 answer
No module named 'flask_jwt_extended'
Python Flask
4 votes305 views1 answer
Format python limit to {:2f}
Python
3 votes282 views2 answers
How to add numbers into a list python
Python
0 vote313 views1 answer
Python print n numbers
Python
0 vote269 views1 answer
Json url to dataframe python
Python
7 votes259 views3 answers
Python print exception type and message
Python
0 vote269 views1 answer
Change variable type python
Python
1 vote295 views1 answer
Python convert file into list
Python