/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 vote313 views1 answer
Remove keys from array python
Python
1 vote321 views2 answers
Python remove everything except numbers from string
Python
-1 vote337 views1 answer
Python all any example
Python
0 vote358 views1 answer
Use if a not trusted message will come up
Python
1 vote310 views1 answer
Cast tensor type pytorch
Python
7 votes372 views1 answer
Np array n same values
Python
1 vote314 views1 answer
Cut 0s on string python
Python
103 votes303 views2 answers
How to take input of something in python
Python
1 vote305 views1 answer
Open excel through python
Python
0 vote316 views1 answer
Swap 2 no in one line python
Python