/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 vote304 views1 answer
Access data frame element by loc
Python
10 votes312 views3 answers
Python modulo
Python
0 vote305 views2 answers
Numpy roundup to nearest 5
Python
2 votes307 views1 answer
How to create a loop in python turtle
Python
0 vote308 views1 answer
Iterate last day of months python
Python
0 vote312 views1 answer
Series object has no attribute split
Python
1 vote301 views2 answers
Python string copy
Python
9 votes289 views6 answers
Python sort list
Python
-1 vote287 views2 answers
Percent to number python
Python
0 vote300 views1 answer
Append path to sys jupyter notebook
Python