/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 vote203 views1 answer
Python euler
Python
0 vote201 views1 answer
Youtube bot python
Python
13 votes195 views2 answers
How to install python libraries
Python
0 vote198 views1 answer
Is complex datatype immutable in python
Python
1 vote201 views1 answer
Bytes-like object
Python
1 vote171 views1 answer
How to print 69 in python
Python
0 vote291 views1 answer
Generate 50 characters long for django
Python Django
3 votes208 views2 answers
UnboundLocalError: local variable
Python
0 vote180 views1 answer
Add a third dimension matrix dataset python
Python
0 vote192 views1 answer
Countplot for different classes in a column
Python