/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

1 vote144 views1 answer
Pyo example
Python
3 votes155 views2 answers
Python execute bat file
Python
0 vote154 views1 answer
Transform image to rgb python
Python
0 vote143 views1 answer
Python dictionary get ket
Python
0 vote147 views1 answer
Python program to print prime numbers in an interval
Python
0 vote148 views1 answer
Df filter out rows that appear more than x times
Python
0 vote146 views1 answer
Break py
Python
4 votes177 views6 answers
Python or in if statement
Python
8 votes144 views6 answers
How to convert categorical data to numerical data in python
Python
3 votes136 views1 answer
Rotate picture in opencv2 python
Python