102 lines
3.0 KiB
Go
102 lines
3.0 KiB
Go
package mariadb
|
|
|
|
import (
|
|
"archive/zip"
|
|
"database/sql"
|
|
"encoding/hex"
|
|
"encoding/json"
|
|
"errors"
|
|
"fmt"
|
|
"io"
|
|
"strings"
|
|
|
|
"git.mchus.pro/mchus/quoteforge/internal/appstate"
|
|
)
|
|
|
|
func readSnapshot(path string, visit func(snapshotTable, []sql.RawBytes) error) (*snapshotManifest, error) {
|
|
if err := appstate.ValidateBackupLocation(path); err != nil {
|
|
return nil, err
|
|
}
|
|
archive, err := zip.OpenReader(path)
|
|
if err != nil {
|
|
return nil, fmt.Errorf("open server snapshot: %w", err)
|
|
}
|
|
defer archive.Close()
|
|
files := map[string]*zip.File{}
|
|
for _, f := range archive.File {
|
|
if files[f.Name] != nil {
|
|
return nil, fmt.Errorf("duplicate snapshot entry")
|
|
}
|
|
files[f.Name] = f
|
|
}
|
|
manifestFile := files["manifest.json"]
|
|
if manifestFile == nil || manifestFile.UncompressedSize64 > 16<<20 {
|
|
return nil, fmt.Errorf("missing or oversized snapshot manifest")
|
|
}
|
|
in, err := manifestFile.Open()
|
|
if err != nil {
|
|
return nil, fmt.Errorf("open server manifest: %w", err)
|
|
}
|
|
data, readErr := io.ReadAll(in)
|
|
closeErr := in.Close()
|
|
if readErr != nil || closeErr != nil {
|
|
return nil, fmt.Errorf("read server manifest: %w", errors.Join(readErr, closeErr))
|
|
}
|
|
var m snapshotManifest
|
|
if err := json.Unmarshal(data, &m); err != nil {
|
|
return nil, fmt.Errorf("parse server manifest: %w", err)
|
|
}
|
|
if m.Format != 1 || m.Schema == "" || len(files) != len(m.Tables)+1 {
|
|
return nil, fmt.Errorf("invalid server snapshot manifest")
|
|
}
|
|
names, entries := map[string]bool{}, map[string]bool{}
|
|
for _, table := range m.Tables {
|
|
if table.Name == "" || names[table.Name] || entries[table.Entry] || files[table.Entry] == nil || len(table.Columns) == 0 || table.Rows < 0 || !strings.HasPrefix(table.Create, "CREATE TABLE "+quoteIdentifier(table.Name)+" (") {
|
|
return nil, fmt.Errorf("invalid snapshot table metadata")
|
|
}
|
|
names[table.Name], entries[table.Entry] = true, true
|
|
if err := readSnapshotTable(files[table.Entry], table, visit); err != nil {
|
|
return nil, err
|
|
}
|
|
}
|
|
return &m, nil
|
|
}
|
|
|
|
func readSnapshotTable(file *zip.File, table snapshotTable, visit func(snapshotTable, []sql.RawBytes) error) error {
|
|
in, err := file.Open()
|
|
if err != nil {
|
|
return fmt.Errorf("open snapshot table %s: %w", table.Name, err)
|
|
}
|
|
defer in.Close()
|
|
decoder := json.NewDecoder(in)
|
|
var rows int64
|
|
var digest [32]byte
|
|
for {
|
|
var values []sql.RawBytes
|
|
err := decoder.Decode(&values)
|
|
if err == io.EOF {
|
|
break
|
|
}
|
|
if err != nil {
|
|
return fmt.Errorf("read snapshot row in %s: %w", table.Name, err)
|
|
}
|
|
if len(values) != len(table.Columns) {
|
|
return fmt.Errorf("snapshot column count mismatch in %s", table.Name)
|
|
}
|
|
addRowDigest(&digest, values)
|
|
rows++
|
|
if visit != nil {
|
|
if err := visit(table, values); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
}
|
|
if err := in.Close(); err != nil {
|
|
return fmt.Errorf("close snapshot table %s: %w", table.Name, err)
|
|
}
|
|
if rows != table.Rows || hex.EncodeToString(digest[:]) != table.Digest {
|
|
return fmt.Errorf("snapshot checksum mismatch in %s", table.Name)
|
|
}
|
|
return nil
|
|
}
|