/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

75 votes176 views3 answers
ModuleNotFoundError: No module named 'pip._internal'
Python
-1 vote180 views1 answer
Can only use .dt accessor with datetimelike values
Python
0 vote165 views1 answer
AttributeError: 'DataFrame' object has no attribute '_data'?q=AttributeError: 'DataFrame' object has no attribute 'data'
Python
1 vote176 views1 answer
Insert data in django models
Python
0 vote205 views1 answer
Validationerror django params
Python Django
44 votes179 views4 answers
Choose random index from list python
Python
0 vote184 views1 answer
Import csv as dic
Python
2 votes187 views2 answers
Check multiple keys in python dict
Python
0 vote179 views2 answers
Turn list to string with commas python
Python
1 vote171 views2 answers
Datetime.time to seconds
Python