[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_462":463,"_464":465},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_113":95,"_33":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":131,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":-5,"_63":31,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",97,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","e084d104-3f20-411c-981d-8fcd76aef6c7","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","server.ts","latestPath","fileId","d8e1fa70-0ff0-11f1-8a19-42dde27851f2","name","fileType","script","content","/**\n * @valtown/react-router - Server\n *\n * createApp() wires together Hono (HTTP routing, static files) and\n * React Router (page routing, SSR, loaders/actions) so the user doesn't have to.\n */\n\nimport { 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 type { AppOptions } from \"./types.ts\";\n\n/**\n * Build the HTML shell for SSR.\n */\nfunction buildHtml(\n appHtml: string,\n hydrationData: any,\n clientScriptUrl: string,\n options: AppOptions,\n): string {\n const rootId = options.rootId || \"root\";\n const head = options.head || \"\";\n\n return `\n\n\n \n \n \n ${head}\n\n\n

${appHtml}

\n \n \n\n`;\n}\n\n/**\n * Create the app handler.\n *\n * @param options - App configuration\n * @returns A fetch handler: (req: Request) => Promise\n *\n * @example\n * ```ts\n * import { createApp, defineRoutes } from \"https://esm.town/v/stevekrouse/react-router/mod.ts\";\n * import { Home } from \"./routes/Home.tsx\";\n *\n * // Must be a named export so the client can import it\n * export const routes = defineRoutes([\n * { path: \"/\", Component: Home },\n * ]);\n *\n * export default createApp({ routes });\n * ```\n */\nexport function createApp(\n options: AppOptions,\n): (req: Request) => Promise {\n const app = new Hono();\n // --- Static file serving ---\n // All project source files are served under /__src/ so the browser can import them.\n // This avoids conflicts with React Router page routes.\n app.get(\"/__src/*\", async (c) => {\n // Strip the /__src prefix to get the actual file path\n const filePath = c.req.path.replace(\"/__src\", \"\");\n\n const { serveFile } = await import(\"https://esm.town/v/std/utils/index.ts\");\n const resp = await serveFile(filePath);\n\n // Fix MIME type for extensionless files (e.g. jsx-runtime from @jsxImportSource).\n // The browser requires a valid JS MIME type for module scripts.\n const ct = resp.headers.get(\"Content-Type\") || \"\";\n if (!ct || ct === \"application/octet-stream\" || ct.startsWith(filePath)) {\n return new Response(resp.body, {\n status: resp.status,\n headers: {\n ...Object.fromEntries(resp.headers.entries()),\n \"Content-Type\": \"application/javascript\",\n },\n });\n }\n return resp;\n });\n\n // --- Library files served under /__lib/ ---\n app.get(\"/__lib/client-runtime.ts\", async (c) => {\n const { serveFile } = await import(\"https://esm.town/v/std/utils/index.ts\");\n return serveFile(\"/client-runtime.ts\", import.meta.url);\n });\n app.get(\"/__lib/routes.ts\", async (c) => {\n const { serveFile } = await import(\"https://esm.town/v/std/utils/index.ts\");\n return serveFile(\"/routes.ts\", import.meta.url);\n });\n app.get(\"/__lib/types.ts\", async (c) => {\n const { serveFile } = await import(\"https://esm.town/v/std/utils/index.ts\");\n return serveFile(\"/types.ts\", import.meta.url);\n });\n\n // Serve the generated client bootstrap script.\n app.get(\"/__client.js\", (c) => {\n // Resolve the routes file path for the client to import.\n // If routesFile is provided, use it directly as a /__src/ path.\n // Otherwise, derive from VALTOWN_ENTRYPOINT.\n let routesSrc: string;\n if (options.routesFile) {\n // Normalize: strip leading \"./\" if present\n const cleaned = options.routesFile.replace(/^\\.\\//, \"\");\n routesSrc = `/__src/${cleaned}`;\n } else {\n // VALTOWN_ENTRYPOINT is a full esm.town URL like:\n // https://esm.town/v/handle/valName@version-branch/path/to/file.tsx\n // We need to extract just the project-relative path, e.g. \"/path/to/file.tsx\"\n const entrypoint = Deno.env.get(\"VALTOWN_ENTRYPOINT\") || \"\";\n const pathname = new URL(entrypoint).pathname;\n // Strip /v/handle/valName@version-branch prefix to get project-relative path\n const match = pathname.match(/^\\/v\\/[^/]+\\/[^/]+\\/(.*)/);\n const relativePath = match ? `/${match[1]}` : pathname;\n routesSrc = `/__src${relativePath}`;\n }\n\n const script = `\nimport { hydrate } from \"/__lib/client-runtime.ts\";\nimport { routes } from \"${routesSrc}\";\nhydrate(routes, \"${options.rootId || \"root\"}\");\n`;\n return c.body(script, {\n headers: { \"Content-Type\": \"application/javascript\" },\n });\n });\n\n // --- User escape hatch: Hono-level setup ---\n if (options.setup) {\n options.setup(app);\n }\n\n // --- React Router SSR ---\n const { query, dataRoutes } = createStaticHandler(options.routes);\n\n app.all(\"*\", async (c) => {\n const isDataRequest = c.req.header(\"X-Data-Request\") === \"true\";\n\n // Run loaders/actions on the server\n const context = await query(c.req.raw);\n\n // Direct Response (e.g., redirect from an action, or API route returning Response)\n if (context instanceof Response) {\n if (isDataRequest && context.status >= 300 && context.status < 400) {\n return Response.json({ redirect: context.headers.get(\"Location\") });\n }\n return context;\n }\n\n // Data-only request (client-side navigation)\n if (isDataRequest) {\n return Response.json({\n loaderData: context.loaderData,\n actionData: context.actionData,\n });\n }\n\n // Full SSR render\n const router = createStaticRouter(dataRoutes, context);\n\n // hydrate=false: we inject hydration data ourselves outside the root div,\n // so StaticRouterProvider shouldn't inject its own \n \n `,\n});\n",[],[196,284,286],"33943a90-0ff7-11f1-b2d2-42dde27851f2","33943b58-0ff7-11f1-b2d2-42dde27851f2",76,["D",1771768982178],"# Message Board Demo\n\nA fullstack community message board built with the [vtrr](../../README.md) framework — demonstrating nested routes, server loaders/actions, SQLite persistence, search, and client-side navigation.\n\n**[▶ Live Demo](https://stevekrouse--6b73cc240ff611f1876e42dde27851f2.web.val.run)**\n\n## Features\n\n- **Topics** — browse, create, and view discussion threads\n- **Messages** — post messages in topics with optimistic form resets\n- **Search** — full-text search across topics and messages with deep-link to individual messages\n- **SSR + Hydration** — pages render on the server, then hydrate for instant client-side transitions\n- **SQLite persistence** — data lives in Val Town's built-in SQLite, seeded with sample data on first run\n\n## Route Map\n\n```mermaid\ngraph TD\n Root[\"/ — App layout\"] --> Home[\"index — Home\"]\n Root --> Topic[\"/topics/:topicId — Topic\"]\n Root --> TopicMsg[\"/topics/:topicId/messages/:messageId — Topic (highlighted)\"]\n Root --> Search[\"/search?q=... — Search\"]\n\n Home -- \"loader\" --> HL[\"Home.loader.ts → getAllTopics()\"]\n Root -- \"action\" --> TA[\"Topics.action.ts → createTopic() → redirect\"]\n\n Topic -- \"loader\" --> TL[\"Topic.loader.ts → getTopic + getMessages\"]\n Topic -- \"action\" --> TAct[\"Topic.action.ts → createMessage()\"]\n\n TopicMsg -- \"loader\" --> TML[\"TopicMessage.loader.ts → getTopic + getMessages\"]\n\n Search -- \"loader\" --> SL[\"Search.loader.ts → search()\"]\n\n style Root fill:#e0e7ff,stroke:#4f46e5\n style Home fill:#dbeafe,stroke:#2563eb\n style Topic fill:#dbeafe,stroke:#2563eb\n style TopicMsg fill:#dbeafe,stroke:#2563eb\n style Search fill:#dbeafe,stroke:#2563eb\n style HL fill:#d1fae5,stroke:#059669\n style TA fill:#fce7f3,stroke:#db2777\n style TL fill:#d1fae5,stroke:#059669\n style TAct fill:#fce7f3,stroke:#db2777\n style TML fill:#d1fae5,stroke:#059669\n style SL fill:#d1fae5,stroke:#059669\n```\n\n> 🟦 Routes 🟩 Loaders (read data) 🟪 Actions (write data)\n\n## Project Structure\n\n```\ndemos/message-board/\n├── index.tsx # Entry point — route definitions + createApp()\n├── types.ts # Shared types (Topic, Message, SearchResults)\n│\n├── database/\n│ ├── migrations.ts # Schema creation + seed data\n│ └── queries.ts # All SQL queries (CRUD + search)\n│\n├── components/\n│ ├── LoadingSpinner.tsx # Reusable loading indicator\n│ ├── MessageForm.tsx # Post a new message (uses useFetcher)\n│ ├── MessageList.tsx # Render messages with highlight support\n│ └── SearchForm.tsx # Search input with navigation\n│\n└── routes/\n ├── App.tsx # Root layout — , loading state, footer\n ├── Home.tsx # Topic list + \"Create Topic\" form\n ├── Home.loader.ts # Loads all topics from DB\n ├── Topic.tsx # Topic detail view + message list + post form\n ├── Topic.loader.ts # Loads topic + its messages\n ├── Topic.action.ts # Creates a new message in a topic\n ├── TopicMessage.loader.ts # Same as Topic.loader (with message highlight)\n ├── Topics.action.ts # Creates a new topic → redirects to it\n ├── Search.tsx # Search results (topics + messages)\n └── Search.loader.ts # Runs search query against DB\n```\n\n## Data Flow\n\n```mermaid\nsequenceDiagram\n participant User\n participant Browser\n participant Server\n participant SQLite\n\n Note over User,SQLite: Creating a new topic\n User->>Browser: Fill in title, click \"Create Topic\"\n Browser->>Server: POST / (X-Data-Request: true)\n Server->>Server: Topics.action.ts\n Server->>SQLite: INSERT INTO topics\n SQLite-->>Server: New topic row\n Server-->>Browser: JSON { redirect: \"/topics/4\" }\n Browser->>Server: GET /topics/4 (X-Data-Request: true)\n Server->>Server: Topic.loader.ts\n Server->>SQLite: SELECT topic + messages\n SQLite-->>Server: Topic + messages data\n Server-->>Browser: JSON { loaderData }\n Browser->>User: Renders topic page\n\n Note over User,SQLite: Posting a message\n User->>Browser: Type message, click \"Post\"\n Browser->>Server: POST /topics/4 (fetcher)\n Server->>Server: Topic.action.ts\n Server->>SQLite: INSERT INTO messages\n SQLite-->>Server: New message row\n Server-->>Browser: JSON { actionData + loaderData }\n Browser->>User: Message appears in list\n```\n\n## Database Schema\n\n```mermaid\nerDiagram\n message_board_topics_v1 {\n INTEGER id PK \"AUTOINCREMENT\"\n TEXT title \"NOT NULL\"\n TEXT createdAt \"NOT NULL (ISO 8601)\"\n }\n\n message_board_messages_v1 {\n INTEGER id PK \"AUTOINCREMENT\"\n INTEGER topicId FK \"NOT NULL\"\n TEXT content \"NOT NULL\"\n TEXT createdAt \"NOT NULL (ISO 8601)\"\n }\n\n message_board_topics_v1 ||--o{ message_board_messages_v1 : \"has many\"\n```\n\nThe database is auto-initialized on cold start via `initializeDatabase()` and seeded with 3 sample topics and 5 messages if empty.\n\n## How It Uses vtrr\n\nThis demo showcases the key patterns of the vtrr framework:\n\n### 1. Route definitions with string-based loaders/actions\n\n```ts\nexport const routes = defineRoutes([\n {\n path: \"/\",\n Component: App,\n action: \"./routes/Topics.action.ts\", // server-only, never shipped to client\n children: [\n { index: true, Component: Home, loader: \"./routes/Home.loader.ts\" },\n { path: \"topics/:topicId\", Component: Topic, loader: \"...\", action: \"...\" },\n ],\n },\n]);\n```\n\nLoaders and actions are specified as **relative file paths** — the server dynamically imports them, while the client only gets lightweight stubs.\n\n### 2. Loader pattern — export a named `loader` function\n\n```ts\n// Home.loader.ts\nexport async function loader() {\n return { topics: await getAllTopics() };\n}\n```\n\n### 3. Action pattern — form mutations with redirects\n\n```ts\n// Topics.action.ts\nexport async function action({ request }) {\n const formData = await request.formData();\n const topic = await createTopic(formData.get(\"title\"));\n return redirect(`/topics/${topic.id}`);\n}\n```\n\n### 4. createApp with custom `` content\n\n```ts\nexport default createApp({\n routes,\n head: `\n Community Message Board\n \n `,\n});\n```\n\n## Styling\n\nUses [Twind](https://twind.style/) (Tailwind-in-JS) loaded from CDN — zero build step, just write Tailwind classes directly in JSX.\n",[],[196,284,189],"554e6224-0ff6-11f1-bbd5-42dde27851f2","Topics.action.ts","554e62ce-0ff6-11f1-bbd5-42dde27851f2","29c37dba-0ff6-11f1-925a-42dde27851f2",64,["D",1771768609272],"import { redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createTopic } from \"../database/queries.ts\";\n\nexport async function action({ request }: { request: Request }) {\n const formData = await request.formData();\n const title = formData.get(\"title\") as string;\n\n if (!title || title.trim() === \"\") {\n throw new Response(\"Title is required\", { status: 400 });\n }\n\n const topic = await createTopic(title);\n return redirect(`/topics/${topic.id}`);\n}\n",[],[196,284,309,301],"routes","5f0247ea-0ff6-11f1-828e-42dde27851f2","TopicMessage.loader.ts","5f0248a8-0ff6-11f1-828e-42dde27851f2",68,["D",1771768625510],"import { getTopicById, getMessageById, getMessagesByTopicId } from \"../database/queries.ts\";\n\nexport async function loader({ params }: { params: Record }) {\n const topicId = parseInt(params.topicId!, 10);\n const messageId = parseInt(params.messageId!, 10);\n\n const topic = await getTopicById(topicId);\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const message = await getMessageById(messageId);\n if (!message || message.topicId !== topicId) {\n throw new Response(\"Message not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}\n",[],[196,284,309,311],"63d75362-0ff8-11f1-974d-42dde27851f2","Topic.tsx","5b1ed954-0ff6-11f1-828e-42dde27851f2",86,["D",1771769492646],"/** @jsxImportSource ../../.. */\nimport { React, useEffect, Link, useLoaderData, useParams } from \"../../../mod.ts\";\nimport { Message, Topic } from \"../types.ts\";\nimport { MessageForm } from \"../components/MessageForm.tsx\";\nimport { MessageList } from \"../components/MessageList.tsx\";\nimport { SearchForm } from \"../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}\n",[],[196,284,309,319],"5c3ed5b4-0ff6-11f1-abac-42dde27851f2","Topic.loader.ts","5c3ed67c-0ff6-11f1-abac-42dde27851f2",66,["D",1771768620905],"import { getTopicById, getMessagesByTopicId } from \"../database/queries.ts\";\n\nexport async function loader({ params }: { params: Record }) {\n const topicId = parseInt(params.topicId!, 10);\n const topic = await getTopicById(topicId);\n\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}\n",[],[196,284,309,327],"5d51a5b2-0ff6-11f1-828e-42dde27851f2","Topic.action.ts","5d51a698-0ff6-11f1-828e-42dde27851f2",67,["D",1771768622710],"import { createMessage } from \"../database/queries.ts\";\n\nexport async function action({ request }: { request: Request }) {\n const formData = await request.formData();\n const topicId = parseInt(formData.get(\"topicId\") as string, 10);\n const content = formData.get(\"content\") as string;\n\n if (!content || content.trim() === \"\") {\n throw new Response(\"Content is required\", { status: 400 });\n }\n\n const message = await createMessage(topicId, content);\n return message;\n}\n",[],[196,284,309,335],"68448c12-0ff8-11f1-82a2-42dde27851f2","Search.tsx","63f0706a-0ff6-11f1-828e-42dde27851f2",87,["D",1771769500071],"/** @jsxImportSource ../../.. */\nimport { React, Link, useLoaderData } from \"../../../mod.ts\";\nimport { SearchResults as SearchResultsType } from \"../types.ts\";\nimport { SearchForm } from \"../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}\n",[],[196,284,309,343],"64e52dda-0ff6-11f1-876e-42dde27851f2","Search.loader.ts","64e52eb6-0ff6-11f1-876e-42dde27851f2",70,["D",1771768635423],"import { search } from \"../database/queries.ts\";\n\nexport async function loader({ request }: { request: Request }) {\n const url = new URL(request.url);\n const query = url.searchParams.get(\"q\") || \"\";\n\n if (!query || query.trim() === \"\") {\n return { topics: [], messages: [], query: \"\" };\n }\n\n return await search(query);\n}\n",[],[196,284,309,351],"60500432-0ff8-11f1-8c2d-42dde27851f2","Home.tsx","53453ca0-0ff6-11f1-876e-42dde27851f2",85,["D",1771769486725],"/** @jsxImportSource ../../.. */\nimport { React, Form, Link, useLoaderData, useNavigation } from \"../../../mod.ts\";\nimport { SearchForm } from \"../components/SearchForm.tsx\";\nimport { Topic } from \"../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}\n",[],[196,284,309,359],"53fb047c-0ff6-11f1-876e-42dde27851f2","Home.loader.ts","53fb0558-0ff6-11f1-876e-42dde27851f2",63,["D",1771768607045],"import { getAllTopics } from \"../database/queries.ts\";\n\nexport async function loader() {\n return { topics: await getAllTopics() };\n}\n",[],[196,284,309,367],"5a6aa23e-0ff8-11f1-8e69-42dde27851f2","App.tsx","4db12fba-0ff6-11f1-828e-42dde27851f2",84,["D",1771769476834],"/** @jsxImportSource ../../.. */\nimport { React, Outlet, useNavigation } from \"../../../mod.ts\";\n\nexport function App() {\n const navigation = useNavigation();\n return (\n

\n \n

\n\n \n

\n );\n}\n",[],[196,284,309,375],"29c37d06-0ff6-11f1-925a-42dde27851f2",53,["D",1771768536213],[223,224,225,226,227,228,229,230,231,232],[196,284,309],"3ae3f408-0ff6-11f1-bbd5-42dde27851f2","queries.ts","3ae3f4bc-0ff6-11f1-bbd5-42dde27851f2","293fc808-0ff6-11f1-bfeb-42dde27851f2",56,["D",1771768564955],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Message, SearchResults, Topic } from \"../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 sql: `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE id = ?\n `,\n args: [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 sql: `\n INSERT INTO ${TOPICS_TABLE} (title, createdAt)\n VALUES (?, ?)\n RETURNING id, title, createdAt\n `,\n args: [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 sql: `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE topicId = ? \n ORDER BY createdAt ASC\n `,\n args: [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 sql: `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE id = ?\n `,\n args: [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 sql: `\n INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt)\n VALUES (?, ?, ?)\n RETURNING id, topicId, content, createdAt\n `,\n args: [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 sql: `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE title LIKE ? \n ORDER BY createdAt DESC\n `,\n args: [`%${query}%`],\n });\n\n // Search in messages\n const messagesResult = await sqlite.execute({\n sql: `\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 args: [`%${query}%`],\n });\n\n return {\n topics: topicsResult.rows as Topic[],\n messages: messagesResult.rows as Message[],\n query,\n };\n}\n",[],[196,284,396,388],"database","352fb07e-0ff6-11f1-876e-42dde27851f2","migrations.ts","352fb15a-0ff6-11f1-876e-42dde27851f2",55,["D",1771768555380],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\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 const now = new Date().toISOString();\n\n // Insert sample topics using parameterized queries\n await sqlite.batch([\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Welcome to the Message Board\", now],\n },\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Tips and Tricks for Val Town\", now],\n },\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Introduce Yourself\", now],\n },\n ]);\n\n // Get the IDs of the inserted topics\n const topics = await sqlite.execute(`SELECT id FROM ${TOPICS_TABLE} ORDER BY id ASC LIMIT 3`);\n\n // Insert sample messages for each topic\n if (topics.rows.length >= 3) {\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.batch([\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [welcomeTopicId, \"Welcome to our community message board! Feel free to browse around and join the discussions.\", now],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [welcomeTopicId, \"If you have any questions, just post them here!\", new Date(Date.now() - 3600000).toISOString()],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [tipsTopicId, \"Val Town makes it easy to build and share serverless functions.\", now],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [tipsTopicId, \"You can use TypeScript for better type safety in your projects.\", new Date(Date.now() - 7200000).toISOString()],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [introTopicId, \"Hi everyone! I'm the creator of this message board example.\", now],\n },\n ]);\n }\n}\n",[],[196,284,396,398],"293fc74a-0ff6-11f1-bfeb-42dde27851f2",51,["D",1771768535352],[220,221],[196,284,396],"6e0e0588-0ff8-11f1-974d-42dde27851f2","SearchForm.tsx","4188e732-0ff6-11f1-876e-42dde27851f2","2978b884-0ff6-11f1-bfeb-42dde27851f2",89,["D",1771769509782],"/** @jsxImportSource ../../.. */\nimport { React, Form, useNavigation, useSearchParams } from \"../../../mod.ts\";\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}\n",[],[196,284,419,411],"components","70f2679e-0ff8-11f1-b9ef-42dde27851f2","MessageList.tsx","44d9e2d8-0ff6-11f1-abac-42dde27851f2",90,["D",1771769514632],"/** @jsxImportSource ../../.. */\nimport { React, Link, useLocation } from \"../../../mod.ts\";\nimport { Message } from \"../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}\n",[],[196,284,419,421],"74404e84-0ff8-11f1-b9ef-42dde27851f2","MessageForm.tsx","492504c6-0ff6-11f1-abac-42dde27851f2",91,["D",1771769520178],"/** @jsxImportSource ../../.. */\nimport { React, Form, useNavigation } from \"../../../mod.ts\";\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}\n",[],[196,284,419,429],"6ba5103e-0ff8-11f1-974d-42dde27851f2","LoadingSpinner.tsx","3e46242c-0ff6-11f1-bbd5-42dde27851f2",88,["D",1771769505738],"/** @jsxImportSource ../../.. */\nimport { React } from \"../../../mod.ts\";\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}\n",[],[196,284,419,437],"2978b7c6-0ff6-11f1-bfeb-42dde27851f2",52,["D",1771768535726],[215,216,217,218],[196,284,419],"26c61618-0ff6-11f1-925a-42dde27851f2",50,["D",1771768531199],[214,219,222,233,234,235],[196,284],["D",1771766554183],[213,236],[196],["D",1771766181944],["D",1789531852468],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_19":61,"_109":110,"_111":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"ctx",{"_87":-5,"_133":495,"_496":497,"_498":499,"_500":31,"_501":31,"_502":31,"_503":131,"_504":-5,"_505":-7,"_506":-7,"_507":185,"_508":31,"_509":31,"_510":-5,"_511":31,"_512":31,"_513":31,"_514":-5},"ENV",{"_466":467,"_468":469,"_470":95,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488,"_489":490,"_491":492,"_493":494},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v97