Files
mtusi2026lab4/internal/storage/migrate.go

100 lines
2.1 KiB
Go

package storage
import (
"context"
"fmt"
"io/fs"
"sort"
"strconv"
"strings"
"github.com/jackc/pgx/v5/pgxpool"
"mtusi2026lab2/migrations"
)
func ApplyMigrations(ctx context.Context, pool *pgxpool.Pool) error {
tx, err := pool.Begin(ctx)
if err != nil {
return fmt.Errorf("begin migrations: %w", err)
}
defer tx.Rollback(ctx)
// Serialize migrations across API instances.
_, err = tx.Exec(ctx, `SELECT pg_advisory_xact_lock(20260002)`)
if err != nil {
return fmt.Errorf("lock migrations: %w", err)
}
_, err = tx.Exec(ctx, `
CREATE TABLE IF NOT EXISTS schema_migrations (
version BIGINT PRIMARY KEY,
applied_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
)
`)
if err != nil {
return fmt.Errorf("create migration history: %w", err)
}
entries, err := fs.ReadDir(migrations.Files, ".")
if err != nil {
return fmt.Errorf("read migrations: %w", err)
}
names := make([]string, 0)
for _, entry := range entries {
if !entry.IsDir() && strings.HasSuffix(entry.Name(), ".up.sql") {
names = append(names, entry.Name())
}
}
sort.Strings(names)
for _, name := range names {
versionPart := strings.SplitN(name, "_", 2)[0]
version, err := strconv.ParseInt(versionPart, 10, 64)
if err != nil {
return fmt.Errorf("invalid migration filename %q: %w", name, err)
}
var applied bool
err = tx.QueryRow(ctx, `
SELECT EXISTS (
SELECT 1
FROM schema_migrations
WHERE version = $1
)
`, version).Scan(&applied)
if err != nil {
return fmt.Errorf("check migration %d: %w", version, err)
}
if applied {
continue
}
sql, err := fs.ReadFile(migrations.Files, name)
if err != nil {
return fmt.Errorf("read migration %s: %w", name, err)
}
if _, err := tx.Exec(ctx, string(sql)); err != nil {
return fmt.Errorf("apply migration %s: %w", name, err)
}
_, err = tx.Exec(ctx, `
INSERT INTO schema_migrations (version)
VALUES ($1)
`, version)
if err != nil {
return fmt.Errorf("record migration %s: %w", name, err)
}
}
if err := tx.Commit(ctx); err != nil {
return fmt.Errorf("commit migrations: %w", err)
}
return nil
}