forked from mtusi2026/mtusi2026lab3
72 lines
1.8 KiB
Go
72 lines
1.8 KiB
Go
package database
|
|
|
|
import (
|
|
"embed"
|
|
"errors"
|
|
"fmt"
|
|
"time"
|
|
|
|
"github.com/golang-migrate/migrate/v4"
|
|
pgxmigrate "github.com/golang-migrate/migrate/v4/database/pgx/v5"
|
|
"github.com/golang-migrate/migrate/v4/source/iofs"
|
|
"github.com/jackc/pgx/v5"
|
|
"github.com/jackc/pgx/v5/stdlib"
|
|
)
|
|
|
|
//go:embed migrations/*.sql
|
|
var migrationFiles embed.FS
|
|
|
|
const migrationsTable = "schema_migrations"
|
|
|
|
// Migrate applies every pending embedded migration. golang-migrate takes its
|
|
// own advisory lock, so concurrent processes serialise instead of racing the
|
|
// schema.
|
|
func Migrate(databaseURL string) error {
|
|
source, err := iofs.New(migrationFiles, "migrations")
|
|
if err != nil {
|
|
return fmt.Errorf("load embedded migrations: %w", err)
|
|
}
|
|
|
|
connConfig, err := pgx.ParseConfig(databaseURL)
|
|
if err != nil {
|
|
_ = source.Close()
|
|
return fmt.Errorf("parse DATABASE_URL for migrations: %w", err)
|
|
}
|
|
if connConfig.RuntimeParams == nil {
|
|
connConfig.RuntimeParams = make(map[string]string)
|
|
}
|
|
connConfig.RuntimeParams["lock_timeout"] = "30000"
|
|
connConfig.ConnectTimeout = 3 * time.Second
|
|
|
|
db := stdlib.OpenDB(*connConfig)
|
|
db.SetMaxOpenConns(1)
|
|
db.SetMaxIdleConns(1)
|
|
|
|
driver, err := pgxmigrate.WithInstance(db, &pgxmigrate.Config{
|
|
MigrationsTable: migrationsTable,
|
|
StatementTimeout: 30 * time.Second,
|
|
})
|
|
if err != nil {
|
|
_ = source.Close()
|
|
_ = db.Close()
|
|
return fmt.Errorf("create migration driver: %w", err)
|
|
}
|
|
|
|
migrator, err := migrate.NewWithInstance("iofs", source, "pgx5", driver)
|
|
if err != nil {
|
|
_ = source.Close()
|
|
_ = driver.Close()
|
|
return fmt.Errorf("create migrator: %w", err)
|
|
}
|
|
defer func() {
|
|
// Close closes both the embedded source and the database connection.
|
|
_, _ = migrator.Close()
|
|
}()
|
|
|
|
if err := migrator.Up(); err != nil && !errors.Is(err, migrate.ErrNoChange) {
|
|
return fmt.Errorf("apply migrations: %w", err)
|
|
}
|
|
|
|
return nil
|
|
}
|