[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_342":343,"_344":345},"routes/_app.x.$handle.$name",{"_102":101,"_33":47,"_110":92,"_28":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":27,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":-5,"_18":57,"_58":59,"_60":25,"_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":27},"version",17,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":34,"_35":39,"_37":38,"_40":41,"_42":14,"_43":44,"_24":27},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",true,"deletedHere",false,"path","backend/index.ts","latestPath","fileId","a38e77c8-14cd-11f0-9bff-569c3dd06744","name","index.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@4.1.0\";\nimport { serveStatic } from \"https://esm.sh/hono@4.1.0/middleware\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport {\n createStaticHandler,\n createStaticRouter,\n StaticRouterProvider,\n} from \"https://esm.sh/react-router-dom@7.5.0/server?deps=react@18.2.0,react-dom@18.2.0\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport {\n getAllTopics,\n getTopicById,\n createTopic,\n getMessagesByTopicId,\n createMessage,\n getMessageById,\n search,\n} from \"./database/queries.ts\";\nimport { App } from \"../frontend/components/App.tsx\";\nimport { TopicList } from \"../frontend/components/TopicList.tsx\";\nimport { TopicDetail } from \"../frontend/components/TopicDetail.tsx\";\nimport { SearchResults } from \"../frontend/components/SearchResults.tsx\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Application error:\", err);\n throw err;\n});\n\n// Define the routes for React Router\nconst routes = [\n {\n path: \"/\",\n element: React.createElement(App),\n children: [\n {\n index: true,\n element: React.createElement(TopicList),\n loader: async () => {\n return { topics: await getAllTopics() };\n },\n },\n {\n path: \"topics/new\",\n action: async ({ request }) => {\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 },\n },\n {\n path: \"topics/:topicId\",\n element: React.createElement(TopicDetail),\n loader: async ({ params }) => {\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 },\n action: async ({ request }) => {\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 },\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n element: React.createElement(TopicDetail),\n loader: async ({ params }) => {\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 },\n },\n {\n path: \"search\",\n element: React.createElement(SearchResults),\n loader: async ({ request }) => {\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 },\n },\n ],\n },\n];\n\n// Serve static files from the frontend directory\napp.get(\"/public/*\", (c) => {\n const path = c.req.path.replace(\"/public\", \"/frontend\");\n return serveFile(path, import.meta.url);\n});\n\n// Handle all other routes with React Router\napp.all(\"*\", async (c) => {\n try {\n // Create a static handler for server-side rendering\n const { query, dataRoutes } = createStaticHandler(routes);\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 \n // Return the HTML with the appropriate headers\n return c.html(html);\n } catch (error) {\n console.error(\"Server rendering error:\", error);\n return c.text(\"Server Error\", 500);\n }\n});\n\n// Start the server\nDeno.serve({ port: 3000 }, app.fetch);\n\n// Export the app for HTTP vals\nexport default app.fetch;","http","createdAt",["D",1744153437517],"branchVersion","branchId","f1a26f20-14cb-11f0-b108-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","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",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":57,"_106":107,"_108":27},"branch",{"_13":91,"_33":92,"_45":44,"_93":46,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":47,"_100":101},"isOwned",178,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_45":46,"_33":47,"_40":337,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":-5,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":338,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":339,"_86":340,"_88":341,"_90":27},"tree",[183,188,200,202,203],"files",[183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203],"counts",{"_173":151,"_174":165,"_175":65,"_176":177,"_178":179},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":168,"_33":169,"_31":170,"_140":-5,"_43":44,"_42":65,"_142":25,"_40":171,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_28":172},{"_45":162,"_33":163,"_31":164,"_140":-5,"_43":44,"_42":165,"_142":25,"_40":166,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_28":167},{"_45":155,"_33":156,"_31":157,"_140":-5,"_43":44,"_42":158,"_142":25,"_40":159,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_28":161},{"_45":148,"_33":149,"_31":150,"_140":-5,"_43":44,"_42":151,"_142":27,"_40":152,"_13":144,"_35":20,"_37":153,"_24":27,"_146":-5,"_28":154},{"_45":137,"_33":138,"_31":139,"_140":-5,"_43":44,"_42":141,"_142":27,"_40":143,"_13":144,"_35":36,"_37":145,"_24":27,"_146":-5,"_28":147},"a6f29ee4-14cd-11f0-a969-569c3dd06744","build.ts","a6f29fac-14cd-11f0-a969-569c3dd06744","parentId",16,"latest",["D",1744153395020],0,"import { fetchTranspiledJavaScript } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// This script compiles the TypeScript files to JavaScript for the frontend\n// It's not strictly necessary for development, but useful for production\n\nasync function build() {\n console.log(\"Building frontend...\");\n \n // Compile the main entry point\n const indexJs = await fetchTranspiledJavaScript(\n `${import.meta.url.replace(\"/build.ts\", \"/frontend/index.tsx\")}`\n );\n \n // Write the compiled JavaScript to a file\n await Deno.writeTextFile(\"./frontend/index.js\", indexJs);\n \n console.log(\"Build complete!\");\n}\n\n// Run the build\nawait build();","label",[138],"513e58ee-14cd-11f0-8f60-569c3dd06744","README.md","513e59ca-14cd-11f0-8f60-569c3dd06744",1,["D",1744153251229],"# 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│ │ ├── App.tsx # Main application component\n│ │ ├── LoadingSpinner.tsx\n│ │ ├── MessageForm.tsx\n│ │ ├── MessageList.tsx\n│ │ ├── SearchForm.tsx\n│ │ ├── TopicDetail.tsx\n│ │ └── TopicList.tsx\n│ ├── index.html # HTML template\n│ └── index.tsx # Client entry point\n└── shared/\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.",[149],"5343c3fe-14cd-11f0-b10b-569c3dd06744","shared","add21c84-9f00-4405-af88-6ec5134089df",2,["D",1744153254621],"directory",[156],"65bd0400-14cd-11f0-9e26-569c3dd06744","frontend","25ba79aa-990f-468a-a9a9-3feab00a24d6",5,["D",1744153285607],[163],"5ae47a2c-14cd-11f0-bbde-569c3dd06744","backend","50aca1db-e744-46f9-883e-ba00e55ffc58",["D",1744153267418],[169],"pulls","branches","forks","envVars",{"_180":144,"_182":144},"connections",{"_180":144,"_181":144},"count","unfilledCount","emptyCount",{"_45":168,"_33":169,"_31":170,"_140":-5,"_43":44,"_42":65,"_142":25,"_40":334,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_205":335,"_28":336},{"_45":330,"_33":322,"_31":316,"_140":170,"_43":44,"_42":65,"_142":25,"_40":331,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_205":332,"_28":333},{"_45":323,"_33":324,"_31":325,"_140":316,"_43":44,"_42":65,"_142":27,"_40":326,"_13":144,"_35":36,"_37":327,"_24":27,"_146":-5,"_205":328,"_28":329},{"_45":313,"_33":314,"_31":315,"_140":316,"_43":44,"_42":317,"_142":27,"_40":318,"_13":144,"_35":36,"_37":319,"_24":27,"_146":-5,"_205":320,"_28":321},{"_45":309,"_33":34,"_31":32,"_140":170,"_43":44,"_42":14,"_142":27,"_40":310,"_13":151,"_35":39,"_37":38,"_24":27,"_146":-5,"_205":311,"_28":312},{"_45":162,"_33":163,"_31":164,"_140":-5,"_43":44,"_42":165,"_142":25,"_40":306,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_205":307,"_28":308},{"_45":302,"_33":245,"_31":239,"_140":164,"_43":44,"_42":289,"_142":25,"_40":303,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_205":304,"_28":305},{"_45":294,"_33":295,"_31":296,"_140":239,"_43":44,"_42":297,"_142":27,"_40":298,"_13":144,"_35":36,"_37":299,"_24":27,"_146":-5,"_205":300,"_28":301},{"_45":286,"_33":287,"_31":288,"_140":239,"_43":44,"_42":289,"_142":27,"_40":290,"_13":144,"_35":36,"_37":291,"_24":27,"_146":-5,"_205":292,"_28":293},{"_45":278,"_33":279,"_31":280,"_140":239,"_43":44,"_42":281,"_142":27,"_40":282,"_13":144,"_35":36,"_37":283,"_24":27,"_146":-5,"_205":284,"_28":285},{"_45":270,"_33":271,"_31":272,"_140":239,"_43":44,"_42":273,"_142":27,"_40":274,"_13":144,"_35":36,"_37":275,"_24":27,"_146":-5,"_205":276,"_28":277},{"_45":262,"_33":263,"_31":264,"_140":239,"_43":44,"_42":265,"_142":27,"_40":266,"_13":144,"_35":36,"_37":267,"_24":27,"_146":-5,"_205":268,"_28":269},{"_45":254,"_33":255,"_31":256,"_140":239,"_43":44,"_42":257,"_142":27,"_40":258,"_13":144,"_35":36,"_37":259,"_24":27,"_146":-5,"_205":260,"_28":261},{"_45":246,"_33":247,"_31":248,"_140":239,"_43":44,"_42":249,"_142":27,"_40":250,"_13":144,"_35":36,"_37":251,"_24":27,"_146":-5,"_205":252,"_28":253},{"_45":236,"_33":237,"_31":238,"_140":239,"_43":44,"_42":240,"_142":27,"_40":241,"_13":144,"_35":36,"_37":242,"_24":27,"_146":-5,"_205":243,"_28":244},{"_45":229,"_33":230,"_31":231,"_140":164,"_43":44,"_42":165,"_142":27,"_40":232,"_13":144,"_35":20,"_37":233,"_24":27,"_146":-5,"_205":234,"_28":235},{"_45":221,"_33":222,"_31":223,"_140":164,"_43":44,"_42":224,"_142":27,"_40":225,"_13":144,"_35":36,"_37":226,"_24":27,"_146":-5,"_205":227,"_28":228},{"_45":155,"_33":156,"_31":157,"_140":-5,"_43":44,"_42":158,"_142":25,"_40":218,"_13":144,"_35":160,"_37":-5,"_24":27,"_146":-5,"_205":219,"_28":220},{"_45":211,"_33":212,"_31":213,"_140":157,"_43":44,"_42":158,"_142":25,"_40":214,"_13":144,"_35":36,"_37":215,"_24":27,"_146":-5,"_205":216,"_28":217},{"_45":148,"_33":149,"_31":150,"_140":-5,"_43":44,"_42":151,"_142":27,"_40":208,"_13":144,"_35":20,"_37":153,"_24":27,"_146":-5,"_205":209,"_28":210},{"_45":137,"_33":138,"_31":139,"_140":-5,"_43":44,"_42":141,"_142":27,"_40":204,"_13":144,"_35":36,"_37":145,"_24":27,"_146":-5,"_205":206,"_28":207},["D",1744153395020],"children",[],[138],["D",1744153251229],[],[149],"5343bcb0-14cd-11f0-b10b-569c3dd06744","types.ts","5343bd78-14cd-11f0-b10b-569c3dd06744",["D",1744153254621],"/**\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}",[],[156,212],["D",1744153254621],[201],[156],"95142c7e-14cd-11f0-b4b7-569c3dd06744","index.tsx","95142d28-14cd-11f0-b4b7-569c3dd06744",14,["D",1744153365038],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { RouterProvider, createBrowserRouter } from \"https://esm.sh/react-router-dom@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\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 // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n window.__staticRouterHydrationData.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);",[],[163,222],"65bcfd3e-14cd-11f0-9e26-569c3dd06744","index.html","65bcfe06-14cd-11f0-9e26-569c3dd06744",["D",1744153285607],"\n\n\n \n \n Community Message Board\n \n \n \n\n\n

