[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_426":427,"_428":429},"routes/_app.x.$handle.$name",{"_104":103,"_32":46,"_112":92,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":-5,"_125":-5,"_126":25,"_127":128,"_129":60,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","routes/App.tsx","latestPath","fileId","019c82b3-583b-71ae-9cac-38166350be11","name","App.tsx","fileType","script","content","/** @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}","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.13.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}","createdAt",["D",1771719381992],"branchVersion","branchId","9120f8c0-0f83-11f1-b3bb-42dde27851f2","id","f1a22d8a-14cb-11f0-b108-569c3dd06744","reactRouter7Example",["D",1744152661331],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack example ReactRouter7 project","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","e315d710-14cd-11f0-a969-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion",151,"likeCount",3,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","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",{"_104":103,"_111":107},"org",{"_104":103,"_105":-5,"_106":107,"_18":56,"_108":109,"_110":25},"branch",{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":45,"_100":67,"_101":46,"_102":103},"isOwned",22,"bump-rr7.13","projectId","forkedBranchId","b5ad49ba-0f82-11f1-b885-42dde27851f2","forkedBranchVersion",6,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":421,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":422,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":423,"_86":424,"_88":425,"_90":25},"tree",[195,200,210,221,224,225,226],"files",[195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226],"counts",{"_185":145,"_186":14,"_187":65,"_188":189,"_190":191},"contents",[134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":180,"_32":181,"_30":182,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":183,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_27":184},{"_44":175,"_32":176,"_30":177,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":178,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_27":179},{"_44":170,"_32":171,"_30":172,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":173,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_27":174},{"_44":164,"_32":165,"_30":166,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":167,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_27":169},{"_44":158,"_32":159,"_30":160,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":161,"_13":148,"_34":20,"_36":162,"_24":25,"_150":-5,"_27":163},{"_44":152,"_32":153,"_30":154,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":155,"_13":148,"_34":20,"_36":156,"_24":25,"_150":-5,"_27":157},{"_44":141,"_32":142,"_30":143,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":147,"_13":148,"_34":20,"_36":149,"_24":25,"_150":-5,"_27":151},"912e397c-0f83-11f1-b3bb-42dde27851f2","react-router-questions.md","019c82b3-583b-71ae-9cac-796482c60cda","parentId",1,"latest",["D",1771719317575],0,"# 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\nI'm using react-router 7.5.0, via esm.sh, and react 18.2.0.\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 [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 [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\nI wonder how single fetch gets called: https://github.com/remix-run/react-router/blob/862709d44db19130daa7b5f9dcc0aec8561f3703/packages/react-router/lib/server-runtime/single-fetch.ts\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\nLooks like this is how remix the framework handles it: https://github.com/remix-run/react-router/blob/862709d44db19130daa7b5f9dcc0aec8561f3703/packages/react-router/lib/server-runtime/single-fetch.ts#L70-L80\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?","label",[142],"912e34a4-0f83-11f1-b3bb-42dde27851f2","TODO.md","019c82b3-583b-71ae-9cac-76f61fe2cf56",["D",1771719317575],"- [ ] 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?",[153],"912e1f14-0f83-11f1-b3bb-42dde27851f2","README.md","019c82b3-583b-71ae-9cac-704a99495985",["D",1771719317575],"# 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\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│ ├── 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- `/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.",[159],"912e1a1e-0f83-11f1-b3bb-42dde27851f2","shared","019c82b3-583b-71ae-9cac-6d9e940f5983",["D",1771719317575],"directory",[165],"912e090c-0f83-11f1-b3bb-42dde27851f2","routes","019c82b3-583b-71ae-9cac-6301754bd0ea",["D",1771719317575],[171],"912dbde4-0f83-11f1-b3bb-42dde27851f2","frontend","019c82b3-583b-71ae-9cac-34ea3e5e54bb",["D",1771719317575],[176],"912d6434-0f83-11f1-b3bb-42dde27851f2","backend","019c82b3-583b-71ae-9cac-0ce3711766dd",["D",1771719317575],[181],"pulls","branches","forks","envVars",{"_192":148,"_194":148},"connections",{"_192":148,"_193":148},"count","unfilledCount","emptyCount",{"_44":180,"_32":181,"_30":182,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":418,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":419,"_27":420},{"_44":414,"_32":406,"_30":401,"_144":182,"_42":43,"_41":145,"_146":60,"_39":415,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":416,"_27":417},{"_44":407,"_32":408,"_30":409,"_144":401,"_42":43,"_41":145,"_146":60,"_39":410,"_13":148,"_34":35,"_36":411,"_24":25,"_150":-5,"_228":412,"_27":413},{"_44":398,"_32":399,"_30":400,"_144":401,"_42":43,"_41":145,"_146":60,"_39":402,"_13":148,"_34":35,"_36":403,"_24":25,"_150":-5,"_228":404,"_27":405},{"_44":389,"_32":390,"_30":391,"_144":182,"_42":43,"_41":392,"_146":60,"_39":393,"_13":145,"_34":394,"_36":395,"_24":25,"_150":-5,"_228":396,"_27":397},{"_44":175,"_32":176,"_30":177,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":386,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":387,"_27":388},{"_44":382,"_32":347,"_30":342,"_144":177,"_42":43,"_41":145,"_146":60,"_39":383,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":384,"_27":385},{"_44":376,"_32":33,"_30":377,"_144":342,"_42":43,"_41":145,"_146":25,"_39":378,"_13":148,"_34":35,"_36":379,"_24":25,"_150":-5,"_228":380,"_27":381},{"_44":369,"_32":370,"_30":371,"_144":342,"_42":43,"_41":145,"_146":60,"_39":372,"_13":148,"_34":35,"_36":373,"_24":25,"_150":-5,"_228":374,"_27":375},{"_44":362,"_32":363,"_30":364,"_144":342,"_42":43,"_41":145,"_146":25,"_39":365,"_13":148,"_34":35,"_36":366,"_24":25,"_150":-5,"_228":367,"_27":368},{"_44":355,"_32":356,"_30":357,"_144":342,"_42":43,"_41":145,"_146":25,"_39":358,"_13":148,"_34":35,"_36":359,"_24":25,"_150":-5,"_228":360,"_27":361},{"_44":348,"_32":349,"_30":350,"_144":342,"_42":43,"_41":145,"_146":25,"_39":351,"_13":148,"_34":35,"_36":352,"_24":25,"_150":-5,"_228":353,"_27":354},{"_44":339,"_32":340,"_30":341,"_144":342,"_42":43,"_41":145,"_146":25,"_39":343,"_13":148,"_34":35,"_36":344,"_24":25,"_150":-5,"_228":345,"_27":346},{"_44":332,"_32":333,"_30":334,"_144":177,"_42":43,"_41":145,"_146":60,"_39":335,"_13":148,"_34":20,"_36":336,"_24":25,"_150":-5,"_228":337,"_27":338},{"_44":325,"_32":326,"_30":327,"_144":177,"_42":43,"_41":65,"_146":25,"_39":328,"_13":145,"_34":35,"_36":329,"_24":25,"_150":-5,"_228":330,"_27":331},{"_44":170,"_32":171,"_30":172,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":322,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":323,"_27":324},{"_44":318,"_32":33,"_30":31,"_144":172,"_42":43,"_41":14,"_146":60,"_39":319,"_13":145,"_34":35,"_36":38,"_24":25,"_150":-5,"_228":320,"_27":321},{"_44":311,"_32":312,"_30":313,"_144":172,"_42":43,"_41":145,"_146":25,"_39":314,"_13":148,"_34":35,"_36":315,"_24":25,"_150":-5,"_228":316,"_27":317},{"_44":304,"_32":305,"_30":306,"_144":172,"_42":43,"_41":145,"_146":25,"_39":307,"_13":148,"_34":35,"_36":308,"_24":25,"_150":-5,"_228":309,"_27":310},{"_44":297,"_32":298,"_30":299,"_144":172,"_42":43,"_41":145,"_146":25,"_39":300,"_13":148,"_34":35,"_36":301,"_24":25,"_150":-5,"_228":302,"_27":303},{"_44":290,"_32":291,"_30":292,"_144":172,"_42":43,"_41":145,"_146":25,"_39":293,"_13":148,"_34":35,"_36":294,"_24":25,"_150":-5,"_228":295,"_27":296},{"_44":283,"_32":284,"_30":285,"_144":172,"_42":43,"_41":145,"_146":25,"_39":286,"_13":148,"_34":35,"_36":287,"_24":25,"_150":-5,"_228":288,"_27":289},{"_44":276,"_32":277,"_30":278,"_144":172,"_42":43,"_41":145,"_146":25,"_39":279,"_13":148,"_34":35,"_36":280,"_24":25,"_150":-5,"_228":281,"_27":282},{"_44":269,"_32":270,"_30":271,"_144":172,"_42":43,"_41":145,"_146":25,"_39":272,"_13":148,"_34":35,"_36":273,"_24":25,"_150":-5,"_228":274,"_27":275},{"_44":262,"_32":263,"_30":264,"_144":172,"_42":43,"_41":145,"_146":25,"_39":265,"_13":148,"_34":35,"_36":266,"_24":25,"_150":-5,"_228":267,"_27":268},{"_44":255,"_32":256,"_30":257,"_144":172,"_42":43,"_41":145,"_146":25,"_39":258,"_13":148,"_34":35,"_36":259,"_24":25,"_150":-5,"_228":260,"_27":261},{"_44":164,"_32":165,"_30":166,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":252,"_13":148,"_34":168,"_36":-5,"_24":25,"_150":-5,"_228":253,"_27":254},{"_44":244,"_32":245,"_30":246,"_144":166,"_42":43,"_41":247,"_146":25,"_39":248,"_13":145,"_34":35,"_36":249,"_24":25,"_150":-5,"_228":250,"_27":251},{"_44":237,"_32":238,"_30":239,"_144":166,"_42":43,"_41":145,"_146":60,"_39":240,"_13":148,"_34":35,"_36":241,"_24":25,"_150":-5,"_228":242,"_27":243},{"_44":158,"_32":159,"_30":160,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":234,"_13":148,"_34":20,"_36":162,"_24":25,"_150":-5,"_228":235,"_27":236},{"_44":152,"_32":153,"_30":154,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":231,"_13":148,"_34":20,"_36":156,"_24":25,"_150":-5,"_228":232,"_27":233},{"_44":141,"_32":142,"_30":143,"_144":-5,"_42":43,"_41":145,"_146":60,"_39":227,"_13":148,"_34":20,"_36":149,"_24":25,"_150":-5,"_228":229,"_27":230},["D",1771719317575],"children",[],[142],["D",1771719317575],[],[153],["D",1771719317575],[],[159],"912e169a-0f83-11f1-b3bb-42dde27851f2","types.ts","019c82b3-583b-71ae-9cac-68bd83060c44",["D",1771719317575],"/**\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}",[],[165,238],"af1df558-0f83-11f1-a276-42dde27851f2","routes.ts","019c82b3-583b-71ae-9cac-655597838f1e",2,["D",1771719367813],"import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.13.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\";\n\n// On the server, dynamically import the real loader/action function.\n// On the client, return a no-op stub. The stub's presence signals to\n// React Router that this route needs data (so it appears in dataStrategy's\n// `matches` with shouldLoad=true), but dataStrategy handles the actual\n// fetching via a single HTTP request to the server.\nfunction serverLoader(importURL: string) {\n if (isServer) {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(importURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nfunction serverAction(importURL: string) {\n if (isServer) {\n return async (args: ActionFunctionArgs) => {\n let module = await import(importURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: serverAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: serverLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"topics/:topicId\",\n Component: Topic,\n loader: serverLoader(\"../routes/Topic.loader.ts\"),\n action: serverAction(\"../routes/Topic.action.ts\"),\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n Component: Topic,\n loader: serverLoader(\"../routes/TopicMessage.loader.ts\"),\n },\n {\n path: \"search\",\n Component: Search,\n loader: serverLoader(\"../routes/Search.loader.ts\"),\n },\n ],\n },\n];",[],[165,245],["D",1771719317575],[222,223],[165],"912e02d6-0f83-11f1-b3bb-42dde27851f2","Topics.action.ts","019c82b3-583b-71ae-9cac-5eaee11c4bff",["D",1771719317575],"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}",[],[171,256],"912dfe4e-0f83-11f1-b3bb-42dde27851f2","TopicMessage.loader.ts","019c82b3-583b-71ae-9cac-5a1b97cc6cbf",["D",1771719317575],"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}",[],[171,263],"912df30e-0f83-11f1-b3bb-42dde27851f2","Topic.tsx","019c82b3-583b-71ae-9cac-544d3d88080b",["D",1771719317575],"/** @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}",[],[171,270],"912dee90-0f83-11f1-b3bb-42dde27851f2","Topic.loader.ts","019c82b3-583b-71ae-9cac-52d820d094d0",["D",1771719317575],"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}",[],[171,277],"912de9d6-0f83-11f1-b3bb-42dde27851f2","Topic.action.ts","019c82b3-583b-71ae-9cac-4e2ac6fb8e8b",["D",1771719317575],"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}",[],[171,284],"912ddc34-0f83-11f1-b3bb-42dde27851f2","Search.tsx","019c82b3-583b-71ae-9cac-4aff258d2fdd",["D",1771719317575],"/** @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}",[],[171,291],"912dd838-0f83-11f1-b3bb-42dde27851f2","Search.loader.ts","019c82b3-583b-71ae-9cac-46b17bb536e8",["D",1771719317575],"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}",[],[171,298],"912dc8d4-0f83-11f1-b3bb-42dde27851f2","Home.tsx","019c82b3-583b-71ae-9cac-41a23628529a",["D",1771719317575],"/** @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 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

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}",[],[171,305],"912dc56e-0f83-11f1-b3bb-42dde27851f2","Home.loader.ts","019c82b3-583b-71ae-9cac-3f3c0e852689",["D",1771719317575],"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}",[],[171,312],"b7917d0e-0f83-11f1-a3bc-42dde27851f2",["D",1771719381992],[],[171,33],["D",1771719317575],[211,212,213,214,215,216,217,218,219,220],[171],"b30f5530-0f83-11f1-b19f-42dde27851f2","index.tsx","019c82b3-583b-71ae-9cac-32ee6db01b2e",["D",1771719374433],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n redirect,\n RouterProvider,\n} from \"https://esm.sh/react-router@7.13.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 dataStrategy for single-fetch\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n hydrationData: window.__staticRouterHydrationData,\n\n async dataStrategy({ request, matches }) {\n // Filter to matches that need their handler called\n const matchesToLoad = matches.filter(m => m.shouldLoad);\n\n // If no matches need loading, return empty results\n if (matchesToLoad.length === 0) {\n return {};\n }\n\n console.log(\"[dataStrategy] fetching:\", request.url, \"method:\", request.method);\n console.log(\"[dataStrategy] matchesToLoad:\", matchesToLoad.map(m => m.route.id));\n\n const fetchInit: RequestInit = {\n method: request.method,\n headers: {\n \"X-Data-Request\": \"true\",\n },\n signal: request.signal,\n };\n\n // For non-GET requests (actions), forward the body\n if (request.method !== \"GET\") {\n fetchInit.body = await request.formData();\n }\n\n const res = await fetch(request.url, fetchInit);\n const json = await res.json();\n\n console.log(\"[dataStrategy] response keys:\", Object.keys(json));\n\n // Handle redirects from actions\n // The server sends { redirect: \"/path\" } instead of a 302\n // We throw a redirect() which React Router will catch and navigate to\n if (json.redirect) {\n console.log(\"[dataStrategy] redirect to:\", json.redirect);\n throw redirect(json.redirect);\n }\n\n // Build results keyed by route ID\n // dataStrategy must return Record\n const results: Record = {};\n for (const match of matchesToLoad) {\n const routeId = match.route.id;\n // For actions, prefer actionData; for loaders, use loaderData\n if (json.actionData && json.actionData[routeId] !== undefined && json.actionData[routeId] !== null) {\n results[routeId] = { type: \"data\", result: json.actionData[routeId] };\n } else if (json.loaderData && json.loaderData[routeId] !== undefined) {\n results[routeId] = { type: \"data\", result: json.loaderData[routeId] };\n }\n }\n\n console.log(\"[dataStrategy] returning results for routes:\", Object.keys(results));\n return results;\n },\n },\n);\n\n// Hydrate the app\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);",[],[176,326],"912da4a8-0f83-11f1-b3bb-42dde27851f2","index.html","019c82b3-583b-71ae-9cac-2e78fb0f5acd",["D",1771719317575],"\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[176,333],"912d9166-0f83-11f1-b3bb-42dde27851f2","SearchResults.tsx","019c82b3-583b-71ae-9cac-27ca4603f2eb","019c82b3-583b-71ae-9cac-2835650ea273",["D",1771719317575],"/** @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}",[],[176,347,340],"components","912d8806-0f83-11f1-b3bb-42dde27851f2","SearchForm.tsx","019c82b3-583b-71ae-9cac-20319c0d3da0",["D",1771719317575],"/** @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}",[],[176,347,349],"912d7e56-0f83-11f1-b3bb-42dde27851f2","MessageList.tsx","019c82b3-583b-71ae-9cac-1f515293d8e5",["D",1771719317575],"/** @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}",[],[176,347,356],"912d72ee-0f83-11f1-b3bb-42dde27851f2","MessageForm.tsx","019c82b3-583b-71ae-9cac-180a2e39c211",["D",1771719317575],"/** @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}",[],[176,347,363],"912d6e0c-0f83-11f1-b3bb-42dde27851f2","LoadingSpinner.tsx","019c82b3-583b-71ae-9cac-15e49fc44d10",["D",1771719317575],"/** @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}",[],[176,347,370],"912d65a6-0f83-11f1-b3bb-42dde27851f2","019c82b3-583b-71ae-9cac-10561f576faa",["D",1771719317575],"/** @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}",[],[176,347,33],"912da2be-0f83-11f1-b3bb-42dde27851f2",["D",1771719317575],[202,203,204,205,206,207],[176,347],["D",1771719317575],[201,208,209],[176],"b52d0466-0f83-11f1-b0f4-42dde27851f2","index.ts","019c82b3-583b-71ae-9cac-0b2bc44714f5",4,["D",1771719377978],"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.13.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// 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 const isDataRequest = c.req.header(\"X-Data-Request\") === \"true\";\n\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 (e.g., redirects from actions)\n if (context instanceof Response) {\n if (isDataRequest && context.status >= 300 && context.status < 400) {\n // For data requests, convert redirects to JSON so the client can handle them\n const location = context.headers.get(\"Location\");\n console.log(\"[data-request] redirect to:\", location);\n return Response.json({ redirect: location });\n }\n return context;\n }\n\n // Data-only request: return loaderData/actionData as JSON keyed by route ID\n if (isDataRequest) {\n console.log(\"[data-request] loaderData keys:\", Object.keys(context.loaderData || {}));\n console.log(\"[data-request] actionData keys:\", Object.keys(context.actionData || {}));\n return Response.json({\n loaderData: context.loaderData,\n actionData: context.actionData,\n });\n }\n\n // Full SSR render\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;",[],[181,390],"912d41d4-0f83-11f1-b3bb-42dde27851f2","queries.ts","019c82b3-583b-71ae-9cac-0371b5959f4f","019c82b3-583b-71ae-9cac-060c9565ddfb",["D",1771719317575],"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 * 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}",[],[181,406,399],"database","912d12f4-0f83-11f1-b3bb-42dde27851f2","migrations.ts","019c82b3-583b-71ae-9cab-fe7fe92a3ba1",["D",1771719317575],"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}",[],[181,406,408],"912d519c-0f83-11f1-b3bb-42dde27851f2",["D",1771719317575],[197,198],[181,406],["D",1771719317575],[196,199],[181],["D",1744152661331],["D",1789558275908],{"_104":103,"_111":107},{"_104":103,"_105":-5,"_106":107,"_18":56,"_108":109,"_110":25},{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":45,"_100":67,"_101":46,"_102":103},"ctx",{"_84":-5,"_131":460,"_461":462,"_463":464,"_465":25,"_466":25,"_467":25,"_468":60,"_469":-5,"_470":-7,"_471":-7,"_472":148,"_473":25,"_474":25,"_475":-5,"_476":25,"_477":25,"_478":25,"_479":-5},"ENV",{"_430":431,"_432":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","main","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 · v5