Python Flask How to convert mysql query result to json

Python Flask How to convert mysql query result to json

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

#app.py from flask import Flask, json, request, jsonify from flask_mysqldb import MySQL,MySQLdb #pip install flask-mysqldb https://github.com/alexferl/flask-mysqldb   app = Flask(__name__)    app.secret_key = "caircocoders-ednalan-2020"    app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = 'root' app.config['MYSQL_PASSWORD'] = '' app.config['MYSQL_DB'] = 'testingdb' app.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(app)    @app.route('/') def index():    cur = mysql.connection.cursor(MySQLdb.cursors.DictCursor)    cur.execute("SELECT * FROM employee")    rv = cur.fetchall()    employee = []    content = {}    for result in rv:        content = {'id': result['id'], 'name': result['name'], 'email': result['email']}        employee.append(content)        content = {}    return jsonify(employee)               if __name__ == '__main__':     app.run(debug=True)