| 1234567891011121314151617 |
- # -*- 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)
|
