add_task.py 669 B

12345678910111213141516171819202122232425
  1. # -*- coding: utf-8 -*-
  2. # Author : Charley
  3. # Python : 3.10.8
  4. # Date : 2025/9/23 14:37
  5. """
  6. 6000+6位数——6075+6位数
  7. """
  8. from mysql_pool import MySQLConnectionPool
  9. from loguru import logger
  10. sql_pool = MySQLConnectionPool(log=logger)
  11. num_list = []
  12. # for i in range(6000, 6076):
  13. # for j in range(100000, 1000000): # 6位数范围 100000-999999
  14. # num_list.append(f"{i}{j:06d}")
  15. for i in range(6060000000, 6069999999):
  16. num_list.append(i)
  17. # print(len(num_list))
  18. logger.debug(f"开始插入 {len(num_list)} 个数据.......................")
  19. sql_insert = "insert into cgc_task (cert_id) values (%s)"
  20. sql_pool.insert_too_many(sql_insert, num_list)