/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

2 votes253 views2 answers
Head first python
Python
0 vote276 views1 answer
Python Print Variable Using the string formatting with positional arguments {}
Python
10 votes256 views3 answers
Cv show image python
Python
1 vote280 views1 answer
TypeError: exceptions must derive from BaseException
Python
1 vote279 views2 answers
Pydictionary
Python
1 vote267 views1 answer
Display max number of columns pandas
Python
4 votes304 views1 answer
Any python
Python
2 votes300 views1 answer
Pandas dataframe set datetime index
Python
0 vote273 views2 answers
How to delete a row based on a criteria in python datafram
Python
0 vote266 views1 answer
Delete virtual environment in python windows
Python