CashStash - Gen Z Budgeting App

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_278":279,"_280":281},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/App.tsx","latestPath","fileId","9334a01c-3333-11f0-a2ac-9e149126039e","name","App.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Envelope, Transaction, Achievement } from \"../../shared/types.ts\";\nimport Onboarding from \"./Onboarding.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport CSVImport from \"./CSVImport.tsx\";\nimport AchievementNotification from \"./AchievementNotification.tsx\";\n\nconst API_BASE_URL = \"/api\";\n\nconst App: React.FC = () => {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n const [showImport, setShowImport] = useState(false);\n const [newAchievement, setNewAchievement] = useState(null);\n \n // Check for user in localStorage on initial load\n useEffect(() => {\n const userId = localStorage.getItem(\"cashStashUserId\");\n if (userId) {\n fetchUser(userId);\n } else {\n setLoading(false);\n }\n }, []);\n \n // Watch for new achievements\n useEffect(() => {\n if (user && user.achievements) {\n const unlockedToday = user.achievements.find(a => {\n if (!a.unlocked || !a.unlockedDate) return false;\n const unlockDate = new Date(a.unlockedDate).toDateString();\n const today = new Date().toDateString();\n return unlockDate === today;\n });\n \n if (unlockedToday && !newAchievement) {\n setNewAchievement(unlockedToday);\n // Clear notification after 5 seconds\n setTimeout(() => setNewAchievement(null), 5000);\n }\n }\n }, [user]);\n \n const fetchUser = async (userId: string) => {\n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users/${userId}`);\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch user\");\n }\n \n const userData = await response.json();\n setUser(userData);\n localStorage.setItem(\"cashStashUserId\", userId);\n } catch (error) {\n console.error(\"Error fetching user:\", error);\n localStorage.removeItem(\"cashStashUserId\");\n } finally {\n setLoading(false);\n }\n };\n \n const createUser = async (name: string) => {\n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ name }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to create user\");\n }\n \n const userData = await response.json();\n setUser(userData);\n localStorage.setItem(\"cashStashUserId\", userData.id);\n } catch (error) {\n console.error(\"Error creating user:\", error);\n } finally {\n setLoading(false);\n }\n };\n \n const createEnvelope = async (name: string, icon: string, color: string, budget: number) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/envelopes`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ name, icon, color, budget }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to create envelope\");\n }\n \n // Refresh user data\n fetchUser(user.id);\n } catch (error) {\n console.error(\"Error creating envelope:\", error);\n }\n };\n \n const allocateMoney = async (envelopeId: string, amount: number) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/envelopes/${envelopeId}/allocate`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ amount }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to allocate money\");\n }\n \n const updatedUser = await response.json();\n setUser(updatedUser);\n } catch (error) {\n console.error(\"Error allocating money:\", error);\n }\n };\n \n const importTransactions = async (csvContent: string, mapping: any) => {\n if (!user) return;\n \n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/transactions/import`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ csvContent, mapping }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to import transactions\");\n }\n \n const data = await response.json();\n setUser(data.user);\n setShowImport(false);\n } catch (error) {\n console.error(\"Error importing transactions:\", error);\n } finally {\n setLoading(false);\n }\n };\n \n const assignTransaction = async (transactionId: string, envelopeId: string) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/transactions/${transactionId}/assign`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ envelopeId }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to assign transaction\");\n }\n \n const updatedUser = await response.json();\n setUser(updatedUser);\n } catch (error) {\n console.error(\"Error assigning transaction:\", error);\n }\n };\n \n if (loading) {\n return (\n

💰

Loading CashStash...

Counting your money...

\n );\n }\n \n if (!user) {\n return ;\n }\n \n return (\n

\n {newAchievement && (\n \n )}\n \n {showImport ? (\n setShowImport(false)} \n />\n ) : (\n setShowImport(true)}\n onAssignTransaction={assignTransaction}\n />\n )}\n

