[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_192":193,"_194":195},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_114":95,"_32":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":30,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",3,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","d13fa0d8-71e3-4f83-a5a9-729db5857ce0","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","lib/db.ts","latestPath","fileId","c53d048c-877e-11f1-bd57-1607ee4eb77e","name","db.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nlet initPromise: Promise | null = null;\n\nexport function init(): Promise {\n if (!initPromise) {\n initPromise = (async () => {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS evaluations (\n evaluation_id TEXT PRIMARY KEY,\n input_digest TEXT NOT NULL,\n status TEXT NOT NULL,\n receipt_verifier TEXT NOT NULL,\n dossier_ids TEXT NOT NULL,\n proposals TEXT NOT NULL,\n propose_response TEXT NOT NULL,\n receipts_digest TEXT,\n commit_response TEXT,\n created_at TEXT NOT NULL,\n completed_at TEXT\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS dossier_cache (\n content_hash TEXT PRIMARY KEY,\n dossier_id TEXT NOT NULL,\n call_id TEXT NOT NULL,\n decision TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`,\n },\n ], { database: undefined as any });\n })();\n }\n return initPromise;\n}\n\n// --- evaluations ---\n\nexport interface StoredEvaluation {\n evaluation_id: string;\n input_digest: string;\n status: \"awaiting_receipts\" | \"completed\";\n receipt_verifier: string; // JSON\n dossier_ids: string; // JSON array\n proposals: string; // JSON map callId -> proposal (incl proposalDigest)\n propose_response: string; // JSON\n receipts_digest: string | null;\n commit_response: string | null;\n created_at: string;\n completed_at: string | null;\n}\n\nexport async function getEvaluation(id: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM evaluations WHERE evaluation_id = ?\",\n args: [id],\n });\n if (res.rows.length === 0) return null;\n return res.rows[0] as unknown as StoredEvaluation;\n}\n\nexport async function insertEvaluation(row: {\n evaluation_id: string;\n input_digest: string;\n receipt_verifier: string;\n dossier_ids: string;\n proposals: string;\n propose_response: string;\n created_at: string;\n}): Promise {\n await sqlite.execute({\n sql: `INSERT INTO evaluations\n (evaluation_id, input_digest, status, receipt_verifier, dossier_ids, proposals, propose_response, created_at)\n VALUES (?, ?, 'awaiting_receipts', ?, ?, ?, ?, ?)`,\n args: [\n row.evaluation_id,\n row.input_digest,\n row.receipt_verifier,\n row.dossier_ids,\n row.proposals,\n row.propose_response,\n row.created_at,\n ],\n });\n}\n\nexport async function completeEvaluation(\n evaluationId: string,\n receiptsDigest: string,\n commitResponse: string,\n completedAt: string,\n): Promise {\n await sqlite.execute({\n sql: `UPDATE evaluations SET status='completed', receipts_digest=?, commit_response=?, completed_at=?\n WHERE evaluation_id = ? AND status = 'awaiting_receipts'`,\n args: [receiptsDigest, commitResponse, completedAt, evaluationId],\n });\n}\n\n// --- dossier decision cache ---\n\nexport interface CachedDecision {\n content_hash: string;\n dossier_id: string;\n call_id: string;\n decision: string; // JSON {action, target, payload, evidence}\n}\n\nexport async function getCachedDecisions(hashes: string[]): Promise> {\n const map = new Map();\n if (hashes.length === 0) return map;\n const placeholders = hashes.map(() => \"?\").join(\",\");\n const res = await sqlite.execute({\n sql: `SELECT * FROM dossier_cache WHERE content_hash IN (${placeholders})`,\n args: hashes,\n });\n for (const row of res.rows as unknown as CachedDecision[]) {\n map.set(row.content_hash, row);\n }\n return map;\n}\n\nexport async function setCachedDecision(\n contentHash: string,\n dossierId: string,\n callId: string,\n decision: string,\n): Promise {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO dossier_cache (content_hash, dossier_id, call_id, decision, created_at)\n VALUES (?, ?, ?, ?, ?)`,\n args: [contentHash, dossierId, callId, decision, new Date().toISOString()],\n });\n}\n","createdAt",["D",1784911396985],"branchVersion","branchId","c310c12a-f495-4659-85f1-f9e6e4e48307","id","4e450ace-2c1f-4c25-b1f8-18957d92633b","mailroom-action-gate",["D",1784911376004],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AI mailroom propose/commit action-gate agent","imageUrl","c1d4b0d1-f48c-4eb6-b2b7-e3324612305d","pinnedFileId","b8bde23a-877e-11f1-a071-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f94ea-46d7-73ac-824d-6af2b6b216bc","tursoName","4e450ace2c1f4c25b1f818957d92633b","tursoHostname","4e450ace2c1f4c25b1f818957d92633b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kumar49","handle","displayName","Vimal Kumar","avatar","https://lh3.googleusercontent.com/a/ACg8ocJlxasCPsMpEdsEc9lPr7vS3ljW01vcCwNRogJLHF29XURUVHSz=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":187,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":188,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":189,"_89":190,"_91":191,"_93":30},"tree",[165,168],"files",[165,166,167,168],"counts",{"_155":68,"_156":141,"_157":68,"_158":159,"_160":161},"contents",[136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_142":64,"_43":152,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":154},{"_48":138,"_37":139,"_35":62,"_140":-5,"_46":47,"_45":141,"_142":30,"_43":143,"_13":68,"_39":144,"_41":145,"_29":30,"_146":-5,"_32":147},"224a6bd3-0a6b-4099-8e41-a250e4fcbebf","main.ts","parentId",1,"latest",["D",1784911376019],"http","export default async function(req: Request): Promise {\n return new Response(\"placeholder\", { status: 200 });\n}","label",[139],"297d426b-3fb7-4fe7-bc21-c2cac6f8c335","lib","fe043c58-28ad-4b67-b864-ca2a94edbe1a",2,["D",1784911383388],"directory",[149],"pulls","branches","forks","envVars",{"_162":141,"_164":141},"connections",{"_162":68,"_163":68},"count","unfilledCount","emptyCount",{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_142":64,"_43":184,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_170":185,"_32":186},{"_48":177,"_37":178,"_35":179,"_140":150,"_46":47,"_45":151,"_142":64,"_43":180,"_13":68,"_39":40,"_41":181,"_29":30,"_146":-5,"_170":182,"_32":183},{"_48":173,"_37":38,"_35":36,"_140":150,"_46":47,"_45":14,"_142":30,"_43":174,"_13":68,"_39":40,"_41":42,"_29":30,"_146":-5,"_170":175,"_32":176},{"_48":138,"_37":139,"_35":62,"_140":-5,"_46":47,"_45":141,"_142":30,"_43":169,"_13":68,"_39":144,"_41":145,"_29":30,"_146":-5,"_170":171,"_32":172},["D",1784911376019],"children",[],[139],"222d65a2-a3de-47e6-a535-bf7bfb06bfd4",["D",1784911396985],[],[149,38],"22dc6e65-32a7-443c-aed8-0e368cab7dc5","canonical.ts","bd24aad4-877e-11f1-8425-1607ee4eb77e",["D",1784911383388],"// Recursively key-sorted, compact JSON canonicalization + SHA-256 hex hashing.\n\nexport function canonicalize(value: unknown): unknown {\n if (Array.isArray(value)) {\n return value.map(canonicalize);\n }\n if (value !== null && typeof value === \"object\") {\n const obj = value as Record;\n const sortedKeys = Object.keys(obj).sort();\n const out: Record = {};\n for (const k of sortedKeys) {\n out[k] = canonicalize(obj[k]);\n }\n return out;\n }\n return value;\n}\n\nexport function canonicalStringify(value: unknown): string {\n return JSON.stringify(canonicalize(value));\n}\n\nexport async function sha256Hex(input: string): Promise {\n const bytes = new TextEncoder().encode(input);\n const digest = await crypto.subtle.digest(\"SHA-256\", bytes);\n return [...new Uint8Array(digest)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport async function canonicalDigest(value: unknown): Promise {\n return sha256Hex(canonicalStringify(value));\n}\n\nexport function base64ToBytes(b64: string): Uint8Array {\n const bin = atob(b64.replace(/-/g, \"+\").replace(/_/g, \"/\"));\n const bytes = new Uint8Array(bin.length);\n for (let i = 0; i < bin.length; i++) bytes[i] = bin.charCodeAt(i);\n return bytes;\n}\n\nexport function base64urlToBytes(b64url: string): Uint8Array {\n let s = b64url.replace(/-/g, \"+\").replace(/_/g, \"/\");\n while (s.length % 4 !== 0) s += \"=\";\n return base64ToBytes(s);\n}\n",[],[149,178],["D",1784911383388],[166,167],[149],["D",1784911376004],["D",1789473046147],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":225,"_226":227,"_228":229,"_230":30,"_231":30,"_232":30,"_233":64,"_234":-5,"_235":-7,"_236":-7,"_237":68,"_238":30,"_239":30,"_240":-5,"_241":30,"_242":30,"_243":30,"_244":-5},"ENV",{"_196":197,"_198":199,"_200":95,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224},"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"]

Diff · v3