[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_312":313,"_314":315},"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",13,"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","frontend/components/Journal.tsx","latestPath","fileId","8532b200-3f7d-11f0-9dcc-76b3cceeab13","name","Journal.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { JournalEntry } from \"../../shared/types.ts\";\n\ninterface JournalProps {\n recentJournals: JournalEntry[];\n onDataUpdate: () => void;\n}\n\nexport default function Journal({ recentJournals, onDataUpdate }: JournalProps) {\n const [isWriting, setIsWriting] = useState(false);\n const [editingEntry, setEditingEntry] = useState(null);\n const [title, setTitle] = useState('');\n const [content, setContent] = useState('');\n const [moodBefore, setMoodBefore] = useState(undefined);\n const [moodAfter, setMoodAfter] = useState(undefined);\n const [tags, setTags] = useState([]);\n const [tagInput, setTagInput] = useState('');\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [entries, setEntries] = useState(recentJournals);\n\n const journalPrompts = [\n \"What am I grateful for today?\",\n \"What challenged me today and how did I handle it?\",\n \"What emotions am I feeling right now?\",\n \"What would I tell a friend going through what I'm experiencing?\",\n \"What small win can I celebrate today?\",\n \"What do I need to let go of?\",\n \"How can I be kinder to myself?\",\n \"What patterns am I noticing in my thoughts or behaviors?\",\n \"What brings me peace and joy?\",\n \"What do I want to remember about today?\"\n ];\n\n useEffect(() => {\n setEntries(recentJournals);\n }, [recentJournals]);\n\n const startNewEntry = () => {\n setIsWriting(true);\n setEditingEntry(null);\n setTitle('');\n setContent('');\n setMoodBefore(undefined);\n setMoodAfter(undefined);\n setTags([]);\n setTagInput('');\n };\n\n const editEntry = (entry: JournalEntry) => {\n setIsWriting(true);\n setEditingEntry(entry);\n setTitle(entry.title);\n setContent(entry.content);\n setMoodBefore(entry.mood_before);\n setMoodAfter(entry.mood_after);\n setTags(entry.tags || []);\n setTagInput('');\n };\n\n const cancelWriting = () => {\n setIsWriting(false);\n setEditingEntry(null);\n setTitle('');\n setContent('');\n setMoodBefore(undefined);\n setMoodAfter(undefined);\n setTags([]);\n setTagInput('');\n };\n\n const addTag = () => {\n const tag = tagInput.trim();\n if (tag && !tags.includes(tag)) {\n setTags([...tags, tag]);\n setTagInput('');\n }\n };\n\n const removeTag = (tagToRemove: string) => {\n setTags(tags.filter(tag => tag !== tagToRemove));\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!title.trim() || !content.trim()) return;\n\n setIsSubmitting(true);\n\n try {\n const entryData = {\n date: new Date().toISOString().split('T')[0],\n title: title.trim(),\n content: content.trim(),\n mood_before: moodBefore,\n mood_after: moodAfter,\n tags: tags.length > 0 ? tags : undefined\n };\n\n const url = editingEntry ? `/api/journal/${editingEntry.id}` : '/api/journal';\n const method = editingEntry ? 'PUT' : 'POST';\n\n const response = await fetch(url, {\n method,\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(entryData)\n });\n\n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n onDataUpdate();\n cancelWriting();\n \n // Show success message\n const successDiv = document.createElement('div');\n successDiv.className = 'fixed top-4 right-4 bg-green-500 text-white px-4 py-2 rounded-lg shadow-lg z-50';\n successDiv.textContent = editingEntry ? 'Journal entry updated!' : 'Journal entry saved!';\n document.body.appendChild(successDiv);\n setTimeout(() => successDiv.remove(), 3000);\n }\n } else {\n throw new Error('Failed to save journal entry');\n }\n } catch (error) {\n console.error('Error saving journal entry:', error);\n alert('Error saving journal entry. Please try again.');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const deleteEntry = async (id: number) => {\n if (!confirm('Are you sure you want to delete this journal entry?')) return;\n\n try {\n const response = await fetch(`/api/journal/${id}`, {\n method: 'DELETE'\n });\n\n if (response.ok) {\n onDataUpdate();\n \n // Show success message\n const successDiv = document.createElement('div');\n successDiv.className = 'fixed top-4 right-4 bg-red-500 text-white px-4 py-2 rounded-lg shadow-lg z-50';\n successDiv.textContent = 'Journal entry deleted';\n document.body.appendChild(successDiv);\n setTimeout(() => successDiv.remove(), 3000);\n }\n } catch (error) {\n console.error('Error deleting journal entry:', error);\n alert('Error deleting journal entry. Please try again.');\n }\n };\n\n const usePrompt = (prompt: string) => {\n setContent(content + (content ? '\\n\\n' : '') + prompt + '\\n\\n');\n };\n\n if (isWriting) {\n return (\n

\n 📝\n {editingEntry ? 'Edit Journal Entry' : 'New Journal Entry'}\n

\n \n ✕\n \n

\n\n

\n {/* Title */}\n

\n Title\n setTitle(e.target.value)}\n placeholder=\"Give your entry a title...\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-purple-500\"\n required\n />\n

