[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_241":242,"_243":244},"routes/_app.x.$handle.$name",{"_101":100,"_37":48,"_110":91,"_32":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":30,"_125":126,"_127":128,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":-5,"_60":30,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":30},"version",17,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","386d1cf8-5459-438b-8288-c23d7ae607be","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","README.md","latestPath","fileId","c8779948-575c-11f1-afb5-ee650bb23af1","name","fileType","content","# 🤖 Townie AI Assistant\n\nA request tracker app built on Val Town with persistent SQLite storage.\n\n## Data Structure\n\nEach request is stored in a SQLite table with the following schema:\n\n```sql\nCREATE TABLE requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n)\n```\n\n| Field | Type | Description |\n|-------------|---------|--------------------------------------|\n| `id` | INTEGER | Auto-incrementing unique identifier |\n| `text` | TEXT | The content of the request |\n| `timestamp` | TEXT | UTC datetime when it was submitted |\n\n## API Endpoints\n\n| Method | Path | Description |\n|----------|----------------------|----------------------|\n| `GET` | `/api/requests` | List all requests |\n| `POST` | `/api/requests` | Create a new request |\n| `DELETE` | `/api/requests/:id` | Delete a request |\n\n## Architecture\n\n```mermaid\ngraph LR\n A[Browser - React UI] -->|fetch| B[Hono API - main.ts]\n B -->|read/write| C[SQLite Database]\n```\n\n## File Structure\n\n- `main.ts` — Hono backend with API routes + file serving\n- `frontend/index.html` — HTML shell\n- `frontend/index.tsx` — React entry point\n- `frontend/components/App.tsx` — Main app component with state management\n- `frontend/components/RequestForm.tsx` — Form to submit new requests\n- `frontend/components/RequestList.tsx` — Displays list of saved requests\n","createdAt",["D",1779619143696],"branchVersion","branchId","a7ec7b4a-575b-11f1-9bc0-ee650bb23af1","id","a7ebb73c-575b-11f1-9bc0-ee650bb23af1","my-job-board",["D",1779618659606],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Basic Assistance Request App","imageUrl","12fa63e7-842d-4b32-9f90-b80f181738be","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e5983-09e3-719e-b1c3-e157a12e3933","tursoName","a7ebb73c575b11f19bc0ee650bb23af1","tursoHostname","a7ebb73c575b11f19bc0ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_19":58,"_106":107,"_108":30},"branch",{"_13":90,"_37":91,"_46":45,"_92":47,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":48,"_99":100},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kandrianaha","handle","displayName","Kandrianaha","avatar","https://avatars.githubusercontent.com/u/195972008?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":236,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":-5,"_60":30,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":237,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":238,"_85":239,"_87":240,"_89":30},"tree",[169,176,177],"files",[169,170,171,172,173,174,175,176,177],"counts",{"_158":64,"_159":160,"_161":64,"_162":163,"_164":165},"contents",[133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_46":151,"_37":152,"_35":153,"_139":-5,"_44":45,"_43":154,"_141":128,"_41":155,"_13":64,"_38":156,"_39":-5,"_29":30,"_146":-5,"_32":157},{"_46":148,"_37":33,"_35":36,"_139":-5,"_44":45,"_43":14,"_141":30,"_41":149,"_13":64,"_38":26,"_39":40,"_29":30,"_146":-5,"_32":150},{"_46":136,"_37":137,"_35":138,"_139":-5,"_44":45,"_43":140,"_141":30,"_41":142,"_13":143,"_38":144,"_39":145,"_29":30,"_146":-5,"_32":147},"a9e99fe4-575c-11f1-b8cb-ee650bb23af1","main.ts","a7ef8c2c-575b-11f1-9bc0-ee650bb23af1","parentId",9,"latest",["D",1779619092432],8,"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 the requests table (idempotent)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n timestamp TEXT NOT NULL DEFAULT (datetime('now'))\n )\n`);\n\nconst app = new Hono();\n\n// Serve frontend\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source\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 requests ORDER BY timestamp DESC\");\n return c.json(result.rows);\n});\n\n// POST a new request\napp.post(\"/api/requests\", async (c) => {\n const body = await c.req.json();\n const text = body.text?.trim();\n\n if (!text) {\n return c.json({ error: \"Text is required\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql: \"INSERT INTO requests (text) VALUES (?)\",\n args: [text],\n });\n\n const newRow = await sqlite.execute({\n sql: \"SELECT * FROM requests WHERE id = ?\",\n args: [result.lastInsertRowid!],\n });\n\n return c.json(newRow.rows[0], 201);\n});\n\n// DELETE a request\napp.delete(\"/api/requests/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({ sql: \"DELETE FROM requests WHERE id = ?\", args: [id] });\n return c.json({ ok: true });\n});\n\n// Error handling for full stack traces\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[137],"c8779876-575c-11f1-afb5-ee650bb23af1",["D",1779619143696],[33],"ab56dba8-575c-11f1-8d53-ee650bb23af1","frontend","ab56dc5c-575c-11f1-8d53-ee650bb23af1",10,["D",1779619094829],"directory",[152],"pulls","branches",1,"forks","envVars",{"_166":64,"_168":64},"connections",{"_166":64,"_167":64},"count","unfilledCount","emptyCount",{"_46":151,"_37":152,"_35":153,"_139":-5,"_44":45,"_43":154,"_141":128,"_41":233,"_13":64,"_38":156,"_39":-5,"_29":30,"_146":-5,"_179":234,"_32":235},{"_46":228,"_37":211,"_35":205,"_139":153,"_44":45,"_43":229,"_141":128,"_41":230,"_13":64,"_38":156,"_39":-5,"_29":30,"_146":-5,"_179":231,"_32":232},{"_46":220,"_37":221,"_35":222,"_139":205,"_44":45,"_43":223,"_141":30,"_41":224,"_13":64,"_38":190,"_39":225,"_29":30,"_146":-5,"_179":226,"_32":227},{"_46":212,"_37":213,"_35":214,"_139":205,"_44":45,"_43":215,"_141":30,"_41":216,"_13":64,"_38":190,"_39":217,"_29":30,"_146":-5,"_179":218,"_32":219},{"_46":202,"_37":203,"_35":204,"_139":205,"_44":45,"_43":206,"_141":30,"_41":207,"_13":64,"_38":190,"_39":208,"_29":30,"_146":-5,"_179":209,"_32":210},{"_46":194,"_37":195,"_35":196,"_139":153,"_44":45,"_43":197,"_141":128,"_41":198,"_13":64,"_38":26,"_39":199,"_29":30,"_146":-5,"_179":200,"_32":201},{"_46":185,"_37":186,"_35":187,"_139":153,"_44":45,"_43":188,"_141":128,"_41":189,"_13":64,"_38":190,"_39":191,"_29":30,"_146":-5,"_179":192,"_32":193},{"_46":148,"_37":33,"_35":36,"_139":-5,"_44":45,"_43":14,"_141":30,"_41":182,"_13":64,"_38":26,"_39":40,"_29":30,"_146":-5,"_179":183,"_32":184},{"_46":136,"_37":137,"_35":138,"_139":-5,"_44":45,"_43":140,"_141":30,"_41":178,"_13":143,"_38":144,"_39":145,"_29":30,"_146":-5,"_179":180,"_32":181},["D",1779619092432],"children",[],[137],["D",1779619143696],[],[33],"b0716d1a-575c-11f1-8d53-ee650bb23af1","index.tsx","b0716dc4-575c-11f1-8d53-ee650bb23af1",13,["D",1779619103380],"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();\n",[],[152,186],"ae02f256-575c-11f1-b8cb-ee650bb23af1","index.html","ae02f314-575c-11f1-b8cb-ee650bb23af1",11,["D",1779619099298],"\n\n \n \n \n Townie AI Assistant\n \n \n \n

