/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

3 votes259 views4 answers
Perfect numbers python
Python
0 vote268 views2 answers
Mechanize python #6
Python
24 votes237 views3 answers
Flask vs django
Python
0 vote239 views1 answer
Reg.fit(x_train, y_train) TypeError: fit() missing 1 required positional argument: 'y'
Python
1 vote264 views1 answer
Example of Single-line comment in Python
Python
43 votes238 views3 answers
Change the current working directory in python
Python
1 vote235 views2 answers
Multiple values in python loop for x,y
Python
1 vote258 views1 answer
Matplotlib show imaginary numbers
Python
0 vote244 views1 answer
How to handle missing values in dataset
Python
0 vote283 views1 answer
Django create ap
Python Django