/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 votes116 views1 answer
What is a cube minus b cube
Python
13 votes153 views4 answers
Add column names to dataframe pandas
Python
-1 vote113 views1 answer
Create file in a specific directory python
Python
0 vote121 views1 answer
How to prit a certian in a list python
Python
0 vote138 views1 answer
Pytohn epsilon
Python
3 votes129 views1 answer
How to connect templates in django
Python
0 vote122 views1 answer
Download folder collab
Python
4 votes143 views2 answers
Matplotlib axes limits
Python
1 vote123 views1 answer
Python matplotlib hist set axis range
Python
95 votes137 views6 answers
Check if string contains python
Python