/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 vote156 views2 answers
How to JOIN three tables with Django ORM
Python Django
2 votes161 views1 answer
Django load model by name
Python Django
0 vote130 views1 answer
Change between two python 3 version in raspberrry pi
Python
6 votes141 views6 answers
Tuple methods in python
Python
0 vote129 views1 answer
Python - matching people based on city
Python
-1 vote124 views1 answer
Loading .dat file in python
Python
8 votes134 views1 answer
Jupyter column limit pd
Python
2 votes87 views2 answers
Python generate all combinations
Python
0 vote186 views1 answer
How to add static files in django 3.2.9
Python Django
14 votes126 views4 answers
Regex in python
Python