\n \n \n \n\n","019e3a45-4d09-7019-8fa6-378d91730976",["D",1779094145062],"branchVersion","label",[181,68],"frontend","pulls","branches","forks","envVars",{"_189":26,"_191":26},"connections",{"_189":26,"_190":26},"count","unfilledCount","emptyCount",{"_33":277,"_13":181,"_66":176,"_43":-5,"_35":36,"_178":40,"_206":96,"_37":278,"_39":26,"_69":274,"_174":-5,"_70":24,"_179":-5,"_211":279,"_17":280},{"_33":272,"_13":248,"_66":242,"_43":176,"_35":36,"_178":40,"_206":96,"_37":273,"_39":26,"_69":274,"_174":-5,"_70":24,"_179":-5,"_211":275,"_17":276},{"_33":265,"_13":266,"_66":267,"_43":242,"_35":36,"_178":208,"_206":96,"_37":268,"_39":40,"_69":225,"_174":269,"_70":24,"_179":-5,"_211":270,"_17":271},{"_33":257,"_13":258,"_66":259,"_43":242,"_35":36,"_178":260,"_206":96,"_37":261,"_39":26,"_69":225,"_174":262,"_70":24,"_179":-5,"_211":263,"_17":264},{"_33":249,"_13":250,"_66":251,"_43":242,"_35":36,"_178":252,"_206":96,"_37":253,"_39":26,"_69":225,"_174":254,"_70":24,"_179":-5,"_211":255,"_17":256},{"_33":239,"_13":240,"_66":241,"_43":242,"_35":36,"_178":243,"_206":96,"_37":244,"_39":26,"_69":225,"_174":245,"_70":24,"_179":-5,"_211":246,"_17":247},{"_33":232,"_13":233,"_66":234,"_43":176,"_35":36,"_178":40,"_206":96,"_37":235,"_39":26,"_69":21,"_174":236,"_70":24,"_179":-5,"_211":237,"_17":238},{"_33":173,"_13":68,"_66":67,"_43":176,"_35":36,"_178":76,"_206":96,"_37":229,"_39":40,"_69":21,"_174":175,"_70":24,"_179":-5,"_211":230,"_17":231},{"_33":221,"_13":222,"_66":223,"_43":176,"_35":36,"_178":40,"_206":96,"_37":224,"_39":26,"_69":225,"_174":226,"_70":24,"_179":-5,"_211":227,"_17":228},{"_33":214,"_13":215,"_66":216,"_43":-5,"_35":36,"_178":122,"_206":96,"_37":217,"_39":40,"_69":21,"_174":218,"_70":24,"_179":-5,"_211":219,"_17":220},{"_33":203,"_13":204,"_66":94,"_43":-5,"_35":36,"_178":205,"_206":96,"_37":207,"_39":208,"_69":209,"_174":210,"_70":24,"_179":-5,"_211":212,"_17":213},"7917d482-5296-11f1-9647-ee650bb23af1","index.ts",10,"latest",["D",1779094165527],3,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Create table if not exists\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n request TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n request_id INTEGER NOT NULL,\n sender TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (request_id) REFERENCES assistance_requests(id)\n)`);\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ===== API Routes =====\n\n// GET all requests\napp.get(\"/api/requests\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM assistance_requests ORDER BY created_at DESC\");\n return c.json(result.rows);\n});\n\n// POST new request\napp.post(\"/api/requests\", async (c) => {\n const { name, request } = await c.req.json();\n if (!name || !request) {\n return c.json({ error: \"Name and request are required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (name, request) VALUES (?, ?)\",\n args: [name, request],\n });\n return c.json({ id: Number(result.lastInsertRowid), name, request, status: \"pending\" }, 201);\n});\n\n// UPDATE request status\napp.patch(\"/api/requests/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const { status } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE assistance_requests SET status = ? WHERE id = ?\",\n args: [status, id],\n });\n return c.json({ success: true });\n});\n\n// DELETE request\napp.delete(\"/api/requests/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.execute({ sql: \"DELETE FROM chat_messages WHERE request_id = ?\", args: [id] });\n await sqlite.execute({ sql: \"DELETE FROM assistance_requests WHERE id = ?\", args: [id] });\n return c.json({ success: true });\n});\n\n// GET chat messages for a request\napp.get(\"/api/requests/:id/messages\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({\n sql: \"SELECT * FROM chat_messages WHERE request_id = ? ORDER BY created_at ASC\",\n args: [id],\n });\n return c.json(result.rows);\n});\n\n// POST chat message\napp.post(\"/api/requests/:id/messages\", async (c) => {\n const id = c.req.param(\"id\");\n const { sender, message } = await c.req.json();\n if (!sender || !message) {\n return c.json({ error: \"Sender and message are required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (request_id, sender, message) VALUES (?, ?, ?)\",\n args: [id, sender, message],\n });\n return c.json({ id: Number(result.lastInsertRowid), request_id: id, sender, message }, 201);\n});\n\n// Unwrap and rethrow Hono errors\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[204],"84406f40-5296-11f1-9647-ee650bb23af1","README.md","019e3a45-4d09-7019-8fa6-3a71023c8ee6",["D",1779094184249],"# 🆘 Assistance Request App\n\nA full-stack assistance request application built with React + Hono on Val Town.\n\nUsers can submit assistance requests, track their status, and communicate through a real-time support chat.\n\n## Features\n\n- **Submit requests** — input field for name and description\n- **Display area** — view all submitted requests with status badges\n- **Data persistence** — SQLite database stores requests and chat messages\n- **Real-time chat** — support chat panel with 3-second polling\n- **Status management** — pending → in-progress → resolved workflow\n- **Delete requests** — remove requests and associated messages\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts (Hono)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| React[\"App.tsx\"]\n React -->|fetch| API[\"/api/requests\"]\n API -->|read/write| DB[\"SQLite DB\"]\n```\n\n## API Endpoints\n\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | /api/requests | List all requests |\n| POST | /api/requests | Create new request |\n| PATCH | /api/requests/:id | Update request status |\n| DELETE | /api/requests/:id | Delete a request |\n| GET | /api/requests/:id/messages | Get chat messages |\n| POST | /api/requests/:id/messages | Send chat message |\n\n## File Structure\n\n```\nindex.ts ← Hono backend + API routes + SQLite\nfrontend/\n index.html ← HTML shell\n index.tsx ← React entrypoint\n components/\n App.tsx ← Root layout\n RequestForm.tsx ← Submit request form\n RequestList.tsx ← Display requests list\n ChatPanel.tsx ← Real-time chat panel\n```\n",[],[215],"46949c48-5296-11f1-b0ce-ee650bb23af1","index.tsx","019e3a45-4d09-7019-8fa6-30064deb21b1",["D",1779094080713],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[181,222],["D",1779094145062],[],[181,68],"469493ba-5296-11f1-b0ce-ee650bb23af1","favicon.svg","019e3a45-4d09-7019-8fa6-2840c9ccab1f",["D",1779094080713],"\n",[],[181,233],"5fcfb24c-5296-11f1-8be2-ee650bb23af1","RequestList.tsx","5fcfb2e2-5296-11f1-8be2-ee650bb23af1","019e3a45-4d09-7019-8fa6-24c208e76c37",5,["D",1779094123114],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Request {\n id: number;\n name: string;\n request: string;\n status: string;\n created_at: string;\n}\n\ninterface Props {\n refreshKey: number;\n onSelect: (id: number | null) => void;\n selectedId: number | null;\n onRefresh: () => void;\n}\n\nexport function RequestList({ refreshKey, onSelect, selectedId, onRefresh }: Props) {\n const [requests, setRequests] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetchRequests();\n }, [refreshKey]);\n\n const fetchRequests = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/requests\");\n const data = await res.json();\n setRequests(data);\n } catch {\n console.error(\"Failed to fetch requests\");\n }\n setLoading(false);\n };\n\n const updateStatus = async (id: number, status: string) => {\n await fetch(`/api/requests/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status }),\n });\n onRefresh();\n };\n\n const deleteRequest = async (id: number) => {\n await fetch(`/api/requests/${id}`, { method: \"DELETE\" });\n if (selectedId === id) onSelect(null);\n onRefresh();\n };\n\n const statusColors: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n \"in-progress\": \"bg-blue-100 text-blue-800\",\n resolved: \"bg-green-100 text-green-800\",\n };\n\n if (loading) return

