`, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_265":266,"_267":268},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_114":95,"_32":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":30,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",4,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","fb6838c5-ef23-4ea0-81ab-f9aff9dec337","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/components/api.ts","latestPath","fileId","9c79e438-b290-11f1-b5ab-1607ee4eb77e","name","api.ts","fileType","script","content","// Client-side API helpers + shared types.\n\nexport type Card = {\n code: string;\n balance: number; // cents\n initial: number; // cents\n status: \"inactive\" | \"active\" | \"void\";\n batch: string | null;\n note: string | null;\n created_at: string;\n activated_at: string | null;\n};\n\nexport type Txn = {\n id: number;\n code: string;\n kind: string;\n amount: number;\n balance_after: number;\n store: string | null;\n created_at: string;\n};\n\nexport type Stats = {\n total: number;\n active: number;\n inactive: number;\n outstandingCents: number;\n};\n\nasync function req(path: string, init?: RequestInit): Promise {\n const res = await fetch(path, {\n ...init,\n headers: { \"Content-Type\": \"application/json\", ...(init?.headers ?? {}) },\n });\n const data = await res.json().catch(() => ({}));\n if (!res.ok) {\n throw new Error((data as { error?: string }).error || `Request failed (${res.status})`);\n }\n return data as T;\n}\n\nexport const api = {\n stats: () => req(\"/api/stats\"),\n\n listCards: (limit = 50) => req<{ cards: Card[] }>(`/api/cards?limit=${limit}`),\n\n getCard: (code: string) =>\n req<{ card: Card; txns: Txn[] }>(`/api/cards/${encodeURIComponent(code)}`),\n\n generate: (body: {\n count: number;\n amount?: number;\n amountCents?: number;\n prefix?: string;\n note?: string;\n }) =>\n req<{ created: number; cards: Card[] }>(\"/api/cards/generate\", {\n method: \"POST\",\n body: JSON.stringify(body),\n }),\n\n activate: (code: string, body: { amount?: number; amountCents?: number } = {}) =>\n req<{ card: Card }>(`/api/cards/${encodeURIComponent(code)}/activate`, {\n method: \"POST\",\n body: JSON.stringify(body),\n }),\n\n redeem: (code: string, body: { amount?: number; amountCents?: number; store?: string }) =>\n req<{ card: Card; message: string }>(\n `/api/cards/${encodeURIComponent(code)}/redeem`,\n { method: \"POST\", body: JSON.stringify(body) },\n ),\n\n void: (code: string) =>\n req<{ card: Card }>(`/api/cards/${encodeURIComponent(code)}/void`, {\n method: \"POST\",\n }),\n\n txns: (limit = 100) => req<{ txns: Txn[] }>(`/api/txns?limit=${limit}`),\n};\n\n/** cents → \"$12.34\" */\nexport function fmt(cents: number): string {\n return `$${(cents / 100).toFixed(2)}`;\n}\n\n/** Parse a dollars string (\"12.50\") into integer cents. */\nexport function parseDollars(s: string): number {\n const n = Number(s);\n if (!Number.isFinite(n) || n < 0) throw new Error(\"Enter a valid amount\");\n return Math.round(n * 100);\n}","createdAt",["D",1789646959538],"branchVersion","branchId","57a6487e-c99e-4332-92e2-6d15ca868b6a","id","dc85dda4-95e6-4479-97de-662e1fc771d9","card-redeem",["D",1789646679801],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Gift-card API with QR redeem scanner UI","imageUrl","d6d32317-8e12-4003-b452-8bd4229aeca3","pinnedFileId","01a0af41-2f44-7689-90a1-221a99b90e3a","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0a0c6-84d9-72a5-9904-46bf8e8a5e5f","tursoName","dc85dda495e6447997de662e1fc771d9","tursoHostname","dc85dda495e6447997de662e1fc771d9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789650647385],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":60,"_110":111,"_112":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","IceyDomain","handle","displayName","Nathaniel Barrett","avatar","https://avatars.githubusercontent.com/u/174974902?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":260,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":261,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":262,"_89":263,"_91":264,"_93":30},"tree",[187,195,196,197,198],"files",[187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_177":68,"_178":147,"_179":68,"_180":181,"_182":183},"contents",[136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":171,"_37":172,"_35":173,"_143":-5,"_46":47,"_45":147,"_145":64,"_43":174,"_13":68,"_39":175,"_41":-5,"_29":30,"_150":-5,"_32":176},{"_48":165,"_37":166,"_35":167,"_143":-5,"_46":47,"_45":147,"_145":64,"_43":168,"_13":68,"_39":26,"_41":169,"_29":30,"_150":-5,"_32":170},{"_48":159,"_37":160,"_35":161,"_143":-5,"_46":47,"_45":147,"_145":30,"_43":162,"_13":68,"_39":26,"_41":163,"_29":30,"_150":-5,"_32":164},{"_48":152,"_37":153,"_35":154,"_143":-5,"_46":47,"_45":155,"_145":30,"_43":156,"_13":68,"_39":40,"_41":157,"_29":30,"_150":-5,"_32":158},{"_48":141,"_37":142,"_35":62,"_143":-5,"_46":47,"_45":144,"_145":30,"_43":146,"_13":147,"_39":148,"_41":149,"_29":30,"_150":50,"_32":151},"92c1637d-f08d-4267-989f-5a63f9bb5fbd","index.ts","parentId",3,"latest",["D",1789646714535],1,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport {\n activateCard,\n fmtCents,\n generateCards,\n getCard,\n listCards,\n listTxns,\n redeemCard,\n refund,\n stats,\n toCents,\n topUp,\n voidCard,\n} from \"./cards.ts\";\n\nconst app = new Hono();\n\n// ---------------------------------------------------------------------------\n// Card API. Everything the frontend (or a store's scanner) needs.\n// Errors are returned as { error } with a 4xx/5xx status.\n// ---------------------------------------------------------------------------\n\n/** Wrap a handler so thrown errors become clean JSON. */\nfunction handle(fn: () => Promise) {\n return fn()\n .then((data) => Response.json(data))\n .catch((e: unknown) => {\n const msg = e instanceof Error ? e.message : String(e);\n return Response.json({ error: msg }, { status: 400 });\n });\n}\n\n// Batch stats (for the dashboard header)\napp.get(\"/api/stats\", () => handle(async () => await stats()));\n\n// Generate a batch of INACTIVE cards\napp.post(\"/api/cards/generate\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n return handle(async () => {\n const count = Number(body.count ?? 10);\n // Accept either dollars or cents explicitly.\n const amountCents = body.amountCents != null\n ? Number(body.amountCents)\n : toCents(Number(body.amount ?? 25));\n const cards = await generateCards({\n count,\n amountCents,\n batch: body.batch,\n prefix: body.prefix,\n note: body.note,\n });\n return { created: cards.length, cards };\n });\n});\n\n// List recent cards (optionally by batch)\napp.get(\"/api/cards\", (c) =>\n handle(async () => {\n const batch = c.req.query(\"batch\") || undefined;\n const limit = Number(c.req.query(\"limit\") ?? 50);\n return { cards: await listCards(limit, batch) };\n }));\n\n// Look up one card + its transaction history\napp.get(\"/api/cards/:code\", (c) =>\n handle(async () => {\n const code = c.req.param(\"code\");\n const card = await getCard(code);\n if (!card) throw new Error(\"Card not found\");\n return { card, txns: await listTxns(card.code, 50) };\n }));\n\n// Activate (sell) a card\napp.post(\"/api/cards/:code/activate\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n return handle(async () => {\n const amountCents = body.amountCents != null\n ? Number(body.amountCents)\n : body.amount != null\n ? toCents(Number(body.amount))\n : undefined;\n return { card: await activateCard(c.req.param(\"code\"), amountCents) };\n });\n});\n\n// Redeem (spend) — the scanner calls this\napp.post(\"/api/cards/:code/redeem\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n return handle(async () => {\n const amountCents = body.amountCents != null\n ? Number(body.amountCents)\n : toCents(Number(body.amount));\n const card = await redeemCard(c.req.param(\"code\"), amountCents, body.store);\n return { card, message: `Redeemed ${fmtCents(amountCents)}` };\n });\n});\n\n// Top up / refund\napp.post(\"/api/cards/:code/topup\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n return handle(async () => {\n const amountCents = body.amountCents != null\n ? Number(body.amountCents)\n : toCents(Number(body.amount));\n return { card: await topUp(c.req.param(\"code\"), amountCents) };\n });\n});\n\napp.post(\"/api/cards/:code/refund\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n return handle(async () => {\n const amountCents = body.amountCents != null\n ? Number(body.amountCents)\n : toCents(Number(body.amount));\n return { card: await refund(c.req.param(\"code\"), amountCents) };\n });\n});\n\n// Void a card (lost/stolen/compromised)\napp.post(\"/api/cards/:code/void\", (c) =>\n handle(async () => ({ card: await voidCard(c.req.param(\"code\")) })));\n\n// Recent transactions across all cards\napp.get(\"/api/txns\", (c) =>\n handle(async () => {\n const code = c.req.query(\"code\") || undefined;\n return { txns: await listTxns(code, Number(c.req.query(\"limit\") ?? 100)) };\n }));\n\n// ---------------------------------------------------------------------------\n// Frontend\n// ---------------------------------------------------------------------------\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","label",[142],"e1b1a67c-fb9b-436a-aca5-60b0f32f93f5","cards.ts","04e5b21e-b290-11f1-b02b-1607ee4eb77e",2,["D",1789646705223],"// ---------------------------------------------------------------------------\n// Card engine — the \"card is a key, not a wallet\" model.\n//\n// The QR code only ever contains a random CODE. All balances live here, in the\n// database, behind the server. Nothing the card says is trusted.\n// ---------------------------------------------------------------------------\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Money is stored in CENTS as integers — never floats (no 0.1 + 0.2 problems).\nexport type Card = {\n code: string;\n balance: number; // cents, current\n initial: number; // cents, face value when activated\n status: \"inactive\" | \"active\" | \"void\";\n batch: string | null;\n note: string | null;\n created_at: string;\n activated_at: string | null;\n};\n\nexport type Txn = {\n id: number;\n code: string;\n kind: \"generate\" | \"activate\" | \"redeem\" | \"refund\" | \"topup\" | \"void\";\n amount: number; // cents, signed (negative = spent)\n balance_after: number;\n store: string | null;\n created_at: string;\n};\n\n// ----------------------------- Schema -----------------------------\nlet schemaReady: Promise | null = null;\n\nexport function ensureSchema(): Promise {\n // Idempotent + cached so we don't re-run DDL on every request.\n if (!schemaReady) {\n schemaReady = (async () => {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS cards (\n code TEXT PRIMARY KEY,\n balance INTEGER NOT NULL DEFAULT 0,\n initial INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'inactive',\n batch TEXT,\n note TEXT,\n created_at TEXT NOT NULL,\n activated_at TEXT\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS card_txns (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n code TEXT NOT NULL,\n kind TEXT NOT NULL,\n amount INTEGER NOT NULL,\n balance_after INTEGER NOT NULL,\n store TEXT,\n created_at TEXT NOT NULL\n )`,\n },\n { sql: `CREATE INDEX IF NOT EXISTS idx_txn_code ON card_txns (code)` },\n { sql: `CREATE INDEX IF NOT EXISTS idx_cards_batch ON cards (batch)` },\n ]);\n })();\n }\n return schemaReady;\n}\n\n// --------------------------- Code generation ---------------------------\n// Unambiguous alphabet: no I, O, 0, 1 — so humans can read a card aloud.\nconst ALPHABET = \"ABCDEFGHJKLMNPQRSTUVWXYZ23456789\";\n\nfunction randomCode(prefix: string, groups = 3, size = 4): string {\n const bytes = new Uint8Array(groups * size);\n crypto.getRandomValues(bytes);\n const chars = Array.from(bytes, (b) => ALPHABET[b % ALPHABET.length]);\n const parts: string[] = [];\n for (let i = 0; i < groups; i++) {\n parts.push(chars.slice(i * size, (i + 1) * size).join(\"\"));\n }\n return `${prefix}-${parts.join(\"-\")}`;\n}\n\nfunction now(): string {\n return new Date().toISOString();\n}\n\n// --------------------------- Lifecycle ---------------------------\n\n/**\n * Create a batch of cards. They start INACTIVE and worth nothing — a box of\n * stolen, unprinted-in-store cards is worthless until activated at the till.\n */\nexport async function generateCards(opts: {\n count: number;\n amountCents: number;\n batch?: string;\n prefix?: string;\n note?: string;\n}): Promise {\n await ensureSchema();\n const count = Math.min(Math.max(1, Math.floor(opts.count)), 500);\n const prefix = (opts.prefix || \"NBL\").toUpperCase().slice(0, 8);\n const batch = opts.batch || `B${Date.now().toString(36).toUpperCase()}`;\n const created: Card[] = [];\n\n // Retry on the astronomically unlikely code collision.\n for (let i = 0; i < count; i++) {\n let inserted = false;\n for (let attempt = 0; attempt < 5 && !inserted; attempt++) {\n const code = randomCode(prefix);\n const res = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO cards\n (code, balance, initial, status, batch, note, created_at)\n VALUES (?, 0, ?, 'inactive', ?, ?, ?)`,\n args: [code, opts.amountCents, batch, opts.note ?? null, now()],\n });\n if (res.rowsAffected > 0) {\n inserted = true;\n created.push({\n code,\n balance: 0,\n initial: opts.amountCents,\n status: \"inactive\",\n batch,\n note: opts.note ?? null,\n created_at: now(),\n activated_at: null,\n });\n }\n }\n }\n return created;\n}\n\nexport async function getCard(code: string): Promise {\n await ensureSchema();\n const res = await sqlite.execute({\n sql: \"SELECT * FROM cards WHERE code = ?\",\n args: [normalize(code)],\n });\n return (res.rows[0] as Card | undefined) ?? null;\n}\n\nexport async function listCards(limit = 50, batch?: string): Promise {\n await ensureSchema();\n const res = batch\n ? await sqlite.execute({\n sql: \"SELECT * FROM cards WHERE batch = ? ORDER BY created_at DESC LIMIT ?\",\n args: [batch, limit],\n })\n : await sqlite.execute({\n sql: \"SELECT * FROM cards ORDER BY created_at DESC LIMIT ?\",\n args: [limit],\n });\n return res.rows as unknown as Card[];\n}\n\n/** Sell a card: give it its face value and make it spendable. */\nexport async function activateCard(\n code: string,\n amountCents?: number,\n): Promise {\n await ensureSchema();\n const c = normalize(code);\n const card = await getCard(c);\n if (!card) throw new Error(\"Card not found\");\n if (card.status === \"void\") throw new Error(\"Card is void\");\n if (card.status === \"active\") throw new Error(\"Card is already active\");\n\n const value = amountCents ?? card.initial;\n const ts = now();\n await sqlite.batch([\n {\n sql: `UPDATE cards SET status = 'active', balance = ?, initial = ?, activated_at = ?\n WHERE code = ? AND status = 'inactive'`,\n args: [value, value, ts, c],\n },\n {\n sql: `INSERT INTO card_txns (code, kind, amount, balance_after, store, created_at)\n VALUES (?, 'activate', ?, ?, NULL, ?)`,\n args: [c, value, value, ts],\n },\n ]);\n return (await getCard(c))!;\n}\n\n/**\n * Spend. The single conditional UPDATE is what prevents double-spend: if two\n * registers scan the same card at once, only one update can match the row.\n */\nexport async function redeemCard(\n code: string,\n amountCents: number,\n store?: string,\n): Promise {\n await ensureSchema();\n const c = normalize(code);\n if (!Number.isInteger(amountCents) || amountCents <= 0) {\n throw new Error(\"Amount must be a positive number of cents\");\n }\n\n const card = await getCard(c);\n if (!card) throw new Error(\"Card not found\");\n if (card.status === \"void\") throw new Error(\"Card is void\");\n if (card.status === \"inactive\") throw new Error(\"Card is not active — activate it first\");\n if (card.balance < amountCents) throw new Error(\"Insufficient balance\");\n\n const res = await sqlite.execute({\n sql: `UPDATE cards SET balance = balance - ?\n WHERE code = ? AND status = 'active' AND balance >= ?`,\n args: [amountCents, c, amountCents],\n });\n if (res.rowsAffected === 0) {\n throw new Error(\"Redeem failed — card changed state. Try again.\");\n }\n\n const after = (await getCard(c))!;\n await sqlite.execute({\n sql: `INSERT INTO card_txns (code, kind, amount, balance_after, store, created_at)\n VALUES (?, 'redeem', ?, ?, ?, ?)`,\n args: [c, -amountCents, after.balance, store ?? null, now()],\n });\n return after;\n}\n\nexport async function topUp(code: string, amountCents: number): Promise {\n return adjust(code, amountCents, \"topup\");\n}\n\nexport async function refund(code: string, amountCents: number): Promise {\n return adjust(code, amountCents, \"refund\");\n}\n\nasync function adjust(\n code: string,\n amountCents: number,\n kind: \"topup\" | \"refund\",\n): Promise {\n await ensureSchema();\n const c = normalize(code);\n if (!Number.isInteger(amountCents) || amountCents <= 0) {\n throw new Error(\"Amount must be a positive number of cents\");\n }\n const card = await getCard(c);\n if (!card) throw new Error(\"Card not found\");\n if (card.status === \"void\") throw new Error(\"Card is void\");\n\n await sqlite.execute({\n sql: \"UPDATE cards SET balance = balance + ? WHERE code = ?\",\n args: [amountCents, c],\n });\n const after = (await getCard(c))!;\n await sqlite.execute({\n sql: `INSERT INTO card_txns (code, kind, amount, balance_after, store, created_at)\n VALUES (?, ?, ?, ?, NULL, ?)`,\n args: [c, kind, amountCents, after.balance, now()],\n });\n return after;\n}\n\nexport async function voidCard(code: string): Promise {\n await ensureSchema();\n const c = normalize(code);\n const card = await getCard(c);\n if (!card) throw new Error(\"Card not found\");\n\n await sqlite.batch([\n { sql: \"UPDATE cards SET status = 'void', balance = 0 WHERE code = ?\", args: [c] },\n {\n sql: `INSERT INTO card_txns (code, kind, amount, balance_after, store, created_at)\n VALUES (?, 'void', ?, 0, NULL, ?)`,\n args: [c, -card.balance, now()],\n },\n ]);\n return (await getCard(c))!;\n}\n\nexport async function listTxns(code?: string, limit = 100): Promise {\n await ensureSchema();\n const res = code\n ? await sqlite.execute({\n sql: \"SELECT * FROM card_txns WHERE code = ? ORDER BY id DESC LIMIT ?\",\n args: [normalize(code), limit],\n })\n : await sqlite.execute({\n sql: \"SELECT * FROM card_txns ORDER BY id DESC LIMIT ?\",\n args: [limit],\n });\n return res.rows as unknown as Txn[];\n}\n\nexport async function stats(): Promise<{\n total: number;\n active: number;\n inactive: number;\n outstandingCents: number;\n}> {\n await ensureSchema();\n const res = await sqlite.execute({\n sql: `SELECT\n COUNT(*) AS total,\n SUM(CASE WHEN status = 'active' THEN 1 ELSE 0 END) AS active,\n SUM(CASE WHEN status = 'inactive' THEN 1 ELSE 0 END) AS inactive,\n SUM(CASE WHEN status = 'active' THEN balance ELSE 0 END) AS outstanding\n FROM cards`,\n });\n const r = res.rows[0] as Record;\n return {\n total: Number(r.total ?? 0),\n active: Number(r.active ?? 0),\n inactive: Number(r.inactive ?? 0),\n outstandingCents: Number(r.outstanding ?? 0),\n };\n}\n\n/** Accept codes with spaces, lowercase, or missing dashes. */\nexport function normalize(code: string): string {\n return code.trim().toUpperCase().replace(/\\s+/g, \"\");\n}\n\n// --------------------------- Money helpers ---------------------------\nexport function toCents(dollars: number | string): number {\n const n = typeof dollars === \"string\" ? Number(dollars) : dollars;\n if (!Number.isFinite(n) || n < 0) throw new Error(\"Invalid amount\");\n return Math.round(n * 100);\n}\n\nexport function fmtCents(cents: number): string {\n return `$${(cents / 100).toFixed(2)}`;\n}",[153],"1fe5fc1a-d1ff-4ef6-95d7-e16ed699a102","README.md","01a0af41-2f44-7689-90a1-1c808e231f8d",["D",1789646679801],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[160],"c9a644e8-51ac-452f-a73c-57220fd87ef2","CHANGELOG.md","01a0af41-2f44-7689-90a1-1b65a816daa2",["D",1789646679801],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v4