[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_203":204,"_205":206},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_107":89,"_26":101,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":58,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","lib/jobs.ts","latestPath","fileId","eee2414a-5cda-11f1-89fb-1607ee4eb77e","name","jobs.ts","fileType","script","content","import {\n getImportableTransactions,\n getSetting,\n markTransactionFailed,\n markTransactionImported,\n migrate,\n recordSyncRun,\n setSetting,\n upsertAkahuAccounts,\n upsertAkahuTransactions,\n upsertYnabAccounts,\n upsertYnabPlans,\n type NormalizedAkahuTransaction,\n} from \"./db.ts\";\nimport { hasAkahuCredentials, listAkahuAccounts, listSettledTransactions } from \"./akahu.ts\";\nimport { createTransactions, hasYnabCredentials, listPlanAccounts, listPlans, YnabError } from \"./ynab.ts\";\n\nconst DAY_MS = 24 * 60 * 60 * 1000;\n\nexport type CatalogRefreshResult = {\n akahuAccounts: number;\n ynabPlans: number;\n ynabAccounts: number;\n selectedPlanId: string | null;\n};\n\nexport type SyncResult = {\n fetched: number;\n stored: number;\n startIso: string;\n endIso: string;\n};\n\nexport type ImportResult = {\n requested: number;\n imported: number;\n failed: number;\n duplicates: number;\n};\n\nexport async function refreshCatalog(): Promise {\n await migrate();\n let akahuAccounts = 0;\n let ynabPlans = 0;\n let ynabAccounts = 0;\n let selectedPlanId = await getSetting(\"ynab_plan_id\");\n\n if (hasAkahuCredentials()) {\n const accounts = await listAkahuAccounts();\n akahuAccounts = await upsertAkahuAccounts(accounts);\n }\n\n if (hasYnabCredentials()) {\n const plans = await listPlans();\n ynabPlans = await upsertYnabPlans(plans);\n\n if (!selectedPlanId && plans.length === 1) {\n selectedPlanId = plans[0].id;\n await setSetting(\"ynab_plan_id\", plans[0].id);\n await setSetting(\"ynab_plan_name\", plans[0].name ?? \"Unnamed plan\");\n }\n\n if (selectedPlanId) {\n const accounts = await listPlanAccounts(selectedPlanId);\n ynabAccounts = await upsertYnabAccounts(accounts);\n }\n }\n\n await setSetting(\"last_catalog_refresh_at\", new Date().toISOString());\n return { akahuAccounts, ynabPlans, ynabAccounts, selectedPlanId };\n}\n\nexport async function runAkahuSync(options: {\n triggerName: string;\n forceBackfill?: boolean;\n backfillDays?: number;\n overlapDays?: number;\n}): Promise {\n await migrate();\n const startedAt = new Date().toISOString();\n const endDate = new Date();\n const endIso = endDate.toISOString();\n const overlapDays = options.overlapDays ?? 7;\n const configuredBackfillDays = Number(await getSetting(\"backfill_days\")) || 30;\n const backfillDays = options.backfillDays ?? configuredBackfillDays;\n const lastSyncAt = await getSetting(\"last_successful_akahu_sync_at\");\n\n let startDate: Date;\n if (options.forceBackfill || !lastSyncAt) {\n startDate = new Date(endDate.getTime() - backfillDays * DAY_MS);\n } else {\n startDate = new Date(Date.parse(lastSyncAt) - overlapDays * DAY_MS);\n }\n const startIso = startDate.toISOString();\n\n try {\n const accounts = await listAkahuAccounts();\n await upsertAkahuAccounts(accounts);\n\n const rawTransactions = await listSettledTransactions(startIso, endIso);\n const normalized = await Promise.all(rawTransactions.map(normalizeAkahuTransaction));\n const stored = await upsertAkahuTransactions(normalized);\n\n await setSetting(\"last_successful_akahu_sync_at\", endIso);\n await recordSyncRun({\n trigger_name: options.triggerName,\n started_at: startedAt,\n finished_at: new Date().toISOString(),\n ok: true,\n message: null,\n fetched_count: rawTransactions.length,\n stored_count: stored,\n start_iso: startIso,\n end_iso: endIso,\n });\n\n return { fetched: rawTransactions.length, stored, startIso, endIso };\n } catch (error) {\n await recordSyncRun({\n trigger_name: options.triggerName,\n started_at: startedAt,\n finished_at: new Date().toISOString(),\n ok: false,\n message: error instanceof Error ? error.message : String(error),\n fetched_count: 0,\n stored_count: 0,\n start_iso: startIso,\n end_iso: endIso,\n });\n throw error;\n }\n}\n\nexport async function importReadyTransactions(ids: string[]): Promise {\n await migrate();\n const uniqueIds = [...new Set(ids)].filter(Boolean);\n const planId = await getSetting(\"ynab_plan_id\");\n if (!planId) throw new Error(\"Select a YNAB plan before importing.\");\n\n const rows = await getImportableTransactions(uniqueIds);\n const result: ImportResult = { requested: uniqueIds.length, imported: 0, failed: 0, duplicates: 0 };\n if (!rows.length) return result;\n\n if (rows.length === 1) {\n await importOne(planId, rows[0], result);\n return result;\n }\n\n try {\n const response = await createTransactions(planId, rows.map(toYnabTransaction));\n await applyYnabImportResponse(rows, response, result);\n } catch (error) {\n for (const row of rows) {\n await importOne(planId, row, result);\n }\n }\n\n return result;\n}\n\nasync function importOne(planId: string, row: any, result: ImportResult) {\n try {\n const response = await createTransactions(planId, [toYnabTransaction(row)]);\n await applyYnabImportResponse([row], response, result);\n } catch (error) {\n if (error instanceof YnabError && error.status === 409) {\n await markTransactionImported(row.akahu_id, null, \"Duplicate import_id already existed in YNAB.\");\n result.imported += 1;\n result.duplicates += 1;\n return;\n }\n const message = error instanceof Error ? error.message : String(error);\n await markTransactionFailed(row.akahu_id, message);\n result.failed += 1;\n }\n}\n\nasync function applyYnabImportResponse(rows: any[], response: any, result: ImportResult) {\n const saved = response?.data?.transactions ?? (response?.data?.transaction ? [response.data.transaction] : []);\n const duplicateImportIds = new Set(response?.data?.duplicate_import_ids ?? []);\n const savedByImportId = new Map();\n for (const transaction of saved) {\n if (transaction.import_id) savedByImportId.set(transaction.import_id, transaction);\n }\n\n for (const row of rows) {\n const savedTransaction = savedByImportId.get(row.import_id);\n if (savedTransaction) {\n await markTransactionImported(row.akahu_id, savedTransaction.id, null);\n result.imported += 1;\n } else if (duplicateImportIds.has(row.import_id)) {\n await markTransactionImported(row.akahu_id, null, \"Duplicate import_id already existed in YNAB.\");\n result.imported += 1;\n result.duplicates += 1;\n } else {\n await markTransactionFailed(row.akahu_id, \"YNAB did not return this transaction in the import response.\");\n result.failed += 1;\n }\n }\n}\n\nasync function normalizeAkahuTransaction(tx: any): Promise {\n return {\n akahu_id: tx._id,\n akahu_account_id: tx._account,\n date: tx.date,\n description: tx.description ?? \"\",\n amount: Number(tx.amount),\n type: tx.type ?? null,\n merchant_name: tx.merchant?.name ?? null,\n raw_json: JSON.stringify(tx),\n import_id: await ynabImportId(tx._id),\n };\n}\n\nasync function ynabImportId(akahuId: string) {\n const bytes = new TextEncoder().encode(akahuId);\n const digest = await crypto.subtle.digest(\"SHA-256\", bytes);\n const hex = [...new Uint8Array(digest)].map((byte) => byte.toString(16).padStart(2, \"0\")).join(\"\");\n return `AKAHU:${hex.slice(0, 28)}`;\n}\n\nfunction toYnabTransaction(row: any) {\n return {\n account_id: row.mapped_ynab_account_id,\n date: String(row.date).slice(0, 10),\n amount: Math.round(Number(row.amount) * 1000),\n payee_name: cleanText(row.merchant_name || row.description || \"Unknown payee\", 200),\n memo: cleanText(`Akahu: ${row.akahu_id} | ${row.description ?? \"\"}`, 500),\n cleared: \"cleared\",\n approved: false,\n import_id: row.import_id,\n };\n}\n\nfunction cleanText(value: string, maxLength: number) {\n return value.replace(/\\s+/g, \" \").trim().slice(0, maxLength) || null;\n}\n","createdAt",["D",1780223080556],"branchVersion","branchId","7dc9747e-5cda-11f1-83e7-1607ee4eb77e","id","7dc870d8-5cda-11f1-83e7-1607ee4eb77e","ynab-import",["D",1780222890810],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Forkable Akahu to YNAB importer with a review UI.","imageUrl","f0a197ec-9517-4b2a-bdcf-4f13ead4af98","pinnedFileId","7dcfb0e6-5cda-11f1-83e7-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e7d77-ed4e-710f-944e-eecb6671720e","tursoName","7dc870d85cda11f183e71607ee4eb77e","tursoHostname","7dc870d85cda11f183e71607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":101},"org",{"_99":98,"_100":101,"_102":101,"_18":54,"_103":104,"_105":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",31,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jonpdw","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":198,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":199,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":200,"_83":201,"_85":202,"_87":24},"tree",[157,162],"files",[157,158,159,160,161,162],"counts",{"_147":62,"_148":133,"_149":62,"_150":151,"_152":153},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":140,"_31":141,"_29":142,"_132":-5,"_40":41,"_39":143,"_134":58,"_37":144,"_13":62,"_33":145,"_35":-5,"_23":24,"_138":-5,"_26":146},{"_42":130,"_31":131,"_29":56,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":62,"_33":136,"_35":137,"_23":24,"_138":-5,"_26":139},"7dcfb000-5cda-11f1-83e7-1607ee4eb77e","main.ts","parentId",1,"latest",["D",1780222890837],"http","export default function () {\n return new Response(\"Setting up YNAB importer...\");\n}\n","label",[131],"a6213a4c-5cda-11f1-85d8-1607ee4eb77e","lib","a6213ae2-5cda-11f1-85d8-1607ee4eb77e",2,["D",1780222958493],"directory",[141],"pulls","branches","forks","envVars",{"_154":143,"_156":62},"connections",{"_154":62,"_155":62},"count","unfilledCount","emptyCount",{"_42":140,"_31":141,"_29":142,"_132":-5,"_40":41,"_39":143,"_134":58,"_37":195,"_13":62,"_33":145,"_35":-5,"_23":24,"_138":-5,"_164":196,"_26":197},{"_42":187,"_31":188,"_29":189,"_132":142,"_40":41,"_39":190,"_134":24,"_37":191,"_13":62,"_33":34,"_35":192,"_23":24,"_138":-5,"_164":193,"_26":194},{"_42":179,"_31":180,"_29":181,"_132":142,"_40":41,"_39":182,"_134":58,"_37":183,"_13":62,"_33":34,"_35":184,"_23":24,"_138":-5,"_164":185,"_26":186},{"_42":175,"_31":32,"_29":30,"_132":142,"_40":41,"_39":14,"_134":58,"_37":176,"_13":62,"_33":34,"_35":36,"_23":24,"_138":-5,"_164":177,"_26":178},{"_42":167,"_31":168,"_29":169,"_132":142,"_40":41,"_39":170,"_134":24,"_37":171,"_13":62,"_33":34,"_35":172,"_23":24,"_138":-5,"_164":173,"_26":174},{"_42":130,"_31":131,"_29":56,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":163,"_13":62,"_33":136,"_35":137,"_23":24,"_138":-5,"_164":165,"_26":166},["D",1780222890837],"children",[],[131],"d611a6a6-5cda-11f1-b61e-1607ee4eb77e","ynab.ts","d611a78c-5cda-11f1-b61e-1607ee4eb77e",5,["D",1780223038919],"const YNAB_BASE_URL = \"https://api.ynab.com/v1\";\n\nexport class YnabError extends Error {\n status: number;\n body: unknown;\n\n constructor(status: number, message: string, body: unknown) {\n super(message);\n this.name = \"YnabError\";\n this.status = status;\n this.body = body;\n }\n}\n\nexport function hasYnabCredentials() {\n return Boolean(Deno.env.get(\"YNAB_ACCESS_TOKEN\"));\n}\n\nfunction token() {\n const accessToken = Deno.env.get(\"YNAB_ACCESS_TOKEN\");\n if (!accessToken) throw new Error(\"Missing YNAB_ACCESS_TOKEN.\");\n return accessToken;\n}\n\nasync function ynabFetch(path: string, init: RequestInit = {}) {\n const response = await fetch(`${YNAB_BASE_URL}${path}`, {\n ...init,\n headers: {\n Authorization: `Bearer ${token()}`,\n Accept: \"application/json\",\n ...(init.body ? { \"Content-Type\": \"application/json\" } : {}),\n ...(init.headers ?? {}),\n },\n });\n\n const text = await response.text();\n let body: any = null;\n try {\n body = text ? JSON.parse(text) : null;\n } catch {\n body = text;\n }\n\n if (!response.ok) {\n const detail = body?.error?.detail ?? body?.error?.name ?? text ?? response.statusText;\n throw new YnabError(response.status, `YNAB ${response.status}: ${detail}`, body);\n }\n\n return body;\n}\n\nexport async function listPlans() {\n const body = await ynabFetch(\"/plans?include_accounts=true\");\n return body.data?.plans ?? [];\n}\n\nexport async function listPlanAccounts(planId: string) {\n const body = await ynabFetch(`/plans/${encodeURIComponent(planId)}/accounts`);\n return body.data?.accounts ?? [];\n}\n\nexport async function createTransactions(planId: string, transactions: any[]) {\n return await ynabFetch(`/plans/${encodeURIComponent(planId)}/transactions`, {\n method: \"POST\",\n body: JSON.stringify({ transactions }),\n });\n}\n",[],[141,168],"eee2408c-5cda-11f1-89fb-1607ee4eb77e",["D",1780223080556],[],[141,32],"c8296132-5cda-11f1-b894-1607ee4eb77e","db.ts","c8296222-5cda-11f1-b894-1607ee4eb77e",3,["D",1780223015588],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type TransactionStatus = \"needs_mapping\" | \"ready\" | \"imported\" | \"ignored\" | \"failed\";\n\nexport type NormalizedAkahuTransaction = {\n akahu_id: string;\n akahu_account_id: string;\n date: string;\n description: string;\n amount: number;\n type: string | null;\n merchant_name: string | null;\n raw_json: string;\n import_id: string;\n};\n\nexport type AccountMappingInput = {\n akahu_account_id: string;\n ynab_account_id: string | null;\n ignored: boolean;\n};\n\nconst STATUSES = new Set([\"needs_mapping\", \"ready\", \"imported\", \"ignored\", \"failed\"]);\n\nfunction nowIso() {\n return new Date().toISOString();\n}\n\nexport function normalizeStatus(value: string | null): TransactionStatus | \"all\" {\n if (value === \"all\") return \"all\";\n if (value && STATUSES.has(value)) return value as TransactionStatus;\n return \"ready\";\n}\n\nexport async function migrate() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS ynab_plans (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n last_modified_on TEXT,\n raw_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS ynab_accounts (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n type TEXT,\n closed INTEGER NOT NULL DEFAULT 0,\n on_budget INTEGER NOT NULL DEFAULT 0,\n transfer_payee_id TEXT,\n raw_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS akahu_accounts (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n type TEXT,\n status TEXT,\n connection_id TEXT,\n connection_name TEXT,\n formatted_account TEXT,\n has_transactions INTEGER NOT NULL DEFAULT 0,\n attributes_json TEXT NOT NULL,\n raw_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS account_mappings (\n akahu_account_id TEXT PRIMARY KEY,\n ynab_account_id TEXT,\n ignored INTEGER NOT NULL DEFAULT 0,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS akahu_transactions (\n akahu_id TEXT PRIMARY KEY,\n akahu_account_id TEXT NOT NULL,\n date TEXT NOT NULL,\n description TEXT NOT NULL,\n amount REAL NOT NULL,\n type TEXT,\n merchant_name TEXT,\n import_id TEXT NOT NULL UNIQUE,\n status TEXT NOT NULL,\n ynab_account_id TEXT,\n ynab_transaction_id TEXT,\n error TEXT,\n raw_json TEXT NOT NULL,\n first_seen_at TEXT NOT NULL,\n updated_at TEXT NOT NULL,\n imported_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS sync_runs (\n id TEXT PRIMARY KEY,\n trigger_name TEXT NOT NULL,\n started_at TEXT NOT NULL,\n finished_at TEXT NOT NULL,\n ok INTEGER NOT NULL,\n message TEXT,\n fetched_count INTEGER NOT NULL DEFAULT 0,\n stored_count INTEGER NOT NULL DEFAULT 0,\n start_iso TEXT,\n end_iso TEXT\n )`,\n `CREATE INDEX IF NOT EXISTS idx_akahu_transactions_status ON akahu_transactions(status)`,\n `CREATE INDEX IF NOT EXISTS idx_akahu_transactions_date ON akahu_transactions(date)`,\n `CREATE INDEX IF NOT EXISTS idx_akahu_transactions_account ON akahu_transactions(akahu_account_id)`,\n `CREATE INDEX IF NOT EXISTS idx_sync_runs_started ON sync_runs(started_at)`\n ]);\n}\n\nexport async function getSettings(): Promise> {\n const result = await sqlite.execute(\"SELECT key, value FROM settings\");\n return Object.fromEntries((result.rows as any[]).map((row) => [row.key, row.value]));\n}\n\nexport async function getSetting(key: string): Promise {\n const result = await sqlite.execute({ sql: \"SELECT value FROM settings WHERE key = ?\", args: [key] });\n return ((result.rows as any[])[0]?.value as string | undefined) ?? null;\n}\n\nexport async function setSetting(key: string, value: string) {\n await sqlite.execute({\n sql: `INSERT INTO settings (key, value, updated_at)\n VALUES (?, ?, ?)\n ON CONFLICT(key) DO UPDATE SET value = excluded.value, updated_at = excluded.updated_at`,\n args: [key, value, nowIso()],\n });\n}\n\nexport async function upsertYnabPlans(plans: any[]) {\n if (!plans.length) return 0;\n const updatedAt = nowIso();\n await sqlite.batch(plans.map((plan) => ({\n sql: `INSERT INTO ynab_plans (id, name, last_modified_on, raw_json, updated_at)\n VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n name = excluded.name,\n last_modified_on = excluded.last_modified_on,\n raw_json = excluded.raw_json,\n updated_at = excluded.updated_at`,\n args: [plan.id, plan.name ?? \"Unnamed plan\", plan.last_modified_on ?? null, JSON.stringify(plan), updatedAt],\n })));\n return plans.length;\n}\n\nexport async function upsertYnabAccounts(accounts: any[]) {\n if (!accounts.length) return 0;\n const updatedAt = nowIso();\n await sqlite.batch(accounts.map((account) => ({\n sql: `INSERT INTO ynab_accounts (id, name, type, closed, on_budget, transfer_payee_id, raw_json, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n name = excluded.name,\n type = excluded.type,\n closed = excluded.closed,\n on_budget = excluded.on_budget,\n transfer_payee_id = excluded.transfer_payee_id,\n raw_json = excluded.raw_json,\n updated_at = excluded.updated_at`,\n args: [\n account.id,\n account.name ?? \"Unnamed account\",\n account.type ?? null,\n account.closed ? 1 : 0,\n account.on_budget ? 1 : 0,\n account.transfer_payee_id ?? null,\n JSON.stringify(account),\n updatedAt,\n ],\n })));\n return accounts.length;\n}\n\nexport async function upsertAkahuAccounts(accounts: any[]) {\n if (!accounts.length) return 0;\n const updatedAt = nowIso();\n await sqlite.batch(accounts.map((account) => {\n const attributes = Array.isArray(account.attributes) ? account.attributes : [];\n return {\n sql: `INSERT INTO akahu_accounts (\n id, name, type, status, connection_id, connection_name, formatted_account,\n has_transactions, attributes_json, raw_json, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n name = excluded.name,\n type = excluded.type,\n status = excluded.status,\n connection_id = excluded.connection_id,\n connection_name = excluded.connection_name,\n formatted_account = excluded.formatted_account,\n has_transactions = excluded.has_transactions,\n attributes_json = excluded.attributes_json,\n raw_json = excluded.raw_json,\n updated_at = excluded.updated_at`,\n args: [\n account._id,\n account.name ?? \"Unnamed Akahu account\",\n account.type ?? null,\n account.status ?? null,\n account.connection?._id ?? account._connection ?? null,\n account.connection?.name ?? null,\n account.formatted_account ?? null,\n attributes.includes(\"TRANSACTIONS\") ? 1 : 0,\n JSON.stringify(attributes),\n JSON.stringify(account),\n updatedAt,\n ],\n };\n }));\n return accounts.length;\n}\n\nexport async function listYnabPlans() {\n const result = await sqlite.execute(\"SELECT * FROM ynab_plans ORDER BY name COLLATE NOCASE\");\n return result.rows as any[];\n}\n\nexport async function listYnabAccounts() {\n const result = await sqlite.execute(\n \"SELECT * FROM ynab_accounts WHERE closed = 0 ORDER BY on_budget DESC, name COLLATE NOCASE\",\n );\n return result.rows as any[];\n}\n\nexport async function listAkahuAccounts() {\n const result = await sqlite.execute(\n \"SELECT * FROM akahu_accounts ORDER BY has_transactions DESC, connection_name COLLATE NOCASE, name COLLATE NOCASE\",\n );\n return result.rows as any[];\n}\n\nexport async function listMappings() {\n const result = await sqlite.execute(\"SELECT * FROM account_mappings\");\n return result.rows as any[];\n}\n\nexport async function saveAccountMappings(mappings: AccountMappingInput[]) {\n const updatedAt = nowIso();\n const statements: any[] = [];\n for (const mapping of mappings) {\n if (mapping.ignored) {\n statements.push({\n sql: `INSERT INTO account_mappings (akahu_account_id, ynab_account_id, ignored, updated_at)\n VALUES (?, NULL, 1, ?)\n ON CONFLICT(akahu_account_id) DO UPDATE SET\n ynab_account_id = NULL, ignored = 1, updated_at = excluded.updated_at`,\n args: [mapping.akahu_account_id, updatedAt],\n });\n statements.push({\n sql: `UPDATE akahu_transactions\n SET status = 'ignored', ynab_account_id = NULL, error = NULL, updated_at = ?\n WHERE akahu_account_id = ? AND status != 'imported'`,\n args: [updatedAt, mapping.akahu_account_id],\n });\n } else if (mapping.ynab_account_id) {\n statements.push({\n sql: `INSERT INTO account_mappings (akahu_account_id, ynab_account_id, ignored, updated_at)\n VALUES (?, ?, 0, ?)\n ON CONFLICT(akahu_account_id) DO UPDATE SET\n ynab_account_id = excluded.ynab_account_id, ignored = 0, updated_at = excluded.updated_at`,\n args: [mapping.akahu_account_id, mapping.ynab_account_id, updatedAt],\n });\n statements.push({\n sql: `UPDATE akahu_transactions\n SET status = 'ready', ynab_account_id = ?, error = NULL, updated_at = ?\n WHERE akahu_account_id = ? AND status IN ('needs_mapping', 'ignored', 'failed')`,\n args: [mapping.ynab_account_id, updatedAt, mapping.akahu_account_id],\n });\n } else {\n statements.push({ sql: \"DELETE FROM account_mappings WHERE akahu_account_id = ?\", args: [mapping.akahu_account_id] });\n statements.push({\n sql: `UPDATE akahu_transactions\n SET status = 'needs_mapping', ynab_account_id = NULL, error = NULL, updated_at = ?\n WHERE akahu_account_id = ? AND status IN ('ready', 'ignored', 'failed')`,\n args: [updatedAt, mapping.akahu_account_id],\n });\n }\n }\n if (statements.length) await sqlite.batch(statements);\n}\n\nexport async function upsertAkahuTransactions(transactions: NormalizedAkahuTransaction[]) {\n if (!transactions.length) return 0;\n const mappings = await listMappings();\n const mappingByAccount = new Map(mappings.map((mapping: any) => [mapping.akahu_account_id, mapping]));\n const updatedAt = nowIso();\n await sqlite.batch(transactions.map((tx) => {\n const mapping: any = mappingByAccount.get(tx.akahu_account_id);\n const status = mapping?.ignored ? \"ignored\" : mapping?.ynab_account_id ? \"ready\" : \"needs_mapping\";\n const ynabAccountId = mapping?.ignored ? null : mapping?.ynab_account_id ?? null;\n return {\n sql: `INSERT INTO akahu_transactions (\n akahu_id, akahu_account_id, date, description, amount, type, merchant_name,\n import_id, status, ynab_account_id, raw_json, first_seen_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(akahu_id) DO UPDATE SET\n akahu_account_id = excluded.akahu_account_id,\n date = excluded.date,\n description = excluded.description,\n amount = excluded.amount,\n type = excluded.type,\n merchant_name = excluded.merchant_name,\n import_id = excluded.import_id,\n status = CASE\n WHEN akahu_transactions.status IN ('imported', 'ignored', 'failed') THEN akahu_transactions.status\n ELSE excluded.status\n END,\n ynab_account_id = CASE\n WHEN akahu_transactions.status = 'imported' THEN akahu_transactions.ynab_account_id\n ELSE excluded.ynab_account_id\n END,\n raw_json = excluded.raw_json,\n updated_at = excluded.updated_at`,\n args: [\n tx.akahu_id,\n tx.akahu_account_id,\n tx.date,\n tx.description,\n tx.amount,\n tx.type,\n tx.merchant_name,\n tx.import_id,\n status,\n ynabAccountId,\n tx.raw_json,\n updatedAt,\n updatedAt,\n ],\n };\n }));\n return transactions.length;\n}\n\nexport async function getCounts() {\n const result = await sqlite.execute(\"SELECT status, COUNT(*) AS count FROM akahu_transactions GROUP BY status\");\n const counts: Record = { needs_mapping: 0, ready: 0, imported: 0, ignored: 0, failed: 0 };\n for (const row of result.rows as any[]) counts[row.status] = Number(row.count);\n return counts;\n}\n\nexport async function listTransactions(status: TransactionStatus | \"all\", limit = 100) {\n const where = status === \"all\" ? \"\" : \"WHERE t.status = ?\";\n const args: any[] = status === \"all\" ? [limit] : [status, limit];\n const result = await sqlite.execute({\n sql: `SELECT\n t.*,\n aa.name AS akahu_account_name,\n aa.connection_name AS akahu_connection_name,\n ya.name AS ynab_account_name\n FROM akahu_transactions t\n LEFT JOIN akahu_accounts aa ON aa.id = t.akahu_account_id\n LEFT JOIN account_mappings m ON m.akahu_account_id = t.akahu_account_id\n LEFT JOIN ynab_accounts ya ON ya.id = COALESCE(t.ynab_account_id, m.ynab_account_id)\n ${where}\n ORDER BY t.date DESC, t.updated_at DESC\n LIMIT ?`,\n args,\n });\n return result.rows as any[];\n}\n\nexport async function getImportableTransactions(ids: string[]) {\n if (!ids.length) return [];\n const placeholders = ids.map(() => \"?\").join(\", \");\n const result = await sqlite.execute({\n sql: `SELECT\n t.*,\n COALESCE(t.ynab_account_id, m.ynab_account_id) AS mapped_ynab_account_id\n FROM akahu_transactions t\n JOIN account_mappings m ON m.akahu_account_id = t.akahu_account_id AND m.ignored = 0\n WHERE t.status = 'ready'\n AND m.ynab_account_id IS NOT NULL\n AND t.akahu_id IN (${placeholders})\n ORDER BY t.date ASC`,\n args: ids,\n });\n return result.rows as any[];\n}\n\nexport async function markTransactionsIgnored(ids: string[]) {\n if (!ids.length) return 0;\n const placeholders = ids.map(() => \"?\").join(\", \");\n await sqlite.execute({\n sql: `UPDATE akahu_transactions\n SET status = 'ignored', error = NULL, updated_at = ?\n WHERE akahu_id IN (${placeholders}) AND status != 'imported'`,\n args: [nowIso(), ...ids],\n });\n return ids.length;\n}\n\nexport async function resetFailedTransactions(ids: string[]) {\n if (!ids.length) return 0;\n const placeholders = ids.map(() => \"?\").join(\", \");\n await sqlite.execute({\n sql: `UPDATE akahu_transactions\n SET status = 'ready', error = NULL, updated_at = ?\n WHERE akahu_id IN (${placeholders}) AND status = 'failed'`,\n args: [nowIso(), ...ids],\n });\n return ids.length;\n}\n\nexport async function markTransactionImported(akahuId: string, ynabTransactionId: string | null, message: string | null = null) {\n const timestamp = nowIso();\n await sqlite.execute({\n sql: `UPDATE akahu_transactions\n SET status = 'imported', ynab_transaction_id = COALESCE(?, ynab_transaction_id), error = ?, imported_at = ?, updated_at = ?\n WHERE akahu_id = ?`,\n args: [ynabTransactionId, message, timestamp, timestamp, akahuId],\n });\n}\n\nexport async function markTransactionFailed(akahuId: string, error: string) {\n await sqlite.execute({\n sql: `UPDATE akahu_transactions SET status = 'failed', error = ?, updated_at = ? WHERE akahu_id = ?`,\n args: [error.slice(0, 1000), nowIso(), akahuId],\n });\n}\n\nexport async function recordSyncRun(run: {\n trigger_name: string;\n started_at: string;\n finished_at: string;\n ok: boolean;\n message: string | null;\n fetched_count: number;\n stored_count: number;\n start_iso: string | null;\n end_iso: string | null;\n}) {\n await sqlite.execute({\n sql: `INSERT INTO sync_runs (\n id, trigger_name, started_at, finished_at, ok, message, fetched_count, stored_count, start_iso, end_iso\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n run.trigger_name,\n run.started_at,\n run.finished_at,\n run.ok ? 1 : 0,\n run.message,\n run.fetched_count,\n run.stored_count,\n run.start_iso,\n run.end_iso,\n ],\n });\n}\n\nexport async function listRecentSyncRuns(limit = 5) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM sync_runs ORDER BY started_at DESC LIMIT ?\",\n args: [limit],\n });\n return result.rows as any[];\n}\n",[],[141,180],"cf051fd2-5cda-11f1-916e-1607ee4eb77e","akahu.ts","cf05209a-5cda-11f1-916e-1607ee4eb77e",4,["D",1780223027095],"const AKAHU_BASE_URL = \"https://api.akahu.io/v1\";\n\nexport class AkahuError extends Error {\n status: number;\n body: unknown;\n\n constructor(status: number, message: string, body: unknown) {\n super(message);\n this.name = \"AkahuError\";\n this.status = status;\n this.body = body;\n }\n}\n\nexport function hasAkahuCredentials() {\n return Boolean(Deno.env.get(\"AKAHU_USER_TOKEN\") && Deno.env.get(\"AKAHU_APP_TOKEN\"));\n}\n\nfunction credentials() {\n const userToken = Deno.env.get(\"AKAHU_USER_TOKEN\");\n const appToken = Deno.env.get(\"AKAHU_APP_TOKEN\");\n if (!userToken || !appToken) {\n throw new Error(\"Missing AKAHU_USER_TOKEN or AKAHU_APP_TOKEN.\");\n }\n return { userToken, appToken };\n}\n\nasync function akahuFetch(path: string, query: Record = {}) {\n const { userToken, appToken } = credentials();\n const url = new URL(`${AKAHU_BASE_URL}${path}`);\n for (const [key, value] of Object.entries(query)) {\n if (value) url.searchParams.set(key, value);\n }\n\n const response = await fetch(url, {\n headers: {\n Authorization: `Bearer ${userToken}`,\n \"X-Akahu-Id\": appToken,\n Accept: \"application/json\",\n },\n });\n\n const text = await response.text();\n let body: any = null;\n try {\n body = text ? JSON.parse(text) : null;\n } catch {\n body = text;\n }\n\n if (!response.ok || body?.success === false) {\n const detail = body?.message ?? body?.error_description ?? body?.error ?? text ?? response.statusText;\n throw new AkahuError(response.status, `Akahu ${response.status}: ${detail}`, body);\n }\n\n return body;\n}\n\nexport async function getAkahuMe() {\n return await akahuFetch(\"/me\");\n}\n\nexport async function listAkahuAccounts() {\n const body = await akahuFetch(\"/accounts\");\n return body.items ?? [];\n}\n\nexport async function listSettledTransactions(startIso: string, endIso: string) {\n const transactions: any[] = [];\n let cursor: string | null | undefined = undefined;\n\n do {\n const body = await akahuFetch(\"/transactions\", { start: startIso, end: endIso, cursor });\n transactions.push(...(body.items ?? []));\n cursor = body.cursor?.next ?? null;\n } while (cursor);\n\n return transactions;\n}\n",[],[141,188],["D",1780222958493],[158,159,160,161],[141],["D",1780222890810],["D",1789470042795],{"_99":98,"_106":101},{"_99":98,"_100":101,"_102":101,"_18":54,"_103":104,"_105":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_125":236,"_237":238,"_239":240,"_241":24,"_242":24,"_243":24,"_244":58,"_245":-5,"_246":-7,"_247":-7,"_248":62,"_249":24,"_250":24,"_251":-5,"_252":24,"_253":24,"_254":24,"_255":-5},"ENV",{"_207":208,"_209":210,"_211":89,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235},"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"]

Diff · v6