/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 vote118 views1 answer
How to extract integers from string python
Python
0 vote101 views1 answer
Reading a cell from another cell in colab
Python
0 vote123 views1 answer
Rotate image pyqt5
Python
31 votes95 views6 answers
Try except
Python
2 votes195 views4 answers
Streamlit python install
Python
4 votes112 views3 answers
Using a print function
Python
1 vote113 views1 answer
Python convert list of lists of strings to int
Python
0 vote114 views1 answer
How to respond to a number in python
Python
0 vote93 views1 answer
Qaction disacble python
Python
2 votes107 views1 answer
Pandas find top 10 values in column
Python