/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 vote170 views1 answer
Filtering certain rows in python that contains a part of string
Python
0 vote165 views2 answers
Send message from server to client python
Python
0 vote167 views1 answer
Python can't add int on string
Python
0 vote193 views1 answer
Extra import on django
Python Django
108 votes188 views3 answers
Pandas dataframe column rename
Python
0 vote158 views1 answer
Break up word in clomun pandas
Python
0 vote158 views1 answer
How to create simple window in wxPython
Python
0 vote161 views1 answer
Python opening file modalities
Python
21 votes175 views6 answers
Reorder columns pandas
Python
57 votes173 views6 answers
Print current date and time in python
Python