{APP_NAME}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_263":264,"_265":266},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_108":89,"_26":52,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":24,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/db.ts","latestPath","fileId","eca1787c-6128-11f1-af04-1607ee4eb77e","name","db.ts","fileType","script","content","// db.ts — Val-scoped SQLite: settings, request log, webhook log.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ------------------------------------------------------------------------------\n// types\n// ------------------------------------------------------------------------------\nexport interface RequestLogEntry {\n id: number;\n body: string;\n response: string;\n ts: string;\n}\n\nexport interface WebhookLogEntry {\n id: number;\n method: string;\n headers: string;\n body: string;\n ts: string;\n}\n\n// ------------------------------------------------------------------------------\n// schema migration\n// ------------------------------------------------------------------------------\nlet migrated = false;\n\n/** Lazily create tables on first DB call. No-op while module is warm. */\nasync function migrate(): Promise {\n if (migrated) return;\n migrated = true;\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS request_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n body TEXT NOT NULL,\n response TEXT NOT NULL,\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS webhook_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n method TEXT NOT NULL,\n headers TEXT NOT NULL DEFAULT '{}',\n body TEXT NOT NULL DEFAULT '',\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n ]);\n}\n\n// ------------------------------------------------------------------------------\n// settings CRUD\n// ------------------------------------------------------------------------------\n\n/** Read all settings as a flat key-value map. */\nexport async function getAllSettings(): Promise> {\n await migrate();\n const { rows } = await sqlite.execute(`SELECT key, value FROM settings`);\n const result: Record = {};\n for (const r of rows) result[String(r[0])] = String(r[1]);\n return result;\n}\n\n/** Upsert multiple settings in a single transaction. */\nexport async function saveSettings(entries: Record): Promise {\n await migrate();\n const queries = Object.entries(entries).map(([key, value]) => ({\n sql: `INSERT INTO settings (key, value) VALUES (?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n }));\n await sqlite.batch(queries);\n}\n\n// ------------------------------------------------------------------------------\n// request log\n// ------------------------------------------------------------------------------\n\n/** Log a request body + response to SQLite. */\nexport async function logRequest(body: string, response: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO request_log (body, response) VALUES (?, ?)`,\n args: [body, response],\n });\n}\n\n/** Get the N most recent request log entries (newest first), with offset. */\nexport async function getRecentRequests(limit = 10, offset = 0): Promise {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, body, response, ts FROM request_log ORDER BY id DESC LIMIT ? OFFSET ?`,\n args: [limit, offset],\n });\n return rows.map((r) => ({\n id: Number(r[0]),\n body: String(r[1]),\n response: String(r[2]),\n ts: String(r[3]),\n }));\n}\n\n/** Total number of logged requests. */\nexport async function getRequestCount(): Promise {\n await migrate();\n const { rows } = await sqlite.execute(`SELECT COUNT(*) FROM request_log`);\n return Number(rows[0][0]);\n}\n\n// ------------------------------------------------------------------------------\n// webhook log\n// ------------------------------------------------------------------------------\n\n/** Store an incoming webhook payload. */\nexport async function logWebhook(method: string, headers: string, body: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO webhook_log (method, headers, body) VALUES (?, ?, ?)`,\n args: [method, headers, body],\n });\n}\n\n/** Get the N most recent webhook entries (newest first), with offset. */\nexport async function getRecentWebhooks(limit = 10, offset = 0): Promise {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, method, headers, body, ts FROM webhook_log ORDER BY id DESC LIMIT ? OFFSET ?`,\n args: [limit, offset],\n });\n return rows.map((r) => ({\n id: Number(r[0]),\n method: String(r[1]),\n headers: String(r[2]),\n body: String(r[3]),\n ts: String(r[4]),\n }));\n}\n\n/** Total number of logged webhooks. */\nexport async function getWebhookCount(): Promise {\n await migrate();\n const { rows } = await sqlite.execute(`SELECT COUNT(*) FROM webhook_log`);\n return Number(rows[0][0]);\n}\n\n// ------------------------------------------------------------------------------\n// cleanup\n// ------------------------------------------------------------------------------\n\n/** Delete request_log and webhook_log entries older than N days. */\nexport async function deleteOldData(days = 3): Promise<{ requests: number; webhooks: number }> {\n await migrate();\n const interval = `-${Math.floor(Math.abs(days))} days`;\n const r1 = await sqlite.execute({\n sql: `DELETE FROM request_log WHERE ts < datetime('now', ?)`,\n args: [interval],\n });\n const r2 = await sqlite.execute({\n sql: `DELETE FROM webhook_log WHERE ts < datetime('now', ?)`,\n args: [interval],\n });\n return { requests: r1.rowsAffected, webhooks: r2.rowsAffected };\n}\n","createdAt",["D",1780696382156],"branchVersion","branchId","5ce0246c-39c2-47d2-86b7-4133abafc79e","id","fd3404f9-cc43-40a4-9f5e-11cc4fb7f36a","uFns",["D",1780696380052],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","279c3e70-f2b8-11ef-a073-37253b8bcbda","pinnedFileId","ecb9a046-6128-11f1-a23b-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e994f-fcc4-73e9-86ed-2d14fe9f5dfa","tursoName","fd3404f9cc4340a49f5e11cc4fb7f36a","tursoHostname","fd3404f9cc4340a49f5e11cc4fb7f36a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789506093912],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":-5,"_104":105,"_106":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",112,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ttai","handle","displayName","Tough Tongue AI","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/4b8edab4-7879-48e2-f777-109aa5256800/square512?exp=1789541999&sig=7848d48fd3a69c275bb09496e617fd0ad9cca42ef23d4de6c0950cc9b05d86ff","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":258,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":259,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":260,"_83":261,"_85":262,"_87":24},"tree",[173,177,183,184],"files",[173,174,175,176,177,178,179,180,181,182,183,184],"counts",{"_163":62,"_164":153,"_165":62,"_166":167,"_168":169},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":58,"_37":161,"_13":62,"_33":155,"_35":-5,"_23":24,"_141":-5,"_26":162},{"_42":150,"_31":151,"_29":152,"_136":-5,"_40":41,"_39":153,"_138":58,"_37":154,"_13":62,"_33":155,"_35":-5,"_23":24,"_141":-5,"_26":156},{"_42":143,"_31":144,"_29":145,"_136":-5,"_40":41,"_39":146,"_138":58,"_37":147,"_13":62,"_33":20,"_35":148,"_23":24,"_141":-5,"_26":149},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":139,"_13":62,"_33":20,"_35":140,"_23":24,"_141":-5,"_26":142},"7a09dc87-67b9-4566-ab76-9979ee43f117","val.yml","ec9d2eac-6128-11f1-a087-1607ee4eb77e","parentId",11,"latest",["D",1780696382144],"# val.yml — metadata contract for this val. Not consumed by `vt` today; reserved\n# for a future repo wrapper over vt-cli (safer deploys, env checks, file typing).\nname: \"uFns\"\norg: \"uapps\"\npublic: true\n# Small integration functions + a beer.css dashboard. No auth — dev/staging only.\nfiles:\n index.http.ts: http\n cron.ts: interval\n","label",[134],"e70eafe0-39e0-45c4-8d7e-4abf2fd344df","deno.json","ec82e4ac-6128-11f1-9fb3-1607ee4eb77e",8,["D",1780696381966],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\"dom\", \"dom.iterable\", \"dom.asynciterable\", \"deno.ns\", \"deno.unstable\"]\n },\n \"fmt\": {\n \"lineWidth\": 100\n },\n \"lint\": {\n \"rules\": {\n \"exclude\": [\"no-explicit-any\", \"no-external-import\", \"no-import-prefix\"]\n }\n },\n \"node_modules_dir\": false,\n \"unstable\": [\"temporal\", \"worker-options\", \"sloppy-imports\", \"node-globals\"]\n}\n",[144],"f3312fd8-02a6-496a-986f-44d7e39f2f13","frontend","ec17eeae-6128-11f1-87d6-1607ee4eb77e",1,["D",1780696381266],"directory",[151],"3362f264-0383-4acf-b57d-e1b15ccedfca","backend","ec3e8050-6128-11f1-9fb3-1607ee4eb77e",2,["D",1780696381494],[158],"pulls","branches","forks","envVars",{"_170":62,"_172":62},"connections",{"_170":62,"_171":62},"count","unfilledCount","emptyCount",{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":58,"_37":255,"_13":62,"_33":155,"_35":-5,"_23":24,"_141":-5,"_186":256,"_26":257},{"_42":251,"_31":32,"_29":30,"_136":159,"_40":41,"_39":14,"_138":24,"_37":252,"_13":62,"_33":34,"_35":36,"_23":24,"_141":-5,"_186":253,"_26":254},{"_42":243,"_31":244,"_29":245,"_136":159,"_40":41,"_39":246,"_138":24,"_37":247,"_13":62,"_33":34,"_35":248,"_23":24,"_141":-5,"_186":249,"_26":250},{"_42":235,"_31":236,"_29":237,"_136":159,"_40":41,"_39":238,"_138":24,"_37":239,"_13":62,"_33":34,"_35":240,"_23":24,"_141":-5,"_186":241,"_26":242},{"_42":150,"_31":151,"_29":152,"_136":-5,"_40":41,"_39":153,"_138":58,"_37":232,"_13":62,"_33":155,"_35":-5,"_23":24,"_141":-5,"_186":233,"_26":234},{"_42":224,"_31":225,"_29":226,"_136":152,"_40":41,"_39":227,"_138":24,"_37":228,"_13":62,"_33":34,"_35":229,"_23":24,"_141":-5,"_186":230,"_26":231},{"_42":216,"_31":217,"_29":218,"_136":152,"_40":41,"_39":219,"_138":24,"_37":220,"_13":62,"_33":34,"_35":221,"_23":24,"_141":-5,"_186":222,"_26":223},{"_42":208,"_31":209,"_29":210,"_136":152,"_40":41,"_39":211,"_138":24,"_37":212,"_13":62,"_33":34,"_35":213,"_23":24,"_141":-5,"_186":214,"_26":215},{"_42":200,"_31":201,"_29":202,"_136":152,"_40":41,"_39":203,"_138":24,"_37":204,"_13":62,"_33":34,"_35":205,"_23":24,"_141":-5,"_186":206,"_26":207},{"_42":192,"_31":193,"_29":194,"_136":152,"_40":41,"_39":195,"_138":58,"_37":196,"_13":62,"_33":34,"_35":197,"_23":24,"_141":-5,"_186":198,"_26":199},{"_42":143,"_31":144,"_29":145,"_136":-5,"_40":41,"_39":146,"_138":58,"_37":189,"_13":62,"_33":20,"_35":148,"_23":24,"_141":-5,"_186":190,"_26":191},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":185,"_13":62,"_33":20,"_35":140,"_23":24,"_141":-5,"_186":187,"_26":188},["D",1780696382144],"children",[],[134],["D",1780696381966],[],[144],"4a4fc7c0-88a2-4fc8-907e-a84d47f5d374","utils.ts","ec609fd2-6128-11f1-ac3a-1607ee4eb77e",3,["D",1780696381742],"// utils.ts — Formatting helpers for SSR pages.\n\nexport function formatJson(raw: string): string {\n try {\n return JSON.stringify(JSON.parse(raw), null, 2);\n } catch {\n return raw;\n }\n}\n\nexport function truncate(s: string, max: number): string {\n const flat = s.replace(/\\s+/g, \" \").trim();\n return flat.length > max ? flat.slice(0, max) + \"…\" : flat;\n}\n\nexport function isoUtc(ts: string): string {\n return ts.replace(\" \", \"T\") + \"Z\";\n}\n\nexport function methodChip(method: string): string {\n if (method === \"GET\") return \"blue\";\n if (method === \"POST\") return \"green\";\n if (method === \"PUT\" || method === \"PATCH\") return \"orange\";\n if (method === \"DELETE\") return \"red\";\n return \"grey\";\n}\n",[],[151,193],"be4e1543-c494-4303-a13c-cf272a81b3e7","types.ts","ec7b6a4c-6128-11f1-b845-1607ee4eb77e",7,["D",1780696381749],"// types.ts — View models passed from backend handlers into SSR pages.\n\nimport type { RequestLogEntry, WebhookLogEntry } from \"../backend/db.ts\";\n\nexport interface UserDetails {\n user_name: string;\n user_email: string;\n dynamic_vars: Record;\n}\n\nexport interface DashboardView {\n requests: RequestLogEntry[];\n webhooks: WebhookLogEntry[];\n reqTotal: number;\n whTotal: number;\n tab: \"requests\" | \"webhooks\";\n page: number;\n totalPages: number;\n}\n\nexport interface SettingsView {\n values: Record;\n saved: boolean;\n}\n",[],[151,201],"5d4ffb13-2785-4c7d-b50b-d827272c01d5","settings.tsx","ec6d2860-6128-11f1-87d6-1607ee4eb77e",5,["D",1780696381824],"/** @jsxImportSource https://esm.sh/preact@10.29.1 */\n// settings.tsx — Mock user configuration (beer.css, aligned with uAgents forms).\n\nimport { render } from \"https://esm.sh/preact-render-to-string@6.6.7?deps=preact@10.29.1\";\nimport { SETTINGS_FIELDS } from \"../backend/config.ts\";\nimport { PageNav, Shell } from \"./layout.tsx\";\nimport type { SettingsView } from \"./types.ts\";\n\n// ------------------------------------------------------------------------------\n// render\n// ------------------------------------------------------------------------------\n\n/** Render the settings page to an HTML string. */\nexport function renderSettings(view: SettingsView): string {\n return \"\" + render();\n}\n\n// ------------------------------------------------------------------------------\n// page\n// ------------------------------------------------------------------------------\n\nfunction SettingsPage({ view }: { view: SettingsView }) {\n return (\n \n \n

