Mental Health Support App

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_272":273,"_274":275},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","2eee9620-0ce7-41aa-86e8-9f559adea0fa","name","fileType","directory","content","createdAt",["D",1748846718415],"branchVersion","branchId","f5071206-3f78-11f0-8d1f-76b3cceeab13",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/index.html","25afbd14-3f7d-11f0-9bea-76b3cceeab13","index.html","\n\n\n \n \n Mental Health Support App\n \n \n 🧠\">\n \n\n\n

\n \n \n\n",["D",1748846718415],"id","f506caa8-3f78-11f0-8d1f-76b3cceeab13","Mind_clinic",["D",1748844918795],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","23880fb0-3f6d-11f0-ad5b-814c56c8abb0","pinnedFileId","1e62cfce-3f7d-11f0-9f28-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","21dd7603-e0af-4a3c-ab51-cd4e608930d0","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","andym42","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdDUUdSUEk1NDFVNjZBeFlwbUFua3RsNmQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":268,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":269,"_84":270,"_86":271,"_88":25},"tree",[177,185,187,189,190],"files",[177,178,179,180,181,182,183,184,185,186,187,188,189,190],"counts",{"_167":66,"_168":139,"_169":66,"_170":171,"_172":173},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":161,"_32":162,"_30":163,"_138":-5,"_39":40,"_38":164,"_140":62,"_36":165,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_27":166},{"_47":158,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":62,"_36":159,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_27":160},{"_47":152,"_32":153,"_30":154,"_138":-5,"_39":40,"_38":155,"_140":62,"_36":156,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_27":157},{"_47":145,"_32":146,"_30":147,"_138":-5,"_39":40,"_38":148,"_140":62,"_36":149,"_13":66,"_33":21,"_35":150,"_24":25,"_143":-5,"_27":151},{"_47":135,"_32":136,"_30":137,"_138":-5,"_39":40,"_38":139,"_140":62,"_36":141,"_13":66,"_33":142,"_35":109,"_24":25,"_143":-5,"_27":144},"f508dd84-3f78-11f0-8d1f-76b3cceeab13","main.tsx","f508de10-3f78-11f0-8d1f-76b3cceeab13","parentId",1,"latest",["D",1748844918805],"script","label",[136],"e2f085da-3f7c-11f0-8786-76b3cceeab13","README.md","e2f086a2-3f7c-11f0-8786-76b3cceeab13",2,["D",1748846606334],"# Mental Health Support App\n\nA comprehensive web application designed to support individuals with their mental health journey through various tools and resources.\n\n## Features\n\n- **Mood Tracking**: Daily mood logging with visual charts\n- **Journaling**: Private journaling with prompts and reflection\n- **Breathing Exercises**: Guided breathing techniques for anxiety and stress\n- **Resources**: Curated mental health resources and crisis support\n- **Progress Tracking**: Visual representation of mood patterns over time\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── mood.ts # Mood tracking endpoints\n│ │ ├── journal.ts # Journal entry endpoints\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── MoodTracker.tsx # Mood tracking interface\n│ │ ├── Journal.tsx # Journaling interface\n│ │ ├── BreathingExercise.tsx # Breathing exercise guide\n│ │ └── Resources.tsx # Mental health resources\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Technology Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Frontend**: React with TypeScript\n- **Database**: SQLite for data persistence\n- **Styling**: TailwindCSS\n- **Charts**: Chart.js for mood visualization\n\n## Getting Started\n\nThis app is designed to run on Val Town. The backend serves both API endpoints and the frontend application.\n\n## Privacy & Security\n\n- All data is stored locally in your Val Town instance\n- No personal data is shared with third parties\n- Journal entries and mood data remain private",[146],"e797150e-3f7c-11f0-9baa-76b3cceeab13","shared","67357349-4169-4d52-b15b-b0d4757c5751",3,["D",1748846614234],[153],"25afc372-3f7d-11f0-9bea-76b3cceeab13",["D",1748846718415],[28],"ec6a7eae-3f7c-11f0-8c0e-76b3cceeab13","backend","3989d51f-22d4-499c-be0c-5a1d262bd617",4,["D",1748846622331],[162],"pulls","branches","forks","envVars",{"_174":66,"_176":66},"connections",{"_174":66,"_175":66},"count","unfilledCount","emptyCount",{"_47":161,"_32":162,"_30":163,"_138":-5,"_39":40,"_38":164,"_140":62,"_36":265,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_192":266,"_27":267},{"_47":261,"_32":253,"_30":247,"_138":163,"_39":40,"_38":164,"_140":62,"_36":262,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_192":263,"_27":264},{"_47":254,"_32":255,"_30":256,"_138":247,"_39":40,"_38":164,"_140":62,"_36":257,"_13":66,"_33":142,"_35":258,"_24":25,"_143":-5,"_192":259,"_27":260},{"_47":244,"_32":245,"_30":246,"_138":247,"_39":40,"_38":248,"_140":62,"_36":249,"_13":66,"_33":142,"_35":250,"_24":25,"_143":-5,"_192":251,"_27":252},{"_47":240,"_32":231,"_30":225,"_138":163,"_39":40,"_38":226,"_140":62,"_36":241,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_192":242,"_27":243},{"_47":232,"_32":233,"_30":234,"_138":225,"_39":40,"_38":235,"_140":62,"_36":236,"_13":66,"_33":142,"_35":237,"_24":25,"_143":-5,"_192":238,"_27":239},{"_47":222,"_32":223,"_30":224,"_138":225,"_39":40,"_38":226,"_140":62,"_36":227,"_13":66,"_33":142,"_35":228,"_24":25,"_143":-5,"_192":229,"_27":230},{"_47":215,"_32":216,"_30":60,"_138":163,"_39":40,"_38":217,"_140":25,"_36":218,"_13":66,"_33":142,"_35":219,"_24":25,"_143":-5,"_192":220,"_27":221},{"_47":158,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":62,"_36":212,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_192":213,"_27":214},{"_47":208,"_32":44,"_30":43,"_138":31,"_39":40,"_38":14,"_140":62,"_36":209,"_13":66,"_33":21,"_35":45,"_24":25,"_143":-5,"_192":210,"_27":211},{"_47":152,"_32":153,"_30":154,"_138":-5,"_39":40,"_38":155,"_140":62,"_36":205,"_13":66,"_33":34,"_35":-5,"_24":25,"_143":-5,"_192":206,"_27":207},{"_47":198,"_32":199,"_30":200,"_138":154,"_39":40,"_38":155,"_140":62,"_36":201,"_13":66,"_33":142,"_35":202,"_24":25,"_143":-5,"_192":203,"_27":204},{"_47":145,"_32":146,"_30":147,"_138":-5,"_39":40,"_38":148,"_140":62,"_36":195,"_13":66,"_33":21,"_35":150,"_24":25,"_143":-5,"_192":196,"_27":197},{"_47":135,"_32":136,"_30":137,"_138":-5,"_39":40,"_38":139,"_140":62,"_36":191,"_13":66,"_33":142,"_35":109,"_24":25,"_143":-5,"_192":193,"_27":194},["D",1748844918805],"children",[],[136],["D",1748846606334],[],[146],"e7970c08-3f7c-11f0-9baa-76b3cceeab13","types.ts","e7970d0c-3f7c-11f0-9baa-76b3cceeab13",["D",1748846614234],"// Shared types for the Mental Health Support App\n\nexport interface MoodEntry {\n id?: number;\n date: string;\n mood: number; // 1-10 scale\n energy: number; // 1-10 scale\n anxiety: number; // 1-10 scale\n notes?: string;\n activities?: string[];\n created_at?: string;\n}\n\nexport interface JournalEntry {\n id?: number;\n date: string;\n title: string;\n content: string;\n mood_before?: number;\n mood_after?: number;\n tags?: string[];\n created_at?: string;\n updated_at?: string;\n}\n\nexport interface BreathingExercise {\n id: string;\n name: string;\n description: string;\n duration: number; // in seconds\n inhale: number;\n hold: number;\n exhale: number;\n cycles: number;\n}\n\nexport interface MentalHealthResource {\n id: string;\n title: string;\n description: string;\n url: string;\n category: 'crisis' | 'therapy' | 'self-help' | 'education' | 'support-groups';\n isEmergency?: boolean;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\nexport interface MoodStats {\n averageMood: number;\n averageEnergy: number;\n averageAnxiety: number;\n totalEntries: number;\n streak: number;\n lastEntry?: string;\n}",[],[153,199],["D",1748846614234],[188],[153],"25afbc56-3f7d-11f0-9bea-76b3cceeab13",["D",1748846718415],[],[28,44],["D",1748846718415],[186],[28],"1e62cf2e-3f7d-11f0-9f28-76b3cceeab13","index.ts",8,["D",1748846706166],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { getMoodStats, getRecentMoodEntries, getRecentJournalEntries } from \"./database/queries.ts\";\nimport moodRoutes from \"./routes/mood.ts\";\nimport journalRoutes from \"./routes/journal.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// Initialize database on startup\nawait runMigrations();\n\n// API Routes\napp.route(\"/api/mood\", moodRoutes);\napp.route(\"/api/journal\", journalRoutes);\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 main application with initial data\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Fetch initial data to avoid extra round-trips\n const [moodStats, recentMoods, recentJournals] = await Promise.all([\n getMoodStats().catch(() => null),\n getRecentMoodEntries(7).catch(() => []),\n getRecentJournalEntries(5).catch(() => [])\n ]);\n\n const initialData = {\n moodStats,\n recentMoods,\n recentJournals\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// Health check endpoint\napp.get(\"/health\", c => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\nexport default app;",[],[162,216],"0a40f552-3f7d-11f0-8525-76b3cceeab13","mood.ts","0a40f624-3f7d-11f0-8525-76b3cceeab13","2fbe3adb-a9a5-4ed4-83fe-145d293db846",6,["D",1748846672389],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ApiResponse, MoodEntry } from \"../../shared/types.ts\";\nimport {\n createMoodEntry,\n getMoodEntryByDate,\n getRecentMoodEntries,\n updateMoodEntry,\n getMoodStats\n} from \"../database/queries.ts\";\n\nconst mood = new Hono();\n\n// Get mood stats\nmood.get(\"/stats\", async (c) => {\n try {\n const stats = await getMoodStats();\n return c.json({ success: true, data: stats } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Get recent mood entries\nmood.get(\"/recent\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"30\");\n const entries = await getRecentMoodEntries(limit);\n return c.json({ success: true, data: entries } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Get mood entry by date\nmood.get(\"/:date\", async (c) => {\n try {\n const date = c.req.param(\"date\");\n const entry = await getMoodEntryByDate(date);\n \n if (!entry) {\n return c.json({ success: false, error: \"Mood entry not found\" }, 404);\n }\n \n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Create or update mood entry\nmood.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n const { date, mood, energy, anxiety, notes, activities } = body;\n\n // Validate required fields\n if (!date || mood === undefined || energy === undefined || anxiety === undefined) {\n return c.json({ \n success: false, \n error: \"Missing required fields: date, mood, energy, anxiety\" \n }, 400);\n }\n\n // Validate ranges\n if (mood < 1 || mood > 10 || energy < 1 || energy > 10 || anxiety < 1 || anxiety > 10) {\n return c.json({ \n success: false, \n error: \"Mood, energy, and anxiety must be between 1 and 10\" \n }, 400);\n }\n\n // Check if entry already exists for this date\n const existingEntry = await getMoodEntryByDate(date);\n \n let entry: MoodEntry;\n if (existingEntry) {\n // Update existing entry\n entry = await updateMoodEntry(existingEntry.id!, {\n mood,\n energy,\n anxiety,\n notes,\n activities\n });\n } else {\n // Create new entry\n entry = await createMoodEntry({\n date,\n mood,\n energy,\n anxiety,\n notes,\n activities\n });\n }\n\n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Update mood entry\nmood.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const body = await c.req.json();\n\n // Validate ranges if provided\n const { mood, energy, anxiety } = body;\n if ((mood !== undefined && (mood < 1 || mood > 10)) ||\n (energy !== undefined && (energy < 1 || energy > 10)) ||\n (anxiety !== undefined && (anxiety < 1 || anxiety > 10))) {\n return c.json({ \n success: false, \n error: \"Mood, energy, and anxiety must be between 1 and 10\" \n }, 400);\n }\n\n const entry = await updateMoodEntry(id, body);\n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n if (error.message === 'Mood entry not found') {\n return c.json({ success: false, error: error.message }, 404);\n }\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\nexport default mood;",[],[162,231,223],"routes","15bc71f4-3f7d-11f0-9f01-76b3cceeab13","journal.ts","15bc72c6-3f7d-11f0-9f01-76b3cceeab13",7,["D",1748846691656],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ApiResponse, JournalEntry } from \"../../shared/types.ts\";\nimport {\n createJournalEntry,\n getJournalEntryById,\n getRecentJournalEntries,\n updateJournalEntry,\n deleteJournalEntry\n} from \"../database/queries.ts\";\n\nconst journal = new Hono();\n\n// Get recent journal entries\njournal.get(\"/\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"20\");\n const entries = await getRecentJournalEntries(limit);\n return c.json({ success: true, data: entries } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Get journal entry by ID\njournal.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const entry = await getJournalEntryById(id);\n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n if (error.message === 'Journal entry not found') {\n return c.json({ success: false, error: error.message }, 404);\n }\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Create journal entry\njournal.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n const { date, title, content, mood_before, mood_after, tags } = body;\n\n // Validate required fields\n if (!date || !title || !content) {\n return c.json({ \n success: false, \n error: \"Missing required fields: date, title, content\" \n }, 400);\n }\n\n // Validate mood ranges if provided\n if ((mood_before !== undefined && (mood_before < 1 || mood_before > 10)) ||\n (mood_after !== undefined && (mood_after < 1 || mood_after > 10))) {\n return c.json({ \n success: false, \n error: \"Mood values must be between 1 and 10\" \n }, 400);\n }\n\n const entry = await createJournalEntry({\n date,\n title,\n content,\n mood_before,\n mood_after,\n tags\n });\n\n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Update journal entry\njournal.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const body = await c.req.json();\n\n // Validate mood ranges if provided\n const { mood_before, mood_after } = body;\n if ((mood_before !== undefined && (mood_before < 1 || mood_before > 10)) ||\n (mood_after !== undefined && (mood_after < 1 || mood_after > 10))) {\n return c.json({ \n success: false, \n error: \"Mood values must be between 1 and 10\" \n }, 400);\n }\n\n const entry = await updateJournalEntry(id, body);\n return c.json({ success: true, data: entry } as ApiResponse);\n } catch (error) {\n if (error.message === 'Journal entry not found') {\n return c.json({ success: false, error: error.message }, 404);\n }\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Delete journal entry\njournal.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n await deleteJournalEntry(id);\n return c.json({ success: true } as ApiResponse);\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\nexport default journal;",[],[162,231,233],"0a410074-3f7d-11f0-8525-76b3cceeab13",["D",1748846672389],[182,183],[162,231],"003a58dc-3f7d-11f0-8525-76b3cceeab13","queries.ts","003a59cc-3f7d-11f0-8525-76b3cceeab13","3f4ddcf7-d138-41ca-b61f-cfcdf6b461fc",5,["D",1748846655570],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { MoodEntry, JournalEntry, MoodStats } from \"../../shared/types.ts\";\n\n// Mood Entry Queries\nexport async function createMoodEntry(entry: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO mood_entries_v1 (date, mood, energy, anxiety, notes, activities)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n entry.date,\n entry.mood,\n entry.energy,\n entry.anxiety,\n entry.notes || null,\n entry.activities ? JSON.stringify(entry.activities) : null\n ]);\n\n return getMoodEntryById(result.lastInsertRowId);\n}\n\nexport async function getMoodEntryById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM mood_entries_v1 WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) {\n throw new Error('Mood entry not found');\n }\n\n const row = result.rows[0];\n return {\n id: row[0] as number,\n date: row[1] as string,\n mood: row[2] as number,\n energy: row[3] as number,\n anxiety: row[4] as number,\n notes: row[5] as string || undefined,\n activities: row[6] ? JSON.parse(row[6] as string) : undefined,\n created_at: row[7] as string\n };\n}\n\nexport async function getMoodEntryByDate(date: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM mood_entries_v1 WHERE date = ?\n `, [date]);\n\n if (result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n return {\n id: row[0] as number,\n date: row[1] as string,\n mood: row[2] as number,\n energy: row[3] as number,\n anxiety: row[4] as number,\n notes: row[5] as string || undefined,\n activities: row[6] ? JSON.parse(row[6] as string) : undefined,\n created_at: row[7] as string\n };\n}\n\nexport async function getRecentMoodEntries(limit: number = 30): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM mood_entries_v1 \n ORDER BY date DESC \n LIMIT ?\n `, [limit]);\n\n return result.rows.map(row => ({\n id: row[0] as number,\n date: row[1] as string,\n mood: row[2] as number,\n energy: row[3] as number,\n anxiety: row[4] as number,\n notes: row[5] as string || undefined,\n activities: row[6] ? JSON.parse(row[6] as string) : undefined,\n created_at: row[7] as string\n }));\n}\n\nexport async function updateMoodEntry(id: number, entry: Partial): Promise {\n const updates: string[] = [];\n const values: any[] = [];\n\n if (entry.mood !== undefined) {\n updates.push('mood = ?');\n values.push(entry.mood);\n }\n if (entry.energy !== undefined) {\n updates.push('energy = ?');\n values.push(entry.energy);\n }\n if (entry.anxiety !== undefined) {\n updates.push('anxiety = ?');\n values.push(entry.anxiety);\n }\n if (entry.notes !== undefined) {\n updates.push('notes = ?');\n values.push(entry.notes);\n }\n if (entry.activities !== undefined) {\n updates.push('activities = ?');\n values.push(JSON.stringify(entry.activities));\n }\n\n if (updates.length === 0) {\n throw new Error('No fields to update');\n }\n\n values.push(id);\n\n await sqlite.execute(`\n UPDATE mood_entries_v1 \n SET ${updates.join(', ')} \n WHERE id = ?\n `, values);\n\n return getMoodEntryById(id);\n}\n\nexport async function getMoodStats(): Promise {\n const result = await sqlite.execute(`\n SELECT \n AVG(mood) as avg_mood,\n AVG(energy) as avg_energy,\n AVG(anxiety) as avg_anxiety,\n COUNT(*) as total_entries,\n MAX(date) as last_entry\n FROM mood_entries_v1\n `);\n\n const row = result.rows[0];\n \n // Calculate streak (consecutive days with entries)\n const streakResult = await sqlite.execute(`\n WITH RECURSIVE date_series AS (\n SELECT date, ROW_NUMBER() OVER (ORDER BY date DESC) as rn\n FROM mood_entries_v1\n WHERE date <= date('now')\n ORDER BY date DESC\n ),\n consecutive_dates AS (\n SELECT date, rn,\n date('now', '-' || (rn - 1) || ' days') as expected_date\n FROM date_series\n )\n SELECT COUNT(*) as streak\n FROM consecutive_dates\n WHERE date = expected_date\n ORDER BY rn\n `);\n\n const streak = streakResult.rows[0]?.[0] as number || 0;\n\n return {\n averageMood: Number((row[0] as number || 0).toFixed(1)),\n averageEnergy: Number((row[1] as number || 0).toFixed(1)),\n averageAnxiety: Number((row[2] as number || 0).toFixed(1)),\n totalEntries: row[3] as number || 0,\n streak,\n lastEntry: row[4] as string || undefined\n };\n}\n\n// Journal Entry Queries\nexport async function createJournalEntry(entry: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO journal_entries_v1 (date, title, content, mood_before, mood_after, tags)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n entry.date,\n entry.title,\n entry.content,\n entry.mood_before || null,\n entry.mood_after || null,\n entry.tags ? JSON.stringify(entry.tags) : null\n ]);\n\n return getJournalEntryById(result.lastInsertRowId);\n}\n\nexport async function getJournalEntryById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM journal_entries_v1 WHERE id = ?\n `, [id]);\n\n if (result.rows.length === 0) {\n throw new Error('Journal entry not found');\n }\n\n const row = result.rows[0];\n return {\n id: row[0] as number,\n date: row[1] as string,\n title: row[2] as string,\n content: row[3] as string,\n mood_before: row[4] as number || undefined,\n mood_after: row[5] as number || undefined,\n tags: row[6] ? JSON.parse(row[6] as string) : undefined,\n created_at: row[7] as string,\n updated_at: row[8] as string\n };\n}\n\nexport async function getRecentJournalEntries(limit: number = 20): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM journal_entries_v1 \n ORDER BY created_at DESC \n LIMIT ?\n `, [limit]);\n\n return result.rows.map(row => ({\n id: row[0] as number,\n date: row[1] as string,\n title: row[2] as string,\n content: row[3] as string,\n mood_before: row[4] as number || undefined,\n mood_after: row[5] as number || undefined,\n tags: row[6] ? JSON.parse(row[6] as string) : undefined,\n created_at: row[7] as string,\n updated_at: row[8] as string\n }));\n}\n\nexport async function updateJournalEntry(id: number, entry: Partial): Promise {\n const updates: string[] = [];\n const values: any[] = [];\n\n if (entry.title !== undefined) {\n updates.push('title = ?');\n values.push(entry.title);\n }\n if (entry.content !== undefined) {\n updates.push('content = ?');\n values.push(entry.content);\n }\n if (entry.mood_before !== undefined) {\n updates.push('mood_before = ?');\n values.push(entry.mood_before);\n }\n if (entry.mood_after !== undefined) {\n updates.push('mood_after = ?');\n values.push(entry.mood_after);\n }\n if (entry.tags !== undefined) {\n updates.push('tags = ?');\n values.push(JSON.stringify(entry.tags));\n }\n\n if (updates.length === 0) {\n throw new Error('No fields to update');\n }\n\n updates.push('updated_at = CURRENT_TIMESTAMP');\n values.push(id);\n\n await sqlite.execute(`\n UPDATE journal_entries_v1 \n SET ${updates.join(', ')} \n WHERE id = ?\n `, values);\n\n return getJournalEntryById(id);\n}\n\nexport async function deleteJournalEntry(id: number): Promise {\n await sqlite.execute(`\n DELETE FROM journal_entries_v1 WHERE id = ?\n `, [id]);\n}",[],[162,253,245],"database","ec6a5d2a-3f7c-11f0-8c0e-76b3cceeab13","migrations.ts","ec6a5dfc-3f7c-11f0-8c0e-76b3cceeab13",["D",1748846622331],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n // Mood entries table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS mood_entries_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL UNIQUE,\n mood INTEGER NOT NULL CHECK (mood >= 1 AND mood <= 10),\n energy INTEGER NOT NULL CHECK (energy >= 1 AND energy <= 10),\n anxiety INTEGER NOT NULL CHECK (anxiety >= 1 AND anxiety <= 10),\n notes TEXT,\n activities TEXT, -- JSON array of activities\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Journal entries table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS journal_entries_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n mood_before INTEGER CHECK (mood_before >= 1 AND mood_before <= 10),\n mood_after INTEGER CHECK (mood_after >= 1 AND mood_after <= 10),\n tags TEXT, -- JSON array of tags\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[162,253,255],"ec6a8066-3f7c-11f0-8c0e-76b3cceeab13",["D",1748846622331],[179,180],[162,253],["D",1748846622331],[178,181,184],[162],["D",1748844918795],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":305,"_306":307,"_308":309,"_310":25,"_311":25,"_312":25,"_313":62,"_314":-5,"_315":-7,"_316":-7,"_317":66,"_318":25,"_319":25,"_320":-5,"_321":25,"_322":25,"_323":25,"_324":-5},"ENV",{"_276":277,"_278":279,"_280":90,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304},"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