/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

9 votes251 views2 answers
How to install packages inside thepython script
Python
1 vote241 views1 answer
How to change a thread name in python
Python
-1 vote266 views1 answer
Opencv python rgb to hsv
Python
0 vote252 views1 answer
How to open cmd at specific size using python
Python
0 vote249 views1 answer
Python convert string to byte array
Python
0 vote265 views1 answer
Bytearray to hex python
Python
8 votes270 views2 answers
Python inner join based on two columns
Python
0 vote264 views1 answer
From plyfile import PlyData ModuleNotFoundError: No module named 'plyfile'
Python
2 votes251 views1 answer
List comprehension python 3 hackerrank solution
Python
0 vote277 views1 answer
Parquet to dataframe
Python