Mock user

\n returned by POST /get-user-details\n

\n {view.saved && (\n

\n check_circle Saved.\n

\n )}\n \n

\n \n );\n}\n",[],[151,209],"aa53f85c-dae3-409b-880e-12b222130ce9","layout.tsx","ec667934-6128-11f1-b2c9-1607ee4eb77e",4,["D",1780696381743],"/** @jsxImportSource https://esm.sh/preact@10.29.1 */\n// layout.tsx — Shared beer.css document shell (aligned with uAgents).\n\nimport type { ComponentChildren } from \"https://esm.sh/preact@10.29.1\";\nimport { APP_NAME } from \"../backend/shared.ts\";\n\nconst BEER_CSS = \"https://cdn.jsdelivr.net/npm/beercss@4.0.21/dist/cdn/beer.min.css\";\nconst BEER_JS = \"https://cdn.jsdelivr.net/npm/beercss@4.0.21/dist/cdn/beer.min.js\";\nconst ICONS =\n \"https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@40,400,0,0\";\n\nexport type Page = \"dashboard\" | \"settings\";\n\ninterface ShellProps {\n children: ComponentChildren;\n}\n\n/** Full HTML document with beer.css and a minimal top app bar. */\nexport function Shell({ children }: ShellProps) {\n return (\n \n \n \n \n {APP_NAME}\n \n \n \n \n \n \n \n

{children}

Diff · v12