\n \n\n",[],[163,230],"7e747118-14cd-11f0-9e26-569c3dd06744","TopicList.tsx","7e7471ea-14cd-11f0-9e26-569c3dd06744","dea96277-3d90-41f7-8b34-da954ceef6fc",10,["D",1744153327079],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, Form, useNavigation } from \"https://esm.sh/react-router-dom@7.5.0?deps=react@18.2.0,react-dom@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({ topics }: TopicListProps) {\n const navigation = useNavigation();\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

Topics

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

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

\n ) : (\n

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

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

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

\n ))}\n

\n )}\n

\n );\n}",[],[163,245,237],"components","84a11e4c-14cd-11f0-90bb-569c3dd06744","TopicDetail.tsx","84a11ef6-14cd-11f0-90bb-569c3dd06744",11,["D",1744153337443],"// @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-dom@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}",[],[163,245,247],"90a035d4-14cd-11f0-8b75-569c3dd06744","SearchResults.tsx","90a036c4-14cd-11f0-8b75-569c3dd06744",13,["D",1744153357569],"// @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-dom@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}",[],[163,245,255],"7700ea24-14cd-11f0-82fd-569c3dd06744","SearchForm.tsx","7700eaba-14cd-11f0-82fd-569c3dd06744",9,["D",1744153314583],"// @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-dom@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}",[],[163,245,263],"722f5f62-14cd-11f0-83b3-569c3dd06744","MessageList.tsx","722f6066-14cd-11f0-83b3-569c3dd06744",8,["D",1744153306497],"// @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-dom@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}",[],[163,245,271],"6d98d488-14cd-11f0-9771-569c3dd06744","MessageForm.tsx","6d98d532-14cd-11f0-9771-569c3dd06744",7,["D",1744153298802],"// @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-dom@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}",[],[163,245,279],"68b503ec-14cd-11f0-98df-569c3dd06744","LoadingSpinner.tsx","68b504be-14cd-11f0-98df-569c3dd06744",6,["D",1744153290594],"// @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}",[],[163,245,287],"892aebb4-14cd-11f0-897e-569c3dd06744","App.tsx","892aec86-14cd-11f0-897e-569c3dd06744",12,["D",1744153345055],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router-dom@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n \n return (\n

