spider_work/cgc_spider/add_task.py

# -*- 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):
for i in range(6069999999, 6110999999):
    # 末尾三位数必须是在0-300之间的
    last_three_digits = i % 1000
    if 0 <= last_three_digits <= 300:
        num_list.append(i)

# print(num_list[:3000])
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)