\",\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;",[],[161,204],[161],{"_106":213,"_98":214,"_162":215,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":216,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_175":217,"_102":298},"2aadb46c-1645-11f0-b5a9-569c3dd06744","frontend","2dad1ee4-a6ea-4a16-b839-896f14d0286d",["D",1744314677289],[218,281,290],{"_106":219,"_98":220,"_162":221,"_164":215,"_165":145,"_166":167,"_168":121,"_108":222,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_175":223,"_102":280},"2aadad5a-1645-11f0-b5a9-569c3dd06744","components","f41330df-a184-42ca-acfd-b06f5891cb32",["D",1744314677289],[224,232,240,248,256,264,272],{"_106":225,"_98":226,"_162":227,"_164":221,"_165":145,"_166":167,"_168":121,"_108":228,"_103":29,"_170":188,"_172":229,"_173":25,"_174":-5,"_175":230,"_102":231},"2aad9e8c-1645-11f0-b5a9-569c3dd06744","App.tsx","01bfe0c0-afc9-4a0f-9d29-56a7b7f0fb17",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n {isLoading && (\n

\n \n

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

\n );\n}",[],[214,220,226],{"_106":233,"_98":234,"_162":235,"_164":221,"_165":145,"_166":167,"_168":121,"_108":236,"_103":29,"_170":188,"_172":237,"_173":25,"_174":-5,"_175":238,"_102":239},"2aad9ffe-1645-11f0-b5a9-569c3dd06744","LoadingSpinner.tsx","733a0e72-f8fc-427d-987d-8deb9e032e62",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface LoadingSpinnerProps {\n size?: \"small\" | \"medium\" | \"large\";\n}\n\nexport function LoadingSpinner({ size = \"medium\" }: LoadingSpinnerProps) {\n const sizeClasses = {\n small: \"w-4 h-4 border-2\",\n medium: \"w-8 h-8 border-3\",\n large: \"w-12 h-12 border-4\"\n };\n\n return (\n

\n );\n}",[],[214,220,234],{"_106":241,"_98":242,"_162":243,"_164":221,"_165":145,"_166":167,"_168":121,"_108":244,"_103":29,"_170":188,"_172":245,"_173":25,"_174":-5,"_175":246,"_102":247},"2aada166-1645-11f0-b5a9-569c3dd06744","MessageForm.tsx","7f905bdc-2fd9-4c56-96be-bdef68b02ee7",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n useActionData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\ninterface MessageFormProps {\n topicId: number;\n}\n\nexport function MessageForm({ topicId }: MessageFormProps) {\n const navigation = useNavigation();\n const isSubmitting = navigation.state === \"submitting\";\n let $form = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n return (\n

Post a Message

\n \n

\n );\n}",[],[214,220,242],{"_106":249,"_98":250,"_162":251,"_164":221,"_165":145,"_166":167,"_168":121,"_108":252,"_103":29,"_170":188,"_172":253,"_173":25,"_174":-5,"_175":254,"_102":255},"2aada3fa-1645-11f0-b5a9-569c3dd06744","MessageList.tsx","8a230f6e-d323-4710-ae6c-aa295041257a",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link, useLocation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Message } from \"../../shared/types.ts\";\n\ninterface MessageListProps {\n messages: Message[];\n topicId: number;\n highlightedMessageId?: number;\n}\n\nexport function MessageList({ messages, topicId, highlightedMessageId }: MessageListProps) {\n const location = useLocation();\n\n if (messages.length === 0) {\n return (\n

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

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

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

{message.content}

\n \n {formattedDate}\n \n

\n );\n })}\n \n );\n}",[],[214,220,250],{"_106":257,"_98":258,"_162":259,"_164":221,"_165":145,"_166":167,"_168":121,"_108":260,"_103":29,"_170":188,"_172":261,"_173":25,"_174":-5,"_175":262,"_102":263},"2aada5f8-1645-11f0-b5a9-569c3dd06744","SearchForm.tsx","0a0dd767-1aa6-4786-9d68-2c175268ec8f",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Form, useNavigation, useSearchParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function SearchForm() {\n const navigation = useNavigation();\n const [searchParams] = useSearchParams();\n const query = searchParams.get(\"q\") || \"\";\n const isSearching = navigation.state === \"loading\" && navigation.location.pathname === \"/search\";\n \n return (\n \n );\n}",[],[214,220,258],{"_106":265,"_98":266,"_162":267,"_164":221,"_165":145,"_166":167,"_168":121,"_108":268,"_103":29,"_170":188,"_172":269,"_173":25,"_174":-5,"_175":270,"_102":271},"2aada774-1645-11f0-b5a9-569c3dd06744","SearchResults.tsx","c592b738-4ea2-44c4-97cc-2d10a4fdd267",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../../shared/types.ts\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\nexport function SearchResults() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

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

\n \n {!hasResults ? (\n

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

\n ) : (\n

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

Topics ({topics.length})

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

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

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

\n ))}\n

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

Messages ({messages.length})

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

{message.content}

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

\n ))}\n

\n )}\n