Loading requests...

;\n\n return (\n

📋 Requests ({requests.length})

\n {requests.length === 0 ? (\n

No requests yet. Submit one above!

\n ) : (\n

\n {requests.map((r) => (\n onSelect(r.id)}\n class={`border rounded-xl p-4 cursor-pointer transition-all ${\n selectedId === r.id\n ? \"border-blue-500 bg-blue-50 shadow-md\"\n : \"border-gray-200 bg-white hover:border-gray-300 hover:shadow-sm\"\n }`}\n >\n

\n {r.name}\n \n {r.status}\n \n

{r.request}

\n {new Date(r.created_at + \"Z\").toLocaleString()}\n

\n {r.status === \"pending\" && (\n { e.stopPropagation(); updateStatus(r.id, \"in-progress\"); }}\n class=\"text-blue-600 hover:underline cursor-pointer\"\n >\n Start\n \n )}\n {r.status === \"in-progress\" && (\n { e.stopPropagation(); updateStatus(r.id, \"resolved\"); }}\n class=\"text-green-600 hover:underline cursor-pointer\"\n >\n Resolve\n \n )}\n { e.stopPropagation(); deleteRequest(r.id); }}\n class=\"text-red-500 hover:underline cursor-pointer\"\n >\n Delete\n \n

\n ))}\n

\n )}\n \n );\n}\n",[],[181,248,240],"components","5914ae30-5296-11f1-9647-ee650bb23af1","RequestForm.tsx","5914aee4-5296-11f1-9647-ee650bb23af1",4,["D",1779094111818],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function RequestForm({ onSubmit }: { onSubmit: () => void }) {\n const [name, setName] = useState(\"\");\n const [request, setRequest] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [message, setMessage] = useState(\"\");\n\n const handleSubmit = async (e: Event) => {\n e.preventDefault();\n if (!name.trim() || !request.trim()) return;\n setLoading(true);\n setMessage(\"\");\n try {\n const res = await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: name.trim(), request: request.trim() }),\n });\n if (res.ok) {\n setName(\"\");\n setRequest(\"\");\n setMessage(\"✅ Request submitted successfully!\");\n onSubmit();\n } else {\n setMessage(\"❌ Failed to submit request.\");\n }\n } catch {\n setMessage(\"❌ Network error.\");\n }\n setLoading(false);\n };\n\n return (\n

📝 Submit a Request

\n setName(e.target.value)}\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 mb-3 focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n setRequest(e.target.value)}\n rows={3}\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 mb-3 focus:outline-none focus:ring-2 focus:ring-blue-400 resize-none\"\n />\n \n {loading ? \"Submitting...\" : \"Submit Request\"}\n \n {message &&

