python3 批量执行参数化insert语句

import sys

sys.path.append('D:\python_test_live')
import pymysql
from course.customer import dict_data_richer,dict_data_course



# 创建连接对象
db = pymysql.connect(host='xxxx', port=xxx, user='xxx',
                       password='xxx', database='xxx', charset='utf8')

# 获取游标对象
cursor = db.cursor()

i = 0 
while i<30 :
    img = dict_data_richer[i]["cover"]
    cid = dict_data_course[i]["id"]
    # 事务处理
    sql = "INSERT INTO `table_name` (`user_id`, `course_id`, `certificate_img_url`, `finished_learn_at`, `created_at`, `updated_at`) VALUES (15896317, '{0}','{1}', '1622709362', '1622709362', '1622709362')".format(cid,img)
 
    cursor.execute(sql)
    db.commit()
    i = i+1



 
# 关闭连接
cursor.close()