\",\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;","react-router-7-example",[18,97],"5ae47cc0-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[18,81],"pulls","branches",5,"forks","envVars",{"_318":293,"_320":293},"connections",{"_318":293,"_319":293},"count","unfilledCount","emptyCount",{"_50":291,"_13":18,"_79":216,"_60":-5,"_52":53,"_295":57,"_302":24,"_54":570,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":571,"_17":572},{"_50":307,"_13":81,"_79":80,"_60":216,"_52":53,"_295":57,"_302":24,"_54":567,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":568,"_17":569},{"_50":560,"_13":561,"_79":562,"_60":80,"_52":53,"_295":256,"_302":24,"_54":563,"_56":57,"_82":98,"_292":564,"_84":30,"_296":-5,"_359":565,"_17":566},{"_50":553,"_13":554,"_79":555,"_60":80,"_52":53,"_295":256,"_302":24,"_54":556,"_56":312,"_82":98,"_292":557,"_84":30,"_296":-5,"_359":558,"_17":559},{"_50":300,"_13":97,"_79":129,"_60":216,"_52":53,"_295":301,"_302":24,"_54":550,"_56":211,"_82":107,"_292":304,"_84":30,"_296":305,"_359":551,"_17":552},{"_50":546,"_13":484,"_79":479,"_60":-5,"_52":53,"_295":312,"_302":24,"_54":547,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":548,"_17":549},{"_50":542,"_13":501,"_79":496,"_60":479,"_52":53,"_295":430,"_302":24,"_54":543,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":544,"_17":545},{"_50":534,"_13":464,"_79":535,"_60":496,"_52":53,"_295":536,"_302":24,"_54":537,"_56":538,"_82":98,"_292":539,"_84":30,"_296":-5,"_359":540,"_17":541},{"_50":527,"_13":528,"_79":529,"_60":496,"_52":53,"_295":505,"_302":24,"_54":530,"_56":26,"_82":98,"_292":531,"_84":30,"_296":-5,"_359":532,"_17":533},{"_50":518,"_13":519,"_79":520,"_60":496,"_52":53,"_295":521,"_302":24,"_54":522,"_56":523,"_82":98,"_292":524,"_84":30,"_296":-5,"_359":525,"_17":526},{"_50":510,"_13":511,"_79":512,"_60":496,"_52":53,"_295":513,"_302":24,"_54":514,"_56":57,"_82":98,"_292":515,"_84":30,"_296":-5,"_359":516,"_17":517},{"_50":502,"_13":503,"_79":504,"_60":496,"_52":53,"_295":505,"_302":24,"_54":506,"_56":374,"_82":98,"_292":507,"_84":30,"_296":-5,"_359":508,"_17":509},{"_50":493,"_13":494,"_79":495,"_60":496,"_52":53,"_295":413,"_302":24,"_54":497,"_56":57,"_82":98,"_292":498,"_84":30,"_296":-5,"_359":499,"_17":500},{"_50":485,"_13":486,"_79":487,"_60":479,"_52":53,"_295":488,"_302":24,"_54":489,"_56":374,"_82":21,"_292":490,"_84":30,"_296":-5,"_359":491,"_17":492},{"_50":476,"_13":477,"_79":478,"_60":479,"_52":53,"_295":301,"_302":24,"_54":480,"_56":312,"_82":98,"_292":481,"_84":30,"_296":-5,"_359":482,"_17":483},{"_50":472,"_13":401,"_79":395,"_60":-5,"_52":53,"_295":405,"_302":24,"_54":473,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":474,"_17":475},{"_50":463,"_13":464,"_79":465,"_60":395,"_52":53,"_295":466,"_302":24,"_54":467,"_56":468,"_82":98,"_292":469,"_84":30,"_296":-5,"_359":470,"_17":471},{"_50":456,"_13":457,"_79":458,"_60":395,"_52":53,"_295":405,"_302":24,"_54":459,"_56":293,"_82":98,"_292":460,"_84":30,"_296":-5,"_359":461,"_17":462},{"_50":448,"_13":449,"_79":450,"_60":395,"_52":53,"_295":451,"_302":24,"_54":452,"_56":312,"_82":98,"_292":453,"_84":30,"_296":-5,"_359":454,"_17":455},{"_50":441,"_13":442,"_79":443,"_60":395,"_52":53,"_295":405,"_302":24,"_54":444,"_56":293,"_82":98,"_292":445,"_84":30,"_296":-5,"_359":446,"_17":447},{"_50":434,"_13":435,"_79":436,"_60":395,"_52":53,"_295":413,"_302":24,"_54":437,"_56":26,"_82":98,"_292":438,"_84":30,"_296":-5,"_359":439,"_17":440},{"_50":425,"_13":426,"_79":427,"_60":395,"_52":53,"_295":428,"_302":24,"_54":429,"_56":430,"_82":98,"_292":431,"_84":30,"_296":-5,"_359":432,"_17":433},{"_50":418,"_13":419,"_79":420,"_60":395,"_52":53,"_295":405,"_302":24,"_54":421,"_56":293,"_82":98,"_292":422,"_84":30,"_296":-5,"_359":423,"_17":424},{"_50":410,"_13":411,"_79":412,"_60":395,"_52":53,"_295":413,"_302":24,"_54":414,"_56":26,"_82":98,"_292":415,"_84":30,"_296":-5,"_359":416,"_17":417},{"_50":402,"_13":403,"_79":404,"_60":395,"_52":53,"_295":405,"_302":24,"_54":406,"_56":293,"_82":98,"_292":407,"_84":30,"_296":-5,"_359":408,"_17":409},{"_50":392,"_13":393,"_79":394,"_60":395,"_52":53,"_295":396,"_302":24,"_54":397,"_56":26,"_82":98,"_292":398,"_84":30,"_296":-5,"_359":399,"_17":400},{"_50":388,"_13":379,"_79":373,"_60":-5,"_52":53,"_295":374,"_302":24,"_54":389,"_56":293,"_82":83,"_292":-5,"_84":30,"_296":-5,"_359":390,"_17":391},{"_50":380,"_13":381,"_79":382,"_60":373,"_52":53,"_295":301,"_302":24,"_54":383,"_56":384,"_82":98,"_292":385,"_84":30,"_296":-5,"_359":386,"_17":387},{"_50":370,"_13":371,"_79":372,"_60":373,"_52":53,"_295":374,"_302":24,"_54":375,"_56":293,"_82":98,"_292":376,"_84":30,"_296":-5,"_359":377,"_17":378},{"_50":362,"_13":363,"_79":364,"_60":-5,"_52":53,"_295":256,"_302":24,"_54":365,"_56":366,"_82":21,"_292":367,"_84":30,"_296":-5,"_359":368,"_17":369},{"_50":352,"_13":353,"_79":354,"_60":-5,"_52":53,"_295":355,"_302":24,"_54":356,"_56":357,"_82":21,"_292":358,"_84":30,"_296":-5,"_359":360,"_17":361},"db92e8f0-163c-11f0-8f3c-569c3dd06744","TODO.md","471f7894-1594-11f0-bc2d-569c3dd06744",143,["D",1744311108608],11,"- [ ] 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?","children",[],[353],"b26e0ca4-0fe5-11f1-bc51-42dde27851f2","README.md","513e59ca-14cd-11f0-8f60-569c3dd06744",["D",1771761464050],9,"# React Router 7 on Val Town\n\nA full-stack SSR + SPA reference architecture for [Val Town](https://val.town), built with **React Router 7**, **Hono**, and **SQLite**. Ships as a community message board demo, but the patterns here are designed to be extracted into a reusable framework/template.\n\n> **Live demo:** \n\n## Why This Exists\n\nVal Town gives you serverless TypeScript functions, but building a real full-stack app with SSR, client-side navigation, loaders, actions, and hydration requires wiring together several pieces. This project demonstrates one clean way to do it — and is the seed for a potential **Val Town Router** framework.\n\n## Architecture Overview\n\n```mermaid\ngraph TD\n subgraph \"Browser\"\n A[index.html] -->|loads| B[frontend/index.tsx]\n B -->|creates| C[createBrowserRouter]\n C -->|uses| D[dataStrategy]\n D -->|\"fetch with X-Data-Request: true\"| E\n end\n\n subgraph \"Val Town Server — backend/index.ts\"\n E[Hono HTTP Handler]\n E -->|\"static files\"| F[serveFile]\n E -->|\"SSR or data request\"| G[createStaticHandler]\n G -->|runs| H[Loaders / Actions]\n H -->|queries| I[(SQLite)]\n G -->|\"full page\"| J[renderToString → HTML]\n G -->|\"data request\"| K[JSON response]\n end\n\n subgraph \"Shared — shared/\"\n L[routes.ts] -.->|\"imported by both\"| C\n L -.->|\"imported by both\"| G\n M[types.ts] -.->|\"used everywhere\"| H\n end\n\n style A fill:#e0f2fe\n style B fill:#e0f2fe\n style C fill:#e0f2fe\n style D fill:#e0f2fe\n style E fill:#fef3c7\n style F fill:#fef3c7\n style G fill:#fef3c7\n style H fill:#fef3c7\n style I fill:#d1fae5\n style J fill:#fef3c7\n style K fill:#fef3c7\n style L fill:#f3e8ff\n style M fill:#f3e8ff\n```\n\n## Request Lifecycle\n\n```mermaid\nsequenceDiagram\n participant Browser\n participant Hono as Hono Server\n participant RR as React Router Static Handler\n participant DB as SQLite\n\n Note over Browser,DB: First visit (SSR)\n Browser->>Hono: GET /topics/42\n Hono->>RR: query(request)\n RR->>DB: Topic.loader → getTopicById(42)\n DB-->>RR: topic + messages\n RR-->>Hono: StaticHandlerContext\n Hono->>Hono: renderToString(StaticRouterProvider)\n Hono-->>Browser: Full HTML page\n\n Note over Browser,DB: Subsequent navigation (SPA)\n Browser->>Browser: User clicks \n Browser->>Hono: GET /search?q=hello (X-Data-Request: true)\n Hono->>RR: query(request)\n RR->>DB: Search.loader → search(\"hello\")\n DB-->>RR: search results\n RR-->>Hono: StaticHandlerContext\n Hono-->>Browser: JSON { loaderData: {...} }\n Browser->>Browser: React Router updates UI\n\n Note over Browser,DB: Form submission (Action)\n Browser->>Hono: POST /topics/42 (X-Data-Request: true, formData)\n Hono->>RR: query(request)\n RR->>DB: Topic.action → createMessage(42, content)\n DB-->>RR: new message\n RR-->>Hono: Redirect response\n Hono-->>Browser: JSON { redirect: \"/topics/42\" }\n Browser->>Browser: Client-side redirect + re-fetch loaders\n```\n\n## Features\n\n- **Server-Side Rendering** — Every page is fully rendered on first visit (SEO-friendly, fast paint)\n- **Client-Side Navigation** — After hydration, navigation is instant SPA-style\n- **Single-Fetch Data Strategy** — Client navigation makes one request per route transition, not one per loader\n- **Loaders & Actions** — Remix-style data loading and form handling, co-located with route components\n- **Redirect Handling** — Server actions return redirects as JSON for the client `dataStrategy` to follow\n- **SQLite Persistence** — Val Town's built-in SQLite with idempotent migrations and seed data\n- **Loading States** — `useNavigation()` for global loading indicators\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Hono HTTP entry point (SSR + data API + static files)\n│ └── database/\n│ ├── migrations.ts # Schema creation + seed data\n│ └── queries.ts # All database queries\n├── frontend/\n│ ├── index.html # HTML shell template\n│ ├── index.tsx # Client entry — hydration + dataStrategy\n│ └── components/\n│ ├── App.tsx # (unused legacy — see routes/App.tsx)\n│ ├── LoadingSpinner.tsx\n│ ├── MessageForm.tsx\n│ ├── MessageList.tsx\n│ ├── SearchForm.tsx\n│ └── SearchResults.tsx\n├── routes/\n│ ├── App.tsx # Root layout (Outlet + nav + footer)\n│ ├── Home.tsx # Home page — topic list + create form\n│ ├── Home.loader.ts # Loads all topics\n│ ├── Topic.tsx # Topic detail — messages + reply form\n│ ├── Topic.loader.ts # Loads topic + messages\n│ ├── Topic.action.ts # Creates a message in a topic\n│ ├── TopicMessage.loader.ts # Direct link to a specific message\n│ ├── Topics.action.ts # Creates a new topic (root action)\n│ ├── Search.tsx # Search results page\n│ └── Search.loader.ts # Runs search query\n├── shared/\n│ ├── routes.ts # Route tree (shared between server + client)\n│ └── types.ts # TypeScript interfaces (Topic, Message, SearchResults)\n├── README.md\n└── TODO.md\n```\n\n## Key Patterns\n\n### 1. Shared Route Definitions (`shared/routes.ts`)\n\nThe same route tree is used on both server and client. The `serverLoader()` / `serverAction()` helpers make this work:\n\n- **On the server:** dynamically import the real loader/action module and call it\n- **On the client:** return a no-op stub (the `dataStrategy` handles fetching)\n\nThis means loader/action code (and its database dependencies) **never ships to the browser**.\n\n### 2. Single-Fetch `dataStrategy` (`frontend/index.tsx`)\n\nInstead of React Router calling each loader individually on the client, a custom `dataStrategy` makes **one HTTP request** with a `X-Data-Request: true` header. The server runs all matched loaders/actions and returns their data as keyed JSON.\n\n### 3. SSR with Hydration (`backend/index.ts`)\n\nOn full page loads:\n1. `createStaticHandler` runs loaders\n2. `createStaticRouter` + `StaticRouterProvider` renders to HTML string\n3. HTML is injected into the `index.html` template\n4. Client picks up with `hydrateRoot` + `createBrowserRouter`\n\n### 4. Action → Redirect → Reload\n\nForm submissions go through React Router actions. On the server, the action returns a `redirect()`. For data requests, the server converts this to `{ redirect: \"/path\" }` JSON so the client `dataStrategy` can follow it, triggering a client-side navigation + loader re-fetch.\n\n## URL Structure\n\n| URL | Description |\n|-----|-------------|\n| `/` | Home — list of topics + create form |\n| `/topics/:topicId` | Topic detail — messages + reply form |\n| `/topics/:topicId/messages/:messageId` | Deep link to a specific message |\n| `/search?q=query` | Search results across topics and messages |\n\n## Tech Stack\n\n| Layer | Technology | Purpose |\n|-------|-----------|---------|\n| Server | [Hono](https://hono.dev/) | HTTP routing, static files, SSR orchestration |\n| Routing | [React Router 7](https://reactrouter.com/) | SSR + SPA routing, loaders, actions |\n| UI | [React 18](https://react.dev/) | Components + hydration |\n| Styling | [Twind](https://twind.dev/) | Tailwind-in-JS (CDN) |\n| Database | Val Town SQLite | Project-scoped persistence via `std/sqlite` |\n| Runtime | Val Town (Deno) | Serverless hosting |\n\n## Towards a Framework / Template\n\nThis project is designed to be the starting point for a reusable **Val Town fullstack framework**. Here's what could be extracted:\n\n### What's Already Framework-Ready\n\n- **`serverLoader()` / `serverAction()` pattern** — Generic helpers that work with any route tree\n- **`dataStrategy` implementation** — The single-fetch client strategy is app-agnostic\n- **SSR pipeline in `backend/index.ts`** — The Hono → StaticHandler → render → hydrate flow is generic\n- **`X-Data-Request` protocol** — Simple convention for distinguishing SSR vs data-only requests\n\n### Suggestions for Extraction\n\n```mermaid\ngraph BT\n subgraph \"Your App\"\n A[routes/Home.tsx]\n B[routes/Topic.tsx]\n C[backend/database/queries.ts]\n end\n\n subgraph \"Val Town Router Framework\"\n D[\"createValTownRouter()\"]\n E[\"createRoutes()\"]\n F[\"dataStrategy (single-fetch)\"]\n G[\"SSR pipeline\"]\n H[\"HTML shell generator\"]\n I[\"deps.ts (version pins)\"]\n J[\"File-based route discovery\"]\n end\n\n subgraph \"Val Town Platform\"\n K[Hono]\n L[SQLite]\n M[Deno Runtime]\n N[esm.sh CDN]\n end\n\n A & B -->|\"define routes via\"| E\n C -->|\"queries\"| L\n E -->|\"passed to\"| D\n D -->|\"creates\"| K\n D -->|\"wires up\"| G\n D -->|\"wires up\"| F\n D -->|\"generates\"| H\n I -->|\"pins versions for\"| N\n J -->|\"auto-discovers\"| E\n K & L & M & N -->|\"provided by\"| M\n\n style A fill:#e0f2fe\n style B fill:#e0f2fe\n style C fill:#e0f2fe\n style D fill:#fef3c7\n style E fill:#fef3c7\n style F fill:#fef3c7\n style G fill:#fef3c7\n style H fill:#fef3c7\n style I fill:#fef3c7\n style J fill:#fef3c7\n style K fill:#d1fae5\n style L fill:#d1fae5\n style M fill:#d1fae5\n style N fill:#d1fae5\n```\n\n1. **`createValTownRouter(routes, options)`** — A single function that returns a Hono app with SSR, static file serving, and the data-request protocol baked in. Users just supply routes and get a working full-stack app:\n ```ts\n import { createValTownRouter } from \"https://esm.town/v/std/valtown-router\";\n import { routes } from \"./shared/routes.ts\";\n export default createValTownRouter(routes, { title: \"My App\" });\n ```\n\n2. **Centralized `deps.ts` version pinning** — React, React Router, and React DOM versions are repeated across many files via `esm.sh` URLs (currently 7+ files all reference `react@18.2.0`). A framework could export these from a single manifest:\n ```ts\n // deps.ts — one place to update versions\n export { default as React } from \"https://esm.sh/react@18.2.0\";\n export { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n export { createBrowserRouter, ... } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\n ```\n\n3. **`createRoutes()` helper** — A typed helper that wraps the `serverLoader`/`serverAction` pattern so users don't need to understand the server/client bifurcation:\n ```ts\n createRoutes([\n { path: \"/\", Component: App, children: [\n { index: true, Component: Home, loader: \"./Home.loader.ts\" },\n { path: \"topics/:id\", Component: Topic, loader: \"./Topic.loader.ts\", action: \"./Topic.action.ts\" },\n ]}\n ])\n ```\n\n4. **File-based route discovery** — The `routes/` directory already follows Remix-style naming conventions (`Home.tsx`, `Home.loader.ts`, `Topic.action.ts`). A framework could auto-discover routes from the filesystem, eliminating the manual `shared/routes.ts` file entirely:\n ```\n routes/\n _layout.tsx → root layout (App)\n _index.tsx → / (Home)\n _index.loader.ts → Home loader\n topics.$id.tsx → /topics/:id (Topic)\n topics.$id.loader.ts\n topics.$id.action.ts\n search.tsx → /search\n search.loader.ts\n ```\n\n5. **HTML template generation** — Instead of a manual `index.html`, the framework could generate the shell with the right scripts, twind, and catch handler included. No more forgetting to add ``.\n\n6. **~~Project-scoped SQLite by default~~** ✅ **Done!** — Migrated from `@stevekrouse/sqlite` (user-scoped) to `std/sqlite` (project-scoped). Each fork now gets its own isolated database automatically.\n\n7. **Middleware hooks** — Auth, logging, error boundaries, CORS, etc. as composable Hono middleware that plugs into the framework:\n ```ts\n export default createValTownRouter(routes, {\n middleware: [authMiddleware(), corsMiddleware()],\n errorBoundary: MyErrorBoundary,\n });\n ```\n\n8. **CLI / `init` template** — A `createValTownApp` script or a Val Town project template that scaffolds the full directory structure with a working starter app in one click.\n\n### Open Questions\n\n- How much of the Hono boilerplate can be hidden vs left explicit for power users?\n- What's the right story for CSS — keep Twind CDN, support CSS modules, or Tailwind build?\n- Should the framework ship as a single Val Town val (importable library) or as an npm package on esm.sh?\n- Could hydration data be embedded in the HTML (like Remix does) instead of requiring a separate client fetch on first load?\n\n## Getting Started\n\n1. **Fork this val** on Val Town\n2. The database auto-initializes with seed data on first request\n3. Visit the HTTP endpoint to see the app\n4. Modify routes in `shared/routes.ts`, add components in `routes/`, and queries in `backend/database/`\n\n## Dependencies\n\nAll dependencies are loaded via `esm.sh` with pinned versions:\n\n- `react@18.2.0`\n- `react-dom@18.2.0`\n- `react-router@7.5.0`\n- `hono@4.1.0`\n- `@valtown/std/utils` (for `readFile` / `serveFile`)\n- `@std/sqlite` (Val Town project-scoped SQLite)\n",[],[363],"5343bcb0-14cd-11f0-b10b-569c3dd06744","types.ts","5343bd78-14cd-11f0-b10b-569c3dd06744","add21c84-9f00-4405-af88-6ec5134089df",2,["D",1744153254621],"/**\n * Topic model representing a discussion thread\n */\nexport interface Topic {\n id: number;\n title: string;\n createdAt: string;\n}\n\n/**\n * Message model representing a post within a topic\n */\nexport interface Message {\n id: number;\n topicId: number;\n content: string;\n createdAt: string;\n}\n\n/**\n * Search results containing matching topics and messages\n */\nexport interface SearchResults {\n topics: Topic[];\n messages: Message[];\n query: string;\n}",[],[379,371],"shared","b51b1732-0f84-11f1-b328-42dde27851f2","routes.ts","7639f8f6-14d2-11f0-97d5-569c3dd06744",["D",1771719807352],28,"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\";\n\n// On the server, dynamically import the real loader/action function.\n// On the client, return a no-op stub. The stub's presence signals to\n// React Router that this route needs data (so it appears in dataStrategy's\n// `matches` with shouldLoad=true), but dataStrategy handles the actual\n// fetching via a single HTTP request to the server.\nfunction serverLoader(importURL: string) {\n if (isServer) {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(importURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nfunction serverAction(importURL: string) {\n if (isServer) {\n return async (args: ActionFunctionArgs) => {\n let module = await import(importURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: serverAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: serverLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"topics/:topicId\",\n Component: Topic,\n loader: serverLoader(\"../routes/Topic.loader.ts\"),\n action: serverAction(\"../routes/Topic.action.ts\"),\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n Component: Topic,\n loader: serverLoader(\"../routes/TopicMessage.loader.ts\"),\n },\n {\n path: \"search\",\n Component: Search,\n loader: serverLoader(\"../routes/Search.loader.ts\"),\n },\n ],\n },\n];",[],[379,381],"5343c3fe-14cd-11f0-b10b-569c3dd06744",["D",1744153254621],[348,349],[379],"5bbd9ef2-1607-11f0-a798-569c3dd06744","Topics.action.ts","f8ffd5be-1593-11f0-9dd6-569c3dd06744","c4795b2d-41e5-4e2d-bb49-1239d72d4d2d",104,["D",1744288130811],"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}",[],[401,393],"routes","f8ffd104-1593-11f0-9dd6-569c3dd06744","TopicMessage.loader.ts","f8ffd1a4-1593-11f0-9dd6-569c3dd06744",81,["D",1744238573020],"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}",[],[401,403],"56d97c60-163b-11f0-bf5f-569c3dd06744","Topic.tsx","f8ffcdf8-1593-11f0-9dd6-569c3dd06744",132,["D",1744310456433],"/** @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}",[],[401,411],"f8ffcace-1593-11f0-9dd6-569c3dd06744","Topic.loader.ts","f8ffcb78-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"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}",[],[401,419],"5136c04e-1607-11f0-ab9a-569c3dd06744","Topic.action.ts","f8ffc948-1593-11f0-9dd6-569c3dd06744",103,["D",1744288113149],6,"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}",[],[401,426],"56d99d76-163b-11f0-bf5f-569c3dd06744","Search.tsx","f8ffc506-1593-11f0-9dd6-569c3dd06744",["D",1744310456433],"/** @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}",[],[401,435],"f8ffc20e-1593-11f0-9dd6-569c3dd06744","Search.loader.ts","f8ffc2cc-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"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}",[],[401,442],"3d47a160-163f-11f0-809e-569c3dd06744","Home.tsx","f8ffb6d8-1593-11f0-9dd6-569c3dd06744",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}",[],[401,449],"f8ffb372-1593-11f0-9dd6-569c3dd06744","Home.loader.ts","f8ffb44e-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"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}",[],[401,457],"9c168580-0f86-11f1-858f-42dde27851f2","App.tsx","f8ff993c-1593-11f0-9dd6-569c3dd06744",177,["D",1771720624387],4,"/** @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}",[],[401,464],"f8ffd76c-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],[337,338,339,340,341,342,343,344,345,346],[401],"b51b0576-0f84-11f1-b328-42dde27851f2","index.tsx","95142d28-14cd-11f0-b4b7-569c3dd06744","25ba79aa-990f-468a-a9a9-3feab00a24d6",["D",1771719807352],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n redirect,\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 dataStrategy for single-fetch\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n hydrationData: window.__staticRouterHydrationData,\n\n async dataStrategy({ request, matches }) {\n // Filter to matches that need their handler called\n const matchesToLoad = matches.filter(m => m.shouldLoad);\n\n // If no matches need loading, return empty results\n if (matchesToLoad.length === 0) {\n return {};\n }\n\n console.log(\"[dataStrategy] fetching:\", request.url, \"method:\", request.method);\n console.log(\"[dataStrategy] matchesToLoad:\", matchesToLoad.map(m => m.route.id));\n\n const fetchInit: RequestInit = {\n method: request.method,\n headers: {\n \"X-Data-Request\": \"true\",\n },\n signal: request.signal,\n };\n\n // For non-GET requests (actions), forward the body\n if (request.method !== \"GET\") {\n fetchInit.body = await request.formData();\n }\n\n const res = await fetch(request.url, fetchInit);\n const json = await res.json();\n\n console.log(\"[dataStrategy] response keys:\", Object.keys(json));\n\n // Handle redirects from actions\n // The server sends { redirect: \"/path\" } instead of a 302\n // Return the redirect Response as a DataStrategyResult for the action route.\n // React Router unwraps Response results — a 302 triggers client-side navigation.\n if (json.redirect) {\n console.log(\"[dataStrategy] redirect to:\", json.redirect);\n const results: Record = {};\n for (const match of matchesToLoad) {\n results[match.route.id] = {\n type: \"data\",\n result: redirect(json.redirect),\n };\n }\n return results;\n }\n\n // Build results keyed by route ID\n // dataStrategy must return Record\n const results: Record = {};\n for (const match of matchesToLoad) {\n const routeId = match.route.id;\n // For actions, prefer actionData; for loaders, use loaderData\n if (json.actionData && json.actionData[routeId] !== undefined && json.actionData[routeId] !== null) {\n results[routeId] = { type: \"data\", result: json.actionData[routeId] };\n } else if (json.loaderData && json.loaderData[routeId] !== undefined) {\n results[routeId] = { type: \"data\", result: json.loaderData[routeId] };\n }\n }\n\n console.log(\"[dataStrategy] returning results for routes:\", Object.keys(results));\n return results;\n },\n },\n);\n\n// Hydrate the app\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);",[],[484,477],"frontend","4cc3ba60-14d3-11f0-abe2-569c3dd06744","index.html","65bcfe06-14cd-11f0-9e26-569c3dd06744",62,["D",1744155820694],"\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[484,486],"56d9a406-163b-11f0-bf5f-569c3dd06744","SearchResults.tsx","90a036c4-14cd-11f0-8b75-569c3dd06744","dea96277-3d90-41f7-8b34-da954ceef6fc",["D",1744310456433],"/** @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}",[],[484,501,494],"components","eefdb18c-14d3-11f0-b7c3-569c3dd06744","SearchForm.tsx","7700eaba-14cd-11f0-82fd-569c3dd06744",68,["D",1744156092862],"/** @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}",[],[484,501,503],"3fb3a7c2-163b-11f0-a98e-569c3dd06744","MessageList.tsx","722f6066-14cd-11f0-83b3-569c3dd06744",130,["D",1744310417601],"/** @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}",[],[484,501,511],"8e3adbcc-163b-11f0-a02e-569c3dd06744","MessageForm.tsx","6d98d532-14cd-11f0-9771-569c3dd06744",135,["D",1744310549349],8,"/** @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}",[],[484,501,519],"eefdb72c-14d3-11f0-b7c3-569c3dd06744","LoadingSpinner.tsx","68b504be-14cd-11f0-98df-569c3dd06744",["D",1744156092862],"/** @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}",[],[484,501,528],"1368ebb8-14d4-11f0-b4aa-569c3dd06744","892aec86-14cd-11f0-897e-569c3dd06744",71,["D",1744156153964],10,"/** @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}",[],[484,501,464],"68b50b94-14cd-11f0-98df-569c3dd06744",["D",1744153290594],[328,329,330,331,332,333],[484,501],"65bd0400-14cd-11f0-9e26-569c3dd06744",["D",1744153285607],[327,334,335],[484],["D",1771719807352],[],[18,97],"b26e6cda-0fe5-11f1-bc51-42dde27851f2","queries.ts","6229805c-14cd-11f0-800b-569c3dd06744",["D",1771761464050],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\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 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",[],[18,81,554],"b26e7f54-0fe5-11f1-bc51-42dde27851f2","migrations.ts","5ae46b72-14cd-11f0-bbde-569c3dd06744",["D",1771761464050],"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",[],[18,81,561],["D",1744153267418],[323,324],[18,81],["D",1744153267418],[322,325],[18],["D",1744152661331],["D",1789558275908],{"_11":12,"_269":87},{"_11":12,"_265":-5,"_86":87,"_31":85,"_266":267,"_268":30},{"_56":256,"_13":16,"_50":53,"_257":218,"_258":-5,"_259":-5,"_260":-5,"_261":-5,"_262":-5,"_263":14,"_264":12},"ctx",{"_69":-5,"_288":611,"_612":613,"_614":615,"_616":30,"_617":30,"_618":30,"_619":24,"_620":-5,"_621":-7,"_622":-7,"_623":293,"_624":30,"_625":30,"_626":-5,"_627":30,"_628":30,"_629":30,"_630":-5},"ENV",{"_582":583,"_584":585,"_586":16,"_587":588,"_589":590,"_591":592,"_593":594,"_595":596,"_597":598,"_599":600,"_601":602,"_603":604,"_605":606,"_607":608,"_609":610},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · backend