// Copyright (c) 2024-2026 Tencent Zhuque Lab. All rights reserved.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
//
// Requirement: Any integration or derivative work must explicitly attribute
// Tencent Zhuque Lab (https://github.com/Tencent/AI-Infra-Guard) in its
// documentation or user interface, as detailed in the NOTICE file.

package database

import (
	"fmt"
	"log"
	"os"
	"path/filepath"
	"time"

	"github.com/Tencent/AI-Infra-Guard/internal/gologger"

	"github.com/glebarez/sqlite"
	"gorm.io/gorm"
	gormlogger "gorm.io/gorm/logger"
)

// Config 用于保存数据库配置
type Config struct {
	DBPath string
}

// NewConfig 创建一个新的数据库配置
func NewConfig(dbPath string) *Config {
	return &Config{DBPath: dbPath}
}

// LoadConfigFromEnv 从环境变量加载数据库配置
func LoadConfigFromEnv() *Config {
	// 默认数据库路径
	defaultDBPath := "db/tasks.db"

	// 从环境变量读取数据库路径
	if dbPath := os.Getenv("DB_PATH"); dbPath != "" {
		defaultDBPath = dbPath
	}

	return &Config{DBPath: defaultDBPath}
}

// InitDB 用 GORM 初始化数据库连接并返回 *gorm.DB
func InitDB(config *Config) (*gorm.DB, error) {
	// 确保数据库目录存在
	dir := filepath.Dir(config.DBPath)
	if err := os.MkdirAll(dir, 0755); err != nil {
		return nil, fmt.Errorf("创建数据库目录失败: %v", err)
	}

	//打开数据库连接 - 启用WAL模式和共享缓存以支持并发访问
	// 显式关闭参数插值：默认 logger 会把绑定参数展开成明文 SQL，
	// 而 models 表里存有 token 与 extra_headers 这类密钥，
	// 一次失败的 UPDATE 或慢查询就可能把它们写进日志。
	dbLogger := gormlogger.New(
		log.New(os.Stdout, "\r\n", log.LstdFlags),
		gormlogger.Config{
			SlowThreshold:        time.Second,
			LogLevel:             gormlogger.Warn,
			ParameterizedQueries: true,
		},
	)
	db, err := gorm.Open(sqlite.Open(config.DBPath+"?_journal=WAL&_timeout=5000&cache=shared"), &gorm.Config{Logger: dbLogger})
	if err != nil {
		gologger.WithError(err).Fatalln("无法打开数据库连接")
	}
	// 获取底层的SQL DB以配置连接池
	sqlDB, err := db.DB()
	if err != nil {
		panic("failed to get database connection")
	}

	// 设置连接池参数
	sqlDB.SetMaxIdleConns(1000)
	sqlDB.SetMaxOpenConns(1000)

	return db, nil
}