/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 vote202 views1 answer
__pycache__
Python
2 votes175 views6 answers
Install nltk in python
Python
25 votes411 views3 answers
Startapp django
Python Django
1 vote183 views1 answer
UnavailableInvalidChannel error in conda
Python
0 vote212 views1 answer
Django rest framework encrypt passwors
Python Django
0 vote182 views1 answer
Django password field encryption
Python
1 vote135 views1 answer
How to distribute a dataset in train and test using scikit
Python
0 vote175 views1 answer
Pip in vscode linux
Python
-1 vote204 views1 answer
Python how to get rid of spaces in print
Python
0 vote183 views1 answer
Printing a range of no one line in python
Python