/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

18 votes205 views3 answers
Tkinter make window not resizable
Python
0 vote181 views1 answer
Convert to date format
Python
2 votes213 views2 answers
Forrest Gump
Python
-2 votes271 views1 answer
Start django project in windows
Python Django
0 vote201 views1 answer
Python input character limit
Python
0 vote246 views1 answer
Python pil to greyscale
Python
0 vote302 views1 answer
Def f(x) python
Python
0 vote202 views1 answer
Root = tk.Tk() my_gui = App1(root)
Python
10 votes187 views5 answers
List of dict to dataframe
Python
17 votes177 views5 answers
Read data from csv python
Python