[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_113":95,"_33":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":64,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_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":31},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","e9409bdd-d04c-4461-8bf9-a87f11e409ce","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","66196a30-5796-11f1-b03b-ee650bb23af1","name","fileType","http","content","import { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ─── Step 1: Data Structure ───────────────────────────────────────\n// Each request is stored as a row with: id (auto-increment), text (content), timestamp (ISO string).\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )\n`);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // View source redirect\n if (url.pathname === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n // ─── Step 2: Save Logic (with validation) ─────────────────────\n if (req.method === \"POST\" && url.pathname === \"/api/requests\") {\n let body: { text?: string };\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n\n const text = body.text?.trim();\n\n // Validate: reject empty or whitespace-only submissions\n if (!text) {\n return Response.json({ error: \"Request text is required\" }, { status: 400 });\n }\n if (text.length > 1000) {\n return Response.json({ error: \"Request text must be under 1000 characters\" }, { status: 400 });\n }\n\n const timestamp = new Date().toISOString();\n\n // Persist to SQLite\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (text, timestamp) VALUES (?, ?)\",\n args: [text, timestamp],\n });\n\n const entry = { id: Number(result.lastInsertRowid), text, timestamp };\n return Response.json({ ok: true, entry });\n }\n\n // ─── Step 3: Retrieve Saved Requests ──────────────────────────\n if (req.method === \"GET\" && url.pathname === \"/api/requests\") {\n const result = await sqlite.execute(\n \"SELECT id, text, timestamp FROM assistance_requests ORDER BY id DESC LIMIT 100\",\n );\n return Response.json(result.rows);\n }\n\n // Serve the HTML page\n return new Response(html(), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction html() {\n return `\n\n\n \n \n Assistance Requests\n \n \n\n\n\n

🛎️ Assistance Requests

Submit your request and it will appear below.

\n\n \n

\n\n \n\n`;\n}\n","import { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ─── Database Setup ──────────────────────────────────────────────\nawait sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n]);\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // View source redirect\n if (url.pathname === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n // ─── Assistance Requests API ────────────────────────────────────\n if (req.method === \"POST\" && url.pathname === \"/api/requests\") {\n let body: { text?: string };\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n const text = body.text?.trim();\n if (!text) return Response.json({ error: \"Request text is required\" }, { status: 400 });\n if (text.length > 1000) return Response.json({ error: \"Max 1000 characters\" }, { status: 400 });\n\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (text, timestamp) VALUES (?, ?)\",\n args: [text, timestamp],\n });\n return Response.json({ ok: true, entry: { id: Number(result.lastInsertRowid), text, timestamp } });\n }\n\n if (req.method === \"GET\" && url.pathname === \"/api/requests\") {\n const result = await sqlite.execute(\n \"SELECT id, text, timestamp FROM assistance_requests ORDER BY id DESC LIMIT 100\",\n );\n return Response.json(result.rows);\n }\n\n // ─── Chat API ───────────────────────────────────────────────────\n\n // Send a chat message\n if (req.method === \"POST\" && url.pathname === \"/api/chat\") {\n let body: { username?: string; message?: string };\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n const username = body.username?.trim();\n const message = body.message?.trim();\n if (!username) return Response.json({ error: \"Username is required\" }, { status: 400 });\n if (!message) return Response.json({ error: \"Message cannot be empty\" }, { status: 400 });\n if (username.length > 30) return Response.json({ error: \"Username max 30 chars\" }, { status: 400 });\n if (message.length > 500) return Response.json({ error: \"Message max 500 chars\" }, { status: 400 });\n\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, message, timestamp) VALUES (?, ?, ?)\",\n args: [username, message, timestamp],\n });\n return Response.json({\n ok: true,\n msg: { id: Number(result.lastInsertRowid), username, message, timestamp },\n });\n }\n\n // Get chat messages (with optional ?after=id for polling new messages)\n if (req.method === \"GET\" && url.pathname === \"/api/chat\") {\n const afterId = parseInt(url.searchParams.get(\"after\") || \"0\", 10);\n const result = await sqlite.execute({\n sql: \"SELECT id, username, message, timestamp FROM chat_messages WHERE id > ? ORDER BY id ASC LIMIT 200\",\n args: [afterId],\n });\n return Response.json(result.rows);\n }\n\n // SSE endpoint for real-time updates\n if (req.method === \"GET\" && url.pathname === \"/api/chat/stream\") {\n const afterId = parseInt(url.searchParams.get(\"after\") || \"0\", 10);\n let lastId = afterId;\n let closed = false;\n\n const stream = new ReadableStream({\n async start(controller) {\n const encoder = new TextEncoder();\n const send = (data: string) => {\n try {\n controller.enqueue(encoder.encode(`data: ${data}\\n\\n`));\n } catch {\n closed = true;\n }\n };\n\n // Poll the DB and push new messages via SSE\n // Run for up to 55 seconds then let the client reconnect\n const deadline = Date.now() + 55_000;\n while (!closed && Date.now() < deadline) {\n try {\n const result = await sqlite.execute({\n sql: \"SELECT id, username, message, timestamp FROM chat_messages WHERE id > ? ORDER BY id ASC LIMIT 50\",\n args: [lastId],\n });\n if (result.rows.length > 0) {\n for (const row of result.rows) {\n send(JSON.stringify(row));\n lastId = row.id as number;\n }\n }\n } catch {\n // DB error — just skip this cycle\n }\n // Wait 1.5s before next poll\n await new Promise((r) => setTimeout(r, 1500));\n }\n try {\n controller.close();\n } catch { /* already closed */ }\n },\n cancel() {\n closed = true;\n },\n });\n\n return new Response(stream, {\n headers: {\n \"Content-Type\": \"text/event-stream\",\n \"Cache-Control\": \"no-cache\",\n Connection: \"keep-alive\",\n },\n });\n }\n\n // ─── Serve HTML ─────────────────────────────────────────────────\n return new Response(html(), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction html() {\n return `\n\n\n \n \n Holberton — Requests & Chat\n \n \n\n\n

\n\n \n

\n \n \n

\n\n \n

🛎️ Assistance Requests

Submit your request and it will appear below.

\n\n \n

No requests yet. Submit one above!

\n\n \n

💬 Join the Chat

Pick a username to start chatting.

\n \n

\n\n \n

💬 Chat Room

\n \n

\n\n \n

\n\n \n \n

\n\n

\n view source\n

\n\n\n\n`;\n}\n","createdAt",["D",1779644539152],"branchVersion","branchId","6612c86a-5796-11f1-b03b-ee650bb23af1","id","6611ebf2-5796-11f1-b03b-ee650bb23af1","holberton",["D",1779643889434],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Simple HTML interface for submitting assistance requests","imageUrl","169fb5c3-4300-4c8b-b3e8-7b51fd3ad297","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e5b04-561e-72ad-b156-b3e2d313ea99","tursoName","6611ebf2579611f1b03bee650bb23af1","tursoHostname","6611ebf2579611f1b03bee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501263826],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":108},"org",{"_105":104,"_106":104,"_107":108,"_19":61,"_109":110,"_111":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",11,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","aykhantagizade070","handle","displayName","avatar","https://avatars.githubusercontent.com/u/234580827?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":159,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":160,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":161,"_89":162,"_91":163,"_93":31},"tree",[154],"files",[154],"counts",{"_143":68,"_144":145,"_146":68,"_147":148,"_149":150},"contents",[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":136,"_38":34,"_36":37,"_137":-5,"_47":48,"_46":14,"_138":31,"_44":139,"_13":140,"_39":40,"_41":43,"_30":31,"_141":-5,"_33":142},"e958304c-5797-11f1-9286-ee650bb23af1","parentId","latest",["D",1779644539152],4,"label",[34],"pulls","branches",1,"forks","envVars",{"_151":68,"_153":68},"connections",{"_151":68,"_152":68},"count","unfilledCount","emptyCount",{"_49":136,"_38":34,"_36":37,"_137":-5,"_47":48,"_46":14,"_138":31,"_44":155,"_13":140,"_39":40,"_41":43,"_30":31,"_141":-5,"_156":157,"_33":158},["D",1779644539152],"children",[],[34],["D",1779643889434],["D",1789501263826],{"_105":104,"_112":108},{"_105":104,"_106":104,"_107":108,"_19":61,"_109":110,"_111":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"ctx",{"_87":-5,"_132":197,"_198":199,"_200":201,"_202":31,"_203":31,"_204":31,"_205":64,"_206":-5,"_207":-7,"_208":-7,"_209":68,"_210":31,"_211":31,"_212":-5,"_213":31,"_214":31,"_215":31,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":95,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"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 · v5