/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 votes81 views1 answer
Is pythin a real coding language
Python
2 votes80 views2 answers
Python infinite l00p
Python
4 votes101 views2 answers
Arrayfield django example
Python
0 vote86 views1 answer
Random pick between given things python
Python
0 vote98 views1 answer
Pandas look for values in column with condition
Python
3 votes85 views1 answer
Pandas create a column from index
Python
5 votes80 views2 answers
Ubuntu remove python 2.7
Python
1 vote84 views2 answers
Python flask api
Python
0 vote81 views1 answer
Nltk regex parser
Python
0 vote92 views1 answer
Python - Cara Mengurutkan String Secara alfabet
Python