如何在将数据从csv复制到sql表时将CurrentUserId和TenantId字段插入目标表

import csv
import pymysql

# 数据库连接配置
db_host = 'localhost'
db_user = 'username'
db_password = 'password'
db_name = 'database_name'

# CSV文件路径
csv_file = 'data.csv'

# 连接数据库
conn = pymysql.connect(host=db_host, user=db_user, password=db_password, database=db_name)
cursor = conn.cursor()

# 创建目标表
create_table_query = '''
    CREATE TABLE IF NOT EXISTS target_table (
        column1 VARCHAR(255),
        column2 INT,
        CurrentUserId INT,
        TenantId INT
    )
'''
cursor.execute(create_table_query)

# 读取CSV文件并插入数据到目标表
with open(csv_file, 'r') as file:
    csv_data = csv.reader(file)
    next(csv_data)  # 跳过CSV文件的标题行
    for row in csv_data:
        insert_query = '''
            INSERT INTO target_table (column1, column2, CurrentUserId, TenantId)
            VALUES (%s, %s, %s, %s)
        '''
        current_user_id = 123  # 设置CurrentUserId的值
        tenant_id = 456  # 设置TenantId的值
        cursor.execute(insert_query, (row[0], row[1], current_user_id, tenant_id))

# 提交事务并关闭数据库连接
conn.commit()
cursor.close()
conn.close()