/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

-1 vote104 views1 answer
Print(shahzaib)
Python
10 votes105 views3 answers
How to find current age from date of birth in python
Python
0 vote135 views1 answer
Power of array
Python
43 votes100 views5 answers
Import sklearn
Python
0 vote98 views1 answer
User_info = user_info.save(commit=False)
Python
0 vote139 views2 answers
Django swagger
Python Django
3 votes103 views1 answer
Creating a virtual environment in python 3.8
Python
1 vote105 views1 answer
How to make a complex calculator in python
Python
0 vote104 views1 answer
# Import KNeighborsClassifier from sklearn.neighbors
Python
0 vote100 views1 answer
How to plot labeled data with different colors
Python