[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_364":365,"_366":367},"routes/_app.x.$handle.$name",{"_116":115,"_38":57,"_124":102,"_33":125,"_13":14,"_126":-5,"_11":127,"_128":129,"_130":131,"_132":133,"_134":135,"_27":-5,"_136":137,"_138":139,"_140":31,"_141":142,"_143":71,"_144":-5,"_145":-5,"_146":147},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_55":56,"_38":57,"_44":58,"_59":-5,"_60":31,"_61":62,"_63":62,"_64":65,"_66":-5,"_19":67,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":75,"_76":77,"_78":79,"_80":81,"_82":83,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":31},"version",13,"changes",[25,26],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","b98ee00c-e392-42e6-ab4d-9fb606f99fd4","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_27":49,"_29":-7,"_30":31,"_32":31,"_33":50,"_35":50},{"_27":28,"_29":-7,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous","deleted",false,"deletedHere","path","frontend/hooks/useRoute.ts","latestPath","fileId","8e5e97b0-39b2-11f1-bce1-42b51c65c3df","name","useRoute.ts","fileType","script","content","import { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\n\nexport function useRoute() {\n const [path, setPath] = useState(window.location.pathname);\n\n useEffect(() => {\n const onPop = () => setPath(window.location.pathname);\n window.addEventListener(\"popstate\", onPop);\n return () => window.removeEventListener(\"popstate\", onPop);\n }, []);\n\n const navigate = useCallback((to: string) => {\n window.history.pushState(null, \"\", to);\n setPath(to);\n }, []);\n\n return { path, navigate };\n}\n","createdAt",["D",1776357448062],"branchVersion","branchId","a4af7710-39b1-11f1-84e8-42b51c65c3df",{"_36":51,"_38":52,"_40":53,"_42":-5,"_44":54,"_46":14,"_47":48,"_30":31},"frontend/hooks","154fda2d-9941-49f1-990f-5f8a0c9a6fd4","hooks","directory",["D",1776357448062],"id","a4a85c00-39b1-11f1-84e8-42b51c65c3df","win-wall",["D",1776357055926],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","f82d7dbb-2899-430f-8e34-4c8688c5bdad","pinnedFileId","019d9721-9e2a-7242-a257-d05dd14e0950","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d9718-b2f5-70df-aa7f-b4e7ee91e025","tursoName","a4a85c0039b111f184e842b51c65c3df","tursoHostname","a4a85c0039b111f184e842b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789506093912],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_116":115,"_123":119},"org",{"_116":115,"_117":-5,"_118":119,"_19":-5,"_120":121,"_122":71},"branch",{"_13":101,"_38":102,"_55":48,"_103":56,"_104":105,"_106":107,"_108":62,"_109":110,"_111":112,"_113":57,"_114":115},"isOwned",25,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","saltmine","handle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b87e7fbf-eb13-44a9-847a-14d2be1c5a00/square512?exp=1789545599&sig=a6ed307a3fb24f454fc0fedefebc32c09a75104821f7e24fe8fb05309d279dc9","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_55":56,"_38":57,"_44":359,"_59":-5,"_60":31,"_61":62,"_63":62,"_64":65,"_66":-5,"_19":67,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":75,"_76":77,"_78":79,"_80":81,"_82":360,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":361,"_96":362,"_98":363,"_100":31},"tree",[215,217,219,232,234,235],"files",[215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235],"counts",{"_205":75,"_206":171,"_207":75,"_208":209,"_210":211},"contents",[159,160,161,162,163,164],"upstreamProject",{"_55":110,"_38":155,"_64":65,"_66":156,"_61":62,"_94":157},"upstreamBranch",{"_55":105,"_44":148,"_149":150,"_38":102,"_103":110,"_13":151,"_104":-5,"_106":-5,"_152":153,"_59":-5,"_100":31,"_61":62,"_114":154,"_76":112,"_113":155},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789545599&sig=91cfcc631bd9f3dd8274549c04838d172adf2572755982193460d49bfd04bd62",{"_116":154,"_123":158},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789545599&sig=2316df07e67031dd48e537f6ce0c4c14b92716fed790ec83ecf27974cc65aa31",{"_55":199,"_38":200,"_36":201,"_167":-5,"_47":48,"_46":202,"_169":71,"_44":203,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_33":204},{"_55":193,"_38":194,"_36":195,"_167":-5,"_47":48,"_46":196,"_169":71,"_44":197,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_33":198},{"_55":188,"_38":189,"_36":190,"_167":-5,"_47":48,"_46":171,"_169":71,"_44":191,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_33":192},{"_55":182,"_38":183,"_36":184,"_167":-5,"_47":48,"_46":185,"_169":71,"_44":186,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_33":187},{"_55":176,"_38":177,"_36":178,"_167":-5,"_47":48,"_46":171,"_169":31,"_44":179,"_13":75,"_40":27,"_42":180,"_30":31,"_174":-5,"_33":181},{"_55":165,"_38":166,"_36":69,"_167":-5,"_47":48,"_46":168,"_169":31,"_44":170,"_13":171,"_40":172,"_42":173,"_30":31,"_174":-5,"_33":175},"7dd493d6-39b2-11f1-bc52-42b51c65c3df","index.ts","parentId",8,"latest",["D",1776357420250],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport testimonialApi from \"./api/testimonials.ts\";\n\nconst app = new Hono();\n\n// Serve pages\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/submit\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/admin\", () => serveFile(\"/frontend/index.html\"));\n\n// API routes\napp.route(\"/api/testimonials\", testimonialApi);\n\n// Serve all frontend files (JS, CSS, etc.)\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// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[166],"a4d9fd32-39b1-11f1-84e8-42b51c65c3df","README.md","019d9721-9e2a-7242-a257-ce28489f7d98",["D",1776357055926],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types",[177],"692dbe62-39b2-11f1-99b3-42b51c65c3df","shared","692dbf16-39b2-11f1-99b3-42b51c65c3df",2,["D",1776357385665],[183],"a4d9f774-39b1-11f1-84e8-42b51c65c3df","frontend","019d9721-9e2a-7242-a257-cae5df2ff1b8",["D",1776357055926],[189],"696bec5a-39b2-11f1-99b3-42b51c65c3df","database","696bed18-39b2-11f1-99b3-42b51c65c3df",3,["D",1776357386070],[194],"733b9316-39b2-11f1-a6f1-42b51c65c3df","api","733b942e-39b2-11f1-a6f1-42b51c65c3df",6,["D",1776357402531],[200],"pulls","branches","forks","envVars",{"_212":75,"_214":75},"connections",{"_212":75,"_213":75},"count","unfilledCount","emptyCount",{"_55":199,"_38":200,"_36":201,"_167":-5,"_47":48,"_46":202,"_169":71,"_44":356,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":357,"_33":358},{"_55":348,"_38":349,"_36":350,"_167":201,"_47":48,"_46":351,"_169":71,"_44":352,"_13":75,"_40":41,"_42":353,"_30":31,"_174":-5,"_237":354,"_33":355},{"_55":193,"_38":194,"_36":195,"_167":-5,"_47":48,"_46":196,"_169":71,"_44":345,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":346,"_33":347},{"_55":337,"_38":338,"_36":339,"_167":195,"_47":48,"_46":340,"_169":71,"_44":341,"_13":75,"_40":41,"_42":342,"_30":31,"_174":-5,"_237":343,"_33":344},{"_55":188,"_38":189,"_36":190,"_167":-5,"_47":48,"_46":171,"_169":71,"_44":334,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":335,"_33":336},{"_55":330,"_38":307,"_36":301,"_167":190,"_47":48,"_46":171,"_169":71,"_44":331,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":332,"_33":333},{"_55":323,"_38":324,"_36":325,"_167":301,"_47":48,"_46":171,"_169":31,"_44":326,"_13":75,"_40":41,"_42":327,"_30":31,"_174":-5,"_237":328,"_33":329},{"_55":316,"_38":317,"_36":318,"_167":301,"_47":48,"_46":171,"_169":71,"_44":319,"_13":75,"_40":41,"_42":320,"_30":31,"_174":-5,"_237":321,"_33":322},{"_55":308,"_38":309,"_36":310,"_167":301,"_47":48,"_46":311,"_169":71,"_44":312,"_13":75,"_40":41,"_42":313,"_30":31,"_174":-5,"_237":314,"_33":315},{"_55":298,"_38":299,"_36":300,"_167":301,"_47":48,"_46":302,"_169":71,"_44":303,"_13":75,"_40":41,"_42":304,"_30":31,"_174":-5,"_237":305,"_33":306},{"_55":294,"_38":52,"_36":51,"_167":190,"_47":48,"_46":14,"_169":71,"_44":295,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":296,"_33":297},{"_55":290,"_38":39,"_36":37,"_167":51,"_47":48,"_46":14,"_169":71,"_44":291,"_13":75,"_40":41,"_42":43,"_30":31,"_174":-5,"_237":292,"_33":293},{"_55":283,"_38":284,"_36":285,"_167":190,"_47":48,"_46":286,"_169":71,"_44":287,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":288,"_33":289},{"_55":275,"_38":276,"_36":277,"_167":190,"_47":48,"_46":278,"_169":31,"_44":279,"_13":75,"_40":41,"_42":280,"_30":31,"_174":-5,"_237":281,"_33":282},{"_55":268,"_38":269,"_36":270,"_167":190,"_47":48,"_46":171,"_169":71,"_44":271,"_13":75,"_40":27,"_42":272,"_30":31,"_174":-5,"_237":273,"_33":274},{"_55":261,"_38":262,"_36":263,"_167":190,"_47":48,"_46":171,"_169":31,"_44":264,"_13":75,"_40":27,"_42":265,"_30":31,"_174":-5,"_237":266,"_33":267},{"_55":254,"_38":255,"_36":256,"_167":190,"_47":48,"_46":171,"_169":71,"_44":257,"_13":75,"_40":41,"_42":258,"_30":31,"_174":-5,"_237":259,"_33":260},{"_55":182,"_38":183,"_36":184,"_167":-5,"_47":48,"_46":185,"_169":71,"_44":251,"_13":75,"_40":53,"_42":-5,"_30":31,"_174":-5,"_237":252,"_33":253},{"_55":243,"_38":244,"_36":245,"_167":184,"_47":48,"_46":246,"_169":71,"_44":247,"_13":75,"_40":41,"_42":248,"_30":31,"_174":-5,"_237":249,"_33":250},{"_55":176,"_38":177,"_36":178,"_167":-5,"_47":48,"_46":171,"_169":31,"_44":240,"_13":75,"_40":27,"_42":180,"_30":31,"_174":-5,"_237":241,"_33":242},{"_55":165,"_38":166,"_36":69,"_167":-5,"_47":48,"_46":168,"_169":31,"_44":236,"_13":171,"_40":172,"_42":173,"_30":31,"_174":-5,"_237":238,"_33":239},["D",1776357420250],"children",[],[166],["D",1776357055926],[],[177],"6c7dc35a-39b2-11f1-a6f1-42b51c65c3df","types.ts","6c7dc40e-39b2-11f1-a6f1-42b51c65c3df",4,["D",1776357391208],"export interface Testimonial {\n id: number;\n author_name: string;\n content: string;\n status: \"pending\" | \"approved\" | \"rejected\";\n created_at: string;\n approved_at: string | null;\n}\n\nexport interface SubmitTestimonialRequest {\n author_name: string;\n content: string;\n}\n",[],[183,244],["D",1776357385665],[233],[183],"a4b605a8-39b1-11f1-84e8-42b51c65c3df","index.tsx","019d9721-9e2a-7242-a257-c737246aa74a",["D",1776357055926],"/** @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();",[],[189,255],"a4b5ff04-39b1-11f1-84e8-42b51c65c3df","index.html","019d9721-9e2a-7242-a257-c26e1cb41fa6",["D",1776357055926],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[189,262],"a4b5f9c8-39b1-11f1-84e8-42b51c65c3df","favicon.svg","019d9721-9e2a-7242-a257-bf26622e28b1",["D",1776357055926],"\n",[],[189,269],"862b0ea2-39b2-11f1-bce1-42b51c65c3df","api.ts","862b0f6a-39b2-11f1-bce1-42b51c65c3df",10,["D",1776357434304],"import type { Testimonial, SubmitTestimonialRequest } from \"../shared/types.ts\";\n\nexport async function fetchApproved(): Promise {\n const res = await fetch(\"/api/testimonials/approved\");\n return res.json();\n}\n\nexport async function fetchAll(): Promise {\n const res = await fetch(\"/api/testimonials/all\");\n return res.json();\n}\n\nexport async function fetchPending(): Promise {\n const res = await fetch(\"/api/testimonials/pending\");\n return res.json();\n}\n\nexport async function submitTestimonial(data: SubmitTestimonialRequest): Promise {\n const res = await fetch(\"/api/testimonials\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n if (!res.ok) {\n const err = await res.json();\n throw new Error(err.error || \"Failed to submit\");\n }\n return res.json();\n}\n\nexport async function approveTestimonial(id: number): Promise {\n const res = await fetch(`/api/testimonials/${id}/approve`, { method: \"POST\" });\n return res.json();\n}\n\nexport async function rejectTestimonial(id: number): Promise {\n const res = await fetch(`/api/testimonials/${id}/reject`, { method: \"POST\" });\n return res.json();\n}\n\nexport async function deleteTestimonial(id: number): Promise {\n await fetch(`/api/testimonials/${id}`, { method: \"DELETE\" });\n}\n",[],[189,276],"80838628-39b2-11f1-ad0c-42b51c65c3df","pages","808386c8-39b2-11f1-ad0c-42b51c65c3df",9,["D",1776357424788],[],[189,284],"8e5e9710-39b2-11f1-bce1-42b51c65c3df",["D",1776357448062],[],[189,52,39],"8e5ea41c-39b2-11f1-bce1-42b51c65c3df",["D",1776357448062],[226],[189,52],"87e3d5bc-39b2-11f1-afd0-42b51c65c3df","TestimonialCard.tsx","87e3d670-39b2-11f1-afd0-42b51c65c3df","019d9721-9e2a-7242-a257-bb21027d391b",11,["D",1776357437191],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { Testimonial } from \"../../shared/types.ts\";\n\ninterface Props {\n testimonial: Testimonial;\n}\n\nexport function TestimonialCard({ testimonial }: Props) {\n const date = new Date(testimonial.created_at).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n\n return (\n

