spider_work/test/test.py

# -*- coding: utf-8 -*-
# Author : Charley
# Python : 3.10.8
# Date   : 2026/3/9 15:01
import time
from loguru import logger
from mysql_pool import MySQLConnectionPool


logger.remove()
logger.add("./logs/{time:YYYYMMDD}.log", encoding='utf-8', rotation="00:00",
           format="[{time:YYYY-MM-DD HH:mm:ss.SSS}] {level} {message}",
           level="DEBUG", retention="7 day")

now_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())

logger.info(f"程序开始运行时间：{now_time}")

sql_pool = MySQLConnectionPool(log=logger)
if not sql_pool.check_pool_health():
    logger.error("数据库连接池异常")
    raise RuntimeError("数据库连接池异常")

token_row = sql_pool.select_one("SELECT token FROM zc_token WHERE id = 1")
if not token_row:
    logger.error("未查询到 token")

token = token_row[0]
logger.debug(f"token: {token}")

logger.info("test 测试")