forked from mtusi2026/mtusi2026lab4
100 lines
2.1 KiB
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
|
|
}
|