\n );\n}",[],[214,220,266],{"_106":273,"_98":274,"_162":275,"_164":221,"_165":145,"_166":167,"_168":121,"_108":276,"_103":29,"_170":188,"_172":277,"_173":25,"_174":-5,"_175":278,"_102":279},"2aadaabc-1645-11f0-b5a9-569c3dd06744","TopicDetail.tsx","b9b00b4e-7e76-4eb2-9d69-09fdd602917c",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link, useLoaderData, useParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Message, Topic } from \"../../shared/types.ts\";\nimport { MessageForm } from \"./MessageForm.tsx\";\nimport { MessageList } from \"./MessageList.tsx\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\ninterface TopicDetailData {\n topic: Topic;\n messages: Message[];\n}\n\nexport function TopicDetail() {\n const { topic, messages } = useLoaderData() as TopicDetailData;\n const { messageId } = useParams();\n const highlightedMessageId = messageId ? parseInt(messageId, 10) : undefined;\n\n // Scroll to highlighted message if messageId is provided\n useEffect(() => {\n if (highlightedMessageId) {\n const messageElement = document.getElementById(`message-${highlightedMessageId}`);\n if (messageElement) {\n messageElement.scrollIntoView({ behavior: \"smooth\", block: \"center\" });\n }\n }\n }, [highlightedMessageId]);\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

{topic.title}

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

\n\n

Messages

\n\n \n\n \n

\n );\n}",[],[214,220,274],[214,220],{"_106":282,"_98":283,"_162":284,"_164":215,"_165":145,"_166":167,"_168":121,"_108":285,"_103":29,"_170":286,"_172":287,"_173":25,"_174":-5,"_175":288,"_102":289},"2aadaf58-1645-11f0-b5a9-569c3dd06744","index.html","7f09b221-180b-47aa-8b48-8a390bce93e1",["D",1744314677289],"file","\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[214,283],{"_106":291,"_98":292,"_162":293,"_164":215,"_165":145,"_166":167,"_168":121,"_108":294,"_103":29,"_170":188,"_172":295,"_173":25,"_174":-5,"_175":296,"_102":297},"2aadb0ac-1645-11f0-b5a9-569c3dd06744","index.tsx","87c07d8e-b7d6-4a4d-bb66-9a5d4cccfe4f",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n RouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { routes } from \"../shared/routes.ts\";\n\n// Create a browser router with the same routes as the server\n// but using the hydration data from the server render\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n hydrationData: window.__staticRouterHydrationData,\n },\n);\n\n// Hydrate the app\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);",[],[214,292],[214],{"_106":300,"_98":301,"_162":302,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":303,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_175":304,"_102":393},"2aadcab0-1645-11f0-b5a9-569c3dd06744","routes","d1dce86a-a6c7-4eab-acfb-7879f79eee39",["D",1744314677289],[305,312,320,328,337,345,353,361,369,377,385],{"_106":306,"_98":226,"_162":307,"_164":302,"_165":145,"_166":167,"_168":121,"_108":308,"_103":29,"_170":188,"_172":309,"_173":25,"_174":-5,"_175":310,"_102":311},"2aadb61a-1645-11f0-b5a9-569c3dd06744","67b4bdd8-663f-4012-b9e6-ba3a5e8f159b",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"../frontend/components/LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n \n

\n\n \n

\n );\n}",[],[301,226],{"_106":313,"_98":314,"_162":315,"_164":302,"_165":145,"_166":125,"_168":121,"_108":316,"_103":29,"_170":188,"_172":317,"_173":25,"_174":-5,"_175":318,"_102":319},"4245ba0c-1645-11f0-9ca3-569c3dd06744","DeleteAll.action.ts","4245ba98-1645-11f0-9ca3-569c3dd06744",["D",1744314716884],"import { ActionFunctionArgs, redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { deleteAllTopicsAndMessages } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const confirmation = formData.get(\"confirmation\") as string;\n\n if (confirmation !== \"delete-all\") {\n throw new Response(\"Invalid confirmation\", { status: 400 });\n }\n\n await deleteAllTopicsAndMessages();\n \n // Redirect back to the home page\n return redirect(\"/\");\n}",[],[301,314],{"_106":321,"_98":322,"_162":323,"_164":302,"_165":145,"_166":167,"_168":121,"_108":324,"_103":29,"_170":188,"_172":325,"_173":25,"_174":-5,"_175":326,"_102":327},"2aadb7f0-1645-11f0-b5a9-569c3dd06744","Home.loader.ts","8555734a-58d5-4f7e-986c-af499c1fdc1c",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getAllTopics } from \"../backend/database/queries.ts\";\n\nexport async function loader() {\n return { topics: await getAllTopics() };\n}",[],[301,322],{"_106":329,"_98":330,"_162":331,"_164":302,"_165":145,"_166":332,"_168":121,"_108":333,"_103":167,"_170":188,"_172":334,"_173":25,"_174":-5,"_175":335,"_102":336},"55f31a0e-1645-11f0-abf8-569c3dd06744","Home.tsx","8239b451-63d6-4090-b0ca-17a2256a913b",5,["D",1744314749895],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n Link,\n useLoaderData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\nimport { Topic } from \"../shared/types.ts\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function Home() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/\" && navigation.state === \"submitting\";\n const isDeletingAll = navigation.formAction === \"/delete-all\" && navigation.state === \"submitting\";\n let $form = React.useRef(null);\n let $deleteForm = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n const handleDeleteAll = (e: React.FormEvent) => {\n if (!confirm(\"Are you sure you want to delete ALL topics and messages? This action cannot be undone.\")) {\n e.preventDefault();\n }\n };\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

Create a New Topic

\n \n

\n\n

Topics

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

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

\n )\n : (\n

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

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

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

\n ))}\n

