\n \n \n","label",[174,65],"frontend","pulls",1,"branches","forks","envVars",{"_183":26,"_185":26},"connections",{"_183":26,"_184":26},"count","unfilledCount","emptyCount",{"_34":441,"_13":420,"_63":412,"_44":-5,"_36":37,"_166":106,"_167":101,"_38":442,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":443,"_17":444},{"_34":437,"_13":429,"_63":424,"_44":412,"_36":37,"_166":106,"_167":101,"_38":438,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":439,"_17":440},{"_34":430,"_13":431,"_63":432,"_44":424,"_36":37,"_166":129,"_167":101,"_38":433,"_40":106,"_66":240,"_170":434,"_67":24,"_172":-5,"_224":435,"_17":436},{"_34":421,"_13":422,"_63":423,"_44":424,"_36":37,"_166":129,"_167":101,"_38":425,"_40":41,"_66":240,"_170":426,"_67":24,"_172":-5,"_224":427,"_17":428},{"_34":410,"_13":411,"_63":99,"_44":412,"_36":37,"_166":248,"_167":101,"_38":413,"_40":414,"_66":415,"_170":416,"_67":24,"_172":417,"_224":418,"_17":419},{"_34":406,"_13":174,"_63":165,"_44":-5,"_36":37,"_166":41,"_167":101,"_38":407,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":408,"_17":409},{"_34":402,"_13":361,"_63":356,"_44":165,"_36":37,"_166":297,"_167":101,"_38":403,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":404,"_17":405},{"_34":394,"_13":331,"_63":395,"_44":356,"_36":37,"_166":396,"_167":101,"_38":397,"_40":398,"_66":240,"_170":399,"_67":24,"_172":-5,"_224":400,"_17":401},{"_34":387,"_13":388,"_63":389,"_44":356,"_36":37,"_166":365,"_167":101,"_38":390,"_40":176,"_66":240,"_170":391,"_67":24,"_172":-5,"_224":392,"_17":393},{"_34":378,"_13":379,"_63":380,"_44":356,"_36":37,"_166":381,"_167":101,"_38":382,"_40":383,"_66":240,"_170":384,"_67":24,"_172":-5,"_224":385,"_17":386},{"_34":370,"_13":371,"_63":372,"_44":356,"_36":37,"_166":373,"_167":101,"_38":374,"_40":106,"_66":240,"_170":375,"_67":24,"_172":-5,"_224":376,"_17":377},{"_34":362,"_13":363,"_63":364,"_44":356,"_36":37,"_166":365,"_167":101,"_38":366,"_40":169,"_66":240,"_170":367,"_67":24,"_172":-5,"_224":368,"_17":369},{"_34":353,"_13":354,"_63":355,"_44":356,"_36":37,"_166":280,"_167":101,"_38":357,"_40":106,"_66":240,"_170":358,"_67":24,"_172":-5,"_224":359,"_17":360},{"_34":164,"_13":65,"_63":64,"_44":165,"_36":37,"_166":81,"_167":101,"_38":350,"_40":169,"_66":21,"_170":171,"_67":24,"_172":-5,"_224":351,"_17":352},{"_34":343,"_13":344,"_63":345,"_44":165,"_36":37,"_166":248,"_167":101,"_38":346,"_40":41,"_66":240,"_170":347,"_67":24,"_172":-5,"_224":348,"_17":349},{"_34":339,"_13":268,"_63":262,"_44":-5,"_36":37,"_166":272,"_167":101,"_38":340,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":341,"_17":342},{"_34":330,"_13":331,"_63":332,"_44":262,"_36":37,"_166":333,"_167":101,"_38":334,"_40":335,"_66":240,"_170":336,"_67":24,"_172":-5,"_224":337,"_17":338},{"_34":323,"_13":324,"_63":325,"_44":262,"_36":37,"_166":272,"_167":101,"_38":326,"_40":26,"_66":240,"_170":327,"_67":24,"_172":-5,"_224":328,"_17":329},{"_34":315,"_13":316,"_63":317,"_44":262,"_36":37,"_166":318,"_167":101,"_38":319,"_40":41,"_66":240,"_170":320,"_67":24,"_172":-5,"_224":321,"_17":322},{"_34":308,"_13":309,"_63":310,"_44":262,"_36":37,"_166":272,"_167":101,"_38":311,"_40":26,"_66":240,"_170":312,"_67":24,"_172":-5,"_224":313,"_17":314},{"_34":301,"_13":302,"_63":303,"_44":262,"_36":37,"_166":280,"_167":101,"_38":304,"_40":176,"_66":240,"_170":305,"_67":24,"_172":-5,"_224":306,"_17":307},{"_34":292,"_13":293,"_63":294,"_44":262,"_36":37,"_166":295,"_167":101,"_38":296,"_40":297,"_66":240,"_170":298,"_67":24,"_172":-5,"_224":299,"_17":300},{"_34":285,"_13":286,"_63":287,"_44":262,"_36":37,"_166":272,"_167":101,"_38":288,"_40":26,"_66":240,"_170":289,"_67":24,"_172":-5,"_224":290,"_17":291},{"_34":277,"_13":278,"_63":279,"_44":262,"_36":37,"_166":280,"_167":101,"_38":281,"_40":176,"_66":240,"_170":282,"_67":24,"_172":-5,"_224":283,"_17":284},{"_34":269,"_13":270,"_63":271,"_44":262,"_36":37,"_166":272,"_167":101,"_38":273,"_40":26,"_66":240,"_170":274,"_67":24,"_172":-5,"_224":275,"_17":276},{"_34":259,"_13":260,"_63":261,"_44":262,"_36":37,"_166":263,"_167":101,"_38":264,"_40":176,"_66":240,"_170":265,"_67":24,"_172":-5,"_224":266,"_17":267},{"_34":254,"_13":244,"_63":238,"_44":-5,"_36":37,"_166":169,"_167":101,"_38":255,"_40":26,"_66":256,"_170":-5,"_67":24,"_172":-5,"_224":257,"_17":258},{"_34":245,"_13":246,"_63":247,"_44":238,"_36":37,"_166":248,"_167":101,"_38":249,"_40":250,"_66":240,"_170":251,"_67":24,"_172":-5,"_224":252,"_17":253},{"_34":235,"_13":236,"_63":237,"_44":238,"_36":37,"_166":169,"_167":101,"_38":239,"_40":26,"_66":240,"_170":241,"_67":24,"_172":-5,"_224":242,"_17":243},{"_34":227,"_13":228,"_63":229,"_44":-5,"_36":37,"_166":129,"_167":101,"_38":230,"_40":231,"_66":21,"_170":232,"_67":24,"_172":-5,"_224":233,"_17":234},{"_34":217,"_13":218,"_63":219,"_44":-5,"_36":37,"_166":220,"_167":101,"_38":221,"_40":222,"_66":21,"_170":223,"_67":24,"_172":-5,"_224":225,"_17":226},"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",[],[218],"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",[],[228],"5343bcb0-14cd-11f0-b10b-569c3dd06744","types.ts","5343bd78-14cd-11f0-b10b-569c3dd06744","add21c84-9f00-4405-af88-6ec5134089df",["D",1744153254621],"script","/**\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}",[],[244,236],"shared","b51b1732-0f84-11f1-b328-42dde27851f2","routes.ts","7639f8f6-14d2-11f0-97d5-569c3dd06744",167,["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];",[],[244,246],"5343c3fe-14cd-11f0-b10b-569c3dd06744",["D",1744153254621],"directory",[213,214],[244],"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}",[],[268,260],"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}",[],[268,270],"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}",[],[268,278],"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}",[],[268,286],"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}",[],[268,293],"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}",[],[268,302],"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}",[],[268,309],"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}",[],[268,316],"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}",[],[268,324],"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}",[],[268,331],"f8ffd76c-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],[202,203,204,205,206,207,208,209,210,211],[268],"b51b0576-0f84-11f1-b328-42dde27851f2","index.tsx","95142d28-14cd-11f0-b4b7-569c3dd06744",["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);",[],[174,344],["D",1744155820694],[],[174,65],"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}",[],[174,361,354],"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}",[],[174,361,363],"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}",[],[174,361,371],"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}",[],[174,361,379],"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}",[],[174,361,388],"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}",[],[174,361,331],"68b50b94-14cd-11f0-98df-569c3dd06744",["D",1744153290594],[193,194,195,196,197,198],[174,361],"65bd0400-14cd-11f0-9e26-569c3dd06744",["D",1744153285607],[192,199,200],[174],"b51adf74-0f84-11f1-b328-42dde27851f2","index.ts","50aca1db-e744-46f9-883e-ba00e55ffc58",["D",1771719807352],45,"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// Create a static handler for server-side rendering\nconst { query, dataRoutes } = createStaticHandler(routes);\n\n// Handle all other routes with React Router\napp.all(\"*\", async (c) => {\n const isDataRequest = c.req.header(\"X-Data-Request\") === \"true\";\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 (e.g., redirects from actions)\n if (context instanceof Response) {\n if (isDataRequest && context.status >= 300 && context.status < 400) {\n // For data requests, convert redirects to JSON so the client can handle them\n const location = context.headers.get(\"Location\");\n console.log(\"[data-request] redirect to:\", location);\n return Response.json({ redirect: location });\n }\n return context;\n }\n\n // Data-only request: return loaderData/actionData as JSON keyed by route ID\n if (isDataRequest) {\n console.log(\"[data-request] loaderData keys:\", Object.keys(context.loaderData || {}));\n console.log(\"[data-request] actionData keys:\", Object.keys(context.actionData || {}));\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 // 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;","react-router-7-example",[],[420,411],"backend","b26e6cda-0fe5-11f1-bc51-42dde27851f2","queries.ts","6229805c-14cd-11f0-800b-569c3dd06744","4af61b55-4e6e-48ee-bb08-a35baadaf267",["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",[],[420,429,422],"database","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",[],[420,429,431],"5ae47cc0-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[188,189],[420,429],"5ae47a2c-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[187,190],[420],["D",1744152661331],["D",1789558275908],{"_11":12,"_142":70},{"_11":12,"_138":-5,"_69":70,"_30":68,"_139":140,"_141":24},{"_40":129,"_13":16,"_34":37,"_130":88,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_53":-5,"_161":483,"_484":485,"_486":487,"_488":24,"_489":24,"_490":24,"_491":101,"_492":-5,"_493":-7,"_494":-7,"_495":26,"_496":24,"_497":24,"_498":-5,"_499":24,"_500":24,"_501":24,"_502":-5},"ENV",{"_454":455,"_456":457,"_458":16,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482},"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 · index.html