/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 vote354 views1 answer
Import user model
Python
0 vote373 views1 answer
Getting the Current Working Directory in Python
Python
0 vote315 views1 answer
Flask restful api post example
Python
0 vote342 views1 answer
Find & replace in csv file
Python
6 votes406 views3 answers
Python print user input
Python
0 vote323 views1 answer
Python change all values in nested list
Python
0 vote347 views1 answer
Python invalid syntax for no reason
Python
0 vote315 views1 answer
Change one value based on another value in pandas
Python
4 votes324 views1 answer
What makes the bot talk? is there a word i have to say?
Python
0 vote336 views1 answer
Pandas change frequency of datetimeindex
Python