\n )}\n

\n );\n}",[],[301,330],{"_106":338,"_98":339,"_162":340,"_164":302,"_165":145,"_166":167,"_168":121,"_108":341,"_103":29,"_170":188,"_172":342,"_173":25,"_174":-5,"_175":343,"_102":344},"2aadbda4-1645-11f0-b5a9-569c3dd06744","Search.loader.ts","f29bd6bb-760c-4a1a-8561-25a4726b3602",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { search } from \"../backend/database/queries.ts\";\n\nexport async function loader({ request }: LoaderFunctionArgs) {\n const url = new URL(request.url);\n const query = url.searchParams.get(\"q\") || \"\";\n\n if (!query || query.trim() === \"\") {\n return { topics: [], messages: [], query: \"\" };\n }\n\n return await search(query);\n}",[],[301,339],{"_106":346,"_98":347,"_162":348,"_164":302,"_165":145,"_166":167,"_168":121,"_108":349,"_103":29,"_170":188,"_172":350,"_173":25,"_174":-5,"_175":351,"_102":352},"2aadbf70-1645-11f0-b5a9-569c3dd06744","Search.tsx","e4076c07-7ec1-4d0f-b4f7-cd2f465ef5b1",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../shared/types.ts\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\nexport function Search() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

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

\n \n {!hasResults ? (\n

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

\n ) : (\n

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

Topics ({topics.length})

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

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

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

\n ))}\n

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

Messages ({messages.length})

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

{message.content}

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

\n ))}\n

\n )}\n

