Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[],[229],"caa9cfa4-1203-11f1-9a25-42dde27851f2",".vtignore","caa9d058-1203-11f1-9a25-42dde27851f2",22,["D",1771994291944],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[],[237],["D",1773011875918],[],[18,82],["D",1771994291783],[],[18,66],["D",1771994290349],[214,215],[18],"ca4d2394-1203-11f1-86a1-42dde27851f2","style.css","ca4d2452-1203-11f1-86a1-42dde27851f2","c95f4a52-1203-11f1-a32e-42dde27851f2",12,["D",1771994291224],":root {\n --bg-base: #0B0F0E;\n --bg-surface: #141A18;\n --bg-surface-hover: #1A2220;\n --border: #1E2A26;\n --border-subtle: #162220;\n --primary: #34D399;\n --primary-dim: #34D39940;\n --text: #F0FDF4;\n --text-muted: #86EFAC80;\n --text-secondary: #A7C4B8;\n --positive: #34D399;\n --warning: #FBBF24;\n --danger: #F87171;\n --income: #6EE7B7;\n}\n\n* {\n box-sizing: border-box;\n margin: 0;\n padding: 0;\n}\n\nhtml, body {\n background: var(--bg-base);\n color: var(--text);\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, sans-serif;\n -webkit-font-smoothing: antialiased;\n min-height: 100vh;\n}\n\n#root {\n max-width: 640px;\n margin: 0 auto;\n padding: 0 16px;\n}\n\n/* Progress bar */\n.progress-track {\n height: 6px;\n background: var(--border);\n border-radius: 3px;\n overflow: hidden;\n}\n\n.progress-fill {\n height: 100%;\n border-radius: 3px;\n transition: width 0.4s ease;\n}\n\n/* Tab bar */\n.tab-bar {\n display: flex;\n gap: 2px;\n background: var(--bg-surface);\n border-radius: 10px;\n padding: 3px;\n margin-bottom: 24px;\n}\n\n.tab-bar button {\n flex: 1;\n padding: 8px 16px;\n border: none;\n border-radius: 8px;\n background: transparent;\n color: var(--text-muted);\n font-size: 14px;\n font-weight: 500;\n cursor: pointer;\n transition: all 0.2s;\n}\n\n.tab-bar button.active {\n background: var(--primary-dim);\n color: var(--primary);\n}\n\n/* Cards */\n.card {\n background: var(--bg-surface);\n border: 1px solid var(--border-subtle);\n border-radius: 12px;\n padding: 16px;\n margin-bottom: 12px;\n}\n\n.card-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n cursor: pointer;\n user-select: none;\n}\n\n/* Badge */\n.badge {\n display: inline-block;\n padding: 2px 8px;\n border-radius: 6px;\n font-size: 11px;\n font-weight: 500;\n background: var(--primary-dim);\n color: var(--primary);\n cursor: pointer;\n transition: background 0.15s;\n}\n\n.badge:hover {\n background: var(--primary);\n color: var(--bg-base);\n}\n\n.badge.empty {\n background: var(--border);\n color: var(--text-muted);\n}\n\n/* Transaction row */\n.tx-row {\n display: flex;\n align-items: center;\n gap: 12px;\n padding: 10px 0;\n border-bottom: 1px solid var(--border-subtle);\n}\n\n.tx-row:last-child {\n border-bottom: none;\n}\n\n/* Modal overlay */\n.modal-overlay {\n position: fixed;\n inset: 0;\n background: rgba(0, 0, 0, 0.7);\n display: flex;\n align-items: flex-end;\n justify-content: center;\n z-index: 50;\n animation: fadeIn 0.15s ease;\n}\n\n.modal-sheet {\n background: var(--bg-surface);\n border: 1px solid var(--border);\n border-radius: 16px 16px 0 0;\n width: 100%;\n max-width: 640px;\n max-height: 70vh;\n overflow-y: auto;\n padding: 20px;\n animation: slideUp 0.2s ease;\n}\n\n.modal-option {\n padding: 12px;\n border-radius: 8px;\n cursor: pointer;\n color: var(--text);\n transition: background 0.15s;\n}\n\n.modal-option:hover {\n background: var(--bg-surface-hover);\n}\n\n.modal-option.selected {\n background: var(--primary-dim);\n color: var(--primary);\n}\n\n@keyframes fadeIn {\n from { opacity: 0; }\n to { opacity: 1; }\n}\n\n@keyframes slideUp {\n from { transform: translateY(100%); }\n to { transform: translateY(0); }\n}\n\n/* Summary row */\n.summary-row {\n display: flex;\n justify-content: space-between;\n align-items: center;\n padding: 6px 0;\n}\n\n/* Setup screen */\n.setup-container {\n display: flex;\n flex-direction: column;\n align-items: center;\n justify-content: center;\n min-height: 60vh;\n gap: 16px;\n text-align: center;\n}\n\n.btn {\n padding: 10px 20px;\n border: none;\n border-radius: 8px;\n font-size: 14px;\n font-weight: 600;\n cursor: pointer;\n transition: all 0.15s;\n}\n\n.btn-primary {\n background: var(--primary);\n color: var(--bg-base);\n}\n\n.btn-primary:hover {\n filter: brightness(1.1);\n}\n\n.btn-primary:disabled {\n opacity: 0.5;\n cursor: not-allowed;\n}\n\n.btn-ghost {\n background: transparent;\n color: var(--text-muted);\n border: 1px solid var(--border);\n}\n\n.btn-ghost:hover {\n border-color: var(--primary);\n color: var(--primary);\n}\n\n/* Spinner */\n.spinner {\n width: 20px;\n height: 20px;\n border: 2px solid var(--border);\n border-top-color: var(--primary);\n border-radius: 50%;\n animation: spin 0.6s linear infinite;\n display: inline-block;\n}\n\n@keyframes spin {\n to { transform: rotate(360deg); }\n}\n\n/* Month selector */\n.month-nav {\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 16px;\n margin-bottom: 20px;\n}\n\n.month-nav button {\n background: none;\n border: none;\n color: var(--text-muted);\n font-size: 20px;\n cursor: pointer;\n padding: 4px 8px;\n border-radius: 6px;\n transition: color 0.15s;\n}\n\n.month-nav button:hover {\n color: var(--primary);\n}\n\n.month-nav span {\n font-size: 16px;\n font-weight: 600;\n min-width: 140px;\n text-align: center;\n}\n\n/* Filter bar */\n.filter-bar {\n display: flex;\n gap: 8px;\n margin-bottom: 16px;\n}\n\n.filter-bar input,\n.filter-bar select {\n flex: 1;\n padding: 8px 12px;\n background: var(--bg-surface);\n border: 1px solid var(--border);\n border-radius: 8px;\n color: var(--text);\n font-size: 13px;\n outline: none;\n transition: border-color 0.15s;\n}\n\n.filter-bar input:focus,\n.filter-bar select:focus {\n border-color: var(--primary);\n}\n\n.filter-bar select option {\n background: var(--bg-surface);\n}\n",[],[262,254],"frontend","ca23adfc-1203-11f1-a75d-42dde27851f2","index.tsx","ca23aed8-1203-11f1-a75d-42dde27851f2",7,["D",1771994291053],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0\";\nimport { App } from \"./components/App.tsx\";\n\nReactDOM.createRoot(document.getElementById(\"root\")!).render();\n",[],[262,264],"ca1f7a98-1203-11f1-8965-42dde27851f2","index.html","ca1f7b60-1203-11f1-8965-42dde27851f2",6,["D",1771994291040],"\n\n\n \n \n \n \n \n Runway\n $\" />\n \n \n \n\n\n

\n \n\n\n",[],[262,272],"ca3ba740-1203-11f1-bb6e-42dde27851f2","Transactions.tsx","ca3ba7fe-1203-11f1-bb6e-42dde27851f2","c9d7d0b2-1203-11f1-aea5-42dde27851f2",10,["D",1771994291187],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction } from \"../../shared/types.ts\";\nimport { ALL_CATEGORIES } from \"../../shared/categories.ts\";\nimport { CategoryPicker } from \"./CategoryPicker.tsx\";\n\nfunction currentMonth(): string {\n const d = new Date();\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction shiftMonth(month: string, delta: number): string {\n const [y, m] = month.split(\"-\").map(Number);\n const d = new Date(y, m - 1 + delta, 1);\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction formatMonth(month: string): string {\n const [y, m] = month.split(\"-\").map(Number);\n return new Date(y, m - 1).toLocaleDateString(\"en-US\", { month: \"long\", year: \"numeric\" });\n}\n\nfunction formatDate(ts: number): string {\n return new Date(ts * 1000).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n}\n\nfunction dollars(n: number): string {\n const abs = Math.abs(n);\n const formatted = \"$\" + abs.toLocaleString(\"en-US\", { minimumFractionDigits: 2, maximumFractionDigits: 2 });\n return n < 0 ? `-${formatted}` : formatted;\n}\n\nexport function Transactions() {\n const [month, setMonth] = useState(currentMonth);\n const [category, setCategory] = useState(\"\");\n const [search, setSearch] = useState(\"\");\n const [transactions, setTransactions] = useState([]);\n const [total, setTotal] = useState(0);\n const [loading, setLoading] = useState(true);\n\n const [pickerTx, setPickerTx] = useState(null);\n\n const fetchTx = useCallback(async () => {\n setLoading(true);\n const params = new URLSearchParams();\n params.set(\"month\", month);\n if (category) params.set(\"category\", category);\n if (search) params.set(\"search\", search);\n params.set(\"limit\", \"500\");\n\n const res = await fetch(`/api/transactions?${params}`);\n const data = await res.json();\n setTransactions(data.transactions);\n setTotal(data.total);\n setLoading(false);\n }, [month, category, search]);\n\n useEffect(() => {\n fetchTx();\n }, [fetchTx]);\n\n const handleCategoryUpdate = useCallback(async (newCategory: string) => {\n if (!pickerTx) return;\n await fetch(`/api/transactions/${encodeURIComponent(pickerTx.id)}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ category: newCategory }),\n });\n setPickerTx(null);\n fetchTx();\n }, [pickerTx, fetchTx]);\n\n return (\n

