/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 vote400 views1 answer
Https://practice.geeksforgeeks.org/problems/coin-change2448/1
Python
0 vote344 views1 answer
Rotate 90 degrees clockwise counter python
Python
0 vote389 views1 answer
Exponential regression python
Python
0 vote353 views2 answers
Run all jupyter notebooks in project folder
Python
0 vote348 views1 answer
Data must be 1-dimensional pd.dataframe
Python
3 votes398 views5 answers
Swap in python
Python
0 vote344 views1 answer
Multiclass.roc plot title
Python
5 votes296 views10 answers
Online python to c converter
Python
0 vote361 views1 answer
Transform image to rgb python
Python
0 vote381 views4 answers
Dfs and bfs in python
Python