/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 vote191 views1 answer
Indent python code
Python
1 vote241 views1 answer
Django queryset multiple filters
Python Django
0 vote167 views2 answers
Browser = webdriver.firefox() error
Python
0 vote199 views2 answers
Call javascript function flask
Python Flask
1 vote148 views1 answer
Number of rows or columns in numpy ndarray python
Python
0 vote155 views1 answer
Convert to pdf fresh little library that outputs our notebook in a nice LaTex format without installing/doing anything else.
Python
1 vote154 views1 answer
Verificar se arquivo existe python
Python
0 vote203 views1 answer
Django extract array from post matrix
Python Django
0 vote165 views1 answer
How to show line chart in seaborn lib
Python
29 votes151 views6 answers
JUPYTER INSTALL
Python