/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 vote298 views1 answer
Django pass list of fields to values
Python Django
0 vote271 views1 answer
Python read in integers separated by spaces
Python
0 vote287 views1 answer
Data[:,:2]
Python
-1 vote281 views1 answer
Templates python
Python
0 vote311 views1 answer
Print without parenthesis
Python
0 vote296 views1 answer
How to fix invalid salt in python flask
Python
1 vote291 views1 answer
Python discord how to get user variables
Python
1 vote259 views1 answer
Python how to set multiple conditional for single var
Python
22 votes279 views4 answers
How to create a string in python
Python
7 votes270 views2 answers
Python print for loop one line
Python