/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

-1 vote323 views1 answer
Csv to pdf python
Python
0 vote390 views1 answer
Docker-compose.yml for flask celery rabbitmq
Python
14 votes438 views3 answers
ModuleNotFoundError: No module named 'pandas_profiling'
Python
2 votes333 views2 answers
Python replace newline
Python
0 vote334 views1 answer
Switch case dictionary python
Python
0 vote340 views1 answer
Scaling Operation in SkLearn
Python
0 vote282 views1 answer
Pandas select data by column value
Python
1 vote371 views4 answers
Python ip camera
Python
6 votes298 views4 answers
Normalize column pandas
Python
13 votes318 views2 answers
How to install python libraries
Python