[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_540":541,"_542":543},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_401":-5,"_20":402,"_22":403,"_404":405,"_406":407,"_26":408,"_24":409,"_410":-5,"_411":412,"_413":58,"_414":415,"_416":76,"_417":-5,"_418":-5,"_419":420},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":31,"_32":33,"_34":35,"_36":-5},"handle","stevekrouse","name","reactRouter7Example","branchName","delete-button","version","path","frontend/index.html","project",{"_37":50,"_13":14,"_44":354,"_56":-5,"_355":58,"_59":60,"_356":60,"_39":357,"_358":-5,"_359":360,"_361":362,"_363":76,"_364":-5,"_365":366,"_367":113,"_62":63,"_368":369,"_370":371,"_372":373,"_374":-5,"_375":376,"_377":376,"_378":379,"_380":379,"_381":379,"_382":376,"_383":376,"_384":385,"_386":387,"_388":389,"_57":58},"tree",[86,87,88,89,90,91,92],"file",{"_37":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_44":77,"_17":78,"_79":24,"_80":81,"_82":58,"_83":-5,"_18":84},"contents",[],"upstream",{"_37":43,"_44":45,"_46":47,"_13":48,"_49":50,"_17":51,"_52":-5,"_53":-5,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":12,"_62":63,"_64":14},"pull",{"_37":38,"_39":40,"_41":42},"ahead",7,"behind",21,"envVars","id","240e6ab0-1646-11f0-871b-569c3dd06744","description","","state","pending","f1a26f20-14cb-11f0-b108-569c3dd06744","createdAt",["D",1744152661331],"updatedAt",["D",1771761464050],"main","projectId","f1a22d8a-14cb-11f0-b108-569c3dd06744",178,"forkedBranchId","forkedBranchVersion","lockfileKey","1771761466206-esm.town_v_stevekrouse_reactRouter7Example@178-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","2aadaf58-1645-11f0-b5a9-569c3dd06744","index.html","fileId","7f09b221-180b-47aa-8b48-8a390bce93e1","parentId","2dad1ee4-a6ea-4a16-b839-896f14d0286d","branchId","2aa8a9d6-1645-11f0-b5a9-569c3dd06744","branchVersion",1,"latest",true,["D",1744314677289],0,"fileType","content","\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n","deleted","label",[85,66],"frontend",{"_37":315,"_13":316,"_67":317,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":318,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":319,"_18":320},{"_37":237,"_13":85,"_67":70,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":238,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":239,"_18":240},{"_37":142,"_13":143,"_67":144,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":145,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":146,"_18":147},{"_37":117,"_13":118,"_67":119,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":120,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":122,"_18":123},{"_37":108,"_13":109,"_67":110,"_69":-5,"_71":72,"_73":111,"_75":76,"_44":112,"_17":113,"_79":24,"_80":114,"_82":58,"_83":-5,"_98":115,"_18":116},{"_37":101,"_13":102,"_67":103,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":104,"_17":78,"_79":24,"_80":105,"_82":58,"_83":-5,"_98":106,"_18":107},{"_37":93,"_13":94,"_67":95,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":96,"_17":78,"_79":24,"_80":97,"_82":58,"_83":-5,"_98":99,"_18":100},"2aadd762-1645-11f0-b5a9-569c3dd06744","react-router-questions.md","ab61e678-0a4b-4250-a1e3-e820c7fc638c",["D",1744314677289],"# React Router Questions\n\nI have some questions about how to set up React Router 7 as a \"custom framework\". It seems like the documentation on this is mostly these two pages:\n\n1. Docs on React Router 7: [\"Custom Framework\"](https://reactrouter.com/start/data/custom)\n2. Example app on Github: [@remix-run/custom-react-router-framework-example](https://github.com/remix-run/custom-react-router-framework-example)\n\n## How I've set it up\n\n### Client loaders & actions\n\n[On the client, I turn loaders and actions into `fetch` calls to the backend.](https://www.val.town/x/stevekrouse/reactRouter7Example/code/shared/routes.ts) This is heavily inspired by the [here in the Github example](https://github.com/remix-run/custom-react-router-framework-example/blob/main/app/routes.tsx#L14-L29).\n\n### Handling client loader & action API calls on the server\n\n[On the client, I check if the Accept header is JSON and then return the loader or action data.](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L66-77) This is heavily inspired by the [here in the Github example](https://github.com/remix-run/custom-react-router-framework-example/blob/main/entry.server.tsx#L12-L22).\n\n### Questions\n\n### 1. Setting loader state for multiple loaders\n\nRight now I've converted every loader into its own fetch call. This is the opposite of what frameworks refer to as \"single fetch\". However on the backend, I actually get access the full loaderData for all nested routes. I even wrote [this silly function to combine all the loaderData objects into one big object](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L36-50).\n\nIdeally we should make a single loader call per navigation event, and set the internal router state. In other words, I would like to somehow reach into React Router and set this `state` here:\n\n![Screenshot 2025-04-10 at 15.03.32@2x.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/23997cd0-6e12-46b5-53d8-89e2fe5a9c00/public)\n\nAnd then let `useLoaderData` funnel the correct loader data's to the correct routes via their IDs.\n\n### 2. Action redirects\n\nWhen my backend returns a 302 from an action, how should I handle this on the frontend? For example, after you create a new topic on the home page, [I redirect you to that topic's ID](https://www.val.town/x/stevekrouse/reactRouter7Example/code/routes/Topics.action.ts#L13)\n\nHowever, I'm not sure how [to handle this on the client here](https://www.val.town/x/stevekrouse/reactRouter7Example/code/shared/routes.ts#L26).\n\nIdeally, I would do a proper React Router \"navigation\", and pass the relevant loader data along so it can be 100% client-side and require no other API calls.\n\n### 3. Should I use `queryRoute` instead of `query` in my server?\n\nThe [example app uses `queryRoute`](https://github.com/remix-run/custom-react-router-framework-example/blob/f5a141d67800e8da076cd1bb3130f29a8c0d4ce3/entry.server.tsx#L77-L79) instead of `query` for loaders and actions. I tried using that too but it didn't work. I think it returned undefined. I am now [using `query` for everything](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L58).\n\nIs it better to use that or is my use of `query` fine? I get the feeling that `query` is doing a bunch of work I don't need, ie SRR, but maybe that's not very expensive so it's fine? I noticed [the example app uses `X-Route-ID`](https://github.com/remix-run/custom-react-router-framework-example/blob/main/app/layout.client.tsx#L8), so maybe I'd need to use that?","children",[],[94],"2aadd5d2-1645-11f0-b5a9-569c3dd06744","TODO.md","e6299794-a831-4673-84bd-a5afa6951f6f",["D",1744314677289],"- [ ] Get OpenTownie or Gemini or Claude or OpenAI to synthesize the core of these patterns into a prompt we can use to make more ReactRouter apps, such as...\n- [ ] Convert this or into the basic react router guest book (and preserve this forum app in another project?)\n- [ ] To what extent can these patterns be packaged up into a Val Town Router project? Would be neat to get the version pinning thing all centralized, can this as-a-library be that centralized place?",[],[102],"5e51b8e0-1645-11f0-88ab-569c3dd06744","README.md","10deab7e-c9d8-4a0c-9a8a-0a0f52346c98",8,["D",1744314763898],3,"# Community Message Board\n\nA simple community message board application built with React Router 7, demonstrating a full-stack approach with server-side rendering and client-side navigation.\n\n## Features\n\n- **Server-Side Rendering**: All pages are server-rendered when accessed directly\n- **Client-Side Navigation**: After initial load, navigation happens client-side\n- **Topic Management**: Create and view discussion topics\n- **Messaging System**: Post messages in topics\n- **Direct Message Links**: Link directly to specific messages via timestamps\n- **Search Functionality**: Search topics and messages with URL parameters\n- **Loading Indicators**: Visual feedback during async operations\n- **Data Management**: Delete all topics and messages with a single click\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database queries\n│ └── index.ts # Server entry point\n├── frontend/\n│ ├── components/\n│ │ ├── LoadingSpinner.tsx\n│ │ ├── MessageForm.tsx\n│ │ ├── MessageList.tsx\n│ │ └── SearchForm.tsx\n│ ├── index.html # HTML template\n│ └── index.tsx # Client entry point\n├── routes/\n│ ├── App.tsx # Main application component\n│ ├── Home.tsx # Home page component\n│ ├── Home.loader.ts # Home page data loader\n│ ├── Topic.tsx # Topic detail component\n│ ├── Topic.loader.ts # Topic data loader\n│ ├── Topic.action.ts # Topic message creation action\n│ ├── TopicMessage.loader.ts # Direct message link loader\n│ ├── Topics.action.ts # Topic creation action\n│ ├── DeleteAll.action.ts # Delete all topics and messages action\n│ ├── Search.tsx # Search results component\n│ └── Search.loader.ts # Search data loader\n└── shared/\n ├── routes.ts # Route definitions\n └── types.ts # Shared TypeScript types\n```\n\n## How It Works\n\n### Server-Side Rendering\n\nThe application uses React Router 7's `createStaticHandler`, `createStaticRouter`, and `StaticRouterProvider` to render pages on the server. When a user directly accesses a URL:\n\n1. The server receives the request\n2. It runs the appropriate loaders/actions for the matched route\n3. The page is rendered with the data and sent to the client\n4. The client hydrates the page with `createBrowserRouter` and `RouterProvider`\n\n### Client-Side Navigation\n\nAfter the initial page load, navigation happens entirely on the client:\n\n1. React Router handles link clicks and form submissions\n2. Data is fetched asynchronously using loaders and actions\n3. A loading spinner is displayed during data fetching\n4. The UI updates without a full page reload\n\n### Data Flow\n\n1. **Topics**: Stored in SQLite with title and creation timestamp\n2. **Messages**: Linked to topics with content and creation timestamp\n3. **Search**: Queries both topics and messages, with results in the URL\n\n### URL Structure\n\n- `/` - Home page with list of topics\n- `/` - Create new topic\n- `/delete-all` - Delete all topics and messages\n- `/topics/:topicId` - View a topic and its messages\n- `/topics/:topicId/messages/:messageId` - Direct link to a message\n- `/search?q=query` - Search results\n\n\n## Implementation Details\n\nThis application demonstrates a \"Val Town fullstack framework\" approach, combining:\n\n- **Hono**: For server-side routing and handling\n- **React Router 7**: For both server and client-side routing\n- **SQLite**: For data persistence\n- **TypeScript**: For type safety across the stack\n\nThe code is structured to be idiomatic and simple, serving as a reference for building full-stack applications with React Router 7. The project uses a Remix-style file naming convention with co-located components, loaders, and actions in the `/routes` directory.",[],[109],"2aadd064-1645-11f0-b5a9-569c3dd06744","shared","d02154ad-498e-4d5e-9daf-80c817fbdbd0",["D",1744314677289],"directory",[124,125],[118],{"_37":134,"_13":135,"_67":136,"_69":119,"_71":72,"_73":137,"_75":76,"_44":138,"_17":74,"_79":130,"_80":139,"_82":58,"_83":-5,"_98":140,"_18":141},{"_37":126,"_13":127,"_67":128,"_69":119,"_71":72,"_73":74,"_75":76,"_44":129,"_17":78,"_79":130,"_80":131,"_82":58,"_83":-5,"_98":132,"_18":133},"2aadce98-1645-11f0-b5a9-569c3dd06744","types.ts","d693e7f0-5fe0-4156-854c-08a19f97ecc7",["D",1744314677289],"script","/**\n * Topic model representing a discussion thread\n */\nexport interface Topic {\n id: number;\n title: string;\n createdAt: string;\n}\n\n/**\n * Message model representing a post within a topic\n */\nexport interface Message {\n id: number;\n topicId: number;\n content: string;\n createdAt: string;\n}\n\n/**\n * Search results containing matching topics and messages\n */\nexport interface SearchResults {\n topics: Topic[];\n messages: Message[];\n query: string;\n}",[],[118,127],"45477c86-1645-11f0-9e0a-569c3dd06744","routes.ts","58d7548f-8eef-4fb6-af3f-dc7669451e67",4,["D",1744314721924],"import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { App } from \"../routes/App.tsx\";\nimport { Home } from \"../routes/Home.tsx\";\nimport { Search } from \"../routes/Search.tsx\";\nimport { Topic } from \"../routes/Topic.tsx\";\n\nlet isServer = typeof document === \"undefined\";\nlet isClient = !isServer;\n\n// Generic loader that forwards on requests for that page's JSON data\nfunction clientLoader({ request }: LoaderFunctionArgs) {\n return fetch(request, {\n headers: {\n \"Accept\": \"application/json\",\n },\n }).then(res => res.json());\n}\n\n// Generic action that forwards on requests for that page\nasync function clientAction({ request }: ActionFunctionArgs) {\n const response = await fetch(request);\n if (response.status === 302) {\n // somehow do a redirect\n }\n // if the response is json content type, parse the json and return it\n if (response.headers.get(\"Content-Type\")?.includes(\"application/json\")) {\n return response.json();\n }\n return response;\n}\n\nfunction createFullstackLoader(loaderSourceImportURL: string) {\n if (isClient) {\n return clientLoader;\n } else {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(loaderSourceImportURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n}\n\nfunction createFullstackAction(actionSourceImportURL: string) {\n if (isClient) {\n return clientAction;\n } else {\n return async (args: ActionFunctionArgs) => {\n let module = await import(actionSourceImportURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: createFullstackAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: createFullstackLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"delete-all\",\n action: createFullstackAction(\"../routes/DeleteAll.action.ts\"),\n },\n {\n path: \"topics/:topicId\",\n Component: Topic,\n loader: createFullstackLoader(\"../routes/Topic.loader.ts\"),\n action: createFullstackAction(\"../routes/Topic.action.ts\"),\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n Component: Topic,\n loader: createFullstackLoader(\"../routes/TopicMessage.loader.ts\"),\n },\n {\n path: \"search\",\n Component: Search,\n loader: createFullstackLoader(\"../routes/Search.loader.ts\"),\n },\n ],\n },\n];",[],[118,135],"2aadcab0-1645-11f0-b5a9-569c3dd06744","routes","d1dce86a-a6c7-4eab-acfb-7879f79eee39",["D",1744314677289],[148,149,150,151,152,153,154,155,156,157,158],[143],{"_37":230,"_13":231,"_67":232,"_69":144,"_71":72,"_73":74,"_75":76,"_44":233,"_17":78,"_79":130,"_80":234,"_82":58,"_83":-5,"_98":235,"_18":236},{"_37":223,"_13":224,"_67":225,"_69":144,"_71":72,"_73":113,"_75":76,"_44":226,"_17":78,"_79":130,"_80":227,"_82":58,"_83":-5,"_98":228,"_18":229},{"_37":216,"_13":217,"_67":218,"_69":144,"_71":72,"_73":74,"_75":76,"_44":219,"_17":78,"_79":130,"_80":220,"_82":58,"_83":-5,"_98":221,"_18":222},{"_37":208,"_13":209,"_67":210,"_69":144,"_71":72,"_73":211,"_75":76,"_44":212,"_17":74,"_79":130,"_80":213,"_82":58,"_83":-5,"_98":214,"_18":215},{"_37":201,"_13":202,"_67":203,"_69":144,"_71":72,"_73":74,"_75":76,"_44":204,"_17":78,"_79":130,"_80":205,"_82":58,"_83":-5,"_98":206,"_18":207},{"_37":194,"_13":195,"_67":196,"_69":144,"_71":72,"_73":74,"_75":76,"_44":197,"_17":78,"_79":130,"_80":198,"_82":58,"_83":-5,"_98":199,"_18":200},{"_37":187,"_13":188,"_67":189,"_69":144,"_71":72,"_73":74,"_75":76,"_44":190,"_17":78,"_79":130,"_80":191,"_82":58,"_83":-5,"_98":192,"_18":193},{"_37":180,"_13":181,"_67":182,"_69":144,"_71":72,"_73":74,"_75":76,"_44":183,"_17":78,"_79":130,"_80":184,"_82":58,"_83":-5,"_98":185,"_18":186},{"_37":173,"_13":174,"_67":175,"_69":144,"_71":72,"_73":74,"_75":76,"_44":176,"_17":78,"_79":130,"_80":177,"_82":58,"_83":-5,"_98":178,"_18":179},{"_37":166,"_13":167,"_67":168,"_69":144,"_71":72,"_73":74,"_75":76,"_44":169,"_17":78,"_79":130,"_80":170,"_82":58,"_83":-5,"_98":171,"_18":172},{"_37":159,"_13":160,"_67":161,"_69":144,"_71":72,"_73":74,"_75":76,"_44":162,"_17":78,"_79":130,"_80":163,"_82":58,"_83":-5,"_98":164,"_18":165},"2aadc920-1645-11f0-b5a9-569c3dd06744","Topics.action.ts","71651c84-ce4f-45f2-891e-0e46184a8430",["D",1744314677289],"import { ActionFunctionArgs, redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createTopic } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const title = formData.get(\"title\") as string;\n\n if (!title || title.trim() === \"\") {\n throw new Response(\"Title is required\", { status: 400 });\n }\n\n const topic = await createTopic(title);\n return redirect(`/topics/${topic.id}`);\n}",[],[143,160],"2aadc7b8-1645-11f0-b5a9-569c3dd06744","TopicMessage.loader.ts","321e0aac-461c-4753-8109-97e0cfda4b8f",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessageById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const messageId = parseInt(params.messageId!, 10);\n\n const topic = await getTopicById(topicId);\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const message = await getMessageById(messageId);\n if (!message || message.topicId !== topicId) {\n throw new Response(\"Message not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[143,167],"2aadc560-1645-11f0-b5a9-569c3dd06744","Topic.tsx","d3e23910-e9ee-497a-a707-19f58864d0ab",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData, useParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Message, Topic } from \"../shared/types.ts\";\nimport { MessageForm } from \"../frontend/components/MessageForm.tsx\";\nimport { MessageList } from \"../frontend/components/MessageList.tsx\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\ninterface TopicDetailData {\n topic: Topic;\n messages: Message[];\n}\n\nexport function Topic() {\n const { topic, messages } = useLoaderData() as TopicDetailData;\n const { messageId } = useParams();\n const highlightedMessageId = messageId ? parseInt(messageId, 10) : undefined;\n \n // Scroll to highlighted message if messageId is provided\n useEffect(() => {\n if (highlightedMessageId) {\n const messageElement = document.getElementById(`message-${highlightedMessageId}`);\n if (messageElement) {\n messageElement.scrollIntoView({ behavior: \"smooth\", block: \"center\" });\n }\n }\n }, [highlightedMessageId]);\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

{topic.title}

\n Created {new Date(topic.createdAt).toDateString()}\n

\n \n

Messages

\n \n \n \n \n

\n );\n}",[],[143,174],"2aadc416-1645-11f0-b5a9-569c3dd06744","Topic.loader.ts","49dc9b30-8f7a-43c9-80bc-72da05a4cf87",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const topic = await getTopicById(topicId);\n\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[143,181],"2aadc268-1645-11f0-b5a9-569c3dd06744","Topic.action.ts","73fdb20b-448c-4b9e-ac48-57aad1415049",["D",1744314677289],"import { ActionFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createMessage } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n console.log(\"HERE!\");\n const formData = await request.formData();\n const topicId = parseInt(formData.get(\"topicId\") as string, 10);\n const content = formData.get(\"content\") as string;\n\n if (!content || content.trim() === \"\") {\n throw new Response(\"Content is required\", { status: 400 });\n }\n\n const message = await createMessage(topicId, content);\n return message;\n}",[],[143,188],"2aadbf70-1645-11f0-b5a9-569c3dd06744","Search.tsx","e4076c07-7ec1-4d0f-b4f7-cd2f465ef5b1",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../shared/types.ts\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\nexport function Search() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

\n Search Results for \"{query}\"\n

\n \n {!hasResults ? (\n

\n No results found for \"{query}\". Try a different search term.\n

\n ) : (\n

\n {topics.length > 0 && (\n

Topics ({topics.length})

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n \n {messages.length > 0 && (\n

Messages ({messages.length})

\n {messages.map((message) => (\n

{message.content}

\n \n View in topic\n \n \n {new Date(message.createdAt).toDateString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[143,195],"2aadbda4-1645-11f0-b5a9-569c3dd06744","Search.loader.ts","f29bd6bb-760c-4a1a-8561-25a4726b3602",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { search } from \"../backend/database/queries.ts\";\n\nexport async function loader({ request }: LoaderFunctionArgs) {\n const url = new URL(request.url);\n const query = url.searchParams.get(\"q\") || \"\";\n\n if (!query || query.trim() === \"\") {\n return { topics: [], messages: [], query: \"\" };\n }\n\n return await search(query);\n}",[],[143,202],"55f31a0e-1645-11f0-abf8-569c3dd06744","Home.tsx","8239b451-63d6-4090-b0ca-17a2256a913b",5,["D",1744314749895],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n Link,\n useLoaderData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\nimport { Topic } from \"../shared/types.ts\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function Home() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/\" && navigation.state === \"submitting\";\n const isDeletingAll = navigation.formAction === \"/delete-all\" && navigation.state === \"submitting\";\n let $form = React.useRef(null);\n let $deleteForm = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n const handleDeleteAll = (e: React.FormEvent) => {\n if (!confirm(\"Are you sure you want to delete ALL topics and messages? This action cannot be undone.\")) {\n e.preventDefault();\n }\n };\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

Create a New Topic

\n \n

\n\n

Topics

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

\n No topics yet. Create the first one!\n

\n )\n : (\n

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n

\n );\n}",[],[143,209],"2aadb7f0-1645-11f0-b5a9-569c3dd06744","Home.loader.ts","8555734a-58d5-4f7e-986c-af499c1fdc1c",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getAllTopics } from \"../backend/database/queries.ts\";\n\nexport async function loader() {\n return { topics: await getAllTopics() };\n}",[],[143,217],"4245ba0c-1645-11f0-9ca3-569c3dd06744","DeleteAll.action.ts","4245ba98-1645-11f0-9ca3-569c3dd06744",["D",1744314716884],"import { ActionFunctionArgs, redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { deleteAllTopicsAndMessages } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const confirmation = formData.get(\"confirmation\") as string;\n\n if (confirmation !== \"delete-all\") {\n throw new Response(\"Invalid confirmation\", { status: 400 });\n }\n\n await deleteAllTopicsAndMessages();\n \n // Redirect back to the home page\n return redirect(\"/\");\n}",[],[143,224],"2aadb61a-1645-11f0-b5a9-569c3dd06744","App.tsx","67b4bdd8-663f-4012-b9e6-ba3a5e8f159b",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"../frontend/components/LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n \n

\n\n \n

\n );\n}",[],[143,231],"2aadb46c-1645-11f0-b5a9-569c3dd06744",["D",1744314677289],[241,242,243],[85],{"_37":254,"_13":255,"_67":256,"_69":70,"_71":72,"_73":74,"_75":76,"_44":257,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":258,"_18":259},{"_37":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_44":251,"_17":78,"_79":24,"_80":81,"_82":58,"_83":-5,"_98":252,"_18":253},{"_37":244,"_13":245,"_67":246,"_69":70,"_71":72,"_73":74,"_75":76,"_44":247,"_17":78,"_79":130,"_80":248,"_82":58,"_83":-5,"_98":249,"_18":250},"2aadb0ac-1645-11f0-b5a9-569c3dd06744","index.tsx","87c07d8e-b7d6-4a4d-bb66-9a5d4cccfe4f",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n RouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { routes } from \"../shared/routes.ts\";\n\n// Create a browser router with the same routes as the server\n// but using the hydration data from the server render\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n hydrationData: window.__staticRouterHydrationData,\n },\n);\n\n// Hydrate the app\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);",[],[85,245],["D",1744314677289],[],[85,66],"2aadad5a-1645-11f0-b5a9-569c3dd06744","components","f41330df-a184-42ca-acfd-b06f5891cb32",["D",1744314677289],[260,261,262,263,264,265,266],[85,255],{"_37":309,"_13":231,"_67":310,"_69":256,"_71":72,"_73":74,"_75":76,"_44":311,"_17":78,"_79":130,"_80":312,"_82":58,"_83":-5,"_98":313,"_18":314},{"_37":302,"_13":303,"_67":304,"_69":256,"_71":72,"_73":74,"_75":76,"_44":305,"_17":78,"_79":130,"_80":306,"_82":58,"_83":-5,"_98":307,"_18":308},{"_37":295,"_13":296,"_67":297,"_69":256,"_71":72,"_73":74,"_75":76,"_44":298,"_17":78,"_79":130,"_80":299,"_82":58,"_83":-5,"_98":300,"_18":301},{"_37":288,"_13":289,"_67":290,"_69":256,"_71":72,"_73":74,"_75":76,"_44":291,"_17":78,"_79":130,"_80":292,"_82":58,"_83":-5,"_98":293,"_18":294},{"_37":281,"_13":282,"_67":283,"_69":256,"_71":72,"_73":74,"_75":76,"_44":284,"_17":78,"_79":130,"_80":285,"_82":58,"_83":-5,"_98":286,"_18":287},{"_37":274,"_13":275,"_67":276,"_69":256,"_71":72,"_73":74,"_75":76,"_44":277,"_17":78,"_79":130,"_80":278,"_82":58,"_83":-5,"_98":279,"_18":280},{"_37":267,"_13":268,"_67":269,"_69":256,"_71":72,"_73":74,"_75":76,"_44":270,"_17":78,"_79":130,"_80":271,"_82":58,"_83":-5,"_98":272,"_18":273},"2aadaabc-1645-11f0-b5a9-569c3dd06744","TopicDetail.tsx","b9b00b4e-7e76-4eb2-9d69-09fdd602917c",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link, useLoaderData, useParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Message, Topic } from \"../../shared/types.ts\";\nimport { MessageForm } from \"./MessageForm.tsx\";\nimport { MessageList } from \"./MessageList.tsx\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\ninterface TopicDetailData {\n topic: Topic;\n messages: Message[];\n}\n\nexport function TopicDetail() {\n const { topic, messages } = useLoaderData() as TopicDetailData;\n const { messageId } = useParams();\n const highlightedMessageId = messageId ? parseInt(messageId, 10) : undefined;\n\n // Scroll to highlighted message if messageId is provided\n useEffect(() => {\n if (highlightedMessageId) {\n const messageElement = document.getElementById(`message-${highlightedMessageId}`);\n if (messageElement) {\n messageElement.scrollIntoView({ behavior: \"smooth\", block: \"center\" });\n }\n }\n }, [highlightedMessageId]);\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

{topic.title}

\n Created {new Date(topic.createdAt).toDateString()}\n

\n\n

Messages

\n\n \n\n \n

\n );\n}",[],[85,255,268],"2aada774-1645-11f0-b5a9-569c3dd06744","SearchResults.tsx","c592b738-4ea2-44c4-97cc-2d10a4fdd267",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../../shared/types.ts\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\nexport function SearchResults() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

\n Search Results for \"{query}\"\n

\n \n {!hasResults ? (\n

\n No results found for \"{query}\". Try a different search term.\n

\n ) : (\n

\n {topics.length > 0 && (\n

Topics ({topics.length})

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n \n {messages.length > 0 && (\n

Messages ({messages.length})

\n {messages.map((message) => (\n

{message.content}

\n \n View in topic\n \n \n {new Date(message.createdAt).toDateString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[85,255,275],"2aada5f8-1645-11f0-b5a9-569c3dd06744","SearchForm.tsx","0a0dd767-1aa6-4786-9d68-2c175268ec8f",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Form, useNavigation, useSearchParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function SearchForm() {\n const navigation = useNavigation();\n const [searchParams] = useSearchParams();\n const query = searchParams.get(\"q\") || \"\";\n const isSearching = navigation.state === \"loading\" && navigation.location.pathname === \"/search\";\n \n return (\n \n );\n}",[],[85,255,282],"2aada3fa-1645-11f0-b5a9-569c3dd06744","MessageList.tsx","8a230f6e-d323-4710-ae6c-aa295041257a",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link, useLocation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Message } from \"../../shared/types.ts\";\n\ninterface MessageListProps {\n messages: Message[];\n topicId: number;\n highlightedMessageId?: number;\n}\n\nexport function MessageList({ messages, topicId, highlightedMessageId }: MessageListProps) {\n const location = useLocation();\n\n if (messages.length === 0) {\n return (\n

\n No messages yet. Be the first to post!\n

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

\n {messages.map((message) => {\n const isHighlighted = message.id === highlightedMessageId;\n const formattedDate = new Date(message.createdAt).toDateString();\n const messageUrl = `/topics/${topicId}/messages/${message.id}`;\n\n return (\n \n

{message.content}

\n \n {formattedDate}\n \n

\n );\n })}\n \n );\n}",[],[85,255,289],"2aada166-1645-11f0-b5a9-569c3dd06744","MessageForm.tsx","7f905bdc-2fd9-4c56-96be-bdef68b02ee7",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n useActionData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\ninterface MessageFormProps {\n topicId: number;\n}\n\nexport function MessageForm({ topicId }: MessageFormProps) {\n const navigation = useNavigation();\n const isSubmitting = navigation.state === \"submitting\";\n let $form = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n return (\n

Post a Message

\n \n

\n );\n}",[],[85,255,296],"2aad9ffe-1645-11f0-b5a9-569c3dd06744","LoadingSpinner.tsx","733a0e72-f8fc-427d-987d-8deb9e032e62",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface LoadingSpinnerProps {\n size?: \"small\" | \"medium\" | \"large\";\n}\n\nexport function LoadingSpinner({ size = \"medium\" }: LoadingSpinnerProps) {\n const sizeClasses = {\n small: \"w-4 h-4 border-2\",\n medium: \"w-8 h-8 border-3\",\n large: \"w-12 h-12 border-4\"\n };\n\n return (\n

\n );\n}",[],[85,255,303],"2aad9e8c-1645-11f0-b5a9-569c3dd06744","01bfe0c0-afc9-4a0f-9d29-56a7b7f0fb17",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n {isLoading && (\n

\n \n

\n )}\n\n \n\n \n

\n );\n}",[],[85,255,231],"2aad9cd4-1645-11f0-b5a9-569c3dd06744","backend","1b868510-caaf-4363-a44f-4931a73e0131",["D",1744314677289],[321,322],[316],{"_37":331,"_13":332,"_67":333,"_69":317,"_71":72,"_73":74,"_75":76,"_44":334,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":335,"_18":336},{"_37":323,"_13":324,"_67":325,"_69":317,"_71":72,"_73":74,"_75":76,"_44":326,"_17":78,"_79":327,"_80":328,"_82":58,"_83":-5,"_98":329,"_18":330},"2aad95e0-1645-11f0-b5a9-569c3dd06744","index.ts","3421c26d-7bba-42d0-aff7-e5aa65c56604",["D",1744314677289],"http","import { Hono } from \"https://esm.sh/hono@4.1.0\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport {\n createStaticHandler,\n createStaticRouter,\n StaticRouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { routes } from \"../shared/routes.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the Hono app\nconst app = new Hono();\n\n// Serve static files from the frontend directory\napp.get(\"/frontend/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// Serve static files from the shared directory\napp.get(\"/shared/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// Serve static files from the routes directory\napp.get(\"/routes/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// LoaderData returns a map of loaderDatas for all matched loaders by an internal\n// id representation that looks like \"0-0\" and \"0-1\"\n// Some context: https://github.com/remix-run/react-router/blob/a3e4b8ed875611637357647fcf862c2bc61f4e11/packages/react-router/lib/hooks.tsx#L1093\n// This function combines all loader datas into a single object, which isn't technically correct, but might get us\n// pretty far.\n// Ultimately what we want is to only make one loader call for a new page navigation and then set the `state`\n// all at once with this exact object, and then have react router take care of sending the apprioriate state\n// to all the useLoaderDatas\nfunction parseData(data: any) {\n const entries = Object.values(data)\n .filter(Boolean)\n .flatMap((value: any) => Object.entries(value));\n return Object.fromEntries(entries);\n}\n\n// Create a static handler for server-side rendering\nconst { query, dataRoutes } = createStaticHandler(routes);\n\n// Handle all other routes with React Router\napp.all(\"*\", async (c) => {\n // Get the routing context by running loaders/actions\n const context = await query(c.req.raw);\n\n // If the context is a Response, return it directly (e.g., redirects)\n if (context instanceof Response) {\n return context;\n }\n console.log(context);\n\n if (\n c.req.header(\"Accept\") === \"application/json\"\n ) {\n // in theory we should use `queryRoute` for this, like here:\n // https://github.com/remix-run/custom-react-router-framework-example/blob/f5a141d67800e8da076cd1bb3130f29a8c0d4ce3/entry.server.tsx#L79\n // but i wasn't able to get that to work in my rewrite-server branch\n // maybe it depends on X-Route-Id?\n return Response.json(parseData(context.loaderData));\n } else if (c.req.header(\"Content-Type\")?.includes(\"application/x-www-form-urlencoded\"))\n {\n return Response.json(parseData(context.actionData));\n }\n // Create a static router for server-side rendering\n const router = createStaticRouter(dataRoutes, context);\n\n // Read the HTML template\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Render the app to a string\n const appHtml = renderToString(\n React.createElement(StaticRouterProvider, {\n router,\n context,\n }),\n );\n\n // Insert the rendered app and hydration data into the HTML template\n html = html.replace(\n \"

\",\n `

${appHtml}

`,\n );\n\n // Return the HTML with the appropriate headers\n return c.html(html);\n});\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Export the app for HTTP vals\nexport default app.fetch;",[],[316,324],"2aad9464-1645-11f0-b5a9-569c3dd06744","database","b0b81f2f-b947-47cf-971a-1326e470e890",["D",1744314677289],[337,338],[316,332],{"_37":347,"_13":348,"_67":349,"_69":333,"_71":72,"_73":74,"_75":76,"_44":350,"_17":78,"_79":130,"_80":351,"_82":58,"_83":-5,"_98":352,"_18":353},{"_37":339,"_13":340,"_67":341,"_69":333,"_71":72,"_73":342,"_75":76,"_44":343,"_17":74,"_79":130,"_80":344,"_82":58,"_83":-5,"_98":345,"_18":346},"3f904c78-1645-11f0-89e7-569c3dd06744","queries.ts","8590525f-81a5-4d71-b0b6-685aa174343f",2,["D",1744314712334],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Message, SearchResults, Topic } from \"../../shared/types.ts\";\nimport { MESSAGES_TABLE, TOPICS_TABLE } from \"./migrations.ts\";\n\n/**\n * Delete all topics and messages from the database\n */\nexport async function deleteAllTopicsAndMessages(): Promise<{ success: boolean }> {\n try {\n // Delete all messages first (due to foreign key constraints)\n await sqlite.execute(`DELETE FROM ${MESSAGES_TABLE}`);\n \n // Then delete all topics\n await sqlite.execute(`DELETE FROM ${TOPICS_TABLE}`);\n \n return { success: true };\n } catch (error) {\n console.error(\"Error deleting all topics and messages:\", error);\n return { success: false };\n }\n}\n\n/**\n * Get all topics ordered by creation date (newest first)\n */\nexport async function getAllTopics(): Promise {\n const result = await sqlite.execute(`\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n ORDER BY createdAt DESC\n `);\n return result.rows as Topic[];\n}\n\n/**\n * Get a single topic by ID\n */\nexport async function getTopicById(id: number): Promise {\n const result = await sqlite.execute(\n `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE id = ?\n `,\n [id],\n );\n\n return result.rows.length > 0 ? (result.rows[0] as Topic) : null;\n}\n\n/**\n * Create a new topic\n */\nexport async function createTopic(title: string): Promise {\n const createdAt = new Date().toISOString();\n\n const result = await sqlite.execute(\n `\n INSERT INTO ${TOPICS_TABLE} (title, createdAt)\n VALUES (?, ?)\n RETURNING id, title, createdAt\n `,\n [title, createdAt],\n );\n\n return result.rows[0] as Topic;\n}\n\n/**\n * Get all messages for a topic\n */\nexport async function getMessagesByTopicId(topicId: number): Promise {\n const result = await sqlite.execute(\n `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE topicId = ? \n ORDER BY createdAt ASC\n `,\n [topicId],\n );\n\n return result.rows as Message[];\n}\n\n/**\n * Get a single message by ID\n */\nexport async function getMessageById(id: number): Promise {\n const result = await sqlite.execute(\n `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE id = ?\n `,\n [id],\n );\n\n return result.rows.length > 0 ? (result.rows[0] as Message) : null;\n}\n\n/**\n * Create a new message in a topic\n */\nexport async function createMessage(topicId: number, content: string): Promise {\n const createdAt = new Date().toISOString();\n\n const result = await sqlite.execute(\n `\n INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt)\n VALUES (?, ?, ?)\n RETURNING id, topicId, content, createdAt\n `,\n [topicId, content, createdAt],\n );\n\n return result.rows[0] as Message;\n}\n\n/**\n * Search for topics and messages containing the query string\n */\nexport async function search(query: string): Promise {\n // Search in topics\n const topicsResult = await sqlite.execute(\n `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE title LIKE ? \n ORDER BY createdAt DESC\n `,\n [`%${query}%`],\n );\n\n // Search in messages\n const messagesResult = await sqlite.execute(\n `\n SELECT m.id, m.topicId, m.content, m.createdAt \n FROM ${MESSAGES_TABLE} m\n JOIN ${TOPICS_TABLE} t ON m.topicId = t.id\n WHERE m.content LIKE ? \n ORDER BY m.createdAt DESC\n `,\n [`%${query}%`],\n );\n\n return {\n topics: topicsResult.rows as Topic[],\n messages: messagesResult.rows as Message[],\n query,\n };\n}",[],[316,332,340],"2aad6c5a-1645-11f0-b5a9-569c3dd06744","migrations.ts","14131a22-86ee-46f4-8e29-368bc3bc2f73",["D",1744314677289],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with versioning to allow for schema changes\nexport const TOPICS_TABLE = \"message_board_topics_v1\";\nexport const MESSAGES_TABLE = \"message_board_messages_v1\";\n\n/**\n * Initialize the database schema\n */\nexport async function initializeDatabase() {\n // Create topics table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TOPICS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n createdAt TEXT NOT NULL\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n topicId INTEGER NOT NULL,\n content TEXT NOT NULL,\n createdAt TEXT NOT NULL,\n FOREIGN KEY (topicId) REFERENCES ${TOPICS_TABLE}(id)\n )\n `);\n\n // Create indexes for faster queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_messages_topicId \n ON ${MESSAGES_TABLE} (topicId)\n `);\n\n // Seed initial data if the topics table is empty\n const existingTopics = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TOPICS_TABLE}`);\n \n if (existingTopics.rows[0].count === 0) {\n await seedInitialData();\n }\n}\n\n/**\n * Seed the database with initial data for demonstration\n */\nasync function seedInitialData() {\n // Insert sample topics\n await sqlite.execute(`\n INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES\n ('Welcome to the Message Board', '${new Date().toISOString()}'),\n ('Tips and Tricks for Val Town', '${new Date().toISOString()}'),\n ('Introduce Yourself', '${new Date().toISOString()}')\n `);\n\n // Get the IDs of the inserted topics\n const topics = await sqlite.execute(`SELECT id FROM ${TOPICS_TABLE} LIMIT 3`);\n \n // Insert sample messages for each topic\n if (topics.rows.length > 0) {\n const welcomeTopicId = topics.rows[0].id;\n const tipsTopicId = topics.rows[1].id;\n const introTopicId = topics.rows[2].id;\n\n await sqlite.execute(`\n INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES\n (${welcomeTopicId}, 'Welcome to our community message board! Feel free to browse around and join the discussions.', '${new Date().toISOString()}'),\n (${welcomeTopicId}, 'If you have any questions, just post them here!', '${new Date(Date.now() - 3600000).toISOString()}'),\n (${tipsTopicId}, 'Val Town makes it easy to build and share serverless functions.', '${new Date().toISOString()}'),\n (${tipsTopicId}, 'You can use TypeScript for better type safety in your projects.', '${new Date(Date.now() - 7200000).toISOString()}'),\n (${introTopicId}, 'Hi everyone! I\\'m the creator of this message board example.', '${new Date().toISOString()}')\n `);\n }\n}",[],[316,332,348],["D",1744152661331],"legacyEnvVars","httpPrivacy","Full-stack example ReactRouter7 project","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","e315d710-14cd-11f0-a969-569c3dd06744","pinPreview","pinMigrated","screenshotVersion",151,"likeCount","tursoName","f1a22d8a14cb11f0b108569c3dd06744","tursoHostname","f1a22d8a14cb11f0b108569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789558275908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_400":396},"org",{"_11":12,"_394":-5,"_395":396,"_359":360,"_397":398,"_399":58},"branch",{"_17":111,"_13":16,"_37":72,"_49":50,"_52":43,"_53":390,"_391":60,"_392":50,"_393":63,"_64":14,"_61":12},157,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":50,"_13":14,"_44":535,"_56":-5,"_355":58,"_59":60,"_356":60,"_39":357,"_358":-5,"_359":360,"_361":362,"_363":76,"_364":-5,"_365":366,"_367":113,"_62":63,"_368":369,"_370":371,"_372":536,"_374":-5,"_375":376,"_377":376,"_378":379,"_380":379,"_381":379,"_382":376,"_383":376,"_384":537,"_386":538,"_388":539,"_57":58},[433,438,449,461,464,465,466],"files",[433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466],"counts",{"_424":74,"_425":211,"_426":113,"_36":427,"_428":429},[],{"_37":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_44":77,"_17":78,"_79":24,"_80":81,"_82":58,"_83":-5,"_18":423},"upstreamProject","upstreamBranch",{"_37":43,"_44":421,"_46":422,"_13":48,"_49":50,"_17":51,"_52":-5,"_53":-5,"_54":55,"_56":-5,"_57":58,"_59":60,"_61":12,"_62":63,"_64":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744152661331],["D",1771761464050],[85,66],"pulls","branches","forks",{"_430":78,"_432":78},"connections",{"_430":78,"_431":78},"count","unfilledCount","emptyCount",{"_37":315,"_13":316,"_67":317,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":318,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":533,"_18":534},{"_37":331,"_13":332,"_67":333,"_69":317,"_71":72,"_73":74,"_75":76,"_44":334,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":531,"_18":532},{"_37":347,"_13":348,"_67":349,"_69":333,"_71":72,"_73":74,"_75":76,"_44":350,"_17":78,"_79":130,"_80":351,"_82":58,"_83":-5,"_98":529,"_18":530},{"_37":339,"_13":340,"_67":341,"_69":333,"_71":72,"_73":342,"_75":76,"_44":343,"_17":74,"_79":130,"_80":344,"_82":58,"_83":-5,"_98":527,"_18":528},{"_37":323,"_13":324,"_67":325,"_69":317,"_71":72,"_73":74,"_75":76,"_44":326,"_17":78,"_79":327,"_80":328,"_82":58,"_83":-5,"_98":525,"_18":526},{"_37":237,"_13":85,"_67":70,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":238,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":523,"_18":524},{"_37":254,"_13":255,"_67":256,"_69":70,"_71":72,"_73":74,"_75":76,"_44":257,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":521,"_18":522},{"_37":309,"_13":231,"_67":310,"_69":256,"_71":72,"_73":74,"_75":76,"_44":311,"_17":78,"_79":130,"_80":312,"_82":58,"_83":-5,"_98":519,"_18":520},{"_37":302,"_13":303,"_67":304,"_69":256,"_71":72,"_73":74,"_75":76,"_44":305,"_17":78,"_79":130,"_80":306,"_82":58,"_83":-5,"_98":517,"_18":518},{"_37":295,"_13":296,"_67":297,"_69":256,"_71":72,"_73":74,"_75":76,"_44":298,"_17":78,"_79":130,"_80":299,"_82":58,"_83":-5,"_98":515,"_18":516},{"_37":288,"_13":289,"_67":290,"_69":256,"_71":72,"_73":74,"_75":76,"_44":291,"_17":78,"_79":130,"_80":292,"_82":58,"_83":-5,"_98":513,"_18":514},{"_37":281,"_13":282,"_67":283,"_69":256,"_71":72,"_73":74,"_75":76,"_44":284,"_17":78,"_79":130,"_80":285,"_82":58,"_83":-5,"_98":511,"_18":512},{"_37":274,"_13":275,"_67":276,"_69":256,"_71":72,"_73":74,"_75":76,"_44":277,"_17":78,"_79":130,"_80":278,"_82":58,"_83":-5,"_98":509,"_18":510},{"_37":267,"_13":268,"_67":269,"_69":256,"_71":72,"_73":74,"_75":76,"_44":270,"_17":78,"_79":130,"_80":271,"_82":58,"_83":-5,"_98":507,"_18":508},{"_37":65,"_13":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_44":251,"_17":78,"_79":24,"_80":81,"_82":58,"_83":-5,"_98":505,"_18":506},{"_37":244,"_13":245,"_67":246,"_69":70,"_71":72,"_73":74,"_75":76,"_44":247,"_17":78,"_79":130,"_80":248,"_82":58,"_83":-5,"_98":503,"_18":504},{"_37":142,"_13":143,"_67":144,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":145,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":501,"_18":502},{"_37":230,"_13":231,"_67":232,"_69":144,"_71":72,"_73":74,"_75":76,"_44":233,"_17":78,"_79":130,"_80":234,"_82":58,"_83":-5,"_98":499,"_18":500},{"_37":223,"_13":224,"_67":225,"_69":144,"_71":72,"_73":113,"_75":76,"_44":226,"_17":78,"_79":130,"_80":227,"_82":58,"_83":-5,"_98":497,"_18":498},{"_37":216,"_13":217,"_67":218,"_69":144,"_71":72,"_73":74,"_75":76,"_44":219,"_17":78,"_79":130,"_80":220,"_82":58,"_83":-5,"_98":495,"_18":496},{"_37":208,"_13":209,"_67":210,"_69":144,"_71":72,"_73":211,"_75":76,"_44":212,"_17":74,"_79":130,"_80":213,"_82":58,"_83":-5,"_98":493,"_18":494},{"_37":201,"_13":202,"_67":203,"_69":144,"_71":72,"_73":74,"_75":76,"_44":204,"_17":78,"_79":130,"_80":205,"_82":58,"_83":-5,"_98":491,"_18":492},{"_37":194,"_13":195,"_67":196,"_69":144,"_71":72,"_73":74,"_75":76,"_44":197,"_17":78,"_79":130,"_80":198,"_82":58,"_83":-5,"_98":489,"_18":490},{"_37":187,"_13":188,"_67":189,"_69":144,"_71":72,"_73":74,"_75":76,"_44":190,"_17":78,"_79":130,"_80":191,"_82":58,"_83":-5,"_98":487,"_18":488},{"_37":180,"_13":181,"_67":182,"_69":144,"_71":72,"_73":74,"_75":76,"_44":183,"_17":78,"_79":130,"_80":184,"_82":58,"_83":-5,"_98":485,"_18":486},{"_37":173,"_13":174,"_67":175,"_69":144,"_71":72,"_73":74,"_75":76,"_44":176,"_17":78,"_79":130,"_80":177,"_82":58,"_83":-5,"_98":483,"_18":484},{"_37":166,"_13":167,"_67":168,"_69":144,"_71":72,"_73":74,"_75":76,"_44":169,"_17":78,"_79":130,"_80":170,"_82":58,"_83":-5,"_98":481,"_18":482},{"_37":159,"_13":160,"_67":161,"_69":144,"_71":72,"_73":74,"_75":76,"_44":162,"_17":78,"_79":130,"_80":163,"_82":58,"_83":-5,"_98":479,"_18":480},{"_37":117,"_13":118,"_67":119,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":120,"_17":78,"_79":121,"_80":-5,"_82":58,"_83":-5,"_98":477,"_18":478},{"_37":134,"_13":135,"_67":136,"_69":119,"_71":72,"_73":137,"_75":76,"_44":138,"_17":74,"_79":130,"_80":139,"_82":58,"_83":-5,"_98":475,"_18":476},{"_37":126,"_13":127,"_67":128,"_69":119,"_71":72,"_73":74,"_75":76,"_44":129,"_17":78,"_79":130,"_80":131,"_82":58,"_83":-5,"_98":473,"_18":474},{"_37":108,"_13":109,"_67":110,"_69":-5,"_71":72,"_73":111,"_75":76,"_44":112,"_17":113,"_79":24,"_80":114,"_82":58,"_83":-5,"_98":471,"_18":472},{"_37":101,"_13":102,"_67":103,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":104,"_17":78,"_79":24,"_80":105,"_82":58,"_83":-5,"_98":469,"_18":470},{"_37":93,"_13":94,"_67":95,"_69":-5,"_71":72,"_73":74,"_75":76,"_44":96,"_17":78,"_79":24,"_80":97,"_82":58,"_83":-5,"_98":467,"_18":468},[],[94],[],[102],[],[109],[],[118,127],[],[118,135],[462,463],[118],[],[143,160],[],[143,167],[],[143,174],[],[143,181],[],[143,188],[],[143,195],[],[143,202],[],[143,209],[],[143,217],[],[143,224],[],[143,231],[450,451,452,453,454,455,456,457,458,459,460],[143],[],[85,245],[],[85,66],[],[85,255,268],[],[85,255,275],[],[85,255,282],[],[85,255,289],[],[85,255,296],[],[85,255,303],[],[85,255,231],[440,441,442,443,444,445,446],[85,255],[439,447,448],[85],[],[316,324],[],[316,332,340],[],[316,332,348],[435,436],[316,332],[434,437],[316],["D",1744152661331],["D",1789558275908],{"_11":12,"_400":396},{"_11":12,"_394":-5,"_395":396,"_359":360,"_397":398,"_399":58},{"_17":111,"_13":16,"_37":72,"_49":50,"_52":43,"_53":390,"_391":60,"_392":50,"_393":63,"_64":14,"_61":12},"ctx",{"_384":-5,"_418":573,"_574":575,"_576":577,"_578":58,"_579":58,"_580":58,"_581":76,"_582":-5,"_583":-7,"_584":-7,"_585":78,"_586":58,"_587":58,"_588":-5,"_589":58,"_590":58,"_591":58,"_592":-5},"ENV",{"_544":545,"_546":547,"_548":48,"_549":550,"_551":552,"_553":554,"_555":556,"_557":558,"_559":560,"_561":562,"_563":564,"_565":566,"_567":568,"_569":570,"_571":572},"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"]