{message}

}\n \n );\n}\n",[],[181,248,250],"6841898c-5296-11f1-9647-ee650bb23af1","ChatPanel.tsx","68418a22-5296-11f1-9647-ee650bb23af1",6,["D",1779094137283],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\n\ninterface Message {\n id: number;\n sender: string;\n message: string;\n created_at: string;\n}\n\nexport function ChatPanel({ requestId }: { requestId: number | null }) {\n const [messages, setMessages] = useState([]);\n const [sender, setSender] = useState(\"\");\n const [text, setText] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const bottomRef = useRef(null);\n const intervalRef = useRef(null);\n\n useEffect(() => {\n if (requestId) {\n fetchMessages();\n // Poll for new messages every 3 seconds (real-time simulation)\n intervalRef.current = setInterval(fetchMessages, 3000) as unknown as number;\n } else {\n setMessages([]);\n }\n return () => {\n if (intervalRef.current) clearInterval(intervalRef.current);\n };\n }, [requestId]);\n\n useEffect(() => {\n bottomRef.current?.scrollIntoView({ behavior: \"smooth\" });\n }, [messages]);\n\n const fetchMessages = async () => {\n if (!requestId) return;\n try {\n const res = await fetch(`/api/requests/${requestId}/messages`);\n const data = await res.json();\n setMessages(data);\n } catch {\n console.error(\"Failed to fetch messages\");\n }\n };\n\n const sendMessage = async (e: Event) => {\n e.preventDefault();\n if (!sender.trim() || !text.trim() || !requestId) return;\n setLoading(true);\n try {\n await fetch(`/api/requests/${requestId}/messages`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ sender: sender.trim(), message: text.trim() }),\n });\n setText(\"\");\n await fetchMessages();\n } catch {\n console.error(\"Failed to send message\");\n }\n setLoading(false);\n };\n\n if (!requestId) {\n return (\n

💬

Select a request to start chatting

\n );\n }\n\n return (\n

💬 Support Chat — Request #{requestId}

Messages refresh every 3 seconds

\n\n

\n {messages.length === 0 ? (\n

No messages yet. Start the conversation!

\n ) : (\n messages.map((m) => (\n

\n {m.sender}\n {new Date(m.created_at + \"Z\").toLocaleTimeString()}\n

{m.message}

\n ))\n )}\n

\n\n

\n );\n}\n",[],[181,248,258],"5485a98c-5296-11f1-a6b5-ee650bb23af1","App.tsx","019e3a45-4d09-7019-8fa6-1c7e59d9923f",["D",1779094104170],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { RequestForm } from \"./RequestForm.tsx\";\nimport { RequestList } from \"./RequestList.tsx\";\nimport { ChatPanel } from \"./ChatPanel.tsx\";\n\nexport function App() {\n const [refreshKey, setRefreshKey] = useState(0);\n const [selectedRequestId, setSelectedRequestId] = useState(null);\n\n const triggerRefresh = () => setRefreshKey((k) => k + 1);\n\n return (\n

🆘 Assistance Request App

Submit your assistance request and chat with support in real-time.

\n\n

\n \n \n

\n \n

\n\n

\n View source\n

\n );\n}\n",[],[181,248,266],"46949234-5296-11f1-b0ce-ee650bb23af1",["D",1779094080713],"directory",[194,195,196,197],[181,248],"46949f54-5296-11f1-b0ce-ee650bb23af1",["D",1779094080713],[193,198,199,200],[181],["D",1779094080713],["D",1789468254172],{"_11":12,"_139":73},{"_11":12,"_134":135,"_72":73,"_30":71,"_136":137,"_138":24},{"_39":122,"_13":16,"_33":36,"_123":84,"_124":63,"_125":126,"_127":88,"_128":129,"_130":131,"_132":14,"_133":12},"ctx",{"_52":-5,"_160":319,"_320":321,"_322":323,"_324":24,"_325":24,"_326":24,"_327":96,"_328":-5,"_329":-7,"_330":-7,"_331":26,"_332":24,"_333":24,"_334":-5,"_335":24,"_336":24,"_337":24,"_338":-5},"ENV",{"_290":291,"_292":293,"_294":16,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318},"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 · index.html