[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_203":204,"_205":206},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_63":113,"_16":-7,"_164":-5,"_17":165,"_166":167,"_28":168,"_21":169,"_23":170,"_56":-5,"_171":-5,"_172":-5,"_173":36,"_174":175,"_176":34,"_177":-5,"_178":-5,"_179":180},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":-5,"_31":-5,"_32":-5,"_33":34,"_35":36,"_37":34},"handle","yoonamonmon","name","Holbie","branchName","version","project",{"_41":105,"_13":14,"_52":106,"_107":-5,"_108":36,"_109":110,"_111":110,"_112":113,"_114":-5,"_115":116,"_117":-5,"_118":36,"_119":-5,"_120":-5,"_121":95,"_122":123,"_124":125,"_126":127,"_128":129,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_140":141,"_142":143,"_144":145,"_146":36},"tags",[],"counts",{"_94":95,"_96":80,"_97":95,"_98":99,"_100":101},"contents",[85,86,87],"readme","upstream","pull","files",[38,39,40],"preview","ahead","behind","showHomeCustomizationHint",true,"showHTTPPreviewSettingsHint",false,"hasHTTPFiles",{"_41":75,"_13":76,"_44":77,"_46":-5,"_47":48,"_49":78,"_51":34,"_52":79,"_16":80,"_55":81,"_57":82,"_59":36,"_60":-5,"_61":83,"_63":84},{"_41":65,"_13":66,"_44":67,"_46":-5,"_47":48,"_49":68,"_51":34,"_52":69,"_16":70,"_55":71,"_57":72,"_59":36,"_60":-5,"_61":73,"_63":74},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":34,"_52":53,"_16":54,"_55":56,"_57":58,"_59":36,"_60":-5,"_61":62,"_63":64},"id","5ff82cd2-56c3-11f1-9a96-ee650bb23af1","ui.html","fileId","2b1ee916-56c2-11f1-af3d-ee650bb23af1","parentId","branchId","e40cef74-56c0-11f1-a1d6-ee650bb23af1","branchVersion",11,"latest","createdAt",["D",1779553255368],2,"fileType","file","content","\n\n\n \n \n Holbie – Assistance & Chat\n \n \n\n\n

\n \n

🤖 Holbie

Assistance requests & live support chat.

\n\n \n

\n \n \n

\n\n \n

\n \n

\n\n \n

\n\n \n \n\n \n

\n \n

\n \n Chatting as \n \n \n \n Connecting…\n \n

\n\n \n

Loading history…

\n\n \n

\n View source\n