\n \n \n \n",[],[152,195],"bd4155fa-575c-11f1-9913-ee650bb23af1","RequestList.tsx","bd415708-575c-11f1-9913-ee650bb23af1","ae3ce29a-575c-11f1-88ab-ee650bb23af1",16,["D",1779619124887],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface Request {\n id: number;\n text: string;\n timestamp: string;\n}\n\ninterface Props {\n requests: Request[];\n onDelete: (id: number) => void;\n}\n\nfunction formatDate(timestamp: string): string {\n const date = new Date(timestamp + \"Z\"); // SQLite stores UTC without Z suffix\n return date.toLocaleString();\n}\n\nexport function RequestList({ requests, onDelete }: Props) {\n if (requests.length === 0) {\n return (\n

📭

No requests yet. Submit one above!

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

\n Submitted Requests ({requests.length})\n

\n {requests.map((req) => (\n \n

{req.text}

\n 🕐 {formatDate(req.timestamp)}\n

\n onDelete(req.id)}\n className=\"text-gray-300 hover:text-red-500 text-lg transition flex-shrink-0\"\n title=\"Delete request\"\n >\n ✕\n \n

\n ))}\n

\n \n );\n}\n",[],[152,211,203],"components","b9c5657e-575c-11f1-8d53-ee650bb23af1","RequestForm.tsx","b9c56646-575c-11f1-8d53-ee650bb23af1",15,["D",1779619119037],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n onSubmit: (text: string) => Promise;\n}\n\nexport function RequestForm({ onSubmit }: Props) {\n const [text, setText] = useState(\"\");\n const [submitting, setSubmitting] = useState(false);\n const [error, setError] = useState(null);\n\n async function handleSubmit(e: React.FormEvent) {\n e.preventDefault();\n const trimmed = text.trim();\n if (!trimmed) return;\n\n setSubmitting(true);\n setError(null);\n\n try {\n await onSubmit(trimmed);\n setText(\"\");\n } catch {\n setError(\"Failed to submit. Please try again.\");\n } finally {\n setSubmitting(false);\n }\n }\n\n return (\n

