/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 vote113 views1 answer
How to get the percentage accuracy of a model in python
Python
5 votes114 views1 answer
Convert jupyter notebook to python cmd line
Python
0 vote118 views2 answers
Fix ImportError: No module named PIL
Python
1 vote120 views2 answers
What is the ternary operator in python
Python
107 votes117 views6 answers
Python split
Python
2 votes70 views1 answer
Check for missing dates pandas with hours
Python
2 votes118 views1 answer
Python auto updating clock
Python
1 vote72 views1 answer
Prime number between range program in python
Python
1 vote116 views1 answer
Loss funfction suited for softmax
Python
4 votes130 views2 answers
Django how to delete a db field
Python Django