/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 vote197 views1 answer
Python strong type
Python
0 vote207 views1 answer
First n lis tpython
Python
0 vote241 views1 answer
Change my python working directory
Python
0 vote221 views1 answer
DataFrame changed by function
Python
2 votes211 views2 answers
How to get the amount of nan values in a data fram
Python
2 votes169 views1 answer
How to change pygame window icon
Python
0 vote227 views1 answer
Video steganography using python
Python
0 vote217 views1 answer
You will be passed a file path P and string S on the command line. Output the number of times the string S appears in the file P.
Python
0 vote217 views1 answer
Move one column value down by one column in pandas
Python
0 vote218 views1 answer
Create python package ros 2
Python