Repository Public
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