[{"_1":2,"_180":-5,"_181":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","a45694a1faeed7a48e6b6123449288e884a42bca","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_154":155,"_177":178,"_179":-5},"handle","shapedlines","name","carmy","path","backend/services/fdc-client.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":73,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":-5,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":132,"_135":136,"_140":141,"_153":20},"id","75b56760-d3a6-11f0-86d1-42dde27851f2","createdAt",["D",1765137234131],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","b9153140-d3a9-11f0-8d63-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_133":134},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","org",{"_94":95,"_137":134,"_12":112,"_138":139},"avatar","tier","pro","branch",{"_142":143,"_96":44,"_102":144,"_145":103,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":97,"_152":95},"version",241,"75b5bdc8-d3a6-11f0-86d1-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":156,"_96":157,"_158":159,"_160":161,"_162":144,"_163":164,"_165":116,"_104":166,"_142":167,"_168":169,"_170":171,"_172":20,"_173":-5,"_98":174},"faa361a8-e142-11f0-8c40-42dde27851f2","fdc-client.ts","fileId","6a3ab8ca-da38-11f0-8f3b-42dde27851f2","parentId","6a0c0b60-da38-11f0-8f3b-42dde27851f2","branchId","branchVersion",167,"latest",["D",1766633823750],6,"fileType","script","content","// USDA FoodData Central API Client\n// Documentation: https://fdc.nal.usda.gov/api-guide.html\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { FDC_FOODS_CACHE_TABLE } from \"../database/migrations.ts\";\nimport type { FDCFood, FDCNutrition, FDCSearchResult, FDCDataType, NutrientKey } from \"../../shared/types.ts\";\nimport { ALL_NUTRIENT_KEYS } from \"../../shared/types.ts\";\n\nconst FDC_API_BASE = \"https://api.nal.usda.gov/fdc/v1\";\n\n// USDA FDC Nutrient IDs (per USDA FDC documentation)\n// Full comprehensive list of all available nutrients\nconst NUTRIENT_IDS: Record = {\n // Energy\n calories: 1008, // Energy (kcal)\n \n // Macronutrients\n protein: 1003, // Protein\n fat: 1004, // Total lipid (fat)\n carbs: 1005, // Carbohydrate, by difference\n fiber: 1079, // Fiber, total dietary\n sugars: 2000, // Sugars, total including NLEA\n addedSugars: 1235, // Sugars, added\n starch: 1009, // Starch\n \n // Fats breakdown\n saturatedFat: 1258, // Fatty acids, total saturated\n transFat: 1257, // Fatty acids, total trans\n monounsaturatedFat: 1292, // Fatty acids, total monounsaturated\n polyunsaturatedFat: 1293, // Fatty acids, total polyunsaturated\n cholesterol: 1253, // Cholesterol\n \n // Other macros\n water: 1051, // Water\n alcohol: 1018, // Alcohol, ethyl\n caffeine: 1057, // Caffeine\n \n // Minerals\n sodium: 1093, // Sodium, Na\n potassium: 1092, // Potassium, K\n calcium: 1087, // Calcium, Ca\n iron: 1089, // Iron, Fe\n magnesium: 1090, // Magnesium, Mg\n zinc: 1095, // Zinc, Zn\n phosphorus: 1091, // Phosphorus, P\n selenium: 1103, // Selenium, Se\n copper: 1098, // Copper, Cu\n manganese: 1101, // Manganese, Mn\n fluoride: 1099, // Fluoride, F\n chromium: 1096, // Chromium, Cr\n molybdenum: 1102, // Molybdenum, Mo\n iodine: 1100, // Iodine, I\n chloride: 1088, // Chlorine, Cl (Chloride)\n \n // Vitamins - Fat soluble\n vitaminA: 1106, // Vitamin A, RAE\n retinol: 1105, // Retinol\n betaCarotene: 1107, // Carotene, beta\n alphaCarotene: 1108, // Carotene, alpha\n betaCryptoxanthin: 1120, // Cryptoxanthin, beta\n lycopene: 1122, // Lycopene\n luteinZeaxanthin: 1123, // Lutein + zeaxanthin\n vitaminD: 1114, // Vitamin D (D2 + D3)\n vitaminD2: 1111, // Vitamin D2 (ergocalciferol)\n vitaminD3: 1112, // Vitamin D3 (cholecalciferol)\n vitaminE: 1109, // Vitamin E (alpha-tocopherol)\n vitaminK: 1185, // Vitamin K (phylloquinone)\n vitaminK2: 1184, // Vitamin K (Dihydrophylloquinone) / menaquinone-4\n \n // Vitamins - Water soluble\n vitaminC: 1162, // Vitamin C, total ascorbic acid\n vitaminB6: 1175, // Vitamin B-6\n vitaminB12: 1178, // Vitamin B-12\n thiamin: 1165, // Thiamin (B1)\n riboflavin: 1166, // Riboflavin (B2)\n niacin: 1167, // Niacin (B3)\n pantothenicAcid: 1170, // Pantothenic acid (B5)\n biotin: 1176, // Biotin (B7)\n folate: 1177, // Folate, total (DFE)\n folicAcid: 1186, // Folic acid\n choline: 1180, // Choline, total\n betaine: 1198, // Betaine\n};\n\nfunction getApiKey(): string {\n const apiKey = Deno.env.get(\"FDC_API_KEY\");\n if (!apiKey) {\n throw new Error(\"FDC_API_KEY environment variable is not set\");\n }\n return apiKey;\n}\n\n// Micronutrient IDs for counting available data (vitamins + minerals, excluding basic macros)\nconst MICRONUTRIENT_KEYS: NutrientKey[] = [\n // Minerals\n 'sodium', 'potassium', 'calcium', 'iron', 'magnesium', 'zinc',\n 'phosphorus', 'selenium', 'copper', 'manganese',\n // Vitamins\n 'vitaminA', 'vitaminC', 'vitaminD', 'vitaminE', 'vitaminK',\n 'vitaminB6', 'vitaminB12', 'thiamin', 'riboflavin', 'niacin',\n 'pantothenicAcid', 'biotin', 'folate', 'choline',\n];\n\nconst MICRONUTRIENT_IDS = MICRONUTRIENT_KEYS.map(key => NUTRIENT_IDS[key]);\n\n// Count micronutrients from food nutrients array\nfunction countMicronutrientsFromNutrients(nutrients: any[]): number {\n if (!nutrients || !Array.isArray(nutrients)) return 0;\n\n let count = 0;\n for (const nutrientId of MICRONUTRIENT_IDS) {\n const nutrient = nutrients.find((n: any) =>\n n.nutrientId === nutrientId || n.nutrient?.id === nutrientId\n );\n if (nutrient && (nutrient.amount != null || nutrient.value != null)) {\n count++;\n }\n }\n return count;\n}\n\n// Search FDC foods\nexport async function searchFDCFoods(\n query: string,\n options?: {\n dataType?: FDCDataType[];\n pageSize?: number;\n pageNumber?: number;\n sortBy?: string;\n sortOrder?: 'asc' | 'desc';\n }\n): Promise {\n const apiKey = getApiKey();\n const pageSize = options?.pageSize ?? 25;\n const pageNumber = options?.pageNumber ?? 1;\n\n // Build data type filter\n const dataTypes = options?.dataType ?? ['Branded', 'Foundation', 'SR Legacy'];\n\n const response = await fetch(`${FDC_API_BASE}/foods/search?api_key=${apiKey}`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n query: query.trim(),\n dataType: dataTypes,\n pageSize,\n pageNumber,\n sortBy: options?.sortBy,\n sortOrder: options?.sortOrder,\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`FDC API search failed: ${response.status} ${errorText}`);\n }\n\n const data = await response.json();\n\n return (data.foods || []).map((food: any) => ({\n fdcId: food.fdcId,\n description: food.description,\n dataType: food.dataType,\n brandOwner: food.brandOwner || null,\n brandName: food.brandName || null,\n score: food.score || 0,\n micronutrientCount: food.foodNutrients\n ? countMicronutrientsFromNutrients(food.foodNutrients)\n : null,\n }));\n}\n\n// Extract nutrition from FDC food nutrients array\nfunction extractNutrition(nutrients: any[]): FDCNutrition {\n const getNutrientValue = (nutrientId: number): number | null => {\n const nutrient = nutrients.find((n: any) => n.nutrientId === nutrientId || n.nutrient?.id === nutrientId);\n if (!nutrient) return null;\n return nutrient.amount ?? nutrient.value ?? null;\n };\n\n // Build nutrition object dynamically from NUTRIENT_IDS\n const nutrition: Partial = {};\n for (const key of ALL_NUTRIENT_KEYS) {\n const nutrientId = NUTRIENT_IDS[key];\n if (nutrientId !== undefined) {\n (nutrition as any)[key] = getNutrientValue(nutrientId);\n }\n }\n\n return nutrition as FDCNutrition;\n}\n\n// Get detailed food info from FDC API\nexport async function getFDCFoodFromApi(fdcId: number): Promise {\n const apiKey = getApiKey();\n\n const response = await fetch(`${FDC_API_BASE}/food/${fdcId}?api_key=${apiKey}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`FDC API food fetch failed: ${response.status} ${errorText}`);\n }\n\n const food = await response.json();\n\n // Extract nutrients (different structure for different data types)\n const nutrients = food.foodNutrients || [];\n\n return {\n fdcId: food.fdcId,\n description: food.description,\n dataType: food.dataType,\n brandOwner: food.brandOwner || null,\n brandName: food.brandName || null,\n servingSize: food.servingSize || null,\n servingSizeUnit: food.servingSizeUnit || null,\n householdServingText: food.householdServingFullText || null,\n nutrition: extractNutrition(nutrients),\n cachedAt: new Date().toISOString(),\n };\n}\n\n// Cache FDC food to database\nexport async function cacheFDCFood(food: FDCFood): Promise {\n const n = food.nutrition;\n\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${FDC_FOODS_CACHE_TABLE} (\n fdc_id, description, data_type, brand_owner, brand_name,\n serving_size, serving_size_unit, household_serving_text,\n calories, protein, fat, carbs, fiber, sugars, added_sugars, starch,\n saturated_fat, trans_fat, monounsaturated_fat, polyunsaturated_fat, cholesterol,\n water, alcohol, caffeine,\n sodium, potassium, calcium, iron, magnesium, zinc,\n phosphorus, selenium, copper, manganese, fluoride, chromium, molybdenum, iodine, chloride,\n vitamin_a, retinol, beta_carotene, alpha_carotene, beta_cryptoxanthin, lycopene, lutein_zeaxanthin,\n vitamin_d, vitamin_d2, vitamin_d3, vitamin_e, vitamin_k, vitamin_k2,\n vitamin_c, vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin,\n pantothenic_acid, biotin, folate, folic_acid, choline, betaine,\n cached_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n food.fdcId, food.description, food.dataType, food.brandOwner, food.brandName,\n food.servingSize, food.servingSizeUnit, food.householdServingText,\n n.calories, n.protein, n.fat, n.carbs, n.fiber, n.sugars, n.addedSugars, n.starch,\n n.saturatedFat, n.transFat, n.monounsaturatedFat, n.polyunsaturatedFat, n.cholesterol,\n n.water, n.alcohol, n.caffeine,\n n.sodium, n.potassium, n.calcium, n.iron, n.magnesium, n.zinc,\n n.phosphorus, n.selenium, n.copper, n.manganese, n.fluoride, n.chromium, n.molybdenum, n.iodine, n.chloride,\n n.vitaminA, n.retinol, n.betaCarotene, n.alphaCarotene, n.betaCryptoxanthin, n.lycopene, n.luteinZeaxanthin,\n n.vitaminD, n.vitaminD2, n.vitaminD3, n.vitaminE, n.vitaminK, n.vitaminK2,\n n.vitaminC, n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin,\n n.pantothenicAcid, n.biotin, n.folate, n.folicAcid, n.choline, n.betaine,\n food.cachedAt,\n ]);\n}\n\n// Get FDC food from cache\nexport async function getFDCFoodFromCache(fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${FDC_FOODS_CACHE_TABLE} WHERE fdc_id = ?`,\n [fdcId]\n );\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n fdcId: row.fdc_id as number,\n description: row.description as string,\n dataType: row.data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n brandName: row.brand_name as string | null,\n servingSize: row.serving_size as number | null,\n servingSizeUnit: row.serving_size_unit as string | null,\n householdServingText: row.household_serving_text as string | null,\n nutrition: {\n calories: row.calories as number | null,\n protein: row.protein as number | null,\n fat: row.fat as number | null,\n carbs: row.carbs as number | null,\n fiber: row.fiber as number | null,\n sugars: row.sugars as number | null,\n addedSugars: row.added_sugars as number | null,\n starch: row.starch as number | null,\n saturatedFat: row.saturated_fat as number | null,\n transFat: row.trans_fat as number | null,\n monounsaturatedFat: row.monounsaturated_fat as number | null,\n polyunsaturatedFat: row.polyunsaturated_fat as number | null,\n cholesterol: row.cholesterol as number | null,\n water: row.water as number | null,\n alcohol: row.alcohol as number | null,\n caffeine: row.caffeine as number | null,\n sodium: row.sodium as number | null,\n potassium: row.potassium as number | null,\n calcium: row.calcium as number | null,\n iron: row.iron as number | null,\n magnesium: row.magnesium as number | null,\n zinc: row.zinc as number | null,\n phosphorus: row.phosphorus as number | null,\n selenium: row.selenium as number | null,\n copper: row.copper as number | null,\n manganese: row.manganese as number | null,\n fluoride: row.fluoride as number | null,\n chromium: row.chromium as number | null,\n molybdenum: row.molybdenum as number | null,\n iodine: row.iodine as number | null,\n chloride: row.chloride as number | null,\n vitaminA: row.vitamin_a as number | null,\n retinol: row.retinol as number | null,\n betaCarotene: row.beta_carotene as number | null,\n alphaCarotene: row.alpha_carotene as number | null,\n betaCryptoxanthin: row.beta_cryptoxanthin as number | null,\n lycopene: row.lycopene as number | null,\n luteinZeaxanthin: row.lutein_zeaxanthin as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminD2: row.vitamin_d2 as number | null,\n vitaminD3: row.vitamin_d3 as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k as number | null,\n vitaminK2: row.vitamin_k2 as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminB6: row.vitamin_b6 as number | null,\n vitaminB12: row.vitamin_b12 as number | null,\n thiamin: row.thiamin as number | null,\n riboflavin: row.riboflavin as number | null,\n niacin: row.niacin as number | null,\n pantothenicAcid: row.pantothenic_acid as number | null,\n biotin: row.biotin as number | null,\n folate: row.folate as number | null,\n folicAcid: row.folic_acid as number | null,\n choline: row.choline as number | null,\n betaine: row.betaine as number | null,\n },\n cachedAt: row.cached_at as string,\n };\n}\n\n// Get FDC food with caching (fetches from API if not cached or cache is old)\nexport async function getFDCFood(fdcId: number, maxCacheAgeHours = 24 * 7): Promise {\n // Try cache first\n const cached = await getFDCFoodFromCache(fdcId);\n\n if (cached) {\n // Check if cache is still valid\n const cacheAge = Date.now() - new Date(cached.cachedAt).getTime();\n const maxAge = maxCacheAgeHours * 60 * 60 * 1000;\n\n if (cacheAge < maxAge) {\n return cached;\n }\n }\n\n // Fetch from API\n const food = await getFDCFoodFromApi(fdcId);\n\n // Cache the result\n await cacheFDCFood(food);\n\n return food;\n}\n\n// Get multiple FDC foods (batch with caching)\nexport async function getFDCFoods(fdcIds: number[]): Promise> {\n const result = new Map();\n const toFetch: number[] = [];\n\n // Check cache for each\n for (const fdcId of fdcIds) {\n const cached = await getFDCFoodFromCache(fdcId);\n if (cached) {\n const cacheAge = Date.now() - new Date(cached.cachedAt).getTime();\n const maxAge = 24 * 7 * 60 * 60 * 1000; // 7 days\n if (cacheAge < maxAge) {\n result.set(fdcId, cached);\n continue;\n }\n }\n toFetch.push(fdcId);\n }\n\n // Fetch missing from API (one by one to avoid rate limits)\n for (const fdcId of toFetch) {\n try {\n const food = await getFDCFoodFromApi(fdcId);\n await cacheFDCFood(food);\n result.set(fdcId, food);\n } catch (error) {\n console.error(`Failed to fetch FDC food ${fdcId}:`, error);\n }\n }\n\n return result;\n}\n\n// Auto-match ingredient name to FDC food (Foundation Foods only)\nexport async function autoMatchIngredient(ingredientName: string): Promise<{\n match: FDCSearchResult | null;\n confidence: number;\n alternatives: FDCSearchResult[];\n}> {\n // Clean up ingredient name for better matching\n const cleanName = ingredientName\n .toLowerCase()\n .replace(/[,()]/g, ' ')\n .replace(/\\s+/g, ' ')\n .trim();\n\n // Search only Foundation Foods and SR Legacy for auto-matching (not Branded)\n const results = await searchFDCFoods(cleanName, {\n dataType: ['Foundation', 'SR Legacy'],\n pageSize: 5\n });\n\n if (results.length === 0) {\n return { match: null, confidence: 0, alternatives: [] };\n }\n\n // Return the first result as the match (per user request)\n return {\n match: results[0],\n confidence: 100,\n alternatives: results.slice(1, 5),\n };\n}\n","deleted","label",[175,176,157],"backend","services","permalink","https://www.val.town/x/shapedlines/carmy/code/backend/services/fdc-client.ts","extension","actionData","errors"]