"""共享数据库连接"""

import os

import pymysql


def get_connection():
    """获取数据库连接（与 store_results_mysql、schedule 共用配置）

    请在 examples/content_finder/.env 中配置 DB_HOST / DB_PORT / DB_USER / DB_PASSWORD / DB_NAME。
    """
    host = os.getenv("DB_HOST", "").strip() or "rm-t4nh1xx6o2a6vj8qu3o.mysql.singapore.rds.aliyuncs.com"
    port = int(os.getenv("DB_PORT", "3306"))
    user = os.getenv("DB_USER", "").strip() or "content_rw"
    password = os.getenv("DB_PASSWORD", "") or "bC1aH4bA1lB0"
    database = os.getenv("DB_NAME", "").strip() or "content-deconstruction-supply"
    if not all([host, user, database]):
        raise ValueError(
            "数据库未配置：请在 examples/content_finder/.env 中设置 DB_HOST、DB_USER、DB_PASSWORD、DB_NAME"
        )

    return pymysql.connect(
        host=host,
        port=port,
        user=user,
        password=password,
        database=database,
        charset="utf8mb4",
        cursorclass=pymysql.cursors.DictCursor,
        autocommit=True,
    )