快速造数据mysql

#给加油表插入百万数据
#批量插入数据
import random
from zaoshuju1.pro_data import *
from tools.my_log import MyLog
log = MyLog()
def insert():
    j = 9496615
    ids = ((1671372687512481794, 1671507235537727490), (1671372687512481794, 1673145894220918786), (1671372687512481794, 1673224577929506818), (1671372687512481794, 1673227641214267393), (1671372687512481794, 1673227641222656002), (1671372687512481794, 1673228774452293634), (1671372687512481794, 1673228774464876545), (1671372687512481794, 1673229036806008833))
    id = random.choice(ids)
    #循环100次
    for i in range(1000):
        #插入的参数
        datalist = []
        oil_flow = 'FBq6eRsZTUcKNmoPlRwl9g=='
        refueling_time = '2023-09-15 10:15:48'
        refueling_seconds = 10
        info_type = 1
        oil_type = 0
        data_type = 0
        create_time = '2023-09-15 10:15:48'
        unit_price = 7.29
        for j in range(j, j+5000):
            id = random.choice(ids)
            station_id = id[0]
            nozzle_id = id[1]
            data = (j, station_id, nozzle_id,oil_flow,refueling_time,refueling_seconds,
                    info_type, oil_type, data_type, create_time, unit_price )
            #使用列表接受元组作为批量插入使用
            datalist.append(data)
        #重置j的值加一，防止重复
        j = j+1
        # print(datalist)
        #插入数据，按data_list
        sql = "INSERT INTO `oil_info`(`info_id`,`station_id`, `nozzle_id`, `oil_flow`," \
              "`refueling_time`, `refueling_seconds`,`info_type`, `oil_type`, `data_type`," \
              "`create_time`,`unit_price`)" \
              "VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
        log.info(f"当前是{j}")
        batch_insert_sql(sql, datalist)

if __name__ == '__main__':
    insert()