/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 vote189 views1 answer
Name decorator in python
Python
4 votes212 views1 answer
Tkinter frame example
Python
0 vote191 views1 answer
Np.arange and np.linspace difference
Python
1 vote196 views1 answer
Somma in python
Python
30 votes190 views6 answers
How to create a superuser in django
Python
0 vote201 views1 answer
Python plot label value
Python
105 votes208 views2 answers
Create react-app
Python
3 votes212 views1 answer
Only keep few key value from dict
Python
0 vote183 views1 answer
Create table numpy
Python
1 vote193 views2 answers
How to print text in python
Python