\n\n \n\n\n","deleted","label","children",[],"path",[43],"db00732c-56c2-11f1-b74d-ee650bb23af1","main.ts","e4103954-56c0-11f1-a1d6-ee650bb23af1",10,["D",1779553032291],5,"http","import {\n getAllRequests,\n getChatHistory,\n insertChatMessage,\n insertRequest,\n} from \"./db.ts\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// BroadcastChannel lets multiple isolates share real-time messages\nconst channel = new BroadcastChannel(\"holbie-chat\");\n\n// Track SSE clients so we can push to them\nconst sseClients = new Set();\n\n// When a message arrives on the BroadcastChannel, push to all SSE clients\nchannel.onmessage = (event: MessageEvent) => {\n const payload = `event: chat\\ndata: ${JSON.stringify(event.data)}\\n\\n`;\n for (const controller of sseClients) {\n try {\n controller.enqueue(new TextEncoder().encode(payload));\n } catch {\n sseClients.delete(controller);\n }\n }\n};\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // --- API: Submit a request ---\n if (req.method === \"POST\" && url.pathname === \"/api/submit\") {\n let body: unknown;\n try {\n body = await req.json();\n } catch {\n return Response.json(\n { error: \"Invalid JSON in request body.\" },\n { status: 400 },\n );\n }\n\n // Validate: message field must be a non-empty string\n const raw = (body as Record)?.message;\n if (typeof raw !== \"string\" || raw.trim().length === 0) {\n return Response.json(\n { error: \"Message cannot be empty. Please enter a valid assistance request.\" },\n { status: 400 },\n );\n }\n\n try {\n const saved = await insertRequest(raw);\n return Response.json({ success: true, request: saved });\n } catch (err: unknown) {\n const msg = err instanceof Error ? err.message : \"Failed to save request.\";\n return Response.json({ error: msg }, { status: 400 });\n }\n }\n\n // --- API: Get all requests ---\n if (req.method === \"GET\" && url.pathname === \"/api/requests\") {\n return Response.json(await getAllRequests());\n }\n\n // --- API: Send a chat message ---\n if (req.method === \"POST\" && url.pathname === \"/api/chat/send\") {\n try {\n const body = await req.json();\n const username = typeof body.username === \"string\"\n ? body.username.trim()\n : \"\";\n const message = typeof body.message === \"string\"\n ? body.message.trim()\n : \"\";\n\n if (!username) {\n return Response.json({ error: \"Username is required.\" }, {\n status: 400,\n });\n }\n if (!message) {\n return Response.json({ error: \"Message cannot be empty.\" }, {\n status: 400,\n });\n }\n\n // Save to SQLite\n const saved = await insertChatMessage(username, message);\n\n // Broadcast to all connected SSE clients via BroadcastChannel\n channel.postMessage(saved);\n\n // Also push directly to local SSE clients (same isolate)\n const payload = `event: chat\\ndata: ${JSON.stringify(saved)}\\n\\n`;\n for (const controller of sseClients) {\n try {\n controller.enqueue(new TextEncoder().encode(payload));\n } catch {\n sseClients.delete(controller);\n }\n }\n\n return Response.json({ success: true });\n } catch {\n return Response.json({ error: \"Invalid request body.\" }, { status: 400 });\n }\n }\n\n // --- API: Get chat history ---\n if (req.method === \"GET\" && url.pathname === \"/api/chat/history\") {\n return Response.json(await getChatHistory());\n }\n\n // --- API: SSE stream for real-time chat ---\n if (req.method === \"GET\" && url.pathname === \"/api/chat/stream\") {\n const body = new ReadableStream({\n start(controller) {\n sseClients.add(controller);\n // Send a keep-alive comment immediately\n controller.enqueue(new TextEncoder().encode(\": connected\\n\\n\"));\n },\n cancel(controller) {\n sseClients.delete(controller);\n },\n });\n\n return new Response(body, {\n headers: {\n \"Content-Type\": \"text/event-stream\",\n \"Cache-Control\": \"no-cache\",\n \"Connection\": \"keep-alive\",\n },\n });\n }\n\n // --- View source ---\n if (url.pathname === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n // --- Serve the HTML UI ---\n return serveFile(\"./ui.html\", import.meta.url);\n}\n",[],[66],"b6f0afc4-56c2-11f1-aeb7-ee650bb23af1","db.ts","227a7848-56c2-11f1-b8a2-ee650bb23af1",7,["D",1779552971790],1,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize tables (idempotent — safe to run on every cold start)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n`);\n\n/**\n * Validate and insert a new assistance request.\n * Returns the saved row (id, message, created_at).\n * Throws if the message is empty or whitespace-only.\n */\nexport async function insertRequest(message: string) {\n const trimmed = message?.trim() ?? \"\";\n if (trimmed.length === 0) {\n throw new Error(\"Message cannot be empty. Please enter a valid assistance request.\");\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO requests (message) VALUES (?) RETURNING id, message, created_at\",\n args: [trimmed],\n });\n return result.rows[0];\n}\n\n/** Return every request, newest first. */\nexport async function getAllRequests() {\n const result = await sqlite.execute(\n \"SELECT id, message, created_at FROM requests ORDER BY created_at DESC\",\n );\n return result.rows;\n}\n\nexport async function insertChatMessage(username: string, message: string) {\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, message) VALUES (?, ?) RETURNING *\",\n args: [username, message],\n });\n return result.rows[0];\n}\n\nexport async function getChatHistory(limit = 50) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM chat_messages ORDER BY created_at DESC LIMIT ?\",\n args: [limit],\n });\n return result.rows.reverse();\n}\n",[],[76],{"_41":75,"_13":76,"_44":77,"_46":-5,"_47":48,"_49":78,"_51":34,"_52":92,"_16":80,"_55":81,"_57":82,"_59":36,"_60":-5,"_63":93},{"_41":65,"_13":66,"_44":67,"_46":-5,"_47":48,"_49":68,"_51":34,"_52":90,"_16":70,"_55":71,"_57":72,"_59":36,"_60":-5,"_63":91},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":34,"_52":88,"_16":54,"_55":56,"_57":58,"_59":36,"_60":-5,"_63":89},["D",1779553255368],[43],["D",1779553032291],[66],["D",1779552971790],[76],"pulls",0,"branches","forks","envVars",{"_102":95,"_104":95},"connections",{"_102":95,"_103":95},"count","unfilledCount","emptyCount","e40c1612-56c0-11f1-a1d6-ee650bb23af1",["D",1779552188489],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","da983280-a000-4811-b921-9e1c222ef989","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e5592-f741-75ae-9b49-08eb14108ed9","tursoName","e40c161256c011f1a1d6ee650bb23af1","tursoHostname","e40c161256c011f1a1d6ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_163":159},"org",{"_11":12,"_156":157,"_158":159,"_115":116,"_160":161,"_162":36},"branch",{"_16":50,"_13":147,"_41":48,"_148":105,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Yoona MonMon","avatar","https://lh3.googleusercontent.com/a/ACg8ocKGBCpdRrUCfON339Wfkdpy4bV5uqGMr63T0d-QjkqqCdTYZA=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_41":105,"_13":14,"_52":198,"_107":-5,"_108":36,"_109":110,"_111":110,"_112":113,"_114":-5,"_115":116,"_117":-5,"_118":36,"_119":-5,"_120":-5,"_121":95,"_122":123,"_124":125,"_126":127,"_128":199,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_140":200,"_142":201,"_144":202,"_146":36},"tree",[189,190,191],[189,190,191],{"_94":95,"_96":80,"_97":95,"_98":187,"_100":188},[181,182,183],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":75,"_13":76,"_44":77,"_46":-5,"_47":48,"_49":78,"_51":34,"_52":92,"_16":80,"_55":81,"_57":82,"_59":36,"_60":-5,"_63":186},{"_41":65,"_13":66,"_44":67,"_46":-5,"_47":48,"_49":68,"_51":34,"_52":90,"_16":70,"_55":71,"_57":72,"_59":36,"_60":-5,"_63":185},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":34,"_52":88,"_16":54,"_55":56,"_57":58,"_59":36,"_60":-5,"_63":184},[43],[66],[76],{"_102":95,"_104":95},{"_102":95,"_103":95},{"_41":75,"_13":76,"_44":77,"_46":-5,"_47":48,"_49":78,"_51":34,"_52":79,"_16":80,"_55":81,"_57":82,"_59":36,"_60":-5,"_61":196,"_63":197},{"_41":65,"_13":66,"_44":67,"_46":-5,"_47":48,"_49":68,"_51":34,"_52":69,"_16":70,"_55":71,"_57":72,"_59":36,"_60":-5,"_61":194,"_63":195},{"_41":42,"_13":43,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":34,"_52":53,"_16":54,"_55":56,"_57":58,"_59":36,"_60":-5,"_61":192,"_63":193},[],[43],[],[66],[],[76],["D",1779552188489],["D",1789498239291],{"_11":12,"_163":159},{"_11":12,"_156":157,"_158":159,"_115":116,"_160":161,"_162":36},{"_16":50,"_13":147,"_41":48,"_148":105,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"ctx",{"_140":-5,"_178":236,"_237":238,"_239":240,"_241":36,"_242":36,"_243":36,"_244":34,"_245":-5,"_246":-7,"_247":-7,"_248":95,"_249":36,"_250":36,"_251":-5,"_252":36,"_253":36,"_254":36,"_255":-5},"ENV",{"_207":208,"_209":210,"_211":147,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235},"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"]

🤖 Holbie

Recent Requests