\n );\n};\n\nexport default App;","createdAt",["D",1747495705444],"branchVersion","branchId","0d1fb8ae-3333-11f0-9f41-9e149126039e",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","602c15ba-76a9-4b69-9abd-cf0195891bfe","components","directory",["D",1747495705444],"id","0d1f68f4-3333-11f0-9f41-9e149126039e","untitled-8939",["D",1747495480497],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","aba6df40-31bf-11f0-ac4e-e3462f58c9c4","pinnedFileId","79f1d980-3333-11f0-9159-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","b516df03-1afb-4b4c-b24c-661c4fbc488b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pmaxx","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4OTJSTExldk5KVEZQd2w4Qm9KVVNuTERuUCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":274,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":275,"_86":276,"_88":277,"_90":25},"tree",[174,181,186,188],"files",[174,175,176,177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_164":68,"_165":140,"_166":68,"_167":168,"_169":170},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":162,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":163},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":156,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":157},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":150,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":151},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":142,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_27":145},"4599a884-3333-11f0-ace2-9e149126039e","README.md","4599a94c-3333-11f0-ace2-9e149126039e","parentId",1,"latest",["D",1747495575248],"# CashStash - Gen Z Cash Stuffing Budget App\n\nA modern, animated budgeting app that makes financial management fun through a digital \"cash stuffing\" approach.\n\n## What is Cash Stuffing?\n\nCash stuffing is a budgeting method where you allocate your income into different categories (envelopes) to control spending. CashStash brings this concept to digital life with animations and game-like elements.\n\n## Features\n\n- 💸 **CSV Bank Import**: Upload your bank statements to automatically import transactions\n- 🎮 **Game-like Interface**: Drag and drop money into different envelopes\n- ✨ **Animated Feedback**: Visual rewards when you save money or stick to your budget\n- 📊 **Budget Tracking**: See where your money is going with intuitive visualizations\n- 🏆 **Achievement System**: Earn badges and rewards for good financial habits\n\n## Tech Stack\n\n- Frontend: React with animations\n- Backend: TypeScript with SQLite storage\n- Data: CSV parsing for bank statements\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/ # SQLite database setup and queries\n│ ├── parsers/ # CSV parsing logic\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/ # React components\n│ ├── animations/ # Animation utilities\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. Upload a CSV bank statement\n2. Create your budget envelopes\n3. Start stuffing cash into your envelopes\n4. Track your spending and saving progress","label",[137],"492bd616-3333-11f0-9a57-9e149126039e","shared","556b8a7e-5d01-45eb-a89a-71bd78dd1081",2,["D",1747495581239],[147],"8137279a-3333-11f0-8460-9e149126039e","frontend","9f01d830-a6a8-41e2-a814-ee483bd68d19",7,["D",1747495675266],[153],"50bb0172-3333-11f0-bd48-9e149126039e","backend","528cc487-fcec-4277-b618-4026997f6154",3,["D",1747495593922],[159],"pulls","branches","forks","envVars",{"_171":68,"_173":68},"connections",{"_171":68,"_172":68},"count","unfilledCount","emptyCount",{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":271,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":272,"_27":273},{"_49":267,"_32":259,"_30":253,"_139":160,"_41":42,"_40":161,"_141":64,"_38":268,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":269,"_27":270},{"_49":260,"_32":261,"_30":262,"_139":253,"_41":42,"_40":161,"_141":64,"_38":263,"_13":68,"_34":35,"_36":264,"_24":25,"_144":-5,"_190":265,"_27":266},{"_49":250,"_32":251,"_30":252,"_139":253,"_41":42,"_40":254,"_141":64,"_38":255,"_13":68,"_34":35,"_36":256,"_24":25,"_144":-5,"_190":257,"_27":258},{"_49":246,"_32":245,"_30":239,"_139":160,"_41":42,"_40":240,"_141":64,"_38":247,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":248,"_27":249},{"_49":236,"_32":237,"_30":238,"_139":239,"_41":42,"_40":240,"_141":64,"_38":241,"_13":68,"_34":35,"_36":242,"_24":25,"_144":-5,"_190":243,"_27":244},{"_49":229,"_32":230,"_30":62,"_139":160,"_41":42,"_40":231,"_141":25,"_38":232,"_13":68,"_34":35,"_36":233,"_24":25,"_144":-5,"_190":234,"_27":235},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":226,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":227,"_27":228},{"_49":222,"_32":46,"_30":45,"_139":154,"_41":42,"_40":14,"_141":64,"_38":223,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":224,"_27":225},{"_49":218,"_32":33,"_30":31,"_139":45,"_41":42,"_40":14,"_141":64,"_38":219,"_13":68,"_34":35,"_36":37,"_24":25,"_144":-5,"_190":220,"_27":221},{"_49":211,"_32":212,"_30":213,"_139":154,"_41":42,"_40":155,"_141":64,"_38":214,"_13":68,"_34":21,"_36":215,"_24":25,"_144":-5,"_190":216,"_27":217},{"_49":203,"_32":204,"_30":205,"_139":154,"_41":42,"_40":206,"_141":64,"_38":207,"_13":68,"_34":35,"_36":208,"_24":25,"_144":-5,"_190":209,"_27":210},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":200,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":201,"_27":202},{"_49":193,"_32":194,"_30":195,"_139":148,"_41":42,"_40":149,"_141":64,"_38":196,"_13":68,"_34":35,"_36":197,"_24":25,"_144":-5,"_190":198,"_27":199},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":189,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_190":191,"_27":192},["D",1747495575248],"children",[],[137],"492bcfe0-3333-11f0-9a57-9e149126039e","types.ts","492bd09e-3333-11f0-9a57-9e149126039e",["D",1747495581239],"// Shared types for both frontend and backend\n\nexport interface Transaction {\n id: string;\n date: string;\n description: string;\n amount: number;\n category?: string;\n processed: boolean;\n}\n\nexport interface Envelope {\n id: string;\n name: string;\n icon: string;\n color: string;\n budget: number;\n current: number;\n}\n\nexport interface User {\n id: string;\n name: string;\n totalBalance: number;\n unallocated: number;\n envelopes: Envelope[];\n transactions: Transaction[];\n achievements: Achievement[];\n}\n\nexport interface Achievement {\n id: string;\n name: string;\n description: string;\n icon: string;\n unlocked: boolean;\n unlockedDate?: string;\n}\n\nexport interface CSVParseResult {\n success: boolean;\n transactions?: Transaction[];\n error?: string;\n}\n\n// CSV mapping configuration\nexport interface CSVMapping {\n date: string;\n description: string;\n amount: string;\n type?: string; // debit/credit indicator column if needed\n balance?: string;\n}",[],[147,194],["D",1747495581239],[187],[147],"83e89f14-3333-11f0-b638-9e149126039e","index.tsx","83e89fbe-3333-11f0-b638-9e149126039e",8,["D",1747495679785],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"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\n// Create a root\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) throw new Error(\"Root element not found\");\n\nconst root = createRoot(rootElement);\nroot.render();",[],[153,204],"81371d2c-3333-11f0-8460-9e149126039e","index.html","81371dfe-3333-11f0-8460-9e149126039e",["D",1747495675266],"\n\n\n \n \n CashStash - Gen Z Budgeting App\n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n",[],[153,212],"93349f86-3333-11f0-a2ac-9e149126039e",["D",1747495705444],[],[153,46,33],"9334ae5e-3333-11f0-a2ac-9e149126039e",["D",1747495705444],[183],[153,46],["D",1747495675266],[182,184,185],[153],"79f1d8d6-3333-11f0-9159-9e149126039e","index.ts",6,["D",1747495663069],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { setupDatabase } from \"./database/migrations.ts\";\nimport { \n createUser, \n getUserById, \n createEnvelope, \n updateEnvelopeAmount,\n addTransactions,\n assignTransactionToEnvelope,\n checkFullAllocation\n} from \"./database/queries.ts\";\nimport { parseCSV } from \"./parsers/csv-parser.ts\";\nimport type { CSVMapping } from \"../shared/types.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Enable CORS\napp.use(\"/*\", cors());\n\n// Initialize database on startup\napp.use(\"*\", async (c, next) => {\n await setupDatabase();\n await next();\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html for root path\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// API Routes\nconst api = new Hono();\n\n// User endpoints\napi.post(\"/users\", async c => {\n const { name } = await c.req.json();\n \n if (!name) {\n return c.json({ error: \"Name is required\" }, 400);\n }\n \n const user = await createUser(name);\n return c.json(user);\n});\n\napi.get(\"/users/:id\", async c => {\n const userId = c.req.param(\"id\");\n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n return c.json(user);\n});\n\n// Envelope endpoints\napi.post(\"/users/:userId/envelopes\", async c => {\n const userId = c.req.param(\"userId\");\n const { name, icon, color, budget } = await c.req.json();\n \n if (!name || !icon || !color) {\n return c.json({ error: \"Name, icon, and color are required\" }, 400);\n }\n \n const envelope = await createEnvelope(userId, name, icon, color, budget || 0);\n return c.json(envelope);\n});\n\napi.put(\"/users/:userId/envelopes/:envelopeId/allocate\", async c => {\n const userId = c.req.param(\"userId\");\n const envelopeId = c.req.param(\"envelopeId\");\n const { amount } = await c.req.json();\n \n if (typeof amount !== \"number\") {\n return c.json({ error: \"Amount must be a number\" }, 400);\n }\n \n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n const envelope = user.envelopes.find(e => e.id === envelopeId);\n \n if (!envelope) {\n return c.json({ error: \"Envelope not found\" }, 404);\n }\n \n // Calculate new amounts\n const newEnvelopeAmount = envelope.current + amount;\n const newUnallocated = user.unallocated - amount;\n \n if (newUnallocated < 0) {\n return c.json({ error: \"Not enough unallocated funds\" }, 400);\n }\n \n // Update envelope amount\n await updateEnvelopeAmount(envelopeId, newEnvelopeAmount);\n \n // Update user's unallocated amount\n await updateUserBalance(userId, user.totalBalance, newUnallocated);\n \n // Check if all money is now allocated\n await checkFullAllocation(userId);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json(updatedUser);\n});\n\n// Transaction endpoints\napi.post(\"/users/:userId/transactions/import\", async c => {\n const userId = c.req.param(\"userId\");\n const { csvContent, mapping } = await c.req.json();\n \n if (!csvContent || !mapping) {\n return c.json({ error: \"CSV content and mapping are required\" }, 400);\n }\n \n const parseResult = parseCSV(csvContent, mapping as CSVMapping);\n \n if (!parseResult.success) {\n return c.json({ error: parseResult.error }, 400);\n }\n \n const transactions = await addTransactions(userId, parseResult.transactions!);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json({\n transactions,\n user: updatedUser\n });\n});\n\napi.put(\"/users/:userId/transactions/:transactionId/assign\", async c => {\n const userId = c.req.param(\"userId\");\n const transactionId = c.req.param(\"transactionId\");\n const { envelopeId } = await c.req.json();\n \n if (!envelopeId) {\n return c.json({ error: \"Envelope ID is required\" }, 400);\n }\n \n await assignTransactionToEnvelope(transactionId, envelopeId);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json(updatedUser);\n});\n\n// Mount API routes\napp.route(\"/api\", api);\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[159,230],"6c6a77a4-3333-11f0-bdd9-9e149126039e","csv-parser.ts","6c6a789e-3333-11f0-bdd9-9e149126039e","ec6a724f-8379-4725-a91f-7b9a0aa137a8",5,["D",1747495640370],"import type { Transaction, CSVMapping, CSVParseResult } from \"../../shared/types.ts\";\n\n/**\n * Parse a CSV bank statement into transactions\n * \n * @param csvContent The raw CSV content as a string\n * @param mapping Configuration for mapping CSV columns to transaction fields\n * @returns Parsed transactions or error\n */\nexport function parseCSV(csvContent: string, mapping: CSVMapping): CSVParseResult {\n try {\n // Split the CSV into lines\n const lines = csvContent.split(/\\r?\\n/).filter(line => line.trim() !== \"\");\n \n if (lines.length < 2) {\n return { \n success: false, \n error: \"CSV file must contain a header row and at least one data row\" \n };\n }\n \n // Extract header row and find column indices\n const headers = parseCSVRow(lines[0]);\n const dateIndex = headers.indexOf(mapping.date);\n const descriptionIndex = headers.indexOf(mapping.description);\n const amountIndex = headers.indexOf(mapping.amount);\n const typeIndex = mapping.type ? headers.indexOf(mapping.type) : -1;\n \n // Validate required columns exist\n if (dateIndex === -1 || descriptionIndex === -1 || amountIndex === -1) {\n return { \n success: false, \n error: \"Required columns not found in CSV. Please check your mapping configuration.\" \n };\n }\n \n // Parse data rows\n const transactions: Transaction[] = [];\n \n for (let i = 1; i < lines.length; i++) {\n const row = parseCSVRow(lines[i]);\n \n if (row.length <= Math.max(dateIndex, descriptionIndex, amountIndex)) {\n continue; // Skip rows that don't have enough columns\n }\n \n let amount = parseFloat(row[amountIndex].replace(/[^\\d.-]/g, \"\"));\n \n // Handle debit/credit indicator if present\n if (typeIndex !== -1) {\n const type = row[typeIndex].toLowerCase();\n if (type.includes(\"debit\") || type.includes(\"withdrawal\") || type.includes(\"payment\")) {\n amount = -Math.abs(amount);\n }\n }\n \n // Skip rows with invalid amounts\n if (isNaN(amount)) {\n continue;\n }\n \n transactions.push({\n id: crypto.randomUUID(),\n date: formatDate(row[dateIndex]),\n description: row[descriptionIndex],\n amount,\n processed: false\n });\n }\n \n if (transactions.length === 0) {\n return { \n success: false, \n error: \"No valid transactions found in the CSV file\" \n };\n }\n \n return {\n success: true,\n transactions\n };\n \n } catch (error) {\n return {\n success: false,\n error: `Failed to parse CSV: ${error.message}`\n };\n }\n}\n\n/**\n * Parse a CSV row into an array of values, handling quoted values correctly\n */\nfunction parseCSVRow(row: string): string[] {\n const result: string[] = [];\n let current = \"\";\n let inQuotes = false;\n \n for (let i = 0; i < row.length; i++) {\n const char = row[i];\n \n if (char === '\"') {\n // Toggle quote state\n inQuotes = !inQuotes;\n } else if (char === ',' && !inQuotes) {\n // End of field\n result.push(current);\n current = \"\";\n } else {\n current += char;\n }\n }\n \n // Add the last field\n result.push(current);\n \n return result;\n}\n\n/**\n * Try to format a date string into a consistent format (YYYY-MM-DD)\n */\nfunction formatDate(dateStr: string): string {\n // Try to parse the date\n const date = new Date(dateStr);\n \n if (!isNaN(date.getTime())) {\n return date.toISOString().split('T')[0];\n }\n \n // If standard parsing fails, try common formats\n // MM/DD/YYYY\n const mmddyyyy = /(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})/.exec(dateStr);\n if (mmddyyyy) {\n const [_, month, day, year] = mmddyyyy;\n return `${year}-${month.padStart(2, '0')}-${day.padStart(2, '0')}`;\n }\n \n // DD/MM/YYYY\n const ddmmyyyy = /(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})/.exec(dateStr);\n if (ddmmyyyy) {\n const [_, day, month, year] = ddmmyyyy;\n return `${year}-${month.padStart(2, '0')}-${day.padStart(2, '0')}`;\n }\n \n // Return original if we can't parse it\n return dateStr;\n}",[],[159,245,237],"parsers","6c6a8ba4-3333-11f0-bdd9-9e149126039e",["D",1747495640370],[179],[159,245],"6156eb54-3333-11f0-9159-9e149126039e","queries.ts","6156ec1c-3333-11f0-9159-9e149126039e","46d8a173-1fde-43f0-a791-9483ac3b7f95",4,["D",1747495621787],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { \n USERS_TABLE, \n ENVELOPES_TABLE, \n TRANSACTIONS_TABLE, \n ACHIEVEMENTS_TABLE \n} from \"./migrations.ts\";\nimport type { User, Envelope, Transaction, Achievement } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(name: string): Promise {\n const userId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, name, total_balance, unallocated) VALUES (?, ?, 0, 0)`,\n [userId, name]\n );\n \n // Create default achievements for the user\n const defaultAchievements = [\n {\n id: \"first_budget\",\n name: \"Budget Beginner\",\n description: \"Created your first budget envelope\",\n icon: \"🏆\"\n },\n {\n id: \"full_allocation\",\n name: \"Money Master\",\n description: \"Allocated 100% of your money to envelopes\",\n icon: \"💰\"\n },\n {\n id: \"saving_streak\",\n name: \"Saving Superstar\",\n description: \"Saved money for 3 weeks in a row\",\n icon: \"⭐\"\n },\n {\n id: \"csv_import\",\n name: \"Data Wizard\",\n description: \"Successfully imported your first bank statement\",\n icon: \"📊\"\n }\n ];\n \n for (const achievement of defaultAchievements) {\n await sqlite.execute(\n `INSERT INTO ${ACHIEVEMENTS_TABLE} (id, user_id, name, description, icon, unlocked) \n VALUES (?, ?, ?, ?, ?, 0)`,\n [achievement.id, userId, achievement.name, achievement.description, achievement.icon]\n );\n }\n \n return getUserById(userId);\n}\n\nexport async function getUserById(userId: string): Promise {\n const userResult = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE id = ?`,\n [userId]\n );\n \n if (userResult.rows.length === 0) {\n return null;\n }\n \n const user = userResult.rows[0];\n \n // Get envelopes\n const envelopes = await getEnvelopesByUserId(userId);\n \n // Get transactions\n const transactions = await getTransactionsByUserId(userId);\n \n // Get achievements\n const achievements = await getAchievementsByUserId(userId);\n \n return {\n id: user.id,\n name: user.name,\n totalBalance: user.total_balance,\n unallocated: user.unallocated,\n envelopes,\n transactions,\n achievements\n };\n}\n\nexport async function updateUserBalance(userId: string, totalBalance: number, unallocated: number): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET total_balance = ?, unallocated = ? WHERE id = ?`,\n [totalBalance, unallocated, userId]\n );\n}\n\n// Envelope queries\nexport async function createEnvelope(\n userId: string, \n name: string, \n icon: string, \n color: string, \n budget: number = 0\n): Promise {\n const envelopeId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ENVELOPES_TABLE} (id, user_id, name, icon, color, budget, current) \n VALUES (?, ?, ?, ?, ?, ?, 0)`,\n [envelopeId, userId, name, icon, color, budget]\n );\n \n // Check for first budget achievement\n await checkAndUnlockAchievement(userId, \"first_budget\");\n \n return {\n id: envelopeId,\n name,\n icon,\n color,\n budget,\n current: 0\n };\n}\n\nexport async function getEnvelopesByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ENVELOPES_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n name: row.name,\n icon: row.icon,\n color: row.color,\n budget: row.budget,\n current: row.current\n }));\n}\n\nexport async function updateEnvelopeAmount(envelopeId: string, amount: number): Promise {\n await sqlite.execute(\n `UPDATE ${ENVELOPES_TABLE} SET current = ? WHERE id = ?`,\n [amount, envelopeId]\n );\n}\n\n// Transaction queries\nexport async function addTransactions(\n userId: string, \n transactions: Omit[]\n): Promise {\n const createdTransactions: Transaction[] = [];\n \n for (const transaction of transactions) {\n const transactionId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (id, user_id, date, description, amount, category, processed) \n VALUES (?, ?, ?, ?, ?, ?, 0)`,\n [transactionId, userId, transaction.date, transaction.description, transaction.amount, transaction.category || null]\n );\n \n createdTransactions.push({\n id: transactionId,\n date: transaction.date,\n description: transaction.description,\n amount: transaction.amount,\n category: transaction.category,\n processed: false\n });\n }\n \n // Check for CSV import achievement\n if (createdTransactions.length > 0) {\n await checkAndUnlockAchievement(userId, \"csv_import\");\n }\n \n // Update user's total balance\n const totalAmount = transactions.reduce((sum, t) => sum + t.amount, 0);\n const user = await getUserById(userId);\n \n if (user) {\n const newTotal = user.totalBalance + totalAmount;\n const newUnallocated = user.unallocated + totalAmount;\n await updateUserBalance(userId, newTotal, newUnallocated);\n }\n \n return createdTransactions;\n}\n\nexport async function getTransactionsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE user_id = ? ORDER BY date DESC`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n date: row.date,\n description: row.description,\n amount: row.amount,\n category: row.category,\n processed: Boolean(row.processed)\n }));\n}\n\nexport async function assignTransactionToEnvelope(\n transactionId: string, \n envelopeId: string\n): Promise {\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS_TABLE} SET envelope_id = ?, processed = 1 WHERE id = ?`,\n [envelopeId, transactionId]\n );\n}\n\n// Achievement queries\nexport async function getAchievementsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ACHIEVEMENTS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n icon: row.icon,\n unlocked: Boolean(row.unlocked),\n unlockedDate: row.unlocked_date\n }));\n}\n\nexport async function checkAndUnlockAchievement(userId: string, achievementId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ACHIEVEMENTS_TABLE} WHERE user_id = ? AND id = ?`,\n [userId, achievementId]\n );\n \n if (result.rows.length === 0 || result.rows[0].unlocked) {\n return false;\n }\n \n await sqlite.execute(\n `UPDATE ${ACHIEVEMENTS_TABLE} SET unlocked = 1, unlocked_date = CURRENT_TIMESTAMP WHERE user_id = ? AND id = ?`,\n [userId, achievementId]\n );\n \n return true;\n}\n\n// Check if all money is allocated (for achievement)\nexport async function checkFullAllocation(userId: string): Promise {\n const user = await getUserById(userId);\n \n if (user && user.unallocated === 0 && user.totalBalance > 0) {\n await checkAndUnlockAchievement(userId, \"full_allocation\");\n }\n}",[],[159,259,251],"database","50baf5f6-3333-11f0-bd48-9e149126039e","migrations.ts","50baf6be-3333-11f0-bd48-9e149126039e",["D",1747495593922],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const USERS_TABLE = \"cash_stash_users\";\nexport const ENVELOPES_TABLE = \"cash_stash_envelopes\";\nexport const TRANSACTIONS_TABLE = \"cash_stash_transactions\";\nexport const ACHIEVEMENTS_TABLE = \"cash_stash_achievements\";\n\nexport async function setupDatabase() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n total_balance REAL DEFAULT 0,\n unallocated REAL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create envelopes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ENVELOPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n icon TEXT NOT NULL,\n color TEXT NOT NULL,\n budget REAL DEFAULT 0,\n current REAL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Create transactions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n date TEXT NOT NULL,\n description TEXT NOT NULL,\n amount REAL NOT NULL,\n category TEXT,\n envelope_id TEXT,\n processed INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n FOREIGN KEY (envelope_id) REFERENCES ${ENVELOPES_TABLE}(id)\n )\n `);\n\n // Create achievements table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ACHIEVEMENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n icon TEXT NOT NULL,\n unlocked INTEGER DEFAULT 0,\n unlocked_date TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Create default achievements\n await createDefaultAchievements();\n}\n\nasync function createDefaultAchievements() {\n const defaultAchievements = [\n {\n id: \"first_budget\",\n name: \"Budget Beginner\",\n description: \"Created your first budget envelope\",\n icon: \"🏆\"\n },\n {\n id: \"full_allocation\",\n name: \"Money Master\",\n description: \"Allocated 100% of your money to envelopes\",\n icon: \"💰\"\n },\n {\n id: \"saving_streak\",\n name: \"Saving Superstar\",\n description: \"Saved money for 3 weeks in a row\",\n icon: \"⭐\"\n },\n {\n id: \"csv_import\",\n name: \"Data Wizard\",\n description: \"Successfully imported your first bank statement\",\n icon: \"📊\"\n }\n ];\n \n // We don't insert these directly as they need to be associated with users\n // They'll be created when a new user is created\n}",[],[159,259,261],"50bb03ac-3333-11f0-bd48-9e149126039e",["D",1747495593922],[176,177],[159,259],["D",1747495593922],[175,178,180],[159],["D",1747495480497],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":311,"_312":313,"_314":315,"_316":25,"_317":25,"_318":25,"_319":64,"_320":-5,"_321":-7,"_322":-7,"_323":68,"_324":25,"_325":25,"_326":-5,"_327":25,"_328":25,"_329":25,"_330":-5},"ENV",{"_282":283,"_284":285,"_286":92,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v9