pymysql insert插入使用字典（dict）数据

pymysql insert插入使用字典（dict）数据

import  pymysql

conn = pymysql.connect(host="xxx",
                       port=3306,
                       user="xx",
                       password="xx",
                       db="xx",
                       charset='utf8mb4',
                       cursorclass=pymysql.cursors.DictCursor,)

def insert(table_name,data):
    with conn.cursor() as cursor:
        cols =  ", ".join('`{}`'.format(k) for k in data.keys())
        placeholders =', '.join('%({})s'.format(k) for k in data.keys())

        insert_sql=f"INSERT INTO {table_name} ({cols}) VALUES ({placeholders})"
        print(insert_sql)
        cursor.execute(insert_sql,data)