\n \n

{title}

\n Range: {monthStart} → {monthEnd} {includePartialWeeks ? \"(partial weeks included)\" : \"(full weeks only)\"}\n

\n {/* Month navigation is query-string driven for shareable URLs. */}\n \n

\n\n {/* Main content: two summary cards */}\n

Blood Sugar

\n \n \n \n \n \n \n \n

\n {(bloodSugar.badges.length ? bloodSugar.badges : [\"No badges yet\"]).map((badge) => (\n \n {badge}\n \n ))}\n

\n\n

Food Log

\n \n \n \n \n \n \n \n

\n Macro averages (per entry)\n {Object.keys(food.macroSummary).length === 0 &&

No macro data yet.

}\n {Object.entries(food.macroSummary).map(([key, value]) => (\n

\n {key}\n {value.avg}\n

\n ))}\n

\n\n

\n Praise Cage mode: keep logging, keep winning. Data from weekly rollups stored in Val Town SQLite.\n

\n \n \n \n );\n}\n\nfunction Stat(props: { label: string; value: string | number }) {\n return (\n

\n {props.label}\n {props.value}\n

\n );\n}\n\n// Build the month dropdown from the first data year through the current month.\nfunction buildMonthOptions(startYear: number, now: Date): string[] {\n const options: string[] = [];\n const start = new Date(Date.UTC(startYear, 0, 1));\n const end = new Date(Date.UTC(now.getUTCFullYear(), now.getUTCMonth(), 1));\n if (end < start) {\n return [formatMonth(start)];\n }\n for (let cursor = start; cursor <= end; cursor = addMonths(cursor, 1)) {\n options.push(formatMonth(cursor));\n }\n return options;\n}\n\n// Use the query string if valid, otherwise default to last month.\nfunction resolveSelectedMonth(monthParam: string | null, now: Date, startYear: number): string {\n const minMonth = `${startYear}-01`;\n if (monthParam && /^\\d{4}-\\d{2}$/.test(monthParam)) {\n return monthParam < minMonth ? minMonth : monthParam;\n }\n const year = now.getUTCFullYear();\n const month = now.getUTCMonth();\n const previous = new Date(Date.UTC(year, month - 1, 1));\n const fallback = formatMonth(previous);\n return fallback < minMonth ? minMonth : fallback;\n}\n\n// Format a Date as YYYY-MM for query params and dropdown values.\nfunction formatMonth(date: Date): string {\n const year = date.getUTCFullYear();\n const month = String(date.getUTCMonth() + 1).padStart(2, \"0\");\n return `${year}-${month}`;\n}\n\n// Date helper for iterating month-by-month.\nfunction addMonths(date: Date, amount: number): Date {\n return new Date(Date.UTC(date.getUTCFullYear(), date.getUTCMonth() + amount, 1));\n}\n",[],[203,393],["D",1768499628695],[239,240],[203],"7950f6a4-f4c7-11f0-bc98-42dde27851f2","food_report.cron.tsx","f851115a-f233-11f0-a807-42dde27851f2",366,["D",1768779801942],28,"interval","import { getWeeklyRange } from \"../shared/date.ts\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { fetchNotionPages, type NotionPage, updateNotionPage } from \"../shared/notion.ts\";\nimport {\n buildNutritionPrompt,\n buildNutritionProperties,\n buildFoodRollup,\n coerceMacros,\n roundNumber,\n type Entry,\n type MacroKey,\n parseEntry,\n PROPERTY_NAMES,\n safeParseJson,\n shouldEnrich,\n} from \"../shared/food_enrich.ts\";\nimport { fetchFatsecretNutrition, type FatsecretConfig } from \"../shared/fatsecret.ts\";\nimport { initRollupSchema, upsertWeeklyRollup } from \"../storage/rollups.ts\";\n\ntype NotionConfig = {\n token: string;\n databaseId: string;\n};\n\nexport default async function () {\n // Resolve configs and hydrate external clients first to fail fast.\n const notionConfig = getNotionConfig();\n if (!notionConfig) {\n return new Response(\"Missing Notion secrets.\", { status: 500 });\n }\n const openai = new OpenAI();\n const fatsecretConfig = getFatsecretConfig();\n\n const { start, end } = getWeeklyRange();\n const entries = await fetchEntries(start, end, notionConfig);\n console.log(`Food entries ${start} to ${end}:`, entries);\n\n let enriched = 0;\n for (const entry of entries) {\n // Only enrich entries missing core macros to avoid overwriting manual edits.\n if (!entry.food || entry.food === \"Unknown\") continue;\n const shouldEnrichEntry = shouldEnrich(entry);\n const shouldCompare = fatsecretConfig?.compareAlways ?? false;\n if (!shouldEnrichEntry && !shouldCompare) continue;\n const openaiResult = await fetchNutritionOpenAI(entry.food, openai);\n const fatsecretResult = fatsecretConfig\n ? await fetchFatsecretNutrition(entry.food, fatsecretConfig)\n : null;\n\n if (fatsecretConfig) {\n const comparison = buildMacroComparison(openaiResult?.macros ?? null, fatsecretResult);\n console.log(\"Nutrition comparison\", {\n pageId: entry.pageId,\n food: entry.food,\n loggedAt: entry.loggedAt,\n openai: openaiResult?.macros ?? null,\n fatsecret: fatsecretResult,\n diff: comparison,\n });\n }\n\n if (!shouldEnrichEntry) continue;\n const mergedMacros = mergeMacros(fatsecretResult, openaiResult?.macros ?? null);\n if (!mergedMacros) continue;\n const properties = buildNutritionProperties(mergedMacros);\n if (!Object.keys(properties).length) continue;\n console.log(\"Enriching entry\", {\n pageId: entry.pageId,\n food: entry.food,\n loggedAt: entry.loggedAt,\n macros: mergedMacros,\n });\n console.log(\"Notion update properties\", {\n pageId: entry.pageId,\n properties,\n });\n await updateNotionPage(entry.pageId, notionConfig.token, properties);\n entry.macros = { ...entry.macros, ...mergedMacros };\n enriched += 1;\n }\n\n await initRollupSchema();\n const rollup = buildFoodRollup(entries, start, end);\n await upsertWeeklyRollup(rollup);\n\n return new Response(`Weekly food entries logged. Enriched ${enriched}.`, { status: 200 });\n}\n\nfunction getNotionConfig(): NotionConfig | null {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const databaseId = Deno.env.get(\"NOTION_FOOD_DB_ID\");\n if (!token || !databaseId) return null;\n return { token, databaseId };\n}\n\nfunction getFatsecretConfig(): FatsecretConfig | null {\n const accessToken = Deno.env.get(\"FATSECRET_ACCESS_TOKEN\");\n if (!accessToken) return null;\n const includeFoodDataValue = Deno.env.get(\"FATSECRET_INCLUDE_FOOD_DATA\");\n const includeFoodData = includeFoodDataValue\n ? includeFoodDataValue.trim().toLowerCase() === \"true\"\n : true;\n const compareAlwaysValue = Deno.env.get(\"FATSECRET_COMPARE_ALWAYS\");\n const compareAlways = compareAlwaysValue\n ? compareAlwaysValue.trim().toLowerCase() === \"true\"\n : false;\n return { accessToken, includeFoodData, compareAlways };\n}\n\nasync function fetchEntries(start: string, end: string, config: NotionConfig): Promise {\n // Pull just the last-week window to keep the Notion query fast.\n const pages = await fetchNotionPages(config.databaseId, config.token, (cursor) => ({\n filter: {\n and: [\n { property: PROPERTY_NAMES.loggedAt, date: { on_or_after: start } },\n { property: PROPERTY_NAMES.loggedAt, date: { on_or_before: end } },\n ],\n },\n sorts: [{ property: PROPERTY_NAMES.loggedAt, direction: \"ascending\" }],\n ...(cursor ? { start_cursor: cursor } : {}),\n }));\n\n const entries: Entry[] = [];\n for (const page of pages) {\n const entry = parseEntry(page);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\nasync function fetchNutritionOpenAI(\n foodName: string,\n openai: OpenAI,\n): Promise<{\n macros: Partial>;\n} | null> {\n // Ask the model for a strict JSON payload and coerce to numeric fields.\n const prompt = buildNutritionPrompt(foodName);\n // Keep the OpenAI request compact to control costs.\n\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n {\n role: \"system\",\n content:\n \"You estimate nutrition macros from short food descriptions. \" +\n \"Respond with a single JSON object with numeric fields: \" +\n \"calories, protein, carbs, fat, fiber, sugar, sodium. \" +\n \"Use grams for macros and milligrams for sodium. \" +\n \"If unsure, make a reasonable estimate. No extra text.\",\n },\n { role: \"user\", content: prompt },\n ],\n max_tokens: 120,\n });\n\n const text = completion.choices[0]?.message?.content?.trim();\n if (!text) return null;\n const parsed = safeParseJson(text);\n if (!parsed || typeof parsed !== \"object\") return null;\n const macros = coerceMacros(parsed as Record);\n if (!Object.keys(macros).length) return null;\n return { macros };\n}\n\nfunction mergeMacros(\n primary: Partial> | null,\n secondary: Partial> | null,\n): Partial> | null {\n if (!primary && !secondary) return null;\n const merged: Partial> = {};\n for (const key of Object.keys(PROPERTY_NAMES.macros) as MacroKey[]) {\n if (primary && typeof primary[key] === \"number\") {\n merged[key] = primary[key];\n continue;\n }\n if (secondary && typeof secondary[key] === \"number\") {\n merged[key] = secondary[key];\n }\n }\n return Object.keys(merged).length ? merged : null;\n}\n\nfunction buildMacroComparison(\n openai: Partial> | null,\n fatsecret: Partial> | null,\n): Partial> | null {\n if (!openai || !fatsecret) return null;\n const diff: Partial> = {};\n for (const key of Object.keys(PROPERTY_NAMES.macros) as MacroKey[]) {\n const openaiValue = openai[key];\n const fatsecretValue = fatsecret[key];\n if (typeof openaiValue !== \"number\" || typeof fatsecretValue !== \"number\") continue;\n diff[key] = roundNumber(fatsecretValue - openaiValue);\n }\n return Object.keys(diff).length ? diff : null;\n}\n",[],[209,405],"4f53f136-f4c6-11f0-b407-42dde27851f2","blood_sugar_report.cron.tsx","905c839c-f0bf-11f0-b356-42dde27851f2",358,["D",1768779301679],53,"import { email } from \"https://esm.town/v/std/email\";\nimport { getWeeklyRange, listDateRange } from \"../shared/date.ts\";\nimport { fetchNotionPages } from \"../shared/notion.ts\";\nimport { initRollupSchema, upsertWeeklyRollup } from \"../storage/rollups.ts\";\nimport {\n buildEncouragement,\n buildBloodSugarRollup,\n formatGroupedEntryLine,\n groupEntriesByDate,\n parseEntry,\n type GroupedEntries,\n type BloodSugarNotionPage,\n type Entry,\n hasPerfectWeekStreak,\n} from \"../shared/blood_sugar_logic.ts\";\n\nexport default async function handler(): Promise {\n const notionConfig = getNotionConfig();\n\n if (!notionConfig) {\n return new Response(\"Missing required secrets.\", { status: 500 });\n }\n\n // Use a fixed 7-day range ending today (UTC) for weekly rollups.\n const { start, end } = getWeeklyRange();\n console.log(`Weekly range: ${start} to ${end}`);\n const entries = await fetchEntries(start, end, notionConfig);\n console.log(`Fetched ${entries.length} entries from Notion`);\n const report = buildReport(entries, start, end);\n console.log(\"Report subject:\", report.subject);\n console.log(\"Sending email to Val Town account owner (free tier default).\");\n\n // Build the payload to match Val Town's std/email expectations.\n const emailPayload = {\n subject: report.subject,\n text: report.text,\n html: report.html,\n };\n\n await email(emailPayload);\n console.log(\"Email sent.\");\n\n await initRollupSchema();\n await upsertWeeklyRollup(report.rollup);\n\n return new Response(\"Weekly report sent.\", { status: 200 });\n}\n\ntype NotionConfig = {\n token: string;\n databaseId: string;\n};\n\nfunction getNotionConfig(): NotionConfig | null {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const databaseId = Deno.env.get(\"NOTION_BLOOD_SUGAR_DB_ID\");\n if (!token || !databaseId) return null;\n return { token, databaseId };\n}\n\nexport async function fetchEntries(\n start: string,\n end: string,\n notionConfig: NotionConfig,\n): Promise {\n const pages = await fetchNotionPages(notionConfig.databaseId, notionConfig.token, (cursor) => ({\n filter: {\n and: [\n { property: \"Measurement Date\", date: { on_or_after: start } },\n { property: \"Measurement Date\", date: { on_or_before: end } },\n ],\n },\n sorts: [{ property: \"Measurement Date\", direction: \"ascending\" }],\n ...(cursor ? { start_cursor: cursor } : {}),\n }));\n\n const entries: Entry[] = [];\n for (const page of pages) {\n const entry = parseEntry(page);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\nexport function buildReport(entries: Entry[], start: string, end: string) {\n // Compute summary stats and derive copy for email-friendly output.\n // Summary stats for the weekly rollup.\n const rollup = buildBloodSugarRollup(entries, start, end);\n const subject = `Blood Sugar Weekly Rollup (${start} → ${end})`;\n const dateRange = listDateRange(start, end);\n const groupedEntries = groupEntriesByDate(entries, dateRange);\n const encouragement = buildEncouragement(rollup.completionRate, rollup.streak);\n const disclaimer =\n \"Not medical advice. Educational info only. Source: https://www.ynhhs.org/articles/what-is-healthy-blood-sugar\";\n\n const lines = [\n `Range: ${start} to ${end}`,\n `Entries: ${rollup.stats.totalEntries} (expected ${rollup.stats.expected}, missing ${rollup.stats.missing})`,\n `Average: ${rollup.stats.avg}`,\n `Min: ${rollup.stats.min}`,\n `Max: ${rollup.stats.max}`,\n `Completion: ${rollup.completionRate}%`,\n `Current streak: ${rollup.streak} day${rollup.streak === 1 ? \"\" : \"s\"}`,\n `Perfect week streak: ${hasPerfectWeekStreak(dateRange, rollup.stats.entriesByDate) ? \"Yes\" : \"No\"}`,\n `XP earned: ${rollup.xp}`,\n `Badges: ${rollup.badges.length ? rollup.badges.join(\", \") : \"No badges yet\"}`,\n `Encouragement: ${encouragement}`,\n `Disclaimer: ${disclaimer}`,\n \"\",\n \"Entries:\",\n ...groupedEntries.map(formatGroupedEntryLine),\n ];\n\n const text = lines.join(\"\\n\");\n const html = renderHtmlReport(groupedEntries, {\n start,\n end,\n count: rollup.stats.totalEntries,\n expected: rollup.stats.expected,\n missing: rollup.stats.missing,\n avg: rollup.stats.avg,\n min: rollup.stats.min,\n max: rollup.stats.max,\n completionRate: rollup.completionRate,\n currentStreak: rollup.streak,\n badges: rollup.badges,\n encouragement,\n disclaimer,\n xp: rollup.xp,\n perfectWeekStreak: hasPerfectWeekStreak(dateRange, rollup.stats.entriesByDate),\n });\n\n return { subject, text, html, rollup };\n}\n\nfunction formatFirstSecondHtml(group: GroupedEntries): [string, string] {\n const ordered = orderEntries(group);\n if (!ordered.length) return [\"—\", \"—\"];\n const first = String(ordered[0].value);\n if (ordered.length === 1) return [first, \"—\"];\n const secondValue = String(ordered[1].value);\n const overflow = ordered.length > 2 ? ` (+${ordered.length - 2})` : \"\";\n return [first, `${secondValue}${overflow}`];\n}\n\nfunction orderEntries(group: GroupedEntries): Entry[] {\n const combined = [...group.am, ...group.pm];\n return combined.sort((a, b) => {\n const aMinutes = parseTimeToMinutes(a.createdTime);\n const bMinutes = parseTimeToMinutes(b.createdTime);\n if (aMinutes === null && bMinutes === null) return 0;\n if (aMinutes === null) return 1;\n if (bMinutes === null) return -1;\n return aMinutes - bMinutes;\n });\n}\n\nfunction parseTimeToMinutes(value: string | null): number | null {\n if (!value) return null;\n const match = value.match(/(\\d{1,2}):(\\d{2})\\s*([AP]M)/i);\n if (!match) return null;\n let hours = Number(match[1]);\n const minutes = Number(match[2]);\n const meridiem = match[3].toUpperCase();\n if (meridiem === \"PM\" && hours < 12) hours += 12;\n if (meridiem === \"AM\" && hours === 12) hours = 0;\n return hours * 60 + minutes;\n}\n\nexport function renderHtmlReport(\n groupedEntries: GroupedEntries[],\n stats: {\n start: string;\n end: string;\n count: number;\n expected: number;\n missing: number;\n avg: number;\n min: number;\n max: number;\n completionRate: number;\n currentStreak: number;\n badges: string[];\n encouragement: string;\n disclaimer: string;\n xp: number;\n perfectWeekStreak: boolean;\n },\n): string {\n // Simple HTML table for quick scanning in email clients.\n const rows = groupedEntries\n .map((group) => {\n const [first, second] = formatFirstSecondHtml(group);\n return `\n ${group.date}\n ${escapeHtml(first)}\n ${escapeHtml(second)}\n `;\n })\n .join(\"\");\n\n return `\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Blood Sugar Weekly Rollup

${stats.start} to ${stats.end}

\n 🔺 🔷 〰️ 🟢 〰️ 🔶 〰️ 🟡 〰️ 🟣 🔺 🔵 〰️\n

\n \n \n \n \n \n \n

Avg

${stats.avg}

Min

${stats.min}

Max

${stats.max}

\n \n \n \n \n \n \n \n \n \n

\n \n Entries \n ${stats.count}/${stats.expected} \n \n	\n \n Completion \n ${stats.completionRate}% \n \n
\n \n Streak \n ${stats.currentStreak} day${stats.currentStreak === 1 ? \"\" : \"s\"} \n \n	\n \n XP \n ${stats.xp} \n \n

\n Perfect Week Streak: ${stats.perfectWeekStreak ? \"Yes\" : \"No\"}\n

\n Badges:\n

\n ${\n stats.badges.length\n ? stats.badges\n .map(\n (badge) =>\n `${escapeHtml(badge)}`,\n )\n .join(\"\")\n : `No badges yet`\n }\n

\n ${escapeHtml(stats.encouragement)}\n

\n ${escapeHtml(stats.disclaimer)}\n

\n Entries\n

\n \n \n \n \n \n \n \n \n \n ${rows || ``}\n \n

Date	1st	2nd
No entries

\n `;\n}\n\nexport function escapeHtml(value: string): string {\n return value\n .replaceAll(\"&\", \"&\")\n .replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\")\n .replaceAll('\"', \""\")\n .replaceAll(\"'\", \"'\");\n}\n",[],[209,415],["D",1768499629095],[236,237],[209],"2de47576-f23b-11f0-a135-42dde27851f2","settings.json","2de4762a-f23b-11f0-a135-42dde27851f2",228,["D",1768499643522],"{\n \"deno.enable\": true,\n \"deno.enablePaths\": [\"./\"]\n }",[],[215,427],"2de68492-f23b-11f0-93cf-42dde27851f2","extensions.json","2de68528-f23b-11f0-93cf-42dde27851f2",229,["D",1768499643540],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[215,435],["D",1768499629401],[233,234],[215],["D",1768332030028],["D",1789516910456],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_124":483,"_484":485,"_486":487,"_488":25,"_489":25,"_490":25,"_491":122,"_492":-5,"_493":-7,"_494":-7,"_495":60,"_496":25,"_497":25,"_498":-5,"_499":25,"_500":25,"_501":25,"_502":-5},"ENV",{"_454":455,"_456":457,"_458":87,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v369