/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 vote258 views1 answer
Customise django admin edit model button in field
Python Django
0 vote273 views1 answer
How to create api for get data in django rest framework
Python Django
1 vote237 views1 answer
Python convert base
Python
0 vote291 views1 answer
Python os filename without extension
Python
0 vote228 views1 answer
List comprehesion python
Python
1 vote264 views1 answer
Jinja2 template import html with as
Python
0 vote229 views1 answer
Python for comparing url path
Python
0 vote243 views1 answer
Python chatbot api
Python
1 vote241 views1 answer
Pip fuzzywuzzy
Python
0 vote243 views2 answers
Write a program to check whether a character is vowel or consonant in python
Python