[{"_1":2,"_181":-5,"_182":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e9e636d7b466d0cb012ac9b89f74068c1d9c5525","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_155":156,"_178":179,"_180":-5},"handle","pchinjr","name","notion_weekly_report","path","shared/food_enrich.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":74,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":33,"_14":119,"_120":121,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","ec7452dc-f0b4-11f0-a3b9-42dde27851f2","createdAt",["D",1768332030028],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","40e69d1a-3254-4858-920b-7b1449761575","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","54bae3d1-8223-41e5-b22d-81eb28a263c7","tursoName","ec7452dcf0b411f0a3b942dde27851f2","tursoHostname","ec7452dcf0b411f0a3b942dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2OaSpooJk6yZ5KFqyjtIVA4z3SH.jpeg","org",{"_95":96,"_138":135,"_12":113,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},"version",648,"ec74b2b8-f0b4-11f0-a3b9-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":157,"_97":158,"_159":160,"_161":162,"_163":145,"_164":165,"_166":167,"_105":168,"_143":169,"_170":171,"_172":173,"_174":20,"_175":-5,"_99":176},"fe2fb036-f328-11f0-b456-42dde27851f2","food_enrich.ts","fileId","659ce588-f309-11f0-b22d-42dde27851f2","parentId","25688b9e-f23b-11f0-a33f-42dde27851f2","branchId","branchVersion",355,"latest",true,["D",1768601783718],6,"fileType","script","content","import {\n type NotionCreatedTimeProperty,\n type NotionDateProperty,\n type NotionNumberProperty,\n type NotionPage,\n type NotionTextProperty,\n type NotionTitleProperty,\n} from \"./notion.ts\";\nimport { calculateCurrentStreak, countEntriesByDate, listDateRange } from \"./date.ts\";\n\n// Macro keys and entry types for the food log.\nexport type MacroKey = \"calories\" | \"protein\" | \"carbs\" | \"fat\" | \"fiber\" | \"sugar\" | \"sodium\";\n\nexport type Entry = {\n pageId: string;\n date: string;\n loggedAt: string;\n food: string;\n macros: Partial>;\n};\n\nexport type MacroStats = {\n count: number;\n total: number;\n avg: number;\n};\n\nexport type FoodStats = {\n totalEntries: number;\n uniqueDays: number;\n entriesByDate: Record;\n avgEntriesPerDay: number;\n minEntriesPerDay: number;\n maxEntriesPerDay: number;\n macroSummary: Partial>;\n};\n\nexport type FoodRollup = {\n category: string;\n periodStart: string;\n periodEnd: string;\n streak: number;\n completionRate: number;\n xp: number;\n badges: string[];\n stats: FoodStats;\n runId: string;\n};\n\n// Mapping from Notion property names to macro fields.\nexport const PROPERTY_NAMES = {\n title: \"food\",\n loggedAt: \"Created time\",\n macros: {\n calories: \"calories\",\n protein: \"protein\",\n carbs: \"carbs\",\n fat: \"fats\",\n fiber: \"fiber\",\n sugar: \"sugar\",\n sodium: \"sodium\",\n },\n};\n\n// Parse a Notion page into a normalized food entry.\nexport function parseEntry(page: NotionPage): Entry | null {\n const props = page.properties ?? {};\n const loggedAtProp = props[PROPERTY_NAMES.loggedAt] as\n | NotionDateProperty\n | NotionCreatedTimeProperty\n | undefined;\n let loggedAt: string | null = null;\n if (loggedAtProp) {\n if (\"date\" in loggedAtProp) loggedAt = loggedAtProp.date?.start ?? null;\n if (\"created_time\" in loggedAtProp) loggedAt = loggedAtProp.created_time ?? null;\n }\n if (!loggedAt) return null;\n\n const foodProp = props[PROPERTY_NAMES.title] as NotionTitleProperty | NotionTextProperty | undefined;\n const food = extractFoodName(foodProp) ?? \"Unknown\";\n const macros = extractMacros(props);\n\n return {\n pageId: page.id,\n date: loggedAt.slice(0, 10),\n loggedAt,\n food,\n macros,\n };\n}\n\n// Normalize Notion title/rich_text into a single plain string.\nexport function extractFoodName(\n prop:\n | NotionTitleProperty\n | NotionTextProperty\n | undefined,\n): string | null {\n // Normalize Notion title/rich_text into a single plain string.\n if (!prop) return null;\n if (\"title\" in prop) {\n const value = prop.title?.map((item) => item.plain_text).join(\"\").trim();\n return value ? value : null;\n }\n if (\"rich_text\" in prop) {\n const value = prop.rich_text?.map((item) => item.plain_text).join(\"\").trim();\n return value ? value : null;\n }\n return null;\n}\n\n// Read macro number properties from a Notion page.\nexport function extractMacros(\n props: Record,\n): Partial> {\n const macros: Partial> = {};\n for (const key of Object.keys(PROPERTY_NAMES.macros) as MacroKey[]) {\n const propName = PROPERTY_NAMES.macros[key];\n const value = (props[propName] as NotionNumberProperty | undefined)?.number;\n if (typeof value === \"number\") macros[key] = value;\n }\n return macros;\n}\n\n// Only enrich entries missing core macros.\nexport function shouldEnrich(entry: Entry): boolean {\n return (\n entry.macros.calories === undefined ||\n entry.macros.protein === undefined ||\n entry.macros.carbs === undefined ||\n entry.macros.fat === undefined\n );\n}\n\n// Shape Notion property updates for numeric columns only.\nexport function buildNutritionProperties(macros: Partial>): Record {\n const props: Record = {};\n if (macros.calories !== undefined) props[PROPERTY_NAMES.macros.calories] = { number: macros.calories };\n if (macros.protein !== undefined) props[PROPERTY_NAMES.macros.protein] = { number: macros.protein };\n if (macros.carbs !== undefined) props[PROPERTY_NAMES.macros.carbs] = { number: macros.carbs };\n if (macros.fat !== undefined) props[PROPERTY_NAMES.macros.fat] = { number: macros.fat };\n if (macros.fiber !== undefined) props[PROPERTY_NAMES.macros.fiber] = { number: macros.fiber };\n if (macros.sugar !== undefined) props[PROPERTY_NAMES.macros.sugar] = { number: macros.sugar };\n if (macros.sodium !== undefined) props[PROPERTY_NAMES.macros.sodium] = { number: macros.sodium };\n return props;\n}\n\n// Build the weekly food rollup stored in SQLite.\nexport function buildFoodRollup(entries: Entry[], start: string, end: string): FoodRollup {\n const dateRange = listDateRange(start, end);\n const entriesByDate = countEntriesByDate(entries);\n const uniqueDays = dateRange.filter((date) => (entriesByDate[date] ?? 0) > 0).length;\n const totalEntries = entries.length;\n const avgEntriesPerDay = dateRange.length ? Number((totalEntries / dateRange.length).toFixed(2)) : 0;\n const minEntriesPerDay = dateRange.length\n ? Math.min(...dateRange.map((date) => entriesByDate[date] ?? 0))\n : 0;\n const maxEntriesPerDay = dateRange.length\n ? Math.max(...dateRange.map((date) => entriesByDate[date] ?? 0))\n : 0;\n const completionRate = dateRange.length ? Math.round((uniqueDays / dateRange.length) * 100) : 0;\n const streak = calculateCurrentStreak(dateRange, entriesByDate);\n const macroSummary = calculateMacroSummary(entries);\n\n const runId = `food-${start}-${end}`;\n\n return {\n category: \"food\",\n periodStart: start,\n periodEnd: end,\n streak,\n completionRate,\n xp: 0,\n badges: [],\n stats: {\n totalEntries,\n uniqueDays,\n entriesByDate,\n avgEntriesPerDay,\n minEntriesPerDay,\n maxEntriesPerDay,\n macroSummary,\n },\n runId,\n };\n}\n\n// Consistent rounding helper for macro math.\nexport function roundNumber(value: number): number {\n return Number(value.toFixed(2));\n}\n\n// Simple prompt for the macro estimation model.\nexport function buildNutritionPrompt(food: string): string {\n return `Estimate macros for: \"${food}\". Assume a typical single serving.`;\n}\n\n// Guard against non-JSON responses from the model.\nexport function safeParseJson(value: string): unknown {\n try {\n return JSON.parse(value);\n } catch {\n return null;\n }\n}\n\n// Aggregate macro stats across entries.\nfunction calculateMacroSummary(entries: Entry[]): Partial> {\n const summary: Partial> = {};\n for (const entry of entries) {\n for (const key of Object.keys(entry.macros) as MacroKey[]) {\n const value = entry.macros[key];\n if (typeof value !== \"number\") continue;\n const current = summary[key] ?? { count: 0, total: 0, avg: 0 };\n current.count += 1;\n current.total += value;\n current.avg = Number((current.total / current.count).toFixed(2));\n summary[key] = current;\n }\n }\n return summary;\n}\n\n// Coerce model output into numeric macro fields.\nexport function coerceMacros(value: Record): Partial> {\n const macros: Partial> = {};\n macros.calories = coerceNumber(value.calories);\n macros.protein = coerceNumber(value.protein);\n macros.carbs = coerceNumber(value.carbs);\n macros.fat = coerceNumber(value.fat);\n macros.fiber = coerceNumber(value.fiber);\n macros.sugar = coerceNumber(value.sugar);\n macros.sodium = coerceNumber(value.sodium);\n return Object.fromEntries(\n Object.entries(macros).filter(([, v]) => typeof v === \"number\" && Number.isFinite(v)),\n ) as Partial>;\n}\n\n// Convert a string or number into a rounded macro value.\nexport function coerceNumber(value: unknown): number | undefined {\n if (typeof value === \"number\" && Number.isFinite(value)) return roundNumber(value);\n if (typeof value === \"string\") {\n const trimmed = value.trim();\n const parsed = Number(trimmed);\n if (Number.isFinite(parsed)) return roundNumber(parsed);\n }\n return undefined;\n}\n","deleted","label",[177,158],"shared","permalink","https://www.val.town/x/pchinjr/notion_weekly_report/code/shared/food_enrich.ts","extension","actionData","errors"]