[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_298":299,"_300":301},"routes/_app.x.$handle.$name",{"_109":108,"_38":51,"_117":95,"_33":111,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_26":-5,"_128":129,"_130":131,"_132":31,"_133":134,"_135":64,"_136":-5,"_137":-5,"_138":139},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","2d7ecf92-2fa1-435f-975e-d197ea519597","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","019e354b-4058-72f9-b23c-16462c7b2d59","name","fileType","http","content","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport api from \"./backend/routes.ts\";\n\nconst app = new Hono();\n\n// API routes\napp.route(\"/api\", api);\n\n// Serve index.html at the root\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","createdAt",["D",1779010646930],"branchVersion","branchId","defc9c24-51d3-11f1-8889-ee650bb23af1","id","deb47d54-51d3-11f1-8889-ee650bb23af1","financial-tracker",["D",1779010584120],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","94ef5435-553f-4787-a0fb-c0926a04820d","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e34c6-b41c-7572-aff8-b2f2f04c460f","tursoName","deb47d5451d311f18889ee650bb23af1","tursoHostname","deb47d5451d311f18889ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789555877593],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_109":108,"_116":111},"org",{"_109":108,"_110":111,"_112":111,"_19":61,"_113":114,"_115":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":98,"_99":100,"_101":56,"_102":103,"_104":105,"_106":51,"_107":108},"isOwned",28,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","yamunna","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":293,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":294,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":295,"_89":296,"_91":297,"_93":31},"tree",[197,200,207,209,210],"files",[197,198,199,200,201,202,203,204,205,206,207,208,209,210],"counts",{"_187":68,"_188":160,"_189":68,"_190":191,"_192":193},"contents",[151,152,153,154,155],"upstreamProject",{"_49":103,"_38":147,"_58":59,"_60":148,"_55":56,"_87":149},"upstreamBranch",{"_49":98,"_44":140,"_141":142,"_38":95,"_96":103,"_13":143,"_97":-5,"_99":-5,"_144":145,"_53":-5,"_93":31,"_55":56,"_107":146,"_69":105,"_106":147},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789581599&sig=be8c9241dcaf80ae72eff5d4763f3300ec6426a8bddc365a5efaae5f85e4dee1",{"_109":146,"_116":150},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789581599&sig=bed85510764f48a9de82762af4b4ce99c525d0ab75e5b57f327c71a53e183d4a",{"_49":181,"_38":182,"_36":183,"_157":-5,"_47":48,"_46":184,"_158":64,"_44":185,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_33":186},{"_49":176,"_38":177,"_36":178,"_157":-5,"_47":48,"_46":160,"_158":64,"_44":179,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_33":180},{"_49":169,"_38":170,"_36":171,"_157":-5,"_47":48,"_46":172,"_158":64,"_44":173,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_33":175},{"_49":163,"_38":164,"_36":165,"_157":-5,"_47":48,"_46":160,"_158":31,"_44":166,"_13":68,"_39":26,"_41":167,"_30":31,"_161":-5,"_33":168},{"_49":156,"_38":34,"_36":37,"_157":-5,"_47":48,"_46":14,"_158":31,"_44":159,"_13":160,"_39":40,"_41":43,"_30":31,"_161":-5,"_33":162},"04226132-51d4-11f1-8811-ee650bb23af1","parentId","latest",["D",1779010646930],1,"label",[34],"df052cc2-51d3-11f1-8889-ee650bb23af1","README.md","019e354b-4058-72f9-b23c-11bbeafa2ec0",["D",1779010584120],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types",[164],"e3e017e8-51d3-11f1-bbb6-ee650bb23af1","shared","e3e018ba-51d3-11f1-bbb6-ee650bb23af1",2,["D",1779010592818],"directory",[170],"df052a92-51d3-11f1-8889-ee650bb23af1","frontend","019e354b-4058-72f9-b23c-0d28155a884c",["D",1779010584120],[177],"e3e6c7c8-51d3-11f1-83a1-ee650bb23af1","backend","e3e6c87c-51d3-11f1-83a1-ee650bb23af1",3,["D",1779010592837],[182],"pulls","branches","forks","envVars",{"_194":68,"_196":68},"connections",{"_194":68,"_195":68},"count","unfilledCount","emptyCount",{"_49":181,"_38":182,"_36":183,"_157":-5,"_47":48,"_46":184,"_158":64,"_44":290,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_212":291,"_33":292},{"_49":282,"_38":283,"_36":284,"_157":183,"_47":48,"_46":285,"_158":64,"_44":286,"_13":68,"_39":223,"_41":287,"_30":31,"_161":-5,"_212":288,"_33":289},{"_49":274,"_38":275,"_36":276,"_157":183,"_47":48,"_46":277,"_158":31,"_44":278,"_13":68,"_39":223,"_41":279,"_30":31,"_161":-5,"_212":280,"_33":281},{"_49":176,"_38":177,"_36":178,"_157":-5,"_47":48,"_46":160,"_158":64,"_44":271,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_212":272,"_33":273},{"_49":267,"_38":259,"_36":254,"_157":178,"_47":48,"_46":160,"_158":64,"_44":268,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_212":269,"_33":270},{"_49":260,"_38":261,"_36":262,"_157":254,"_47":48,"_46":160,"_158":31,"_44":263,"_13":68,"_39":223,"_41":264,"_30":31,"_161":-5,"_212":265,"_33":266},{"_49":251,"_38":252,"_36":253,"_157":254,"_47":48,"_46":160,"_158":31,"_44":255,"_13":68,"_39":223,"_41":256,"_30":31,"_161":-5,"_212":257,"_33":258},{"_49":244,"_38":245,"_36":246,"_157":178,"_47":48,"_46":160,"_158":31,"_44":247,"_13":68,"_39":26,"_41":248,"_30":31,"_161":-5,"_212":249,"_33":250},{"_49":237,"_38":238,"_36":239,"_157":178,"_47":48,"_46":160,"_158":31,"_44":240,"_13":68,"_39":26,"_41":241,"_30":31,"_161":-5,"_212":242,"_33":243},{"_49":230,"_38":231,"_36":232,"_157":178,"_47":48,"_46":160,"_158":64,"_44":233,"_13":68,"_39":223,"_41":234,"_30":31,"_161":-5,"_212":235,"_33":236},{"_49":169,"_38":170,"_36":171,"_157":-5,"_47":48,"_46":172,"_158":64,"_44":227,"_13":68,"_39":174,"_41":-5,"_30":31,"_161":-5,"_212":228,"_33":229},{"_49":218,"_38":219,"_36":220,"_157":171,"_47":48,"_46":221,"_158":64,"_44":222,"_13":68,"_39":223,"_41":224,"_30":31,"_161":-5,"_212":225,"_33":226},{"_49":163,"_38":164,"_36":165,"_157":-5,"_47":48,"_46":160,"_158":31,"_44":215,"_13":68,"_39":26,"_41":167,"_30":31,"_161":-5,"_212":216,"_33":217},{"_49":156,"_38":34,"_36":37,"_157":-5,"_47":48,"_46":14,"_158":31,"_44":211,"_13":160,"_39":40,"_41":43,"_30":31,"_161":-5,"_212":213,"_33":214},["D",1779010646930],"children",[],[34],["D",1779010584120],[],[164],"e8eaa762-51d3-11f1-8889-ee650bb23af1","types.ts","e8eaa87a-51d3-11f1-8889-ee650bb23af1",4,["D",1779010601265],"script","export interface Loan {\n id?: number;\n name: string;\n lender: string;\n lenderOther?: string;\n loanType: string;\n description: string;\n principal: number;\n interestRate: number;\n monthlyPayment: number;\n totalPaid: number;\n currentBalance: number;\n startDate: string;\n endDate: string;\n paymentDueDay: number;\n paidBy: \"Sean\" | \"Yam\";\n isRental: boolean;\n createdAt?: string;\n}\n\nexport interface PaymentRecord {\n id?: number;\n loanId: number;\n month: number; // 1-12\n year: number;\n isPaid: boolean;\n paidBy: \"Sean\" | \"Yam\";\n paidAt?: string;\n}\n\nexport interface Message {\n id?: number;\n author: \"Sean\" | \"Yam\";\n content: string;\n createdAt?: string;\n}\n\nexport const LENDERS = [\n \"Atome\",\n \"Shopee Loan\",\n \"SPayLater\",\n \"GX Bank\",\n \"CIMB\",\n \"PTPTN\",\n \"RHB\",\n \"Public Bank\",\n \"Other\",\n] as const;\n\nexport const LOAN_TYPES = [\n \"Car Loan\",\n \"Personal Loan\",\n \"Student Loan\",\n \"Mobile Loan\",\n \"Buy Now Pay Later\",\n \"Salary Recovery\",\n \"Rental\",\n \"Utility\",\n \"Other\",\n] as const;\n",[],[170,219],["D",1779010592818],[208],[170],"df0525ec-51d3-11f1-8889-ee650bb23af1","index.tsx","019e354b-4058-72f9-b23c-0b897c958766",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[177,231],"df052132-51d3-11f1-8889-ee650bb23af1","index.html","019e354b-4058-72f9-b23c-07070e8c2ee9",["D",1779010584120],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[177,238],"df051d40-51d3-11f1-8889-ee650bb23af1","favicon.svg","019e354b-4058-72f9-b23c-000f0dfe3a0f",["D",1779010584120],"\n",[],[177,245],"df050c92-51d3-11f1-8889-ee650bb23af1","Counter.tsx","019e354b-4058-72f9-b23b-f8b86cf4bd32","019e354b-4058-72f9-b23b-fdf265d1b880",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[177,259,252],"components","df04fb1c-51d3-11f1-8889-ee650bb23af1","App.tsx","019e354b-4058-72f9-b23b-f4f7aea91f3e",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[177,259,261],"df05139a-51d3-11f1-8889-ee650bb23af1",["D",1779010584120],[202,203],[177,259],["D",1779010584120],[201,204,205,206],[177],"fd9e4ce0-51d3-11f1-9d75-ee650bb23af1","routes.ts","fd9e4d9e-51d3-11f1-9d75-ee650bb23af1",6,["D",1779010635982],"import { Hono } from \"npm:hono\";\nimport { initDB, sqlite } from \"./db.ts\";\n\nconst api = new Hono();\n\n// Initialize DB on first request\nlet dbReady = false;\napi.use(\"*\", async (_c, next) => {\n if (!dbReady) {\n await initDB();\n dbReady = true;\n }\n await next();\n});\n\n// ── Loans CRUD ──\n\napi.get(\"/loans\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM loans ORDER BY paidBy, name\");\n return c.json(result.rows);\n});\n\napi.post(\"/loans\", async (c) => {\n const loan = await c.req.json();\n const result = await sqlite.execute({\n sql: `INSERT INTO loans (name, lender, lenderOther, loanType, description, principal, interestRate, monthlyPayment, totalPaid, currentBalance, startDate, endDate, paymentDueDay, paidBy, isRental)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n loan.name, loan.lender, loan.lenderOther || \"\", loan.loanType, loan.description || \"\",\n loan.principal, loan.interestRate || 0, loan.monthlyPayment, loan.totalPaid || 0,\n loan.currentBalance, loan.startDate, loan.endDate || \"\", loan.paymentDueDay || 1,\n loan.paidBy, loan.isRental ? 1 : 0,\n ],\n });\n return c.json({ id: result.lastInsertRowid, ...loan }, 201);\n});\n\napi.put(\"/loans/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const loan = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE loans SET name=?, lender=?, lenderOther=?, loanType=?, description=?, principal=?, interestRate=?, monthlyPayment=?, totalPaid=?, currentBalance=?, startDate=?, endDate=?, paymentDueDay=?, paidBy=?, isRental=? WHERE id=?`,\n args: [\n loan.name, loan.lender, loan.lenderOther || \"\", loan.loanType, loan.description || \"\",\n loan.principal, loan.interestRate || 0, loan.monthlyPayment, loan.totalPaid || 0,\n loan.currentBalance, loan.startDate, loan.endDate || \"\", loan.paymentDueDay || 1,\n loan.paidBy, loan.isRental ? 1 : 0, Number(id),\n ],\n });\n return c.json({ id: Number(id), ...loan });\n});\n\napi.delete(\"/loans/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.batch([\n { sql: \"DELETE FROM payment_records WHERE loanId = ?\", args: [Number(id)] },\n { sql: \"DELETE FROM loans WHERE id = ?\", args: [Number(id)] },\n ]);\n return c.json({ ok: true });\n});\n\n// ── Payment Records ──\n\napi.get(\"/payments/:loanId\", async (c) => {\n const loanId = c.req.param(\"loanId\");\n const result = await sqlite.execute({\n sql: \"SELECT * FROM payment_records WHERE loanId = ? ORDER BY year, month\",\n args: [Number(loanId)],\n });\n return c.json(result.rows);\n});\n\napi.post(\"/payments/toggle\", async (c) => {\n const { loanId, month, year, isPaid, paidBy } = await c.req.json();\n\n if (isPaid) {\n await sqlite.execute({\n sql: `INSERT INTO payment_records (loanId, month, year, isPaid, paidBy, paidAt)\n VALUES (?, ?, ?, 1, ?, datetime('now'))\n ON CONFLICT(loanId, month, year) DO UPDATE SET isPaid=1, paidBy=?, paidAt=datetime('now')`,\n args: [loanId, month, year, paidBy, paidBy],\n });\n // Reduce balance\n const loan = await sqlite.execute({ sql: \"SELECT * FROM loans WHERE id = ?\", args: [loanId] });\n if (loan.rows.length > 0) {\n const l = loan.rows[0] as any;\n const newBalance = Math.max(0, l.currentBalance - l.monthlyPayment);\n const newTotalPaid = l.totalPaid + l.monthlyPayment;\n await sqlite.execute({\n sql: \"UPDATE loans SET currentBalance = ?, totalPaid = ? WHERE id = ?\",\n args: [newBalance, newTotalPaid, loanId],\n });\n }\n } else {\n // Check if record exists and was paid\n const existing = await sqlite.execute({\n sql: \"SELECT * FROM payment_records WHERE loanId = ? AND month = ? AND year = ?\",\n args: [loanId, month, year],\n });\n if (existing.rows.length > 0 && (existing.rows[0] as any).isPaid) {\n await sqlite.execute({\n sql: \"UPDATE payment_records SET isPaid = 0, paidAt = NULL WHERE loanId = ? AND month = ? AND year = ?\",\n args: [loanId, month, year],\n });\n // Restore balance\n const loan = await sqlite.execute({ sql: \"SELECT * FROM loans WHERE id = ?\", args: [loanId] });\n if (loan.rows.length > 0) {\n const l = loan.rows[0] as any;\n const newBalance = l.currentBalance + l.monthlyPayment;\n const newTotalPaid = Math.max(0, l.totalPaid - l.monthlyPayment);\n await sqlite.execute({\n sql: \"UPDATE loans SET currentBalance = ?, totalPaid = ? WHERE id = ?\",\n args: [newBalance, newTotalPaid, loanId],\n });\n }\n }\n }\n return c.json({ ok: true });\n});\n\napi.get(\"/payments/all/list\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM payment_records ORDER BY year, month\");\n return c.json(result.rows);\n});\n\n// ── Messages ──\n\napi.get(\"/messages\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM messages ORDER BY createdAt DESC LIMIT 50\");\n return c.json(result.rows);\n});\n\napi.post(\"/messages\", async (c) => {\n const msg = await c.req.json();\n const result = await sqlite.execute({\n sql: \"INSERT INTO messages (author, content) VALUES (?, ?)\",\n args: [msg.author, msg.content],\n });\n return c.json({ id: result.lastInsertRowid, ...msg }, 201);\n});\n\n// ── Dashboard Stats ──\n\napi.get(\"/stats\", async (c) => {\n const loans = await sqlite.execute(\"SELECT * FROM loans ORDER BY paidBy, name\");\n const payments = await sqlite.execute(\"SELECT * FROM payment_records\");\n return c.json({\n loans: loans.rows,\n payments: payments.rows,\n });\n});\n\nexport default api;\n",[],[182,275],"f0a0bc9e-51d3-11f1-9c7f-ee650bb23af1","db.ts","f0a0bd66-51d3-11f1-9c7f-ee650bb23af1",5,["D",1779010614208],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS loans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n lender TEXT NOT NULL,\n lenderOther TEXT DEFAULT '',\n loanType TEXT NOT NULL,\n description TEXT DEFAULT '',\n principal REAL NOT NULL,\n interestRate REAL DEFAULT 0,\n monthlyPayment REAL NOT NULL,\n totalPaid REAL DEFAULT 0,\n currentBalance REAL NOT NULL,\n startDate TEXT NOT NULL,\n endDate TEXT DEFAULT '',\n paymentDueDay INTEGER DEFAULT 1,\n paidBy TEXT NOT NULL DEFAULT 'Sean',\n isRental INTEGER DEFAULT 0,\n createdAt TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS payment_records (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n loanId INTEGER NOT NULL,\n month INTEGER NOT NULL,\n year INTEGER NOT NULL,\n isPaid INTEGER DEFAULT 0,\n paidBy TEXT NOT NULL DEFAULT 'Sean',\n paidAt TEXT,\n FOREIGN KEY (loanId) REFERENCES loans(id) ON DELETE CASCADE,\n UNIQUE(loanId, month, year)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n author TEXT NOT NULL,\n content TEXT NOT NULL,\n createdAt TEXT DEFAULT (datetime('now'))\n )`,\n },\n ]);\n}\n\nexport { sqlite };\n",[],[182,283],["D",1779010592837],[198,199],[182],["D",1779010584120],["D",1789555877593],{"_109":108,"_116":111},{"_109":108,"_110":111,"_112":111,"_19":61,"_113":114,"_115":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":98,"_99":100,"_101":56,"_102":103,"_104":105,"_106":51,"_107":108},"ctx",{"_87":-5,"_137":331,"_332":333,"_334":335,"_336":31,"_337":31,"_338":31,"_339":64,"_340":-5,"_341":-7,"_342":-7,"_343":68,"_344":31,"_345":31,"_346":-5,"_347":31,"_348":31,"_349":31,"_350":-5},"ENV",{"_302":303,"_304":305,"_306":95,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330},"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"]

Diff · v7