SPB Git

Repository Public

backup_test.go 4.8 KB 136 lines go

1package backup_test23import (4	"context"5	"crypto/rand"6	"os"7	"strings"8	"testing"9	"time"1011	"github.com/google/uuid"12	"github.com/jackc/pgx/v5"1314	"clustr.spboucher.ai/mcc/internal/audit"15	"clustr.spboucher.ai/mcc/internal/backup"16	"clustr.spboucher.ai/mcc/internal/testdb"17)1819func TestBackupVerifyRestoreRoundTrip(t *testing.T) {20	pool, url := testdb.New(t)21	ctx, cancel := context.WithTimeout(context.Background(), 2*time.Minute)22	defer cancel()2324	// Real content: users, a node, a chained audit log.25	for i := 0; i < 3; i++ {26		wh := make([]byte, 32)27		rand.Read(wh)28		if _, err := pool.Exec(ctx, `insert into users(id,handle,display_name,role,webauthn_handle) values ($1,$2,$3,'viewer',$4)`,29			uuid.New(), "user"+string(rune('a'+i)), "User", wh); err != nil {30			t.Fatal(err)31		}32	}33	pool.Exec(ctx, `insert into nodes(id, alias, registered_via) values ($1,'n1','manual')`, uuid.New())34	for i := 0; i < 20; i++ {35		if _, err := audit.Append(ctx, pool, audit.Entry{ActorKind: "system", Action: "test.event", Outcome: audit.Success, Params: map[string]any{"i": i}}); err != nil {36			t.Fatal(err)37		}38	}39	want, err := backup.Inspect(ctx, url)40	if err != nil || !want.AuditOK || want.Users != 3 || want.AuditRows != 20 {41		t.Fatalf("source inspect: %+v %v", want, err)42	}4344	dir := t.TempDir()45	key, created, err := backup.LoadOrCreateKey(dir + "/keys/backup.key")46	if err != nil || !created {47		t.Fatal(err)48	}49	if st, _ := os.Stat(dir + "/keys/backup.key"); st.Mode().Perm() != 0o600 {50		t.Fatalf("key file mode %v", st.Mode().Perm())51	}52	res, err := backup.Create(ctx, url, dir, key)53	if err != nil {54		t.Skipf("pg_dump unavailable or failed: %v", err)55	}56	raw, _ := os.ReadFile(res.Path)57	if strings.Contains(string(raw), "usera") || strings.Contains(string(raw), "test.event") {58		t.Fatal("backup file contains plaintext")59	}60	if st, _ := os.Stat(res.Path); st.Mode().Perm() != 0o600 {61		t.Fatalf("backup file mode %v", st.Mode().Perm())62	}63	if n, err := backup.Verify(ctx, res.Path, key); err != nil || n < 20 {64		t.Fatalf("verify: %d entries, %v", n, err)65	}6667	// Restore into a fresh database and compare, including the audit hash chain.68	admin, err := pgx.Connect(ctx, "postgres://127.0.0.1/postgres?sslmode=disable")69	if err != nil {70		t.Fatal(err)71	}72	defer admin.Close(ctx)73	target := "mcc_test_restore_" + strings.ReplaceAll(uuid.NewString()[:8], "-", "")74	if _, err := admin.Exec(ctx, "create database "+target); err != nil {75		t.Fatal(err)76	}77	defer admin.Exec(context.Background(), "drop database if exists "+target+" with (force)")78	targetURL := "postgres://127.0.0.1/" + target + "?sslmode=disable"79	if err := backup.Restore(ctx, res.Path, key, targetURL); err != nil {80		t.Fatalf("restore: %v", err)81	}82	got, err := backup.Inspect(ctx, targetURL)83	if err != nil || got != want {84		t.Fatalf("restored copy differs:\n got  %+v\n want %+v (%v)", got, want, err)85	}86	// The append-only protection is restored too.87	c2, _ := pgx.Connect(ctx, targetURL)88	if _, err := c2.Exec(ctx, `delete from audit_log`); err == nil {89		t.Fatal("restored audit_log lost its append-only trigger")90	}91	c2.Close(ctx)9293	// Restoring over a non-empty database is refused.94	if err := backup.Restore(ctx, res.Path, key, targetURL); err == nil || !strings.Contains(err.Error(), "not empty") {95		t.Fatalf("restore over existing data: %v", err)96	}97	// A corrupted backup is rejected by verify and restores nothing.98	bad := dir + "/bad" + ".dump.enc"99	raw[len(raw)/2] ^= 0xff100	os.WriteFile(bad, raw, 0o600)101	if _, err := backup.Verify(ctx, bad, key); err == nil {102		t.Fatal("corrupted backup verified")103	}104	empty := "mcc_test_restore_" + strings.ReplaceAll(uuid.NewString()[:8], "-", "")105	admin.Exec(ctx, "create database "+empty)106	defer admin.Exec(context.Background(), "drop database if exists "+empty+" with (force)")107	emptyURL := "postgres://127.0.0.1/" + empty + "?sslmode=disable"108	if err := backup.Restore(ctx, bad, key, emptyURL); err == nil {109		t.Fatal("corrupted backup restored")110	}111	c3, _ := pgx.Connect(ctx, emptyURL)112	var tables int113	c3.QueryRow(ctx, `select count(*) from information_schema.tables where table_schema='public'`).Scan(&tables)114	c3.Close(ctx)115	if tables != 0 {116		t.Fatalf("a rejected backup left %d tables behind", tables)117	}118119	// Outcome recording and pruning.120	if err := backup.Record(ctx, pool, "postgres", "pg_dump+aes256gcm", res, nil, "test"); err != nil {121		t.Fatal(err)122	}123	var status string124	pool.QueryRow(ctx, `select last_status from backups where name='postgres'`).Scan(&status)125	if status != "ok" {126		t.Fatalf("status %q", status)127	}128	for _, n := range []string{"mcc-20200101T000000Z.dump.enc", "mcc-20200102T000000Z.dump.enc"} {129		os.WriteFile(dir+"/"+n, []byte("x"), 0o600)130	}131	removed, err := backup.Prune(dir, 2)132	if err != nil || len(removed) != 1 || removed[0] != "mcc-20200101T000000Z.dump.enc" {133		t.Fatalf("prune: %v %v", removed, err)134	}135}136
Files main
Menu

Theme