[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_439":440,"_441":442},"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":126,"_127":25,"_128":129,"_130":60,"_131":-5,"_132":-5,"_133":134},"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",7,"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/Home.loader.ts","latestPath","fileId","cc743363-3789-41da-8d02-b0658fb3a1a2","name","Home.loader.ts","fileType","script","content","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}","import { data, 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 data({ topics: await getAllTopics() });\n}","createdAt",["D",1744285660404],"branchVersion","branchId","0df6df06-15ff-11f0-8fc6-569c3dd06744","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",10,"rewrite-server","projectId","forkedBranchId","f1a26f20-14cb-11f0-b108-569c3dd06744","forkedBranchVersion",84,"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":434,"_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":435,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":436,"_86":437,"_88":438,"_90":25},"tree",[197,202,214,225,228,229],"files",[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,227,228,229],"counts",{"_186":152,"_187":188,"_189":65,"_190":191,"_192":193},"contents",[142,143,144,145,146,147],"upstreamProject","upstreamBranch",{"_44":95,"_39":135,"_136":137,"_32":138,"_93":45,"_13":139,"_94":-5,"_96":-5,"_140":141,"_48":-5,"_90":25,"_50":51,"_102":103,"_66":67,"_101":46},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744152661331],"updatedAt",["D",1771761464050],"main",178,"lockfileKey","1771761466206-esm.town_v_stevekrouse_reactRouter7Example@178-main",{"_44":181,"_32":182,"_30":183,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":184,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_27":185},{"_44":176,"_32":177,"_30":178,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":179,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_27":180},{"_44":171,"_32":172,"_30":173,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":174,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_27":175},{"_44":165,"_32":166,"_30":167,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":168,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_27":170},{"_44":159,"_32":160,"_30":161,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":162,"_13":155,"_34":20,"_36":163,"_24":25,"_157":-5,"_27":164},{"_44":148,"_32":149,"_30":150,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":154,"_13":155,"_34":20,"_36":156,"_24":25,"_157":-5,"_27":158},"0dfb147c-15ff-11f0-8464-569c3dd06744","TODO.md","d000c49a-5346-48cb-9efb-23a23336443c","parentId",1,"latest",["D",1744284564372],0,"- [ ] When you submit a new message board thing, it doesn't redirect to that newly created thing after it's done. It just shows a lame empty page.\n- [ ] 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- [ ] Sometimes when you hit the back button, you get the JSON representation of the page, ie its loader. That's weird! I wonder if I can get a solid repro of that.\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?","label",[149],"0dfaf24e-15ff-11f0-8464-569c3dd06744","README.md","d3009e84-5e6a-46a7-906c-a5787afc7421",["D",1744284564372],"# 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- `/topics/new` - 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## Getting Started\n\n1. Clone the repository\n2. Run the application with `deno run -A backend/index.ts`\n3. Visit `http://localhost:3000` in your browser\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.",[160],"0dfaf0dc-15ff-11f0-8464-569c3dd06744","shared","c6a1db02-fc07-4d85-aa6d-82c34c1a0361",["D",1744284564372],"directory",[166],"0dfaea88-15ff-11f0-8464-569c3dd06744","routes","2c535eba-6784-48c5-a5cf-65c8208c0d9a",["D",1744284564372],[172],"0dfad372-15ff-11f0-8464-569c3dd06744","frontend","4da763eb-2fc2-4086-b67a-439bf27fdfff",["D",1744284564372],[177],"0dfa9ce0-15ff-11f0-8464-569c3dd06744","backend","31dfe576-1b7a-4959-8de1-b093a853993d",["D",1744284564372],[182],"pulls","branches",5,"forks","envVars",{"_194":155,"_196":155},"connections",{"_194":155,"_195":155},"count","unfilledCount","emptyCount",{"_44":181,"_32":182,"_30":183,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":431,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":432,"_27":433},{"_44":427,"_32":419,"_30":414,"_151":183,"_42":43,"_41":152,"_153":60,"_39":428,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":429,"_27":430},{"_44":420,"_32":421,"_30":422,"_151":414,"_42":43,"_41":152,"_153":60,"_39":423,"_13":155,"_34":35,"_36":424,"_24":25,"_157":-5,"_231":425,"_27":426},{"_44":411,"_32":412,"_30":413,"_151":414,"_42":43,"_41":152,"_153":60,"_39":415,"_13":155,"_34":35,"_36":416,"_24":25,"_157":-5,"_231":417,"_27":418},{"_44":402,"_32":403,"_30":404,"_151":183,"_42":43,"_41":405,"_153":25,"_39":406,"_13":188,"_34":407,"_36":408,"_24":25,"_157":-5,"_231":409,"_27":410},{"_44":176,"_32":177,"_30":178,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":399,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":400,"_27":401},{"_44":395,"_32":346,"_30":341,"_151":178,"_42":43,"_41":152,"_153":60,"_39":396,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":397,"_27":398},{"_44":389,"_32":315,"_30":390,"_151":341,"_42":43,"_41":152,"_153":60,"_39":391,"_13":155,"_34":35,"_36":392,"_24":25,"_157":-5,"_231":393,"_27":394},{"_44":382,"_32":383,"_30":384,"_151":341,"_42":43,"_41":152,"_153":60,"_39":385,"_13":155,"_34":35,"_36":386,"_24":25,"_157":-5,"_231":387,"_27":388},{"_44":375,"_32":376,"_30":377,"_151":341,"_42":43,"_41":152,"_153":60,"_39":378,"_13":155,"_34":35,"_36":379,"_24":25,"_157":-5,"_231":380,"_27":381},{"_44":368,"_32":369,"_30":370,"_151":341,"_42":43,"_41":152,"_153":60,"_39":371,"_13":155,"_34":35,"_36":372,"_24":25,"_157":-5,"_231":373,"_27":374},{"_44":361,"_32":362,"_30":363,"_151":341,"_42":43,"_41":152,"_153":60,"_39":364,"_13":155,"_34":35,"_36":365,"_24":25,"_157":-5,"_231":366,"_27":367},{"_44":354,"_32":355,"_30":356,"_151":341,"_42":43,"_41":152,"_153":60,"_39":357,"_13":155,"_34":35,"_36":358,"_24":25,"_157":-5,"_231":359,"_27":360},{"_44":347,"_32":348,"_30":349,"_151":341,"_42":43,"_41":152,"_153":60,"_39":350,"_13":155,"_34":35,"_36":351,"_24":25,"_157":-5,"_231":352,"_27":353},{"_44":338,"_32":339,"_30":340,"_151":341,"_42":43,"_41":152,"_153":60,"_39":342,"_13":155,"_34":35,"_36":343,"_24":25,"_157":-5,"_231":344,"_27":345},{"_44":331,"_32":332,"_30":333,"_151":178,"_42":43,"_41":152,"_153":60,"_39":334,"_13":155,"_34":20,"_36":335,"_24":25,"_157":-5,"_231":336,"_27":337},{"_44":324,"_32":325,"_30":326,"_151":178,"_42":43,"_41":152,"_153":60,"_39":327,"_13":155,"_34":35,"_36":328,"_24":25,"_157":-5,"_231":329,"_27":330},{"_44":171,"_32":172,"_30":173,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":321,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":322,"_27":323},{"_44":314,"_32":315,"_30":316,"_151":173,"_42":43,"_41":152,"_153":60,"_39":317,"_13":155,"_34":35,"_36":318,"_24":25,"_157":-5,"_231":319,"_27":320},{"_44":310,"_32":33,"_30":31,"_151":173,"_42":43,"_41":14,"_153":25,"_39":311,"_13":152,"_34":35,"_36":38,"_24":25,"_157":-5,"_231":312,"_27":313},{"_44":303,"_32":304,"_30":305,"_151":173,"_42":43,"_41":152,"_153":60,"_39":306,"_13":155,"_34":35,"_36":307,"_24":25,"_157":-5,"_231":308,"_27":309},{"_44":296,"_32":297,"_30":298,"_151":173,"_42":43,"_41":152,"_153":60,"_39":299,"_13":155,"_34":35,"_36":300,"_24":25,"_157":-5,"_231":301,"_27":302},{"_44":289,"_32":290,"_30":291,"_151":173,"_42":43,"_41":152,"_153":60,"_39":292,"_13":155,"_34":35,"_36":293,"_24":25,"_157":-5,"_231":294,"_27":295},{"_44":282,"_32":283,"_30":284,"_151":173,"_42":43,"_41":152,"_153":60,"_39":285,"_13":155,"_34":35,"_36":286,"_24":25,"_157":-5,"_231":287,"_27":288},{"_44":275,"_32":276,"_30":277,"_151":173,"_42":43,"_41":152,"_153":60,"_39":278,"_13":155,"_34":35,"_36":279,"_24":25,"_157":-5,"_231":280,"_27":281},{"_44":268,"_32":269,"_30":270,"_151":173,"_42":43,"_41":152,"_153":60,"_39":271,"_13":155,"_34":35,"_36":272,"_24":25,"_157":-5,"_231":273,"_27":274},{"_44":261,"_32":262,"_30":263,"_151":173,"_42":43,"_41":152,"_153":60,"_39":264,"_13":155,"_34":35,"_36":265,"_24":25,"_157":-5,"_231":266,"_27":267},{"_44":254,"_32":255,"_30":256,"_151":173,"_42":43,"_41":152,"_153":60,"_39":257,"_13":155,"_34":35,"_36":258,"_24":25,"_157":-5,"_231":259,"_27":260},{"_44":165,"_32":166,"_30":167,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":251,"_13":155,"_34":169,"_36":-5,"_24":25,"_157":-5,"_231":252,"_27":253},{"_44":244,"_32":245,"_30":246,"_151":167,"_42":43,"_41":152,"_153":60,"_39":247,"_13":155,"_34":35,"_36":248,"_24":25,"_157":-5,"_231":249,"_27":250},{"_44":237,"_32":238,"_30":239,"_151":167,"_42":43,"_41":152,"_153":60,"_39":240,"_13":155,"_34":35,"_36":241,"_24":25,"_157":-5,"_231":242,"_27":243},{"_44":159,"_32":160,"_30":161,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":234,"_13":155,"_34":20,"_36":163,"_24":25,"_157":-5,"_231":235,"_27":236},{"_44":148,"_32":149,"_30":150,"_151":-5,"_42":43,"_41":152,"_153":60,"_39":230,"_13":155,"_34":20,"_36":156,"_24":25,"_157":-5,"_231":232,"_27":233},["D",1744284564372],"children",[],[149],["D",1744284564372],[],[160],"0dfaef2e-15ff-11f0-8464-569c3dd06744","types.ts","f0d28d5e-05ff-44de-8a01-2ddf26652d01",["D",1744284564372],"/**\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}",[],[166,238],"0dfaec36-15ff-11f0-8464-569c3dd06744","routes.ts","7dcf0b05-231b-4f0d-a5e8-42494836de0f",["D",1744284564372],"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\nfunction clientAction({ request }: ActionFunctionArgs) {\n return fetch(request);\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 children: [\n {\n index: true,\n Component: Home,\n loader: createFullstackLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"topics/new\",\n action: createFullstackAction(\"../routes/Topics.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];",[],[166,245],["D",1744284564372],[226,227],[166],"0dfae8ee-15ff-11f0-8464-569c3dd06744","Topics.action.ts","5b18e047-c3cc-410e-950c-9c23ecef1fc4",["D",1744284564372],"import { ActionFunctionArgs } 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 { topic };\n}",[],[172,255],"0dfae682-15ff-11f0-8464-569c3dd06744","TopicMessage.loader.ts","e276afd4-1b7d-4ad7-920a-ba7d8bbe0079",["D",1744284564372],"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}",[],[172,262],"0dfae39e-15ff-11f0-8464-569c3dd06744","Topic.tsx","4c8311a1-ac2e-4ec5-a287-47c0300e9dbe",["D",1744284564372],"/** @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).toLocaleString()}\n

