88 lines
2.4 KiB
Go
88 lines
2.4 KiB
Go
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")
|
|
}
|
|
}
|