\n \n {formatMonth(month)}\n \n

\n\n

\n setSearch(e.target.value)}\n />\n \n

\n\n

\n {total} transaction{total !== 1 ? \"s\" : \"\"}\n

\n\n {loading ? (\n

\n ) : transactions.length === 0 ? (\n

\n No transactions found\n

\n ) : (\n

\n {transactions.map((tx) => {\n const amount = parseFloat(tx.amount);\n const isIncome = amount > 0;\n return (\n

\n {formatDate(tx.posted)}\n

\n {tx.payee || tx.description}\n

\n {tx.is_transfer && (\n transfer\n )}\n

\n setPickerTx(tx)}\n >\n {tx.category || \"—\"}\n

\n {dollars(amount)}\n

\n );\n })}\n

\n )}\n\n {pickerTx && (\n setPickerTx(null)}\n />\n )}\n \n );\n}\n",[],[262,288,280],"components","09ed7734-1b45-11f1-a31d-42dde27851f2","Rules.tsx","f760d396-1b39-11f1-a0df-42dde27851f2",39,["D",1773011875756],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { StoredRule } from \"../../shared/types.ts\";\nimport { ALL_CATEGORIES } from \"../../shared/categories.ts\";\n\ntype RuleType = \"payee_rename\" | \"category\";\ntype Condition = { field: \"payee\" | \"notes\"; contains: string };\n\ninterface RulesData {\n payeeRenameRules: StoredRule[];\n categoryRules: StoredRule[];\n transferCategories: string[];\n transferPayees: string[];\n}\n\ntype EditState =\n | { mode: \"create\"; type: RuleType }\n | { mode: \"edit\"; rule: StoredRule };\n\n// ---------------------------------------------------------------------------\n// Rule editor modal\n// ---------------------------------------------------------------------------\n\nfunction RuleEditor({\n editState,\n onSave,\n onCancel,\n}: {\n editState: EditState;\n onSave: (type: RuleType, conditions: Condition[], actionValue: string, id?: number) => Promise;\n onCancel: () => void;\n}) {\n const type = editState.mode === \"create\" ? editState.type : editState.rule.type;\n const existing = editState.mode === \"edit\" ? editState.rule : null;\n\n const [conditions, setConditions] = useState(\n existing?.conditions?.length\n ? existing.conditions\n : [{ field: \"payee\", contains: \"\" }],\n );\n const [actionValue, setActionValue] = useState(\n existing ? (existing.action.setPayee ?? existing.action.setCategory ?? \"\") : \"\",\n );\n const [error, setError] = useState(\"\");\n const [saving, setSaving] = useState(false);\n\n const title = type === \"payee_rename\"\n ? (existing ? \"Edit Payee Rename Rule\" : \"New Payee Rename Rule\")\n : (existing ? \"Edit Category Rule\" : \"New Category Rule\");\n\n const handleSave = async () => {\n if (conditions.some((c) => !c.contains.trim())) {\n setError(\"All conditions must have a value.\");\n return;\n }\n if (!actionValue.trim()) {\n setError(type === \"payee_rename\" ? \"Enter a payee name.\" : \"Select a category.\");\n return;\n }\n setSaving(true);\n setError(\"\");\n await onSave(type, conditions, actionValue, existing?.id);\n setSaving(false);\n };\n\n const updateCondition = (i: number, patch: Partial) => {\n setConditions((prev) => prev.map((c, idx) => idx === i ? { ...c, ...patch } : c));\n };\n\n const removeCondition = (i: number) => {\n setConditions((prev) => prev.filter((_, idx) => idx !== i));\n };\n\n return (\n

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

{title}

\n \n ×\n \n

\n\n

