使用flask将json文件插入到mysql中

from flask import Flask, request
import pymysql
import json

app = Flask(__name__)
app.config['MYSQL_HOST'] = '数据库主机地址'
app.config['MYSQL_USER'] = '数据库用户名'
app.config['MYSQL_PASSWORD'] = '数据库密码'
app.config['MYSQL_DB'] = '数据库名'
db = pymysql.connect(host=app.config['MYSQL_HOST'], user=app.config['MYSQL_USER'], password=app.config['MYSQL_PASSWORD'], db=app.config['MYSQL_DB'])

@app.route('/insert', methods=['POST'])
def insert_json():
    try:
        data = request.get_json()  # 获取POST请求中的JSON数据
        cursor = db.cursor()
        # 解析JSON数据并插入到MySQL中
        for item in data:
            query = "INSERT INTO 表名 (字段1, 字段2, ...) VALUES (%s, %s, ...)"
            values = (item['字段1'], item['字段2'], ...)
            cursor.execute(query, values)
        db.commit()
        cursor.close()
        return '数据插入成功'
    except Exception as e:
        return str(e)

if __name__ == '__main__':
    app.run()