<?php
/**
 * 轻量 PDO 封装（MySQL / SQLite 双驱动）
 */
class DB
{
    /** @var PDO */
    public static $pdo;
    public static $driver = 'mysql';
    public static $prefix = '';

    public static function init(array $config)
    {
        self::$driver = $config['driver'] === 'sqlite' ? 'sqlite' : 'mysql';
        self::$prefix = $config['prefix'] ?? '';

        try {
            if (self::$driver === 'sqlite') {
                $path = $config['sqlite_path'] ?? (APP_ROOT . '/data/komorebi.sqlite');
                $dir = dirname($path);
                if (!is_dir($dir)) {
                    @mkdir($dir, 0775, true);
                }
                self::$pdo = new PDO('sqlite:' . $path);
                self::$pdo->exec('PRAGMA journal_mode = WAL');
                self::$pdo->exec('PRAGMA busy_timeout = 5000');
            } else {
                $db = $config['db'];
                $dsn = 'mysql:host=' . $db['host'] . ';port=' . (int) $db['port'] . ';dbname=' . $db['database'] . ';charset=utf8mb4';
                self::$pdo = new PDO($dsn, $db['username'], $db['password']);
            }
            self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            self::$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
            self::$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        } catch (PDOException $e) {
            app_fatal_page('数据加载失败', '数据库连接失败：' . $e->getMessage());
        }
    }

    public static function table($name)
    {
        return self::$prefix . $name;
    }

    public static function run($sql, array $params = [])
    {
        $stmt = self::$pdo->prepare($sql);
        $stmt->execute($params);
        return $stmt;
    }

    public static function all($sql, array $params = [])
    {
        return self::run($sql, $params)->fetchAll();
    }

    public static function one($sql, array $params = [])
    {
        $row = self::run($sql, $params)->fetch();
        return $row === false ? null : $row;
    }

    public static function val($sql, array $params = [], $default = null)
    {
        $v = self::run($sql, $params)->fetchColumn();
        return $v === false ? $default : $v;
    }

    public static function insert($table, array $data)
    {
        $cols = array_keys($data);
        $sql = 'INSERT INTO ' . self::table($table) . ' (' . implode(',', $cols) . ') VALUES ('
            . implode(',', array_fill(0, count($cols), '?')) . ')';
        self::run($sql, array_values($data));
        return (int) self::$pdo->lastInsertId();
    }

    public static function update($table, array $data, $where, array $whereParams = [])
    {
        $sets = [];
        foreach (array_keys($data) as $c) {
            $sets[] = $c . ' = ?';
        }
        $sql = 'UPDATE ' . self::table($table) . ' SET ' . implode(', ', $sets) . ' WHERE ' . $where;
        self::run($sql, array_merge(array_values($data), array_values($whereParams)));
    }

    public static function delete($table, $where, array $params = [])
    {
        self::run('DELETE FROM ' . self::table($table) . ' WHERE ' . $where, $params);
    }

    public static function count($table, $where = '1', array $params = [])
    {
        return (int) self::val('SELECT COUNT(*) FROM ' . self::table($table) . ' WHERE ' . $where, $params, 0);
    }
}

function db_health_check()
{
    try {
        DB::val('SELECT COUNT(*) FROM ' . DB::table('settings'));
    } catch (Exception $e) {
        app_fatal_page('数据加载失败', '数据表读取异常，请确认已安装并完成 install.php：' . $e->getMessage());
    }
}