\n {type === \"payee_rename\"\n ? \"If any condition matches → rename the payee. First matching rule wins.\"\n : \"If any condition matches → assign the category. Last matching rule wins.\"}\n

\n\n {/* Conditions */}\n

\n Conditions (OR)\n

\n {conditions.map((cond, i) => (\n

\n {i > 0 && (\n \n OR\n \n )}\n {i === 0 &&

}\n updateCondition(i, { field: e.target.value as \"payee\" | \"notes\" })}\n style={selectStyle}\n >\n \n \n \n contains\n updateCondition(i, { contains: e.target.value })}\n placeholder=\"e.g. Starbucks\"\n style={{ ...inputStyle, flex: 1 }}\n />\n {conditions.length > 1 && (\n removeCondition(i)}\n style={{ background: \"none\", border: \"none\", color: \"var(--text-muted)\", cursor: \"pointer\", fontSize: 16, padding: \"0 4px\" }}\n >\n ×\n \n )}\n

\n ))}\n setConditions((prev) => [...prev, { field: \"payee\", contains: \"\" }])}\n style={{ fontSize: 12, color: \"var(--primary)\", background: \"none\", border: \"none\", cursor: \"pointer\", padding: \"4px 0\" }}\n >\n + Add condition (OR)\n \n

\n\n {/* Action */}\n

\n {type === \"payee_rename\" ? \"Then rename payee to\" : \"Then set category to\"}\n

\n {type === \"payee_rename\" ? (\n setActionValue(e.target.value)}\n placeholder=\"e.g. Starbucks\"\n style={{ ...inputStyle, width: \"100%\" }}\n />\n ) : (\n setActionValue(e.target.value)}\n style={{ ...selectStyle, width: \"100%\" }}\n >\n \n {ALL_CATEGORIES.filter((c) => c !== \"Uncategorized\").map((cat) => (\n \n ))}\n \n )}\n

\n\n {error && (\n

{error}

\n )}\n\n

\n \n \n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Recategorize prompt modal\n// ---------------------------------------------------------------------------\n\nfunction RecategorizePrompt({\n onApply,\n onSkip,\n applying,\n}: {\n onApply: () => void;\n onSkip: () => void;\n applying: boolean;\n}) {\n return (\n

Apply to history?

\n Would you like to re-categorize your existing transactions using the updated rules?\n Only transactions you haven't manually categorized will be affected.\n

\n \n \n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Shared inline styles\n// ---------------------------------------------------------------------------\n\nconst inputStyle: React.CSSProperties = {\n padding: \"7px 10px\",\n background: \"var(--bg-base)\",\n border: \"1px solid var(--border)\",\n borderRadius: 7,\n color: \"var(--text)\",\n fontSize: 13,\n outline: \"none\",\n};\n\nconst selectStyle: React.CSSProperties = {\n ...inputStyle,\n cursor: \"pointer\",\n};\n\n// ---------------------------------------------------------------------------\n// Rule row\n// ---------------------------------------------------------------------------\n\nfunction RuleRow({\n rule,\n actionLabel,\n actionValue,\n onEdit,\n onDelete,\n}: {\n rule: StoredRule;\n actionLabel: string;\n actionValue: string;\n onEdit: () => void;\n onDelete: () => void;\n}) {\n return (\n \n

\n {rule.conditions.map((cond, i) => (\n \n {i > 0 && (\n OR\n )}\n \n {cond.field}:\n \"{cond.contains}\"\n \n \n ))}\n

\n \n \n

\n →\n {actionLabel}\n \n {actionValue}\n \n

\n );\n}\n\nconst iconBtnStyle: React.CSSProperties = {\n background: \"none\",\n border: \"none\",\n cursor: \"pointer\",\n padding: \"2px 5px\",\n borderRadius: 5,\n fontSize: 13,\n opacity: 0.6,\n};\n\n// ---------------------------------------------------------------------------\n// Section wrapper\n// ---------------------------------------------------------------------------\n\nfunction Section({\n title,\n description,\n onAdd,\n children,\n}: {\n title: string;\n description: string;\n onAdd: () => void;\n children: React.ReactNode;\n}) {\n return (\n

{title}

\n \n + Add rule\n \n

{description}

\n {children}\n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Main Rules component\n// ---------------------------------------------------------------------------\n\nexport function Rules() {\n const [rules, setRules] = useState(null);\n const [loading, setLoading] = useState(true);\n const [editState, setEditState] = useState(null);\n const [showRecategorize, setShowRecategorize] = useState(false);\n const [applying, setApplying] = useState(false);\n\n const loadRules = useCallback(async () => {\n const res = await fetch(\"/api/rules\");\n const data = await res.json();\n setRules(data);\n setLoading(false);\n }, []);\n\n useEffect(() => { loadRules(); }, []);\n\n const handleSave = useCallback(async (\n type: RuleType,\n conditions: Condition[],\n actionValue: string,\n id?: number,\n ) => {\n const action = type === \"payee_rename\"\n ? { setPayee: actionValue }\n : { setCategory: actionValue };\n\n if (id != null) {\n await fetch(`/api/rules/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ conditions, action }),\n });\n } else {\n await fetch(\"/api/rules\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ type, conditions, action }),\n });\n }\n\n setEditState(null);\n await loadRules();\n setShowRecategorize(true);\n }, [loadRules]);\n\n const handleDelete = useCallback(async (id: number) => {\n await fetch(`/api/rules/${id}`, { method: \"DELETE\" });\n await loadRules();\n setShowRecategorize(true);\n }, [loadRules]);\n\n const handleApplyToHistory = useCallback(async () => {\n setApplying(true);\n await fetch(\"/api/rules/recategorize\", { method: \"POST\" });\n setApplying(false);\n setShowRecategorize(false);\n }, []);\n\n if (loading) {\n return (\n

\n \n

\n );\n }\n\n if (!rules) return null;\n\n return (\n <>\n setEditState({ mode: \"create\", type: \"payee_rename\" })}\n >\n {rules.payeeRenameRules.length === 0 ? (\n

No rules yet.

\n ) : (\n rules.payeeRenameRules.map((rule) => (\n setEditState({ mode: \"edit\", rule })}\n onDelete={() => handleDelete(rule.id)}\n />\n ))\n )}\n \n\n setEditState({ mode: \"create\", type: \"category\" })}\n >\n {rules.categoryRules.length === 0 ? (\n

No rules yet.

\n ) : (\n rules.categoryRules.map((rule) => (\n setEditState({ mode: \"edit\", rule })}\n onDelete={() => handleDelete(rule.id)}\n />\n ))\n )}\n \n\n

Transfer Detection

\n Transactions matching these are flagged as internal transfers and excluded from spending.\n

Categories:

\n {rules.transferCategories.map((c) => (\n {c}\n ))}\n

Payees:

\n {rules.transferPayees.map((p) => (\n {p}\n ))}\n

\n\n {editState && (\n setEditState(null)}\n />\n )}\n\n {showRecategorize && (\n setShowRecategorize(false)}\n applying={applying}\n />\n )}\n \n );\n}\n",[],[262,288,290],"0eae5940-1b3c-11f1-bd10-42dde27851f2","Login.tsx","0eae5a12-1b3c-11f1-bd10-42dde27851f2",30,["D",1773008018172],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useMemo } from \"https://esm.sh/react@18.2.0\";\n\nconst ERROR_MESSAGES: Record = {\n unauthorized: \"That Google account isn't authorized to access Runway.\",\n auth_failed: \"Authentication failed. Please try again.\",\n config_error: \"Server configuration error. Contact the admin.\",\n};\n\nexport function Login() {\n const errorKey = useMemo(() => {\n const params = new URLSearchParams(window.location.search);\n return params.get(\"error\") ?? \"\";\n }, []);\n\n const errorMessage = errorKey ? ERROR_MESSAGES[errorKey] ?? \"Something went wrong.\" : null;\n\n return (\n

Runway

\n Personal finance tracking. Sign in to continue.\n

\n\n {errorMessage && (\n \n {errorMessage}\n

\n )}\n\n {\n (e.currentTarget as HTMLAnchorElement).style.filter = \"brightness(0.95)\";\n }}\n onMouseLeave={(e) => {\n (e.currentTarget as HTMLAnchorElement).style.filter = \"\";\n }}\n >\n \n Sign in with Google\n \n \n );\n}\n",[],[262,288,298],"1c66e552-1b46-11f1-94d9-42dde27851f2","Dashboard.tsx","ca37713e-1203-11f1-a532-42dde27851f2",43,["D",1773012336285],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { BudgetSummary, BudgetSummaryItem, Transaction } from \"../../shared/types.ts\";\n\n// ---------------------------------------------------------------------------\n// Period types and helpers\n// ---------------------------------------------------------------------------\n\ntype Period = \"weekly\" | \"monthly\" | \"quarterly\";\n\ninterface DateRange {\n start: number; // Unix seconds\n end: number;\n label: string;\n days: number;\n}\n\nfunction startOfWeek(d: Date): Date {\n const day = d.getDay(); // 0=Sun\n const diff = day === 0 ? -6 : 1 - day; // back to Monday\n const result = new Date(d);\n result.setDate(d.getDate() + diff);\n result.setHours(0, 0, 0, 0);\n return result;\n}\n\nfunction initialCursor(period: Period): Date {\n const now = new Date();\n if (period === \"weekly\") return startOfWeek(now);\n if (period === \"monthly\") return new Date(now.getFullYear(), now.getMonth(), 1);\n const q = Math.floor(now.getMonth() / 3);\n return new Date(now.getFullYear(), q * 3, 1);\n}\n\nfunction advanceCursor(period: Period, cursor: Date, delta: number): Date {\n const d = new Date(cursor);\n if (period === \"weekly\") d.setDate(d.getDate() + delta * 7);\n else if (period === \"monthly\") d.setMonth(d.getMonth() + delta);\n else d.setMonth(d.getMonth() + delta * 3);\n return d;\n}\n\nfunction dateRangeFor(period: Period, cursor: Date): DateRange {\n let start: Date, end: Date, label: string;\n\n if (period === \"weekly\") {\n start = new Date(cursor);\n end = new Date(cursor);\n end.setDate(end.getDate() + 7);\n const fmt = (d: Date) =>\n d.toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n const endDay = new Date(end.getTime() - 86400000);\n label = start.getMonth() === endDay.getMonth()\n ? `${fmt(start)} – ${endDay.getDate()}, ${start.getFullYear()}`\n : `${fmt(start)} – ${fmt(endDay)}, ${endDay.getFullYear()}`;\n } else if (period === \"monthly\") {\n start = new Date(cursor.getFullYear(), cursor.getMonth(), 1);\n end = new Date(cursor.getFullYear(), cursor.getMonth() + 1, 1);\n label = start.toLocaleDateString(\"en-US\", { month: \"long\", year: \"numeric\" });\n } else {\n const q = Math.floor(cursor.getMonth() / 3);\n start = new Date(cursor.getFullYear(), q * 3, 1);\n end = new Date(cursor.getFullYear(), q * 3 + 3, 1);\n label = `Q${q + 1} ${cursor.getFullYear()}`;\n }\n\n const days = (end.getTime() - start.getTime()) / 86400000;\n return { start: start.getTime() / 1000, end: end.getTime() / 1000, label, days };\n}\n\n// ---------------------------------------------------------------------------\n// Formatters\n// ---------------------------------------------------------------------------\n\nfunction dollars(n: number): string {\n return \"$\" + Math.abs(n).toLocaleString(\"en-US\", {\n minimumFractionDigits: 2,\n maximumFractionDigits: 2,\n });\n}\n\nfunction formatDate(ts: number): string {\n return new Date(ts * 1000).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n}\n\nfunction pct(actual: number, target: number): number {\n if (target <= 0) return 0;\n return Math.min((actual / target) * 100, 100);\n}\n\nfunction barColor(actual: number, target: number): string {\n if (target <= 0) return \"var(--primary)\";\n const ratio = actual / target;\n if (ratio > 1) return \"var(--danger)\";\n if (ratio > 0.8) return \"var(--warning)\";\n return \"var(--primary)\";\n}\n\n// ---------------------------------------------------------------------------\n// CategorySheet — bottom sheet showing transactions for one budget item\n// ---------------------------------------------------------------------------\n\nfunction CategorySheet({\n item,\n range,\n onClose,\n}: {\n item: BudgetSummaryItem;\n range: DateRange;\n onClose: () => void;\n}) {\n const [transactions, setTransactions] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n const params = new URLSearchParams({\n start: String(range.start),\n end: String(range.end),\n category: item.ruleCategory,\n limit: \"200\",\n });\n fetch(`/api/transactions?${params}`)\n .then((r) => r.json())\n .then((data) => {\n setTransactions(data.transactions);\n setLoading(false);\n });\n }, [item.ruleCategory, range.start, range.end]);\n\n return (\n

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

\n {/* Header */}\n

{item.name}

{range.label}

\n \n ×\n \n

\n\n {/* Summary row */}\n

\n \n {loading ? \"…\" : `${transactions.length} transaction${transactions.length !== 1 ? \"s\" : \"\"}`}\n \n item.target ? \"var(--danger)\" : \"var(--text)\" }}>\n {dollars(item.actual)}\n \n {\" \"}/ {dollars(item.target)}\n \n \n

\n\n {/* Progress bar */}\n

\n \n

\n\n {/* Transaction list */}\n

\n {loading ? (\n

\n ) : transactions.length === 0 ? (\n

\n No transactions\n

\n ) : (\n transactions.map((tx) => {\n const amount = parseFloat(tx.amount);\n const isIncome = amount > 0;\n return (\n

\n {formatDate(tx.posted)}\n

\n {tx.payee || tx.description}\n

\n {dollars(amount)}\n

\n );\n })\n )}\n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Progress bar\n// ---------------------------------------------------------------------------\n\nfunction ProgressBar({ actual, target }: { actual: number; target: number }) {\n return (\n

\n \n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Budget item row — clickable\n// ---------------------------------------------------------------------------\n\nfunction BudgetItemRow({\n item,\n onDrillDown,\n}: {\n item: BudgetSummaryItem;\n onDrillDown: (item: BudgetSummaryItem) => void;\n}) {\n const over = item.actual > item.target;\n return (\n onDrillDown(item)}\n style={{ padding: \"8px 12px\", cursor: \"pointer\", borderRadius: 8, transition: \"background 0.1s\" }}\n onMouseEnter={(e) => { (e.currentTarget as HTMLDivElement).style.background = \"var(--bg-surface-hover)\"; }}\n onMouseLeave={(e) => { (e.currentTarget as HTMLDivElement).style.background = \"\"; }}\n >\n

\n {item.name}\n \n {dollars(item.actual)}\n / {dollars(item.target)}\n \n

\n \n \n );\n}\n\n// ---------------------------------------------------------------------------\n// Group card\n// ---------------------------------------------------------------------------\n\nfunction GroupCard({\n group,\n onDrillDown,\n}: {\n group: BudgetSummary[\"groups\"][number];\n onDrillDown: (item: BudgetSummaryItem) => void;\n}) {\n const [expanded, setExpanded] = useState(false);\n const over = group.totalActual > group.totalTarget;\n\n return (\n

setExpanded(!expanded)}>\n

{group.name}

\n {group.items.length} categories · tap to expand\n

\n {dollars(group.totalActual)}\n

/ {dollars(group.totalTarget)}

\n \n {expanded && (\n

\n {group.items.map((item) => (\n \n ))}\n

\n )}\n

\n );\n}\n\n// ---------------------------------------------------------------------------\n// Main Dashboard\n// ---------------------------------------------------------------------------\n\nexport function Dashboard() {\n const [period, setPeriod] = useState(\"monthly\");\n const [cursor, setCursor] = useState(() => initialCursor(\"monthly\"));\n const [summary, setSummary] = useState(null);\n const [loading, setLoading] = useState(true);\n const [drillDown, setDrillDown] = useState(null);\n\n // Reset cursor when period changes\n const handlePeriodChange = (p: Period) => {\n setPeriod(p);\n setCursor(initialCursor(p));\n };\n\n const range = dateRangeFor(period, cursor);\n\n const fetchSummary = useCallback(async (r: DateRange) => {\n setLoading(true);\n const res = await fetch(`/api/budget/summary?start=${r.start}&end=${r.end}`);\n const data: BudgetSummary = await res.json();\n setSummary(data);\n setLoading(false);\n }, []);\n\n useEffect(() => {\n fetchSummary(range);\n }, [range.start, range.end]);\n\n const savingsPositive = (summary?.savings ?? 0) >= 0;\n\n return (\n

\n {/* Period picker */}\n

\n {([\"weekly\", \"monthly\", \"quarterly\"] as Period[]).map((p) => (\n handlePeriodChange(p)}\n style={{ textTransform: \"capitalize\" }}\n >\n {p}\n \n ))}\n

\n\n {/* Period navigation */}\n

\n \n {range.label}\n \n

\n\n {loading ? (\n

\n ) : summary ? (\n <>\n {/* Summary cards */}\n

Income

{dollars(summary.totalIncome)}

Spent

{dollars(summary.totalExpenses)}

Saved

\n {savingsPositive ? \"\" : \"-\"}{dollars(summary.savings)}\n

{summary.savingsRate.toFixed(1)}%

\n\n {/* Total budget bar */}\n

\n Total Budget\n \n {dollars(summary.totalExpenses)} / {dollars(summary.expenseTarget)}\n \n

\n \n

\n\n {/* Group cards */}\n {summary.groups.map((group) => (\n \n ))}\n \n ) : null}\n\n {/* Drill-down sheet */}\n {drillDown && (\n setDrillDown(null)}\n />\n )}\n

\n );\n}\n",[],[262,288,306],"ca462a4e-1203-11f1-ac8f-42dde27851f2","CategoryPicker.tsx","ca462b34-1203-11f1-ac8f-42dde27851f2",11,["D",1771994291229],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { BudgetGroup } from \"../../shared/types.ts\";\nimport { BUDGET_GROUPS } from \"../../shared/categories.ts\";\n\ninterface Props {\n currentCategory: string;\n onSelect: (category: string) => void;\n onClose: () => void;\n}\n\nconst EXTRA_OPTIONS = [\n { group: \"Other\", items: [\"Other\", \"Uncategorized\", \"Transfer\", \"Income\"] },\n];\n\nexport function CategoryPicker({ currentCategory, onSelect, onClose }: Props) {\n return (\n

e.stopPropagation()}>\n

Set Category

\n \n ✕\n \n

\n\n {BUDGET_GROUPS.map((group: BudgetGroup) => (\n

\n {group.name}\n

\n {group.items.map((item) => (\n onSelect(item.ruleCategory)}\n >\n {item.name}\n

\n ))}\n

\n ))}\n\n {EXTRA_OPTIONS.map((section) => (\n

\n {section.group}\n

\n {section.items.map((cat) => (\n onSelect(cat)}\n >\n {cat}\n

\n ))}\n

\n ))}\n \n \n );\n}\n",[],[262,288,314],"de3e5e84-1b42-11f1-a676-42dde27851f2","App.tsx","ca340454-1203-11f1-ab27-42dde27851f2",33,["D",1773010943532],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useCallback, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { Transactions } from \"./Transactions.tsx\";\nimport { Rules } from \"./Rules.tsx\";\nimport { Login } from \"./Login.tsx\";\n\ntype Tab = \"dashboard\" | \"transactions\" | \"rules\";\n\nexport function App() {\n const [tab, setTab] = useState(\"dashboard\");\n const [syncing, setSyncing] = useState(false);\n const [refreshKey, setRefreshKey] = useState(0);\n\n const config = (window as any).__RUNWAY_CONFIG__ ?? { connected: false, user: null, lastSync: null };\n const [connected, setConnected] = useState(config.connected);\n const [lastSync, setLastSync] = useState(config.lastSync);\n const [now, setNow] = useState(() => Date.now());\n\n // Tick every minute so the \"X ago\" label stays fresh\n useEffect(() => {\n const id = setInterval(() => setNow(Date.now()), 60_000);\n return () => clearInterval(id);\n }, []);\n\n if (!config.user) {\n return ;\n }\n\n const handleClaim = useCallback(async () => {\n setSyncing(true);\n try {\n const res = await fetch(\"/api/simplefin/claim\", { method: \"POST\" });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error);\n setConnected(true);\n // Trigger initial sync after claiming\n await fetch(\"/api/sync\", { method: \"POST\" });\n setRefreshKey((k) => k + 1);\n } catch (err: any) {\n console.error(\"Claim error:\", err.message);\n } finally {\n setSyncing(false);\n }\n }, []);\n\n const handleSync = useCallback(async () => {\n setSyncing(true);\n try {\n await fetch(\"/api/sync\", { method: \"POST\" });\n setLastSync(Date.now() / 1000);\n setRefreshKey((k) => k + 1);\n } finally {\n setSyncing(false);\n }\n }, []);\n\n if (!connected) {\n return (\n

Runway

\n Connect your bank via SimpleFIN to start tracking your budget.\n Set the SIMPLEFIN_SETUP_TOKEN env var first.\n

\n \n

\n );\n }\n\n const syncLabel = (() => {\n if (!lastSync) return \"Never synced\";\n const diffMs = now - lastSync * 1000;\n const mins = Math.floor(diffMs / 60_000);\n if (mins < 1) return \"Synced just now\";\n if (mins < 60) return `Synced ${mins}m ago`;\n const hrs = Math.floor(mins / 60);\n if (hrs < 24) return `Synced ${hrs}h ago`;\n const days = Math.floor(hrs / 24);\n return `Synced ${days}d ago`;\n })();\n\n return (\n

Runway

\n {syncLabel}\n \n \n

\n\n

\n \n \n \n

\n\n {tab === \"dashboard\" && }\n {tab === \"transactions\" && }\n {tab === \"rules\" && }\n

\n );\n}\n",[],[262,288,322],"c9d7cfea-1203-11f1-aea5-42dde27851f2",4,["D",1771994290565],[204,205,206,207,208,209],[262,288],"c95f498a-1203-11f1-a32e-42dde27851f2",["D",1771994289777],[203,210,211,212],[262],"09e89782-1b45-11f1-9a36-42dde27851f2","sync.cron.ts","ca6746e8-1203-11f1-ac8f-42dde27851f2","c97e906a-1203-11f1-8965-42dde27851f2",38,["D",1773011875770],"interval","import { runMigrations } from \"./database/migrations.ts\";\nimport {\n getSyncState,\n setSyncState,\n upsertAccount,\n upsertTransaction,\n getExcludedAccountIds,\n} from \"./database/queries.ts\";\nimport { getAllRules } from \"./database/rulesQueries.ts\";\nimport { fetchAccounts, fetchHistorical } from \"./simplefin.ts\";\nimport { categorizeAll } from \"./categorize.ts\";\nimport { TRANSFER_CATEGORIES, TRANSFER_PAYEES } from \"../shared/categories.ts\";\nimport type { SimpleFINAccountSet } from \"../shared/types.ts\";\nimport type { RulesConfig } from \"../shared/types.ts\";\n\nconst TWO_YEARS_DAYS = 730;\nconst TWO_DAYS_S = 2 * 24 * 60 * 60;\n\nasync function processAccountSet(\n data: SimpleFINAccountSet,\n excludedIds: Set,\n rules: RulesConfig,\n): Promise<{ accountCount: number; txCount: number }> {\n let accountCount = 0;\n let txCount = 0;\n\n for (const account of data.accounts) {\n if (excludedIds.has(account.id)) continue;\n\n await upsertAccount({\n id: account.id,\n name: account.name,\n org_domain: account.org?.domain ?? \"\",\n currency: account.currency,\n balance: account.balance,\n balance_date: account[\"balance-date\"],\n excluded: false,\n });\n accountCount++;\n\n if (account.transactions) {\n const categorized = categorizeAll(\n account.transactions.map((tx) => ({\n id: tx.id,\n account_id: account.id,\n posted: tx.posted,\n amount: tx.amount,\n description: tx.description,\n notes: tx.extra?.notes as string ?? \"\",\n pending: tx.pending ?? false,\n })),\n rules,\n );\n\n for (const tx of categorized) {\n await upsertTransaction(tx);\n txCount++;\n }\n }\n }\n\n return { accountCount, txCount };\n}\n\n/**\n * Main sync function. Called by the cron trigger and the manual sync endpoint.\n */\nexport async function syncTransactions(): Promise<{\n accountCount: number;\n txCount: number;\n errors: string[];\n}> {\n await runMigrations();\n\n const accessUrl = await getSyncState(\"access_url\");\n if (!accessUrl) {\n return { accountCount: 0, txCount: 0, errors: [\"No SimpleFIN access URL configured. Claim a setup token first.\"] };\n }\n\n const { payeeRenameRules, categoryRules } = await getAllRules();\n const rules: RulesConfig = {\n payeeRenameRules,\n categoryRules,\n transferCategories: TRANSFER_CATEGORIES,\n transferPayees: TRANSFER_PAYEES,\n };\n\n const excludedIds = await getExcludedAccountIds();\n const lastSync = await getSyncState(\"last_sync_timestamp\");\n const allErrors: string[] = [];\n let totalAccounts = 0;\n let totalTx = 0;\n\n if (!lastSync) {\n // Initial sync: fetch historical data in 90-day windows\n const results = await fetchHistorical(accessUrl, TWO_YEARS_DAYS);\n for (const data of results) {\n allErrors.push(...data.errors);\n const { accountCount, txCount } = await processAccountSet(data, excludedIds, rules);\n totalAccounts += accountCount;\n totalTx += txCount;\n }\n } else {\n // Incremental sync: overlap by 2 days for late-posting transactions\n const startDate = Number(lastSync) - TWO_DAYS_S;\n const data = await fetchAccounts(accessUrl, { startDate });\n allErrors.push(...data.errors);\n const { accountCount, txCount } = await processAccountSet(data, excludedIds, rules);\n totalAccounts = accountCount;\n totalTx = txCount;\n }\n\n await setSyncState(\"last_sync_timestamp\", String(Math.floor(Date.now() / 1000)));\n\n return { accountCount: totalAccounts, txCount: totalTx, errors: allErrors };\n}\n\n// Val Town cron trigger entry point\nexport default async function () {\n const result = await syncTransactions();\n console.log(\n `Runway sync complete: ${result.accountCount} accounts, ${result.txCount} transactions` +\n (result.errors.length ? ` | errors: ${result.errors.join(\"; \")}` : \"\"),\n );\n}\n",[],[348,339],"backend","ca905038-1203-11f1-92b7-42dde27851f2","simplefin.ts","ca9050f6-1203-11f1-92b7-42dde27851f2",18,["D",1771994291777],"import type { SimpleFINAccountSet } from \"../shared/types.ts\";\n\n/**\n * Claim a SimpleFIN setup token, returning the access URL.\n * The setup token is base64-encoded; decoding gives a claim URL.\n * POST to that URL returns the access URL (with embedded credentials).\n */\nexport async function claimSetupToken(setupToken: string): Promise {\n const claimUrl = atob(setupToken.trim());\n const response = await fetch(claimUrl, { method: \"POST\" });\n\n if (response.status === 403) {\n throw new Error(\n \"Setup token was already claimed or is invalid. \" +\n \"The token may be compromised — disable it in SimpleFIN Bridge.\",\n );\n }\n if (!response.ok) {\n throw new Error(`Failed to claim token: ${response.status} ${response.statusText}`);\n }\n\n return response.text();\n}\n\n/**\n * Parse an access URL into { baseUrl, username, password }.\n * Access URLs look like: https://user:pass@bridge.simplefin.org/simplefin\n */\nfunction parseAccessUrl(accessUrl: string): { url: string; username: string; password: string } {\n const parsed = new URL(accessUrl);\n const username = parsed.username;\n const password = parsed.password;\n parsed.username = \"\";\n parsed.password = \"\";\n return { url: parsed.toString().replace(/\\/$/, \"\"), username, password };\n}\n\n/**\n * Fetch accounts and transactions from SimpleFIN for a given date range.\n * Date range is limited to 90 days per the API spec.\n */\nexport async function fetchAccounts(\n accessUrl: string,\n opts?: { startDate?: number; endDate?: number },\n): Promise {\n const { url, username, password } = parseAccessUrl(accessUrl);\n const params = new URLSearchParams();\n\n if (opts?.startDate !== undefined) {\n params.set(\"start-date\", String(Math.floor(opts.startDate)));\n }\n if (opts?.endDate !== undefined) {\n params.set(\"end-date\", String(Math.floor(opts.endDate)));\n }\n\n const qs = params.toString();\n const endpoint = `${url}/accounts${qs ? `?${qs}` : \"\"}`;\n\n const response = await fetch(endpoint, {\n headers: {\n Authorization: `Basic ${btoa(`${username}:${password}`)}`,\n },\n });\n\n if (response.status === 403) {\n throw new Error(\"SimpleFIN access revoked or credentials invalid.\");\n }\n if (response.status === 402) {\n throw new Error(\"SimpleFIN subscription payment required.\");\n }\n if (!response.ok) {\n throw new Error(`SimpleFIN error: ${response.status} ${response.statusText}`);\n }\n\n return response.json();\n}\n\nconst NINETY_DAYS_S = 90 * 24 * 60 * 60;\n\n/**\n * Fetch all historical transactions in 90-day windows going back a given\n * number of days from now. Returns all account sets merged.\n */\nexport async function fetchHistorical(\n accessUrl: string,\n daysBack: number,\n): Promise {\n const now = Math.floor(Date.now() / 1000);\n const earliest = now - daysBack * 24 * 60 * 60;\n const results: SimpleFINAccountSet[] = [];\n\n let windowEnd = now;\n while (windowEnd > earliest) {\n const windowStart = Math.max(windowEnd - NINETY_DAYS_S, earliest);\n const data = await fetchAccounts(accessUrl, {\n startDate: windowStart,\n endDate: windowEnd,\n });\n results.push(data);\n windowEnd = windowStart;\n }\n\n return results;\n}\n",[],[348,350],"1c70c09a-1b46-11f1-ba7c-42dde27851f2","index.http.ts","ca95f2ae-1203-11f1-a32e-42dde27851f2",44,["D",1773012336310],5,"http","import { Hono } from \"https://esm.sh/hono@4.4.6\";\nimport { getCookie, setCookie, deleteCookie } from \"https://esm.sh/hono@4.4.6/cookie\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n getAccounts,\n getTransactions,\n updateTransactionCategory,\n getMonthlySpendByCategory,\n getMonthlyIncome,\n getSpendByRange,\n getIncomeByRange,\n getSyncState,\n setSyncState,\n setAccountExcluded,\n getAllAutoTransactions,\n setAutoCategorization,\n} from \"./database/queries.ts\";\nimport {\n getAllRules,\n createRule,\n updateRule,\n deleteRule,\n} from \"./database/rulesQueries.ts\";\nimport { categorizeTransaction } from \"./categorize.ts\";\nimport { claimSetupToken } from \"./simplefin.ts\";\nimport { syncTransactions } from \"./sync.cron.ts\";\nimport {\n BUDGET_GROUPS,\n INCOME_TARGET,\n INCOME_CATEGORY,\n TRANSFER_CATEGORIES,\n TRANSFER_PAYEES,\n} from \"../shared/categories.ts\";\nimport type { BudgetSummary } from \"../shared/types.ts\";\nimport {\n ALLOWED_EMAIL,\n createSession,\n deleteSession,\n fetchGoogleUser,\n getGoogleAuthUrl,\n getSessionUser,\n} from \"./auth.ts\";\n\ntype Variables = { user: { email: string } };\n\nconst app = new Hono<{ Variables: Variables }>();\n\napp.onError((err, c) => {\n throw err;\n});\n\n// Run migrations on first request\nlet migrated = false;\napp.use(\"*\", async (_c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\n// Static files (no auth required)\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// ---------------------------------------------------------------------------\n// Auth routes\n// ---------------------------------------------------------------------------\n\napp.get(\"/auth/google\", (c) => {\n const clientId = Deno.env.get(\"GOOGLE_CLIENT_ID\");\n if (!clientId) return c.text(\"GOOGLE_CLIENT_ID env var not set\", 500);\n\n const origin = new URL(c.req.url).origin;\n const redirectUri = `${origin}/auth/google/callback`;\n const state = crypto.randomUUID();\n\n setCookie(c, \"oauth_state\", state, {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 600,\n path: \"/\",\n });\n\n return c.redirect(getGoogleAuthUrl(clientId, redirectUri, state));\n});\n\napp.get(\"/auth/google/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const state = c.req.query(\"state\");\n const savedState = getCookie(c, \"oauth_state\");\n\n if (!code || !state || state !== savedState) {\n return c.redirect(\"/?error=auth_failed\");\n }\n\n const clientId = Deno.env.get(\"GOOGLE_CLIENT_ID\");\n const clientSecret = Deno.env.get(\"GOOGLE_CLIENT_SECRET\");\n if (!clientId || !clientSecret) {\n return c.redirect(\"/?error=config_error\");\n }\n\n const origin = new URL(c.req.url).origin;\n const redirectUri = `${origin}/auth/google/callback`;\n\n const googleUser = await fetchGoogleUser(code, clientId, clientSecret, redirectUri);\n\n deleteCookie(c, \"oauth_state\", { path: \"/\" });\n\n if (!googleUser || googleUser.email !== ALLOWED_EMAIL) {\n return c.redirect(\"/?error=unauthorized\");\n }\n\n const sessionId = await createSession(googleUser.email);\n setCookie(c, \"session\", sessionId, {\n httpOnly: true,\n secure: true,\n sameSite: \"Lax\",\n maxAge: 7 * 24 * 60 * 60,\n path: \"/\",\n });\n\n return c.redirect(\"/\");\n});\n\napp.post(\"/auth/logout\", async (c) => {\n const sessionId = getCookie(c, \"session\");\n if (sessionId) await deleteSession(sessionId);\n deleteCookie(c, \"session\", { path: \"/\" });\n return c.redirect(\"/\");\n});\n\n// ---------------------------------------------------------------------------\n// Pages\n// ---------------------------------------------------------------------------\n\napp.get(\"/\", async (c) => {\n const sessionId = getCookie(c, \"session\");\n const user = sessionId ? await getSessionUser(sessionId) : null;\n\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n const hasAccess = !!(await getSyncState(\"access_url\"));\n const lastSync = await getSyncState(\"last_sync_timestamp\");\n const configScript = ``;\n html = html.replace(\"\", `${configScript}\\n`);\n\n return c.html(html);\n});\n\n// ---------------------------------------------------------------------------\n// API auth middleware — all /api/* routes require a valid session\n// ---------------------------------------------------------------------------\n\napp.use(\"/api/*\", async (c, next) => {\n const sessionId = getCookie(c, \"session\");\n if (!sessionId) return c.json({ error: \"Unauthorized\" }, 401);\n\n const user = await getSessionUser(sessionId);\n if (!user) return c.json({ error: \"Unauthorized\" }, 401);\n\n c.set(\"user\", user);\n await next();\n});\n\n// ---------------------------------------------------------------------------\n// SimpleFIN setup\n// ---------------------------------------------------------------------------\n\napp.post(\"/api/simplefin/claim\", async (c) => {\n const setupToken = Deno.env.get(\"SIMPLEFIN_SETUP_TOKEN\");\n if (!setupToken) {\n return c.json({ error: \"SIMPLEFIN_SETUP_TOKEN env var not set\" }, 400);\n }\n\n const existingUrl = await getSyncState(\"access_url\");\n if (existingUrl) {\n return c.json({ error: \"Already connected. Access URL exists.\" }, 409);\n }\n\n const accessUrl = await claimSetupToken(setupToken);\n await setSyncState(\"access_url\", accessUrl);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/simplefin/status\", async (c) => {\n const accessUrl = await getSyncState(\"access_url\");\n const lastSync = await getSyncState(\"last_sync_timestamp\");\n return c.json({\n connected: !!accessUrl,\n lastSync: lastSync ? Number(lastSync) : null,\n });\n});\n\n// ---------------------------------------------------------------------------\n// Sync\n// ---------------------------------------------------------------------------\n\napp.post(\"/api/sync\", async (c) => {\n const result = await syncTransactions();\n return c.json(result);\n});\n\n// ---------------------------------------------------------------------------\n// Accounts\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/accounts\", async (c) => {\n const accounts = await getAccounts();\n return c.json(accounts);\n});\n\napp.patch(\"/api/accounts/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n if (typeof body.excluded === \"boolean\") {\n await setAccountExcluded(id, body.excluded);\n }\n return c.json({ ok: true });\n});\n\n// ---------------------------------------------------------------------------\n// Transactions\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/transactions\", async (c) => {\n const month = c.req.query(\"month\");\n const startParam = c.req.query(\"start\");\n const endParam = c.req.query(\"end\");\n const category = c.req.query(\"category\");\n const search = c.req.query(\"search\");\n const limit = c.req.query(\"limit\") ? Number(c.req.query(\"limit\")) : undefined;\n const offset = c.req.query(\"offset\") ? Number(c.req.query(\"offset\")) : undefined;\n\n const result = await getTransactions({\n month,\n start: startParam ? Number(startParam) : undefined,\n end: endParam ? Number(endParam) : undefined,\n category,\n search,\n limit,\n offset,\n });\n return c.json(result);\n});\n\napp.patch(\"/api/transactions/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const isTransfer = TRANSFER_CATEGORIES.includes(body.category) || false;\n await updateTransactionCategory(id, body.category, isTransfer);\n return c.json({ ok: true });\n});\n\n// ---------------------------------------------------------------------------\n// Rules\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/rules\", async (c) => {\n const { payeeRenameRules, categoryRules } = await getAllRules();\n return c.json({\n payeeRenameRules,\n categoryRules,\n transferCategories: TRANSFER_CATEGORIES,\n transferPayees: TRANSFER_PAYEES,\n });\n});\n\napp.post(\"/api/rules\", async (c) => {\n const body = await c.req.json();\n const rule = await createRule(body.type, body.conditions, body.action);\n return c.json(rule, 201);\n});\n\napp.patch(\"/api/rules/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await updateRule(id, body.conditions, body.action);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/rules/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await deleteRule(id);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/rules/recategorize\", async (c) => {\n const { payeeRenameRules, categoryRules } = await getAllRules();\n const rules = {\n payeeRenameRules,\n categoryRules,\n transferCategories: TRANSFER_CATEGORIES,\n transferPayees: TRANSFER_PAYEES,\n };\n\n const transactions = await getAllAutoTransactions();\n for (const tx of transactions) {\n const result = categorizeTransaction(\n {\n description: tx.description,\n payee: tx.description,\n notes: tx.notes,\n category: \"\",\n category_source: \"\",\n is_transfer: false,\n },\n rules,\n );\n await setAutoCategorization(\n tx.id,\n result.payee,\n result.category,\n result.category_source,\n result.is_transfer,\n );\n }\n\n return c.json({ ok: true, count: transactions.length });\n});\n\n// ---------------------------------------------------------------------------\n// Budget summary\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/budget/summary\", async (c) => {\n const now = new Date();\n const startParam = c.req.query(\"start\");\n const endParam = c.req.query(\"end\");\n\n let start: number, end: number;\n if (startParam && endParam) {\n start = Number(startParam);\n end = Number(endParam);\n } else {\n const month = c.req.query(\"month\") ??\n `${now.getFullYear()}-${String(now.getMonth() + 1).padStart(2, \"0\")}`;\n const [year, m] = month.split(\"-\").map(Number);\n start = new Date(year, m - 1, 1).getTime() / 1000;\n end = new Date(year, m, 1).getTime() / 1000;\n }\n\n // Scale monthly targets proportionally to the period length\n const DAYS_PER_MONTH = 365.25 / 12;\n const periodDays = (end - start) / 86400;\n const scale = periodDays / DAYS_PER_MONTH;\n\n const spending = await getSpendByRange(start, end);\n const totalIncome = await getIncomeByRange(start, end);\n\n const groups = BUDGET_GROUPS.map((group) => {\n const items = group.items.map((item) => {\n const actual = Math.abs(spending[item.ruleCategory] ?? 0);\n const target = item.monthlyTarget * scale;\n return { name: item.name, target, actual, ruleCategory: item.ruleCategory };\n });\n return {\n name: group.name,\n items,\n totalTarget: items.reduce((s, i) => s + i.target, 0),\n totalActual: items.reduce((s, i) => s + i.actual, 0),\n };\n });\n\n const expenseTarget = groups.reduce((s, g) => s + g.totalTarget, 0);\n const totalExpenses = groups.reduce((s, g) => s + g.totalActual, 0);\n const savings = totalIncome - totalExpenses;\n const savingsRate = totalIncome > 0 ? (savings / totalIncome) * 100 : 0;\n\n const summary: BudgetSummary = {\n month: new Date(start * 1000).toISOString().slice(0, 7),\n groups,\n totalIncome,\n incomeTarget: INCOME_TARGET * scale,\n totalExpenses,\n expenseTarget,\n savings,\n savingsRate,\n };\n\n return c.json(summary);\n});\n\nexport default app.fetch;\n",[],[348,358],"09f996cc-1b45-11f1-9e46-42dde27851f2","categorize.ts","ca6b24fc-1203-11f1-9a25-42dde27851f2",40,["D",1773011875757],"import type { CategoryRule, RulesConfig, Transaction } from \"../shared/types.ts\";\n\nfunction matchesRule(\n rule: CategoryRule,\n payee: string,\n notes: string,\n): boolean {\n const payeeLower = payee.toLowerCase();\n const notesLower = notes.toLowerCase();\n // OR logic: any condition matching is sufficient\n return rule.conditions.some((cond) => {\n const value = cond.field === \"payee\" ? payeeLower : notesLower;\n return value.includes(cond.contains.toLowerCase());\n });\n}\n\n/**\n * Apply auto-categorization rules to a transaction.\n * Modifies payee, category, and is_transfer fields.\n * Does NOT touch transactions with category_source === 'manual'.\n */\nexport function categorizeTransaction(\n tx: {\n description: string;\n payee: string;\n notes: string;\n category: string;\n category_source: string;\n is_transfer: boolean;\n },\n rules: RulesConfig,\n): { payee: string; category: string; category_source: string; is_transfer: boolean } {\n let payee = tx.payee || tx.description;\n let category = tx.category;\n let categorySource = tx.category_source;\n let isTransfer = tx.is_transfer;\n\n if (categorySource === \"manual\") {\n return { payee, category, category_source: categorySource, is_transfer: isTransfer };\n }\n\n // Phase 1: payee renaming (first match wins)\n for (const rule of rules.payeeRenameRules) {\n if (matchesRule(rule, payee, tx.notes)) {\n if (rule.action.setPayee) {\n payee = rule.action.setPayee;\n }\n break;\n }\n }\n\n // Phase 2: category assignment (last match wins)\n for (const rule of rules.categoryRules) {\n if (matchesRule(rule, payee, tx.notes)) {\n if (rule.action.setCategory) {\n category = rule.action.setCategory;\n categorySource = \"auto\";\n }\n }\n }\n\n // Phase 3: detect transfers\n isTransfer =\n rules.transferCategories.includes(category) || rules.transferPayees.includes(payee);\n\n return { payee, category, category_source: categorySource, is_transfer: isTransfer };\n}\n\n/**\n * Apply categorization to a batch of raw transaction data and return\n * fully-formed Transaction objects.\n */\nexport function categorizeAll(\n rawTransactions: Array<{\n id: string;\n account_id: string;\n posted: number;\n amount: string;\n description: string;\n notes: string;\n pending: boolean;\n }>,\n rules: RulesConfig,\n): Transaction[] {\n return rawTransactions.map((raw) => {\n const result = categorizeTransaction(\n {\n description: raw.description,\n payee: raw.description,\n notes: raw.notes,\n category: \"\",\n category_source: \"\",\n is_transfer: false,\n },\n rules,\n );\n\n return {\n id: raw.id,\n account_id: raw.account_id,\n posted: raw.posted,\n amount: raw.amount,\n description: raw.description,\n payee: result.payee,\n notes: raw.notes,\n category: result.category,\n category_source: result.category_source as Transaction[\"category_source\"],\n is_transfer: result.is_transfer,\n pending: raw.pending,\n };\n });\n}\n",[],[348,368],"840ba1aa-1b43-11f1-8c4b-42dde27851f2","auth.ts","0eba4110-1b3c-11f1-b632-42dde27851f2",34,["D",1773011221715],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst SESSIONS_TABLE = \"runway_sessions\";\nconst SESSION_DURATION_MS = 7 * 24 * 60 * 60 * 1000; // 7 days\n\nexport const ALLOWED_EMAIL = \"shapedlines@gmail.com\";\n\n// ---------------------------------------------------------------------------\n// Session management\n// ---------------------------------------------------------------------------\n\nexport async function createSession(email: string): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, email, created_at, expires_at) VALUES (?, ?, ?, ?)`,\n [id, email, now, now + SESSION_DURATION_MS],\n );\n return id;\n}\n\nexport async function getSessionUser(sessionId: string): Promise<{ email: string } | null> {\n const result = await sqlite.execute(\n `SELECT email, expires_at FROM ${SESSIONS_TABLE} WHERE id = ?`,\n [sessionId],\n );\n if (result.rows.length === 0) return null;\n\n const email = result.rows[0][0];\n const expiresAt = result.rows[0][1];\n if (Date.now() > Number(expiresAt)) {\n await deleteSession(sessionId);\n return null;\n }\n return { email: String(email) };\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n}\n\n// ---------------------------------------------------------------------------\n// Google OAuth helpers\n// ---------------------------------------------------------------------------\n\nexport function getGoogleAuthUrl(clientId: string, redirectUri: string, state: string): string {\n const params = new URLSearchParams({\n client_id: clientId,\n redirect_uri: redirectUri,\n response_type: \"code\",\n scope: \"openid email profile\",\n state,\n access_type: \"online\",\n });\n return `https://accounts.google.com/o/oauth2/v2/auth?${params}`;\n}\n\nexport async function fetchGoogleUser(\n code: string,\n clientId: string,\n clientSecret: string,\n redirectUri: string,\n): Promise<{ email: string; name: string } | null> {\n const tokenRes = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n code,\n client_id: clientId,\n client_secret: clientSecret,\n redirect_uri: redirectUri,\n grant_type: \"authorization_code\",\n }),\n });\n if (!tokenRes.ok) return null;\n\n const { access_token } = await tokenRes.json();\n const userRes = await fetch(\"https://www.googleapis.com/oauth2/v3/userinfo\", {\n headers: { Authorization: `Bearer ${access_token}` },\n });\n if (!userRes.ok) return null;\n\n const { email, name } = await userRes.json();\n return { email: String(email), name: String(name ?? email) };\n}\n",[],[348,376],"09c8d06e-1b45-11f1-a5fa-42dde27851f2","rulesQueries.ts","09c8d12c-1b45-11f1-a5fa-42dde27851f2","ca044fac-1203-11f1-bfb6-42dde27851f2",35,["D",1773011875595],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { CategoryRule, StoredRule } from \"../../shared/types.ts\";\n\nconst TABLE = \"runway_rules\";\n\nfunction rowToStoredRule(row: any[]): StoredRule {\n return {\n id: Number(row[0]),\n type: String(row[1]) as \"payee_rename\" | \"category\",\n position: Number(row[2]),\n conditions: JSON.parse(String(row[3])),\n action: JSON.parse(String(row[4])),\n };\n}\n\nexport async function getAllRules(): Promise<{\n payeeRenameRules: StoredRule[];\n categoryRules: StoredRule[];\n}> {\n const result = await sqlite.execute(\n `SELECT id, type, position, conditions, action FROM ${TABLE} ORDER BY position ASC`,\n );\n const rules = result.rows.map(rowToStoredRule);\n return {\n payeeRenameRules: rules.filter((r) => r.type === \"payee_rename\"),\n categoryRules: rules.filter((r) => r.type === \"category\"),\n };\n}\n\nexport async function createRule(\n type: \"payee_rename\" | \"category\",\n conditions: CategoryRule[\"conditions\"],\n action: CategoryRule[\"action\"],\n): Promise {\n const maxRes = await sqlite.execute(\n `SELECT MAX(position) FROM ${TABLE} WHERE type = ?`,\n [type],\n );\n const maxPos = maxRes.rows[0][0] != null ? Number(maxRes.rows[0][0]) : -1;\n const position = maxPos + 1;\n\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE} (type, position, conditions, action) VALUES (?, ?, ?, ?)`,\n [type, position, JSON.stringify(conditions), JSON.stringify(action)],\n );\n return {\n id: Number(result.lastInsertRowid),\n type,\n position,\n conditions,\n action,\n };\n}\n\nexport async function updateRule(\n id: number,\n conditions: CategoryRule[\"conditions\"],\n action: CategoryRule[\"action\"],\n): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE} SET conditions = ?, action = ? WHERE id = ?`,\n [JSON.stringify(conditions), JSON.stringify(action), id],\n );\n}\n\nexport async function deleteRule(id: number): Promise {\n await sqlite.execute(`DELETE FROM ${TABLE} WHERE id = ?`, [id]);\n}\n\n/** Seeds the DB with hardcoded rules from shared/categories.ts if the table is empty. */\nexport async function seedRulesIfEmpty(): Promise {\n const count = await sqlite.execute(`SELECT COUNT(*) FROM ${TABLE}`);\n if (Number(count.rows[0][0]) > 0) return;\n\n const { PAYEE_RENAME_RULES, CATEGORY_RULES } = await import(\n \"../../shared/categories.ts\"\n );\n\n for (let i = 0; i < PAYEE_RENAME_RULES.length; i++) {\n const rule = PAYEE_RENAME_RULES[i];\n await sqlite.execute(\n `INSERT INTO ${TABLE} (type, position, conditions, action) VALUES (?, ?, ?, ?)`,\n [\"payee_rename\", i, JSON.stringify(rule.conditions), JSON.stringify(rule.action)],\n );\n }\n\n for (let i = 0; i < CATEGORY_RULES.length; i++) {\n const rule = CATEGORY_RULES[i];\n await sqlite.execute(\n `INSERT INTO ${TABLE} (type, position, conditions, action) VALUES (?, ?, ?, ?)`,\n [\"category\", i, JSON.stringify(rule.conditions), JSON.stringify(rule.action)],\n );\n }\n}\n",[],[348,392,384],"database","1c8907c2-1b46-11f1-8050-42dde27851f2","queries.ts","ca57540e-1203-11f1-9a25-42dde27851f2",["D",1773012336544],2,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Account, Transaction } from \"../../shared/types.ts\";\n\nconst ACCOUNTS = \"runway_accounts\";\nconst TRANSACTIONS = \"runway_transactions\";\nconst SYNC_STATE = \"runway_sync_state\";\n\n// ---------------------------------------------------------------------------\n// Sync state\n// ---------------------------------------------------------------------------\n\nexport async function getSyncState(key: string): Promise {\n const result = await sqlite.execute(\n `SELECT value FROM ${SYNC_STATE} WHERE key = ?`,\n [key],\n );\n return result.rows.length > 0 ? String(result.rows[0][0]) : null;\n}\n\nexport async function setSyncState(key: string, value: string): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${SYNC_STATE} (key, value) VALUES (?, ?)`,\n [key, value],\n );\n}\n\n// ---------------------------------------------------------------------------\n// Accounts\n// ---------------------------------------------------------------------------\n\nexport async function upsertAccount(account: Account): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${ACCOUNTS}\n (id, name, org_domain, currency, balance, balance_date, excluded)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n account.id,\n account.name,\n account.org_domain,\n account.currency,\n account.balance,\n account.balance_date,\n account.excluded ? 1 : 0,\n ],\n );\n}\n\nexport async function getAccounts(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${ACCOUNTS} ORDER BY name`);\n return result.rows.map((row) => ({\n id: String(row[0]),\n name: String(row[1]),\n org_domain: String(row[2]),\n currency: String(row[3]),\n balance: String(row[4]),\n balance_date: Number(row[5]),\n excluded: Boolean(row[6]),\n }));\n}\n\nexport async function setAccountExcluded(id: string, excluded: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${ACCOUNTS} SET excluded = ? WHERE id = ?`,\n [excluded ? 1 : 0, id],\n );\n}\n\nexport async function getExcludedAccountIds(): Promise> {\n const result = await sqlite.execute(\n `SELECT id FROM ${ACCOUNTS} WHERE excluded = 1`,\n );\n return new Set(result.rows.map((row) => String(row[0])));\n}\n\n// ---------------------------------------------------------------------------\n// Transactions\n// ---------------------------------------------------------------------------\n\nexport async function upsertTransaction(tx: Transaction): Promise {\n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS}\n (id, account_id, posted, amount, description, payee, notes, category, category_source, is_transfer, pending)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n account_id = excluded.account_id,\n posted = excluded.posted,\n amount = excluded.amount,\n description = excluded.description,\n payee = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.payee ELSE excluded.payee END,\n notes = excluded.notes,\n category = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.category ELSE excluded.category END,\n category_source = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN 'manual' ELSE excluded.category_source END,\n is_transfer = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.is_transfer ELSE excluded.is_transfer END,\n pending = excluded.pending`,\n [\n tx.id,\n tx.account_id,\n tx.posted,\n tx.amount,\n tx.description,\n tx.payee,\n tx.notes,\n tx.category,\n tx.category_source,\n tx.is_transfer ? 1 : 0,\n tx.pending ? 1 : 0,\n ],\n );\n}\n\nfunction rowToTransaction(row: any[]): Transaction {\n return {\n id: String(row[0]),\n account_id: String(row[1]),\n posted: Number(row[2]),\n amount: String(row[3]),\n description: String(row[4]),\n payee: String(row[5]),\n notes: String(row[6]),\n category: String(row[7]),\n category_source: String(row[8]) as Transaction[\"category_source\"],\n is_transfer: Boolean(row[9]),\n pending: Boolean(row[10]),\n };\n}\n\nexport async function getSpendByRange(start: number, end: number): Promise> {\n const result = await sqlite.execute(\n `SELECT category, SUM(CAST(amount AS REAL)) as total\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND is_transfer = 0\n GROUP BY category`,\n [start, end],\n );\n const spending: Record = {};\n for (const row of result.rows) {\n spending[String(row[0])] = Number(row[1]);\n }\n return spending;\n}\n\nexport async function getIncomeByRange(start: number, end: number): Promise {\n const result = await sqlite.execute(\n `SELECT SUM(CAST(amount AS REAL))\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND category = 'Income'`,\n [start, end],\n );\n return result.rows[0][0] ? Number(result.rows[0][0]) : 0;\n}\n\nexport async function getTransactions(opts: {\n month?: string;\n start?: number;\n end?: number;\n category?: string;\n search?: string;\n limit?: number;\n offset?: number;\n}): Promise<{ transactions: Transaction[]; total: number }> {\n const conditions: string[] = [];\n const params: any[] = [];\n\n if (opts.start != null && opts.end != null) {\n conditions.push(\"posted >= ? AND posted < ?\");\n params.push(opts.start, opts.end);\n } else if (opts.month) {\n const [year, month] = opts.month.split(\"-\").map(Number);\n const start = new Date(year, month - 1, 1).getTime() / 1000;\n const end = new Date(year, month, 1).getTime() / 1000;\n conditions.push(\"posted >= ? AND posted < ?\");\n params.push(start, end);\n }\n\n if (opts.category) {\n conditions.push(\"category = ?\");\n params.push(opts.category);\n }\n\n if (opts.search) {\n conditions.push(\"(payee LIKE ? OR description LIKE ?)\");\n const term = `%${opts.search}%`;\n params.push(term, term);\n }\n\n const where = conditions.length > 0 ? `WHERE ${conditions.join(\" AND \")}` : \"\";\n\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) FROM ${TRANSACTIONS} ${where}`,\n params,\n );\n const total = Number(countResult.rows[0][0]);\n\n const limit = opts.limit ?? 200;\n const offset = opts.offset ?? 0;\n const dataResult = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS} ${where} ORDER BY posted DESC LIMIT ? OFFSET ?`,\n [...params, limit, offset],\n );\n\n return {\n transactions: dataResult.rows.map(rowToTransaction),\n total,\n };\n}\n\nexport async function updateTransactionCategory(\n id: string,\n category: string,\n isTransfer: boolean,\n): Promise {\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS} SET category = ?, category_source = 'manual', is_transfer = ? WHERE id = ?`,\n [category, isTransfer ? 1 : 0, id],\n );\n}\n\nexport async function getMonthlySpendByCategory(month: string): Promise> {\n const [year, m] = month.split(\"-\").map(Number);\n const start = new Date(year, m - 1, 1).getTime() / 1000;\n const end = new Date(year, m, 1).getTime() / 1000;\n\n const result = await sqlite.execute(\n `SELECT category, SUM(CAST(amount AS REAL)) as total\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND is_transfer = 0\n GROUP BY category`,\n [start, end],\n );\n\n const spending: Record = {};\n for (const row of result.rows) {\n spending[String(row[0])] = Number(row[1]);\n }\n return spending;\n}\n\nexport async function getAllAutoTransactions(): Promise<\n Array<{ id: string; description: string; notes: string }>\n> {\n const result = await sqlite.execute(\n `SELECT id, description, notes FROM ${TRANSACTIONS} WHERE category_source != 'manual'`,\n );\n return result.rows.map((row) => ({\n id: String(row[0]),\n description: String(row[1]),\n notes: String(row[2]),\n }));\n}\n\nexport async function setAutoCategorization(\n id: string,\n payee: string,\n category: string,\n categorySource: string,\n isTransfer: boolean,\n): Promise {\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS} SET payee = ?, category = ?, category_source = ?, is_transfer = ? WHERE id = ?`,\n [payee, category, categorySource, isTransfer ? 1 : 0, id],\n );\n}\n\nexport async function getMonthlyIncome(month: string): Promise {\n const [year, m] = month.split(\"-\").map(Number);\n const start = new Date(year, m - 1, 1).getTime() / 1000;\n const end = new Date(year, m, 1).getTime() / 1000;\n\n const result = await sqlite.execute(\n `SELECT SUM(CAST(amount AS REAL))\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND category = 'Income'`,\n [start, end],\n );\n\n return result.rows[0][0] ? Number(result.rows[0][0]) : 0;\n}\n",[],[348,392,394],"09de81f2-1b45-11f1-aa58-42dde27851f2","migrations.ts","ca63fd4e-1203-11f1-8b72-42dde27851f2",36,["D",1773011875737],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { seedRulesIfEmpty } from \"./rulesQueries.ts\";\n\nconst ACCOUNTS_TABLE = \"runway_accounts\";\nconst TRANSACTIONS_TABLE = \"runway_transactions\";\nconst SYNC_STATE_TABLE = \"runway_sync_state\";\n\nexport async function runMigrations() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ACCOUNTS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n org_domain TEXT NOT NULL DEFAULT '',\n currency TEXT NOT NULL DEFAULT 'USD',\n balance TEXT NOT NULL DEFAULT '0',\n balance_date INTEGER NOT NULL DEFAULT 0,\n excluded INTEGER NOT NULL DEFAULT 0\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL,\n posted INTEGER NOT NULL,\n amount TEXT NOT NULL,\n description TEXT NOT NULL DEFAULT '',\n payee TEXT NOT NULL DEFAULT '',\n notes TEXT NOT NULL DEFAULT '',\n category TEXT NOT NULL DEFAULT '',\n category_source TEXT NOT NULL DEFAULT '',\n is_transfer INTEGER NOT NULL DEFAULT 0,\n pending INTEGER NOT NULL DEFAULT 0\n )`);\n\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_posted\n ON ${TRANSACTIONS_TABLE} (posted)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_category\n ON ${TRANSACTIONS_TABLE} (category)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_account\n ON ${TRANSACTIONS_TABLE} (account_id)`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SYNC_STATE_TABLE} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS runway_sessions (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS runway_rules (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n type TEXT NOT NULL,\n position INTEGER NOT NULL DEFAULT 0,\n conditions TEXT NOT NULL DEFAULT '[]',\n action TEXT NOT NULL DEFAULT '{}'\n )`);\n\n await seedRulesIfEmpty();\n}\n",[],[348,392,402],"ca044f0c-1203-11f1-bfb6-42dde27851f2",["D",1771994290859],[194,195,196],[348,392],"c97e8fc0-1203-11f1-8965-42dde27851f2",["D",1771994289982],[193,197,198,199,200,201],[348],["D",1771992592978],{"_11":12,"_141":72},{"_11":12,"_137":-5,"_71":72,"_31":70,"_138":139,"_140":30},{"_41":128,"_13":16,"_35":38,"_129":94,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"ctx",{"_54":-5,"_160":454,"_455":456,"_457":458,"_459":30,"_460":30,"_461":30,"_462":24,"_463":-5,"_464":-7,"_465":-7,"_466":26,"_467":30,"_468":30,"_469":-5,"_470":30,"_471":30,"_472":30,"_473":-5},"ENV",{"_425":426,"_427":428,"_429":16,"_430":431,"_432":433,"_434":435,"_436":437,"_438":439,"_440":441,"_442":443,"_444":445,"_446":447,"_448":449,"_450":451,"_452":453},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · shared