/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
Off-by-one error in python
Python
1 vote152 views1 answer
How to find the mode using pandas groupby
Python
3 votes138 views2 answers
Multiple variable input in python
Python
4 votes188 views2 answers
How to get each digit of a number
Python
1 vote176 views1 answer
Log base 2 python
Python
71 votes145 views4 answers
Saving a pandas dataframe as a csv
Python
19 votes216 views1 answer
Python substring
Python
0 vote112 views1 answer
Parcours de graph en largeur
Python
0 vote144 views2 answers
How to get current page url in django template
Python
2 votes145 views3 answers
Python pandas difference between two data frames
Python