/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 vote103 views1 answer
How to find ip address of website using python
Python
2 votes98 views1 answer
How to make pyautogui search a region of the screen
Python
0 vote113 views1 answer
Ball python
Python
0 vote110 views1 answer
How to get session value in django template
Python Django
0 vote100 views2 answers
Read image from a folder python
Python
3 votes109 views1 answer
Drop duplicates pandas first column
Python
0 vote94 views1 answer
Python barcode generator
Python
1 vote102 views1 answer
Python multiplication array
Python
1 vote95 views1 answer
Python extract name out of mail
Python
7 votes93 views1 answer
Float to percentage python
Python