forked from mtusi2026/mtusi2026lab2
95 lines
2.9 KiB
Go
95 lines
2.9 KiB
Go
package database
|
|
|
|
import (
|
|
"context"
|
|
"errors"
|
|
"fmt"
|
|
"time"
|
|
|
|
"github.com/jackc/pgx/v5/pgxpool"
|
|
|
|
"gitea.privcloud.tech/dizi/mtusi2026lab2/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")
|
|
errMigrationTimeout = errors.New("database migration 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
|
|
MigrationTimeout 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)
|
|
}
|
|
|
|
migrationCtx, cancel := context.WithTimeout(ctx, config.MigrationTimeout)
|
|
defer cancel()
|
|
if err := applyMigrations(migrationCtx, pool, migrations.FS); err != nil {
|
|
pool.Close()
|
|
return nil, err
|
|
}
|
|
return pool, nil
|
|
}
|
|
|
|
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
|
|
case config.MigrationTimeout <= 0:
|
|
return errMigrationTimeout
|
|
default:
|
|
return nil
|
|
}
|
|
}
|