\n\n {/* Mood Before/After */}\n

\n \n Mood Before Writing (optional)\n \n setMoodBefore(e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-purple-500\"\n >\n \n {Array.from({ length: 10 }, (_, i) => i + 1).map(num => (\n \n ))}\n \n

\n \n Mood After Writing (optional)\n \n setMoodAfter(e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-purple-500\"\n >\n \n {Array.from({ length: 10 }, (_, i) => i + 1).map(num => (\n \n ))}\n \n

\n\n {/* Writing Prompts */}\n

\n \n Need inspiration? Try these prompts:\n \n

\n {journalPrompts.slice(0, 6).map((prompt, idx) => (\n usePrompt(prompt)}\n className=\"text-left p-2 text-sm bg-purple-50 text-purple-700 rounded border hover:bg-purple-100 transition-colors\"\n >\n {prompt}\n \n ))}\n

\n\n {/* Content */}\n

\n Your thoughts\n setContent(e.target.value)}\n placeholder=\"Write about your thoughts, feelings, experiences...\"\n rows={12}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-purple-500\"\n required\n />\n

\n {content.length} characters\n

\n\n {/* Tags */}\n

\n Tags\n

\n {tags.map(tag => (\n \n {tag}\n removeTag(tag)}\n className=\"ml-1 text-purple-600 hover:text-purple-800\"\n >\n ×\n \n \n ))}\n

\n setTagInput(e.target.value)}\n onKeyPress={(e) => e.key === 'Enter' && (e.preventDefault(), addTag())}\n placeholder=\"Add a tag...\"\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-purple-500\"\n />\n \n Add\n \n

\n\n {/* Submit Buttons */}\n

\n \n {isSubmitting ? 'Saving...' : (editingEntry ? 'Update Entry' : 'Save Entry')}\n \n \n Cancel\n \n

\n );\n }\n\n return (\n

\n {/* Header */}\n

\n 📝\n Journal\n

\n \n ✏️ New Entry\n \n

\n\n {/* Journal Entries */}\n {entries.length === 0 ? (\n

📖

Start Your Journal

\n Writing can help you process emotions, track patterns, and reflect on your journey.\n

\n \n Write Your First Entry\n \n

\n ) : (\n

\n {entries.map((entry) => (\n

{entry.title}

\n {new Date(entry.created_at!).toLocaleDateString()} at{' '}\n {new Date(entry.created_at!).toLocaleTimeString()}\n

\n editEntry(entry)}\n className=\"text-gray-400 hover:text-blue-600\"\n title=\"Edit entry\"\n >\n ✏️\n \n deleteEntry(entry.id!)}\n className=\"text-gray-400 hover:text-red-600\"\n title=\"Delete entry\"\n >\n 🗑️\n \n

\n\n {/* Mood indicators */}\n {(entry.mood_before || entry.mood_after) && (\n

\n {entry.mood_before && (\n \n Mood before: {entry.mood_before}/10\n \n )}\n {entry.mood_after && (\n \n Mood after: {entry.mood_after}/10\n \n )}\n

\n )}\n\n {/* Content preview */}\n

\n {entry.content.length > 300 ? (\n <>\n {entry.content.substring(0, 300)}...\n editEntry(entry)}\n className=\"text-purple-600 hover:text-purple-800 ml-2\"\n >\n Read more\n \n \n ) : (\n entry.content\n )}\n

\n\n {/* Tags */}\n {entry.tags && entry.tags.length > 0 && (\n

\n {entry.tags.map((tag, idx) => (\n \n {tag}\n \n ))}\n

\n )}\n

\n ))}\n

\n )}\n

\n );\n}","createdAt",["D",1748846878657],"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":308,"_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":309,"_79":310,"_81":311,"_83":24},"tree",[175,183,190,192,193],"files",[175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193],"counts",{"_165":61,"_166":134,"_167":61,"_168":169,"_170":171},"contents",[125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":163,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":157,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":158},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":150,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_26":152},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":143,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_26":145},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":57,"_37":136,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_26":138},"f508dd84-3f78-11f0-8d1f-76b3cceeab13","main.tsx","f508de10-3f78-11f0-8d1f-76b3cceeab13","parentId",1,"latest",["D",1748844918805],"label",[131],"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",[140],"e797150e-3f7c-11f0-9baa-76b3cceeab13","shared","67357349-4169-4d52-b15b-b0d4757c5751",3,["D",1748846614234],"directory",[147],"25afc372-3f7d-11f0-9bea-76b3cceeab13","frontend","2eee9620-0ce7-41aa-86e8-9f559adea0fa",9,["D",1748846718415],[154],"ec6a7eae-3f7c-11f0-8c0e-76b3cceeab13","backend","3989d51f-22d4-499c-be0c-5a1d262bd617",4,["D",1748846622331],[160],"pulls","branches","forks","envVars",{"_172":61,"_174":61},"connections",{"_172":61,"_173":61},"count","unfilledCount","emptyCount",{"_42":159,"_31":160,"_29":161,"_133":-5,"_40":41,"_39":162,"_135":57,"_37":305,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":306,"_26":307},{"_42":301,"_31":293,"_29":287,"_133":161,"_40":41,"_39":162,"_135":57,"_37":302,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":303,"_26":304},{"_42":294,"_31":295,"_29":296,"_133":287,"_40":41,"_39":162,"_135":57,"_37":297,"_13":61,"_33":34,"_35":298,"_23":24,"_137":-5,"_195":299,"_26":300},{"_42":284,"_31":285,"_29":286,"_133":287,"_40":41,"_39":288,"_135":57,"_37":289,"_13":61,"_33":34,"_35":290,"_23":24,"_137":-5,"_195":291,"_26":292},{"_42":280,"_31":271,"_29":265,"_133":161,"_40":41,"_39":266,"_135":57,"_37":281,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":282,"_26":283},{"_42":272,"_31":273,"_29":274,"_133":265,"_40":41,"_39":275,"_135":57,"_37":276,"_13":61,"_33":34,"_35":277,"_23":24,"_137":-5,"_195":278,"_26":279},{"_42":262,"_31":263,"_29":264,"_133":265,"_40":41,"_39":266,"_135":57,"_37":267,"_13":61,"_33":34,"_35":268,"_23":24,"_137":-5,"_195":269,"_26":270},{"_42":255,"_31":256,"_29":55,"_133":161,"_40":41,"_39":257,"_135":24,"_37":258,"_13":61,"_33":34,"_35":259,"_23":24,"_137":-5,"_195":260,"_26":261},{"_42":153,"_31":154,"_29":155,"_133":-5,"_40":41,"_39":156,"_135":57,"_37":252,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":253,"_26":254},{"_42":248,"_31":235,"_29":229,"_133":155,"_40":41,"_39":243,"_135":57,"_37":249,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":250,"_26":251},{"_42":240,"_31":241,"_29":242,"_133":229,"_40":41,"_39":243,"_135":57,"_37":244,"_13":61,"_33":34,"_35":245,"_23":24,"_137":-5,"_195":246,"_26":247},{"_42":236,"_31":32,"_29":30,"_133":229,"_40":41,"_39":14,"_135":57,"_37":237,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_195":238,"_26":239},{"_42":226,"_31":227,"_29":228,"_133":229,"_40":41,"_39":230,"_135":57,"_37":231,"_13":61,"_33":34,"_35":232,"_23":24,"_137":-5,"_195":233,"_26":234},{"_42":219,"_31":220,"_29":221,"_133":155,"_40":41,"_39":156,"_135":57,"_37":222,"_13":61,"_33":20,"_35":223,"_23":24,"_137":-5,"_195":224,"_26":225},{"_42":211,"_31":212,"_29":213,"_133":155,"_40":41,"_39":214,"_135":57,"_37":215,"_13":61,"_33":34,"_35":216,"_23":24,"_137":-5,"_195":217,"_26":218},{"_42":146,"_31":147,"_29":148,"_133":-5,"_40":41,"_39":149,"_135":57,"_37":208,"_13":61,"_33":151,"_35":-5,"_23":24,"_137":-5,"_195":209,"_26":210},{"_42":201,"_31":202,"_29":203,"_133":148,"_40":41,"_39":149,"_135":57,"_37":204,"_13":61,"_33":34,"_35":205,"_23":24,"_137":-5,"_195":206,"_26":207},{"_42":139,"_31":140,"_29":141,"_133":-5,"_40":41,"_39":142,"_135":57,"_37":198,"_13":61,"_33":20,"_35":144,"_23":24,"_137":-5,"_195":199,"_26":200},{"_42":130,"_31":131,"_29":132,"_133":-5,"_40":41,"_39":134,"_135":57,"_37":194,"_13":61,"_33":34,"_35":104,"_23":24,"_137":-5,"_195":196,"_26":197},["D",1748844918805],"children",[],[131],["D",1748846606334],[],[140],"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}",[],[147,202],["D",1748846614234],[191],[147],"29ef8b3e-3f7d-11f0-b38d-76b3cceeab13","index.tsx","29ef8bde-3f7d-11f0-b38d-76b3cceeab13",10,["D",1748846725508],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\n// Get initial data from server\nconst initialData = (window as any).__INITIAL_DATA__ || {\n moodStats: null,\n recentMoods: [],\n recentJournals: []\n};\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[154,212],"25afbc56-3f7d-11f0-9bea-76b3cceeab13","index.html","25afbd14-3f7d-11f0-9bea-76b3cceeab13",["D",1748846718415],"\n\n\n \n \n Mental Health Support App\n \n \n 🧠\">\n \n\n\n

