package database import ( "context" "errors" "fmt" "time" "github.com/jackc/pgx/v5/pgxpool" "gitea.privcloud.tech/dizi/mtusi2026lab5/migrations" ) var ( errURLRequired = errors.New("database URL is required") errMinConnections = errors.New("minimum database connections must not be negative") errMaxConnections = errors.New("maximum database connections must be positive") errConnectionRange = errors.New("minimum database connections exceed maximum") errMaxConnectionAge = errors.New("maximum database connection age must be positive") errMaxConnectionIdle = errors.New("maximum database connection idle time must be positive") errHealthCheckPeriod = errors.New("database health check period must be positive") errConnectionTimeout = errors.New("database connection timeout must be positive") ) type Config struct { URL string MinConnections int32 MaxConnections int32 MaxConnectionAge time.Duration MaxConnectionIdle time.Duration HealthCheckPeriod time.Duration ConnectTimeout time.Duration } func Open(ctx context.Context, config Config) (*pgxpool.Pool, error) { if err := validateConfig(config); err != nil { return nil, err } poolConfig, err := pgxpool.ParseConfig(config.URL) if err != nil { return nil, fmt.Errorf("parse database configuration: %w", err) } poolConfig.MinConns = config.MinConnections poolConfig.MaxConns = config.MaxConnections poolConfig.MaxConnLifetime = config.MaxConnectionAge poolConfig.MaxConnIdleTime = config.MaxConnectionIdle poolConfig.HealthCheckPeriod = config.HealthCheckPeriod connectCtx, cancel := context.WithTimeout(ctx, config.ConnectTimeout) defer cancel() pool, err := pgxpool.NewWithConfig(connectCtx, poolConfig) if err != nil { return nil, fmt.Errorf("create database pool: %w", err) } if err := pool.Ping(connectCtx); err != nil { pool.Close() return nil, fmt.Errorf("ping database: %w", err) } return pool, nil } func Migrate(ctx context.Context, pool *pgxpool.Pool, timeout time.Duration) error { if timeout <= 0 { return errors.New("database migration timeout must be positive") } migrationCtx, cancel := context.WithTimeout(ctx, timeout) defer cancel() return applyMigrations(migrationCtx, pool, migrations.FS) } func validateConfig(config Config) error { switch { case config.URL == "": return errURLRequired case config.MinConnections < 0: return errMinConnections case config.MaxConnections < 1: return errMaxConnections case config.MinConnections > config.MaxConnections: return errConnectionRange case config.MaxConnectionAge <= 0: return errMaxConnectionAge case config.MaxConnectionIdle <= 0: return errMaxConnectionIdle case config.HealthCheckPeriod <= 0: return errHealthCheckPeriod case config.ConnectTimeout <= 0: return errConnectionTimeout default: return nil } }