# -*- coding: utf-8 -*-
# Author : Charley
# Python : 3.10.8
# Date   : 2025/6/13 11:48
from mysq_pool import MySQLConnectionPool
from loguru import logger


sql_pool = MySQLConnectionPool(log=logger)

max_bgs_id = sql_pool.select_one("SELECT MAX(auth_code) AS max_number FROM bgs_task")
# print(max_bgs_id_list)
max_bgs_id = max_bgs_id[0]
logger.info(f"max_bgs_id 从 {max_bgs_id} 开始爬取.........................")
bgs_id_list = [i for i in range(max_bgs_id+1, 20000001)]

sql_pool.insert_all("INSERT INTO bgs_task(auth_code) VALUES (%s)", bgs_id_list)