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 }