# -*- coding: utf-8 -*-
# Author : Charley
# Python : 3.10.8
# Date   : 2025/9/23 14:37
"""
6000+6位数——6075+6位数
"""
from mysql_pool import MySQLConnectionPool
from loguru import logger

sql_pool = MySQLConnectionPool(log=logger)

num_list = []
# for i in range(6000, 6076):
#     for j in range(100000, 1000000):  # 6位数范围 100000-999999
#         num_list.append(f"{i}{j:06d}")

for i in range(6060000000, 6069999999):
    num_list.append(i)

# print(len(num_list))
logger.debug(f"开始插入 {len(num_list)} 个数据.......................")

sql_insert = "insert into cgc_task (cert_id) values (%s)"
sql_pool.insert_too_many(sql_insert, num_list)