\n \n

Know what is safe to spend.

A private household cash-flow view. Your data stays behind your Val Town account.

\n Log in with Val Town\n

\n \n );\n }\n if (!session.authorized) {\n return

Account not authorized

Signed in as {session.username}. Only the app owner and explicitly allowed family accounts can access this data.

;\n }\n if (!data) return ;\n\n return (\n

\n \n

\n {session.username}\n \n

\n \n

\n\n

\n {error &&

{error}

}\n {data.accounts.length === 0 ? (\n mutate(\"/api/demo\", \"POST\")}\n onAccount={() => setEditor({ type: \"account\" })}\n onCleanupDemo={cleanupDemo}\n />\n ) : view === \"overview\" ? (\n setEditor({ type: \"transaction\" })}\n onAddPlanned={() => setEditor({ type: \"planned\" })}\n onCleanupDemo={cleanupDemo}\n />\n ) : view === \"activity\" ? (\n setEditor({ type: \"transaction\" })} onEdit={(item) => setEditor({ type: \"transaction\", item })} onDelete={(id) => confirmed(\"Delete this transaction and reverse its balance effect?\") && mutate(`/api/transactions/${id}`, \"DELETE\")} />\n ) : view === \"planned\" ? (\n setEditor({ type: \"planned\" })} onEdit={(item) => setEditor({ type: \"planned\", item })} onComplete={(item) => mutate(`/api/planned/${item.id}/complete`, \"POST\", { date: today(), accountId: item.accountId ?? data.accounts[0]?.id })} onDelete={(id) => confirmed(\"Delete this planned item?\") && mutate(`/api/planned/${id}`, \"DELETE\")} />\n ) : view === \"reserves\" ? (\n setEditor({ type: \"reserve\" })} onEdit={(item) => setEditor({ type: \"reserve\", item })} onDelete={(id) => confirmed(\"Delete this reserve?\") && mutate(`/api/reserves/${id}`, \"DELETE\")} />\n ) : (\n setEditor({ type: \"account\" })} onEdit={(item) => setEditor({ type: \"account\", item })} onDelete={(id) => confirmed(\"Delete this empty account?\") && mutate(`/api/accounts/${id}`, \"DELETE\")} />\n )}\n

\n\n {editor && (\n setEditor(null)} onSave={async (payload) => {\n const item = editor.item;\n const base = editor.type === \"transaction\" ? \"/api/transactions\" : editor.type === \"planned\" ? \"/api/planned\" : editor.type === \"reserve\" ? \"/api/reserves\" : \"/api/accounts\";\n await mutate(item ? `${base}/${item.id}` : base, item ? \"PUT\" : \"POST\", payload);\n }} />\n )}\n \n

\n );\n}\n\nfunction Overview({ data, onAddTransaction, onAddPlanned, onCleanupDemo }: { data: AppData; onAddTransaction: () => void; onAddPlanned: () => void; onCleanupDemo: () => void }) {\n const d = data.dashboard;\n return (\n

\n {data.demoDataState === \"demo-only\" && (\n

Synthetic demo data

This dataset contains demo records only. Cleanup permanently removes all of them.

\n \n

\n )}\n

HOUSEHOLD CASH FLOW

Your money this month

As of {prettyDate(d.asOfDate)}

\n\n

Safe to spend

{money(d.safeToSpendCents)}

Cash now, plus expected income, minus unpaid commitments and protected reserves through {prettyDate(d.monthEnd)}.

\n\n

\n \n \n \n \n

\n\n

\n \n

\n {d.upcoming.length === 0 ? Nothing else is planned this month. : d.upcoming.slice(0, 8).map((item, index) => (\n

\n \n

{item.description}

{item.kind}

\n \n

\n ))}\n

\n \n

\n \n \n

\n );\n}\n\nfunction Activity({ data, onAdd, onEdit, onDelete }: { data: AppData; onAdd: () => void; onEdit: (item: Transaction) => void; onDelete: (id: string) => void }) {\n const accounts = useMemo(() => Object.fromEntries(data.accounts.map((a) => [a.id, a.name])), [data.accounts]);\n return

{data.transactions.length === 0 ? No transactions yet. : data.transactions.map((item) => onEdit(item) : undefined} onDelete={item.source === \"manual\" ? () => onDelete(item.id) : undefined} />)}

;\n}\n\nfunction Planned({ data, onAdd, onEdit, onComplete, onDelete }: { data: AppData; onAdd: () => void; onEdit: (item: PlannedTransaction) => void; onComplete: (item: PlannedTransaction) => void; onDelete: (id: string) => void }) {\n return

{data.plannedTransactions.length === 0 ? No planned items yet. : data.plannedTransactions.map((item) =>

{item.description}

{item.recurrence === \"once\" ? \"One-off\" : `Every ${item.intervalCount > 1 ? `${item.intervalCount} ` : \"\"}${item.recurrence.replace(\"ly\", \"\")}${item.intervalCount > 1 ? \"s\" : \"\"}`}{!item.isActive && Inactive}

Next: {prettyDate(item.nextDate)}

onEdit(item)}>Edit onDelete(item.id)}>Delete{item.isActive && onComplete(item)}>Mark {item.kind === \"expense\" ? \"paid\" : \"received\"}}

)}

;\n}\n\nfunction Reserves({ data, onAdd, onEdit, onDelete }: { data: AppData; onAdd: () => void; onEdit: (item: Reserve) => void; onDelete: (id: string) => void }) {\n return

{data.reserves.length === 0 ? No reserves yet. : data.reserves.map((item) =>

{item.name}

{item.note || \"Protected funds\"}

{money(item.amountCents)}

onEdit(item)}>Edit onDelete(item.id)}>Delete

)}

;\n}\n\nfunction Accounts({ data, onAdd, onEdit, onDelete }: { data: AppData; onAdd: () => void; onEdit: (item: Account) => void; onDelete: (id: string) => void }) {\n return

{data.accounts.map((item) =>

{item.type}

{item.name}

{money(item.balanceCents)}

onEdit(item)}>Edit onDelete(item.id)}>Delete

)}

;\n}\n\nfunction EditorModal({ editor, data, busy, onClose, onSave }: { editor: NonNullable; data: AppData; busy: boolean; onClose: () => void; onSave: (payload: unknown) => Promise }) {\n const item = editor.item;\n const baseDate = today();\n const initial = item ? itemToForm(editor.type, item) : editor.type === \"account\" ? { name: \"\", type: \"checking\", balance: \"0.00\", isActive: true } : editor.type === \"transaction\" ? { description: \"\", kind: \"expense\", amount: \"\", date: baseDate, accountId: data.accounts[0]?.id ?? \"\" } : editor.type === \"planned\" ? { description: \"\", kind: \"expense\", amount: \"\", nextDate: baseDate, recurrence: \"monthly\", intervalCount: \"1\", endDate: \"\", accountId: data.accounts[0]?.id ?? \"\", isActive: true } : { name: \"\", amount: \"\", note: \"\", isActive: true };\n const [form, setForm] = useState>(initial);\n const [formError, setFormError] = useState(\"\");\n const set = (key: string) => (event: FormEvent) => {\n const target = event.currentTarget as HTMLInputElement | HTMLSelectElement | HTMLTextAreaElement;\n setForm((current) => ({ ...current, [key]: target instanceof HTMLInputElement && target.type === \"checkbox\" ? target.checked : target.value }));\n };\n const submit = async (event: FormEvent) => {\n event.preventDefault();\n setFormError(\"\");\n try {\n const amountCents = editor.type === \"account\"\n ? parseMoney(String(form.balance), true)\n : parseMoney(String(form.amount));\n const payload = editor.type === \"account\" ? { name: form.name, type: form.type, balanceCents: amountCents, isActive: form.isActive ?? true }\n : editor.type === \"transaction\" ? { description: form.description, kind: form.kind, amountCents, date: form.date, accountId: form.accountId }\n : editor.type === \"planned\" ? { description: form.description, kind: form.kind, amountCents, nextDate: form.nextDate, recurrence: form.recurrence, intervalCount: Number(form.intervalCount), endDate: form.endDate || null, accountId: form.accountId || null, isActive: form.isActive ?? true }\n : { name: form.name, amountCents, note: form.note, isActive: form.isActive ?? true };\n await onSave(payload);\n } catch (err) {\n setFormError(messageOf(err));\n }\n };\n const title = `${item ? \"Edit\" : \"Add\"} ${editor.type === \"planned\" ? \"planned item\" : editor.type}`;\n return (\n

e.target === e.currentTarget && onClose()}>\n

{title}

\n {editor.type === \"account\" && <>}\n {editor.type === \"transaction\" && <>

}\n {editor.type === \"planned\" && <>

}\n {editor.type === \"reserve\" && <>

</Field></>}\n          {item && editor.type !== \"transaction\" && <label className=\"flex items-center gap-3 text-sm\"><input type=\"checkbox\" checked={Boolean(form.isActive)} onChange={set(\"isActive\")} className=\"h-4 w-4 accent-green-800\" /> Active</label>}\n          {formError && <p className=\"text-sm text-red-700\">{formError}</p>}\n          <div className=\"mt-2 flex justify-end gap-2\"><Button secondary type=\"button\" onClick={onClose}>Cancel</Button><Button type=\"submit\" disabled={busy}>{busy ? \"Saving…\" : \"Save\"}</Button></div>\n        </form>\n      </div>\n    </div>\n  );\n}\n\nfunction EmptyStart({ busy, canCleanupDemo, onDemo, onAccount, onCleanupDemo }: { busy: boolean; canCleanupDemo: boolean; onDemo: () => void; onAccount: () => void; onCleanupDemo: () => void }) {\n  return <div className=\"mx-auto max-w-xl rounded-3xl border border-stone-200 bg-white p-7 text-center sm:p-12\"><div className=\"mx-auto flex h-14 w-14 items-center justify-center rounded-2xl bg-lime-200 text-2xl text-green-950\">€</div><h1 className=\"mt-6 text-2xl font-semibold\">Start with your current cash</h1><p className=\"mx-auto mt-3 max-w-md text-stone-500\">{canCleanupDemo ? \"Synthetic demo records remain without an account. Remove them before starting with real data.\" : \"Add a real account balance, or load clearly synthetic data to explore the workflow first.\"}</p><div className=\"mt-7 flex flex-col justify-center gap-2 sm:flex-row\"><Button onClick={onAccount}>Add account</Button>{canCleanupDemo ? <Button secondary onClick={onCleanupDemo} disabled={busy}>Remove demo data</Button> : <Button secondary onClick={onDemo} disabled={busy}>{busy ? \"Loading…\" : \"Load synthetic demo\"}</Button>}</div></div>;\n}\n\nfunction Page({ title, subtitle, action, onAction, children }: { title: string; subtitle: string; action: string; onAction: () => void; children: ReactNode }) {\n  return <div><div className=\"mb-6 flex flex-col justify-between gap-4 sm:flex-row sm:items-end\"><div><h1 className=\"text-3xl font-semibold tracking-tight\">{title}</h1><p className=\"mt-2 text-sm text-stone-500\">{subtitle}</p></div><Button onClick={onAction}>{action}</Button></div>{children}</div>;\n}\n\nfunction ListRow({ title, meta, amount, inactive, onEdit, onDelete }: { title: string; meta: string; amount: number; inactive?: boolean; onEdit?: () => void; onDelete?: () => void }) {\n  return <div className={`flex items-center gap-3 py-4 ${inactive ? \"opacity-60\" : \"\"}`}><div className={`flex h-9 w-9 shrink-0 items-center justify-center rounded-full text-lg ${amount < 0 ? \"bg-orange-50 text-orange-700\" : \"bg-green-50 text-green-700\"}`}>{amount < 0 ? \"−\" : \"+\"}</div><div className=\"min-w-0 flex-1\"><p className=\"truncate font-medium\">{title}</p><p className=\"truncate text-xs text-stone-400\">{meta}</p></div><Amount cents={amount} /><div className=\"flex\"><button disabled={!onEdit} onClick={onEdit} className=\"px-2 py-1 text-xs text-stone-400 disabled:invisible\">Edit</button><button disabled={!onDelete} onClick={onDelete} className=\"px-2 py-1 text-xs text-stone-400 hover:text-red-700 disabled:invisible\">Delete</button></div></div>;\n}\n\nfunction Metric({ label, value, positive, negative }: { label: string; value: number; positive?: boolean; negative?: boolean }) {\n  return <div className=\"rounded-2xl border border-stone-200 bg-white p-4 sm:p-5\"><p className=\"text-xs font-medium text-stone-500 sm:text-sm\">{label}</p><p className={`mt-2 text-xl font-semibold sm:text-2xl ${positive ? \"text-green-700\" : negative ? \"text-orange-700\" : \"\"}`}>{money(value)}</p></div>;\n}\nfunction Card({ children, inactive }: { children: ReactNode; inactive?: boolean }) { return <div className={`rounded-2xl border border-stone-200 bg-white p-5 ${inactive ? \"opacity-60\" : \"\"}`}>{children}</div>; }\nfunction SectionTitle({ title, subtitle }: { title: string; subtitle?: string }) { return <div className=\"flex items-baseline justify-between gap-3\"><h2 className=\"font-semibold\">{title}</h2>{subtitle && <span className=\"text-xs text-stone-400\">{subtitle}</span>}</div>; }\nfunction SummaryRow({ label, cents, strong }: { label: string; cents: number; strong?: boolean }) { return <div className=\"flex items-center justify-between gap-3\"><span className={strong ? \"font-medium\" : \"text-sm text-stone-500\"}>{label}</span><span className={strong ? \"font-semibold\" : \"text-sm\"}>{money(cents)}</span></div>; }\nfunction Amount({ cents }: { cents: number }) { return <span className={`whitespace-nowrap font-semibold tabular-nums ${cents < 0 ? \"text-stone-800\" : \"text-green-700\"}`}>{cents > 0 ? \"+\" : \"\"}{money(cents)}</span>; }\nfunction DateBadge({ date }: { date: string }) { const parsed = new Date(`${date}T12:00:00Z`); return <div className=\"flex h-11 w-11 shrink-0 flex-col items-center justify-center rounded-xl bg-stone-100 leading-none\"><span className=\"text-[10px] font-semibold uppercase text-stone-400\">{parsed.toLocaleDateString(\"en\", { month: \"short\", timeZone: \"UTC\" })}</span><span className=\"mt-1 text-sm font-semibold\">{parsed.getUTCDate()}</span></div>; }\nfunction Badge({ children }: { children: ReactNode }) { return <span className=\"rounded-full bg-stone-100 px-2 py-1 text-[10px] font-medium uppercase tracking-wide text-stone-500\">{children}</span>; }\nfunction EmptyLine({ children }: { children: ReactNode }) { return <p className=\"py-8 text-center text-sm text-stone-400\">{children}</p>; }\nfunction Centered({ children }: { children: ReactNode }) { return <main className=\"flex min-h-screen items-center justify-center bg-stone-100 p-5\">{children}</main>; }\nfunction Spinner({ label }: { label: string }) { return <div className=\"text-center\"><div className=\"mx-auto h-8 w-8 animate-spin rounded-full border-2 border-stone-300 border-t-green-800\" /><p className=\"mt-4 text-sm text-stone-500\">{label}</p></div>; }\nfunction Brand() { return <div className=\"flex items-center gap-3\"><span className=\"flex h-9 w-9 items-center justify-center rounded-xl bg-green-950 font-semibold text-lime-200\">€</span><span className=\"font-semibold tracking-tight\">BudgetApp</span></div>; }\nfunction Logout({ compact }: { compact?: boolean }) { return <form method=\"POST\" action=\"/auth/logout\" className={compact ? \"mt-0\" : \"mt-6\"}><button className=\"rounded-lg border border-stone-200 px-3 py-2 text-sm text-stone-500 hover:bg-white\">Log out</button></form>; }\nfunction Button({ children, secondary, ...props }: ButtonHTMLAttributes<HTMLButtonElement> & { secondary?: boolean }) { return <button {...props} className={`rounded-xl px-4 py-2.5 text-sm font-medium transition-colors disabled:cursor-not-allowed disabled:opacity-50 ${secondary ? \"border border-stone-200 bg-white text-stone-700 hover:bg-stone-50\" : \"bg-green-900 text-white hover:bg-green-800\"}`}>{children}</button>; }\nfunction SmallButton({ children, primary, ...props }: ButtonHTMLAttributes<HTMLButtonElement> & { primary?: boolean }) { return <button {...props} className={`rounded-lg px-3 py-2 text-xs font-medium ${primary ? \"bg-green-900 text-white\" : \"bg-stone-100 text-stone-600 hover:bg-stone-200\"}`}>{children}</button>; }\nfunction Field({ label, children }: { label: string; children: ReactNode }) { return <label className=\"grid gap-1.5 text-sm font-medium text-stone-700\"><span>{label}</span>{children}</label>; }\nfunction MoneyField({ label, value, onInput, allowNegative }: { label: string; value: string; onInput: (event: FormEvent<Element>) => void; allowNegative?: boolean }) { return <Field label={label}><div className=\"relative\"><span className=\"absolute left-3 top-2.5 text-stone-400\">€</span><input inputMode=\"decimal\" required pattern={allowNegative ? \"-?[0-9]+([.,][0-9]{1,2})?\" : \"[0-9]+([.,][0-9]{1,2})?\"} placeholder=\"0.00\" value={value} onInput={onInput} className={`${inputClass} pl-8`} /></div></Field>; }\nfunction AccountSelect({ accounts, value, onChange, optional }: { accounts: Account[]; value: string; onChange: (event: FormEvent<Element>) => void; optional?: boolean }) { return <Field label={`Account${optional ? \" (optional)\" : \"\"}`}><select required={!optional} value={value} onChange={onChange} className={inputClass}>{optional && <option value=\"\">Choose when paid</option>}{accounts.filter((a) => a.isActive || a.id === value).map((account) => <option key={account.id} value={account.id}>{account.name}</option>)}</select></Field>; }\n\nconst inputClass = \"w-full box-border rounded-xl border border-stone-300 bg-white px-3 py-2.5 text-base outline-none focus:border-green-700 focus:ring-2 focus:ring-green-100\";\n\nfunction itemToForm(type: NonNullable<Editor>[\"type\"], item: Account | Transaction | PlannedTransaction | Reserve): Record<string, string | boolean> {\n  if (type === \"account\") { const a = item as Account; return { name: a.name, type: a.type, balance: euros(a.balanceCents), isActive: a.isActive }; }\n  if (type === \"transaction\") { const t = item as Transaction; return { description: t.description, kind: t.kind, amount: euros(Math.abs(t.amountCents)), date: t.date, accountId: t.accountId }; }\n  if (type === \"planned\") { const p = item as PlannedTransaction; return { description: p.description, kind: p.kind, amount: euros(p.amountCents), nextDate: p.nextDate, recurrence: p.recurrence, intervalCount: String(p.intervalCount), endDate: p.endDate ?? \"\", accountId: p.accountId ?? \"\", isActive: p.isActive }; }\n  const r = item as Reserve; return { name: r.name, amount: euros(r.amountCents), note: r.note, isActive: r.isActive };\n}\n\nasync function api<T = unknown>(path: string, init?: RequestInit, requireOk = true): Promise<T> {\n  const response = await fetch(path, { ...init, headers: { \"Content-Type\": \"application/json\", \"X-BudgetApp-Request\": \"1\", ...(init?.headers ?? {}) } });\n  const body = response.status === 204 ? null : await response.json().catch(() => null);\n  if (requireOk && !response.ok) throw new Error(body?.error ?? `Request failed (${response.status})`);\n  return body as T;\n}\n\nfunction parseMoney(raw: string, allowNegative = false): number {\n  const normalized = raw.trim().replace(\",\", \".\");\n  if (!(allowNegative ? /^-?\\d+(?:\\.\\d{1,2})?$/ : /^\\d+(?:\\.\\d{1,2})?$/).test(normalized)) throw new Error(\"Enter a valid amount with at most two decimals\");\n  const negative = normalized.startsWith(\"-\");\n  const [whole, decimal = \"\"] = normalized.replace(\"-\", \"\").split(\".\");\n  const cents = Number(BigInt(whole) * 100n + BigInt(decimal.padEnd(2, \"0\")));\n  if (!Number.isSafeInteger(cents)) throw new Error(\"Amount is too large\");\n  return negative ? -cents : cents;\n}\nfunction money(cents: number): string { return new Intl.NumberFormat(\"en-IE\", { style: \"currency\", currency: \"EUR\" }).format(cents / 100); }\nfunction euros(cents: number): string { return `${cents < 0 ? \"-\" : \"\"}${Math.floor(Math.abs(cents) / 100)}.${String(Math.abs(cents) % 100).padStart(2, \"0\")}`; }\nfunction today(): string { return householdDate(); }\nfunction prettyDate(date: string): string { return new Date(`${date}T12:00:00Z`).toLocaleDateString(\"en-GB\", { day: \"numeric\", month: \"short\", year: \"numeric\", timeZone: \"UTC\" }); }\nfunction messageOf(error: unknown): string { return error instanceof Error ? error.message : \"Something went wrong\"; }\nfunction confirmed(message: string): boolean { return window.confirm(message); }\n","deleted",false,"label",[58,59,36],"frontend","components","6a897343-11a3-46d5-a98b-da6649dc1994","c43a05aa-af04-11f1-9abb-1607ee4eb77e",5,["D",1789257043481],0,"directory",[58,59],{"_34":168,"_13":58,"_37":61,"_39":-5,"_41":42,"_43":49,"_45":46,"_47":169,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":170,"_18":171},{"_34":125,"_13":126,"_37":127,"_39":-5,"_41":42,"_43":128,"_45":46,"_47":129,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":130,"_18":131},{"_34":101,"_13":102,"_37":103,"_39":-5,"_41":42,"_43":89,"_45":46,"_47":104,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":105,"_18":106},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":89,"_50":24,"_52":98,"_54":55,"_56":-5,"_81":99,"_18":100},{"_34":84,"_13":85,"_37":86,"_39":-5,"_41":42,"_43":87,"_45":46,"_47":88,"_17":89,"_50":24,"_52":90,"_54":55,"_56":-5,"_81":91,"_18":92},{"_34":73,"_13":74,"_37":75,"_39":-5,"_41":42,"_43":76,"_45":46,"_47":77,"_17":78,"_50":79,"_52":80,"_54":55,"_56":-5,"_81":82,"_18":83},"df5c9601-3cd4-4ae2-a384-23a244b24255","index.http.ts","c47a5506-af04-11f1-b536-1607ee4eb77e",34,["D",1789505541595],4,"http","// Val Town infers the HTTP trigger from the `.http.ts` filename.\nimport { Hono } from \"npm:hono@4.13.7\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { assertDateOnly, householdDate } from \"./shared/finance.ts\";\nimport { Root } from \"./frontend/root.tsx\";\nimport {\n  completePlanned,\n  cleanupDemoData,\n  createAccount,\n  createPlanned,\n  createReserve,\n  createTransaction,\n  deleteAccount,\n  deletePlanned,\n  deleteReserve,\n  deleteTransaction,\n  getAppData,\n  seedDemoData,\n  updateAccount,\n  updatePlanned,\n  updateReserve,\n  updateTransaction,\n} from \"./server/repository.ts\";\nimport { DEMO_CLEANUP_CONFIRMATION } from \"./shared/types.ts\";\nimport {\n  booleanField,\n  centsField,\n  dateField,\n  enumField,\n  exactStringField,\n  integerField,\n  objectBody,\n  optionalString,\n  signedCentsField,\n  stringField,\n} from \"./server/validation.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html(Root()));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\napp.get(\"/api/session\", async (c) => {\n  const session = await getOAuthUserData(c.req.raw);\n  if (!session?.user) return c.json({ authenticated: false, authorized: false });\n  return c.json({\n    authenticated: true,\n    authorized: isAuthorized(session.user.username),\n    username: session.user.username,\n  });\n});\n\napp.use(\"/api/*\", async (c, next) => {\n  const session = await getOAuthUserData(c.req.raw);\n  if (!session?.user) return c.json({ error: \"Authentication required\" }, 401);\n  if (!isAuthorized(session.user.username)) return c.json({ error: \"This Val Town account is not allowed\" }, 403);\n  if (![\"GET\", \"HEAD\", \"OPTIONS\"].includes(c.req.method)) {\n    const origin = c.req.header(\"Origin\");\n    const expectedOrigin = new URL(c.req.url).origin;\n    if (origin !== expectedOrigin || c.req.header(\"X-BudgetApp-Request\") !== \"1\") {\n      return c.json({ error: \"Invalid request origin\" }, 403);\n    }\n  }\n  await next();\n});\n\napp.get(\"/api/data\", async (c) => {\n  const asOf = c.req.query(\"asOf\") || householdDate();\n  assertDateOnly(asOf);\n  return c.json(await getAppData(asOf));\n});\n\napp.post(\"/api/accounts\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await createAccount({\n    name: stringField(body, \"name\", 80),\n    type: enumField(body, \"type\", [\"checking\", \"savings\", \"cash\"] as const),\n    balanceCents: signedCentsField(body, \"balanceCents\"),\n  });\n  return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/accounts/:id\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await updateAccount(safeId(c.req.param(\"id\")), {\n    name: stringField(body, \"name\", 80),\n    type: enumField(body, \"type\", [\"checking\", \"savings\", \"cash\"] as const),\n    balanceCents: signedCentsField(body, \"balanceCents\"),\n    isActive: booleanField(body, \"isActive\", true),\n  });\n  return c.json({ ok: true });\n});\n\napp.delete(\"/api/accounts/:id\", async (c) => {\n  await deleteAccount(safeId(c.req.param(\"id\")));\n  return c.body(null, 204);\n});\n\napp.post(\"/api/transactions\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await createTransaction({\n    accountId: safeId(stringField(body, \"accountId\", 64)),\n    date: dateField(body, \"date\"),\n    amountCents: centsField(body),\n    description: stringField(body, \"description\", 160),\n    kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n  });\n  return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/transactions/:id\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await updateTransaction(safeId(c.req.param(\"id\")), {\n    accountId: safeId(stringField(body, \"accountId\", 64)),\n    date: dateField(body, \"date\"),\n    amountCents: centsField(body),\n    description: stringField(body, \"description\", 160),\n    kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n  });\n  return c.json({ ok: true });\n});\n\napp.delete(\"/api/transactions/:id\", async (c) => {\n  await deleteTransaction(safeId(c.req.param(\"id\")));\n  return c.body(null, 204);\n});\n\napp.post(\"/api/planned\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await createPlanned(plannedInput(body));\n  return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/planned/:id\", async (c) => {\n  await updatePlanned(safeId(c.req.param(\"id\")), plannedInput(await readBody(c.req.raw)));\n  return c.json({ ok: true });\n});\n\napp.post(\"/api/planned/:id/complete\", async (c) => {\n  const body = await readBody(c.req.raw);\n  const accountId = optionalString(body, \"accountId\", 64);\n  await completePlanned(\n    safeId(c.req.param(\"id\")),\n    dateField(body, \"date\"),\n    accountId ? safeId(accountId) : null,\n  );\n  return c.json({ ok: true });\n});\n\napp.delete(\"/api/planned/:id\", async (c) => {\n  await deletePlanned(safeId(c.req.param(\"id\")));\n  return c.body(null, 204);\n});\n\napp.post(\"/api/reserves\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await createReserve({\n    name: stringField(body, \"name\", 80),\n    amountCents: centsField(body, \"amountCents\", true),\n    note: optionalString(body, \"note\", 300) ?? \"\",\n  });\n  return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/reserves/:id\", async (c) => {\n  const body = await readBody(c.req.raw);\n  await updateReserve(safeId(c.req.param(\"id\")), {\n    name: stringField(body, \"name\", 80),\n    amountCents: centsField(body, \"amountCents\", true),\n    note: optionalString(body, \"note\", 300) ?? \"\",\n    isActive: booleanField(body, \"isActive\", true),\n  });\n  return c.json({ ok: true });\n});\n\napp.delete(\"/api/reserves/:id\", async (c) => {\n  await deleteReserve(safeId(c.req.param(\"id\")));\n  return c.body(null, 204);\n});\n\napp.post(\"/api/demo\", async (c) => c.json({ seeded: await seedDemoData() }));\n\napp.delete(\"/api/demo\", async (c) => {\n  const body = await readBody(c.req.raw);\n  const confirmation = exactStringField(body, \"confirmation\", DEMO_CLEANUP_CONFIRMATION.length);\n  return c.json({ cleaned: await cleanupDemoData(confirmation) });\n});\n\napp.notFound((c) => c.json({ error: \"Not found\" }, 404));\napp.onError((error, c) => {\n  const status = Number((error as Error & { status?: number }).status) ||\n    (/constraint/i.test(error.message) ? 409 : error instanceof SyntaxError ? 400 : 500);\n  if (status >= 500) console.error(\"BudgetApp request failed\", error.name, error.message);\n  return c.json({ error: status >= 500 ? \"Unexpected server error\" : error.message }, status as 400);\n});\n\nfunction isAuthorized(username: string | null): boolean {\n  if (!username) return false;\n  const owner = parseVal(import.meta.url).username.toLowerCase();\n  const extras = (Deno.env.get(\"BUDGET_APP_ALLOWED_USERS\") ?? \"\")\n    .split(\",\")\n    .map((value) => value.trim().toLowerCase())\n    .filter(Boolean);\n  return username.toLowerCase() === owner || extras.includes(username.toLowerCase());\n}\n\nasync function readBody(request: Request): Promise<Record<string, unknown>> {\n  const length = Number(request.headers.get(\"content-length\") ?? 0);\n  if (length > 32_000) throw Object.assign(new Error(\"Request body is too large\"), { status: 413 });\n  return objectBody(await request.json());\n}\n\nfunction safeId(value: string): string {\n  if (!/^[0-9a-f-]{36}$/i.test(value)) throw new Error(\"Invalid id\");\n  return value;\n}\n\nfunction plannedInput(body: Record<string, unknown>) {\n  const accountId = optionalString(body, \"accountId\", 64);\n  const nextDate = dateField(body, \"nextDate\");\n  const endDate = optionalString(body, \"endDate\", 10);\n  if (endDate) {\n    assertDateOnly(endDate);\n    if (endDate < nextDate) throw new Error(\"endDate cannot be before nextDate\");\n  }\n  return {\n    accountId: accountId ? safeId(accountId) : null,\n    description: stringField(body, \"description\", 160),\n    kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n    amountCents: centsField(body),\n    recurrence: enumField(body, \"recurrence\", [\"once\", \"weekly\", \"monthly\", \"yearly\"] as const),\n    intervalCount: integerField(body, \"intervalCount\"),\n    nextDate,\n    endDate,\n    isActive: booleanField(body, \"isActive\", true),\n  };\n}\n\nexport default oauthMiddleware(app.fetch);\n","children",[],[74],"239448e8-060b-40bd-b861-76e6e3429268","deno.json","c4748054-af04-11f1-9abb-1607ee4eb77e",32,["D",1789259984492],1,"{\n  \"nodeModulesDir\": \"auto\",\n  \"compilerOptions\": {\n    \"strict\": true,\n    \"noImplicitOverride\": true\n  },\n  \"imports\": {\n    \"hono\": \"npm:hono@4.13.7\"\n  },\n  \"exclude\": [\"node_modules\", \"tests\"]\n}\n",[],[85],"d927bf8f-079f-4da8-aa1e-3549a8149d4f",".vtignore","c498fea2-af04-11f1-9d2b-1607ee4eb77e",23,["D",1789257283542],".git/\n.github/\n.gitignore\nnode_modules/\ntests/\ntypes/\npackage-lock.json\npackage.json\ntsconfig.json\ndeno.lock\ndocs/\nREADME.md\nROADMAP.md\n.env*\n",[],[94],"65021267-97d2-46c5-a1f1-8e3430d2e5b8","shared","c42952fa-af04-11f1-83ee-1607ee4eb77e",["D",1789257043083],[107,108],[102],{"_34":117,"_13":118,"_37":119,"_39":103,"_41":42,"_43":120,"_45":46,"_47":121,"_17":64,"_50":51,"_52":122,"_54":55,"_56":-5,"_81":123,"_18":124},{"_34":109,"_13":110,"_37":111,"_39":103,"_41":42,"_43":112,"_45":46,"_47":113,"_17":89,"_50":51,"_52":114,"_54":55,"_56":-5,"_81":115,"_18":116},"98af08e2-ee76-4566-9b92-affc015d631c","types.ts","c482b91c-af04-11f1-bb78-1607ee4eb77e",37,["D",1789505541703],"export type AccountType = \"checking\" | \"savings\" | \"cash\";\nexport type TransactionKind = \"income\" | \"expense\" | \"refund\" | \"transfer\";\nexport type TransactionStatus = \"cleared\" | \"pending\";\nexport type Recurrence = \"once\" | \"weekly\" | \"monthly\" | \"yearly\";\nexport type PlannedKind = \"income\" | \"expense\";\nexport type DemoDataState = \"empty\" | \"demo-only\" | \"real-or-mixed\";\nexport const DEMO_CLEANUP_CONFIRMATION = \"DELETE DEMO DATA\";\n\nexport function canCleanupDemoData(state: DemoDataState): boolean {\n  return state === \"demo-only\";\n}\n\nexport interface Account {\n  id: string;\n  name: string;\n  type: AccountType;\n  currency: string;\n  balanceCents: number;\n  isActive: boolean;\n  createdAt: string;\n  updatedAt: string;\n}\n\nexport interface Transaction {\n  id: string;\n  accountId: string;\n  date: string;\n  amountCents: number;\n  currency: string;\n  description: string;\n  kind: TransactionKind;\n  status: TransactionStatus;\n  source: \"manual\" | \"import\" | \"planned\";\n  transferGroupId: string | null;\n  plannedTransactionId: string | null;\n  createdAt: string;\n  updatedAt: string;\n}\n\nexport interface PlannedTransaction {\n  id: string;\n  accountId: string | null;\n  description: string;\n  kind: PlannedKind;\n  amountCents: number;\n  currency: string;\n  recurrence: Recurrence;\n  intervalCount: number;\n  nextDate: string;\n  endDate: string | null;\n  isActive: boolean;\n  createdAt: string;\n  updatedAt: string;\n}\n\nexport interface Reserve {\n  id: string;\n  name: string;\n  amountCents: number;\n  currency: string;\n  note: string;\n  isActive: boolean;\n  createdAt: string;\n  updatedAt: string;\n}\n\nexport interface PlannedOccurrence {\n  plannedTransactionId: string;\n  description: string;\n  kind: PlannedKind;\n  amountCents: number;\n  date: string;\n}\n\nexport interface DashboardSummary {\n  asOfDate: string;\n  monthStart: string;\n  monthEnd: string;\n  currentCashCents: number;\n  spentThisMonthCents: number;\n  remainingIncomeCents: number;\n  remainingExpensesCents: number;\n  protectedReservesCents: number;\n  projectedMonthEndCents: number;\n  safeToSpendCents: number;\n  upcoming: PlannedOccurrence[];\n}\n\nexport interface AppData {\n  dashboard: DashboardSummary;\n  accounts: Account[];\n  transactions: Transaction[];\n  plannedTransactions: PlannedTransaction[];\n  reserves: Reserve[];\n  demoDataState: DemoDataState;\n}\n",[],[102,110],"b2a40611-5738-4b92-8324-d42002a33263","finance.ts","c4dbe0aa-af04-11f1-800c-1607ee4eb77e",18,["D",1789257043587],"import type {\n  Account,\n  DashboardSummary,\n  PlannedOccurrence,\n  PlannedTransaction,\n  Reserve,\n  Transaction,\n} from \"./types.ts\";\n\nconst DATE_RE = /^\\d{4}-\\d{2}-\\d{2}$/;\n\nexport function assertDateOnly(value: string): void {\n  if (!DATE_RE.test(value)) throw new Error(\"Date must use YYYY-MM-DD\");\n  const [year, month, day] = value.split(\"-\").map(Number);\n  const parsed = new Date(Date.UTC(year, month - 1, day));\n  if (\n    parsed.getUTCFullYear() !== year ||\n    parsed.getUTCMonth() !== month - 1 ||\n    parsed.getUTCDate() !== day\n  ) throw new Error(\"Date is invalid\");\n}\n\nexport function householdDate(now = new Date(), timeZone = \"Europe/Rome\"): string {\n  return new Intl.DateTimeFormat(\"en-CA\", {\n    timeZone,\n    year: \"numeric\",\n    month: \"2-digit\",\n    day: \"2-digit\",\n  }).format(now);\n}\n\nexport function monthBounds(date: string): { start: string; end: string } {\n  assertDateOnly(date);\n  const [year, month] = date.split(\"-\").map(Number);\n  return {\n    start: `${year}-${String(month).padStart(2, \"0\")}-01`,\n    end: formatUtcDate(new Date(Date.UTC(year, month, 0))),\n  };\n}\n\nexport function addRecurrence(\n  date: string,\n  recurrence: PlannedTransaction[\"recurrence\"],\n  intervalCount: number,\n): string | null {\n  assertDateOnly(date);\n  if (recurrence === \"once\") return null;\n  if (!Number.isInteger(intervalCount) || intervalCount < 1) throw new Error(\"Interval must be a positive integer\");\n  const [year, month, day] = date.split(\"-\").map(Number);\n  if (recurrence === \"weekly\") {\n    return formatUtcDate(new Date(Date.UTC(year, month - 1, day + 7 * intervalCount)));\n  }\n  if (recurrence === \"monthly\") {\n    const targetMonthStart = new Date(Date.UTC(year, month - 1 + intervalCount, 1));\n    const targetYear = targetMonthStart.getUTCFullYear();\n    const targetMonth = targetMonthStart.getUTCMonth();\n    const lastDay = new Date(Date.UTC(targetYear, targetMonth + 1, 0)).getUTCDate();\n    return formatUtcDate(new Date(Date.UTC(targetYear, targetMonth, Math.min(day, lastDay))));\n  }\n  const targetYear = year + intervalCount;\n  const lastDay = new Date(Date.UTC(targetYear, month, 0)).getUTCDate();\n  return formatUtcDate(new Date(Date.UTC(targetYear, month - 1, Math.min(day, lastDay))));\n}\n\nexport function occurrencesBetween(\n  item: PlannedTransaction,\n  fromDate: string,\n  toDate: string,\n): PlannedOccurrence[] {\n  if (!item.isActive || item.nextDate > toDate || (item.endDate && item.nextDate > item.endDate)) return [];\n  const occurrences: PlannedOccurrence[] = [];\n  let cursor: string | null = item.nextDate;\n  let guard = 0;\n  while (cursor && cursor <= toDate && (!item.endDate || cursor <= item.endDate)) {\n    if (cursor >= fromDate) {\n      occurrences.push({\n        plannedTransactionId: item.id,\n        description: item.description,\n        kind: item.kind,\n        amountCents: item.amountCents,\n        date: cursor,\n      });\n    }\n    cursor = addRecurrence(cursor, item.recurrence, item.intervalCount);\n    if (++guard > 400) throw new Error(\"Recurrence produced too many occurrences\");\n  }\n  return occurrences;\n}\n\nexport function calculateDashboard(input: {\n  asOfDate: string;\n  accounts: Account[];\n  transactions: Transaction[];\n  plannedTransactions: PlannedTransaction[];\n  reserves: Reserve[];\n}): DashboardSummary {\n  const { start, end } = monthBounds(input.asOfDate);\n  const currentCashCents = sum(input.accounts.filter((a) => a.isActive), (a) => a.balanceCents);\n  const monthTransactions = input.transactions.filter(\n    (t) => t.status === \"cleared\" && t.date >= start && t.date <= input.asOfDate && t.kind !== \"transfer\",\n  );\n  const grossExpenses = sum(monthTransactions.filter((t) => t.kind === \"expense\"), (t) => Math.abs(t.amountCents));\n  const refunds = sum(monthTransactions.filter((t) => t.kind === \"refund\"), (t) => Math.abs(t.amountCents));\n  const spentThisMonthCents = Math.max(0, grossExpenses - refunds);\n  const upcoming = input.plannedTransactions\n    // nextDate is the earliest unpaid occurrence, so overdue items remain\n    // committed until explicitly completed rather than disappearing at midnight.\n    .flatMap((item) => occurrencesBetween(item, item.nextDate, end))\n    .sort((a, b) => a.date.localeCompare(b.date) || a.description.localeCompare(b.description));\n  const remainingIncomeCents = sum(upcoming.filter((o) => o.kind === \"income\"), (o) => o.amountCents);\n  const remainingExpensesCents = sum(upcoming.filter((o) => o.kind === \"expense\"), (o) => o.amountCents);\n  const protectedReservesCents = sum(input.reserves.filter((r) => r.isActive), (r) => r.amountCents);\n  const projectedMonthEndCents = currentCashCents + remainingIncomeCents - remainingExpensesCents;\n  const safeToSpendCents = projectedMonthEndCents - protectedReservesCents;\n\n  return {\n    asOfDate: input.asOfDate,\n    monthStart: start,\n    monthEnd: end,\n    currentCashCents,\n    spentThisMonthCents,\n    remainingIncomeCents,\n    remainingExpensesCents,\n    protectedReservesCents,\n    projectedMonthEndCents,\n    safeToSpendCents,\n    upcoming,\n  };\n}\n\nfunction sum<T>(items: T[], value: (item: T) => number): number {\n  return items.reduce((total, item) => total + value(item), 0);\n}\n\nfunction formatUtcDate(date: Date): string {\n  return date.toISOString().slice(0, 10);\n}\n",[],[102,118],"ccf57a66-c3e0-4a52-9c44-82a68ddbe0ec","server","c448cf40-af04-11f1-9abb-1607ee4eb77e",3,["D",1789257043295],[132,133,134,135],[126],{"_34":160,"_13":161,"_37":162,"_39":127,"_41":42,"_43":163,"_45":46,"_47":164,"_17":89,"_50":51,"_52":165,"_54":55,"_56":-5,"_81":166,"_18":167},{"_34":152,"_13":153,"_37":154,"_39":127,"_41":42,"_43":155,"_45":46,"_47":156,"_17":64,"_50":51,"_52":157,"_54":55,"_56":-5,"_81":158,"_18":159},{"_34":144,"_13":145,"_37":146,"_39":127,"_41":42,"_43":147,"_45":46,"_47":148,"_17":89,"_50":51,"_52":149,"_54":55,"_56":-5,"_81":150,"_18":151},{"_34":136,"_13":137,"_37":138,"_39":127,"_41":42,"_43":139,"_45":46,"_47":140,"_17":89,"_50":51,"_52":141,"_54":55,"_56":-5,"_81":142,"_18":143},"7d6e0f36-e605-4124-bb4c-aa1f98028d39","validation.ts","c4bc29f4-af04-11f1-8508-1607ee4eb77e",39,["D",1789505541788],"import { assertDateOnly } from \"../shared/finance.ts\";\n\nexport function objectBody(value: unknown): Record<string, unknown> {\n  if (!value || typeof value !== \"object\" || Array.isArray(value)) throw new Error(\"A JSON object is required\");\n  return value as Record<string, unknown>;\n}\n\nexport function stringField(body: Record<string, unknown>, key: string, max = 120): string {\n  const value = body[key];\n  if (typeof value !== \"string\" || !value.trim()) throw new Error(`${key} is required`);\n  const normalized = value.trim();\n  if (normalized.length > max) throw new Error(`${key} is too long`);\n  return normalized;\n}\n\nexport function exactStringField(body: Record<string, unknown>, key: string, max = 120): string {\n  const value = body[key];\n  if (typeof value !== \"string\" || !value) throw new Error(`${key} is required`);\n  if (value.length > max) throw new Error(`${key} is too long`);\n  return value;\n}\n\nexport function optionalString(body: Record<string, unknown>, key: string, max = 500): string | null {\n  const value = body[key];\n  if (value == null || value === \"\") return null;\n  if (typeof value !== \"string\" || value.length > max) throw new Error(`${key} is invalid`);\n  return value.trim();\n}\n\nexport function enumField<T extends string>(body: Record<string, unknown>, key: string, allowed: readonly T[]): T {\n  const value = body[key];\n  if (typeof value !== \"string\" || !allowed.includes(value as T)) throw new Error(`${key} is invalid`);\n  return value as T;\n}\n\nexport function centsField(body: Record<string, unknown>, key = \"amountCents\", allowZero = false): number {\n  const value = body[key];\n  if (!Number.isSafeInteger(value) || (allowZero ? (value as number) < 0 : (value as number) <= 0)) {\n    throw new Error(`${key} must be a safe integer number of cents${allowZero ? \"\" : \" greater than zero\"}`);\n  }\n  return value as number;\n}\n\nexport function signedCentsField(body: Record<string, unknown>, key: string): number {\n  const value = body[key];\n  if (!Number.isSafeInteger(value)) throw new Error(`${key} must be a safe integer number of cents`);\n  return value as number;\n}\n\nexport function integerField(body: Record<string, unknown>, key: string, min = 1): number {\n  const value = body[key];\n  if (!Number.isSafeInteger(value) || (value as number) < min) throw new Error(`${key} is invalid`);\n  return value as number;\n}\n\nexport function dateField(body: Record<string, unknown>, key: string): string {\n  const value = stringField(body, key, 10);\n  assertDateOnly(value);\n  return value;\n}\n\nexport function booleanField(body: Record<string, unknown>, key: string, fallback: boolean): boolean {\n  const value = body[key];\n  if (value == null) return fallback;\n  if (typeof value !== \"boolean\") throw new Error(`${key} is invalid`);\n  return value;\n}\n",[],[126,137],"a956394f-5108-4ee7-b66d-3a3b3b664079","repository.ts","c52d942c-af04-11f1-a256-1607ee4eb77e",35,["D",1789505541601],"import { addRecurrence, calculateDashboard, householdDate } from \"../shared/finance.ts\";\nimport {\n  DEMO_CLEANUP_CONFIRMATION,\n  type Account,\n  type AppData,\n  type DemoDataState,\n  type PlannedTransaction,\n  type Reserve,\n  type Transaction,\n} from \"../shared/types.ts\";\nimport { db, ensureSchema } from \"./db.ts\";\nimport {\n  classifyDemoData,\n  demoCleanupStatements,\n  demoSeedStatements,\n  demoStateQuery,\n} from \"./demo-data.ts\";\n\ntype Row = Record<string, unknown>;\n\nexport async function getAppData(asOfDate = householdDate()): Promise<AppData> {\n  await ensureSchema();\n  const [accountResult, transactionResult, plannedResult, reserveResult, demoResult] = await Promise.all([\n    db.execute(\"SELECT * FROM accounts ORDER BY is_active DESC, name COLLATE NOCASE\"),\n    db.execute(\"SELECT * FROM transactions ORDER BY date DESC, created_at DESC LIMIT 500\"),\n    db.execute(\"SELECT * FROM planned_transactions ORDER BY is_active DESC, next_date, description COLLATE NOCASE\"),\n    db.execute(\"SELECT * FROM reserves ORDER BY is_active DESC, name COLLATE NOCASE\"),\n    db.execute(demoStateQuery()),\n  ]);\n  const accounts = accountResult.rows.map(mapAccount);\n  const transactions = transactionResult.rows.map(mapTransaction);\n  const plannedTransactions = plannedResult.rows.map(mapPlanned);\n  const reserves = reserveResult.rows.map(mapReserve);\n  const demoDataState = demoStateFromRow(demoResult.rows[0] as Row | undefined);\n  return {\n    accounts,\n    transactions,\n    plannedTransactions,\n    reserves,\n    demoDataState,\n    dashboard: calculateDashboard({ asOfDate, accounts, transactions, plannedTransactions, reserves }),\n  };\n}\n\nexport async function createAccount(input: {\n  name: string;\n  type: Account[\"type\"];\n  balanceCents: number;\n}): Promise<void> {\n  await ensureSchema();\n  const now = new Date().toISOString();\n  await db.execute({\n    sql: `INSERT INTO accounts (id, name, type, currency, balance_cents, is_active, created_at, updated_at)\n      VALUES (?, ?, ?, 'EUR', ?, 1, ?, ?)`,\n    args: [crypto.randomUUID(), input.name, input.type, input.balanceCents, now, now],\n  });\n}\n\nexport async function updateAccount(id: string, input: {\n  name: string;\n  type: Account[\"type\"];\n  balanceCents: number;\n  isActive: boolean;\n}): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({\n    sql: `UPDATE accounts SET name = ?, type = ?, balance_cents = ?, is_active = ?, updated_at = ?, is_demo = 0 WHERE id = ?`,\n    args: [input.name, input.type, input.balanceCents, Number(input.isActive), new Date().toISOString(), id],\n  });\n  requireChanged(result.rowsAffected, \"Account\");\n}\n\nexport async function deleteAccount(id: string): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({ sql: \"DELETE FROM accounts WHERE id = ?\", args: [id] });\n  requireChanged(result.rowsAffected, \"Account\");\n}\n\nexport async function createTransaction(input: {\n  accountId: string;\n  date: string;\n  amountCents: number;\n  description: string;\n  kind: \"income\" | \"expense\";\n  source?: \"manual\" | \"planned\";\n  plannedTransactionId?: string | null;\n}): Promise<void> {\n  await ensureSchema();\n  const signedAmount = input.kind === \"expense\" ? -input.amountCents : input.amountCents;\n  const now = new Date().toISOString();\n  await db.batch([\n    {\n      sql: `INSERT INTO transactions\n        (id, account_id, date, amount_cents, currency, description, kind, status, source, planned_transaction_id, created_at, updated_at)\n        VALUES (?, ?, ?, ?, 'EUR', ?, ?, 'cleared', ?, ?, ?, ?)`,\n      args: [crypto.randomUUID(), input.accountId, input.date, signedAmount, input.description, input.kind,\n        input.source ?? \"manual\", input.plannedTransactionId ?? null, now, now],\n    },\n    { sql: \"UPDATE accounts SET balance_cents = balance_cents + ?, updated_at = ?, is_demo = 0 WHERE id = ?\", args: [signedAmount, now, input.accountId] },\n  ]);\n}\n\nexport async function updateTransaction(id: string, input: {\n  accountId: string;\n  date: string;\n  amountCents: number;\n  description: string;\n  kind: \"income\" | \"expense\";\n}): Promise<void> {\n  await ensureSchema();\n  const existing = await one(\"SELECT * FROM transactions WHERE id = ?\", [id]);\n  if (!existing) throw notFound(\"Transaction\");\n  if (existing.source !== \"manual\") throw conflict(\"Only manual transactions can be edited\");\n  const oldAmount = Number(existing.amount_cents);\n  const newAmount = input.kind === \"expense\" ? -input.amountCents : input.amountCents;\n  const oldAccountId = String(existing.account_id);\n  const now = new Date().toISOString();\n  await db.batch([\n    { sql: \"UPDATE accounts SET balance_cents = balance_cents - ?, updated_at = ?, is_demo = 0 WHERE id = ?\", args: [oldAmount, now, oldAccountId] },\n    { sql: \"UPDATE accounts SET balance_cents = balance_cents + ?, updated_at = ?, is_demo = 0 WHERE id = ?\", args: [newAmount, now, input.accountId] },\n    {\n      sql: `UPDATE transactions SET account_id = ?, date = ?, amount_cents = ?, description = ?, kind = ?, updated_at = ?, is_demo = 0 WHERE id = ?`,\n      args: [input.accountId, input.date, newAmount, input.description, input.kind, now, id],\n    },\n  ]);\n}\n\nexport async function deleteTransaction(id: string): Promise<void> {\n  await ensureSchema();\n  const existing = await one(\"SELECT * FROM transactions WHERE id = ?\", [id]);\n  if (!existing) throw notFound(\"Transaction\");\n  if (existing.source !== \"manual\") throw conflict(\"Only manual transactions can be deleted directly\");\n  await db.batch([\n    {\n      sql: \"UPDATE accounts SET balance_cents = balance_cents - ?, updated_at = ?, is_demo = 0 WHERE id = ?\",\n      args: [Number(existing.amount_cents), new Date().toISOString(), String(existing.account_id)],\n    },\n    { sql: \"DELETE FROM transactions WHERE id = ?\", args: [id] },\n  ]);\n}\n\nexport async function createPlanned(input: Omit<PlannedTransaction, \"id\" | \"currency\" | \"createdAt\" | \"updatedAt\">): Promise<void> {\n  await ensureSchema();\n  const now = new Date().toISOString();\n  await db.execute({\n    sql: `INSERT INTO planned_transactions\n      (id, account_id, description, kind, amount_cents, currency, recurrence, interval_count, next_date, end_date, is_active, created_at, updated_at)\n      VALUES (?, ?, ?, ?, ?, 'EUR', ?, ?, ?, ?, ?, ?, ?)`,\n    args: [crypto.randomUUID(), input.accountId, input.description, input.kind, input.amountCents, input.recurrence,\n      input.intervalCount, input.nextDate, input.endDate, Number(input.isActive), now, now],\n  });\n}\n\nexport async function updatePlanned(id: string, input: Omit<PlannedTransaction, \"id\" | \"currency\" | \"createdAt\" | \"updatedAt\">): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({\n    sql: `UPDATE planned_transactions SET account_id = ?, description = ?, kind = ?, amount_cents = ?, recurrence = ?,\n      interval_count = ?, next_date = ?, end_date = ?, is_active = ?, updated_at = ?, is_demo = 0 WHERE id = ?`,\n    args: [input.accountId, input.description, input.kind, input.amountCents, input.recurrence, input.intervalCount,\n      input.nextDate, input.endDate, Number(input.isActive), new Date().toISOString(), id],\n  });\n  requireChanged(result.rowsAffected, \"Planned transaction\");\n}\n\nexport async function completePlanned(id: string, actualDate: string, accountId?: string | null): Promise<void> {\n  await ensureSchema();\n  const row = await one(\"SELECT * FROM planned_transactions WHERE id = ?\", [id]);\n  if (!row) throw notFound(\"Planned transaction\");\n  const item = mapPlanned(row);\n  if (!item.isActive) throw conflict(\"Planned transaction is inactive\");\n  const targetAccountId = accountId || item.accountId;\n  if (!targetAccountId) throw conflict(\"Choose an account before marking this item paid\");\n  const signedAmount = item.kind === \"expense\" ? -item.amountCents : item.amountCents;\n  const nextDate = addRecurrence(item.nextDate, item.recurrence, item.intervalCount);\n  const remainsActive = Boolean(nextDate && (!item.endDate || nextDate <= item.endDate));\n  const now = new Date().toISOString();\n  await db.batch([\n    {\n      sql: `INSERT INTO transactions\n        (id, account_id, date, amount_cents, currency, description, kind, status, source, planned_transaction_id, created_at, updated_at)\n        VALUES (?, ?, ?, ?, 'EUR', ?, ?, 'cleared', 'planned', ?, ?, ?)`,\n      args: [crypto.randomUUID(), targetAccountId, actualDate, signedAmount, item.description, item.kind, id, now, now],\n    },\n    { sql: \"UPDATE accounts SET balance_cents = balance_cents + ?, updated_at = ?, is_demo = 0 WHERE id = ?\", args: [signedAmount, now, targetAccountId] },\n    {\n      sql: \"UPDATE planned_transactions SET next_date = ?, is_active = ?, updated_at = ?, is_demo = 0 WHERE id = ?\",\n      args: [nextDate ?? item.nextDate, Number(remainsActive), now, id],\n    },\n  ]);\n}\n\nexport async function deletePlanned(id: string): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({ sql: \"DELETE FROM planned_transactions WHERE id = ?\", args: [id] });\n  requireChanged(result.rowsAffected, \"Planned transaction\");\n}\n\nexport async function createReserve(input: { name: string; amountCents: number; note: string }): Promise<void> {\n  await ensureSchema();\n  const now = new Date().toISOString();\n  await db.execute({\n    sql: `INSERT INTO reserves (id, name, amount_cents, currency, note, is_active, created_at, updated_at)\n      VALUES (?, ?, ?, 'EUR', ?, 1, ?, ?)`,\n    args: [crypto.randomUUID(), input.name, input.amountCents, input.note, now, now],\n  });\n}\n\nexport async function updateReserve(id: string, input: { name: string; amountCents: number; note: string; isActive: boolean }): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({\n    sql: \"UPDATE reserves SET name = ?, amount_cents = ?, note = ?, is_active = ?, updated_at = ?, is_demo = 0 WHERE id = ?\",\n    args: [input.name, input.amountCents, input.note, Number(input.isActive), new Date().toISOString(), id],\n  });\n  requireChanged(result.rowsAffected, \"Reserve\");\n}\n\nexport async function deleteReserve(id: string): Promise<void> {\n  await ensureSchema();\n  const result = await db.execute({ sql: \"DELETE FROM reserves WHERE id = ?\", args: [id] });\n  requireChanged(result.rowsAffected, \"Reserve\");\n}\n\nexport async function seedDemoData(today = householdDate()): Promise<boolean> {\n  await ensureSchema();\n  const now = new Date().toISOString();\n  const claimToken = crypto.randomUUID();\n  const { start } = (() => {\n    const month = today.slice(0, 7);\n    return { start: `${month}-01` };\n  })();\n  const day = (value: number) => `${today.slice(0, 8)}${String(value).padStart(2, \"0\")}`;\n  const futureDay = Math.min(28, Number(today.slice(8, 10)) + 2);\n  const checkingId = crypto.randomUUID();\n  await db.batch(demoSeedStatements({\n    claimToken,\n    checkingId,\n    savingsId: crypto.randomUUID(),\n    transactionId: crypto.randomUUID(),\n    salaryId: crypto.randomUUID(),\n    mortgageId: crypto.randomUUID(),\n    reserveId: crypto.randomUUID(),\n    now,\n    monthStart: start,\n    salaryDate: day(futureDay),\n    mortgageDate: day(Math.min(28, futureDay + 2)),\n  }));\n  const claim = await one(\"SELECT value FROM app_metadata WHERE key = 'demo_seed_claim'\", []);\n  return claim?.value === claimToken;\n}\n\nexport async function cleanupDemoData(confirmation: string): Promise<boolean> {\n  if (confirmation !== DEMO_CLEANUP_CONFIRMATION) throw conflict(`Type ${DEMO_CLEANUP_CONFIRMATION} exactly to remove demo data`);\n  await ensureSchema();\n  const initialState = await getDemoDataState();\n  if (initialState === \"empty\") return false;\n  if (initialState !== \"demo-only\") throw conflict(\"Demo cleanup is blocked because this dataset contains real or unmarked data\");\n\n  const claimToken = crypto.randomUUID();\n  await db.batch(demoCleanupStatements(claimToken, new Date().toISOString()));\n  const finalState = await getDemoDataState();\n  if (finalState !== \"empty\") throw conflict(\"Demo cleanup was blocked because the dataset changed\");\n  return true;\n}\n\nasync function getDemoDataState(): Promise<DemoDataState> {\n  const result = await db.execute(demoStateQuery());\n  return demoStateFromRow(result.rows[0] as Row | undefined);\n}\n\nfunction demoStateFromRow(row: Row | undefined): DemoDataState {\n  return classifyDemoData(Number(row?.total_count ?? 0), Number(row?.demo_count ?? 0));\n}\n\nasync function one(sql: string, args: (string | number | null)[]): Promise<Row | null> {\n  const result = await db.execute({ sql, args });\n  return (result.rows[0] as Row | undefined) ?? null;\n}\n\nfunction mapAccount(row: Row): Account {\n  return {\n    id: String(row.id), name: String(row.name), type: row.type as Account[\"type\"], currency: String(row.currency),\n    balanceCents: Number(row.balance_cents), isActive: Boolean(row.is_active), createdAt: String(row.created_at), updatedAt: String(row.updated_at),\n  };\n}\n\nfunction mapTransaction(row: Row): Transaction {\n  return {\n    id: String(row.id), accountId: String(row.account_id), date: String(row.date), amountCents: Number(row.amount_cents),\n    currency: String(row.currency), description: String(row.description), kind: row.kind as Transaction[\"kind\"],\n    status: row.status as Transaction[\"status\"], source: row.source as Transaction[\"source\"],\n    transferGroupId: row.transfer_group_id == null ? null : String(row.transfer_group_id),\n    plannedTransactionId: row.planned_transaction_id == null ? null : String(row.planned_transaction_id),\n    createdAt: String(row.created_at), updatedAt: String(row.updated_at),\n  };\n}\n\nfunction mapPlanned(row: Row): PlannedTransaction {\n  return {\n    id: String(row.id), accountId: row.account_id == null ? null : String(row.account_id), description: String(row.description),\n    kind: row.kind as PlannedTransaction[\"kind\"], amountCents: Number(row.amount_cents), currency: String(row.currency),\n    recurrence: row.recurrence as PlannedTransaction[\"recurrence\"], intervalCount: Number(row.interval_count), nextDate: String(row.next_date),\n    endDate: row.end_date == null ? null : String(row.end_date), isActive: Boolean(row.is_active),\n    createdAt: String(row.created_at), updatedAt: String(row.updated_at),\n  };\n}\n\nfunction mapReserve(row: Row): Reserve {\n  return {\n    id: String(row.id), name: String(row.name), amountCents: Number(row.amount_cents), currency: String(row.currency),\n    note: String(row.note), isActive: Boolean(row.is_active), createdAt: String(row.created_at), updatedAt: String(row.updated_at),\n  };\n}\n\nfunction requireChanged(rowsAffected: number, entity: string): void {\n  if (!rowsAffected) throw notFound(entity);\n}\n\nfunction notFound(entity: string): Error {\n  return Object.assign(new Error(`${entity} not found`), { status: 404 });\n}\n\nfunction conflict(message: string): Error {\n  return Object.assign(new Error(message), { status: 409 });\n}\n",[],[126,145],"cccd28dd-ae71-4d72-ba95-4eb63564cefc","demo-data.ts","58dd70ae-b147-11f1-a9c6-1607ee4eb77e",36,["D",1789505541602],"import type { DemoDataState } from \"../shared/types.ts\";\n\nexport interface SqlStatement {\n  sql: string;\n  args?: (string | number | null)[];\n}\n\nexport const demoEntityTables = [\"accounts\", \"transactions\", \"planned_transactions\", \"reserves\"] as const;\nexport type DemoEntityTable = typeof demoEntityTables[number];\n\nexport function demoProvenanceMigrationSql(table: DemoEntityTable): string {\n  return `ALTER TABLE ${table} ADD COLUMN is_demo INTEGER NOT NULL DEFAULT 0 CHECK (is_demo IN (0, 1))`;\n}\n\nexport function demoStateQuery(): string {\n  return `SELECT\n    (${demoEntityTables.map((table) => `(SELECT COUNT(*) FROM ${table})`).join(\" + \")}) AS total_count,\n    (${demoEntityTables.map((table) => `(SELECT COUNT(*) FROM ${table} WHERE is_demo = 1)`).join(\" + \")}) AS demo_count`;\n}\n\nexport function classifyDemoData(totalCount: number, demoCount: number): DemoDataState {\n  if (totalCount === 0) return \"empty\";\n  return totalCount === demoCount ? \"demo-only\" : \"real-or-mixed\";\n}\n\nexport function isDuplicateIsDemoColumnError(error: unknown): boolean {\n  return error instanceof Error && /duplicate column name:\\s*is_demo/i.test(error.message);\n}\n\nexport function demoSeedStatements(input: {\n  claimToken: string;\n  checkingId: string;\n  savingsId: string;\n  transactionId: string;\n  salaryId: string;\n  mortgageId: string;\n  reserveId: string;\n  now: string;\n  monthStart: string;\n  salaryDate: string;\n  mortgageDate: string;\n}): SqlStatement[] {\n  const ownsClaim = `EXISTS (\n    SELECT 1 FROM app_metadata WHERE key = 'demo_seed_claim' AND value = ?\n  )`;\n  const allEntitiesEmpty = demoEntityTables.map((table) => `NOT EXISTS (SELECT 1 FROM ${table})`).join(\" AND \");\n  return [\n    {\n      sql: `DELETE FROM app_metadata WHERE key = 'demo_seed_claim' AND ${allEntitiesEmpty}`,\n    },\n    {\n      sql: `INSERT OR IGNORE INTO app_metadata (key, value, updated_at)\n        SELECT 'demo_seed_claim', ?, ?\n        WHERE ${allEntitiesEmpty}`,\n      args: [input.claimToken, input.now],\n    },\n    {\n      sql: `INSERT INTO accounts\n        (id, name, type, currency, balance_cents, is_active, created_at, updated_at, is_demo)\n        SELECT ?, 'Main account', 'checking', 'EUR', 284500, 1, ?, ?, 1 WHERE ${ownsClaim}`,\n      args: [input.checkingId, input.now, input.now, input.claimToken],\n    },\n    {\n      sql: `INSERT INTO accounts\n        (id, name, type, currency, balance_cents, is_active, created_at, updated_at, is_demo)\n        SELECT ?, 'Savings', 'savings', 'EUR', 620000, 1, ?, ?, 1 WHERE ${ownsClaim}`,\n      args: [input.savingsId, input.now, input.now, input.claimToken],\n    },\n    {\n      sql: `INSERT INTO transactions\n        (id, account_id, date, amount_cents, currency, description, kind, status, source,\n          transfer_group_id, planned_transaction_id, created_at, updated_at, is_demo)\n        SELECT ?, ?, ?, -8650, 'EUR', 'Synthetic household shop', 'expense', 'cleared', 'manual',\n          NULL, NULL, ?, ?, 1 WHERE ${ownsClaim}`,\n      args: [input.transactionId, input.checkingId, input.monthStart, input.now, input.now, input.claimToken],\n    },\n    {\n      sql: `INSERT INTO planned_transactions\n        (id, account_id, description, kind, amount_cents, currency, recurrence, interval_count,\n          next_date, end_date, is_active, created_at, updated_at, is_demo)\n        SELECT ?, ?, 'Synthetic salary', 'income', 280000, 'EUR', 'monthly', 1,\n          ?, NULL, 1, ?, ?, 1 WHERE ${ownsClaim}`,\n      args: [input.salaryId, input.checkingId, input.salaryDate, input.now, input.now, input.claimToken],\n    },\n    {\n      sql: `INSERT INTO planned_transactions\n        (id, account_id, description, kind, amount_cents, currency, recurrence, interval_count,\n          next_date, end_date, is_active, created_at, updated_at, is_demo)\n        SELECT ?, ?, 'Mortgage', 'expense', 58100, 'EUR', 'monthly', 1,\n          ?, NULL, 1, ?, ?, 1 WHERE ${ownsClaim}`,\n      args: [input.mortgageId, input.checkingId, input.mortgageDate, input.now, input.now, input.claimToken],\n    },\n    {\n      sql: `INSERT INTO reserves\n        (id, name, amount_cents, currency, note, is_active, created_at, updated_at, is_demo)\n        SELECT ?, 'Emergency buffer', 300000, 'EUR', 'Protected from normal spending', 1, ?, ?, 1\n        WHERE ${ownsClaim}`,\n      args: [input.reserveId, input.now, input.now, input.claimToken],\n    },\n  ];\n}\n\nexport function demoCleanupStatements(claimToken: string, now: string): SqlStatement[] {\n  const hasAnyRows = demoEntityTables.map((table) => `EXISTS (SELECT 1 FROM ${table})`).join(\" OR \");\n  const hasRealRows = demoEntityTables.map((table) => `EXISTS (SELECT 1 FROM ${table} WHERE is_demo = 0)`).join(\" OR \");\n  const ownsClaim = `EXISTS (\n    SELECT 1 FROM app_metadata WHERE key = 'demo_cleanup_claim' AND value = ?\n  )`;\n  return [\n    {\n      sql: `INSERT OR IGNORE INTO app_metadata (key, value, updated_at)\n        SELECT 'demo_cleanup_claim', ?, ?\n        WHERE (${hasAnyRows}) AND NOT (${hasRealRows})`,\n      args: [claimToken, now],\n    },\n    { sql: `DELETE FROM transactions WHERE is_demo = 1 AND ${ownsClaim}`, args: [claimToken] },\n    { sql: `DELETE FROM planned_transactions WHERE is_demo = 1 AND ${ownsClaim}`, args: [claimToken] },\n    { sql: `DELETE FROM reserves WHERE is_demo = 1 AND ${ownsClaim}`, args: [claimToken] },\n    { sql: `DELETE FROM accounts WHERE is_demo = 1 AND ${ownsClaim}`, args: [claimToken] },\n    {\n      sql: `DELETE FROM app_metadata\n        WHERE key = 'demo_seed_claim' AND ${ownsClaim}`,\n      args: [claimToken],\n    },\n    {\n      sql: \"DELETE FROM app_metadata WHERE key = 'demo_cleanup_claim' AND value = ?\",\n      args: [claimToken],\n    },\n  ];\n}\n",[],[126,153],"93fa8c79-7292-4243-a7cc-b98d2b4f6c6c","db.ts","c4b5efd0-af04-11f1-bb78-1607ee4eb77e",38,["D",1789505541741],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { demoEntityTables, demoProvenanceMigrationSql, isDuplicateIsDemoColumnError } from \"./demo-data.ts\";\n\nexport const db = sqlite;\n\nlet initialized: Promise<void> | null = null;\n\nexport function ensureSchema(): Promise<void> {\n  initialized ??= migrate().catch((error) => {\n    initialized = null;\n    throw error;\n  });\n  return initialized;\n}\n\nasync function migrate(): Promise<void> {\n  await db.batch([\n    `CREATE TABLE IF NOT EXISTS schema_migrations (\n      version INTEGER PRIMARY KEY,\n      applied_at TEXT NOT NULL\n    )`,\n    `CREATE TABLE IF NOT EXISTS accounts (\n      id TEXT PRIMARY KEY,\n      name TEXT NOT NULL,\n      type TEXT NOT NULL CHECK (type IN ('checking', 'savings', 'cash')),\n      currency TEXT NOT NULL DEFAULT 'EUR',\n      balance_cents INTEGER NOT NULL,\n      is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n      created_at TEXT NOT NULL,\n      updated_at TEXT NOT NULL\n    )`,\n    `CREATE TABLE IF NOT EXISTS planned_transactions (\n      id TEXT PRIMARY KEY,\n      account_id TEXT REFERENCES accounts(id) ON DELETE SET NULL,\n      description TEXT NOT NULL,\n      kind TEXT NOT NULL CHECK (kind IN ('income', 'expense')),\n      amount_cents INTEGER NOT NULL CHECK (amount_cents > 0),\n      currency TEXT NOT NULL DEFAULT 'EUR',\n      recurrence TEXT NOT NULL CHECK (recurrence IN ('once', 'weekly', 'monthly', 'yearly')),\n      interval_count INTEGER NOT NULL DEFAULT 1 CHECK (interval_count > 0),\n      next_date TEXT NOT NULL,\n      end_date TEXT,\n      is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n      created_at TEXT NOT NULL,\n      updated_at TEXT NOT NULL\n    )`,\n    `CREATE TABLE IF NOT EXISTS transactions (\n      id TEXT PRIMARY KEY,\n      account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE RESTRICT,\n      date TEXT NOT NULL,\n      amount_cents INTEGER NOT NULL CHECK (amount_cents != 0),\n      currency TEXT NOT NULL DEFAULT 'EUR',\n      description TEXT NOT NULL,\n      kind TEXT NOT NULL CHECK (kind IN ('income', 'expense', 'refund', 'transfer')),\n      status TEXT NOT NULL CHECK (status IN ('cleared', 'pending')),\n      source TEXT NOT NULL CHECK (source IN ('manual', 'import', 'planned')),\n      external_id TEXT,\n      import_identity TEXT,\n      transfer_group_id TEXT,\n      planned_transaction_id TEXT REFERENCES planned_transactions(id) ON DELETE SET NULL,\n      raw_metadata TEXT,\n      created_at TEXT NOT NULL,\n      updated_at TEXT NOT NULL\n    )`,\n    `CREATE UNIQUE INDEX IF NOT EXISTS transactions_import_identity_idx\n      ON transactions(import_identity) WHERE import_identity IS NOT NULL`,\n    `CREATE INDEX IF NOT EXISTS transactions_date_idx ON transactions(date)`,\n    `CREATE TABLE IF NOT EXISTS reserves (\n      id TEXT PRIMARY KEY,\n      name TEXT NOT NULL,\n      amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),\n      currency TEXT NOT NULL DEFAULT 'EUR',\n      note TEXT NOT NULL DEFAULT '',\n      is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n      created_at TEXT NOT NULL,\n      updated_at TEXT NOT NULL\n    )`,\n    `CREATE TABLE IF NOT EXISTS imports (\n      id TEXT PRIMARY KEY,\n      filename TEXT NOT NULL,\n      status TEXT NOT NULL CHECK (status IN ('processing', 'completed', 'failed')),\n      row_count INTEGER NOT NULL DEFAULT 0,\n      imported_count INTEGER NOT NULL DEFAULT 0,\n      duplicate_count INTEGER NOT NULL DEFAULT 0,\n      error_summary TEXT,\n      created_at TEXT NOT NULL,\n      completed_at TEXT\n    )`,\n    `CREATE TABLE IF NOT EXISTS app_metadata (\n      key TEXT PRIMARY KEY,\n      value TEXT NOT NULL,\n      updated_at TEXT NOT NULL\n    )`,\n    {\n      sql: `INSERT OR IGNORE INTO schema_migrations (version, applied_at) VALUES (?, ?)`,\n      args: [1, new Date().toISOString()],\n    },\n  ]);\n\n  await applyDemoProvenanceMigration();\n}\n\nasync function applyDemoProvenanceMigration(): Promise<void> {\n  const applied = await db.execute(\"SELECT 1 FROM schema_migrations WHERE version = 2\");\n  if (applied.rows.length) return;\n\n  for (const table of demoEntityTables) {\n    try {\n      await db.execute(demoProvenanceMigrationSql(table));\n    } catch (error) {\n      // Concurrent cold starts can both observe an unapplied migration. Only the\n      // exact, recoverable duplicate-column outcome is safe to accept.\n      if (!isDuplicateIsDemoColumnError(error)) throw error;\n    }\n  }\n\n  await db.execute({\n    sql: \"INSERT OR IGNORE INTO schema_migrations (version, applied_at) VALUES (2, ?)\",\n    args: [new Date().toISOString()],\n  });\n}\n",[],[126,161],"e62562cf-b974-4924-a7ea-327aaca48cfe",["D",1789257043196],[172,173,174,175],[58],{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":200,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":201,"_18":202},{"_34":192,"_13":193,"_37":194,"_39":61,"_41":42,"_43":195,"_45":46,"_47":196,"_17":64,"_50":24,"_52":197,"_54":55,"_56":-5,"_81":198,"_18":199},{"_34":184,"_13":185,"_37":186,"_39":61,"_41":42,"_43":187,"_45":46,"_47":188,"_17":64,"_50":51,"_52":189,"_54":55,"_56":-5,"_81":190,"_18":191},{"_34":176,"_13":177,"_37":178,"_39":61,"_41":42,"_43":179,"_45":46,"_47":180,"_17":64,"_50":51,"_52":181,"_54":55,"_56":-5,"_81":182,"_18":183},"1861c029-4d6f-4028-b4c9-d7f27ae9b711","root.tsx","c489761c-af04-11f1-9abb-1607ee4eb77e",9,["D",1789257043718],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\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, viewport-fit=cover\" />\n          <meta name=\"theme-color\" content=\"#10221b\" />\n          <meta name=\"robots\" content=\"noindex,nofollow\" />\n          <title>BudgetApp</title>\n          <script src=\"https://cdn.twind.style\" crossOrigin=\"anonymous\" />\n          <link rel=\"icon\" href={immutableFileUrl(\"/frontend/favicon.svg\")} type=\"image/svg+xml\" />\n        </head>\n        <body className=\"m-0 bg-stone-50 text-stone-900 antialiased\">\n          <div id=\"root\" />\n          <script src=\"https://esm.town/v/std/catch\" />\n          <script src={immutableFileUrl(\"/frontend/index.tsx\")} type=\"module\" />\n        </body>\n      </html>\n    </>\n  );\n}\n",[],[58,177],"b4afe315-9e56-406e-8e1b-3a7e1d2b2db6","index.tsx","c4c46772-af04-11f1-82ca-1607ee4eb77e",16,["D",1789257043729],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No root element found\");\ncreateRoot(root).render(<App />);\n",[],[58,185],"b7a8592b-3acf-4b51-8ba2-c1c5b9c02408","favicon.svg","c4a44d84-af04-11f1-b691-1607ee4eb77e",12,["D",1789257043786],"<svg width=\"32\" height=\"32\" viewBox=\"0 0 32 32\" xmlns=\"http://www.w3.org/2000/svg\">\n  <rect width=\"32\" height=\"32\" rx=\"9\" fill=\"#163c2d\"/>\n  <path d=\"M8 11.5A3.5 3.5 0 0 1 11.5 8h9A3.5 3.5 0 0 1 24 11.5v9a3.5 3.5 0 0 1-3.5 3.5h-9A3.5 3.5 0 0 1 8 20.5v-9Z\" fill=\"#d6f36a\"/>\n  <path d=\"M11 16h10M16 11v10\" stroke=\"#163c2d\" stroke-width=\"2.4\" stroke-linecap=\"round\"/>\n</svg>\n",[],[58,193],["D",1789257043481],[203],[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":204,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_81":205,"_18":206},["D",1789505541717],[],[58,59,36],"bc270bf3-6831-493b-a6bf-e8bca9c639c8",["D",1789257041201],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","019bc8c8-8bb9-72ff-96b5-3323d5278042","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019bc8c8-8bba-72f3-b7c5-f4447a4e9cc4","tursoName","bc270bf36831493ba6bfe8bca9c639c8","tursoHostname","bc270bf36831493ba6bfe8bca9c639c8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789458074143],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_263":259},"org",{"_11":12,"_257":-5,"_258":259,"_217":218,"_260":261,"_262":55},"branch",{"_17":44,"_13":16,"_34":42,"_249":207,"_250":-5,"_251":-5,"_252":-5,"_253":-5,"_254":-5,"_255":14,"_256":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOE1CeERUd200ZFR6UURGWVJMalVQejNuWDMifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":207,"_13":14,"_47":346,"_209":-5,"_210":55,"_211":212,"_213":212,"_214":215,"_216":-5,"_217":218,"_219":75,"_220":46,"_221":-5,"_222":-5,"_223":64,"_224":225,"_226":227,"_228":229,"_230":347,"_232":-5,"_233":234,"_235":234,"_236":237,"_238":237,"_239":237,"_240":234,"_241":234,"_242":348,"_244":349,"_246":350,"_248":55},[295,301,306,309,310,311],"files",[295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311],"counts",{"_286":64,"_287":89,"_288":64,"_32":289,"_290":291},[284],{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":63,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_18":283},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":285},[58,59,36],"pulls","branches","forks",{"_292":64,"_294":64},"connections",{"_292":64,"_293":64},"count","unfilledCount","emptyCount",{"_34":168,"_13":58,"_37":61,"_39":-5,"_41":42,"_43":49,"_45":46,"_47":169,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":344,"_18":345},{"_34":60,"_13":59,"_37":40,"_39":61,"_41":42,"_43":62,"_45":46,"_47":200,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":342,"_18":343},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":204,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_81":340,"_18":341},{"_34":192,"_13":193,"_37":194,"_39":61,"_41":42,"_43":195,"_45":46,"_47":196,"_17":64,"_50":24,"_52":197,"_54":55,"_56":-5,"_81":338,"_18":339},{"_34":184,"_13":185,"_37":186,"_39":61,"_41":42,"_43":187,"_45":46,"_47":188,"_17":64,"_50":51,"_52":189,"_54":55,"_56":-5,"_81":336,"_18":337},{"_34":176,"_13":177,"_37":178,"_39":61,"_41":42,"_43":179,"_45":46,"_47":180,"_17":64,"_50":51,"_52":181,"_54":55,"_56":-5,"_81":334,"_18":335},{"_34":125,"_13":126,"_37":127,"_39":-5,"_41":42,"_43":128,"_45":46,"_47":129,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":332,"_18":333},{"_34":160,"_13":161,"_37":162,"_39":127,"_41":42,"_43":163,"_45":46,"_47":164,"_17":89,"_50":51,"_52":165,"_54":55,"_56":-5,"_81":330,"_18":331},{"_34":152,"_13":153,"_37":154,"_39":127,"_41":42,"_43":155,"_45":46,"_47":156,"_17":64,"_50":51,"_52":157,"_54":55,"_56":-5,"_81":328,"_18":329},{"_34":144,"_13":145,"_37":146,"_39":127,"_41":42,"_43":147,"_45":46,"_47":148,"_17":89,"_50":51,"_52":149,"_54":55,"_56":-5,"_81":326,"_18":327},{"_34":136,"_13":137,"_37":138,"_39":127,"_41":42,"_43":139,"_45":46,"_47":140,"_17":89,"_50":51,"_52":141,"_54":55,"_56":-5,"_81":324,"_18":325},{"_34":101,"_13":102,"_37":103,"_39":-5,"_41":42,"_43":89,"_45":46,"_47":104,"_17":64,"_50":65,"_52":-5,"_54":55,"_56":-5,"_81":322,"_18":323},{"_34":117,"_13":118,"_37":119,"_39":103,"_41":42,"_43":120,"_45":46,"_47":121,"_17":64,"_50":51,"_52":122,"_54":55,"_56":-5,"_81":320,"_18":321},{"_34":109,"_13":110,"_37":111,"_39":103,"_41":42,"_43":112,"_45":46,"_47":113,"_17":89,"_50":51,"_52":114,"_54":55,"_56":-5,"_81":318,"_18":319},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":89,"_50":24,"_52":98,"_54":55,"_56":-5,"_81":316,"_18":317},{"_34":84,"_13":85,"_37":86,"_39":-5,"_41":42,"_43":87,"_45":46,"_47":88,"_17":89,"_50":24,"_52":90,"_54":55,"_56":-5,"_81":314,"_18":315},{"_34":73,"_13":74,"_37":75,"_39":-5,"_41":42,"_43":76,"_45":46,"_47":77,"_17":78,"_50":79,"_52":80,"_54":55,"_56":-5,"_81":312,"_18":313},[],[74],[],[85],[],[94],[],[102,110],[],[102,118],[307,308],[102],[],[126,137],[],[126,145],[],[126,153],[],[126,161],[302,303,304,305],[126],[],[58,177],[],[58,185],[],[58,193],[],[58,59,36],[297],[58,59],[296,298,299,300],[58],["D",1789257041201],["D",1789458074143],{"_11":12,"_263":259},{"_11":12,"_257":-5,"_258":259,"_217":218,"_260":261,"_262":55},{"_17":44,"_13":16,"_34":42,"_249":207,"_250":-5,"_251":-5,"_252":-5,"_253":-5,"_254":-5,"_255":14,"_256":12},"ctx",{"_242":-5,"_280":384,"_385":386,"_387":388,"_389":55,"_390":55,"_391":55,"_392":46,"_393":-5,"_394":-7,"_395":-7,"_396":64,"_397":55,"_398":55,"_399":-5,"_400":55,"_401":55,"_402":55,"_403":-5},"ENV",{"_355":356,"_357":358,"_359":16,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383},"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"]
</article></body></html>