/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 vote194 views1 answer
Unable to import flask pylint
Python Flask
0 vote234 views1 answer
Form data postman don't work
Python
3 votes149 views1 answer
Smtplib login
Python
0 vote164 views1 answer
Python seaborn violin stack overflow
Python
3 votes175 views1 answer
How to close an application from python
Python
0 vote187 views1 answer
Pandas dataframe froms string
Python
3 votes184 views2 answers
Python element wise multiplication list
Python
1 vote159 views1 answer
Discord.py dm specific user
Python
2 votes171 views2 answers
Check if boolean is true python
Python
7 votes169 views2 answers
Mongodb aggregate count
Python