\n );\n}",[],[301,347],{"_106":354,"_98":355,"_162":356,"_164":302,"_165":145,"_166":167,"_168":121,"_108":357,"_103":29,"_170":188,"_172":358,"_173":25,"_174":-5,"_175":359,"_102":360},"2aadc268-1645-11f0-b5a9-569c3dd06744","Topic.action.ts","73fdb20b-448c-4b9e-ac48-57aad1415049",["D",1744314677289],"import { ActionFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createMessage } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n console.log(\"HERE!\");\n const formData = await request.formData();\n const topicId = parseInt(formData.get(\"topicId\") as string, 10);\n const content = formData.get(\"content\") as string;\n\n if (!content || content.trim() === \"\") {\n throw new Response(\"Content is required\", { status: 400 });\n }\n\n const message = await createMessage(topicId, content);\n return message;\n}",[],[301,355],{"_106":362,"_98":363,"_162":364,"_164":302,"_165":145,"_166":167,"_168":121,"_108":365,"_103":29,"_170":188,"_172":366,"_173":25,"_174":-5,"_175":367,"_102":368},"2aadc416-1645-11f0-b5a9-569c3dd06744","Topic.loader.ts","49dc9b30-8f7a-43c9-80bc-72da05a4cf87",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const topic = await getTopicById(topicId);\n\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[301,363],{"_106":370,"_98":371,"_162":372,"_164":302,"_165":145,"_166":167,"_168":121,"_108":373,"_103":29,"_170":188,"_172":374,"_173":25,"_174":-5,"_175":375,"_102":376},"2aadc560-1645-11f0-b5a9-569c3dd06744","Topic.tsx","d3e23910-e9ee-497a-a707-19f58864d0ab",["D",1744314677289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData, useParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Message, Topic } from \"../shared/types.ts\";\nimport { MessageForm } from \"../frontend/components/MessageForm.tsx\";\nimport { MessageList } from \"../frontend/components/MessageList.tsx\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\ninterface TopicDetailData {\n topic: Topic;\n messages: Message[];\n}\n\nexport function Topic() {\n const { topic, messages } = useLoaderData() as TopicDetailData;\n const { messageId } = useParams();\n const highlightedMessageId = messageId ? parseInt(messageId, 10) : undefined;\n \n // Scroll to highlighted message if messageId is provided\n useEffect(() => {\n if (highlightedMessageId) {\n const messageElement = document.getElementById(`message-${highlightedMessageId}`);\n if (messageElement) {\n messageElement.scrollIntoView({ behavior: \"smooth\", block: \"center\" });\n }\n }\n }, [highlightedMessageId]);\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

{topic.title}

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

\n \n

Messages

\n \n \n \n \n

\n );\n}",[],[301,371],{"_106":378,"_98":379,"_162":380,"_164":302,"_165":145,"_166":167,"_168":121,"_108":381,"_103":29,"_170":188,"_172":382,"_173":25,"_174":-5,"_175":383,"_102":384},"2aadc7b8-1645-11f0-b5a9-569c3dd06744","TopicMessage.loader.ts","321e0aac-461c-4753-8109-97e0cfda4b8f",["D",1744314677289],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessageById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const messageId = parseInt(params.messageId!, 10);\n\n const topic = await getTopicById(topicId);\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const message = await getMessageById(messageId);\n if (!message || message.topicId !== topicId) {\n throw new Response(\"Message not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[301,379],{"_106":386,"_98":387,"_162":388,"_164":302,"_165":145,"_166":167,"_168":121,"_108":389,"_103":29,"_170":188,"_172":390,"_173":25,"_174":-5,"_175":391,"_102":392},"2aadc920-1645-11f0-b5a9-569c3dd06744","Topics.action.ts","71651c84-ce4f-45f2-891e-0e46184a8430",["D",1744314677289],"import { ActionFunctionArgs, redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createTopic } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const title = formData.get(\"title\") as string;\n\n if (!title || title.trim() === \"\") {\n throw new Response(\"Title is required\", { status: 400 });\n }\n\n const topic = await createTopic(title);\n return redirect(`/topics/${topic.id}`);\n}",[],[301,387],[301],{"_106":395,"_98":396,"_162":397,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":398,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_175":399,"_102":417},"2aadd064-1645-11f0-b5a9-569c3dd06744","shared","d02154ad-498e-4d5e-9daf-80c817fbdbd0",["D",1744314677289],[400,409],{"_106":401,"_98":402,"_162":403,"_164":397,"_165":145,"_166":404,"_168":121,"_108":405,"_103":167,"_170":188,"_172":406,"_173":25,"_174":-5,"_175":407,"_102":408},"45477c86-1645-11f0-9e0a-569c3dd06744","routes.ts","58d7548f-8eef-4fb6-af3f-dc7669451e67",4,["D",1744314721924],"import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { App } from \"../routes/App.tsx\";\nimport { Home } from \"../routes/Home.tsx\";\nimport { Search } from \"../routes/Search.tsx\";\nimport { Topic } from \"../routes/Topic.tsx\";\n\nlet isServer = typeof document === \"undefined\";\nlet isClient = !isServer;\n\n// Generic loader that forwards on requests for that page's JSON data\nfunction clientLoader({ request }: LoaderFunctionArgs) {\n return fetch(request, {\n headers: {\n \"Accept\": \"application/json\",\n },\n }).then(res => res.json());\n}\n\n// Generic action that forwards on requests for that page\nasync function clientAction({ request }: ActionFunctionArgs) {\n const response = await fetch(request);\n if (response.status === 302) {\n // somehow do a redirect\n }\n // if the response is json content type, parse the json and return it\n if (response.headers.get(\"Content-Type\")?.includes(\"application/json\")) {\n return response.json();\n }\n return response;\n}\n\nfunction createFullstackLoader(loaderSourceImportURL: string) {\n if (isClient) {\n return clientLoader;\n } else {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(loaderSourceImportURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n}\n\nfunction createFullstackAction(actionSourceImportURL: string) {\n if (isClient) {\n return clientAction;\n } else {\n return async (args: ActionFunctionArgs) => {\n let module = await import(actionSourceImportURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: createFullstackAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: createFullstackLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"delete-all\",\n action: createFullstackAction(\"../routes/DeleteAll.action.ts\"),\n },\n {\n path: \"topics/:topicId\",\n Component: Topic,\n loader: createFullstackLoader(\"../routes/Topic.loader.ts\"),\n action: createFullstackAction(\"../routes/Topic.action.ts\"),\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n Component: Topic,\n loader: createFullstackLoader(\"../routes/TopicMessage.loader.ts\"),\n },\n {\n path: \"search\",\n Component: Search,\n loader: createFullstackLoader(\"../routes/Search.loader.ts\"),\n },\n ],\n },\n];",[],[396,402],{"_106":410,"_98":411,"_162":412,"_164":397,"_165":145,"_166":167,"_168":121,"_108":413,"_103":29,"_170":188,"_172":414,"_173":25,"_174":-5,"_175":415,"_102":416},"2aadce98-1645-11f0-b5a9-569c3dd06744","types.ts","d693e7f0-5fe0-4156-854c-08a19f97ecc7",["D",1744314677289],"/**\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}",[],[396,411],[396],{"_106":419,"_98":420,"_162":421,"_164":-5,"_165":145,"_166":144,"_168":121,"_108":422,"_103":125,"_170":286,"_172":423,"_173":25,"_174":-5,"_175":424,"_102":425},"5e51b8e0-1645-11f0-88ab-569c3dd06744","README.md","10deab7e-c9d8-4a0c-9a8a-0a0f52346c98",["D",1744314763898],"# Community Message Board\n\nA simple community message board application built with React Router 7, demonstrating a full-stack approach with server-side rendering and client-side navigation.\n\n## Features\n\n- **Server-Side Rendering**: All pages are server-rendered when accessed directly\n- **Client-Side Navigation**: After initial load, navigation happens client-side\n- **Topic Management**: Create and view discussion topics\n- **Messaging System**: Post messages in topics\n- **Direct Message Links**: Link directly to specific messages via timestamps\n- **Search Functionality**: Search topics and messages with URL parameters\n- **Loading Indicators**: Visual feedback during async operations\n- **Data Management**: Delete all topics and messages with a single click\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database queries\n│ └── index.ts # Server entry point\n├── frontend/\n│ ├── components/\n│ │ ├── LoadingSpinner.tsx\n│ │ ├── MessageForm.tsx\n│ │ ├── MessageList.tsx\n│ │ └── SearchForm.tsx\n│ ├── index.html # HTML template\n│ └── index.tsx # Client entry point\n├── routes/\n│ ├── App.tsx # Main application component\n│ ├── Home.tsx # Home page component\n│ ├── Home.loader.ts # Home page data loader\n│ ├── Topic.tsx # Topic detail component\n│ ├── Topic.loader.ts # Topic data loader\n│ ├── Topic.action.ts # Topic message creation action\n│ ├── TopicMessage.loader.ts # Direct message link loader\n│ ├── Topics.action.ts # Topic creation action\n│ ├── DeleteAll.action.ts # Delete all topics and messages action\n│ ├── Search.tsx # Search results component\n│ └── Search.loader.ts # Search data loader\n└── shared/\n ├── routes.ts # Route definitions\n └── types.ts # Shared TypeScript types\n```\n\n## How It Works\n\n### Server-Side Rendering\n\nThe application uses React Router 7's `createStaticHandler`, `createStaticRouter`, and `StaticRouterProvider` to render pages on the server. When a user directly accesses a URL:\n\n1. The server receives the request\n2. It runs the appropriate loaders/actions for the matched route\n3. The page is rendered with the data and sent to the client\n4. The client hydrates the page with `createBrowserRouter` and `RouterProvider`\n\n### Client-Side Navigation\n\nAfter the initial page load, navigation happens entirely on the client:\n\n1. React Router handles link clicks and form submissions\n2. Data is fetched asynchronously using loaders and actions\n3. A loading spinner is displayed during data fetching\n4. The UI updates without a full page reload\n\n### Data Flow\n\n1. **Topics**: Stored in SQLite with title and creation timestamp\n2. **Messages**: Linked to topics with content and creation timestamp\n3. **Search**: Queries both topics and messages, with results in the URL\n\n### URL Structure\n\n- `/` - Home page with list of topics\n- `/` - Create new topic\n- `/delete-all` - Delete all topics and messages\n- `/topics/:topicId` - View a topic and its messages\n- `/topics/:topicId/messages/:messageId` - Direct link to a message\n- `/search?q=query` - Search results\n\n\n## Implementation Details\n\nThis application demonstrates a \"Val Town fullstack framework\" approach, combining:\n\n- **Hono**: For server-side routing and handling\n- **React Router 7**: For both server and client-side routing\n- **SQLite**: For data persistence\n- **TypeScript**: For type safety across the stack\n\nThe code is structured to be idiomatic and simple, serving as a reference for building full-stack applications with React Router 7. The project uses a Remix-style file naming convention with co-located components, loaders, and actions in the `/routes` directory.",[],[420],{"_106":427,"_98":428,"_162":429,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":430,"_103":29,"_170":286,"_172":431,"_173":25,"_174":-5,"_175":432,"_102":433},"2aadd5d2-1645-11f0-b5a9-569c3dd06744","TODO.md","e6299794-a831-4673-84bd-a5afa6951f6f",["D",1744314677289],"- [ ] Get OpenTownie or Gemini or Claude or OpenAI to synthesize the core of these patterns into a prompt we can use to make more ReactRouter apps, such as...\n- [ ] Convert this or into the basic react router guest book (and preserve this forum app in another project?)\n- [ ] To what extent can these patterns be packaged up into a Val Town Router project? Would be neat to get the version pinning thing all centralized, can this as-a-library be that centralized place?",[],[428],{"_106":435,"_98":436,"_162":437,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":438,"_103":29,"_170":286,"_172":439,"_173":25,"_174":-5,"_175":440,"_102":441},"2aadd762-1645-11f0-b5a9-569c3dd06744","react-router-questions.md","ab61e678-0a4b-4250-a1e3-e820c7fc638c",["D",1744314677289],"# React Router Questions\n\nI have some questions about how to set up React Router 7 as a \"custom framework\". It seems like the documentation on this is mostly these two pages:\n\n1. Docs on React Router 7: [\"Custom Framework\"](https://reactrouter.com/start/data/custom)\n2. Example app on Github: [@remix-run/custom-react-router-framework-example](https://github.com/remix-run/custom-react-router-framework-example)\n\n## How I've set it up\n\n### Client loaders & actions\n\n[On the client, I turn loaders and actions into `fetch` calls to the backend.](https://www.val.town/x/stevekrouse/reactRouter7Example/code/shared/routes.ts) This is heavily inspired by the [here in the Github example](https://github.com/remix-run/custom-react-router-framework-example/blob/main/app/routes.tsx#L14-L29).\n\n### Handling client loader & action API calls on the server\n\n[On the client, I check if the Accept header is JSON and then return the loader or action data.](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L66-77) This is heavily inspired by the [here in the Github example](https://github.com/remix-run/custom-react-router-framework-example/blob/main/entry.server.tsx#L12-L22).\n\n### Questions\n\n### 1. Setting loader state for multiple loaders\n\nRight now I've converted every loader into its own fetch call. This is the opposite of what frameworks refer to as \"single fetch\". However on the backend, I actually get access the full loaderData for all nested routes. I even wrote [this silly function to combine all the loaderData objects into one big object](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L36-50).\n\nIdeally we should make a single loader call per navigation event, and set the internal router state. In other words, I would like to somehow reach into React Router and set this `state` here:\n\n![Screenshot 2025-04-10 at 15.03.32@2x.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/23997cd0-6e12-46b5-53d8-89e2fe5a9c00/public)\n\nAnd then let `useLoaderData` funnel the correct loader data's to the correct routes via their IDs.\n\n### 2. Action redirects\n\nWhen my backend returns a 302 from an action, how should I handle this on the frontend? For example, after you create a new topic on the home page, [I redirect you to that topic's ID](https://www.val.town/x/stevekrouse/reactRouter7Example/code/routes/Topics.action.ts#L13)\n\nHowever, I'm not sure how [to handle this on the client here](https://www.val.town/x/stevekrouse/reactRouter7Example/code/shared/routes.ts#L26).\n\nIdeally, I would do a proper React Router \"navigation\", and pass the relevant loader data along so it can be 100% client-side and require no other API calls.\n\n### 3. Should I use `queryRoute` instead of `query` in my server?\n\nThe [example app uses `queryRoute`](https://github.com/remix-run/custom-react-router-framework-example/blob/f5a141d67800e8da076cd1bb3130f29a8c0d4ce3/entry.server.tsx#L77-L79) instead of `query` for loaders and actions. I tried using that too but it didn't work. I think it returned undefined. I am now [using `query` for everything](https://www.val.town/x/stevekrouse/reactRouter7Example/code/backend/index.ts#L58).\n\nIs it better to use that or is my use of `query` fine? I get the feeling that `query` is doing a bunch of work I don't need, ie SRR, but maybe that's not very expensive so it's fine? I noticed [the example app uses `X-Route-ID`](https://github.com/remix-run/custom-react-router-framework-example/blob/main/app/layout.client.tsx#L8), so maybe I'd need to use that?",[],[436],"files",[159,177,183,192,202,212,218,224,232,240,248,256,264,272,281,290,299,305,312,320,328,337,345,353,361,369,377,385,394,400,409,418,426,434],"counts",{"_446":167,"_447":404,"_448":196,"_449":29},"pulls","branches","forks","envVars","contents",[452,455,458,461,464,467,470],{"_106":160,"_98":161,"_162":163,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":453,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_102":454},["D",1744314677289],[161],{"_106":213,"_98":214,"_162":215,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":456,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_102":457},["D",1744314677289],[214],{"_106":300,"_98":301,"_162":302,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":459,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_102":460},["D",1744314677289],[301],{"_106":395,"_98":396,"_162":397,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":462,"_103":29,"_170":171,"_172":-5,"_173":25,"_174":-5,"_102":463},["D",1744314677289],[396],{"_106":419,"_98":420,"_162":421,"_164":-5,"_165":145,"_166":144,"_168":121,"_108":465,"_103":125,"_170":286,"_172":423,"_173":25,"_174":-5,"_102":466},["D",1744314763898],[420],{"_106":427,"_98":428,"_162":429,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":468,"_103":29,"_170":286,"_172":431,"_173":25,"_174":-5,"_102":469},["D",1744314677289],[428],{"_106":435,"_98":436,"_162":437,"_164":-5,"_165":145,"_166":167,"_168":121,"_108":471,"_103":29,"_170":286,"_172":439,"_173":25,"_174":-5,"_102":472},["D",1744314677289],[436],"upstreamProject","upstreamBranch",{"_106":148,"_108":476,"_477":478,"_98":40,"_146":107,"_103":479,"_147":-5,"_149":-5,"_480":481,"_110":-5,"_156":25,"_112":113,"_155":97,"_14":126,"_154":99},["D",1744152661331],"updatedAt",["D",1751462022442],166,"lockfileKey","1755574565225-esm.town_v_stevekrouse_reactRouter7Example@166-main","emptyEnvVars","isNew","routes/_app.x.$handle.$name.compare.$branch",{"_96":97,"_98":99,"_100":101,"_104":486,"_491":492,"_493":494,"_495":496,"_565":121,"_566":490,"_567":568,"_571":572},{"_106":107,"_98":99,"_108":487,"_110":-5,"_111":25,"_112":113,"_114":115,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":123,"_124":125,"_14":126,"_127":128,"_129":128,"_130":131,"_132":131,"_133":131,"_134":128,"_135":128,"_19":488,"_139":489,"_142":490,"_156":25},["D",1744152661331],{"_96":97,"_137":138},{"_96":97,"_141":138},{"_103":144,"_98":101,"_106":145,"_146":107,"_147":148,"_149":150,"_151":113,"_152":107,"_153":126,"_154":99,"_155":97},"ahead",7,"behind",9,"diff",{"_497":498,"_173":507,"_508":509},"added",[499],{"_102":500,"_501":-7,"_502":503},"routes/DeleteAll.action.ts","targetFile","sourceFile",{"_106":313,"_98":314,"_162":315,"_164":302,"_165":145,"_166":125,"_168":121,"_108":316,"_103":29,"_170":188,"_172":317,"_173":25,"_174":-5,"_175":-7,"_102":504,"_505":506},[301,314],"contentHash","0041f923e5c3fcea1f95359207218cc5c306371cddb70d32d237d21a59925aaf",[],"modified",[510,522,536,550],{"_102":420,"_501":511,"_502":519},{"_106":512,"_98":420,"_162":513,"_164":-5,"_165":148,"_166":514,"_168":121,"_108":515,"_103":125,"_170":286,"_172":516,"_173":25,"_174":-5,"_175":-7,"_102":517,"_505":518},"d5a32784-163c-11f0-a89b-569c3dd06744","513e59ca-14cd-11f0-8f60-569c3dd06744",142,["D",1744311098646],"# Community Message Board\n\nA simple community message board application built with React Router 7, demonstrating a full-stack approach with server-side rendering and client-side navigation.\n\n## Features\n\n- **Server-Side Rendering**: All pages are server-rendered when accessed directly\n- **Client-Side Navigation**: After initial load, navigation happens client-side\n- **Topic Management**: Create and view discussion topics\n- **Messaging System**: Post messages in topics\n- **Direct Message Links**: Link directly to specific messages via timestamps\n- **Search Functionality**: Search topics and messages with URL parameters\n- **Loading Indicators**: Visual feedback during async operations\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database queries\n│ └── index.ts # Server entry point\n├── frontend/\n│ ├── components/\n│ │ ├── LoadingSpinner.tsx\n│ │ ├── MessageForm.tsx\n│ │ ├── MessageList.tsx\n│ │ └── SearchForm.tsx\n│ ├── index.html # HTML template\n│ └── index.tsx # Client entry point\n├── routes/\n│ ├── App.tsx # Main application component\n│ ├── Home.tsx # Home page component\n│ ├── Home.loader.ts # Home page data loader\n│ ├── Topic.tsx # Topic detail component\n│ ├── Topic.loader.ts # Topic data loader\n│ ├── Topic.action.ts # Topic message creation action\n│ ├── TopicMessage.loader.ts # Direct message link loader\n│ ├── Topics.action.ts # Topic creation action\n│ ├── Search.tsx # Search results component\n│ └── Search.loader.ts # Search data loader\n└── shared/\n ├── routes.ts # Route definitions\n └── types.ts # Shared TypeScript types\n```\n\n## How It Works\n\n### Server-Side Rendering\n\nThe application uses React Router 7's `createStaticHandler`, `createStaticRouter`, and `StaticRouterProvider` to render pages on the server. When a user directly accesses a URL:\n\n1. The server receives the request\n2. It runs the appropriate loaders/actions for the matched route\n3. The page is rendered with the data and sent to the client\n4. The client hydrates the page with `createBrowserRouter` and `RouterProvider`\n\n### Client-Side Navigation\n\nAfter the initial page load, navigation happens entirely on the client:\n\n1. React Router handles link clicks and form submissions\n2. Data is fetched asynchronously using loaders and actions\n3. A loading spinner is displayed during data fetching\n4. The UI updates without a full page reload\n\n### Data Flow\n\n1. **Topics**: Stored in SQLite with title and creation timestamp\n2. **Messages**: Linked to topics with content and creation timestamp\n3. **Search**: Queries both topics and messages, with results in the URL\n\n### URL Structure\n\n- `/` - Home page with list of topics\n- `/` - Create new topic\n- `/topics/:topicId` - View a topic and its messages\n- `/topics/:topicId/messages/:messageId` - Direct link to a message\n- `/search?q=query` - Search results\n\n\n## Implementation Details\n\nThis application demonstrates a \"Val Town fullstack framework\" approach, combining:\n\n- **Hono**: For server-side routing and handling\n- **React Router 7**: For both server and client-side routing\n- **SQLite**: For data persistence\n- **TypeScript**: For type safety across the stack\n\nThe code is structured to be idiomatic and simple, serving as a reference for building full-stack applications with React Router 7. The project uses a Remix-style file naming convention with co-located components, loaders, and actions in the `/routes` directory.",[420],"4083c48457414eddab0c1faf617d75e0c2b26318935420a11052a1aa1cb6053d",{"_106":419,"_98":420,"_162":421,"_164":-5,"_165":145,"_166":144,"_168":121,"_108":422,"_103":125,"_170":286,"_172":423,"_173":25,"_174":-5,"_175":-7,"_102":520,"_505":521},[420],"a0cebd633750cf4f2effc378c36276e38f93da190672662400c05031fd4133db",{"_102":523,"_501":524,"_502":533},"backend/database/queries.ts",{"_106":525,"_98":194,"_162":526,"_164":527,"_165":148,"_166":528,"_168":121,"_108":529,"_103":196,"_170":188,"_172":530,"_173":25,"_174":-5,"_175":-7,"_102":531,"_505":532},"badc7172-14ce-11f0-8c0e-569c3dd06744","6229805c-14cd-11f0-800b-569c3dd06744","4af61b55-4e6e-48ee-bb08-a35baadaf267",28,["D",1744153857922],"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}",[161,179,194],"ae2892a1e08069217dcccbf55a36f7366ca1be69c9a6b753161f5250972fb970",{"_106":193,"_98":194,"_162":195,"_164":180,"_165":145,"_166":196,"_168":121,"_108":197,"_103":167,"_170":188,"_172":198,"_173":25,"_174":-5,"_175":-7,"_102":534,"_505":535},[161,179,194],"b9887ca23c052dc32004797e443fefe490e6060a80709ac39734472256df5be4",{"_102":537,"_501":538,"_502":547},"routes/Home.tsx",{"_106":539,"_98":330,"_162":540,"_164":541,"_165":148,"_166":542,"_168":121,"_108":543,"_103":332,"_170":188,"_172":544,"_173":25,"_174":-5,"_175":-7,"_102":545,"_505":546},"3d47a160-163f-11f0-809e-569c3dd06744","f8ffb6d8-1593-11f0-9dd6-569c3dd06744","c4795b2d-41e5-4e2d-bb49-1239d72d4d2d",150,["D",1744312131524],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n Link,\n useLoaderData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\nimport { Topic } from \"../shared/types.ts\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function Home() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/\" && navigation.state === \"submitting\";\n let $form = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

Create a New Topic

\n \n

\n\n

Topics

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

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

\n )\n : (\n

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

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

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

\n ))}\n

