/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 vote267 views1 answer
Face sentiment
Python
2 votes264 views2 answers
ë python
Python
6 votes187 views2 answers
How to add mouse button in pygame
Python
19 votes196 views4 answers
How to use python to sleep if the user is not using the system
Python
6 votes197 views2 answers
How to return the derivative of a function in python
Python
8 votes197 views6 answers
Python functions
Python
3 votes159 views1 answer
Get terminal output in python
Python
0 vote191 views1 answer
Python get num chars
Python
0 vote184 views1 answer
Read excel file in computer
Python
0 vote231 views1 answer
Python set remove if exists
Python