/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

6 votes147 views3 answers
Python open folder
Python
5 votes190 views1 answer
Picasa
Python
0 vote110 views1 answer
Remove from list if not maches in list
Python
1 vote148 views2 answers
Python pandas remove punctuation
Python
8 votes151 views2 answers
If else elif python
Python
8 votes146 views6 answers
Redirect django
Python
0 vote166 views1 answer
Dynamic printing
Python
7 votes171 views2 answers
Create the dataframe column based on condition
Python
0 vote144 views1 answer
Download image from url selenium python
Python
0 vote143 views1 answer
Pythagorean theorem calc: find c, a=n
Python