[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_242":243,"_244":245},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"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":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",7,"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/routes/journal.ts","latestPath","fileId","15bc72c6-3f7d-11f0-9f01-76b3cceeab13","name","journal.ts","fileType","script","content","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;","createdAt",["D",1748846691656],"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","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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":238,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":239,"_79":240,"_81":241,"_83":24},"tree",[168,175,177,178],"files",[168,169,170,171,172,173,174,175,176,177,178],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_26":157},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":57,"_37":149,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_26":151},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":57,"_37":142,"_13":61,"_33":20,"_35":143,"_23":24,"_136":-5,"_26":144},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":135,"_13":61,"_33":34,"_35":104,"_23":24,"_136":-5,"_26":137},"f508dd84-3f78-11f0-8d1f-76b3cceeab13","main.tsx","f508de10-3f78-11f0-8d1f-76b3cceeab13","parentId",1,"latest",["D",1748844918805],"label",[130],"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",[139],"e797150e-3f7c-11f0-9baa-76b3cceeab13","shared","67357349-4169-4d52-b15b-b0d4757c5751",3,["D",1748846614234],"directory",[146],"ec6a7eae-3f7c-11f0-8c0e-76b3cceeab13","backend","3989d51f-22d4-499c-be0c-5a1d262bd617",4,["D",1748846622331],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":235,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_180":236,"_26":237},{"_42":231,"_31":223,"_29":217,"_132":154,"_40":41,"_39":155,"_134":57,"_37":232,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_180":233,"_26":234},{"_42":224,"_31":225,"_29":226,"_132":217,"_40":41,"_39":155,"_134":57,"_37":227,"_13":61,"_33":34,"_35":228,"_23":24,"_136":-5,"_180":229,"_26":230},{"_42":214,"_31":215,"_29":216,"_132":217,"_40":41,"_39":218,"_134":57,"_37":219,"_13":61,"_33":34,"_35":220,"_23":24,"_136":-5,"_180":221,"_26":222},{"_42":210,"_31":205,"_29":199,"_132":154,"_40":41,"_39":200,"_134":57,"_37":211,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_180":212,"_26":213},{"_42":206,"_31":32,"_29":30,"_132":199,"_40":41,"_39":14,"_134":57,"_37":207,"_13":61,"_33":34,"_35":36,"_23":24,"_136":-5,"_180":208,"_26":209},{"_42":196,"_31":197,"_29":198,"_132":199,"_40":41,"_39":200,"_134":57,"_37":201,"_13":61,"_33":34,"_35":202,"_23":24,"_136":-5,"_180":203,"_26":204},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":57,"_37":193,"_13":61,"_33":150,"_35":-5,"_23":24,"_136":-5,"_180":194,"_26":195},{"_42":186,"_31":187,"_29":188,"_132":147,"_40":41,"_39":148,"_134":57,"_37":189,"_13":61,"_33":34,"_35":190,"_23":24,"_136":-5,"_180":191,"_26":192},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":57,"_37":183,"_13":61,"_33":20,"_35":143,"_23":24,"_136":-5,"_180":184,"_26":185},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":179,"_13":61,"_33":34,"_35":104,"_23":24,"_136":-5,"_180":181,"_26":182},["D",1748844918805],"children",[],[130],["D",1748846606334],[],[139],"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}",[],[146,187],["D",1748846614234],[176],[146],"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;",[],[153,205,197],"routes","15bc71f4-3f7d-11f0-9f01-76b3cceeab13",["D",1748846691656],[],[153,205,32],"0a410074-3f7d-11f0-8525-76b3cceeab13",["D",1748846672389],[173,174],[153,205],"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}",[],[153,223,215],"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}",[],[153,223,225],"ec6a8066-3f7c-11f0-8c0e-76b3cceeab13",["D",1748846622331],[170,171],[153,223],["D",1748846622331],[169,172],[153],["D",1748844918795],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":275,"_276":277,"_278":279,"_280":24,"_281":24,"_282":24,"_283":57,"_284":-5,"_285":-7,"_286":-7,"_287":61,"_288":24,"_289":24,"_290":-5,"_291":24,"_292":24,"_293":24,"_294":-5},"ENV",{"_246":247,"_248":249,"_250":85,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274},"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 · v7