/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

6 votes132 views6 answers
Change date format python
Python
0 vote131 views1 answer
Max(X_train, key=len).split()
Python
-2 votes160 views1 answer
OpenCV: FFMPEG: tag 0x4745504d/'MPEG' is not supported with codec id 2 and format 'mp4 / MP4 (MPEG-4 Part 14)'
Python
0 vote156 views1 answer
Python fibonacci series (Recursion)
Python
0 vote123 views2 answers
Numpy index of first true value
Python
39 votes123 views6 answers
Python generate requirements.txt
Python
1 vote139 views1 answer
How to urllib3
Python
2 votes130 views2 answers
ValueError: Shapes (None, 1) and (None, 11) are incompatible keras
Python
0 vote135 views1 answer
Oop - Apa metaclasses di Python
Python
3 votes141 views2 answers
How to import a variable from another python file
Python