\n \n \n\n",[],[154,220],"5e57d6e2-3f7d-11f0-9bea-76b3cceeab13","MoodTracker.tsx","5e57d78c-3f7d-11f0-9bea-76b3cceeab13","a825b90a-f2a2-4f61-ab50-02b47dd1c39a",12,["D",1748846813471],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { MoodEntry, MoodStats } from \"../../shared/types.ts\";\n\ninterface MoodTrackerProps {\n moodStats: MoodStats | null;\n recentMoods: MoodEntry[];\n onDataUpdate: () => void;\n}\n\nexport default function MoodTracker({ moodStats, recentMoods, onDataUpdate }: MoodTrackerProps) {\n const [selectedDate, setSelectedDate] = useState(new Date().toISOString().split('T')[0]);\n const [mood, setMood] = useState(5);\n const [energy, setEnergy] = useState(5);\n const [anxiety, setAnxiety] = useState(5);\n const [notes, setNotes] = useState('');\n const [activities, setActivities] = useState([]);\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [todayEntry, setTodayEntry] = useState(null);\n\n const activityOptions = [\n 'Exercise', 'Meditation', 'Reading', 'Socializing', 'Work', 'Sleep',\n 'Therapy', 'Music', 'Nature', 'Cooking', 'Gaming', 'Art'\n ];\n\n const moodLabels = {\n 1: 'Terrible', 2: 'Very Bad', 3: 'Bad', 4: 'Poor', 5: 'Okay',\n 6: 'Good', 7: 'Very Good', 8: 'Great', 9: 'Excellent', 10: 'Amazing'\n };\n\n const energyLabels = {\n 1: 'Exhausted', 2: 'Very Low', 3: 'Low', 4: 'Below Average', 5: 'Average',\n 6: 'Good', 7: 'High', 8: 'Very High', 9: 'Energetic', 10: 'Buzzing'\n };\n\n const anxietyLabels = {\n 1: 'Very Calm', 2: 'Calm', 3: 'Relaxed', 4: 'Slightly Tense', 5: 'Neutral',\n 6: 'Worried', 7: 'Anxious', 8: 'Very Anxious', 9: 'Panicked', 10: 'Overwhelmed'\n };\n\n // Load today's entry on component mount\n useEffect(() => {\n loadTodayEntry();\n }, []);\n\n const loadTodayEntry = async () => {\n try {\n const today = new Date().toISOString().split('T')[0];\n const response = await fetch(`/api/mood/${today}`);\n if (response.ok) {\n const data = await response.json();\n if (data.success && data.data) {\n const entry = data.data;\n setTodayEntry(entry);\n setMood(entry.mood);\n setEnergy(entry.energy);\n setAnxiety(entry.anxiety);\n setNotes(entry.notes || '');\n setActivities(entry.activities || []);\n }\n }\n } catch (error) {\n console.error('Error loading today\\'s entry:', error);\n }\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n\n try {\n const response = await fetch('/api/mood', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n date: selectedDate,\n mood,\n energy,\n anxiety,\n notes: notes.trim() || undefined,\n activities: activities.length > 0 ? activities : undefined\n })\n });\n\n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n setTodayEntry(data.data);\n onDataUpdate();\n \n // Show success message\n const successDiv = document.createElement('div');\n successDiv.className = 'fixed top-4 right-4 bg-green-500 text-white px-4 py-2 rounded-lg shadow-lg z-50';\n successDiv.textContent = 'Mood entry saved successfully!';\n document.body.appendChild(successDiv);\n setTimeout(() => successDiv.remove(), 3000);\n }\n } else {\n throw new Error('Failed to save mood entry');\n }\n } catch (error) {\n console.error('Error saving mood entry:', error);\n alert('Error saving mood entry. Please try again.');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const toggleActivity = (activity: string) => {\n setActivities(prev => \n prev.includes(activity) \n ? prev.filter(a => a !== activity)\n : [...prev, activity]\n );\n };\n\n const getMoodColor = (value: number) => {\n if (value <= 3) return 'text-red-600';\n if (value <= 5) return 'text-yellow-600';\n if (value <= 7) return 'text-blue-600';\n return 'text-green-600';\n };\n\n return (\n

