[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_250":251,"_252":253},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"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":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",8,"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","backend/index.ts","latestPath","fileId","1e62cfce-3f7d-11f0-9f28-76b3cceeab13","name","index.ts","fileType","script","content","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;","createdAt",["D",1748846706166],"branchVersion","branchId","f5071206-3f78-11f0-8d1f-76b3cceeab13","id","f506caa8-3f78-11f0-8d1f-76b3cceeab13","Mind_clinic",["D",1748844918795],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","23880fb0-3f6d-11f0-ad5b-814c56c8abb0","pinnedFileId","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",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"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",{"_42":43,"_31":44,"_37":246,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":247,"_78":248,"_80":249,"_82":24},"tree",[167,175,177,178],"files",[167,168,169,170,171,172,173,174,175,176,177,178],"counts",{"_157":60,"_158":132,"_159":60,"_160":161,"_162":163},"contents",[124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":151,"_31":152,"_29":153,"_131":-5,"_40":41,"_39":154,"_133":56,"_37":155,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_26":156},{"_42":144,"_31":145,"_29":146,"_131":-5,"_40":41,"_39":147,"_133":56,"_37":148,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_26":150},{"_42":137,"_31":138,"_29":139,"_131":-5,"_40":41,"_39":140,"_133":56,"_37":141,"_13":60,"_33":20,"_35":142,"_23":24,"_135":-5,"_26":143},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":56,"_37":134,"_13":60,"_33":34,"_35":103,"_23":24,"_135":-5,"_26":136},"f508dd84-3f78-11f0-8d1f-76b3cceeab13","main.tsx","f508de10-3f78-11f0-8d1f-76b3cceeab13","parentId",1,"latest",["D",1748844918805],"label",[129],"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",[138],"e797150e-3f7c-11f0-9baa-76b3cceeab13","shared","67357349-4169-4d52-b15b-b0d4757c5751",3,["D",1748846614234],"directory",[145],"ec6a7eae-3f7c-11f0-8c0e-76b3cceeab13","backend","3989d51f-22d4-499c-be0c-5a1d262bd617",4,["D",1748846622331],[152],"pulls","branches","forks","envVars",{"_164":60,"_166":60},"connections",{"_164":60,"_165":60},"count","unfilledCount","emptyCount",{"_42":151,"_31":152,"_29":153,"_131":-5,"_40":41,"_39":154,"_133":56,"_37":243,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_180":244,"_26":245},{"_42":239,"_31":231,"_29":225,"_131":153,"_40":41,"_39":154,"_133":56,"_37":240,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_180":241,"_26":242},{"_42":232,"_31":233,"_29":234,"_131":225,"_40":41,"_39":154,"_133":56,"_37":235,"_13":60,"_33":34,"_35":236,"_23":24,"_135":-5,"_180":237,"_26":238},{"_42":222,"_31":223,"_29":224,"_131":225,"_40":41,"_39":226,"_133":56,"_37":227,"_13":60,"_33":34,"_35":228,"_23":24,"_135":-5,"_180":229,"_26":230},{"_42":218,"_31":209,"_29":203,"_131":153,"_40":41,"_39":204,"_133":56,"_37":219,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_180":220,"_26":221},{"_42":210,"_31":211,"_29":212,"_131":203,"_40":41,"_39":213,"_133":56,"_37":214,"_13":60,"_33":34,"_35":215,"_23":24,"_135":-5,"_180":216,"_26":217},{"_42":200,"_31":201,"_29":202,"_131":203,"_40":41,"_39":204,"_133":56,"_37":205,"_13":60,"_33":34,"_35":206,"_23":24,"_135":-5,"_180":207,"_26":208},{"_42":196,"_31":32,"_29":30,"_131":153,"_40":41,"_39":14,"_133":24,"_37":197,"_13":60,"_33":34,"_35":36,"_23":24,"_135":-5,"_180":198,"_26":199},{"_42":144,"_31":145,"_29":146,"_131":-5,"_40":41,"_39":147,"_133":56,"_37":193,"_13":60,"_33":149,"_35":-5,"_23":24,"_135":-5,"_180":194,"_26":195},{"_42":186,"_31":187,"_29":188,"_131":146,"_40":41,"_39":147,"_133":56,"_37":189,"_13":60,"_33":34,"_35":190,"_23":24,"_135":-5,"_180":191,"_26":192},{"_42":137,"_31":138,"_29":139,"_131":-5,"_40":41,"_39":140,"_133":56,"_37":183,"_13":60,"_33":20,"_35":142,"_23":24,"_135":-5,"_180":184,"_26":185},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":56,"_37":179,"_13":60,"_33":34,"_35":103,"_23":24,"_135":-5,"_180":181,"_26":182},["D",1748844918805],"children",[],[129],["D",1748846606334],[],[138],"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}",[],[145,187],["D",1748846614234],[176],[145],"1e62cf2e-3f7d-11f0-9f28-76b3cceeab13",["D",1748846706166],[],[152,32],"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;",[],[152,209,201],"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;",[],[152,209,211],"0a410074-3f7d-11f0-8525-76b3cceeab13",["D",1748846672389],[172,173],[152,209],"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}",[],[152,231,223],"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}",[],[152,231,233],"ec6a8066-3f7c-11f0-8c0e-76b3cceeab13",["D",1748846622331],[169,170],[152,231],["D",1748846622331],[168,171,174],[152],["D",1748844918795],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":283,"_284":285,"_286":287,"_288":24,"_289":24,"_290":24,"_291":56,"_292":-5,"_293":-7,"_294":-7,"_295":60,"_296":24,"_297":24,"_298":-5,"_299":24,"_300":24,"_301":24,"_302":-5},"ENV",{"_254":255,"_256":257,"_258":84,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282},"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 · v8