\n {isLoading && (\n

\n \n

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

\n );\n}",[],[163,245,295],"68b50b94-14cd-11f0-98df-569c3dd06744",["D",1744153290594],[190,191,192,193,194,195,196,197],[163,245],["D",1744153285607],[189,198,199],[163],"c047d666-14cd-11f0-a9fb-569c3dd06744",["D",1744153437517],[],[169,34],"62297fd0-14cd-11f0-800b-569c3dd06744","queries.ts","6229805c-14cd-11f0-800b-569c3dd06744","4af61b55-4e6e-48ee-bb08-a35baadaf267",4,["D",1744153279616],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Message, Topic, SearchResults } 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 \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 SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE id = ?\n `, [id]);\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 INSERT INTO ${TOPICS_TABLE} (title, createdAt)\n VALUES (?, ?)\n RETURNING id, title, createdAt\n `, [title, createdAt]);\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 SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE topicId = ? \n ORDER BY createdAt ASC\n `, [topicId]);\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 SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE id = ?\n `, [id]);\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 INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt)\n VALUES (?, ?, ?)\n RETURNING id, topicId, content, createdAt\n `, [topicId, content, createdAt]);\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 SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE title LIKE ? \n ORDER BY createdAt DESC\n `, [`%${query}%`]);\n \n // Search in messages\n const messagesResult = await sqlite.execute(`\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 `, [`%${query}%`]);\n \n return {\n topics: topicsResult.rows as Topic[],\n messages: messagesResult.rows as Message[],\n query\n };\n}",[],[169,322,314],"database","5ae46a96-14cd-11f0-bbde-569c3dd06744","migrations.ts","5ae46b72-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],"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}",[],[169,322,324],"5ae47cc0-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[185,186],[169,322],["D",1744153267418],[184,187],[169],["D",1744152661331],["D",1789558275908],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":57,"_106":107,"_108":27},{"_13":91,"_33":92,"_45":44,"_93":46,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":47,"_100":101},"ctx",{"_84":-5,"_129":375,"_376":377,"_378":379,"_380":27,"_381":27,"_382":27,"_383":25,"_384":-5,"_385":-7,"_386":-7,"_387":144,"_388":27,"_389":27,"_390":-5,"_391":27,"_392":27,"_393":27,"_394":-5},"ENV",{"_346":347,"_348":349,"_350":92,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v17