\n {/* Stats Overview */}\n {moodStats && (\n

🔥

Current Streak

{moodStats.streak} days

\n \n

😊

Average Mood

\n {moodStats.averageMood}/10\n

\n \n

⚡

Average Energy

\n {moodStats.averageEnergy}/10\n

\n \n

📈

Total Entries

{moodStats.totalEntries}

\n )}\n\n

\n {/* Mood Entry Form */}\n

\n 📊\n Track Your Mood\n

\n \n

\n {/* Date Selection */}\n

\n Date\n setSelectedDate(e.target.value)}\n max={new Date().toISOString().split('T')[0]}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n\n {/* Mood Scale */}\n

\n \n Mood: {mood}/10 - {moodLabels[mood as keyof typeof moodLabels]}\n \n

\n setMood(parseInt(e.target.value))}\n className=\"w-full h-2 mood-scale rounded-lg appearance-none cursor-pointer\"\n />\n

\n 😢 Terrible\n 😐 Okay\n 😊 Amazing\n

\n\n {/* Energy Scale */}\n

\n \n Energy: {energy}/10 - {energyLabels[energy as keyof typeof energyLabels]}\n \n setEnergy(parseInt(e.target.value))}\n className=\"w-full h-2 bg-gradient-to-r from-red-400 to-green-400 rounded-lg appearance-none cursor-pointer\"\n />\n