\"{testimonial.content}\"

\n {testimonial.author_name}\n {date}\n

\n );\n}\n",[],[189,307,299],"components","8d072364-39b2-11f1-a6f1-42b51c65c3df","Nav.tsx","8d07242c-39b2-11f1-a6f1-42b51c65c3df",12,["D",1776357445813],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface Props {\n currentPath: string;\n onNavigate: (path: string) => void;\n}\n\nexport function Nav({ currentPath, onNavigate }: Props) {\n const links = [\n { path: \"/\", label: \"🏆 Win Wall\" },\n { path: \"/submit\", label: \"✍️ Submit\" },\n { path: \"/admin\", label: \"🔒 Admin\" },\n ];\n\n return (\n

\n {links.map((link) => (\n {\n e.preventDefault();\n onNavigate(link.path);\n }}\n class={`px-4 py-2 rounded-lg text-sm font-medium transition-colors ${\n currentPath === link.path\n ? \"bg-indigo-50 text-indigo-700\"\n : \"text-gray-600 hover:bg-gray-50 hover:text-gray-900\"\n }`}\n >\n {link.label}\n \n ))}\n

\n \n view source\n \n

\n );\n}\n",[],[189,307,309],"a4b5ef46-39b1-11f1-84e8-42b51c65c3df","Counter.tsx","019d9721-9e2a-7242-a257-b503c0040a2c",["D",1776357055926],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[189,307,317],"a4b5c2dc-39b1-11f1-84e8-42b51c65c3df","App.tsx","019d9721-9e2a-7242-a257-b0d2f7557178",["D",1776357055926],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[189,307,324],"a4b5f70c-39b1-11f1-84e8-42b51c65c3df",["D",1776357055926],[221,222,223,224],[189,307],["D",1776357055926],[220,225,227,228,229,230,231],[189],"6fd727ee-39b2-11f1-a6f1-42b51c65c3df","queries.ts","6fd728c0-39b2-11f1-a6f1-42b51c65c3df",5,["D",1776357396838],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Testimonial } from \"../shared/types.ts\";\n\nexport async function getApprovedTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials WHERE status = 'approved' ORDER BY approved_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function getAllTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials ORDER BY created_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function getPendingTestimonials(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM testimonials WHERE status = 'pending' ORDER BY created_at DESC\",\n );\n return result.rows as unknown as Testimonial[];\n}\n\nexport async function createTestimonial(authorName: string, content: string): Promise {\n const result = await sqlite.execute({\n sql: \"INSERT INTO testimonials (author_name, content) VALUES (?, ?) RETURNING *\",\n args: [authorName, content],\n });\n return result.rows[0] as unknown as Testimonial;\n}\n\nexport async function approveTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"UPDATE testimonials SET status = 'approved', approved_at = datetime('now') WHERE id = ? RETURNING *\",\n args: [id],\n });\n return (result.rows[0] as unknown as Testimonial) ?? null;\n}\n\nexport async function rejectTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"UPDATE testimonials SET status = 'rejected' WHERE id = ? RETURNING *\",\n args: [id],\n });\n return (result.rows[0] as unknown as Testimonial) ?? null;\n}\n\nexport async function deleteTestimonial(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"DELETE FROM testimonials WHERE id = ?\",\n args: [id],\n });\n return result.rowsAffected > 0;\n}\n",[],[194,338],["D",1776357386070],[218],[194],"790afd0e-39b2-11f1-9973-42b51c65c3df","testimonials.ts","790afdf4-39b2-11f1-9973-42b51c65c3df",7,["D",1776357412276],"import { Hono } from \"npm:hono\";\nimport {\n getApprovedTestimonials,\n getAllTestimonials,\n getPendingTestimonials,\n createTestimonial,\n approveTestimonial,\n rejectTestimonial,\n deleteTestimonial,\n} from \"../database/queries.ts\";\n\nconst api = new Hono();\n\n// Public: get approved testimonials for the wall\napi.get(\"/approved\", async (c) => {\n const testimonials = await getApprovedTestimonials();\n return c.json(testimonials);\n});\n\n// Admin: get all testimonials\napi.get(\"/all\", async (c) => {\n const testimonials = await getAllTestimonials();\n return c.json(testimonials);\n});\n\n// Admin: get pending testimonials\napi.get(\"/pending\", async (c) => {\n const testimonials = await getPendingTestimonials();\n return c.json(testimonials);\n});\n\n// Public: submit a new testimonial\napi.post(\"/\", async (c) => {\n const body = await c.req.json();\n const { author_name, content } = body;\n\n if (!author_name?.trim() || !content?.trim()) {\n return c.json({ error: \"Name and testimonial text are required\" }, 400);\n }\n\n if (content.trim().length > 500) {\n return c.json({ error: \"Testimonial must be 500 characters or fewer\" }, 400);\n }\n\n const testimonial = await createTestimonial(author_name.trim(), content.trim());\n return c.json(testimonial, 201);\n});\n\n// Admin: approve a testimonial\napi.post(\"/:id/approve\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const testimonial = await approveTestimonial(id);\n if (!testimonial) return c.json({ error: \"Not found\" }, 404);\n return c.json(testimonial);\n});\n\n// Admin: reject a testimonial\napi.post(\"/:id/reject\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const testimonial = await rejectTestimonial(id);\n if (!testimonial) return c.json({ error: \"Not found\" }, 404);\n return c.json(testimonial);\n});\n\n// Admin: delete a testimonial\napi.delete(\"/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const deleted = await deleteTestimonial(id);\n if (!deleted) return c.json({ error: \"Not found\" }, 404);\n return c.json({ ok: true });\n});\n\nexport default api;\n",[],[200,349],["D",1776357402531],[216],[200],["D",1776357055926],["D",1789506093912],{"_116":115,"_123":119},{"_116":115,"_117":-5,"_118":119,"_19":-5,"_120":121,"_122":71},{"_13":101,"_38":102,"_55":48,"_103":56,"_104":105,"_106":107,"_108":62,"_109":110,"_111":112,"_113":57,"_114":115},"ctx",{"_94":-5,"_145":397,"_398":399,"_400":401,"_402":31,"_403":31,"_404":31,"_405":71,"_406":-5,"_407":-7,"_408":-7,"_409":75,"_410":31,"_411":31,"_412":-5,"_413":31,"_414":31,"_415":31,"_416":-5},"ENV",{"_368":369,"_370":371,"_372":102,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396},"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 · v13