[{"_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","collectors/food_report.cron.tsx","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},"8f078c0a-f7ac-11f0-9c14-42dde27851f2","food_report.cron.tsx","fileId","f851115a-f233-11f0-a807-42dde27851f2","parentId","25490f94-f23b-11f0-a33f-42dde27851f2","branchId","branchVersion",417,"latest",true,["D",1769098095429],38,"fileType","interval","content","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 { fetchFoodMacros, getFatSecretConfig, requestAccessToken, sumIfComplete } from \"../shared/fatsecret.ts\";\nimport {\n buildNutritionProperties,\n buildFoodRollup,\n type Entry,\n type MacroKey,\n parseEntry,\n PROPERTY_NAMES,\n roundNumber,\n safeParseJson,\n shouldEnrich,\n} from \"../shared/food_enrich.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 const fatSecretToken = fatSecretConfig ? await requestAccessToken(fatSecretConfig) : null;\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 (!shouldEnrich(entry)) continue;\n if (!entry.food || entry.food === \"Unknown\") continue;\n const enrichment = await fetchNutrition(entry.food, openai, fatSecretConfig, fatSecretToken);\n if (!enrichment) continue;\n const properties = buildNutritionProperties(enrichment.macros);\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: enrichment.macros,\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, ...enrichment.macros };\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\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 fetchNutrition(\n foodName: string,\n openai: OpenAI,\n config: ReturnType,\n token: string | null,\n): Promise<{\n macros: Partial>;\n} | null> {\n if (!config || !token) return null;\n const items = await parseFoodItems(foodName, openai);\n const macros = await fetchFatSecretTotals(items, foodName, token, config);\n if (!macros || !Object.keys(macros).length) return null;\n return { macros };\n}\n\ntype FoodItem = {\n name: string;\n servings: number;\n};\n\nasync function parseFoodItems(foodName: string, openai: OpenAI): Promise {\n // Keep the OpenAI request compact to control costs.\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n {\n role: \"system\",\n content:\n \"You normalize food log entries. \" +\n \"Return a single JSON object: {\\\"items\\\":[{\\\"name\\\":\\\"...\\\",\\\"servings\\\":1}]}. \" +\n \"Correct spelling, keep names short, and split sides when phrased as \\\"with\\\" or \\\"and\\\". \" +\n \"Infer servings for a regular meal: default to 1 per item; if explicit quantities are given, \" +\n \"convert to a servings multiplier. Keep brands and key ingredients. No extra text.\",\n },\n {\n role: \"user\",\n content: `Food entry: \"${foodName}\".`,\n },\n ],\n max_tokens: 160,\n });\n\n const text = completion.choices[0]?.message?.content?.trim();\n if (!text) return [{ name: foodName, servings: 1 }];\n const parsed = safeParseJson(text);\n if (!parsed || typeof parsed !== \"object\") return [{ name: foodName, servings: 1 }];\n const items = (parsed as Record).items;\n if (!Array.isArray(items)) return [{ name: foodName, servings: 1 }];\n const cleaned = items\n .map((item) => coerceFoodItem(item))\n .filter((item): item is FoodItem => !!item)\n .map((item) => ({\n name: item.name.trim(),\n servings: sanitizeServings(item.servings),\n }))\n .filter((item) => item.name.length > 0);\n return cleaned.length ? cleaned : [{ name: foodName, servings: 1 }];\n}\n\nasync function fetchFatSecretTotals(\n items: FoodItem[],\n original: string,\n token: string,\n config: ReturnType,\n): Promise> | null> {\n if (!config) return null;\n const components: Array> | null> = [];\n for (const item of items) {\n const macros = await fetchFoodMacros(item.name, token);\n components.push(macros ? scaleMacros(macros, item.servings) : null);\n }\n\n if (components.length === 1 && components[0]) return components[0];\n const totals = sumComponentMacros(components);\n if (totals && hasCoreMacros(totals)) return totals;\n const fallback = await fetchFoodMacros(original, token);\n return fallback ?? null;\n}\n\nconst CORE_MACROS: MacroKey[] = [\"calories\", \"protein\", \"carbs\", \"fat\"];\nconst SUM_MACROS: MacroKey[] = [\"calories\", \"protein\", \"carbs\", \"fat\", \"fiber\", \"sugar\", \"sodium\"];\n\nfunction hasCoreMacros(macros: Partial>): boolean {\n return CORE_MACROS.every((key) => typeof macros[key] === \"number\");\n}\n\nfunction sumComponentMacros(\n components: Array> | null>,\n): Partial> | null {\n if (!components.length) return null;\n if (components.some((component) => !component)) return null;\n const entries = components as Array>>;\n const totals: Partial> = {};\n for (const key of SUM_MACROS) {\n const value = sumIfComplete(entries.map((entry) => entry[key]));\n if (value !== undefined) totals[key] = value;\n }\n return totals;\n}\n\nfunction coerceFoodItem(item: unknown): FoodItem | null {\n if (typeof item === \"string\") {\n return { name: item, servings: 1 };\n }\n if (!item || typeof item !== \"object\") return null;\n const record = item as Record;\n const name = record.name;\n if (typeof name !== \"string\") return null;\n const servings = record.servings;\n if (typeof servings === \"number\" && Number.isFinite(servings)) {\n return { name, servings };\n }\n if (typeof servings === \"string\") {\n const parsed = Number(servings.trim());\n if (Number.isFinite(parsed)) return { name, servings: parsed };\n }\n return { name, servings: 1 };\n}\n\nfunction sanitizeServings(value: number): number {\n if (!Number.isFinite(value) || value <= 0) return 1;\n return roundNumber(value);\n}\n\nfunction scaleMacros(\n macros: Partial>,\n servings: number,\n): Partial> {\n const scaled: Partial> = {};\n for (const [key, value] of Object.entries(macros) as Array<[MacroKey, number]>) {\n if (typeof value !== \"number\") continue;\n scaled[key] = roundNumber(value * servings);\n }\n return scaled;\n}\n","deleted","label",[177,158],"collectors","permalink","https://www.val.town/x/pchinjr/notion_weekly_report/code/collectors/food_report.cron.tsx","extension","actionData","errors"]