\n 🔋 Exhausted\n ⚡ Buzzing\n

\n\n {/* Anxiety Scale */}\n

\n \n Anxiety: {anxiety}/10 - {anxietyLabels[anxiety as keyof typeof anxietyLabels]}\n \n setAnxiety(parseInt(e.target.value))}\n className=\"w-full h-2 bg-gradient-to-r from-green-400 to-red-400 rounded-lg appearance-none cursor-pointer\"\n />\n

\n 😌 Very Calm\n 😰 Overwhelmed\n

\n\n {/* Activities */}\n

\n Activities\n

\n {activityOptions.map(activity => (\n toggleActivity(activity)}\n className={`px-3 py-2 text-sm rounded-md border transition-colors ${\n activities.includes(activity)\n ? 'bg-blue-500 text-white border-blue-500'\n : 'bg-white text-gray-700 border-gray-300 hover:bg-gray-50'\n }`}\n >\n {activity}\n \n ))}\n

\n\n {/* Notes */}\n

\n Notes (optional)\n setNotes(e.target.value)}\n placeholder=\"How are you feeling today? What's on your mind?\"\n rows={3}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n\n \n {isSubmitting ? 'Saving...' : (todayEntry ? 'Update Entry' : 'Save Entry')}\n \n \n

\n\n {/* Recent Entries */}\n

