/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 votes200 views3 answers
Python grid
Python
0 vote203 views1 answer
Python dictionary get ket
Python
1 vote154 views1 answer
Pandas shift all columns
Python
1 vote196 views2 answers
How to download python freegames
Python
0 vote203 views1 answer
How to print out even index in python
Python
-1 vote204 views1 answer
Count true in a dataframe
Python
9 votes219 views2 answers
Make string numeric pandas
Python
0 vote240 views2 answers
Allow x_frame_options django
Python Django
10 votes224 views3 answers
Accessing element from csv file in python
Python
0 vote265 views1 answer
Python find closest value in list to zero
Python