SPB Git

Repository Public

testdb.go 1.8 KB 69 lines go

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
Files main
Menu

Theme