\n 📈\n Recent Entries\n

\n \n {recentMoods.length === 0 ? (\n

📊

No mood entries yet.

Start tracking your mood to see patterns!

\n ) : (\n

\n {recentMoods.map((entry) => (\n

\n \n {new Date(entry.date).toLocaleDateString()}\n \n

\n \n 😊 {entry.mood}/10\n \n \n ⚡ {entry.energy}/10\n \n \n 😰 {entry.anxiety}/10\n \n

\n \n {entry.activities && entry.activities.length > 0 && (\n

\n {entry.activities.map((activity, idx) => (\n \n {activity}\n \n ))}\n

\n )}\n \n {entry.notes && (\n

{entry.notes}

\n )}\n

\n ))}\n

\n )}\n

\n );\n}",[],[154,235,227],"components","8532b12e-3f7d-11f0-9dcc-76b3cceeab13",["D",1748846878657],[],[154,235,32],"3bb5e4f8-3f7d-11f0-8786-76b3cceeab13","App.tsx","3bb5e5ca-3f7d-11f0-8786-76b3cceeab13",11,["D",1748846755365],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { MoodEntry, JournalEntry, MoodStats } from \"../../shared/types.ts\";\nimport MoodTracker from \"./MoodTracker.tsx\";\nimport Journal from \"./Journal.tsx\";\nimport BreathingExercise from \"./BreathingExercise.tsx\";\nimport Resources from \"./Resources.tsx\";\n\ninterface AppProps {\n initialData: {\n moodStats: MoodStats | null;\n recentMoods: MoodEntry[];\n recentJournals: JournalEntry[];\n };\n}\n\ntype Tab = 'mood' | 'journal' | 'breathing' | 'resources';\n\nexport default function App({ initialData }: AppProps) {\n const [activeTab, setActiveTab] = useState('mood');\n const [moodStats, setMoodStats] = useState(initialData.moodStats);\n const [recentMoods, setRecentMoods] = useState(initialData.recentMoods);\n const [recentJournals, setRecentJournals] = useState(initialData.recentJournals);\n\n const tabs = [\n { id: 'mood' as Tab, name: 'Mood Tracker', icon: '📊', gradient: 'mood-gradient' },\n { id: 'journal' as Tab, name: 'Journal', icon: '📝', gradient: 'journal-gradient' },\n { id: 'breathing' as Tab, name: 'Breathing', icon: '🫁', gradient: 'breathing-gradient' },\n { id: 'resources' as Tab, name: 'Resources', icon: '🆘', gradient: 'resources-gradient' }\n ];\n\n const refreshMoodData = async () => {\n try {\n const [statsRes, moodsRes] = await Promise.all([\n fetch('/api/mood/stats'),\n fetch('/api/mood/recent?limit=7')\n ]);\n \n if (statsRes.ok) {\n const statsData = await statsRes.json();\n if (statsData.success) setMoodStats(statsData.data);\n }\n \n if (moodsRes.ok) {\n const moodsData = await moodsRes.json();\n if (moodsData.success) setRecentMoods(moodsData.data);\n }\n } catch (error) {\n console.error('Error refreshing mood data:', error);\n }\n };\n\n const refreshJournalData = async () => {\n try {\n const response = await fetch('/api/journal?limit=5');\n if (response.ok) {\n const data = await response.json();\n if (data.success) setRecentJournals(data.data);\n }\n } catch (error) {\n console.error('Error refreshing journal data:', error);\n }\n };\n\n return (\n

