tracker
All repositories: gitoria
8.5 KB
// Cross-compat proof driver (mission 066, acceptance gate for D12):// exercises the Zig mpackdb engine against db files written by the REAL// JS mpackdb v1.0.7 — and writes db files the JS side then verifies.//// Companion JS scripts: testdata/compat/*.mjs (see their headers for setup).//// Usage:// zig run compat_driver.zig -- verify_a <dbfile> # read a JS-written db// zig run compat_driver.zig -- mutate_a <dbfile> # mutate it (JS re-verifies)// zig run compat_driver.zig -- write_b <dbfile> # write a fresh db for JS// zig run compat_driver.zig -- verify_b2 <dbfile> # verify JS-side mutationsconst std = @import("std");const msgpack = @import("msgpack.zig");const engine = @import("engine.zig");const P = std.debug.print;fn keyStr(s: []const u8) engine.Key {return .{ .str = s };}fn keyNum(n: f64) engine.Key {return .{ .num = n };}fn printValue(v: msgpack.Value) void {switch (v) {.nil => P("null", .{}),.undef => P("undefined", .{}),.boolean => |b| P("{}", .{b}),.number => |n| {var buf: [40]u8 = undefined;P("{s}", .{engine.jsNumFmt(&buf, n)});},.str => |s| P("\"{s}\"", .{s}),.bin => |b| P("<bin {d}>", .{b.len}),.array => |items| {P("[", .{});for (items, 0..) |it, i| {if (i > 0) P(",", .{});printValue(it);}P("]", .{});},.map => |entries| {P("{{", .{});for (entries, 0..) |e, i| {if (i > 0) P(",", .{});printValue(e.key);P(":", .{});printValue(e.value);}P("}}", .{});},.ext => |e| {if (v.timestampMs()) |ms| {var buf: [40]u8 = undefined;P("Date({s})", .{engine.jsNumFmt(&buf, ms)});} else {P("<ext {d} len {d}>", .{ e.type, e.data.len });}},}}fn printRecords(label: []const u8, db: *engine.Db, arena: std.mem.Allocator, locs: []const engine.Loc) !void {P("{s}: {d} record(s)\n", .{ label, locs.len });for (locs) |loc| {const rec = try db.readAt(arena, loc);P(" ", .{});printValue(rec);P("\n", .{});}}pub fn main(init: std.process.Init) !void {const gpa = init.gpa;var arena_state = std.heap.ArenaAllocator.init(gpa);defer arena_state.deinit();const arena = arena_state.allocator();var iter = std.process.Args.Iterator.init(init.minimal.args);_ = iter.next();const cmd = iter.next() orelse {P("usage: compat_driver <verify_a|mutate_a|write_b|verify_b2> <dbfile>\n", .{});return;};const dbfile = iter.next() orelse {P("missing dbfile\n", .{});return;};if (std.mem.eql(u8, cmd, "verify_a")) {// Open the JS-written db WITHOUT compaction so we read its files// (data, indexes, idxstate, meta) exactly as JS persisted them.const db = try engine.Db.open(gpa, dbfile, .{.primary_key = "*id",.indexes = &.{ "email", "*age" },.compact = false,});defer db.close();var locs: std.ArrayList(engine.Loc) = .empty;try db.findPkLocs(arena, keyNum(1), &locs);try printRecords("pk id=1", db, arena, locs.items);var locs2: std.ArrayList(engine.Loc) = .empty;try db.findIndexLocs(arena, "email", keyStr("[email protected]"), &locs2);try printRecords("[email protected]", db, arena, locs2.items);// Carol (id=2) was deleted by JS — her email must yield nothingvar locs2b: std.ArrayList(engine.Loc) = .empty;try db.findIndexLocs(arena, "email", keyStr("[email protected]"), &locs2b);P("[email protected] (JS-deleted): {d} record(s)\n", .{locs2b.items.len});var locs3: std.ArrayList(engine.Loc) = .empty;try db.findRangeLocs(arena, "age", keyNum(28), keyNum(40), &locs3);try printRecords("age in [28,40]", db, arena, locs3.items);// deleted record must be invisiblevar locs4: std.ArrayList(engine.Loc) = .empty;try db.findPkLocs(arena, keyNum(2), &locs4);P("pk id=2 (JS-deleted): {d} record(s)\n", .{locs4.items.len});// full scan countvar scanner = engine.Db.Scanner.init(db, arena, true);defer scanner.deinit();var count: usize = 0;while (try scanner.next(arena)) |_| count += 1;P("total live records: {d}\n", .{count});P("nextId: ", .{});var buf: [40]u8 = undefined;P("{s}\n", .{engine.jsNumFmt(&buf, db.next_id)});} else if (std.mem.eql(u8, cmd, "mutate_a")) {const db = try engine.Db.open(gpa, dbfile, .{.primary_key = "*id",.indexes = &.{ "email", "*age" },.compact = false,});defer db.close();// 1) insert a new record — auto id must continue the JS sequencevar rec = engine.Db.MutableRecord{};try rec.set(arena, "name", .{ .str = "Ziggy Stardust" });try rec.set(arena, "email", .{ .str = "[email protected]" });try rec.set(arena, "age", .{ .number = 99 });var tags = [_]msgpack.Value{ .{ .str = "zig" }, .{ .str = "native" } };try rec.set(arena, "tags", .{ .array = &tags });const res = try db.insert(arena, rec.toValue(), false);var buf: [40]u8 = undefined;P("inserted id={s}\n", .{engine.jsNumFmt(&buf, res.pk_num)});// 2) update id=0: bump age to 31, KEEP the Date field byte-identicalvar locs: std.ArrayList(engine.Loc) = .empty;try db.findPkLocs(arena, keyNum(0), &locs);if (locs.items.len != 1) return error.UpdateTargetMissing;const old = try db.readAt(arena, locs.items[0]);var upd = engine.Db.MutableRecord{};for (old.map) |e| try upd.entries.append(arena, e);try upd.set(arena, "age", .{ .number = 31 });const n_upd = try db.updatePk(arena, keyNum(0), upd.toValue());P("updated id=0: {d} record(s), age -> 31\n", .{n_upd});// 3) delete id=3var deleted: std.ArrayList(msgpack.Value) = .empty;const n_del = try db.deletePk(arena, keyNum(3), &deleted);P("deleted id=3: {d} record(s)\n", .{n_del});} else if (std.mem.eql(u8, cmd, "write_b")) {// Fresh Zig-written db with uuid pk + secondary indexes for JS to read.const db = try engine.Db.open(gpa, dbfile, .{.primary_key = "@uuid",.indexes = &.{ "city", "*score" },});defer db.close();const cities = [_][]const u8{ "Klagenfurt", "Helsinki", "Wörgl" };const names = [_][]const u8{ "Ada", "Böb", "Chidi" };const scores = [_]f64{ 12.5, -3, 4294967296 };for (cities, names, scores) |city, name, score| {var rec = engine.Db.MutableRecord{};try rec.set(arena, "name", .{ .str = name });try rec.set(arena, "city", .{ .str = city });try rec.set(arena, "score", .{ .number = score });var nested_entries = [_]msgpack.Entry{.{ .key = .{ .str = "active" }, .value = .{ .boolean = true } },.{ .key = .{ .str = "note" }, .value = .nil },};try rec.set(arena, "meta", .{ .map = &nested_entries });const res = try db.insert(arena, rec.toValue(), false);P("inserted uuid={s} ({s})\n", .{ res.pk_str, name });}} else if (std.mem.eql(u8, cmd, "verify_b2")) {const db = try engine.Db.open(gpa, dbfile, .{.primary_key = "@uuid",.indexes = &.{ "city", "*score" },.compact = false,});defer db.close();// JS inserted a marker record with city "Byrodin"var locs: std.ArrayList(engine.Loc) = .empty;try db.findIndexLocs(arena, "city", keyStr("Byrodin"), &locs);try printRecords("city=Byrodin (JS-inserted)", db, arena, locs.items);// JS deleted "Ada" — city Klagenfurt must be gonevar locs2: std.ArrayList(engine.Loc) = .empty;try db.findIndexLocs(arena, "city", keyStr("Klagenfurt"), &locs2);P("city=Klagenfurt (JS-deleted): {d} record(s)\n", .{locs2.items.len});var scanner = engine.Db.Scanner.init(db, arena, true);defer scanner.deinit();var count: usize = 0;while (try scanner.next(arena)) |_| count += 1;P("total live records: {d}\n", .{count});} else {P("unknown command {s}\n", .{cmd});}}
Branches
- mainmain branch
Latest commits
- 5cb85d75deploy.sh: a backup taken while a background job writes (tar exit 1) is a warning; archive checked with gzip -tmre
- 9abda75dtracker: report 035mre
- 12595e47mission 035: theme re-vendored from layouts.worldapi.org 0222f67 (two corner radii: radiusSmall 5px, radiusLarge 10px); the tracker's 18 own radii -> radiusSmall/radiusLarge (--layout-radius is gone); check-theme 0; gates 379/0, 32/0, 53/0, 229/0, 26/0; real copy: every computed radius in {0, 5px, 10px, 50%}mre
- e7305014tracker: report 032 (art + photos)mre
- fbb903cctracker#33/#37 (mission 032): a title without a TMDB poster gets its backdrop (w780, posterFromBackdrop, shown 2:3 centre-cropped); movies store runtime, the page shows release date + runtime; art backfill (public titles without poster file / movies without runtime) and person photo backfill (tmdbProfile / photoCheck) as the last start jobs (TRACKER_ART, TRACKER_PHOTOS; off in every gate start); gates 379/0, 32/0, 53/0, 229/0, 26/0, check-theme 0; live copy: art 4977 titles in 42 min (115 posters, 15 backdrops, 4609 runtimes), The Remaining shows its backdrop + 7 minmre
- 4ecc67b2tracker: STATUS/LOG for the t38 + t40 merge (gates 374/0, 32/0, 53/0, 229/0, 26/0, check-theme 0; live copy checks)mre
- e5945d2fMerge t40 (tracker#40 curated franchises, Franchises menu, superseded collections) into main: deploy.sh lists all six gates (browser, kinds, franchises, pager, franchiseseed, check-theme); search.hl keeps #37's personPhotoOf + #40's importWithCredits; pager gate runs with TRACKER_FRANCHISE_SEED=0; gates 374/0, 32/0, 53/0, 229/0, 26/0, check-theme 0mre
- b638e99dMerge t38 (tracker#38 pagination, #35 Returning/Airing label) into main: LOG/STATUS keep both sides; pager gate follows #37's /people (everyone, last updated first: seed updatedAt); gates pager 229/0, browser 374/0mre
- f8ffa4dbtracker: report 032 + The Remaining + #39mre
- 7565a863tracker: LOG timemre
- b10f00c8tracker#39: double episodes — migrated episodes whose TMDB id TMDB replaced are adopted by their number in the sync (old id -> migratedTmdbId); merge.hl step 3 merges each season's doubles at start (keeper: most watches > synced > first; watches moved/parked; tombstones into mergedEpisodes, nothing deleted); tools/count-duplicate-episodes.hl; gate fixture + paths-m039; live copy 850 -> 0 in 64 s; gates 373/0, 32/0, 52/0mre
- 8f1d4542tracker#40: superseded collections — a TMDB collection timeline whose titles are all in one curated timeline is hidden (supersededBy; kept: own page + editor finder), set by the collection seed when it makes one and by the curated build (lifted when the cover is gone); partly covered ones join that franchise; no second widget (First Contact: only Star Trek — Prime); gate franchiseseed 26/0, browser 365/0, kinds 32/0, franchises 53/0, check-theme 0; real copy 24 supersededmre
- 9448d643tracker#35 follow-up (mission 033): TVmaze 'Running' is labelled 'Returning', or 'Airing' while a non-special episode of the two newest seasons is released within today +-7 days (data unchanged); gate fixtures Running/Airing/Aired + a special; browser 366/0, kinds 32/0, franchises 52/0, pager 229/0, check-theme 0mre
- 7d4b293dtracker#40: "Franchises" in the main menu (desktop header after People, phone sidebar) → /franchises, marked on franchise and timeline pages; gates 365/0, 32/0, 53/0, 24/0, check-theme 0mre
- 8751adb8tracker: report 032mre
- 9bce1f65tracker mission 032: STATUS gate files + the hour-boundary flakemre
- 718bfb89tracker#37 (mission 032): /people = everyone, last updated first (updatedAt stamped by the person fill; view built at boot, touched people first at once), photo + name tiles (person colour) with the /movies pagination, /people/<letter> removed; photo = our file, tmdbProfile, a cast/crew entry's profile (in-memory map at boot), else the new 'no photo' placeholder; new cast/crew/created_by people keep tmdbProfile; search people rows with the photo; /settings = the heading only; util.hl sortDesc starts from sorted runs (same result, 105k: 1.6 s -> 0.15 s); gates 369/0, 32/0, 52/0, check-theme 0; README/STATUS/LOGmre
- 93dfb0batracker#40 (mission 034): the curated franchises — data/franchises.json (17 franchises, 31 timelines, 285 TMDB titles, movies + series, in-universe/release order, 12 TMDB collections attached); lib/franchiseseed.hl + jobs.hl franchiseSeedTick (last start job, imports missing titles via details.hl importWithCredits = the search's Add, one per step paced, then one build; franchiseseed.db: editor changes win, the creator's same-name franchise adopted / timeline left alone, 404 remembered, resumable, idempotent); timeline heads 'N titles · in-universe order' (orderKind) and wrap on a phone; series pages show the widget; new gate tests/franchiseseed.mjs (5th in deploy.sh), the others run with TRACKER_FRANCHISE_SEED=0; gates 365/0, 32/0, 52/0, 24/0, check-theme 0; real copy 196 imported, 0 failed, 7 min, restart unchanged=31mre
- 03ec792ftracker#38 (mission 033): pagination goes exactly to the clicked page — tilelist read the clicked button's text after pagination.hl's own handler had rebuilt the buttons (real clicks only); now li.current, else the button's own text; new gate tests/pager.mjs (5 lists x 11 pages, 390/1280, real + script clicks, Back/Forward) 229/0; browser 365/0, kinds 32/0, franchises 52/0, check-theme 0mre
- 96ba683adeploy.sh: a gate without a 'passed,' line (check-theme) no longer ends the scriptmre