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}",[],[126,156],"0ab2cdd8-1635-11f0-88d0-569c3dd06744","Topic.loader.ts","924a052e-4283-42cb-ac11-fd7ea346c683",["D",1744307751648],"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}",[],[126,163],"0ab2cc0c-1635-11f0-88d0-569c3dd06744","Topic.action.ts","f4f398fb-a1d4-4774-a4eb-c6e73595db3e",["D",1744307751648],"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}",[],[126,170],"0ab2c7e8-1635-11f0-88d0-569c3dd06744","Search.tsx","1a17b0d2-55b7-43b3-9cd0-5da66c9dd3c8",["D",1744307751648],"/** @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}",[],[126,177],"0ab2c5fe-1635-11f0-88d0-569c3dd06744","Search.loader.ts","cf07e02b-a707-4369-b79b-f066dcb8c1bf",["D",1744307751648],"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}",[],[126,184],"0ab2c0fe-1635-11f0-88d0-569c3dd06744","Home.tsx","33c8d850-decb-400c-8320-e7b170914d46",["D",1744307751648],"/** @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 === \"/\" && 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}",[],[126,191],"0ab2bf82-1635-11f0-88d0-569c3dd06744","Home.loader.ts","99f6dc16-540e-4a1a-87ab-f98889fcd7f9",["D",1744307751648],"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}",[],[126,198],"0ab2bdd4-1635-11f0-88d0-569c3dd06744","App.tsx","989077a5-29e0-4fec-9803-0336f413f523",["D",1744307751648],"/** @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}",[],[126,205],"0ab2bc44-1635-11f0-88d0-569c3dd06744","frontend","d76c8bfb-5415-496d-a27a-4b01a56f8a15",["D",1744307751648],[217,218,219],[212],{"_36":234,"_13":235,"_63":236,"_65":213,"_67":68,"_69":70,"_71":72,"_38":237,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":238,"_18":239},{"_36":227,"_13":228,"_63":229,"_65":213,"_67":68,"_69":70,"_71":72,"_38":230,"_17":74,"_75":24,"_77":231,"_79":51,"_80":-5,"_104":232,"_18":233},{"_36":220,"_13":221,"_63":222,"_65":213,"_67":68,"_69":70,"_71":72,"_38":223,"_17":74,"_75":76,"_77":224,"_79":51,"_80":-5,"_104":225,"_18":226},"0ab2ba78-1635-11f0-88d0-569c3dd06744","index.tsx","b6e3326e-240e-4e8a-83c5-d00695f27583",["D",1744307751648],"/** @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);",[],[212,221],"0ab2b8b6-1635-11f0-88d0-569c3dd06744","index.html","c78175c9-3ff2-4b4d-899f-ccba0a2405d4",["D",1744307751648],"\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[212,228],"0ab2b6e0-1635-11f0-88d0-569c3dd06744","components","2fbfe479-4d69-45e9-ab6d-390471275e4c",["D",1744307751648],[240,241,242,243,244,245,246,247],[212,235],{"_36":297,"_13":205,"_63":298,"_65":236,"_67":68,"_69":70,"_71":72,"_38":299,"_17":74,"_75":76,"_77":300,"_79":51,"_80":-5,"_104":301,"_18":302},{"_36":290,"_13":291,"_63":292,"_65":236,"_67":68,"_69":70,"_71":72,"_38":293,"_17":74,"_75":76,"_77":294,"_79":51,"_80":-5,"_104":295,"_18":296},{"_36":283,"_13":284,"_63":285,"_65":236,"_67":68,"_69":70,"_71":72,"_38":286,"_17":74,"_75":76,"_77":287,"_79":51,"_80":-5,"_104":288,"_18":289},{"_36":276,"_13":277,"_63":278,"_65":236,"_67":68,"_69":70,"_71":72,"_38":279,"_17":74,"_75":76,"_77":280,"_79":51,"_80":-5,"_104":281,"_18":282},{"_36":269,"_13":270,"_63":271,"_65":236,"_67":68,"_69":70,"_71":72,"_38":272,"_17":74,"_75":76,"_77":273,"_79":51,"_80":-5,"_104":274,"_18":275},{"_36":262,"_13":263,"_63":264,"_65":236,"_67":68,"_69":70,"_71":72,"_38":265,"_17":74,"_75":76,"_77":266,"_79":51,"_80":-5,"_104":267,"_18":268},{"_36":255,"_13":256,"_63":257,"_65":236,"_67":68,"_69":70,"_71":72,"_38":258,"_17":74,"_75":76,"_77":259,"_79":51,"_80":-5,"_104":260,"_18":261},{"_36":248,"_13":249,"_63":250,"_65":236,"_67":68,"_69":70,"_71":72,"_38":251,"_17":74,"_75":76,"_77":252,"_79":51,"_80":-5,"_104":253,"_18":254},"0ab2b294-1635-11f0-88d0-569c3dd06744","TopicList.tsx","fd46be0c-babd-44d5-89ee-92a3b3fa3063",["D",1744307751648],"/** @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 === \"/\" && 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}",[],[212,235,249],"0ab2ae98-1635-11f0-88d0-569c3dd06744","TopicDetail.tsx","fb6d6eb8-e971-4fe5-8cee-3d52df35f547",["D",1744307751648],"/** @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}",[],[212,235,256],"0ab2aa92-1635-11f0-88d0-569c3dd06744","SearchResults.tsx","fd03b760-8b50-4779-8afc-697fb1a498c5",["D",1744307751648],"/** @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}",[],[212,235,263],"0ab2a8e4-1635-11f0-88d0-569c3dd06744","SearchForm.tsx","ac3cd8a7-1835-4184-9c75-70407efec351",["D",1744307751648],"/** @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}",[],[212,235,270],"0ab2a72c-1635-11f0-88d0-569c3dd06744","MessageList.tsx","83461ee7-9b42-40b5-a0f0-1269d8fe8686",["D",1744307751648],"/** @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}",[],[212,235,277],"0ab2a54c-1635-11f0-88d0-569c3dd06744","MessageForm.tsx","59f2303b-6825-4158-871a-20abe33c9512",["D",1744307751648],"/** @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}",[],[212,235,284],"0ab2a3a8-1635-11f0-88d0-569c3dd06744","LoadingSpinner.tsx","27c3ac66-48f9-4a36-9bec-ed6ece96abac",["D",1744307751648],"/** @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}",[],[212,235,291],"0ab2a13c-1635-11f0-88d0-569c3dd06744","f4081814-1319-44b5-b8e6-da42eec16349",["D",1744307751648],"/** @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}",[],[212,235,205],"0ab29da4-1635-11f0-88d0-569c3dd06744","backend","6d387cf0-55c5-416d-a08d-3dfe1bbd0c62",["D",1744307751648],[309,310],[304],{"_36":320,"_13":321,"_63":322,"_65":305,"_67":68,"_69":70,"_71":72,"_38":323,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":324,"_18":325},{"_36":311,"_13":312,"_63":313,"_65":305,"_67":68,"_69":314,"_71":72,"_38":315,"_17":70,"_75":316,"_77":317,"_79":51,"_80":-5,"_104":318,"_18":319},"b989d602-1636-11f0-b95a-569c3dd06744","index.ts","cd9aa321-60bf-40d6-b555-63e36ebc3a12",4,["D",1744308474521],"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// LoaderData returns a map of loaderDatas for all matched loaders by an internal\n// id representation that looks like \"0-0\" and \"0-1\"\n// Some context: https://github.com/remix-run/react-router/blob/a3e4b8ed875611637357647fcf862c2bc61f4e11/packages/react-router/lib/hooks.tsx#L1093\n// This function combines all loader datas into a single object, which isn't technically correct, but might get us\n// pretty far.\n// Ultimately what we want is to only make one loader call for a new page navigation and then set the `state`\n// all at once with this exact object, and then have react router take care of sending the apprioriate state\n// to all the useLoaderDatas\nfunction parseData(data: any) {\n const entries = Object.values(data)\n .filter(Boolean)\n .flatMap((value: any) => Object.entries(value));\n return Object.fromEntries(entries);\n}\n\n// Handle all other routes with React Router\napp.all(\"*\", async (c) => {\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 console.log(context);\n\n if (\n c.req.header(\"Accept\") === \"application/json\"\n ) {\n // in theory we should use `queryRoute` for this, like here:\n // https://github.com/remix-run/custom-react-router-framework-example/blob/f5a141d67800e8da076cd1bb3130f29a8c0d4ce3/entry.server.tsx#L79\n // but i wasn't able to get that to work in my rewrite-server branch\n // maybe it depends on X-Route-Id?\n return Response.json(context.loaderData);\n } else if (c.req.header(\"Content-Type\")?.includes(\"application/x-www-form-urlencoded\"))\n {\n return Response.json(context.actionData);\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;",[],[304,312],"0ab285d0-1635-11f0-88d0-569c3dd06744","database","61502f22-d0c0-4f25-84cd-a4692a0d4b37",["D",1744307751648],[326,327],[304,321],{"_36":335,"_13":336,"_63":337,"_65":322,"_67":68,"_69":70,"_71":72,"_38":338,"_17":74,"_75":76,"_77":339,"_79":51,"_80":-5,"_104":340,"_18":341},{"_36":328,"_13":329,"_63":330,"_65":322,"_67":68,"_69":70,"_71":72,"_38":331,"_17":74,"_75":76,"_77":332,"_79":51,"_80":-5,"_104":333,"_18":334},"0ab280bc-1635-11f0-88d0-569c3dd06744","queries.ts","f7d8a933-6f37-4a8c-abc1-5b10093cde29",["D",1744307751648],"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}",[],[304,321,329],"0ab2775c-1635-11f0-88d0-569c3dd06744","migrations.ts","171f7848-30d5-4d89-b69c-5f7acac936ba",["D",1744307751648],"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}",[],[304,321,336],"0aab7c72-1635-11f0-88d0-569c3dd06744",["D",1744307751648],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","19892fed-baf3-41fb-a5cc-96c80e95edec","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","f407f111-fdbb-4126-923f-44aed4d9e9ad","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_385":381},"org",{"_11":12,"_379":-5,"_380":381,"_348":349,"_382":383,"_384":51},"branch",{"_17":314,"_13":16,"_36":68,"_42":342,"_45":37,"_46":375,"_376":53,"_377":43,"_378":57,"_58":14,"_54":12},114,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7935dc1b-7699-4095-366a-2e9103307501/square512?exp=1789585199&sig=1140b03e10bb10cbbc5fc52fea03e51f88c015ceaa8ce18e41e3898ea5efb3b1","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":342,"_13":14,"_38":525,"_49":-5,"_344":51,"_52":53,"_345":53,"_346":-5,"_347":-5,"_348":349,"_350":313,"_351":72,"_352":-5,"_353":314,"_354":70,"_56":355,"_356":-5,"_357":-5,"_358":-5,"_359":-5,"_360":361,"_362":361,"_363":364,"_365":364,"_366":364,"_367":361,"_368":361,"_369":526,"_371":527,"_373":528,"_50":51},[426,431,443,454,457,458],"files",[426,427,428,429,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],"counts",{"_417":74,"_418":70,"_419":70,"_35":420,"_421":422},[413,414],{"_36":89,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":90,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_18":412},"upstreamProject",{"_36":43,"_13":14,"_346":409,"_347":-5,"_52":53,"_369":410},"upstreamBranch",{"_36":37,"_38":407,"_40":408,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744152661331],["D",1771761464050],"Full-stack example ReactRouter7 project",{"_11":55,"_385":411},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",[19],{"_36":82,"_13":83,"_63":84,"_65":66,"_67":68,"_69":32,"_71":72,"_38":85,"_17":86,"_75":76,"_77":87,"_79":51,"_80":-5,"_18":416},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":73,"_17":74,"_75":76,"_77":78,"_79":51,"_80":-5,"_18":415},[19,62],[19,83],"pulls","branches","forks",{"_423":74,"_425":74},"connections",{"_423":74,"_424":74},"count","unfilledCount","emptyCount",{"_36":303,"_13":304,"_63":305,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":306,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":523,"_18":524},{"_36":320,"_13":321,"_63":322,"_65":305,"_67":68,"_69":70,"_71":72,"_38":323,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":521,"_18":522},{"_36":335,"_13":336,"_63":337,"_65":322,"_67":68,"_69":70,"_71":72,"_38":338,"_17":74,"_75":76,"_77":339,"_79":51,"_80":-5,"_104":519,"_18":520},{"_36":328,"_13":329,"_63":330,"_65":322,"_67":68,"_69":70,"_71":72,"_38":331,"_17":74,"_75":76,"_77":332,"_79":51,"_80":-5,"_104":517,"_18":518},{"_36":311,"_13":312,"_63":313,"_65":305,"_67":68,"_69":314,"_71":72,"_38":315,"_17":70,"_75":316,"_77":317,"_79":51,"_80":-5,"_104":515,"_18":516},{"_36":211,"_13":212,"_63":213,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":214,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":513,"_18":514},{"_36":234,"_13":235,"_63":236,"_65":213,"_67":68,"_69":70,"_71":72,"_38":237,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":511,"_18":512},{"_36":297,"_13":205,"_63":298,"_65":236,"_67":68,"_69":70,"_71":72,"_38":299,"_17":74,"_75":76,"_77":300,"_79":51,"_80":-5,"_104":509,"_18":510},{"_36":290,"_13":291,"_63":292,"_65":236,"_67":68,"_69":70,"_71":72,"_38":293,"_17":74,"_75":76,"_77":294,"_79":51,"_80":-5,"_104":507,"_18":508},{"_36":283,"_13":284,"_63":285,"_65":236,"_67":68,"_69":70,"_71":72,"_38":286,"_17":74,"_75":76,"_77":287,"_79":51,"_80":-5,"_104":505,"_18":506},{"_36":276,"_13":277,"_63":278,"_65":236,"_67":68,"_69":70,"_71":72,"_38":279,"_17":74,"_75":76,"_77":280,"_79":51,"_80":-5,"_104":503,"_18":504},{"_36":269,"_13":270,"_63":271,"_65":236,"_67":68,"_69":70,"_71":72,"_38":272,"_17":74,"_75":76,"_77":273,"_79":51,"_80":-5,"_104":501,"_18":502},{"_36":262,"_13":263,"_63":264,"_65":236,"_67":68,"_69":70,"_71":72,"_38":265,"_17":74,"_75":76,"_77":266,"_79":51,"_80":-5,"_104":499,"_18":500},{"_36":255,"_13":256,"_63":257,"_65":236,"_67":68,"_69":70,"_71":72,"_38":258,"_17":74,"_75":76,"_77":259,"_79":51,"_80":-5,"_104":497,"_18":498},{"_36":248,"_13":249,"_63":250,"_65":236,"_67":68,"_69":70,"_71":72,"_38":251,"_17":74,"_75":76,"_77":252,"_79":51,"_80":-5,"_104":495,"_18":496},{"_36":227,"_13":228,"_63":229,"_65":213,"_67":68,"_69":70,"_71":72,"_38":230,"_17":74,"_75":24,"_77":231,"_79":51,"_80":-5,"_104":493,"_18":494},{"_36":220,"_13":221,"_63":222,"_65":213,"_67":68,"_69":70,"_71":72,"_38":223,"_17":74,"_75":76,"_77":224,"_79":51,"_80":-5,"_104":491,"_18":492},{"_36":125,"_13":126,"_63":127,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":128,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":489,"_18":490},{"_36":204,"_13":205,"_63":206,"_65":127,"_67":68,"_69":70,"_71":72,"_38":207,"_17":74,"_75":76,"_77":208,"_79":51,"_80":-5,"_104":487,"_18":488},{"_36":197,"_13":198,"_63":199,"_65":127,"_67":68,"_69":70,"_71":72,"_38":200,"_17":74,"_75":76,"_77":201,"_79":51,"_80":-5,"_104":485,"_18":486},{"_36":190,"_13":191,"_63":192,"_65":127,"_67":68,"_69":70,"_71":72,"_38":193,"_17":74,"_75":76,"_77":194,"_79":51,"_80":-5,"_104":483,"_18":484},{"_36":183,"_13":184,"_63":185,"_65":127,"_67":68,"_69":70,"_71":72,"_38":186,"_17":74,"_75":76,"_77":187,"_79":51,"_80":-5,"_104":481,"_18":482},{"_36":176,"_13":177,"_63":178,"_65":127,"_67":68,"_69":70,"_71":72,"_38":179,"_17":74,"_75":76,"_77":180,"_79":51,"_80":-5,"_104":479,"_18":480},{"_36":169,"_13":170,"_63":171,"_65":127,"_67":68,"_69":70,"_71":72,"_38":172,"_17":74,"_75":76,"_77":173,"_79":51,"_80":-5,"_104":477,"_18":478},{"_36":162,"_13":163,"_63":164,"_65":127,"_67":68,"_69":70,"_71":72,"_38":165,"_17":74,"_75":76,"_77":166,"_79":51,"_80":-5,"_104":475,"_18":476},{"_36":155,"_13":156,"_63":157,"_65":127,"_67":68,"_69":70,"_71":72,"_38":158,"_17":74,"_75":76,"_77":159,"_79":51,"_80":-5,"_104":473,"_18":474},{"_36":148,"_13":149,"_63":150,"_65":127,"_67":68,"_69":70,"_71":72,"_38":151,"_17":74,"_75":76,"_77":152,"_79":51,"_80":-5,"_104":471,"_18":472},{"_36":141,"_13":142,"_63":143,"_65":127,"_67":68,"_69":70,"_71":72,"_38":144,"_17":74,"_75":76,"_77":145,"_79":51,"_80":-5,"_104":469,"_18":470},{"_36":89,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":114,"_17":74,"_75":91,"_77":-5,"_79":51,"_80":-5,"_104":467,"_18":468},{"_36":82,"_13":83,"_63":84,"_65":66,"_67":68,"_69":32,"_71":72,"_38":122,"_17":86,"_75":76,"_77":87,"_79":51,"_80":-5,"_104":465,"_18":466},{"_36":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_38":119,"_17":74,"_75":76,"_77":78,"_79":51,"_80":-5,"_104":463,"_18":464},{"_36":107,"_13":108,"_63":109,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":110,"_17":74,"_75":24,"_77":111,"_79":51,"_80":-5,"_104":461,"_18":462},{"_36":99,"_13":100,"_63":101,"_65":-5,"_67":68,"_69":70,"_71":72,"_38":102,"_17":74,"_75":24,"_77":103,"_79":51,"_80":-5,"_104":459,"_18":460},[],[100],[],[108],[],[19,62],[],[19,83],[455,456],[19],[],[126,142],[],[126,149],[],[126,156],[],[126,163],[],[126,170],[],[126,177],[],[126,184],[],[126,191],[],[126,198],[],[126,205],[444,445,446,447,448,449,450,451,452,453],[126],[],[212,221],[],[212,228],[],[212,235,249],[],[212,235,256],[],[212,235,263],[],[212,235,270],[],[212,235,277],[],[212,235,284],[],[212,235,291],[],[212,235,205],[433,434,435,436,437,438,439,440],[212,235],[432,441,442],[212],[],[304,312],[],[304,321,329],[],[304,321,336],[428,429],[304,321],[427,430],[304],["D",1744307751648],{"_11":12,"_385":381},{"_11":12,"_379":-5,"_380":381,"_348":349,"_382":383,"_384":51},{"_17":314,"_13":16,"_36":68,"_42":342,"_45":37,"_46":375,"_376":53,"_377":43,"_378":57,"_58":14,"_54":12},"ctx",{"_369":-5,"_404":562,"_563":564,"_565":566,"_567":51,"_568":51,"_569":51,"_570":72,"_571":-5,"_572":-7,"_573":-7,"_574":74,"_575":51,"_576":51,"_577":-5,"_578":51,"_579":51,"_580":51,"_581":-5},"ENV",{"_533":534,"_535":536,"_537":16,"_538":539,"_540":541,"_542":543,"_544":545,"_546":547,"_548":549,"_550":551,"_552":553,"_554":555,"_556":557,"_558":559,"_560":561},"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"]