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}",[],[125,155],"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}",[],[125,162],"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}",[],[125,169],"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}",[],[125,176],"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}",[],[125,183],"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}",[],[125,190],"a19ebdc6-1601-11f0-b336-569c3dd06744","Home.loader.ts","cc743363-3789-41da-8d02-b0658fb3a1a2",8,["D",1744285671067],2,"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}",[],[125,197],"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}",[],[125,206],"0dfad372-15ff-11f0-8464-569c3dd06744","frontend","4da763eb-2fc2-4086-b67a-439bf27fdfff",["D",1744284564372],[218,219,220],[213],{"_36":235,"_13":236,"_63":237,"_65":214,"_67":68,"_69":70,"_71":72,"_38":238,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":239,"_18":240},{"_36":228,"_13":229,"_63":230,"_65":214,"_67":68,"_69":70,"_71":72,"_38":231,"_17":74,"_75":24,"_77":232,"_79":52,"_80":-5,"_103":233,"_18":234},{"_36":221,"_13":222,"_63":223,"_65":214,"_67":68,"_69":70,"_71":72,"_38":224,"_17":74,"_75":76,"_77":225,"_79":52,"_80":-5,"_103":226,"_18":227},"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);",[],[213,222],"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",[],[213,229],"0dfacf08-15ff-11f0-8464-569c3dd06744","components","a03b28b7-1d27-4a70-814b-e822a531240d",["D",1744284564372],[241,242,243,244,245,246,247,248],[213,236],{"_36":298,"_13":206,"_63":299,"_65":237,"_67":68,"_69":70,"_71":72,"_38":300,"_17":74,"_75":76,"_77":301,"_79":52,"_80":-5,"_103":302,"_18":303},{"_36":291,"_13":292,"_63":293,"_65":237,"_67":68,"_69":70,"_71":72,"_38":294,"_17":74,"_75":76,"_77":295,"_79":52,"_80":-5,"_103":296,"_18":297},{"_36":284,"_13":285,"_63":286,"_65":237,"_67":68,"_69":70,"_71":72,"_38":287,"_17":74,"_75":76,"_77":288,"_79":52,"_80":-5,"_103":289,"_18":290},{"_36":277,"_13":278,"_63":279,"_65":237,"_67":68,"_69":70,"_71":72,"_38":280,"_17":74,"_75":76,"_77":281,"_79":52,"_80":-5,"_103":282,"_18":283},{"_36":270,"_13":271,"_63":272,"_65":237,"_67":68,"_69":70,"_71":72,"_38":273,"_17":74,"_75":76,"_77":274,"_79":52,"_80":-5,"_103":275,"_18":276},{"_36":263,"_13":264,"_63":265,"_65":237,"_67":68,"_69":70,"_71":72,"_38":266,"_17":74,"_75":76,"_77":267,"_79":52,"_80":-5,"_103":268,"_18":269},{"_36":256,"_13":257,"_63":258,"_65":237,"_67":68,"_69":70,"_71":72,"_38":259,"_17":74,"_75":76,"_77":260,"_79":52,"_80":-5,"_103":261,"_18":262},{"_36":249,"_13":250,"_63":251,"_65":237,"_67":68,"_69":70,"_71":72,"_38":252,"_17":74,"_75":76,"_77":253,"_79":52,"_80":-5,"_103":254,"_18":255},"0dfacb98-15ff-11f0-8464-569c3dd06744","TopicList.tsx","b0d10a5c-9dc3-4854-9081-079445471502",["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}",[],[213,236,250],"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}",[],[213,236,257],"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}",[],[213,236,264],"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}",[],[213,236,271],"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}",[],[213,236,278],"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}",[],[213,236,285],"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}",[],[213,236,292],"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}",[],[213,236,206],"0dfa9ce0-15ff-11f0-8464-569c3dd06744","backend","31dfe576-1b7a-4959-8de1-b093a853993d",["D",1744284564372],[310,311],[305],{"_36":321,"_13":322,"_63":323,"_65":306,"_67":68,"_69":70,"_71":72,"_38":324,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":325,"_18":326},{"_36":312,"_13":313,"_63":314,"_65":306,"_67":68,"_69":32,"_71":72,"_38":315,"_17":316,"_75":317,"_77":318,"_79":52,"_80":-5,"_103":319,"_18":320},"71087660-1602-11f0-b18d-569c3dd06744","index.ts","c20af5ca-069c-4bdc-9a24-774ab2eeef59",["D",1744286019032],7,"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 // From: https://github.com/remix-run/custom-react-router-framework-example/blob/f5a141d67800e8da076cd1bb3130f29a8c0d4ce3/entry.server.tsx#L79\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;",[],[305,313],"0dfa9560-15ff-11f0-8464-569c3dd06744","database","0f2f1506-7c6a-4b12-9efc-fd71035cb369",["D",1744284564372],[327,328],[305,322],{"_36":336,"_13":337,"_63":338,"_65":323,"_67":68,"_69":70,"_71":72,"_38":339,"_17":74,"_75":76,"_77":340,"_79":52,"_80":-5,"_103":341,"_18":342},{"_36":329,"_13":330,"_63":331,"_65":323,"_67":68,"_69":70,"_71":72,"_38":332,"_17":74,"_75":76,"_77":333,"_79":52,"_80":-5,"_103":334,"_18":335},"0dfa918c-15ff-11f0-8464-569c3dd06744","queries.ts","fed67a00-f6f6-423c-b2e5-d28a5c36ed27",["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}",[],[305,322,330],"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}",[],[305,322,337],["D",1744152661331],"legacyEnvVars","httpPrivacy","description","Full-stack example ReactRouter7 project","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","e315d710-14cd-11f0-a969-569c3dd06744","pinPreview","pinMigrated","screenshotVersion",151,"likeCount",3,"tursoName","f1a22d8a14cb11f0b108569c3dd06744","tursoHostname","f1a22d8a14cb11f0b108569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789558275908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_391":387},"org",{"_11":12,"_385":-5,"_386":387,"_349":350,"_388":389,"_390":52},"branch",{"_17":32,"_13":16,"_36":68,"_43":44,"_46":37,"_47":381,"_382":54,"_383":44,"_384":57,"_58":14,"_55":12},84,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":44,"_13":14,"_38":529,"_50":-5,"_344":52,"_53":54,"_345":54,"_346":347,"_348":-5,"_349":350,"_351":352,"_353":72,"_354":-5,"_355":356,"_357":358,"_56":57,"_359":360,"_361":362,"_363":530,"_365":-5,"_366":367,"_368":367,"_369":370,"_371":370,"_372":370,"_373":367,"_374":367,"_375":531,"_377":532,"_379":533,"_51":52},[430,435,447,458,461,462],"files",[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,460,461,462],"counts",{"_420":70,"_421":422,"_423":358,"_35":424,"_425":426},[416,417],{"_36":88,"_67":68,"_63":66,"_13":19,"_77":-5,"_75":90,"_17":74,"_65":-5,"_38":414,"_69":70,"_80":-5,"_18":415},"upstreamProject","upstreamBranch",{"_36":37,"_38":412,"_40":413,"_13":42,"_43":44,"_17":45,"_46":-5,"_47":-5,"_48":49,"_50":-5,"_51":52,"_53":54,"_55":12,"_56":57,"_58":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744152661331],["D",1771761464050],["D",1744284564372],[19],{"_36":82,"_13":83,"_63":84,"_65":66,"_67":68,"_69":70,"_71":72,"_38":85,"_17":74,"_75":76,"_77":86,"_79":52,"_80":-5,"_18":419},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":73,"_17":74,"_75":76,"_77":78,"_79":52,"_80":-5,"_18":418},[19,62],[19,83],"pulls","branches",5,"forks",{"_427":74,"_429":74},"connections",{"_427":74,"_428":74},"count","unfilledCount","emptyCount",{"_36":304,"_13":305,"_63":306,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":307,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":527,"_18":528},{"_36":321,"_13":322,"_63":323,"_65":306,"_67":68,"_69":70,"_71":72,"_38":324,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":525,"_18":526},{"_36":336,"_13":337,"_63":338,"_65":323,"_67":68,"_69":70,"_71":72,"_38":339,"_17":74,"_75":76,"_77":340,"_79":52,"_80":-5,"_103":523,"_18":524},{"_36":329,"_13":330,"_63":331,"_65":323,"_67":68,"_69":70,"_71":72,"_38":332,"_17":74,"_75":76,"_77":333,"_79":52,"_80":-5,"_103":521,"_18":522},{"_36":312,"_13":313,"_63":314,"_65":306,"_67":68,"_69":32,"_71":72,"_38":315,"_17":316,"_75":317,"_77":318,"_79":52,"_80":-5,"_103":519,"_18":520},{"_36":212,"_13":213,"_63":214,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":215,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":517,"_18":518},{"_36":235,"_13":236,"_63":237,"_65":214,"_67":68,"_69":70,"_71":72,"_38":238,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":515,"_18":516},{"_36":298,"_13":206,"_63":299,"_65":237,"_67":68,"_69":70,"_71":72,"_38":300,"_17":74,"_75":76,"_77":301,"_79":52,"_80":-5,"_103":513,"_18":514},{"_36":291,"_13":292,"_63":293,"_65":237,"_67":68,"_69":70,"_71":72,"_38":294,"_17":74,"_75":76,"_77":295,"_79":52,"_80":-5,"_103":511,"_18":512},{"_36":284,"_13":285,"_63":286,"_65":237,"_67":68,"_69":70,"_71":72,"_38":287,"_17":74,"_75":76,"_77":288,"_79":52,"_80":-5,"_103":509,"_18":510},{"_36":277,"_13":278,"_63":279,"_65":237,"_67":68,"_69":70,"_71":72,"_38":280,"_17":74,"_75":76,"_77":281,"_79":52,"_80":-5,"_103":507,"_18":508},{"_36":270,"_13":271,"_63":272,"_65":237,"_67":68,"_69":70,"_71":72,"_38":273,"_17":74,"_75":76,"_77":274,"_79":52,"_80":-5,"_103":505,"_18":506},{"_36":263,"_13":264,"_63":265,"_65":237,"_67":68,"_69":70,"_71":72,"_38":266,"_17":74,"_75":76,"_77":267,"_79":52,"_80":-5,"_103":503,"_18":504},{"_36":256,"_13":257,"_63":258,"_65":237,"_67":68,"_69":70,"_71":72,"_38":259,"_17":74,"_75":76,"_77":260,"_79":52,"_80":-5,"_103":501,"_18":502},{"_36":249,"_13":250,"_63":251,"_65":237,"_67":68,"_69":70,"_71":72,"_38":252,"_17":74,"_75":76,"_77":253,"_79":52,"_80":-5,"_103":499,"_18":500},{"_36":228,"_13":229,"_63":230,"_65":214,"_67":68,"_69":70,"_71":72,"_38":231,"_17":74,"_75":24,"_77":232,"_79":52,"_80":-5,"_103":497,"_18":498},{"_36":221,"_13":222,"_63":223,"_65":214,"_67":68,"_69":70,"_71":72,"_38":224,"_17":74,"_75":76,"_77":225,"_79":52,"_80":-5,"_103":495,"_18":496},{"_36":124,"_13":125,"_63":126,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":127,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":493,"_18":494},{"_36":205,"_13":206,"_63":207,"_65":126,"_67":68,"_69":70,"_71":72,"_38":208,"_17":74,"_75":76,"_77":209,"_79":52,"_80":-5,"_103":491,"_18":492},{"_36":196,"_13":197,"_63":198,"_65":126,"_67":68,"_69":199,"_71":72,"_38":200,"_17":201,"_75":76,"_77":202,"_79":52,"_80":-5,"_103":489,"_18":490},{"_36":189,"_13":190,"_63":191,"_65":126,"_67":68,"_69":70,"_71":72,"_38":192,"_17":74,"_75":76,"_77":193,"_79":52,"_80":-5,"_103":487,"_18":488},{"_36":182,"_13":183,"_63":184,"_65":126,"_67":68,"_69":70,"_71":72,"_38":185,"_17":74,"_75":76,"_77":186,"_79":52,"_80":-5,"_103":485,"_18":486},{"_36":175,"_13":176,"_63":177,"_65":126,"_67":68,"_69":70,"_71":72,"_38":178,"_17":74,"_75":76,"_77":179,"_79":52,"_80":-5,"_103":483,"_18":484},{"_36":168,"_13":169,"_63":170,"_65":126,"_67":68,"_69":70,"_71":72,"_38":171,"_17":74,"_75":76,"_77":172,"_79":52,"_80":-5,"_103":481,"_18":482},{"_36":161,"_13":162,"_63":163,"_65":126,"_67":68,"_69":70,"_71":72,"_38":164,"_17":74,"_75":76,"_77":165,"_79":52,"_80":-5,"_103":479,"_18":480},{"_36":154,"_13":155,"_63":156,"_65":126,"_67":68,"_69":70,"_71":72,"_38":157,"_17":74,"_75":76,"_77":158,"_79":52,"_80":-5,"_103":477,"_18":478},{"_36":147,"_13":148,"_63":149,"_65":126,"_67":68,"_69":70,"_71":72,"_38":150,"_17":74,"_75":76,"_77":151,"_79":52,"_80":-5,"_103":475,"_18":476},{"_36":140,"_13":141,"_63":142,"_65":126,"_67":68,"_69":70,"_71":72,"_38":143,"_17":74,"_75":76,"_77":144,"_79":52,"_80":-5,"_103":473,"_18":474},{"_36":88,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":113,"_17":74,"_75":90,"_77":-5,"_79":52,"_80":-5,"_103":471,"_18":472},{"_36":82,"_13":83,"_63":84,"_65":66,"_67":68,"_69":70,"_71":72,"_38":121,"_17":74,"_75":76,"_77":86,"_79":52,"_80":-5,"_103":469,"_18":470},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":118,"_17":74,"_75":76,"_77":78,"_79":52,"_80":-5,"_103":467,"_18":468},{"_36":106,"_13":107,"_63":108,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":109,"_17":74,"_75":24,"_77":110,"_79":52,"_80":-5,"_103":465,"_18":466},{"_36":98,"_13":99,"_63":100,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":101,"_17":74,"_75":24,"_77":102,"_79":52,"_80":-5,"_103":463,"_18":464},[],[99],[],[107],[],[19,62],[],[19,83],[459,460],[19],[],[125,141],[],[125,148],[],[125,155],[],[125,162],[],[125,169],[],[125,176],[],[125,183],[],[125,190],[],[125,197],[],[125,206],[448,449,450,451,452,453,454,455,456,457],[125],[],[213,222],[],[213,229],[],[213,236,250],[],[213,236,257],[],[213,236,264],[],[213,236,271],[],[213,236,278],[],[213,236,285],[],[213,236,292],[],[213,236,206],[437,438,439,440,441,442,443,444],[213,236],[436,445,446],[213],[],[305,313],[],[305,322,330],[],[305,322,337],[432,433],[305,322],[431,434],[305],["D",1744152661331],["D",1789558275908],{"_11":12,"_391":387},{"_11":12,"_385":-5,"_386":387,"_349":350,"_388":389,"_390":52},{"_17":32,"_13":16,"_36":68,"_43":44,"_46":37,"_47":381,"_382":54,"_383":44,"_384":57,"_58":14,"_55":12},"ctx",{"_375":-5,"_409":567,"_568":569,"_570":571,"_572":52,"_573":52,"_574":52,"_575":72,"_576":-5,"_577":-7,"_578":-7,"_579":74,"_580":52,"_581":52,"_582":-5,"_583":52,"_584":52,"_585":52,"_586":-5},"ENV",{"_538":539,"_540":541,"_542":42,"_543":544,"_545":546,"_547":548,"_549":550,"_551":552,"_553":554,"_555":556,"_557":558,"_559":560,"_561":562,"_563":564,"_565":566},"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"]