gitoriaLog in with ident

tracker

All repositories: gitoria

ReadmeCodePull requestsReleasesTicketsSettings
Branchmain5cb85d75deploy.sh: a backup taken while a background job writes (tar exit 1) is a warning; archive checked with gzip -tmremain/plugins/mpackdb/compat_driver.zig

8.5 KB

  1. // Cross-compat proof driver (mission 066, acceptance gate for D12):
  2. // exercises the Zig mpackdb engine against db files written by the REAL
  3. // JS mpackdb v1.0.7 — and writes db files the JS side then verifies.
  4. //
  5. // Companion JS scripts: testdata/compat/*.mjs (see their headers for setup).
  6. //
  7. // Usage:
  8. // zig run compat_driver.zig -- verify_a <dbfile> # read a JS-written db
  9. // zig run compat_driver.zig -- mutate_a <dbfile> # mutate it (JS re-verifies)
  10. // zig run compat_driver.zig -- write_b <dbfile> # write a fresh db for JS
  11. // zig run compat_driver.zig -- verify_b2 <dbfile> # verify JS-side mutations
  12. const std = @import("std");
  13. const msgpack = @import("msgpack.zig");
  14. const engine = @import("engine.zig");
  15. const P = std.debug.print;
  16. fn keyStr(s: []const u8) engine.Key {
  17. return .{ .str = s };
  18. }
  19. fn keyNum(n: f64) engine.Key {
  20. return .{ .num = n };
  21. }
  22. fn printValue(v: msgpack.Value) void {
  23. switch (v) {
  24. .nil => P("null", .{}),
  25. .undef => P("undefined", .{}),
  26. .boolean => |b| P("{}", .{b}),
  27. .number => |n| {
  28. var buf: [40]u8 = undefined;
  29. P("{s}", .{engine.jsNumFmt(&buf, n)});
  30. },
  31. .str => |s| P("\"{s}\"", .{s}),
  32. .bin => |b| P("<bin {d}>", .{b.len}),
  33. .array => |items| {
  34. P("[", .{});
  35. for (items, 0..) |it, i| {
  36. if (i > 0) P(",", .{});
  37. printValue(it);
  38. }
  39. P("]", .{});
  40. },
  41. .map => |entries| {
  42. P("{{", .{});
  43. for (entries, 0..) |e, i| {
  44. if (i > 0) P(",", .{});
  45. printValue(e.key);
  46. P(":", .{});
  47. printValue(e.value);
  48. }
  49. P("}}", .{});
  50. },
  51. .ext => |e| {
  52. if (v.timestampMs()) |ms| {
  53. var buf: [40]u8 = undefined;
  54. P("Date({s})", .{engine.jsNumFmt(&buf, ms)});
  55. } else {
  56. P("<ext {d} len {d}>", .{ e.type, e.data.len });
  57. }
  58. },
  59. }
  60. }
  61. fn printRecords(label: []const u8, db: *engine.Db, arena: std.mem.Allocator, locs: []const engine.Loc) !void {
  62. P("{s}: {d} record(s)\n", .{ label, locs.len });
  63. for (locs) |loc| {
  64. const rec = try db.readAt(arena, loc);
  65. P(" ", .{});
  66. printValue(rec);
  67. P("\n", .{});
  68. }
  69. }
  70. pub fn main(init: std.process.Init) !void {
  71. const gpa = init.gpa;
  72. var arena_state = std.heap.ArenaAllocator.init(gpa);
  73. defer arena_state.deinit();
  74. const arena = arena_state.allocator();
  75. var iter = std.process.Args.Iterator.init(init.minimal.args);
  76. _ = iter.next();
  77. const cmd = iter.next() orelse {
  78. P("usage: compat_driver <verify_a|mutate_a|write_b|verify_b2> <dbfile>\n", .{});
  79. return;
  80. };
  81. const dbfile = iter.next() orelse {
  82. P("missing dbfile\n", .{});
  83. return;
  84. };
  85. if (std.mem.eql(u8, cmd, "verify_a")) {
  86. // Open the JS-written db WITHOUT compaction so we read its files
  87. // (data, indexes, idxstate, meta) exactly as JS persisted them.
  88. const db = try engine.Db.open(gpa, dbfile, .{
  89. .primary_key = "*id",
  90. .indexes = &.{ "email", "*age" },
  91. .compact = false,
  92. });
  93. defer db.close();
  94. var locs: std.ArrayList(engine.Loc) = .empty;
  95. try db.findPkLocs(arena, keyNum(1), &locs);
  96. try printRecords("pk id=1", db, arena, locs.items);
  97. var locs2: std.ArrayList(engine.Loc) = .empty;
  98. try db.findIndexLocs(arena, "email", keyStr("[email protected]"), &locs2);
  99. try printRecords("[email protected]", db, arena, locs2.items);
  100. // Carol (id=2) was deleted by JS — her email must yield nothing
  101. var locs2b: std.ArrayList(engine.Loc) = .empty;
  102. try db.findIndexLocs(arena, "email", keyStr("[email protected]"), &locs2b);
  103. P("[email protected] (JS-deleted): {d} record(s)\n", .{locs2b.items.len});
  104. var locs3: std.ArrayList(engine.Loc) = .empty;
  105. try db.findRangeLocs(arena, "age", keyNum(28), keyNum(40), &locs3);
  106. try printRecords("age in [28,40]", db, arena, locs3.items);
  107. // deleted record must be invisible
  108. var locs4: std.ArrayList(engine.Loc) = .empty;
  109. try db.findPkLocs(arena, keyNum(2), &locs4);
  110. P("pk id=2 (JS-deleted): {d} record(s)\n", .{locs4.items.len});
  111. // full scan count
  112. var scanner = engine.Db.Scanner.init(db, arena, true);
  113. defer scanner.deinit();
  114. var count: usize = 0;
  115. while (try scanner.next(arena)) |_| count += 1;
  116. P("total live records: {d}\n", .{count});
  117. P("nextId: ", .{});
  118. var buf: [40]u8 = undefined;
  119. P("{s}\n", .{engine.jsNumFmt(&buf, db.next_id)});
  120. } else if (std.mem.eql(u8, cmd, "mutate_a")) {
  121. const db = try engine.Db.open(gpa, dbfile, .{
  122. .primary_key = "*id",
  123. .indexes = &.{ "email", "*age" },
  124. .compact = false,
  125. });
  126. defer db.close();
  127. // 1) insert a new record — auto id must continue the JS sequence
  128. var rec = engine.Db.MutableRecord{};
  129. try rec.set(arena, "name", .{ .str = "Ziggy Stardust" });
  130. try rec.set(arena, "email", .{ .str = "[email protected]" });
  131. try rec.set(arena, "age", .{ .number = 99 });
  132. var tags = [_]msgpack.Value{ .{ .str = "zig" }, .{ .str = "native" } };
  133. try rec.set(arena, "tags", .{ .array = &tags });
  134. const res = try db.insert(arena, rec.toValue(), false);
  135. var buf: [40]u8 = undefined;
  136. P("inserted id={s}\n", .{engine.jsNumFmt(&buf, res.pk_num)});
  137. // 2) update id=0: bump age to 31, KEEP the Date field byte-identical
  138. var locs: std.ArrayList(engine.Loc) = .empty;
  139. try db.findPkLocs(arena, keyNum(0), &locs);
  140. if (locs.items.len != 1) return error.UpdateTargetMissing;
  141. const old = try db.readAt(arena, locs.items[0]);
  142. var upd = engine.Db.MutableRecord{};
  143. for (old.map) |e| try upd.entries.append(arena, e);
  144. try upd.set(arena, "age", .{ .number = 31 });
  145. const n_upd = try db.updatePk(arena, keyNum(0), upd.toValue());
  146. P("updated id=0: {d} record(s), age -> 31\n", .{n_upd});
  147. // 3) delete id=3
  148. var deleted: std.ArrayList(msgpack.Value) = .empty;
  149. const n_del = try db.deletePk(arena, keyNum(3), &deleted);
  150. P("deleted id=3: {d} record(s)\n", .{n_del});
  151. } else if (std.mem.eql(u8, cmd, "write_b")) {
  152. // Fresh Zig-written db with uuid pk + secondary indexes for JS to read.
  153. const db = try engine.Db.open(gpa, dbfile, .{
  154. .primary_key = "@uuid",
  155. .indexes = &.{ "city", "*score" },
  156. });
  157. defer db.close();
  158. const cities = [_][]const u8{ "Klagenfurt", "Helsinki", "Wörgl" };
  159. const names = [_][]const u8{ "Ada", "Böb", "Chidi" };
  160. const scores = [_]f64{ 12.5, -3, 4294967296 };
  161. for (cities, names, scores) |city, name, score| {
  162. var rec = engine.Db.MutableRecord{};
  163. try rec.set(arena, "name", .{ .str = name });
  164. try rec.set(arena, "city", .{ .str = city });
  165. try rec.set(arena, "score", .{ .number = score });
  166. var nested_entries = [_]msgpack.Entry{
  167. .{ .key = .{ .str = "active" }, .value = .{ .boolean = true } },
  168. .{ .key = .{ .str = "note" }, .value = .nil },
  169. };
  170. try rec.set(arena, "meta", .{ .map = &nested_entries });
  171. const res = try db.insert(arena, rec.toValue(), false);
  172. P("inserted uuid={s} ({s})\n", .{ res.pk_str, name });
  173. }
  174. } else if (std.mem.eql(u8, cmd, "verify_b2")) {
  175. const db = try engine.Db.open(gpa, dbfile, .{
  176. .primary_key = "@uuid",
  177. .indexes = &.{ "city", "*score" },
  178. .compact = false,
  179. });
  180. defer db.close();
  181. // JS inserted a marker record with city "Byrodin"
  182. var locs: std.ArrayList(engine.Loc) = .empty;
  183. try db.findIndexLocs(arena, "city", keyStr("Byrodin"), &locs);
  184. try printRecords("city=Byrodin (JS-inserted)", db, arena, locs.items);
  185. // JS deleted "Ada" — city Klagenfurt must be gone
  186. var locs2: std.ArrayList(engine.Loc) = .empty;
  187. try db.findIndexLocs(arena, "city", keyStr("Klagenfurt"), &locs2);
  188. P("city=Klagenfurt (JS-deleted): {d} record(s)\n", .{locs2.items.len});
  189. var scanner = engine.Db.Scanner.init(db, arena, true);
  190. defer scanner.deinit();
  191. var count: usize = 0;
  192. while (try scanner.next(arena)) |_| count += 1;
  193. P("total live records: {d}\n", .{count});
  194. } else {
  195. P("unknown command {s}\n", .{cmd});
  196. }
  197. }

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