[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_261":262,"_263":264},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_40":-7,"_152":-5,"_19":153,"_154":155,"_156":157,"_158":159,"_160":161,"_21":162,"_163":-5,"_164":-5,"_165":24,"_166":167,"_168":169,"_170":-5,"_171":-5,"_172":173},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","plusjade","name","source-gtb","branchName","main","path","gtbSource.ts","project",{"_34":101,"_13":14,"_38":102,"_87":-5,"_103":24,"_104":105,"_106":105,"_107":108,"_109":-5,"_30":70,"_110":111,"_112":24,"_113":-5,"_114":-5,"_115":26,"_42":43,"_116":117,"_118":119,"_120":121,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_55":132,"_133":134,"_135":136,"_137":24},"file",{"_65":66,"_13":18,"_67":68,"_69":24,"_100":-5},"isDirectory",false,"page",0,"history",[31,32,33],"hasNext","userId",{"_34":88,"_36":37,"_38":89,"_40":90,"_42":43,"_44":73,"_46":91,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":78,"_55":92,"_21":93,"_58":-5,"_59":94,"_60":-5,"_61":-5,"_62":95},{"_34":73,"_36":37,"_38":74,"_40":75,"_42":43,"_44":76,"_46":77,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":78,"_55":79,"_21":80,"_58":-5,"_59":81,"_60":-5,"_61":-5,"_62":82},{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":63},"id","cb2568ed-8860-42ce-9c4e-be8fb8aca61d","branchId","a3048ec0-333a-4b49-9884-3544cf56b1bc","createdAt",["D",1788937029426],"version",2,"orgId","5a10edca-919b-4a78-babb-71908f69af93","parentId","80b93071-73e7-4322-ac4f-9998725e5382","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","Claude","user",{"_34":70,"_42":43,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":68,"_69":24},"pull","merge","revert","multiple","commits",[64],{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":56,"_21":57,"_58":-5,"_59":-5,"_60":-5},"fileId","ad286ed8-ac1b-11f1-95ee-1607ee4eb77e","fileType","script","deleted","b0a8da26-58e7-4d19-8b5c-eedf487df9a9","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVHpab25kTlBTM3M3WmpCa3NMSTd5akVwWksuanBlZyJ9","ff7f4cca-1b82-4617-92f9-0b3f9b113593",["D",1789230693679],8,"b2b491ad-7da4-4853-ba79-9bd52522ac37","9f97ace1-495d-48dd-8b83-869f248f0045","ChatGPT",{"_34":70,"_42":43,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":68,"_69":24},{"_36":84,"_13":85,"_40":86,"_87":-5},[83],{"_34":73,"_36":37,"_38":74,"_40":75,"_42":43,"_44":76,"_46":77,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":78,"_55":79,"_21":80,"_58":-5,"_59":81,"_60":-5},"caf01072-0b69-496f-9756-972ac4951352","codex-gtb-item-windows",15,"deletedAt","958f71b3-eba7-40b7-8266-afc76a1f1a14",["D",1789230852564],9,"d0296732-0807-40f2-a200-8c2d955929ff",{"_34":70,"_42":43,"_11":12,"_71":72},{"_65":66,"_13":18,"_67":68,"_69":24},{"_36":97,"_13":98,"_40":99,"_87":-5},[96],{"_34":88,"_36":37,"_38":89,"_40":90,"_42":43,"_44":73,"_46":91,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":52,"_53":78,"_55":92,"_21":93,"_58":-5,"_59":94,"_60":-5},"93ca6783-b041-4938-b723-d4d7685cb9c4","codex-gtb-starts-at",5,"deletedAtVersion","a7b2eeb5-f918-4692-b7a6-a0c0bf445b34",["D",1788937002070],"legacyEnvVars","privacy","public","httpPrivacy","description","Clark View source: flea medication reminder, 8th of every month","imageUrl","pinnedFileId","c169c7a2-ac1b-11f1-80ba-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","a7b2eeb5f9184692b7a6a0c0bf445b34","tursoHostname","a7b2eeb5f9184692b7a6a0c0bf445b34-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789458074143],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_151":72},"org",{"_11":12,"_147":-5,"_71":72,"_30":70,"_148":149,"_150":24},"branch",{"_40":138,"_13":16,"_34":37,"_139":101,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"isOwned",11,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":101,"_13":14,"_38":256,"_87":-5,"_103":24,"_104":105,"_106":105,"_107":108,"_109":-5,"_30":70,"_110":111,"_112":24,"_113":-5,"_114":-5,"_115":26,"_42":43,"_116":117,"_118":119,"_120":257,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_55":258,"_133":259,"_135":260,"_137":24},"tree",[194,196,197,198,199,200,201],"files",[194,195,196,197,198,199,200,201],"counts",{"_182":26,"_183":184,"_185":26,"_186":187,"_188":189},"contents",[],{"_34":174,"_13":18,"_65":66,"_44":-5,"_36":37,"_175":90,"_176":169,"_38":177,"_40":41,"_67":68,"_178":179,"_69":24,"_180":-5,"_17":181},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},"ba2ed046-9034-4597-8cd8-4de431f2e5f6","branchVersion","latest",["D",1789230852564],"content","// Flea-medication reminder source: the 8th of every month, and nothing else.\n// Device settings are always empty; storage is GTB-only. main_text/sub_text\n// are stored as real columns, not a JSON payload, since every row carries\n// the same fixed reminder text.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { accept, reject, record, type Item, defineSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport { monthlyDatesAfter, noonInZoneUtcSeconds } from \"./lib/schedule.ts\";\n\nconst FALLBACK_ZONE = \"America/Los_Angeles\";\nconst REMINDER_ZONE = \"America/Los_Angeles\";\nconst REMINDER_DAY = 8;\nconst REMINDER_DURATION_SECONDS = 3600;\nconst MAIN_TEXT = \"Give Flea medication\";\nconst SUB_TEXT = \"Gemma, Bron, Tilka \\u{1F408}\\u{1F408}‍⬛\\u{1F408}\";\n\n/** Provision at deployment, never on a feed read. */\nexport async function ensureSchema(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS flea_medication_reminders(\n date_key TEXT PRIMARY KEY,\n main_text TEXT NOT NULL,\n sub_text TEXT NOT NULL,\n starts_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL,\n fetched_at TEXT NOT NULL\n )`);\n}\n\n/** Whole-day offset context for a reader; `null` means the parent had none. */\nexport function offsetSecondsFor(offset: number | null, dateKey: string): number {\n if (offset !== null && offset >= -43200 && offset <= 50400) return offset;\n // Not UTC: treating a missing offset as 0 would move every day boundary to\n // Greenwich. Match Moon/Lunar's fallback zone, resolved for the day in question.\n const name = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: FALLBACK_ZONE,\n timeZoneName: \"longOffset\",\n }).formatToParts(new Date(dateKey + \"T12:00:00Z\"))\n .find((p) => p.type === \"timeZoneName\")?.value ?? \"GMT+00:00\";\n const [, sign, hh, mm] = /GMT([+-])(\\d{2}):(\\d{2})/.exec(name) ?? [, \"+\", \"00\", \"00\"];\n return (sign === \"-\" ? -1 : 1) * (Number(hh) * 3600 + Number(mm) * 60);\n}\n\n/** The reader's current civil date. */\nexport function fromDate(offset: number | null, now = new Date()): string {\n const today = now.toISOString().slice(0, 10);\n return new Date(now.getTime() + offsetSecondsFor(offset, today) * 1000)\n .toISOString().slice(0, 10);\n}\n\nexport async function gtbItems(dateKey: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT date_key, main_text, sub_text, starts_at, expires_at FROM flea_medication_reminders WHERE date_key >= ? ORDER BY date_key LIMIT 1\",\n args: [dateKey],\n });\n const row = result.rows[0];\n if (!row) return [];\n return [{\n id: `gtb-${row.date_key}`,\n mainText: String(row.main_text),\n subText: String(row.sub_text),\n // Noon Pacific is the actual reminder instant, not a whole-day or\n // astronomical event, so let the widget render it as a real clock time.\n caption: null,\n emphasized: false,\n startsAt: Number(row.starts_at),\n expiresAt: Number(row.expires_at),\n }];\n}\n\n/** Replace the next `count` monthly reminders authoritatively, starting after `afterDateKey`. */\nexport async function rebuildSchedule(count: number, afterDateKey: string): Promise {\n await ensureSchema();\n const dateKeys = monthlyDatesAfter(REMINDER_DAY, count, afterDateKey);\n const fetchedAt = new Date().toISOString();\n for (const dateKey of dateKeys) {\n const startsAt = noonInZoneUtcSeconds(dateKey, REMINDER_ZONE);\n await sqlite.execute({\n sql: `INSERT INTO flea_medication_reminders(date_key,main_text,sub_text,starts_at,expires_at,fetched_at) VALUES(?,?,?,?,?,?)\n ON CONFLICT(date_key) DO UPDATE SET main_text=excluded.main_text,sub_text=excluded.sub_text,starts_at=excluded.starts_at,expires_at=excluded.expires_at,fetched_at=excluded.fetched_at`,\n args: [dateKey, MAIN_TEXT, SUB_TEXT, startsAt, startsAt + REMINDER_DURATION_SECONDS, fetchedAt],\n });\n }\n return dateKeys.length;\n}\n\nexport default defineSource({\n key: \"gtb\",\n settingsSchema: { type: \"object\", properties: {}, additionalProperties: false },\n parseSettings: (raw) => Object.keys(raw).length === 0 ? accept(null) : reject(\"invalid_settings\"),\n read: (_, { utcOffsetSeconds }) => gtbItems(fromDate(utcOffsetSeconds)),\n writes: {\n // Idempotent authoritative rebuild, mirroring Lunar's calendar.rebuild:\n // the only way this fixed-formula schedule needs to change is extending\n // the window, so there is no per-date upstream to page through.\n \"reminders.rebuild\": async (raw) => {\n const count = raw.count;\n const after = raw.after;\n if (!record(raw) || typeof count !== \"number\" || !Number.isInteger(count)\n || count < 1 || count > 60\n || typeof after !== \"string\" || !/^\\d{4}-\\d{2}-\\d{2}$/.test(after)) {\n return reject(\"invalid_rebuild_payload\");\n }\n return accept({ count: await rebuildSchedule(count, after) });\n },\n },\n});\n","label",[18],"pulls","branches",3,"forks","envVars",{"_190":192,"_193":26},"connections",{"_190":26,"_191":26},"count","unfilledCount",1,"emptyCount",{"_34":251,"_13":250,"_65":245,"_44":-5,"_36":37,"_175":192,"_176":169,"_38":252,"_40":26,"_67":253,"_178":-5,"_69":24,"_180":-5,"_207":254,"_17":255},{"_34":242,"_13":243,"_65":244,"_44":245,"_36":37,"_175":192,"_176":169,"_38":246,"_40":26,"_67":68,"_178":247,"_69":24,"_180":-5,"_207":248,"_17":249},{"_34":234,"_13":235,"_65":236,"_44":-5,"_36":37,"_175":237,"_176":169,"_38":238,"_40":26,"_67":21,"_178":239,"_69":24,"_180":-5,"_207":240,"_17":241},{"_34":227,"_13":228,"_65":229,"_44":-5,"_36":37,"_175":138,"_176":169,"_38":230,"_40":184,"_67":21,"_178":231,"_69":24,"_180":-5,"_207":232,"_17":233},{"_34":220,"_13":221,"_65":222,"_44":-5,"_36":37,"_175":75,"_176":169,"_38":223,"_40":184,"_67":68,"_178":224,"_69":24,"_180":-5,"_207":225,"_17":226},{"_34":174,"_13":18,"_65":66,"_44":-5,"_36":37,"_175":90,"_176":169,"_38":217,"_40":41,"_67":68,"_178":179,"_69":24,"_180":-5,"_207":218,"_17":219},{"_34":210,"_13":211,"_65":212,"_44":-5,"_36":37,"_175":75,"_176":169,"_38":213,"_40":26,"_67":68,"_178":214,"_69":24,"_180":-5,"_207":215,"_17":216},{"_34":202,"_13":203,"_65":111,"_44":-5,"_36":37,"_175":75,"_176":169,"_38":204,"_40":192,"_67":205,"_178":206,"_69":24,"_180":-5,"_207":208,"_17":209},"94204429-75e0-4b77-a2fa-3489bd9d96fe","rpc.ts",["D",1789230693679],"http","// Deployment authentication around the shared source protocol.\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport gtb from \"./gtbSource.ts\";\nexport default function handler(req: Request): Promise | Response {\n const token = Deno.env.get(\"SOURCE_GTB_V1_TOKEN\");\n if (!token) return Response.json({error:\"RPC token not configured\"},{status:503});\n if (req.headers.get(\"authorization\") !== `Bearer ${token}`) {\n return Response.json({error:\"unauthorized\"},{status:401});\n }\n return serveSource(gtb, req);\n}\n","children",[],[203],"f0043e4a-5a49-4b3c-8f7e-a2a2b3cbde3c","http-check.ts","6ab3a33e-aec7-11f1-9b08-1607ee4eb77e",["D",1789230693679],"// Read-only verification of the deployed GTB protocol and stored windows.\nconst endpoint = \"https://plusjade--c169c7a2ac1b11f180ba1607ee4eb77e.web.val.run\";\nconst token = Deno.env.get(\"SOURCE_GTB_V1_TOKEN\");\nif (!token) throw new Error(\"SOURCE_GTB_V1_TOKEN is required\");\nconst headers = { authorization: `Bearer ${token}`, \"content-type\": \"application/json\" };\nconst unauth = await fetch(endpoint + \"/v1/descriptor?sourceKey=gtb\");\nif (unauth.status !== 401) throw new Error(\"Expected unauthenticated rejection\");\nconst descriptor = await fetch(endpoint + \"/v1/descriptor?sourceKey=gtb\", { headers });\nconst desc = await descriptor.json();\nif (!descriptor.ok || desc.sourceKey !== \"gtb\" || !desc.temporal) throw new Error(\"Invalid descriptor\");\nfor (const utcOffsetSeconds of [null, -43200, 50400]) {\n const response = await fetch(endpoint + \"/v1/read\", {\n method: \"POST\", headers,\n body: JSON.stringify({ protocolVersion: 1, sourceKey: \"gtb\", settings: {}, context: { utcOffsetSeconds } }),\n });\n const body = await response.json();\n if (!response.ok || body.protocolVersion !== 1 || body.sourceKey !== \"gtb\" || !body.items?.length)\n throw new Error(\"Expected a nonempty deployed feed; check stored schedule coverage\");\n for (const item of body.items) {\n if (!Number.isInteger(item.startsAt) || item.expiresAt !== item.startsAt + 3600 || \"timestamp\" in item)\n throw new Error(\"Invalid deployed window\");\n }\n}\nconsole.log(\"PASS: deployed authenticated descriptor/read, nonempty one-hour windows, timezone edges and auth rejection\");\n",[],[211],["D",1789230852564],[],[18],"9cd878da-8429-4fdb-8861-8a02b20823de","check.ts","cc43f72e-ac1b-11f1-bbe2-1607ee4eb77e",["D",1789230693679],"// GTB contract, schedule and storage checks. Disposable rows are removed.\nimport handler from \"./rpc.ts\";\nimport gtb from \"./gtbSource.ts\";\nimport { fromDate, gtbItems, offsetSecondsFor, rebuildSchedule, ensureSchema } from \"./gtbSource.ts\";\nimport { monthlyDatesAfter, noonInZoneUtcSeconds } from \"./lib/schedule.ts\";\nimport { serveSource } from \"https://esm.town/v/plusjade/source-sdk@12-main/mod.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nfunction check(ok: unknown, message: string) { if (!ok) throw new Error(message); }\nconst base = { protocolVersion: 1, sourceKey: \"gtb\" };\n\n// The protocol is exercised through the definition; the mount below is checked\n// for authentication only, so these checks need no token to run.\nfunction call(path: string, body?: unknown) {\n return serveSource(gtb, new Request(\"https://gtb.invalid\" + path, {\n method: body === undefined ? \"GET\" : \"POST\",\n ...(body === undefined ? {} : { body: JSON.stringify(body) }),\n }));\n}\n\n// --- schedule arithmetic ------------------------------------------------------\nconst dates = monthlyDatesAfter(8, 12, \"2026-09-09\");\ncheck(dates.length === 12, \"twelve dates\");\ncheck(dates[0] === \"2026-10-08\", \"starts after this month's 8th has already passed\");\ncheck(dates[11] === \"2027-09-08\", \"twelve months out\");\ncheck(dates.every((d, i) => i === 0 || d > dates[i - 1]), \"ascending\");\ncheck(new Set(dates).size === dates.length, \"unique date keys\");\ncheck(dates.every((d) => d.slice(8, 10) === \"08\"), \"always the 8th\");\ncheck(monthlyDatesAfter(8, 3, \"2026-01-08\")[0] === \"2026-02-08\", \"on-the-day is not after itself\");\ncheck(monthlyDatesAfter(31, 1, \"2026-03-01\")[0] === \"2026-03-31\", \"31st exists in a long month\");\ncheck(monthlyDatesAfter(31, 1, \"2026-01-31\")[0] === \"2026-02-28\", \"clamped in a short month\");\n\ncheck(noonInZoneUtcSeconds(\"2026-10-08\", \"America/Los_Angeles\") === Date.parse(\"2026-10-08T19:00:00Z\") / 1000, \"PDT noon offset\");\ncheck(noonInZoneUtcSeconds(\"2026-11-08\", \"America/Los_Angeles\") === Date.parse(\"2026-11-08T20:00:00Z\") / 1000, \"PST noon offset\");\ncheck(noonInZoneUtcSeconds(\"2027-09-08\", \"America/Los_Angeles\") === Date.parse(\"2027-09-08T19:00:00Z\") / 1000, \"PDT noon offset a year out\");\n\n// --- offsets and selection ---------------------------------------------------\ncheck(offsetSecondsFor(50400, \"2026-06-01\") === 50400, \"offset passthrough\");\ncheck(offsetSecondsFor(null, \"2026-01-04\") === -28800, \"null falls back to Pacific standard\");\n\n// --- protocol ----------------------------------------------------------------\nconst desc = await (await call(\"/v1/descriptor?sourceKey=gtb\")).json();\ncheck(desc.temporal && desc.sourceKey === \"gtb\", \"descriptor\");\ncheck(JSON.stringify(desc.capabilities.write) === '[\"reminders.rebuild\"]', \"writes\");\ncheck((await call(\"/v1/read\", { ...base, settings: { x: 1 }, context: { utcOffsetSeconds: 0 } })).status === 400, \"settings\");\ncheck((await call(\"/v1/read\", { ...base, sourceKey: \"moon\", settings: {}, context: { utcOffsetSeconds: 0 } })).status === 404, \"wrong source\");\ncheck((await call(\"/v1/write\", { ...base, operation: \"toString\", payload: {} })).status === 422, \"unsupported write\");\ncheck((await call(\"/v1/write\", { ...base, operation: \"reminders.rebuild\", payload: { count: \"12\", after: \"2026-09-09\" } })).status === 400, \"non-numeric count\");\ncheck((await call(\"/v1/write\", { ...base, operation: \"reminders.rebuild\", payload: { count: 12, after: \"bad-date\" } })).status === 400, \"bad after date\");\ncheck((await call(\"/v1/publish\", base)).status === 501, \"publish\");\n\n// The mount adds only authentication.\nconst unauth = await handler(new Request(\"https://gtb.invalid/v1/descriptor\"));\ncheck(unauth.status === 401 || unauth.status === 503, \"mount rejects a missing bearer\");\nconst token = Deno.env.get(\"SOURCE_GTB_V1_TOKEN\");\nif (token) {\n const authed = await handler(new Request(\"https://gtb.invalid/v1/descriptor?sourceKey=gtb\", {\n headers: { authorization: `Bearer ${token}` },\n }));\n check(authed.ok, \"mount accepts the configured bearer\");\n}\n\n// --- storage round trip ------------------------------------------------------\nawait ensureSchema();\nconst fixtureYear = \"1901\";\nconst fixtureAfter = `${fixtureYear}-01-01`;\ntry {\n const count = await rebuildSchedule(2, fixtureAfter);\n check(count === 2, \"rebuild writes the requested count\");\n check(await rebuildSchedule(2, fixtureAfter) === 2, \"rebuild is idempotent\");\n\n const first = monthlyDatesAfter(8, 1, fixtureAfter)[0];\n const [item] = await gtbItems(first);\n check(item.id === `gtb-${first}`, \"stable id\");\n check(item.mainText === \"Give Flea medication\", \"main text\");\n check(item.subText === \"Gemma, Bron, Tilka \\u{1F408}\\u{1F408}‍⬛\\u{1F408}\", \"sub text\");\n check(item.caption === null, \"no caption: the timestamp itself is the reminder time\");\n check(item.startsAt === noonInZoneUtcSeconds(first, \"America/Los_Angeles\"), \"stored noon-Pacific instant\");\n check(item.expiresAt === item.startsAt + 3600, \"one-hour stored expiry\");\n check(!(\"timestamp\" in item), \"source emits window fields only\");\n check((await gtbItems(\"2200-01-01\")).length === 0, \"exhaustion past the ingested window\");\n check((await gtbItems(fromDate(null, new Date(first + \"T00:00:00Z\"))))[0]?.id === `gtb-${first}`, \"fromDate selects the fixture row\");\n} finally {\n await sqlite.execute({ sql: \"DELETE FROM flea_medication_reminders WHERE date_key LIKE ?\", args: [`${fixtureYear}-%`] });\n}\n\nconsole.log(\"PASS: GTB schedule arithmetic, noon-Pacific conversion, offsets, protocol, auth, storage and cleanup\");\n",[],[221],"4bc0352c-69e8-4528-a9ac-dc272eb67c81","README.md","081ea708-ac1c-11f1-bbe2-1607ee4eb77e",["D",1789231745657],"# source-gtb\n\nA Clark View source that reminds to give flea medication on the 8th of every\nmonth, and nothing else. Every row carries the same fixed text.\n\nBuilt on the shared [source SDK](https://www.val.town/x/plusjade/source-sdk):\nprotocol v1 over `rpc.ts`, bearer-authenticated, SQLite owned by this val.\n\n## Agent data entry\n\n[AGENTS.md](AGENTS.md) owns the `add-entry:` shortcut for individual custom events,\nincluding normalization, conflict handling, and transactional verification. Update\nit alongside changes to storage or reader selection. It uses direct SQLite access;\nit is separate from the authoritative monthly `reminders.rebuild` operation.\n\n## Storage\n\nUnlike Moon/Lunar, which store a JSON `payload` column and derive display\ntext in code, `flea_medication_reminders` stores `main_text` and `sub_text`\nas real columns — every row's reminder text is identical, so there is\nnothing a payload blob would buy here:\n\n```sql\nCREATE TABLE flea_medication_reminders(\n date_key TEXT PRIMARY KEY,\n main_text TEXT NOT NULL,\n sub_text TEXT NOT NULL,\n starts_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL,\n fetched_at TEXT NOT NULL\n)\n```\n\nThe existing database received an additive nullable `expires_at INTEGER` column;\nall existing rows were backfilled with `starts_at + 3600`. New databases use the\nNOT NULL schema above. Every write must supply expiry; missing/invalid windows\nare rejected by the SDK on read. Reads never migrate storage.\n\n## Files\n\n| File | Role |\n| --- | --- |\n| `lib/schedule.ts` | Pure arithmetic: monthly date generation, noon-in-zone-to-UTC conversion. No storage, clock or network. |\n| `gtbSource.ts` | Source definition, offset policy, item text, `flea_medication_reminders` storage and `rebuildSchedule`. |\n| `rpc.ts` | HTTP entry: bearer authentication around `serveSource`. |\n| `check.ts` | Contract, schedule, DST, offset, protocol, auth and storage checks. Disposable rows are removed. |\n\n## Settings and items\n\nSettings are exactly `{}` — there is nothing to select, and the parent's\nbrowser form renders no controls. One item is returned: the next reminder\non or after the reader's current civil date.\n\n```json\n{\n \"id\": \"gtb-2026-10-08\",\n \"mainText\": \"Give Flea medication\",\n \"subText\": \"Gemma, Bron, Tilka 🐈🐈‍⬛🐈\",\n \"caption\": null,\n \"emphasized\": false,\n \"startsAt\": 1791486000,\n \"expiresAt\": 1791489600\n}\n```\n\n(noon Pacific on 2026-10-08, stored as 19:00 UTC — PDT is in effect that date)\n\n`startsAt` (stored in `starts_at`) is Unix **seconds** for local noon in `America/Los_Angeles` on the\nreminder date, precomputed and stored in UTC at write time — it does not\ndepend on the reader's timezone. `caption` is `null`, unlike Moon's `PEAK` or\nLunar's `DAY 15`: noon Pacific is the actual reminder instant here, not a\nwhole-day or astronomical event, so the widget renders it as a real clock\ntime in the reader's own zone. `expiresAt` is stored in `expires_at`, exactly one\nhour after the start for rebuilt reminders. It controls lifecycle and refresh timing\nand is never displayed. The source uses SDK snapshot `12-main` and emits no legacy\nwire `timestamp`; the parent owns compatibility for older clients.\n\n`utcOffsetSeconds: null` (used only to pick the reader's \"today\" for\nselecting the next row) falls back to `America/Los_Angeles`, matching\nMoon/Lunar.\n\n## Populating and extending the schedule\n\nThe write operation `reminders.rebuild` replaces the next `count` monthly\nreminders authoritatively, starting after `after` (`YYYY-MM-DD`):\n\n```json\n{ \"protocolVersion\": 1, \"sourceKey\": \"gtb\", \"operation\": \"reminders.rebuild\",\n \"payload\": { \"count\": 12, \"after\": \"2026-09-09\" } }\n```\n\nThe initial 12 months (2026-10-08 through 2027-09-08) were seeded this way at\ndeployment. There is no automatic reseed job — unlike Lunar's annual interval,\nthis schedule is a fixed formula with nothing upstream to poll for, but it\nstill needs a fresh `reminders.rebuild` call with a later `after` date before\nthe stored window is exhausted. Add an interval later if ongoing unattended\nextension is wanted; it was left out here as unbuilt scope, not an oversight.\n\n## Deployment\n\n1. Set `SOURCE_GTB_V1_TOKEN` on this val.\n2. Register in `plusjade/app-clarkview`: `rpc.ts`'s endpoint, source key `gtb`,\n protocol version 1, and a credential reference holding the same bearer\n value configured independently in the parent. Then assign it to a device.\n3. Run `check.ts` after any change. With the token set it also covers the\n authenticated mount; without it, everything but that one assertion still\n runs.\n4. Run `http-check.ts` after merging to verify the deployed authenticated descriptor\n and nonempty window feed at null and extreme timezone offsets.\n",[],[228],"2f340d32-cc7d-474d-ad8f-841b3873592e","AGENTS.md","b4d1938e-aec9-11f1-9274-1607ee4eb77e",10,["D",1789231677034],"# add-entry: source-gtb\n\nThis is the complete operational contract for inserting one GTB event. Read only\nthis file for an add-entry request; no parent, SDK, README, or repository brief is\nneeded. Keep this file synchronized when GTB's schema or selection changes.\n\n## Scope and input\n\nTarget: `plusjade/source-gtb`, val-scoped SQLite, table\n`flea_medication_reminders`. Use Val Town MCP SQLite directly. This operation is\nauthorized by an explicit add-entry request. Never call `reminders.rebuild`,\nedit code/schema, create branches, fetch credentials, send notifications, or\ninspect the parent as part of this path.\n\nPreferred prompt (JSON after the source name):\n\n```text\nadd-entry: source-gtb {\"starts_at\":\"2026-09-12T17:00:00-07:00\",\"duration_seconds\":3600,\"main_text\":\"Facetime with Bron\",\"sub_text\":\"healthcheck\"}\n```\n\nRequired: offset-qualified ISO start, integer duration 1..86400 seconds, nonblank\nmain_text. sub_text defaults to \"\"; preserve supplied text exactly. Reject unknown\nfields rather than silently ignoring them. Duration is elapsed seconds, including\nacross DST. The one-day maximum is an intentional limit of this shortcut.\n\nNatural-language equivalents are accepted when unambiguous: \"today at 5pm,\nexpires 1 hour\" means a one-hour duration, in America/Los_Angeles unless the user\nspecifies a different timezone. Capture the current clock once for relative dates;\ndo not use a stale conversation date. Resolve calendar dates using an IANA timezone\nwith a timezone-aware runtime, not mental UTC arithmetic. Ask once if required\ninformation is missing or a local time is nonexistent/ambiguous at a DST transition.\n\"Today\" stays today even if the requested time has passed; do not roll to tomorrow.\nRestate the resolved date/time and offset in the result.\n\n## Normalize before any write\n\nUse a local runtime (Python standard library datetime/zoneinfo is sufficient).\nConvert the supplied start to an aware datetime; require an explicit offset in\ncanonical input, whole seconds, and year 2000..2100. Validate by parsing and\nround-tripping the supplied calendar date/time (reject invalid dates). Require\nduration_seconds to be an integer, not a boolean, and main_text/sub_text to be\nstrings. Check nonblank main_text without trimming the stored text.\n\nCompute deterministically:\n\n- starts_at = integer Unix seconds from that datetime.\n- expires_at = starts_at + duration_seconds, also integer Unix seconds.\n- date_key = start converted to America/Los_Angeles, formatted YYYY-MM-DD.\n This source-owned date rule applies even when the input uses another timezone.\n- fetched_at = current UTC ISO timestamp captured for this operation.\n\nThe start and expiry must be finite, with expiry strictly greater than start.\nDo not compute timestamps in the language model or send milliseconds. Do not\ninterpolate user text into SQL, shell commands, or executable code: pass it as data.\n\n## One transactional write and read-back\n\nDiscover only `val_town_sqlite_batch` if it is not already callable. Call it with:\n\n```json\n{\"database\":{\"type\":\"val\",\"val\":\"plusjade/source-gtb\"},\"mode\":\"write\",\"statements\":[\n {\"sql\":\"\",\"args\":\"\"},\n {\"sql\":\"\",\"args\":\"\"}\n]}\n```\n\nThe placeholders above describe tool arguments, not literal strings to submit.\nUse named args objects containing exactly the parameters each statement references.\nRun these two statements in order in the same transaction:\n\n```sql\nINSERT INTO flea_medication_reminders\n (date_key, main_text, sub_text, starts_at, expires_at, fetched_at)\nVALUES (:date_key, :main_text, :sub_text, :starts_at, :expires_at, :fetched_at)\nON CONFLICT(date_key) DO NOTHING;\n```\n\n```sql\nSELECT date_key, main_text, sub_text, starts_at, expires_at,\n CASE WHEN main_text = :main_text AND sub_text = :sub_text\n AND starts_at = :starts_at AND expires_at = :expires_at\n AND typeof(starts_at) = 'integer' AND typeof(expires_at) = 'integer'\n AND expires_at > starts_at AND expires_at - starts_at <= 86400\n THEN 1 ELSE 0 END AS matches_request\nFROM flea_medication_reminders WHERE date_key = :date_key;\n```\n\nSuccess requires a successful transaction, exactly one verification row, and\n`matches_request = 1`. Insert rowsAffected=1 means added; 0 with matching read-back\nmeans already present (safe retry). fetched_at is not part of duplicate identity.\n\nA different event on the same date produces rowsAffected=0 and matches_request=0:\nreport the date conflict, make no further writes, and ask whether the user wants\nto replace that entry as a separate request. Never silently upsert or manufacture\na different date_key. SQL errors roll back the batch; a missing table/column is\nschema drift, not permission to migrate. Report the error and stop the shortcut.\nIf the tool outcome is uncertain, repeat the exact normalized request; do not\nreinterpret relative time or change dates. The unique key prevents duplicates.\n\nAfter success, finish immediately: \"Added [text] to source-gtb: [resolved start]\nfor [duration]. Stored row verified.\" Say \"Already present\" for an exact retry.\nNo production smoke-test fixtures, broad checks, logs in repository docs, or\nadditional MCP reads are needed.\n\n## Dependencies and limits\n\n- Requires Val Town edit/SQLite access and a runtime with timezone data.\n- date_key is the primary key: one event per Pacific date. Multiple events on a\n date need a separate schema/reader change, outside this shortcut.\n- Storage columns are date_key, main_text, sub_text, starts_at, expires_at,\n fetched_at. The existing expires_at column is nullable; this path always writes\n an integer. Wire fields are startsAt/expiresAt; row ID becomes gtb-.\n- GTB returns one row: first date_key on/after the reader's current civil date.\n It does not filter on expiry. An earlier date can hide this entry; clients in\n other timezones can cross the date boundary sooner or later.\n- reminders.rebuild can overwrite custom entries on the 8th. If inserting on\n the 8th, include that concrete limitation in the result.\n- Completion proves exact persisted content, not assignment, device refresh,\n widget visibility, or notification delivery. No parent context is required.\n- This bypasses the source write API; these checks are the ingest boundary.\n Schema/reader maintainers must update this file in the same change.\n",[],[235],"a4dce68c-9802-4f80-a2b3-48f0febc997f","schedule.ts","a2f8eb7c-ac1b-11f1-bbe6-1607ee4eb77e","94313899-2b4a-48d2-8d44-57fc3efb0203",["D",1788937012306],"// Pure monthly-reminder date arithmetic: no storage, no clock side effects\n// beyond the `now`/`afterDateKey` callers pass in explicitly.\n\n/** Civil YYYY-MM-DD for `day` in `year`-`month` (1-indexed), clamped to the month's real last day. */\nfunction civilDateForMonth(year: number, month: number, day: number): string {\n const lastDay = new Date(Date.UTC(year, month, 0)).getUTCDate();\n const clamped = Math.min(day, lastDay);\n return `${year}-${String(month).padStart(2, \"0\")}-${String(clamped).padStart(2, \"0\")}`;\n}\n\n/**\n * The next `count` civil dates falling on `day` of consecutive months,\n * starting from the first such date strictly after `afterDateKey`.\n */\nexport function monthlyDatesAfter(day: number, count: number, afterDateKey: string): string[] {\n const [afterYear, afterMonth] = afterDateKey.split(\"-\").map(Number);\n let year = afterYear;\n let month = afterMonth;\n if (civilDateForMonth(year, month, day) <= afterDateKey) {\n month += 1;\n if (month > 12) { month = 1; year += 1; }\n }\n const out: string[] = [];\n for (let i = 0; i < count; i++) {\n out.push(civilDateForMonth(year, month, day));\n month += 1;\n if (month > 12) { month = 1; year += 1; }\n }\n return out;\n}\n\n/** The IANA zone's UTC offset in seconds, east-positive, at `instantMs`. */\nfunction offsetSecondsAt(instantMs: number, timeZone: string): number {\n const name = new Intl.DateTimeFormat(\"en-US\", { timeZone, timeZoneName: \"longOffset\" })\n .formatToParts(new Date(instantMs))\n .find((p) => p.type === \"timeZoneName\")?.value ?? \"GMT+00:00\";\n const [, sign, hh, mm] = /GMT([+-])(\\d{2}):(\\d{2})/.exec(name) ?? [, \"+\", \"00\", \"00\"];\n return (sign === \"-\" ? -1 : 1) * (Number(hh) * 3600 + Number(mm) * 60);\n}\n\n/**\n * Unix seconds of local noon on civil date `dateKey` in `timeZone`, correct\n * across a DST transition. Noon UTC on `dateKey` always falls in the same\n * `timeZone` civil day as local noon (the gap between them is at most a few\n * hours, far short of a day), so resolving the offset there and correcting\n * once is exact — no fixed-point iteration needed.\n */\nexport function noonInZoneUtcSeconds(dateKey: string, timeZone: string): number {\n const noonUtcGuessMs = Date.parse(dateKey + \"T12:00:00Z\");\n const offsetSeconds = offsetSecondsAt(noonUtcGuessMs, timeZone);\n return noonUtcGuessMs / 1000 - offsetSeconds;\n}\n",[],[250,243],"lib","6a900a50-a3d1-4d66-8daa-8a1b52b3238c",["D",1788937012306],"directory",[195],[250],["D",1788937002070],["D",1789458074143],{"_11":12,"_151":72},{"_11":12,"_147":-5,"_71":72,"_30":70,"_148":149,"_150":24},{"_40":138,"_13":16,"_34":37,"_139":101,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"ctx",{"_55":-5,"_171":294,"_295":296,"_297":298,"_299":24,"_300":24,"_301":24,"_302":169,"_303":-5,"_304":-7,"_305":-7,"_306":26,"_307":24,"_308":24,"_309":-5,"_310":24,"_311":24,"_312":24,"_313":-5},"ENV",{"_265":266,"_267":268,"_269":16,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · gtbSource.ts