/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

9 votes272 views2 answers
Import numpy python
Python
1 vote315 views1 answer
Unix command in python script
Python
4 votes294 views3 answers
Pip clear cache command
Python
1 vote221 views1 answer
Append array to array python
Python
0 vote281 views1 answer
Print python reverse list
Python
1 vote274 views2 answers
Python read and write pdf data
Python
0 vote279 views3 answers
Python thread exception
Python
0 vote257 views1 answer
Python can't find text file
Python
0 vote252 views1 answer
Manytomany django add bulk create
Python
0 vote305 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python Flask