package mariadb import ( "archive/zip" "database/sql" "encoding/hex" "encoding/json" "os" "path/filepath" "testing" ) func TestSnapshotRowsAndValidation(t *testing.T) { row := []sql.RawBytes{[]byte{0, 1, 255}, {}, nil} var sum [32]byte addRowDigest(&sum, row) for _, tt := range []struct { name string format int rows int64 digest string width int valid bool }{ {"valid", 1, 1, hex.EncodeToString(sum[:]), 3, true}, {"bad format", 2, 1, hex.EncodeToString(sum[:]), 3, false}, {"bad count", 1, 2, hex.EncodeToString(sum[:]), 3, false}, {"bad digest", 1, 1, "invalid", 3, false}, {"bad width", 1, 1, hex.EncodeToString(sum[:]), 2, false}, } { t.Run(tt.name, func(t *testing.T) { path := filepath.Join(t.TempDir(), "backup.zip") file, err := os.Create(path) if err != nil { t.Fatal(err) } archive := zip.NewWriter(file) entry, err := archive.Create("table.jsonl") if err != nil { t.Fatal(err) } if err := json.NewEncoder(entry).Encode(row); err != nil { t.Fatal(err) } entry, err = archive.Create("manifest.json") if err != nil { t.Fatal(err) } table := snapshotTable{Name: "example", Create: "CREATE TABLE `example` (id INT)", Entry: "table.jsonl", Columns: []string{"a", "b", "c"}[:tt.width], Rows: tt.rows, Digest: tt.digest} if err := json.NewEncoder(entry).Encode(snapshotManifest{Format: tt.format, Schema: "example", Tables: []snapshotTable{table}}); err != nil { t.Fatal(err) } if err := archive.Close(); err != nil { t.Fatal(err) } if err := file.Close(); err != nil { t.Fatal(err) } _, err = readSnapshot(path, nil) if (err == nil) != tt.valid { t.Fatalf("valid=%v err=%v", tt.valid, err) } if !tt.valid { if err := RestoreSnapshot(nil, path); err == nil { t.Fatal("invalid archive reached restore without preflight refusal") } } }) } } func TestSnapshotDigestPreservesValues(t *testing.T) { a, b := []sql.RawBytes{[]byte("a")}, []sql.RawBytes{[]byte("b")} var forward, reverse, null, empty [32]byte addRowDigest(&forward, a) addRowDigest(&forward, b) addRowDigest(&reverse, b) addRowDigest(&reverse, a) if forward != reverse { t.Fatal("digest depends on row order") } addRowDigest(&null, []sql.RawBytes{nil}) addRowDigest(&empty, []sql.RawBytes{{}}) if null == empty { t.Fatal("digest conflates NULL and empty bytes") } }