/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

4 votes288 views2 answers
Change django admin title
Python Django
17 votes205 views3 answers
Set title matplotlib
Python
5 votes206 views1 answer
Shift elements in list python
Python
5 votes217 views3 answers
Strptime python
Python
0 vote193 views1 answer
Python Command '['latexmk', '--pdf', '--interaction=nonstopmode', % returned non-zero exit status 2.
Python
4 votes253 views4 answers
Binary to decimal in python
Python
3 votes184 views2 answers
Rest_framework_simplejwt
Python
0 vote189 views1 answer
Minio python make an object
Python
5 votes190 views5 answers
Pass in python
Python
0 vote193 views1 answer
Tensorflow Dense layer activatity leaklyrelu
Python