\n {/* Header */}\n

🧠

Mental Health Support

Your personal wellness companion

\n \n {/* Quick Stats */}\n {moodStats && (\n

{moodStats.streak}

Day Streak

{moodStats.averageMood}

Avg Mood

{moodStats.totalEntries}

Total Entries

\n )}\n

\n\n {/* Navigation Tabs */}\n

\n {tabs.map((tab) => (\n setActiveTab(tab.id)}\n className={`flex items-center space-x-2 py-4 px-2 border-b-2 font-medium text-sm whitespace-nowrap transition-colors ${\n activeTab === tab.id\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n {tab.icon}\n {tab.name}\n \n ))}\n

\n\n {/* Main Content */}\n

\n {activeTab === 'mood' && (\n \n )}\n \n {activeTab === 'journal' && (\n \n )}\n \n {activeTab === 'breathing' && }\n \n {activeTab === 'resources' && }\n

\n\n {/* Footer */}\n \n

\n );\n}",[],[154,235,241],"3bb5f984-3f7d-11f0-8786-76b3cceeab13",["D",1748846755365],[185,186,187],[154,235],["D",1748846718415],[184,188,189],[154],"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;",[],[160,256],"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;",[],[160,271,263],"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;",[],[160,271,273],"0a410074-3f7d-11f0-8525-76b3cceeab13",["D",1748846672389],[180,181],[160,271],"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}",[],[160,293,285],"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}",[],[160,293,295],"ec6a8066-3f7c-11f0-8c0e-76b3cceeab13",["D",1748846622331],[177,178],[160,293],["D",1748846622331],[176,179,182],[160],["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":345,"_346":347,"_348":349,"_350":24,"_351":24,"_352":24,"_353":57,"_354":-5,"_355":-7,"_356":-7,"_357":61,"_358":24,"_359":24,"_360":-5,"_361":24,"_362":24,"_363":24,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":85,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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 · v13