Repository Public
1// Package testdb creates a throwaway, migrated PostgreSQL database per test.2// Databases are named mcc_test_<random> and dropped on cleanup; they never3// share data with dev or prod.4package testdb56import (7 "context"8 "crypto/rand"9 "encoding/hex"10 "fmt"11 "os"12 "testing"13 "time"1415 "github.com/jackc/pgx/v5"16 "github.com/jackc/pgx/v5/pgxpool"1718 "clustr.spboucher.ai/mcc/internal/db"19)2021func adminURL() string {22 if v := os.Getenv("MCC_TEST_ADMIN_URL"); v != "" {23 return v24 }25 return "postgres://127.0.0.1/postgres?sslmode=disable"26}2728// New returns a pool on a fresh migrated database and its URL.29func New(t testing.TB) (*pgxpool.Pool, string) {30 t.Helper()31 ctx, cancel := context.WithTimeout(context.Background(), 30*time.Second)32 defer cancel()33 admin, err := pgx.Connect(ctx, adminURL())34 if err != nil {35 t.Skipf("PostgreSQL not reachable (%v) — integration test skipped", err)36 }37 b := make([]byte, 6)38 rand.Read(b)39 name := "mcc_test_" + hex.EncodeToString(b)40 if _, err := admin.Exec(ctx, "create database "+name); err != nil {41 admin.Close(ctx)42 t.Fatalf("create database: %v", err)43 }44 admin.Close(ctx)4546 cfg, _ := pgx.ParseConfig(adminURL())47 url := fmt.Sprintf("postgres://%s:%d/%s?sslmode=disable", cfg.Host, cfg.Port, name)48 if cfg.User != "" {49 url = fmt.Sprintf("postgres://%s@%s:%d/%s?sslmode=disable", cfg.User, cfg.Host, cfg.Port, name)50 }51 pool, err := db.Open(ctx, url)52 if err != nil {53 t.Fatalf("open: %v", err)54 }55 if _, err := db.Migrate(ctx, pool); err != nil {56 t.Fatalf("migrate: %v", err)57 }58 t.Cleanup(func() {59 pool.Close()60 c, cancel := context.WithTimeout(context.Background(), 15*time.Second)61 defer cancel()62 if a, err := pgx.Connect(c, adminURL()); err == nil {63 a.Exec(c, "drop database if exists "+name+" with (force)")64 a.Close(c)65 }66 })67 return pool, url68}69