\n \n

Messages

\n \n \n \n \n

\n );\n}",[],[172,269],"0dfae16e-15ff-11f0-8464-569c3dd06744","Topic.loader.ts","84d0da5b-8019-48ba-bf24-e06cec537eef",["D",1744284564372],"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}",[],[172,276],"0dfadfca-15ff-11f0-8464-569c3dd06744","Topic.action.ts","94a427aa-e49b-4ca5-8ca2-2921de46711c",["D",1744284564372],"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 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}",[],[172,283],"0dfadd04-15ff-11f0-8464-569c3dd06744","Search.tsx","518a9902-a1e7-46b0-bba5-2d7f99bad9b8",["D",1744284564372],"/** @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).toLocaleString()}\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).toLocaleString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[172,290],"0dfadba6-15ff-11f0-8464-569c3dd06744","Search.loader.ts","723268ed-f6ad-42cd-9d47-12472c351680",["D",1744284564372],"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}",[],[172,297],"0dfad7d2-15ff-11f0-8464-569c3dd06744","Home.tsx","dbdbac3f-4b57-47ed-ad62-d4b7100b4f52",["D",1744284564372],"/** @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 { Topic } from \"../shared/types.ts\";\nimport { LoadingSpinner } from \"../frontend/components/LoadingSpinner.tsx\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function Home() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/topics/new\" && navigation.state === \"submitting\";\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}",[],[172,304],"9b43915e-1601-11f0-8e3e-569c3dd06744",["D",1744285660404],[],[172,33],"0dfad4d0-15ff-11f0-8464-569c3dd06744","App.tsx","d899cf14-b293-43e8-aa79-9e163305207b",["D",1744284564372],"/** @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 {isLoading && (\n

\n \n

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

\n );\n}",[],[172,315],["D",1744284564372],[215,216,217,218,219,220,221,222,223,224],[172],"0dfad228-15ff-11f0-8464-569c3dd06744","index.tsx","b07424a0-2603-44fb-979c-2d0f026523d4",["D",1744284564372],"/** @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);",[],[177,325],"0dfad03e-15ff-11f0-8464-569c3dd06744","index.html","93e46ad9-5307-47a8-8db9-403e4e875039",["D",1744284564372],"\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[177,332],"0dfacb98-15ff-11f0-8464-569c3dd06744","TopicList.tsx","b0d10a5c-9dc3-4854-9081-079445471502","a03b28b7-1d27-4a70-814b-e822a531240d",["D",1744284564372],"/** @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 { Topic } from \"../../shared/types.ts\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function TopicList() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/topics/new\" && navigation.state === \"submitting\";\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}",[],[177,346,339],"components","0dfac8b4-15ff-11f0-8464-569c3dd06744","TopicDetail.tsx","22fc8cc1-2809-414a-90c3-f4ed7d0514be",["D",1744284564372],"/** @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 \"./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).toLocaleString()}\n

\n \n

Messages

\n \n \n \n \n

\n );\n}",[],[177,346,348],"0dfac4cc-15ff-11f0-8464-569c3dd06744","SearchResults.tsx","c95f57e4-8b09-436c-bfd5-b44c03223cf5",["D",1744284564372],"/** @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).toLocaleString()}\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).toLocaleString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[177,346,355],"0dfac31e-15ff-11f0-8464-569c3dd06744","SearchForm.tsx","f85ff90e-384b-4398-af50-4e15f2ef33ce",["D",1744284564372],"/** @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}",[],[177,346,362],"0dfabef0-15ff-11f0-8464-569c3dd06744","MessageList.tsx","14d40aaa-b94e-41df-a0e7-86f781cf7aeb",["D",1744284564372],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"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 { 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).toLocaleString();\n const messageUrl = `/topics/${topicId}/messages/${message.id}`;\n \n return (\n

{message.content}

\n \n {formattedDate}\n \n

\n );\n })}\n

\n );\n}",[],[177,346,369],"0dfaa3d4-15ff-11f0-8464-569c3dd06744","MessageForm.tsx","740d79a9-aca2-4c3a-9845-221aa09e5acc",["D",1744284564372],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Form, useNavigation } 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\ninterface MessageFormProps {\n topicId: number;\n}\n\nexport function MessageForm({ topicId }: MessageFormProps) {\n const navigation = useNavigation();\n const isSubmitting = navigation.state === \"submitting\";\n \n return (\n

Post a Message

\n \n

\n );\n}",[],[177,346,376],"0dfaa14a-15ff-11f0-8464-569c3dd06744","LoadingSpinner.tsx","6cf36671-983e-4a01-98c6-629ac9cdb0a4",["D",1744284564372],"/** @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}",[],[177,346,383],"0dfa9ee8-15ff-11f0-8464-569c3dd06744","a4d869aa-8812-414f-a7ac-50e3db84f7e9",["D",1744284564372],"/** @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}",[],[177,346,315],"0dfacf08-15ff-11f0-8464-569c3dd06744",["D",1744284564372],[204,205,206,207,208,209,210,211],[177,346],["D",1744284564372],[203,212,213],[177],"905923b2-1601-11f0-a0ef-569c3dd06744","index.ts","c20af5ca-069c-4bdc-9a24-774ab2eeef59",6,["D",1744285642090],"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// seems like .loaderData returns a map of loaderDatas for all matched loaders by an internal\n// loader id representation that looks like \"0-0\" and \"0-1\"\n// Some context: https://github.com/remix-run/react-router/blob/main/packages/react-router/lib/router/router.ts#L923\n// So far, I've only seen there be one real value there, so this function just parses out that one real value.\n// I guess if you have a page within a page, ie two loaders deep, then this would fall over possibly\nfunction parseData(data: any) {\n return Object.values(data).filter(Boolean)[0];\n}\n\nconst { query, dataRoutes, queryRoute } = createStaticHandler(routes);\n// Handle all other routes with React Router\n\napp.all(\"*\", async (c) => {\n if (\n c.req.header(\"Accept\")?.includes(\"application/json\")\n ) {\n // 2. get data from our router, queryRoute knows to call the action or loader\n // of the leaf route that matches\n let data = await queryRoute(c.req.raw);\n console.log(data);\n return c.json(data);\n }\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, return it directly (e.g., redirects)\n if (context instanceof Response) {\n return context;\n }\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;",[],[182,403],"0dfa918c-15ff-11f0-8464-569c3dd06744","queries.ts","fed67a00-f6f6-423c-b2e5-d28a5c36ed27","0f2f1506-7c6a-4b12-9efc-fd71035cb369",["D",1744284564372],"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}",[],[182,419,412],"database","0dfa5942-15ff-11f0-8464-569c3dd06744","migrations.ts","83c29efe-d0fe-44e2-aab1-ecd35d860cdb",["D",1744284564372],"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}",[],[182,419,421],"0dfa9560-15ff-11f0-8464-569c3dd06744",["D",1744284564372],[199,200],[182,419],["D",1744284564372],[198,201],[182],["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,"_132":472,"_473":474,"_475":476,"_477":25,"_478":25,"_479":25,"_480":60,"_481":-5,"_482":-7,"_483":-7,"_484":155,"_485":25,"_486":25,"_487":-5,"_488":25,"_489":25,"_490":25,"_491":-5},"ENV",{"_443":444,"_445":446,"_447":138,"_448":449,"_450":451,"_452":453,"_454":455,"_456":457,"_458":459,"_460":461,"_462":463,"_464":465,"_466":467,"_468":469,"_470":471},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7