/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 vote133 views1 answer
Max sum slice python 5 - autopilot
Python
0 vote139 views1 answer
Crawling emails with python
Python
0 vote193 views1 answer
Python Entry default text
Python
0 vote156 views3 answers
Python ascii to string
Python
0 vote139 views1 answer
Python console
Python
1 vote187 views1 answer
Flask error f = open(f'{getcwd()}/haikus/{haiku}',"r") ^ SyntaxError: invalid syntax
Python Flask
0 vote142 views1 answer
Ajouter élément liste python
Python
0 vote134 views1 answer
Python - merge and incluse only specific columns
Python
11 votes129 views1 answer
Python discord
Python
1 vote157 views1 answer
How to open dialog box to select folder in python
Python