/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 vote299 views2 answers
Graph data structure in python
Python
26 votes240 views5 answers
Display max rows pandas
Python
0 vote267 views1 answer
Delete df rows where column value = 0: mult col's
Python
1 vote253 views1 answer
For loop django template count
Python Django
4 votes225 views3 answers
How to make a button in python
Python
0 vote249 views1 answer
Import math print(m.cos(10))
Python
0 vote247 views1 answer
Opencv houghlines only horizontal
Python
0 vote223 views1 answer
Tensorflow not installing error
Python
0 vote260 views1 answer
Only get top 10 python dataframe
Python
0 vote247 views3 answers
Pandas pivot table
Python