\n \n What do you need help with?\n \n setText(e.target.value)}\n placeholder=\"Describe your request...\"\n rows={3}\n className=\"w-full border border-gray-300 rounded-lg p-3 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400 resize-none\"\n />\n {error &&

{error}

}\n \n {submitting ? \"Submitting...\" : \"Submit Request\"}\n \n \n );\n}\n",[],[152,211,213],"b4cdda06-575c-11f1-b8cb-ee650bb23af1","App.tsx","b4cddae2-575c-11f1-b8cb-ee650bb23af1",14,["D",1779619110707],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { RequestForm } from \"./RequestForm.tsx\";\nimport { RequestList } from \"./RequestList.tsx\";\n\ninterface Request {\n id: number;\n text: string;\n timestamp: string;\n}\n\nexport function App() {\n const [requests, setRequests] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n // Fetch all requests on mount\n useEffect(() => {\n fetchRequests();\n }, []);\n\n async function fetchRequests() {\n try {\n const res = await fetch(\"/api/requests\");\n const data = await res.json();\n setRequests(data);\n } catch (err) {\n setError(\"Failed to load requests\");\n } finally {\n setLoading(false);\n }\n }\n\n async function addRequest(text: string) {\n const res = await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ text }),\n });\n\n if (!res.ok) {\n throw new Error(\"Failed to submit request\");\n }\n\n const newRequest = await res.json();\n setRequests((prev) => [newRequest, ...prev]);\n }\n\n async function deleteRequest(id: number) {\n await fetch(`/api/requests/${id}`, { method: \"DELETE\" });\n setRequests((prev) => prev.filter((r) => r.id !== id));\n }\n\n return (\n

🤖 Townie AI Assistant

Submit and track your assistance requests

\n\n \n\n {loading &&

Loading requests...

}\n {error &&

{error}

}\n\n {!loading && (\n \n )}\n\n

\n view source\n

\n );\n}\n",[],[152,211,221],"ae3ce1be-575c-11f1-88ab-ee650bb23af1",12,["D",1779619099693],[171,172,173],[152,211],["D",1779619094829],[170,174,175],[152],["D",1779618659606],["D",1789470042795],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_19":58,"_106":107,"_108":30},{"_13":90,"_37":91,"_46":45,"_92":47,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":48,"_99":100},"ctx",{"_83":-5,"_130":274,"_275":276,"_277":278,"_279":30,"_280":30,"_281":30,"_282":128,"_283":-5,"_284":-7,"_285":-7,"_286":64,"_287":30,"_288":30,"_289":-5,"_290":30,"_291":30,"_292":30,"_293":-5},"ENV",{"_245":246,"_247":248,"_249":91,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273},"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 · v17