gohub/config/database.go

package config

import "github.com/runningwater/gohub/pkg/config"

func init() {
	config.Add("database", func() map[string]any {
		return map[string]any{
			// 默认数据库
			"connection": config.Env("DB_CONNECTION", "mysql"),
			// MySQL 配置
			"mysql": map[string]any{
				// 数据库连接信息，可以使用 DSN 格式
				"host":     config.Env("DB_HOST", "127.0.0.1"),
				"port":     config.Env("DB_PORT", "3306"),
				"database": config.Env("DB_DATABASE", "gohub"),
				"username": config.Env("DB_USERNAME", "root"),
				"password": config.Env("DB_PASSWORD", ""),
				"charset":  "utf8mb4",
				// 数据库连接池配置
				"max_idle_connections": config.Env("DB_MAX_IDLE_CONNECTIONS", 100),
				"max_open_connections": config.Env("DB_MAX_OPEN_CONNECTIONS", 25),
				// 连接的最大存活时间
				"max_life_seconds": config.Env("DB_MAX_LIFE_SECONDS", 5*60),
			},
			// SQLite 配置
			"sqlite": map[string]any{
				// 数据库文件地址
				"database": config.Env("DB_SQLITE_DATABASE", "database/gohub.db"),
			},
		}
	})
}