\n )}\n

\n );\n}",[301,330],"7a749545db18471da0f260e2651858b5cca7ce7c3d426e4a9edbe88ce1f0b862",{"_106":329,"_98":330,"_162":331,"_164":302,"_165":145,"_166":332,"_168":121,"_108":333,"_103":167,"_170":188,"_172":334,"_173":25,"_174":-5,"_175":-7,"_102":548,"_505":549},[301,330],"e9b435b373570ef5f50025139d92dbe8e12768cba96c7e3e0cb76fe75b7d9c5d",{"_102":551,"_501":552,"_502":562},"shared/routes.ts",{"_106":553,"_98":402,"_162":554,"_164":555,"_165":148,"_166":556,"_168":121,"_108":557,"_103":558,"_170":188,"_172":559,"_173":25,"_174":-5,"_175":-7,"_102":560,"_505":561},"2eaa3540-163b-11f0-ade2-569c3dd06744","7639f8f6-14d2-11f0-97d5-569c3dd06744","add21c84-9f00-4405-af88-6ec5134089df",129,["D",1744310389015],27,"import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { App } from \"../routes/App.tsx\";\nimport { Home } from \"../routes/Home.tsx\";\nimport { Search } from \"../routes/Search.tsx\";\nimport { Topic } from \"../routes/Topic.tsx\";\n\nlet isServer = typeof document === \"undefined\";\nlet isClient = !isServer;\n\n// Generic loader that forwards on requests for that page's JSON data\nfunction clientLoader({ request }: LoaderFunctionArgs) {\n return fetch(request, {\n headers: {\n \"Accept\": \"application/json\",\n },\n }).then(res => res.json());\n}\n\n// Generic action that forwards on requests for that page\nasync function clientAction({ request }: ActionFunctionArgs) {\n const response = await fetch(request);\n if (response.status === 302) {\n // somehow do a redirect\n }\n // if the response is json content type, parse the json and return it\n if (response.headers.get(\"Content-Type\")?.includes(\"application/json\")) {\n return response.json();\n }\n return response;\n}\n\nfunction createFullstackLoader(loaderSourceImportURL: string) {\n if (isClient) {\n return clientLoader;\n } else {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(loaderSourceImportURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n}\n\nfunction createFullstackAction(actionSourceImportURL: string) {\n if (isClient) {\n return clientAction;\n } else {\n return async (args: ActionFunctionArgs) => {\n let module = await import(actionSourceImportURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: createFullstackAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: createFullstackLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"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];",[396,402],"2c7476aae99c15986c84bd42d8d91077a61cf4412c775d4e5ce780eb7cd26a07",{"_106":401,"_98":402,"_162":403,"_164":397,"_165":145,"_166":404,"_168":121,"_108":405,"_103":167,"_170":188,"_172":406,"_173":25,"_174":-5,"_175":-7,"_102":563,"_505":564},[396,402],"45fc35f9219d4b6ad2ea5d5353d6c9755ecd205d8ec2193435d0d1ecd93ce1b0","hasChanges","sourceBranch","targetBranch",{"_106":148,"_108":569,"_477":570,"_98":40,"_146":107,"_103":479,"_147":-5,"_149":-5,"_480":481,"_110":-5,"_156":25,"_112":113,"_155":97,"_14":126,"_154":99},["D",1744152661331],["D",1751462022442],"pull",{"_106":573,"_114":71,"_574":575},"240e6ab0-1646-11f0-871b-569c3dd06744","state","pending","routes/_app","actionData","errors"]

Mergedelete-buttonintomain

README.md+3-0

backend/database/queries.ts+18-0

routes/Home.tsx+26-1

shared/routes.ts+4-0

routes/DeleteAll.action.ts+16-0