/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 vote157 views1 answer
SparkSession pyspark
Python
0 vote141 views1 answer
Compare input with list python
Python
2 votes143 views1 answer
Change pyplot dpi
Python
0 vote150 views1 answer
1*2*3*4*5*6* - print on console?by python
Python
0 vote132 views1 answer
Plot every nth label in barplot
Python
0 vote148 views1 answer
Bracket balanced or not in python
Python
8 votes120 views1 answer
Python find runtime
Python
0 vote177 views3 answers
User serializer in django rest framework
Python Django
0 vote135 views1 answer
Push notification using python
Python
1 vote200 views1 answer
Using bs4 to obtain html element by id
Python