[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_101":100,"_32":51,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_21":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_37":52,"_53":-5,"_54":25,"_55":51,"_56":51,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",5,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","backend/routes","latestPath","fileId","e933c03f-eea5-4333-b80f-c5570cf198a8","name","routes","fileType","directory","content","createdAt",["D",1748856231039],"branchVersion","branchId","01fc47be-3f93-11f0-8152-76b3cceeab13",{"_30":44,"_32":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_24":25},"backend/routes/cycles.ts","4ba7e9ea-3f93-11f0-b1ef-76b3cceeab13","cycles.ts","script","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createCycle, \n updateCycle, \n getCycles, \n getCycleById, \n deleteCycle,\n calculateCyclePrediction \n} from \"../database/queries.ts\";\nimport type { Cycle } from \"../../shared/types.ts\";\n\nconst cycles = new Hono();\n\n// Get all cycles\ncycles.get(\"/\", async (c) => {\n try {\n const cycles = await getCycles();\n return c.json(cycles);\n } catch (error) {\n console.error(\"Error fetching cycles:\", error);\n return c.json({ error: \"Failed to fetch cycles\" }, 500);\n }\n});\n\n// Get cycle by ID\ncycles.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid cycle ID\" }, 400);\n }\n \n const cycle = await getCycleById(id);\n if (!cycle) {\n return c.json({ error: \"Cycle not found\" }, 404);\n }\n \n return c.json(cycle);\n } catch (error) {\n console.error(\"Error fetching cycle:\", error);\n return c.json({ error: \"Failed to fetch cycle\" }, 500);\n }\n});\n\n// Create new cycle\ncycles.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as Omit;\n \n // Validate required fields\n if (!body.start_date || !body.flow_intensity) {\n return c.json({ error: \"start_date and flow_intensity are required\" }, 400);\n }\n \n // Validate flow intensity\n if (!['light', 'medium', 'heavy'].includes(body.flow_intensity)) {\n return c.json({ error: \"flow_intensity must be light, medium, or heavy\" }, 400);\n }\n \n // Validate dates\n const startDate = new Date(body.start_date);\n if (isNaN(startDate.getTime())) {\n return c.json({ error: \"Invalid start_date format\" }, 400);\n }\n \n if (body.end_date) {\n const endDate = new Date(body.end_date);\n if (isNaN(endDate.getTime())) {\n return c.json({ error: \"Invalid end_date format\" }, 400);\n }\n if (endDate < startDate) {\n return c.json({ error: \"end_date cannot be before start_date\" }, 400);\n }\n }\n \n const cycle = await createCycle(body);\n return c.json(cycle, 201);\n } catch (error) {\n console.error(\"Error creating cycle:\", error);\n return c.json({ error: \"Failed to create cycle\" }, 500);\n }\n});\n\n// Update cycle\ncycles.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid cycle ID\" }, 400);\n }\n \n const body = await c.req.json() as Partial;\n \n // Validate flow intensity if provided\n if (body.flow_intensity && !['light', 'medium', 'heavy'].includes(body.flow_intensity)) {\n return c.json({ error: \"flow_intensity must be light, medium, or heavy\" }, 400);\n }\n \n // Validate dates if provided\n if (body.end_date) {\n const endDate = new Date(body.end_date);\n if (isNaN(endDate.getTime())) {\n return c.json({ error: \"Invalid end_date format\" }, 400);\n }\n }\n \n const cycle = await updateCycle(id, body);\n if (!cycle) {\n return c.json({ error: \"Cycle not found\" }, 404);\n }\n \n return c.json(cycle);\n } catch (error) {\n console.error(\"Error updating cycle:\", error);\n return c.json({ error: \"Failed to update cycle\" }, 500);\n }\n});\n\n// Delete cycle\ncycles.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid cycle ID\" }, 400);\n }\n \n const deleted = await deleteCycle(id);\n if (!deleted) {\n return c.json({ error: \"Cycle not found\" }, 404);\n }\n \n return c.json({ message: \"Cycle deleted successfully\" });\n } catch (error) {\n console.error(\"Error deleting cycle:\", error);\n return c.json({ error: \"Failed to delete cycle\" }, 500);\n }\n});\n\n// Get cycle predictions\ncycles.get(\"/predictions/next\", async (c) => {\n try {\n const prediction = await calculateCyclePrediction();\n if (!prediction) {\n return c.json({ error: \"Not enough data for predictions. Need at least 2 completed cycles.\" }, 400);\n }\n \n return c.json(prediction);\n } catch (error) {\n console.error(\"Error calculating predictions:\", error);\n return c.json({ error: \"Failed to calculate predictions\" }, 500);\n }\n});\n\nexport default cycles;",["D",1748856231039],"id","01fbebf2-3f93-11f0-8152-76b3cceeab13","public",["D",1748856107449],"deletedAt","legacyEnvVars","privacy","httpPrivacy","description","imageUrl","e0cf86b0-3f91-11f0-b6e9-ab0b2f88b858","pinnedFileId","62241356-3f93-11f0-9cea-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d6e87c56-bb6b-483c-b32f-76f2cddfffc0","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_49":41,"_92":50,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":51,"_99":100},"isOwned",22,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","MrsJD","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2lVRndKSHcyNENLV0hzZ3lDSzBhY3p4WSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_37":221,"_53":-5,"_54":25,"_55":51,"_56":51,"_57":-5,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":222,"_85":223,"_87":224,"_89":25},"tree",[166,172,174],"files",[166,167,168,169,170,171,172,173,174],"counts",{"_156":67,"_157":138,"_158":67,"_159":160,"_161":162},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":150,"_32":151,"_30":152,"_137":-5,"_40":41,"_39":153,"_139":63,"_37":154,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_27":155},{"_49":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":63,"_37":148,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_27":149},{"_49":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":63,"_37":140,"_13":67,"_34":21,"_36":141,"_24":25,"_142":-5,"_27":143},"1d9c85f6-3f93-11f0-a547-76b3cceeab13","README.md","1d9c86dc-3f93-11f0-a547-76b3cceeab13","parentId",1,"latest",["D",1748856153797],"# Menstrual Cycle Tracker\n\nA comprehensive web application for tracking menstrual cycles, symptoms, and health insights.\n\n## Features\n\n- **Cycle Tracking**: Log period start/end dates and flow intensity\n- **Predictions**: Automatic calculation of next period and fertile window\n- **Symptom Tracking**: Track mood, pain levels, and other symptoms\n- **Calendar View**: Visual calendar showing cycle phases and predictions\n- **Insights**: Cycle length trends and pattern analysis\n- **Data Export**: Download your data as JSON\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│ │ ├── cycles.ts # Cycle CRUD operations\n│ │ ├── symptoms.ts # Symptom tracking\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Calendar.tsx # Calendar view\n│ │ ├── CycleForm.tsx # Period logging form\n│ │ ├── SymptomForm.tsx # Symptom tracking form\n│ │ └── Insights.tsx # Analytics and insights\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React entry point\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app will automatically create the database tables on first run\n2. Navigate to the main page to start tracking your cycle\n3. Use the calendar view to see predictions and cycle phases\n4. Track symptoms daily for better insights\n\n## Data Privacy\n\nAll data is stored locally in your Val Town SQLite database. No data is shared with third parties.","label",[135],"23a42a76-3f93-11f0-8ca0-76b3cceeab13","shared","3a033f41-7722-4edf-8117-47d5adc79182",2,["D",1748856163909],[145],"286874f4-3f93-11f0-9177-76b3cceeab13","backend","8210e1b0-7271-4e6c-a8be-c5950e58a310",3,["D",1748856171907],[151],"pulls","branches","forks","envVars",{"_163":67,"_165":67},"connections",{"_163":67,"_164":67},"count","unfilledCount","emptyCount",{"_49":150,"_32":151,"_30":152,"_137":-5,"_40":41,"_39":153,"_139":63,"_37":218,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_176":219,"_27":220},{"_49":214,"_32":206,"_30":200,"_137":152,"_40":41,"_39":153,"_139":63,"_37":215,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_176":216,"_27":217},{"_49":207,"_32":208,"_30":209,"_137":200,"_40":41,"_39":153,"_139":63,"_37":210,"_13":67,"_34":46,"_36":211,"_24":25,"_142":-5,"_176":212,"_27":213},{"_49":197,"_32":198,"_30":199,"_137":200,"_40":41,"_39":201,"_139":63,"_37":202,"_13":67,"_34":46,"_36":203,"_24":25,"_142":-5,"_176":204,"_27":205},{"_49":193,"_32":33,"_30":31,"_137":152,"_40":41,"_39":14,"_139":63,"_37":194,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_176":195,"_27":196},{"_49":189,"_32":45,"_30":44,"_137":31,"_40":41,"_39":14,"_139":63,"_37":190,"_13":67,"_34":46,"_36":47,"_24":25,"_142":-5,"_176":191,"_27":192},{"_49":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":63,"_37":186,"_13":67,"_34":35,"_36":-5,"_24":25,"_142":-5,"_176":187,"_27":188},{"_49":179,"_32":180,"_30":181,"_137":146,"_40":41,"_39":147,"_139":63,"_37":182,"_13":67,"_34":46,"_36":183,"_24":25,"_142":-5,"_176":184,"_27":185},{"_49":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":63,"_37":175,"_13":67,"_34":21,"_36":141,"_24":25,"_142":-5,"_176":177,"_27":178},["D",1748856153797],"children",[],[135],"23a422d8-3f93-11f0-8ca0-76b3cceeab13","types.ts","23a423a0-3f93-11f0-8ca0-76b3cceeab13",["D",1748856163909],"// Shared types for menstrual cycle tracking app\n\nexport interface Cycle {\n id?: number;\n start_date: string; // ISO date string\n end_date?: string; // ISO date string, null if ongoing\n flow_intensity: 'light' | 'medium' | 'heavy';\n notes?: string;\n created_at?: string;\n}\n\nexport interface Symptom {\n id?: number;\n date: string; // ISO date string\n mood: number; // 1-5 scale\n pain_level: number; // 1-5 scale\n energy_level: number; // 1-5 scale\n sleep_quality: number; // 1-5 scale\n symptoms: string[]; // Array of symptom names\n notes?: string;\n created_at?: string;\n}\n\nexport interface CyclePrediction {\n next_period_start: string;\n next_period_end: string;\n fertile_window_start: string;\n fertile_window_end: string;\n ovulation_date: string;\n cycle_length: number;\n period_length: number;\n}\n\nexport interface CycleInsights {\n average_cycle_length: number;\n average_period_length: number;\n cycle_regularity: 'regular' | 'irregular' | 'unknown';\n most_common_symptoms: string[];\n mood_trends: { date: string; mood: number }[];\n pain_trends: { date: string; pain: number }[];\n}\n\nexport interface CalendarDay {\n date: string;\n is_period: boolean;\n is_predicted_period: boolean;\n is_fertile: boolean;\n is_ovulation: boolean;\n flow_intensity?: 'light' | 'medium' | 'heavy';\n symptoms?: Symptom;\n}\n\nexport const SYMPTOM_OPTIONS = [\n 'Cramps',\n 'Bloating',\n 'Headache',\n 'Breast tenderness',\n 'Acne',\n 'Food cravings',\n 'Fatigue',\n 'Mood swings',\n 'Nausea',\n 'Back pain',\n 'Constipation',\n 'Diarrhea',\n 'Hot flashes',\n 'Insomnia'\n] as const;\n\nexport type SymptomOption = typeof SYMPTOM_OPTIONS[number];",[],[145,180],["D",1748856163909],[173],[145],"4ba7e936-3f93-11f0-b1ef-76b3cceeab13",["D",1748856231039],[],[151,33,45],"4ba7faca-3f93-11f0-b1ef-76b3cceeab13",["D",1748856231039],[171],[151,33],"3f85f594-3f93-11f0-b922-76b3cceeab13","queries.ts","3f85f65c-3f93-11f0-b922-76b3cceeab13","194ba6ba-e660-42d6-821d-a4eec3ab11cf",4,["D",1748856210691],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { CYCLES_TABLE, SYMPTOMS_TABLE } from \"./migrations.ts\";\nimport type { Cycle, Symptom, CyclePrediction, CycleInsights } from \"../../shared/types.ts\";\n\n// Cycle queries\nexport async function createCycle(cycle: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${CYCLES_TABLE} (start_date, end_date, flow_intensity, notes) \n VALUES (?, ?, ?, ?) RETURNING *`,\n [cycle.start_date, cycle.end_date || null, cycle.flow_intensity, cycle.notes || null]\n );\n return result[0] as Cycle;\n}\n\nexport async function updateCycle(id: number, updates: Partial): Promise {\n const setClauses = [];\n const values = [];\n \n if (updates.end_date !== undefined) {\n setClauses.push('end_date = ?');\n values.push(updates.end_date);\n }\n if (updates.flow_intensity) {\n setClauses.push('flow_intensity = ?');\n values.push(updates.flow_intensity);\n }\n if (updates.notes !== undefined) {\n setClauses.push('notes = ?');\n values.push(updates.notes);\n }\n \n if (setClauses.length === 0) return null;\n \n values.push(id);\n const result = await sqlite.execute(\n `UPDATE ${CYCLES_TABLE} SET ${setClauses.join(', ')} WHERE id = ? RETURNING *`,\n values\n );\n \n return result[0] as Cycle || null;\n}\n\nexport async function getCycles(limit = 50): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CYCLES_TABLE} ORDER BY start_date DESC LIMIT ?`,\n [limit]\n );\n return result as Cycle[];\n}\n\nexport async function getCycleById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CYCLES_TABLE} WHERE id = ?`,\n [id]\n );\n return result[0] as Cycle || null;\n}\n\nexport async function deleteCycle(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CYCLES_TABLE} WHERE id = ?`,\n [id]\n );\n return result.length > 0;\n}\n\n// Symptom queries\nexport async function createOrUpdateSymptom(symptom: Omit): Promise {\n const symptomsJson = JSON.stringify(symptom.symptoms || []);\n \n const result = await sqlite.execute(\n `INSERT OR REPLACE INTO ${SYMPTOMS_TABLE} \n (date, mood, pain_level, energy_level, sleep_quality, symptoms, notes) \n VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [\n symptom.date,\n symptom.mood,\n symptom.pain_level,\n symptom.energy_level,\n symptom.sleep_quality,\n symptomsJson,\n symptom.notes || null\n ]\n );\n \n const returned = result[0] as any;\n return {\n ...returned,\n symptoms: JSON.parse(returned.symptoms || '[]')\n };\n}\n\nexport async function getSymptoms(startDate?: string, endDate?: string): Promise {\n let query = `SELECT * FROM ${SYMPTOMS_TABLE}`;\n const params = [];\n \n if (startDate && endDate) {\n query += ` WHERE date BETWEEN ? AND ?`;\n params.push(startDate, endDate);\n } else if (startDate) {\n query += ` WHERE date >= ?`;\n params.push(startDate);\n }\n \n query += ` ORDER BY date DESC`;\n \n const result = await sqlite.execute(query, params);\n return result.map((row: any) => ({\n ...row,\n symptoms: JSON.parse(row.symptoms || '[]')\n })) as Symptom[];\n}\n\nexport async function getSymptomByDate(date: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SYMPTOMS_TABLE} WHERE date = ?`,\n [date]\n );\n \n if (!result[0]) return null;\n \n const row = result[0] as any;\n return {\n ...row,\n symptoms: JSON.parse(row.symptoms || '[]')\n };\n}\n\n// Analytics and predictions\nexport async function calculateCyclePrediction(): Promise {\n const cycles = await getCycles(6); // Get last 6 cycles for prediction\n \n if (cycles.length < 2) return null;\n \n // Calculate average cycle length\n const completedCycles = cycles.filter(c => c.end_date);\n if (completedCycles.length < 2) return null;\n \n const cycleLengths = [];\n const periodLengths = [];\n \n for (let i = 0; i < completedCycles.length - 1; i++) {\n const current = new Date(completedCycles[i].start_date);\n const next = new Date(completedCycles[i + 1].start_date);\n const cycleLength = Math.abs((current.getTime() - next.getTime()) / (1000 * 60 * 60 * 24));\n cycleLengths.push(cycleLength);\n }\n \n completedCycles.forEach(cycle => {\n if (cycle.end_date) {\n const start = new Date(cycle.start_date);\n const end = new Date(cycle.end_date);\n const periodLength = Math.abs((end.getTime() - start.getTime()) / (1000 * 60 * 60 * 24)) + 1;\n periodLengths.push(periodLength);\n }\n });\n \n const avgCycleLength = Math.round(cycleLengths.reduce((a, b) => a + b, 0) / cycleLengths.length);\n const avgPeriodLength = Math.round(periodLengths.reduce((a, b) => a + b, 0) / periodLengths.length);\n \n // Predict next period based on last cycle\n const lastCycle = cycles[0];\n const lastPeriodStart = new Date(lastCycle.start_date);\n \n const nextPeriodStart = new Date(lastPeriodStart);\n nextPeriodStart.setDate(nextPeriodStart.getDate() + avgCycleLength);\n \n const nextPeriodEnd = new Date(nextPeriodStart);\n nextPeriodEnd.setDate(nextPeriodEnd.getDate() + avgPeriodLength - 1);\n \n // Calculate fertile window (typically 5 days before ovulation + ovulation day)\n const ovulationDate = new Date(nextPeriodStart);\n ovulationDate.setDate(ovulationDate.getDate() - 14); // Ovulation typically 14 days before period\n \n const fertileStart = new Date(ovulationDate);\n fertileStart.setDate(fertileStart.getDate() - 5);\n \n const fertileEnd = new Date(ovulationDate);\n fertileEnd.setDate(fertileEnd.getDate() + 1);\n \n return {\n next_period_start: nextPeriodStart.toISOString().split('T')[0],\n next_period_end: nextPeriodEnd.toISOString().split('T')[0],\n fertile_window_start: fertileStart.toISOString().split('T')[0],\n fertile_window_end: fertileEnd.toISOString().split('T')[0],\n ovulation_date: ovulationDate.toISOString().split('T')[0],\n cycle_length: avgCycleLength,\n period_length: avgPeriodLength\n };\n}\n\nexport async function getCycleInsights(): Promise {\n const cycles = await getCycles();\n const symptoms = await getSymptoms();\n \n // Calculate cycle statistics\n const completedCycles = cycles.filter(c => c.end_date);\n const cycleLengths = [];\n const periodLengths = [];\n \n for (let i = 0; i < completedCycles.length - 1; i++) {\n const current = new Date(completedCycles[i].start_date);\n const next = new Date(completedCycles[i + 1].start_date);\n const cycleLength = Math.abs((current.getTime() - next.getTime()) / (1000 * 60 * 60 * 24));\n cycleLengths.push(cycleLength);\n }\n \n completedCycles.forEach(cycle => {\n if (cycle.end_date) {\n const start = new Date(cycle.start_date);\n const end = new Date(cycle.end_date);\n const periodLength = Math.abs((end.getTime() - start.getTime()) / (1000 * 60 * 60 * 24)) + 1;\n periodLengths.push(periodLength);\n }\n });\n \n const avgCycleLength = cycleLengths.length > 0 \n ? cycleLengths.reduce((a, b) => a + b, 0) / cycleLengths.length \n : 0;\n \n const avgPeriodLength = periodLengths.length > 0\n ? periodLengths.reduce((a, b) => a + b, 0) / periodLengths.length\n : 0;\n \n // Determine regularity\n const cycleVariation = cycleLengths.length > 1\n ? Math.max(...cycleLengths) - Math.min(...cycleLengths)\n : 0;\n \n let regularity: 'regular' | 'irregular' | 'unknown' = 'unknown';\n if (cycleLengths.length >= 3) {\n regularity = cycleVariation <= 7 ? 'regular' : 'irregular';\n }\n \n // Most common symptoms\n const allSymptoms = symptoms.flatMap(s => s.symptoms || []);\n const symptomCounts = allSymptoms.reduce((acc, symptom) => {\n acc[symptom] = (acc[symptom] || 0) + 1;\n return acc;\n }, {} as Record);\n \n const mostCommonSymptoms = Object.entries(symptomCounts)\n .sort(([,a], [,b]) => b - a)\n .slice(0, 5)\n .map(([symptom]) => symptom);\n \n // Mood and pain trends (last 30 days)\n const thirtyDaysAgo = new Date();\n thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);\n const recentSymptoms = symptoms.filter(s => new Date(s.date) >= thirtyDaysAgo);\n \n const moodTrends = recentSymptoms\n .filter(s => s.mood)\n .map(s => ({ date: s.date, mood: s.mood }))\n .sort((a, b) => a.date.localeCompare(b.date));\n \n const painTrends = recentSymptoms\n .filter(s => s.pain_level)\n .map(s => ({ date: s.date, pain: s.pain_level }))\n .sort((a, b) => a.date.localeCompare(b.date));\n \n return {\n average_cycle_length: Math.round(avgCycleLength * 10) / 10,\n average_period_length: Math.round(avgPeriodLength * 10) / 10,\n cycle_regularity: regularity,\n most_common_symptoms: mostCommonSymptoms,\n mood_trends: moodTrends,\n pain_trends: painTrends\n };\n}",[],[151,206,198],"database","28686a0e-3f93-11f0-9177-76b3cceeab13","migrations.ts","28686ac2-3f93-11f0-9177-76b3cceeab13",["D",1748856171907],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst CYCLES_TABLE = 'menstrual_cycles_v1';\nconst SYMPTOMS_TABLE = 'cycle_symptoms_v1';\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n \n // Create cycles table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CYCLES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n start_date TEXT NOT NULL,\n end_date TEXT,\n flow_intensity TEXT NOT NULL CHECK (flow_intensity IN ('light', 'medium', 'heavy')),\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create symptoms table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SYMPTOMS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL UNIQUE,\n mood INTEGER CHECK (mood >= 1 AND mood <= 5),\n pain_level INTEGER CHECK (pain_level >= 1 AND pain_level <= 5),\n energy_level INTEGER CHECK (energy_level >= 1 AND energy_level <= 5),\n sleep_quality INTEGER CHECK (sleep_quality >= 1 AND sleep_quality <= 5),\n symptoms TEXT, -- JSON array of symptom names\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed');\n}\n\nexport { CYCLES_TABLE, SYMPTOMS_TABLE };",[],[151,206,208],"286876d4-3f93-11f0-9177-76b3cceeab13",["D",1748856171907],[168,169],[151,206],["D",1748856171907],[167,170],[151],["D",1748856107449],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":59,"_105":106,"_107":25},{"_13":90,"_32":91,"_49":41,"_92":50,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":51,"_99":100},"ctx",{"_83":-5,"_128":258,"_259":260,"_261":262,"_263":25,"_264":25,"_265":25,"_266":63,"_267":-5,"_268":-7,"_269":-7,"_270":67,"_271":25,"_272":25,"_273":-5,"_274":25,"_275":25,"_276":25,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":91,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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 · v5