/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 vote178 views1 answer
Python docx title
Python
0 vote169 views1 answer
1 12 123 python
Python
0 vote163 views1 answer
Python series get value
Python
0 vote134 views1 answer
Replace hour , minute, seconds in timestamp pandas
Python
0 vote198 views1 answer
Remove prefix in python 3.6
Python
0 vote169 views1 answer
Matlab find 2d index
Python
1 vote255 views2 answers
Flask print to console
Python Flask
0 vote180 views1 answer
Shorten all floats in a list
Python
1 vote163 views1 answer
Python practice questions on classes and objects
Python
2 votes165 views2 answers
Python obtain data from pandas dataframe without index name
Python