/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

33 votes267 views4 answers
Python random password generator
Python
0 vote252 views1 answer
Append vector to vector python
Python
77 votes235 views6 answers
How to sort a dictionary by value in python
Python
14 votes246 views2 answers
How to check if a dictionary is empty in python
Python
0 vote249 views1 answer
Scrapy get text custom tags
Python
4 votes250 views1 answer
Get os information python
Python
0 vote238 views3 answers
Why a Python Arithmetic Operators used
Python
-1 vote285 views1 answer
Pop a string from a list python
Python
1 vote347 views3 answers
Ipynb to py online converter
Python
133 votes249 views6 answers
Python input
Python