[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_498":499,"_500":501},"routes/_app.x.$handle.$name",{"_98":97,"_32":46,"_106":88,"_27":54,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":60,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",163,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","b90da5f6-d3a9-11f0-a23f-42dde27851f2","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport {\n USERS_TABLE,\n SESSIONS_TABLE,\n RECIPES_TABLE,\n RECIPE_INGREDIENTS_TABLE,\n RECIPE_NUTRITION_TABLE,\n FDC_FOODS_CACHE_TABLE,\n GROCERY_LISTS_TABLE,\n GROCERY_LIST_ITEMS_TABLE,\n NUTRITION_GOALS_TABLE,\n MEAL_PLANS_TABLE,\n MEAL_PLAN_ENTRIES_TABLE,\n SCRAPER_EVAL_URLS_TABLE,\n STARRED_INGREDIENTS_TABLE,\n CUSTOM_FOODS_TABLE,\n} from \"./migrations.ts\";\nimport type {\n User,\n Recipe,\n RecipeIngredient,\n RecipeNutrition,\n GroceryList,\n GroceryListItem,\n NutritionGoals,\n MealPlan,\n MealPlanEntry,\n DayOfWeek,\n MealType,\n FDCDataType,\n CreateRecipeIngredient,\n StarredIngredient,\n CustomFood,\n CreateCustomFoodRequest,\n FDCFood,\n FDCNutrition,\n} from \"../../shared/types.ts\";\nimport { calculateRecipeNutrition, convertToGrams } from \"../services/nutrition-calculator.ts\";\n\n// Generate unique IDs\nfunction generateId(): string {\n return crypto.randomUUID();\n}\n\n// ============ USER QUERIES ============\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function createOrUpdateUser(\n email: string,\n name: string | null,\n picture: string | null\n): Promise {\n const existing = await getUserByEmail(email);\n\n if (existing) {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET name = ?, picture = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [name, picture, existing.id]\n );\n return { ...existing, name, picture };\n }\n\n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, email, name, picture) VALUES (?, ?, ?, ?)`,\n [id, email, name, picture]\n );\n return { id, email, name, picture };\n}\n\n// ============ SESSION QUERIES ============\n\nexport async function createSession(userId: string): Promise {\n const sessionId = generateId();\n const expiresAt = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString(); // 30 days\n\n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [sessionId, userId, expiresAt]\n );\n\n return sessionId;\n}\n\nexport async function getSessionUser(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT u.id, u.email, u.name, u.picture\n FROM ${SESSIONS_TABLE} s\n JOIN ${USERS_TABLE} u ON s.user_id = u.id\n WHERE s.id = ? AND s.expires_at > datetime('now')`,\n [sessionId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n}\n\n// ============ RECIPE QUERIES ============\n\nexport async function getRecipesByUser(userId: string): Promise {\n const recipesResult = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n const recipes: Recipe[] = [];\n\n for (const row of recipesResult.rows) {\n const recipeId = row.id as string;\n\n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n\n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n\n // Get nutrition with extended micronutrients\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete\n FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n\n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n\n recipes.push({\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n });\n }\n\n return recipes;\n}\n\n// Helper to map nutrition row to RecipeNutrition\nfunction mapNutritionRow(n: any, recipeId: string): RecipeNutrition {\n return {\n id: n.id as string,\n recipeId: recipeId,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n fiber: n.fiber as number | null,\n sodium: n.sodium as number | null,\n potassium: n.potassium as number | null,\n calcium: n.calcium as number | null,\n iron: n.iron as number | null,\n magnesium: n.magnesium as number | null,\n zinc: n.zinc as number | null,\n vitaminA: n.vitamin_a as number | null,\n vitaminC: n.vitamin_c as number | null,\n vitaminD: n.vitamin_d as number | null,\n vitaminE: n.vitamin_e as number | null,\n vitaminK: n.vitamin_k as number | null,\n vitaminB6: n.vitamin_b6 as number | null,\n vitaminB12: n.vitamin_b12 as number | null,\n thiamin: n.thiamin as number | null,\n riboflavin: n.riboflavin as number | null,\n niacin: n.niacin as number | null,\n folate: n.folate as number | null,\n isComplete: Boolean(n.is_complete),\n };\n}\n\nexport async function getRecipeById(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n\n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n\n // Get nutrition with extended micronutrients\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete\n FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n\n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n\n return {\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n };\n}\n\nexport async function createRecipe(\n userId: string,\n title: string,\n url: string | null,\n instructions: string | null,\n servingSize: number,\n ingredients: CreateRecipeIngredient[]\n): Promise {\n const recipeId = generateId();\n\n await sqlite.execute(\n `INSERT INTO ${RECIPES_TABLE} (id, user_id, title, url, instructions, serving_size)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [recipeId, userId, title, url, instructions, servingSize]\n );\n\n // Insert ingredients with FDC fields\n const recipeIngredients: RecipeIngredient[] = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ing = ingredients[i];\n const ingId = generateId();\n\n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name,\n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n\n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n\n // Insert calculated nutrition\n let recipeNutrition: RecipeNutrition | null = null;\n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} \n (id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n nutId, recipeId,\n n.calories, n.protein, n.fat, n.carbs, n.fiber,\n n.sodium, n.potassium, n.calcium, n.iron, n.magnesium, n.zinc,\n n.vitaminA, n.vitaminC, n.vitaminD, n.vitaminE, n.vitaminK,\n n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin, n.folate,\n n.isComplete ? 1 : 0\n ]\n );\n\n recipeNutrition = {\n id: nutId,\n recipeId,\n ...n,\n };\n\n const now = new Date().toISOString();\n return {\n id: recipeId,\n userId,\n title,\n url,\n instructions,\n servingSize,\n createdAt: now,\n updatedAt: now,\n ingredients: recipeIngredients,\n nutrition: recipeNutrition,\n };\n}\n\nexport async function updateRecipe(\n recipeId: string,\n userId: string,\n updates: {\n title?: string;\n url?: string | null;\n instructions?: string | null;\n servingSize?: number;\n ingredients?: CreateRecipeIngredient[];\n }\n): Promise {\n // Check ownership\n const existing = await getRecipeById(recipeId, userId);\n if (!existing) return null;\n\n // Update recipe\n const fields: string[] = [];\n const values: any[] = [];\n\n if (updates.title !== undefined) {\n fields.push('title = ?');\n values.push(updates.title);\n }\n if (updates.url !== undefined) {\n fields.push('url = ?');\n values.push(updates.url);\n }\n if (updates.instructions !== undefined) {\n fields.push('instructions = ?');\n values.push(updates.instructions);\n }\n if (updates.servingSize !== undefined) {\n fields.push('serving_size = ?');\n values.push(updates.servingSize);\n }\n\n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(recipeId, userId);\n await sqlite.execute(\n `UPDATE ${RECIPES_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n\n // Determine the serving size to use for nutrition calculation\n const servingSize = updates.servingSize ?? existing.servingSize;\n\n // Update ingredients if provided\n let recipeIngredients: RecipeIngredient[] = existing.ingredients;\n if (updates.ingredients !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ?`, [recipeId]);\n recipeIngredients = [];\n\n for (let i = 0; i < updates.ingredients.length; i++) {\n const ing = updates.ingredients[i];\n const ingId = generateId();\n\n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name,\n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n }\n\n // Recalculate nutrition if ingredients or serving size changed\n if (updates.ingredients !== undefined || updates.servingSize !== undefined) {\n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n\n // Update nutrition\n await sqlite.execute(`DELETE FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`, [recipeId]);\n\n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} \n (id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n nutId, recipeId,\n n.calories, n.protein, n.fat, n.carbs, n.fiber,\n n.sodium, n.potassium, n.calcium, n.iron, n.magnesium, n.zinc,\n n.vitaminA, n.vitaminC, n.vitaminD, n.vitaminE, n.vitaminK,\n n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin, n.folate,\n n.isComplete ? 1 : 0\n ]\n );\n }\n\n return getRecipeById(recipeId, userId);\n}\n\nexport async function deleteRecipe(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function duplicateRecipe(recipeId: string, userId: string): Promise {\n const original = await getRecipeById(recipeId, userId);\n if (!original) return null;\n\n return createRecipe(\n userId,\n `${original.title} (Copy)`,\n original.url,\n original.instructions,\n original.servingSize,\n original.ingredients.map(i => ({\n name: i.name,\n amount: i.amount,\n unit: i.unit,\n notes: i.notes,\n fdcId: i.fdcId,\n fdcDescription: i.fdcDescription,\n fdcDataType: i.fdcDataType,\n }))\n );\n}\n\n// ============ GROCERY LIST QUERIES ============\n\nexport async function getGroceryListsByUser(userId: string): Promise {\n const listsResult = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n const lists: GroceryList[] = [];\n\n for (const row of listsResult.rows) {\n const listId = row.id as string;\n\n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n\n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n\n lists.push({\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n });\n }\n\n return lists;\n}\n\nexport async function getGroceryListById(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n\n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n\n return {\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n };\n}\n\nexport async function createGroceryList(userId: string, name: string): Promise {\n const listId = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${GROCERY_LISTS_TABLE} (id, user_id, name) VALUES (?, ?, ?)`,\n [listId, userId, name]\n );\n\n return {\n id: listId,\n userId,\n name,\n createdAt: now,\n updatedAt: now,\n items: [],\n };\n}\n\nexport async function updateGroceryList(listId: string, userId: string, name: string): Promise {\n const existing = await getGroceryListById(listId, userId);\n if (!existing) return null;\n\n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET name = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ? AND user_id = ?`,\n [name, listId, userId]\n );\n\n return getGroceryListById(listId, userId);\n}\n\nexport async function deleteGroceryList(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function addGroceryItem(\n listId: string,\n userId: string,\n name: string,\n quantity: number | null,\n unit: string | null,\n recipeId: string | null = null,\n recipeName: string | null = null\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return null;\n\n const itemId = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${GROCERY_LIST_ITEMS_TABLE} (id, list_id, name, quantity, unit, recipe_id, recipe_name)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [itemId, listId, name, quantity, unit, recipeId, recipeName]\n );\n\n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [listId]\n );\n\n return {\n id: itemId,\n listId,\n name,\n quantity,\n unit,\n recipeId,\n recipeName,\n checked: false,\n createdAt: now,\n };\n}\n\nexport async function addRecipeIngredientsToList(\n listId: string,\n userId: string,\n recipeId: string\n): Promise {\n const recipe = await getRecipeById(recipeId, userId);\n if (!recipe) return [];\n\n const items: GroceryListItem[] = [];\n\n for (const ing of recipe.ingredients) {\n const item = await addGroceryItem(\n listId,\n userId,\n ing.name,\n ing.amount,\n ing.unit,\n recipeId,\n recipe.title\n );\n if (item) items.push(item);\n }\n\n return items;\n}\n\nexport async function updateGroceryItemChecked(\n itemId: string,\n listId: string,\n userId: string,\n checked: boolean\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n\n const result = await sqlite.execute(\n `UPDATE ${GROCERY_LIST_ITEMS_TABLE} SET checked = ? WHERE id = ? AND list_id = ?`,\n [checked ? 1 : 0, itemId, listId]\n );\n\n return result.rowsAffected > 0;\n}\n\nexport async function deleteGroceryItem(itemId: string, listId: string, userId: string): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n\n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE id = ? AND list_id = ?`,\n [itemId, listId]\n );\n\n return result.rowsAffected > 0;\n}\n\n// ============ NUTRITION GOALS QUERIES ============\n\nexport async function getNutritionGoals(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, primary_goal_type, primary_goal_value, \n sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value, updated_at\n FROM ${NUTRITION_GOALS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n return {\n id: row.id as string,\n userId: row.user_id as string,\n primaryGoalType: row.primary_goal_type as any,\n primaryGoalValue: row.primary_goal_value as number,\n subGoal1Type: row.sub_goal_1_type as any | null,\n subGoal1Value: row.sub_goal_1_value as number | null,\n subGoal2Type: row.sub_goal_2_type as any | null,\n subGoal2Value: row.sub_goal_2_value as number | null,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function setNutritionGoals(\n userId: string,\n primaryGoalType: string,\n primaryGoalValue: number,\n subGoal1Type: string | null,\n subGoal1Value: number | null,\n subGoal2Type: string | null,\n subGoal2Value: number | null\n): Promise {\n const existing = await getNutritionGoals(userId);\n const now = new Date().toISOString();\n\n if (existing) {\n await sqlite.execute(\n `UPDATE ${NUTRITION_GOALS_TABLE} \n SET primary_goal_type = ?, primary_goal_value = ?,\n sub_goal_1_type = ?, sub_goal_1_value = ?,\n sub_goal_2_type = ?, sub_goal_2_value = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE user_id = ?`,\n [primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value, userId]\n );\n\n return {\n ...existing,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n }\n\n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${NUTRITION_GOALS_TABLE} \n (id, user_id, primary_goal_type, primary_goal_value, sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, userId, primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value]\n );\n\n return {\n id,\n userId,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n}\n\n// ============ MEAL PLAN QUERIES ============\n\nexport async function getMealPlan(userId: string, weekStartDate: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, week_start_date, created_at, updated_at\n FROM ${MEAL_PLANS_TABLE} WHERE user_id = ? AND week_start_date = ?`,\n [userId, weekStartDate]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const mealPlanId = row.id as string;\n\n // Get all entries (recipes, custom foods, and FDC ingredients)\n const entriesResult = await sqlite.execute(\n `SELECT id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams\n FROM ${MEAL_PLAN_ENTRIES_TABLE}\n WHERE meal_plan_id = ?\n ORDER BY day_of_week, meal_type`,\n [mealPlanId]\n );\n\n const entries: MealPlanEntry[] = [];\n for (const e of entriesResult.rows) {\n const entry: MealPlanEntry = {\n id: e.id as string,\n mealPlanId: e.meal_plan_id as string,\n dayOfWeek: e.day_of_week as DayOfWeek,\n mealType: e.meal_type as MealType,\n recipeId: e.recipe_id as string | null,\n customFoodId: e.custom_food_id as string | null,\n fdcId: e.fdc_id as number | null,\n servings: e.servings as number,\n amountGrams: e.amount_grams as number | null,\n };\n\n // Populate associated data based on entry type\n if (entry.recipeId) {\n const recipe = await getRecipeById(entry.recipeId, userId);\n if (recipe) entry.recipe = recipe;\n } else if (entry.customFoodId) {\n const customFood = await getCustomFoodById(entry.customFoodId, userId);\n if (customFood) entry.customFood = customFood;\n } else if (entry.fdcId) {\n const fdcFood = await getFDCFoodFromCache(entry.fdcId);\n if (fdcFood) entry.fdcFood = fdcFood;\n }\n\n entries.push(entry);\n }\n\n return {\n id: mealPlanId,\n userId: row.user_id as string,\n weekStartDate: row.week_start_date as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n entries,\n };\n}\n\nexport async function getOrCreateMealPlan(userId: string, weekStartDate: string): Promise {\n const existing = await getMealPlan(userId, weekStartDate);\n if (existing) return existing;\n\n const id = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${MEAL_PLANS_TABLE} (id, user_id, week_start_date) VALUES (?, ?, ?)`,\n [id, userId, weekStartDate]\n );\n\n return {\n id,\n userId,\n weekStartDate,\n createdAt: now,\n updatedAt: now,\n entries: [],\n };\n}\n\n// Add entry to meal plan - supports recipes, custom foods, or FDC ingredients\nexport async function addMealPlanEntry(\n userId: string,\n weekStartDate: string,\n dayOfWeek: DayOfWeek,\n mealType: MealType,\n options: {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number;\n }\n): Promise {\n const { recipeId, customFoodId, fdcId, servings = 1, amountGrams } = options;\n\n // Validate that exactly one of the IDs is provided\n const idCount = [recipeId, customFoodId, fdcId].filter(Boolean).length;\n if (idCount !== 1) {\n return null;\n }\n\n // Verify ownership/existence based on entry type\n let recipe: Recipe | undefined;\n let customFood: CustomFood | undefined;\n let fdcFood: FDCFood | undefined;\n\n if (recipeId) {\n const r = await getRecipeById(recipeId, userId);\n if (!r) return null;\n recipe = r;\n } else if (customFoodId) {\n const cf = await getCustomFoodById(customFoodId, userId);\n if (!cf) return null;\n customFood = cf;\n } else if (fdcId) {\n const fdc = await getFDCFoodFromCache(fdcId);\n if (!fdc) return null;\n fdcFood = fdc;\n }\n\n const mealPlan = await getOrCreateMealPlan(userId, weekStartDate);\n const entryId = generateId();\n\n await sqlite.execute(\n `INSERT INTO ${MEAL_PLAN_ENTRIES_TABLE} \n (id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [entryId, mealPlan.id, dayOfWeek, mealType, recipeId ?? null, customFoodId ?? null, fdcId ?? null, servings, amountGrams ?? null]\n );\n\n await sqlite.execute(\n `UPDATE ${MEAL_PLANS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [mealPlan.id]\n );\n\n return {\n id: entryId,\n mealPlanId: mealPlan.id,\n dayOfWeek,\n mealType,\n recipeId: recipeId ?? null,\n customFoodId: customFoodId ?? null,\n fdcId: fdcId ?? null,\n recipe,\n customFood,\n fdcFood,\n servings,\n amountGrams: amountGrams ?? null,\n };\n}\n\nexport async function deleteMealPlanEntry(entryId: string, userId: string): Promise {\n // Get entry and verify ownership through meal plan\n const entryResult = await sqlite.execute(\n `SELECT e.id, e.meal_plan_id, m.user_id\n FROM ${MEAL_PLAN_ENTRIES_TABLE} e\n JOIN ${MEAL_PLANS_TABLE} m ON e.meal_plan_id = m.id\n WHERE e.id = ?`,\n [entryId]\n );\n\n if (entryResult.rows.length === 0) return false;\n if (entryResult.rows[0].user_id !== userId) return false;\n\n const result = await sqlite.execute(\n `DELETE FROM ${MEAL_PLAN_ENTRIES_TABLE} WHERE id = ?`,\n [entryId]\n );\n\n return result.rowsAffected > 0;\n}\n\nexport async function scheduleMeals(\n userId: string,\n weekStartDate: string,\n options: {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number;\n },\n mealType: MealType,\n days: DayOfWeek[]\n): Promise {\n const entries: MealPlanEntry[] = [];\n\n for (const day of days) {\n const entry = await addMealPlanEntry(userId, weekStartDate, day, mealType, options);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\n// ============ SCRAPER EVAL URL QUERIES ============\n\nexport interface ScraperEvalUrl {\n id: string;\n userId: string;\n url: string;\n createdAt: string;\n}\n\nexport async function getScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, url, created_at FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n url: row.url as string,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addScraperEvalUrl(userId: string, url: string): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n try {\n await sqlite.execute(\n `INSERT INTO ${SCRAPER_EVAL_URLS_TABLE} (id, user_id, url) VALUES (?, ?, ?)`,\n [id, userId, url]\n );\n\n return { id, userId, url, createdAt: now };\n } catch (error) {\n // URL already exists for this user (unique constraint)\n return null;\n }\n}\n\nexport async function addScraperEvalUrls(userId: string, urls: string[]): Promise {\n const added: ScraperEvalUrl[] = [];\n\n for (const url of urls) {\n const result = await addScraperEvalUrl(userId, url);\n if (result) added.push(result);\n }\n\n return added;\n}\n\nexport async function deleteScraperEvalUrl(userId: string, urlId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE id = ? AND user_id = ?`,\n [urlId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function deleteAllScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n return result.rowsAffected;\n}\n\n// ============ STARRED INGREDIENTS QUERIES ============\n\nexport async function getStarredIngredients(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner, created_at\n FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n fdcId: row.fdc_id as number,\n fdcDescription: row.fdc_description as string,\n fdcDataType: row.fdc_data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addStarredIngredient(\n userId: string,\n fdcId: number,\n fdcDescription: string,\n fdcDataType: FDCDataType,\n brandOwner: string | null\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n try {\n await sqlite.execute(\n `INSERT INTO ${STARRED_INGREDIENTS_TABLE} (id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, userId, fdcId, fdcDescription, fdcDataType, brandOwner]\n );\n\n return { id, userId, fdcId, fdcDescription, fdcDataType, brandOwner, createdAt: now };\n } catch (error) {\n // Already starred (unique constraint on user_id + fdc_id)\n return null;\n }\n}\n\nexport async function removeStarredIngredient(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ?`,\n [userId, fdcId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function isIngredientStarred(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ? LIMIT 1`,\n [userId, fdcId]\n );\n return result.rows.length > 0;\n}\n\n// ============ CUSTOM FOODS QUERIES ============\n\nfunction mapCustomFoodRow(row: any): CustomFood {\n return {\n id: row.id as string,\n userId: row.user_id as string,\n name: row.name as string,\n servingSizeGrams: row.serving_size_grams as number,\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 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 vitaminA: row.vitamin_a as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k 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 folate: row.folate as number | null,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function getCustomFoodsByUser(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n created_at, updated_at\n FROM ${CUSTOM_FOODS_TABLE} WHERE user_id = ? ORDER BY name`,\n [userId]\n );\n\n return result.rows.map(mapCustomFoodRow);\n}\n\nexport async function getCustomFoodById(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n created_at, updated_at\n FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n\n if (result.rows.length === 0) return null;\n return mapCustomFoodRow(result.rows[0]);\n}\n\nexport async function createCustomFood(\n userId: string,\n data: CreateCustomFoodRequest\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, userId, data.name, data.servingSizeGrams ?? 100,\n data.calories ?? null, data.protein ?? null, data.fat ?? null, data.carbs ?? null, data.fiber ?? null,\n data.sodium ?? null, data.potassium ?? null, data.calcium ?? null, data.iron ?? null, data.magnesium ?? null, data.zinc ?? null,\n data.vitaminA ?? null, data.vitaminC ?? null, data.vitaminD ?? null, data.vitaminE ?? null, data.vitaminK ?? null,\n data.vitaminB6 ?? null, data.vitaminB12 ?? null, data.thiamin ?? null, data.riboflavin ?? null, data.niacin ?? null, data.folate ?? null,\n ]\n );\n\n return {\n id,\n userId,\n name: data.name,\n servingSizeGrams: data.servingSizeGrams ?? 100,\n calories: data.calories ?? null,\n protein: data.protein ?? null,\n fat: data.fat ?? null,\n carbs: data.carbs ?? null,\n fiber: data.fiber ?? null,\n sodium: data.sodium ?? null,\n potassium: data.potassium ?? null,\n calcium: data.calcium ?? null,\n iron: data.iron ?? null,\n magnesium: data.magnesium ?? null,\n zinc: data.zinc ?? null,\n vitaminA: data.vitaminA ?? null,\n vitaminC: data.vitaminC ?? null,\n vitaminD: data.vitaminD ?? null,\n vitaminE: data.vitaminE ?? null,\n vitaminK: data.vitaminK ?? null,\n vitaminB6: data.vitaminB6 ?? null,\n vitaminB12: data.vitaminB12 ?? null,\n thiamin: data.thiamin ?? null,\n riboflavin: data.riboflavin ?? null,\n niacin: data.niacin ?? null,\n folate: data.folate ?? null,\n createdAt: now,\n updatedAt: now,\n };\n}\n\nexport async function updateCustomFood(\n customFoodId: string,\n userId: string,\n data: Partial\n): Promise {\n // Check ownership\n const existing = await getCustomFoodById(customFoodId, userId);\n if (!existing) return null;\n\n const fields: string[] = [];\n const values: any[] = [];\n\n if (data.name !== undefined) { fields.push('name = ?'); values.push(data.name); }\n if (data.servingSizeGrams !== undefined) { fields.push('serving_size_grams = ?'); values.push(data.servingSizeGrams); }\n if (data.calories !== undefined) { fields.push('calories = ?'); values.push(data.calories); }\n if (data.protein !== undefined) { fields.push('protein = ?'); values.push(data.protein); }\n if (data.fat !== undefined) { fields.push('fat = ?'); values.push(data.fat); }\n if (data.carbs !== undefined) { fields.push('carbs = ?'); values.push(data.carbs); }\n if (data.fiber !== undefined) { fields.push('fiber = ?'); values.push(data.fiber); }\n if (data.sodium !== undefined) { fields.push('sodium = ?'); values.push(data.sodium); }\n if (data.potassium !== undefined) { fields.push('potassium = ?'); values.push(data.potassium); }\n if (data.calcium !== undefined) { fields.push('calcium = ?'); values.push(data.calcium); }\n if (data.iron !== undefined) { fields.push('iron = ?'); values.push(data.iron); }\n if (data.magnesium !== undefined) { fields.push('magnesium = ?'); values.push(data.magnesium); }\n if (data.zinc !== undefined) { fields.push('zinc = ?'); values.push(data.zinc); }\n if (data.vitaminA !== undefined) { fields.push('vitamin_a = ?'); values.push(data.vitaminA); }\n if (data.vitaminC !== undefined) { fields.push('vitamin_c = ?'); values.push(data.vitaminC); }\n if (data.vitaminD !== undefined) { fields.push('vitamin_d = ?'); values.push(data.vitaminD); }\n if (data.vitaminE !== undefined) { fields.push('vitamin_e = ?'); values.push(data.vitaminE); }\n if (data.vitaminK !== undefined) { fields.push('vitamin_k = ?'); values.push(data.vitaminK); }\n if (data.vitaminB6 !== undefined) { fields.push('vitamin_b6 = ?'); values.push(data.vitaminB6); }\n if (data.vitaminB12 !== undefined) { fields.push('vitamin_b12 = ?'); values.push(data.vitaminB12); }\n if (data.thiamin !== undefined) { fields.push('thiamin = ?'); values.push(data.thiamin); }\n if (data.riboflavin !== undefined) { fields.push('riboflavin = ?'); values.push(data.riboflavin); }\n if (data.niacin !== undefined) { fields.push('niacin = ?'); values.push(data.niacin); }\n if (data.folate !== undefined) { fields.push('folate = ?'); values.push(data.folate); }\n\n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(customFoodId, userId);\n await sqlite.execute(\n `UPDATE ${CUSTOM_FOODS_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n\n return getCustomFoodById(customFoodId, userId);\n}\n\nexport async function deleteCustomFood(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n return result.rowsAffected > 0;\n}\n\n// ============ FDC FOOD CACHE QUERIES ============\n\nfunction mapFDCFoodRow(row: any): FDCFood {\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 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 vitaminA: row.vitamin_a as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k 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 folate: row.folate as number | null,\n },\n cachedAt: row.cached_at as string,\n };\n}\n\nexport async function getFDCFoodFromCache(fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT fdc_id, description, data_type, brand_owner, brand_name,\n serving_size, serving_size_unit, household_serving_text,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n cached_at\n FROM ${FDC_FOODS_CACHE_TABLE} WHERE fdc_id = ?`,\n [fdcId]\n );\n\n if (result.rows.length === 0) return null;\n return mapFDCFoodRow(result.rows[0]);\n}\n\n\n","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport {\n USERS_TABLE,\n SESSIONS_TABLE,\n RECIPES_TABLE,\n RECIPE_INGREDIENTS_TABLE,\n RECIPE_NUTRITION_TABLE,\n FDC_FOODS_CACHE_TABLE,\n GROCERY_LISTS_TABLE,\n GROCERY_LIST_ITEMS_TABLE,\n NUTRITION_GOALS_TABLE,\n MEAL_PLANS_TABLE,\n MEAL_PLAN_ENTRIES_TABLE,\n SCRAPER_EVAL_URLS_TABLE,\n STARRED_INGREDIENTS_TABLE,\n CUSTOM_FOODS_TABLE,\n} from \"./migrations.ts\";\nimport type {\n User,\n Recipe,\n RecipeIngredient,\n RecipeNutrition,\n GroceryList,\n GroceryListItem,\n NutritionGoals,\n MealPlan,\n MealPlanEntry,\n DayOfWeek,\n MealType,\n FDCDataType,\n CreateRecipeIngredient,\n StarredIngredient,\n CustomFood,\n CreateCustomFoodRequest,\n FDCFood,\n FDCNutrition,\n} from \"../../shared/types.ts\";\nimport { ALL_NUTRIENT_KEYS } from \"../../shared/types.ts\";\nimport { calculateRecipeNutrition, convertToGrams } from \"../services/nutrition-calculator.ts\";\n\n// Generate unique IDs\nfunction generateId(): string {\n return crypto.randomUUID();\n}\n\n// ============ USER QUERIES ============\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function createOrUpdateUser(\n email: string,\n name: string | null,\n picture: string | null\n): Promise {\n const existing = await getUserByEmail(email);\n\n if (existing) {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET name = ?, picture = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [name, picture, existing.id]\n );\n return { ...existing, name, picture };\n }\n\n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, email, name, picture) VALUES (?, ?, ?, ?)`,\n [id, email, name, picture]\n );\n return { id, email, name, picture };\n}\n\n// ============ SESSION QUERIES ============\n\nexport async function createSession(userId: string): Promise {\n const sessionId = generateId();\n const expiresAt = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString(); // 30 days\n\n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [sessionId, userId, expiresAt]\n );\n\n return sessionId;\n}\n\nexport async function getSessionUser(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT u.id, u.email, u.name, u.picture\n FROM ${SESSIONS_TABLE} s\n JOIN ${USERS_TABLE} u ON s.user_id = u.id\n WHERE s.id = ? AND s.expires_at > datetime('now')`,\n [sessionId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n}\n\n// ============ RECIPE QUERIES ============\n\n// Helper to map nutrition row to RecipeNutrition with all nutrients\nfunction mapNutritionRow(n: any, recipeId: string): RecipeNutrition {\n return {\n id: n.id as string,\n recipeId: recipeId,\n // Energy\n calories: n.calories as number | null,\n // Macronutrients\n protein: n.protein as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n fiber: n.fiber as number | null,\n sugars: n.sugars as number | null,\n addedSugars: n.added_sugars as number | null,\n starch: n.starch as number | null,\n // Fats breakdown\n saturatedFat: n.saturated_fat as number | null,\n transFat: n.trans_fat as number | null,\n monounsaturatedFat: n.monounsaturated_fat as number | null,\n polyunsaturatedFat: n.polyunsaturated_fat as number | null,\n cholesterol: n.cholesterol as number | null,\n // Other macros\n water: n.water as number | null,\n alcohol: n.alcohol as number | null,\n caffeine: n.caffeine as number | null,\n // Minerals\n sodium: n.sodium as number | null,\n potassium: n.potassium as number | null,\n calcium: n.calcium as number | null,\n iron: n.iron as number | null,\n magnesium: n.magnesium as number | null,\n zinc: n.zinc as number | null,\n phosphorus: n.phosphorus as number | null,\n selenium: n.selenium as number | null,\n copper: n.copper as number | null,\n manganese: n.manganese as number | null,\n fluoride: n.fluoride as number | null,\n chromium: n.chromium as number | null,\n molybdenum: n.molybdenum as number | null,\n iodine: n.iodine as number | null,\n chloride: n.chloride as number | null,\n // Vitamins - Fat soluble\n vitaminA: n.vitamin_a as number | null,\n retinol: n.retinol as number | null,\n betaCarotene: n.beta_carotene as number | null,\n alphaCarotene: n.alpha_carotene as number | null,\n betaCryptoxanthin: n.beta_cryptoxanthin as number | null,\n lycopene: n.lycopene as number | null,\n luteinZeaxanthin: n.lutein_zeaxanthin as number | null,\n vitaminD: n.vitamin_d as number | null,\n vitaminD2: n.vitamin_d2 as number | null,\n vitaminD3: n.vitamin_d3 as number | null,\n vitaminE: n.vitamin_e as number | null,\n vitaminK: n.vitamin_k as number | null,\n vitaminK2: n.vitamin_k2 as number | null,\n // Vitamins - Water soluble\n vitaminC: n.vitamin_c as number | null,\n vitaminB6: n.vitamin_b6 as number | null,\n vitaminB12: n.vitamin_b12 as number | null,\n thiamin: n.thiamin as number | null,\n riboflavin: n.riboflavin as number | null,\n niacin: n.niacin as number | null,\n pantothenicAcid: n.pantothenic_acid as number | null,\n biotin: n.biotin as number | null,\n folate: n.folate as number | null,\n folicAcid: n.folic_acid as number | null,\n choline: n.choline as number | null,\n betaine: n.betaine as number | null,\n // Metadata\n isComplete: Boolean(n.is_complete),\n };\n}\n\n// SQL column list for nutrition table SELECT queries\nconst NUTRITION_SELECT_COLUMNS = `\n id, recipe_id, calories,\n 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 is_complete\n`;\n\nexport async function getRecipesByUser(userId: string): Promise {\n const recipesResult = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n const recipes: Recipe[] = [];\n\n for (const row of recipesResult.rows) {\n const recipeId = row.id as string;\n\n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n\n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n\n // Get nutrition with all nutrients\n const nutritionResult = await sqlite.execute(\n `SELECT ${NUTRITION_SELECT_COLUMNS} FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n\n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n\n recipes.push({\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n });\n }\n\n return recipes;\n}\n\nexport async function getRecipeById(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n\n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n\n // Get nutrition with all nutrients\n const nutritionResult = await sqlite.execute(\n `SELECT ${NUTRITION_SELECT_COLUMNS} FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n\n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n\n return {\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n };\n}\n\n// Helper to build INSERT statement for nutrition\nfunction buildNutritionInsert(nutId: string, recipeId: string, n: any): { sql: string; values: any[] } {\n return {\n sql: `INSERT INTO ${RECIPE_NUTRITION_TABLE} (\n id, recipe_id, calories,\n 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 is_complete\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n values: [\n nutId, recipeId, n.calories,\n 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 n.isComplete ? 1 : 0\n ]\n };\n}\n\nexport async function createRecipe(\n userId: string,\n title: string,\n url: string | null,\n instructions: string | null,\n servingSize: number,\n ingredients: CreateRecipeIngredient[]\n): Promise {\n const recipeId = generateId();\n\n await sqlite.execute(\n `INSERT INTO ${RECIPES_TABLE} (id, user_id, title, url, instructions, serving_size)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [recipeId, userId, title, url, instructions, servingSize]\n );\n\n // Insert ingredients with FDC fields\n const recipeIngredients: RecipeIngredient[] = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ing = ingredients[i];\n const ingId = generateId();\n\n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name,\n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n\n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n\n // Insert calculated nutrition\n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n const { sql, values } = buildNutritionInsert(nutId, recipeId, n);\n await sqlite.execute(sql, values);\n\n const recipeNutrition: RecipeNutrition = {\n id: nutId,\n recipeId,\n ...n,\n };\n\n const now = new Date().toISOString();\n return {\n id: recipeId,\n userId,\n title,\n url,\n instructions,\n servingSize,\n createdAt: now,\n updatedAt: now,\n ingredients: recipeIngredients,\n nutrition: recipeNutrition,\n };\n}\n\nexport async function updateRecipe(\n recipeId: string,\n userId: string,\n updates: {\n title?: string;\n url?: string | null;\n instructions?: string | null;\n servingSize?: number;\n ingredients?: CreateRecipeIngredient[];\n }\n): Promise {\n // Check ownership\n const existing = await getRecipeById(recipeId, userId);\n if (!existing) return null;\n\n // Update recipe\n const fields: string[] = [];\n const values: any[] = [];\n\n if (updates.title !== undefined) {\n fields.push('title = ?');\n values.push(updates.title);\n }\n if (updates.url !== undefined) {\n fields.push('url = ?');\n values.push(updates.url);\n }\n if (updates.instructions !== undefined) {\n fields.push('instructions = ?');\n values.push(updates.instructions);\n }\n if (updates.servingSize !== undefined) {\n fields.push('serving_size = ?');\n values.push(updates.servingSize);\n }\n\n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(recipeId, userId);\n await sqlite.execute(\n `UPDATE ${RECIPES_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n\n // Determine the serving size to use for nutrition calculation\n const servingSize = updates.servingSize ?? existing.servingSize;\n\n // Update ingredients if provided\n let recipeIngredients: RecipeIngredient[] = existing.ingredients;\n if (updates.ingredients !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ?`, [recipeId]);\n recipeIngredients = [];\n\n for (let i = 0; i < updates.ingredients.length; i++) {\n const ing = updates.ingredients[i];\n const ingId = generateId();\n\n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name,\n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n }\n\n // Recalculate nutrition if ingredients or serving size changed\n if (updates.ingredients !== undefined || updates.servingSize !== undefined) {\n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n\n // Update nutrition\n await sqlite.execute(`DELETE FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`, [recipeId]);\n\n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n const { sql, values } = buildNutritionInsert(nutId, recipeId, n);\n await sqlite.execute(sql, values);\n }\n\n return getRecipeById(recipeId, userId);\n}\n\nexport async function deleteRecipe(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function duplicateRecipe(recipeId: string, userId: string): Promise {\n const original = await getRecipeById(recipeId, userId);\n if (!original) return null;\n\n return createRecipe(\n userId,\n `${original.title} (Copy)`,\n original.url,\n original.instructions,\n original.servingSize,\n original.ingredients.map(i => ({\n name: i.name,\n amount: i.amount,\n unit: i.unit,\n notes: i.notes,\n fdcId: i.fdcId,\n fdcDescription: i.fdcDescription,\n fdcDataType: i.fdcDataType,\n }))\n );\n}\n\n// ============ GROCERY LIST QUERIES ============\n\nexport async function getGroceryListsByUser(userId: string): Promise {\n const listsResult = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n const lists: GroceryList[] = [];\n\n for (const row of listsResult.rows) {\n const listId = row.id as string;\n\n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n\n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n\n lists.push({\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n });\n }\n\n return lists;\n}\n\nexport async function getGroceryListById(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n\n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n\n return {\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n };\n}\n\nexport async function createGroceryList(userId: string, name: string): Promise {\n const listId = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${GROCERY_LISTS_TABLE} (id, user_id, name) VALUES (?, ?, ?)`,\n [listId, userId, name]\n );\n\n return {\n id: listId,\n userId,\n name,\n createdAt: now,\n updatedAt: now,\n items: [],\n };\n}\n\nexport async function updateGroceryList(listId: string, userId: string, name: string): Promise {\n const existing = await getGroceryListById(listId, userId);\n if (!existing) return null;\n\n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET name = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ? AND user_id = ?`,\n [name, listId, userId]\n );\n\n return getGroceryListById(listId, userId);\n}\n\nexport async function deleteGroceryList(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function addGroceryItem(\n listId: string,\n userId: string,\n name: string,\n quantity: number | null,\n unit: string | null,\n recipeId: string | null = null,\n recipeName: string | null = null\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return null;\n\n const itemId = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${GROCERY_LIST_ITEMS_TABLE} (id, list_id, name, quantity, unit, recipe_id, recipe_name)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [itemId, listId, name, quantity, unit, recipeId, recipeName]\n );\n\n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [listId]\n );\n\n return {\n id: itemId,\n listId,\n name,\n quantity,\n unit,\n recipeId,\n recipeName,\n checked: false,\n createdAt: now,\n };\n}\n\nexport async function addRecipeIngredientsToList(\n listId: string,\n userId: string,\n recipeId: string\n): Promise {\n const recipe = await getRecipeById(recipeId, userId);\n if (!recipe) return [];\n\n const items: GroceryListItem[] = [];\n\n for (const ing of recipe.ingredients) {\n const item = await addGroceryItem(\n listId,\n userId,\n ing.name,\n ing.amount,\n ing.unit,\n recipeId,\n recipe.title\n );\n if (item) items.push(item);\n }\n\n return items;\n}\n\nexport async function updateGroceryItemChecked(\n itemId: string,\n listId: string,\n userId: string,\n checked: boolean\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n\n const result = await sqlite.execute(\n `UPDATE ${GROCERY_LIST_ITEMS_TABLE} SET checked = ? WHERE id = ? AND list_id = ?`,\n [checked ? 1 : 0, itemId, listId]\n );\n\n return result.rowsAffected > 0;\n}\n\nexport async function deleteGroceryItem(itemId: string, listId: string, userId: string): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n\n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE id = ? AND list_id = ?`,\n [itemId, listId]\n );\n\n return result.rowsAffected > 0;\n}\n\n// ============ NUTRITION GOALS QUERIES ============\n\nexport async function getNutritionGoals(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, primary_goal_type, primary_goal_value, \n sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value, updated_at\n FROM ${NUTRITION_GOALS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n\n return {\n id: row.id as string,\n userId: row.user_id as string,\n primaryGoalType: row.primary_goal_type as any,\n primaryGoalValue: row.primary_goal_value as number,\n subGoal1Type: row.sub_goal_1_type as any | null,\n subGoal1Value: row.sub_goal_1_value as number | null,\n subGoal2Type: row.sub_goal_2_type as any | null,\n subGoal2Value: row.sub_goal_2_value as number | null,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function setNutritionGoals(\n userId: string,\n primaryGoalType: string,\n primaryGoalValue: number,\n subGoal1Type: string | null,\n subGoal1Value: number | null,\n subGoal2Type: string | null,\n subGoal2Value: number | null\n): Promise {\n const existing = await getNutritionGoals(userId);\n const now = new Date().toISOString();\n\n if (existing) {\n await sqlite.execute(\n `UPDATE ${NUTRITION_GOALS_TABLE} \n SET primary_goal_type = ?, primary_goal_value = ?,\n sub_goal_1_type = ?, sub_goal_1_value = ?,\n sub_goal_2_type = ?, sub_goal_2_value = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE user_id = ?`,\n [primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value, userId]\n );\n\n return {\n ...existing,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n }\n\n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${NUTRITION_GOALS_TABLE} \n (id, user_id, primary_goal_type, primary_goal_value, sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, userId, primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value]\n );\n\n return {\n id,\n userId,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n}\n\n// ============ MEAL PLAN QUERIES ============\n\n// SQL for FDC food cache SELECT\nconst FDC_FOOD_SELECT_COLUMNS = `\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`;\n\nfunction mapFDCFoodRow(row: any): FDCFood {\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\nexport async function getFDCFoodFromCache(fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT ${FDC_FOOD_SELECT_COLUMNS} FROM ${FDC_FOODS_CACHE_TABLE} WHERE fdc_id = ?`,\n [fdcId]\n );\n\n if (result.rows.length === 0) return null;\n return mapFDCFoodRow(result.rows[0]);\n}\n\n// Custom foods SQL\nconst CUSTOM_FOOD_SELECT_COLUMNS = `\n id, user_id, name, serving_size_grams,\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 created_at, updated_at\n`;\n\nfunction mapCustomFoodRow(row: any): CustomFood {\n return {\n id: row.id as string,\n userId: row.user_id as string,\n name: row.name as string,\n servingSizeGrams: row.serving_size_grams as number,\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 createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function getMealPlan(userId: string, weekStartDate: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, week_start_date, created_at, updated_at\n FROM ${MEAL_PLANS_TABLE} WHERE user_id = ? AND week_start_date = ?`,\n [userId, weekStartDate]\n );\n\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const mealPlanId = row.id as string;\n\n // Get all entries (recipes, custom foods, and FDC ingredients)\n const entriesResult = await sqlite.execute(\n `SELECT id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams\n FROM ${MEAL_PLAN_ENTRIES_TABLE}\n WHERE meal_plan_id = ?\n ORDER BY day_of_week, meal_type`,\n [mealPlanId]\n );\n\n const entries: MealPlanEntry[] = [];\n for (const e of entriesResult.rows) {\n const entry: MealPlanEntry = {\n id: e.id as string,\n mealPlanId: e.meal_plan_id as string,\n dayOfWeek: e.day_of_week as DayOfWeek,\n mealType: e.meal_type as MealType,\n recipeId: e.recipe_id as string | null,\n customFoodId: e.custom_food_id as string | null,\n fdcId: e.fdc_id as number | null,\n servings: e.servings as number,\n amountGrams: e.amount_grams as number | null,\n };\n\n // Populate associated data based on entry type\n if (entry.recipeId) {\n const recipe = await getRecipeById(entry.recipeId, userId);\n if (recipe) entry.recipe = recipe;\n } else if (entry.customFoodId) {\n const customFood = await getCustomFoodById(entry.customFoodId, userId);\n if (customFood) entry.customFood = customFood;\n } else if (entry.fdcId) {\n const fdcFood = await getFDCFoodFromCache(entry.fdcId);\n if (fdcFood) entry.fdcFood = fdcFood;\n }\n\n entries.push(entry);\n }\n\n return {\n id: mealPlanId,\n userId: row.user_id as string,\n weekStartDate: row.week_start_date as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n entries,\n };\n}\n\nexport async function getOrCreateMealPlan(userId: string, weekStartDate: string): Promise {\n const existing = await getMealPlan(userId, weekStartDate);\n if (existing) return existing;\n\n const id = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${MEAL_PLANS_TABLE} (id, user_id, week_start_date) VALUES (?, ?, ?)`,\n [id, userId, weekStartDate]\n );\n\n return {\n id,\n userId,\n weekStartDate,\n createdAt: now,\n updatedAt: now,\n entries: [],\n };\n}\n\n// Add entry to meal plan - supports recipes, custom foods, or FDC ingredients\nexport async function addMealPlanEntry(\n userId: string,\n weekStartDate: string,\n dayOfWeek: DayOfWeek,\n mealType: MealType,\n options: {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number;\n }\n): Promise {\n const { recipeId, customFoodId, fdcId, servings = 1, amountGrams } = options;\n\n // Validate that exactly one of the IDs is provided\n const idCount = [recipeId, customFoodId, fdcId].filter(Boolean).length;\n if (idCount !== 1) {\n return null;\n }\n\n // Verify ownership/existence based on entry type\n let recipe: Recipe | undefined;\n let customFood: CustomFood | undefined;\n let fdcFood: FDCFood | undefined;\n\n if (recipeId) {\n const r = await getRecipeById(recipeId, userId);\n if (!r) return null;\n recipe = r;\n } else if (customFoodId) {\n const cf = await getCustomFoodById(customFoodId, userId);\n if (!cf) return null;\n customFood = cf;\n } else if (fdcId) {\n const fdc = await getFDCFoodFromCache(fdcId);\n if (!fdc) return null;\n fdcFood = fdc;\n }\n\n const mealPlan = await getOrCreateMealPlan(userId, weekStartDate);\n const entryId = generateId();\n\n await sqlite.execute(\n `INSERT INTO ${MEAL_PLAN_ENTRIES_TABLE} \n (id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [entryId, mealPlan.id, dayOfWeek, mealType, recipeId ?? null, customFoodId ?? null, fdcId ?? null, servings, amountGrams ?? null]\n );\n\n await sqlite.execute(\n `UPDATE ${MEAL_PLANS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [mealPlan.id]\n );\n\n return {\n id: entryId,\n mealPlanId: mealPlan.id,\n dayOfWeek,\n mealType,\n recipeId: recipeId ?? null,\n customFoodId: customFoodId ?? null,\n fdcId: fdcId ?? null,\n recipe,\n customFood,\n fdcFood,\n servings,\n amountGrams: amountGrams ?? null,\n };\n}\n\nexport async function deleteMealPlanEntry(entryId: string, userId: string): Promise {\n // Get entry and verify ownership through meal plan\n const entryResult = await sqlite.execute(\n `SELECT e.id, e.meal_plan_id, m.user_id\n FROM ${MEAL_PLAN_ENTRIES_TABLE} e\n JOIN ${MEAL_PLANS_TABLE} m ON e.meal_plan_id = m.id\n WHERE e.id = ?`,\n [entryId]\n );\n\n if (entryResult.rows.length === 0) return false;\n if (entryResult.rows[0].user_id !== userId) return false;\n\n const result = await sqlite.execute(\n `DELETE FROM ${MEAL_PLAN_ENTRIES_TABLE} WHERE id = ?`,\n [entryId]\n );\n\n return result.rowsAffected > 0;\n}\n\nexport async function scheduleMeals(\n userId: string,\n weekStartDate: string,\n options: {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number;\n },\n mealType: MealType,\n days: DayOfWeek[]\n): Promise {\n const entries: MealPlanEntry[] = [];\n\n for (const day of days) {\n const entry = await addMealPlanEntry(userId, weekStartDate, day, mealType, options);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\n// ============ SCRAPER EVAL URL QUERIES ============\n\nexport interface ScraperEvalUrl {\n id: string;\n userId: string;\n url: string;\n createdAt: string;\n}\n\nexport async function getScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, url, created_at FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n url: row.url as string,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addScraperEvalUrl(userId: string, url: string): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n try {\n await sqlite.execute(\n `INSERT INTO ${SCRAPER_EVAL_URLS_TABLE} (id, user_id, url) VALUES (?, ?, ?)`,\n [id, userId, url]\n );\n\n return { id, userId, url, createdAt: now };\n } catch (error) {\n // URL already exists for this user (unique constraint)\n return null;\n }\n}\n\nexport async function addScraperEvalUrls(userId: string, urls: string[]): Promise {\n const added: ScraperEvalUrl[] = [];\n\n for (const url of urls) {\n const result = await addScraperEvalUrl(userId, url);\n if (result) added.push(result);\n }\n\n return added;\n}\n\nexport async function deleteScraperEvalUrl(userId: string, urlId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE id = ? AND user_id = ?`,\n [urlId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function deleteAllScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n return result.rowsAffected;\n}\n\n// ============ STARRED INGREDIENTS QUERIES ============\n\nexport async function getStarredIngredients(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner, created_at\n FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n\n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n fdcId: row.fdc_id as number,\n fdcDescription: row.fdc_description as string,\n fdcDataType: row.fdc_data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addStarredIngredient(\n userId: string,\n fdcId: number,\n fdcDescription: string,\n fdcDataType: FDCDataType,\n brandOwner: string | null\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n try {\n await sqlite.execute(\n `INSERT INTO ${STARRED_INGREDIENTS_TABLE} (id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, userId, fdcId, fdcDescription, fdcDataType, brandOwner]\n );\n\n return { id, userId, fdcId, fdcDescription, fdcDataType, brandOwner, createdAt: now };\n } catch (error) {\n // Already starred (unique constraint on user_id + fdc_id)\n return null;\n }\n}\n\nexport async function removeStarredIngredient(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ?`,\n [userId, fdcId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function isIngredientStarred(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ? LIMIT 1`,\n [userId, fdcId]\n );\n return result.rows.length > 0;\n}\n\n// ============ CUSTOM FOODS QUERIES ============\n\nexport async function getCustomFoodsByUser(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT ${CUSTOM_FOOD_SELECT_COLUMNS} FROM ${CUSTOM_FOODS_TABLE} WHERE user_id = ? ORDER BY name`,\n [userId]\n );\n\n return result.rows.map(mapCustomFoodRow);\n}\n\nexport async function getCustomFoodById(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT ${CUSTOM_FOOD_SELECT_COLUMNS} FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n\n if (result.rows.length === 0) return null;\n return mapCustomFoodRow(result.rows[0]);\n}\n\nexport async function createCustomFood(\n userId: string,\n data: CreateCustomFoodRequest\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\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 ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, userId, data.name, data.servingSizeGrams ?? 100,\n data.calories ?? null, data.protein ?? null, data.fat ?? null, data.carbs ?? null, data.fiber ?? null,\n data.sugars ?? null, data.addedSugars ?? null, data.starch ?? null,\n data.saturatedFat ?? null, data.transFat ?? null, data.monounsaturatedFat ?? null, data.polyunsaturatedFat ?? null, data.cholesterol ?? null,\n data.water ?? null, data.alcohol ?? null, data.caffeine ?? null,\n data.sodium ?? null, data.potassium ?? null, data.calcium ?? null, data.iron ?? null, data.magnesium ?? null, data.zinc ?? null,\n data.phosphorus ?? null, data.selenium ?? null, data.copper ?? null, data.manganese ?? null, data.fluoride ?? null, data.chromium ?? null, data.molybdenum ?? null, data.iodine ?? null, data.chloride ?? null,\n data.vitaminA ?? null, data.retinol ?? null, data.betaCarotene ?? null, data.alphaCarotene ?? null, data.betaCryptoxanthin ?? null, data.lycopene ?? null, data.luteinZeaxanthin ?? null,\n data.vitaminD ?? null, data.vitaminD2 ?? null, data.vitaminD3 ?? null, data.vitaminE ?? null, data.vitaminK ?? null, data.vitaminK2 ?? null,\n data.vitaminC ?? null, data.vitaminB6 ?? null, data.vitaminB12 ?? null, data.thiamin ?? null, data.riboflavin ?? null, data.niacin ?? null,\n data.pantothenicAcid ?? null, data.biotin ?? null, data.folate ?? null, data.folicAcid ?? null, data.choline ?? null, data.betaine ?? null,\n ]\n );\n\n // Return created food by fetching it\n return (await getCustomFoodById(id, userId))!;\n}\n\nexport async function updateCustomFood(\n customFoodId: string,\n userId: string,\n data: Partial\n): Promise {\n // Check ownership\n const existing = await getCustomFoodById(customFoodId, userId);\n if (!existing) return null;\n\n const fields: string[] = [];\n const values: any[] = [];\n\n // Build dynamic update based on provided fields\n const fieldMappings: Array<[keyof CreateCustomFoodRequest, string]> = [\n ['name', 'name'],\n ['servingSizeGrams', 'serving_size_grams'],\n ['calories', 'calories'],\n ['protein', 'protein'],\n ['fat', 'fat'],\n ['carbs', 'carbs'],\n ['fiber', 'fiber'],\n ['sugars', 'sugars'],\n ['addedSugars', 'added_sugars'],\n ['starch', 'starch'],\n ['saturatedFat', 'saturated_fat'],\n ['transFat', 'trans_fat'],\n ['monounsaturatedFat', 'monounsaturated_fat'],\n ['polyunsaturatedFat', 'polyunsaturated_fat'],\n ['cholesterol', 'cholesterol'],\n ['water', 'water'],\n ['alcohol', 'alcohol'],\n ['caffeine', 'caffeine'],\n ['sodium', 'sodium'],\n ['potassium', 'potassium'],\n ['calcium', 'calcium'],\n ['iron', 'iron'],\n ['magnesium', 'magnesium'],\n ['zinc', 'zinc'],\n ['phosphorus', 'phosphorus'],\n ['selenium', 'selenium'],\n ['copper', 'copper'],\n ['manganese', 'manganese'],\n ['fluoride', 'fluoride'],\n ['chromium', 'chromium'],\n ['molybdenum', 'molybdenum'],\n ['iodine', 'iodine'],\n ['chloride', 'chloride'],\n ['vitaminA', 'vitamin_a'],\n ['retinol', 'retinol'],\n ['betaCarotene', 'beta_carotene'],\n ['alphaCarotene', 'alpha_carotene'],\n ['betaCryptoxanthin', 'beta_cryptoxanthin'],\n ['lycopene', 'lycopene'],\n ['luteinZeaxanthin', 'lutein_zeaxanthin'],\n ['vitaminD', 'vitamin_d'],\n ['vitaminD2', 'vitamin_d2'],\n ['vitaminD3', 'vitamin_d3'],\n ['vitaminE', 'vitamin_e'],\n ['vitaminK', 'vitamin_k'],\n ['vitaminK2', 'vitamin_k2'],\n ['vitaminC', 'vitamin_c'],\n ['vitaminB6', 'vitamin_b6'],\n ['vitaminB12', 'vitamin_b12'],\n ['thiamin', 'thiamin'],\n ['riboflavin', 'riboflavin'],\n ['niacin', 'niacin'],\n ['pantothenicAcid', 'pantothenic_acid'],\n ['biotin', 'biotin'],\n ['folate', 'folate'],\n ['folicAcid', 'folic_acid'],\n ['choline', 'choline'],\n ['betaine', 'betaine'],\n ];\n\n for (const [jsKey, dbColumn] of fieldMappings) {\n if (data[jsKey] !== undefined) {\n fields.push(`${dbColumn} = ?`);\n values.push(data[jsKey]);\n }\n }\n\n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(customFoodId, userId);\n await sqlite.execute(\n `UPDATE ${CUSTOM_FOODS_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n\n return getCustomFoodById(customFoodId, userId);\n}\n\nexport async function deleteCustomFood(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n return result.rowsAffected > 0;\n}\n","createdAt",["D",1766633823590],"branchVersion","branchId","75b5bdc8-d3a6-11f0-86d1-42dde27851f2","id","75b56760-d3a6-11f0-86d1-42dde27851f2","carmy",["D",1765137234131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","b9153140-d3a9-11f0-8d63-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",251,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":494,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":495,"_82":496,"_84":497,"_86":25},"tree",[187,206,220,222,223,224],"files",[187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224],"counts",{"_177":64,"_178":168,"_179":64,"_180":181,"_182":183},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_58":127},"carmy.shapedlines.com",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":60,"_39":175,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":176},{"_44":165,"_32":166,"_30":167,"_137":-5,"_42":43,"_41":168,"_139":60,"_39":169,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":170},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":60,"_39":162,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":164},{"_44":151,"_32":152,"_30":153,"_137":-5,"_42":43,"_41":154,"_139":25,"_39":155,"_13":64,"_34":20,"_36":156,"_24":25,"_142":-5,"_27":157},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":60,"_39":148,"_13":64,"_34":20,"_36":149,"_24":25,"_142":-5,"_27":150},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":140,"_13":64,"_34":20,"_36":141,"_24":25,"_142":-5,"_27":143},"b8fc0cce-d3a9-11f0-a23f-42dde27851f2","deno.json","b8fc0d82-d3a9-11f0-a23f-42dde27851f2","parentId",16,"latest",["D",1765138635487],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[135],"b93a060a-d3a9-11f0-b1bf-42dde27851f2","AGENTS.md","b93a06dc-d3a9-11f0-b1bf-42dde27851f2",28,["D",1765138635892],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[145],"b93ee7d8-d3a9-11f0-b1e3-42dde27851f2",".vtignore","b93ee86e-d3a9-11f0-b1e3-42dde27851f2",29,["D",1765138635895],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[152],"b856c354-d3a9-11f0-8e4b-42dde27851f2","shared","b856c412-d3a9-11f0-8e4b-42dde27851f2",3,["D",1765138634405],"directory",[159],"b82c4976-d3a9-11f0-8e4b-42dde27851f2","frontend","b82c4a48-d3a9-11f0-8e4b-42dde27851f2",1,["D",1765138634122],[166],"b8403292-d3a9-11f0-8e76-42dde27851f2","backend","b8403350-d3a9-11f0-8e76-42dde27851f2",2,["D",1765138634257],[172],"pulls","branches","forks","envVars",{"_184":161,"_186":64},"connections",{"_184":64,"_185":64},"count","unfilledCount","emptyCount",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":60,"_39":491,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":492,"_27":493},{"_44":486,"_32":476,"_30":472,"_137":173,"_42":43,"_41":487,"_139":60,"_39":488,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":489,"_27":490},{"_44":477,"_32":478,"_30":479,"_137":472,"_42":43,"_41":480,"_139":25,"_39":481,"_13":482,"_34":35,"_36":483,"_24":25,"_142":-5,"_226":484,"_27":485},{"_44":471,"_32":33,"_30":31,"_137":472,"_42":43,"_41":14,"_139":25,"_39":473,"_13":312,"_34":35,"_36":38,"_24":25,"_142":-5,"_226":474,"_27":475},{"_44":467,"_32":466,"_30":460,"_137":173,"_42":43,"_41":277,"_139":60,"_39":468,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":469,"_27":470},{"_44":457,"_32":458,"_30":459,"_137":460,"_42":43,"_41":461,"_139":60,"_39":462,"_13":161,"_34":35,"_36":463,"_24":25,"_142":-5,"_226":464,"_27":465},{"_44":453,"_32":396,"_30":390,"_137":173,"_42":43,"_41":240,"_139":60,"_39":454,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":455,"_27":456},{"_44":445,"_32":446,"_30":447,"_137":390,"_42":43,"_41":448,"_139":60,"_39":449,"_13":161,"_34":35,"_36":450,"_24":25,"_142":-5,"_226":451,"_27":452},{"_44":437,"_32":438,"_30":439,"_137":390,"_42":43,"_41":440,"_139":60,"_39":441,"_13":168,"_34":35,"_36":442,"_24":25,"_142":-5,"_226":443,"_27":444},{"_44":429,"_32":430,"_30":431,"_137":390,"_42":43,"_41":432,"_139":60,"_39":433,"_13":349,"_34":35,"_36":434,"_24":25,"_142":-5,"_226":435,"_27":436},{"_44":421,"_32":422,"_30":423,"_137":390,"_42":43,"_41":424,"_139":25,"_39":425,"_13":161,"_34":35,"_36":426,"_24":25,"_142":-5,"_226":427,"_27":428},{"_44":413,"_32":414,"_30":415,"_137":390,"_42":43,"_41":416,"_139":60,"_39":417,"_13":349,"_34":35,"_36":418,"_24":25,"_142":-5,"_226":419,"_27":420},{"_44":405,"_32":406,"_30":407,"_137":390,"_42":43,"_41":408,"_139":25,"_39":409,"_13":349,"_34":35,"_36":410,"_24":25,"_142":-5,"_226":411,"_27":412},{"_44":397,"_32":398,"_30":399,"_137":390,"_42":43,"_41":400,"_139":25,"_39":401,"_13":277,"_34":35,"_36":402,"_24":25,"_142":-5,"_226":403,"_27":404},{"_44":387,"_32":388,"_30":389,"_137":390,"_42":43,"_41":391,"_139":60,"_39":392,"_13":174,"_34":35,"_36":393,"_24":25,"_142":-5,"_226":394,"_27":395},{"_44":382,"_32":373,"_30":367,"_137":173,"_42":43,"_41":383,"_139":60,"_39":384,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":385,"_27":386},{"_44":374,"_32":375,"_30":376,"_137":367,"_42":43,"_41":377,"_139":25,"_39":378,"_13":277,"_34":35,"_36":379,"_24":25,"_142":-5,"_226":380,"_27":381},{"_44":364,"_32":365,"_30":366,"_137":367,"_42":43,"_41":368,"_139":25,"_39":369,"_13":168,"_34":35,"_36":370,"_24":25,"_142":-5,"_226":371,"_27":372},{"_44":356,"_32":357,"_30":58,"_137":173,"_42":43,"_41":358,"_139":60,"_39":359,"_13":277,"_34":360,"_36":361,"_24":25,"_142":-5,"_226":362,"_27":363},{"_44":165,"_32":166,"_30":167,"_137":-5,"_42":43,"_41":168,"_139":60,"_39":353,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":354,"_27":355},{"_44":348,"_32":281,"_30":274,"_137":167,"_42":43,"_41":349,"_139":60,"_39":350,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":351,"_27":352},{"_44":340,"_32":341,"_30":342,"_137":274,"_42":43,"_41":343,"_139":25,"_39":344,"_13":161,"_34":35,"_36":345,"_24":25,"_142":-5,"_226":346,"_27":347},{"_44":332,"_32":333,"_30":334,"_137":274,"_42":43,"_41":335,"_139":25,"_39":336,"_13":168,"_34":35,"_36":337,"_24":25,"_142":-5,"_226":338,"_27":339},{"_44":324,"_32":325,"_30":326,"_137":274,"_42":43,"_41":327,"_139":25,"_39":328,"_13":174,"_34":35,"_36":329,"_24":25,"_142":-5,"_226":330,"_27":331},{"_44":316,"_32":317,"_30":318,"_137":274,"_42":43,"_41":319,"_139":25,"_39":320,"_13":161,"_34":35,"_36":321,"_24":25,"_142":-5,"_226":322,"_27":323},{"_44":307,"_32":308,"_30":309,"_137":274,"_42":43,"_41":310,"_139":25,"_39":311,"_13":312,"_34":35,"_36":313,"_24":25,"_142":-5,"_226":314,"_27":315},{"_44":299,"_32":300,"_30":301,"_137":274,"_42":43,"_41":302,"_139":25,"_39":303,"_13":161,"_34":35,"_36":304,"_24":25,"_142":-5,"_226":305,"_27":306},{"_44":290,"_32":291,"_30":292,"_137":274,"_42":43,"_41":293,"_139":25,"_39":294,"_13":295,"_34":35,"_36":296,"_24":25,"_142":-5,"_226":297,"_27":298},{"_44":282,"_32":283,"_30":284,"_137":274,"_42":43,"_41":285,"_139":25,"_39":286,"_13":277,"_34":35,"_36":287,"_24":25,"_142":-5,"_226":288,"_27":289},{"_44":271,"_32":272,"_30":273,"_137":274,"_42":43,"_41":275,"_139":25,"_39":276,"_13":277,"_34":35,"_36":278,"_24":25,"_142":-5,"_226":279,"_27":280},{"_44":263,"_32":264,"_30":265,"_137":167,"_42":43,"_41":266,"_139":60,"_39":267,"_13":161,"_34":20,"_36":268,"_24":25,"_142":-5,"_226":269,"_27":270},{"_44":255,"_32":256,"_30":257,"_137":167,"_42":43,"_41":258,"_139":25,"_39":259,"_13":161,"_34":20,"_36":260,"_24":25,"_142":-5,"_226":261,"_27":262},{"_44":247,"_32":248,"_30":249,"_137":167,"_42":43,"_41":250,"_139":60,"_39":251,"_13":161,"_34":35,"_36":252,"_24":25,"_142":-5,"_226":253,"_27":254},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":60,"_39":244,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_226":245,"_27":246},{"_44":235,"_32":236,"_30":237,"_137":160,"_42":43,"_41":238,"_139":25,"_39":239,"_13":240,"_34":35,"_36":241,"_24":25,"_142":-5,"_226":242,"_27":243},{"_44":151,"_32":152,"_30":153,"_137":-5,"_42":43,"_41":154,"_139":25,"_39":232,"_13":64,"_34":20,"_36":156,"_24":25,"_142":-5,"_226":233,"_27":234},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":60,"_39":229,"_13":64,"_34":20,"_36":149,"_24":25,"_142":-5,"_226":230,"_27":231},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":225,"_13":64,"_34":20,"_36":141,"_24":25,"_142":-5,"_226":227,"_27":228},["D",1765138635487],"children",[],[135],["D",1765138635892],[],[145],["D",1765138635895],[],[152],"8261b324-dbcb-11f0-8572-42dde27851f2","types.ts","b9331f48-d3a9-11f0-a755-42dde27851f2",145,["D",1766032755893],7,"// Shared types for Carmy - Recipe and Meal Planning App\n// NOTE: This file runs in both frontend and backend - do not use Deno APIs here\n\nexport interface User {\n id: string;\n email: string;\n name: string | null;\n picture: string | null;\n}\n\nexport interface Recipe {\n id: string;\n userId: string;\n title: string;\n url: string | null;\n instructions: string | null;\n servingSize: number;\n createdAt: string;\n updatedAt: string;\n ingredients: RecipeIngredient[];\n nutrition: RecipeNutrition | null;\n}\n\nexport interface RecipeIngredient {\n id: string;\n recipeId: string;\n name: string;\n amount: number | null;\n unit: string | null;\n amountGrams: number | null; // Converted amount in grams for nutrition calculation\n notes: string | null;\n orderIndex: number;\n // FDC linking fields\n fdcId: number | null;\n fdcDescription: string | null;\n fdcDataType: FDCDataType | null;\n}\n\nexport type FDCDataType = 'Branded' | 'Foundation' | 'SR Legacy' | 'Survey (FNDDS)';\n\n// Cached FDC food data\nexport interface FDCFood {\n fdcId: number;\n description: string;\n dataType: FDCDataType;\n brandOwner: string | null;\n brandName: string | null;\n servingSize: number | null;\n servingSizeUnit: string | null;\n householdServingText: string | null;\n nutrition: FDCNutrition;\n cachedAt: string;\n}\n\n// Nutrition data from FDC (per 100g)\nexport interface FDCNutrition {\n calories: number | null;\n protein: number | null;\n fat: number | null;\n carbs: number | null;\n fiber: number | null;\n // Minerals\n sodium: number | null;\n potassium: number | null;\n calcium: number | null;\n iron: number | null;\n magnesium: number | null;\n zinc: number | null;\n // Vitamins\n vitaminA: number | null;\n vitaminC: number | null;\n vitaminD: number | null;\n vitaminE: number | null;\n vitaminK: number | null;\n vitaminB6: number | null;\n vitaminB12: number | null;\n thiamin: number | null;\n riboflavin: number | null;\n niacin: number | null;\n folate: number | null;\n}\n\nexport interface RecipeNutrition {\n id: string;\n recipeId: string;\n // Macros\n calories: number | null;\n protein: number | null;\n fat: number | null;\n carbs: number | null;\n fiber: number | null;\n // Minerals\n sodium: number | null;\n potassium: number | null;\n calcium: number | null;\n iron: number | null;\n magnesium: number | null;\n zinc: number | null;\n // Vitamins\n vitaminA: number | null;\n vitaminC: number | null;\n vitaminD: number | null;\n vitaminE: number | null;\n vitaminK: number | null;\n vitaminB6: number | null;\n vitaminB12: number | null;\n thiamin: number | null;\n riboflavin: number | null;\n niacin: number | null;\n folate: number | null;\n // Whether all ingredients have FDC links\n isComplete: boolean;\n}\n\nexport interface GroceryList {\n id: string;\n userId: string;\n name: string;\n createdAt: string;\n updatedAt: string;\n items: GroceryListItem[];\n}\n\nexport interface GroceryListItem {\n id: string;\n listId: string;\n name: string;\n quantity: number | null;\n unit: string | null;\n recipeId: string | null;\n recipeName: string | null;\n checked: boolean;\n createdAt: string;\n}\n\nexport interface NutritionGoals {\n id: string;\n userId: string;\n primaryGoalType: NutritionGoalType;\n primaryGoalValue: number;\n subGoal1Type: NutritionGoalType | null;\n subGoal1Value: number | null;\n subGoal2Type: NutritionGoalType | null;\n subGoal2Value: number | null;\n updatedAt: string;\n}\n\nexport type NutritionGoalType = 'calories' | 'protein' | 'fiber' | 'fat' | 'carbs';\n\nexport const NUTRITION_GOAL_UNITS: Record = {\n calories: 'kcal',\n protein: 'g',\n fiber: 'g',\n fat: 'g',\n carbs: 'g',\n};\n\nexport const NUTRITION_GOAL_LABELS: Record = {\n calories: 'Calories',\n protein: 'Protein',\n fiber: 'Fiber',\n fat: 'Fat',\n carbs: 'Carbohydrates',\n};\n\n// All nutrition keys (macros + micronutrients)\nexport type NutrientKey =\n | 'calories' | 'protein' | 'fat' | 'carbs' | 'fiber'\n | 'sodium' | 'potassium' | 'calcium' | 'iron' | 'magnesium' | 'zinc'\n | 'vitaminA' | 'vitaminC' | 'vitaminD' | 'vitaminE' | 'vitaminK'\n | 'vitaminB6' | 'vitaminB12' | 'thiamin' | 'riboflavin' | 'niacin' | 'folate';\n\nexport const NUTRIENT_INFO: Record = {\n calories: { label: 'Calories', unit: 'kcal', category: 'macro' },\n protein: { label: 'Protein', unit: 'g', category: 'macro' },\n fat: { label: 'Fat', unit: 'g', category: 'macro' },\n carbs: { label: 'Carbohydrates', unit: 'g', category: 'macro' },\n fiber: { label: 'Fiber', unit: 'g', category: 'macro' },\n sodium: { label: 'Sodium', unit: 'mg', category: 'mineral' },\n potassium: { label: 'Potassium', unit: 'mg', category: 'mineral' },\n calcium: { label: 'Calcium', unit: 'mg', category: 'mineral' },\n iron: { label: 'Iron', unit: 'mg', category: 'mineral' },\n magnesium: { label: 'Magnesium', unit: 'mg', category: 'mineral' },\n zinc: { label: 'Zinc', unit: 'mg', category: 'mineral' },\n vitaminA: { label: 'Vitamin A', unit: 'mcg', category: 'vitamin' },\n vitaminC: { label: 'Vitamin C', unit: 'mg', category: 'vitamin' },\n vitaminD: { label: 'Vitamin D', unit: 'mcg', category: 'vitamin' },\n vitaminE: { label: 'Vitamin E', unit: 'mg', category: 'vitamin' },\n vitaminK: { label: 'Vitamin K', unit: 'mcg', category: 'vitamin' },\n vitaminB6: { label: 'Vitamin B6', unit: 'mg', category: 'vitamin' },\n vitaminB12: { label: 'Vitamin B12', unit: 'mcg', category: 'vitamin' },\n thiamin: { label: 'Thiamin (B1)', unit: 'mg', category: 'vitamin' },\n riboflavin: { label: 'Riboflavin (B2)', unit: 'mg', category: 'vitamin' },\n niacin: { label: 'Niacin (B3)', unit: 'mg', category: 'vitamin' },\n folate: { label: 'Folate', unit: 'mcg', category: 'vitamin' },\n};\n\n// Common ingredient units with gram conversions (approximate, for common ingredients)\nexport const COMMON_UNITS = ['g', 'oz', 'lb', 'cup', 'tbsp', 'tsp', 'ml', 'piece', 'whole'] as const;\nexport type IngredientUnit = typeof COMMON_UNITS[number];\n\n// FDC search result (summary)\nexport interface FDCSearchResult {\n fdcId: number;\n description: string;\n dataType: FDCDataType;\n brandOwner: string | null;\n brandName: string | null;\n score: number;\n micronutrientCount: number | null; // How many micronutrients have data (out of 16)\n}\n\nexport interface MealPlan {\n id: string;\n userId: string;\n weekStartDate: string; // ISO date string (Sunday)\n createdAt: string;\n updatedAt: string;\n entries: MealPlanEntry[];\n}\n\nexport type DayOfWeek = 0 | 1 | 2 | 3 | 4 | 5 | 6; // Sunday = 0\nexport type MealType = 'breakfast' | 'lunch' | 'dinner' | 'snacks';\n\nexport const DAY_NAMES: string[] = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];\nexport const MEAL_TYPES: MealType[] = ['breakfast', 'lunch', 'dinner', 'snacks'];\nexport const MEAL_TYPE_LABELS: Record = {\n breakfast: 'Breakfast',\n lunch: 'Lunch',\n dinner: 'Dinner',\n snacks: 'Snacks',\n};\n\n// Custom food with user-defined nutrition (per serving)\nexport interface CustomFood {\n id: string;\n userId: string;\n name: string;\n servingSizeGrams: number; // default 100g\n // Macros\n calories: number | null;\n protein: number | null;\n fat: number | null;\n carbs: number | null;\n fiber: number | null;\n // Minerals\n sodium: number | null;\n potassium: number | null;\n calcium: number | null;\n iron: number | null;\n magnesium: number | null;\n zinc: number | null;\n // Vitamins\n vitaminA: number | null;\n vitaminC: number | null;\n vitaminD: number | null;\n vitaminE: number | null;\n vitaminK: number | null;\n vitaminB6: number | null;\n vitaminB12: number | null;\n thiamin: number | null;\n riboflavin: number | null;\n niacin: number | null;\n folate: number | null;\n createdAt: string;\n updatedAt: string;\n}\n\n// Meal plan entry - supports recipes, custom foods, or individual FDC ingredients\n// Exactly one of recipeId, customFoodId, or fdcId should be set\nexport interface MealPlanEntry {\n id: string;\n mealPlanId: string;\n dayOfWeek: DayOfWeek;\n mealType: MealType;\n // One of these three will be set\n recipeId: string | null;\n customFoodId: string | null;\n fdcId: number | null;\n // Associated data (populated when fetched)\n recipe?: Recipe;\n customFood?: CustomFood;\n fdcFood?: FDCFood;\n // Servings for recipes, amount for custom foods/ingredients\n servings: number;\n amountGrams: number | null; // Used for custom foods and FDC ingredients\n}\n\nexport interface DailyNutrition {\n // Macros\n calories: number;\n protein: number;\n fat: number;\n carbs: number;\n fiber: number;\n // Minerals\n sodium: number;\n potassium: number;\n calcium: number;\n iron: number;\n magnesium: number;\n zinc: number;\n // Vitamins\n vitaminA: number;\n vitaminC: number;\n vitaminD: number;\n vitaminE: number;\n vitaminK: number;\n vitaminB6: number;\n vitaminB12: number;\n thiamin: number;\n riboflavin: number;\n niacin: number;\n folate: number;\n}\n\n// Helper to create empty daily nutrition\nexport function createEmptyDailyNutrition(): DailyNutrition {\n return {\n calories: 0, protein: 0, fat: 0, carbs: 0, fiber: 0,\n sodium: 0, potassium: 0, calcium: 0, iron: 0, magnesium: 0, zinc: 0,\n vitaminA: 0, vitaminC: 0, vitaminD: 0, vitaminE: 0, vitaminK: 0,\n vitaminB6: 0, vitaminB12: 0, thiamin: 0, riboflavin: 0, niacin: 0, folate: 0,\n };\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\n// Request types\nexport interface CreateRecipeIngredient {\n name: string;\n amount?: number | null;\n unit?: string | null;\n notes?: string | null;\n fdcId?: number | null;\n fdcDescription?: string | null;\n fdcDataType?: FDCDataType | null;\n}\n\nexport interface CreateRecipeRequest {\n title: string;\n url?: string | null;\n instructions?: string | null;\n servingSize: number;\n ingredients: CreateRecipeIngredient[];\n // Note: nutrition is now calculated from ingredients, not manually provided\n}\n\n// Response type for parsing a recipe from URL\nexport interface ParsedRecipeFromUrl {\n title: string;\n url: string;\n instructions: string | null;\n servingSize: number;\n ingredients: {\n name: string;\n amount: number | null;\n unit: string | null;\n notes: string | null;\n originalText: string;\n }[];\n nutrition: {\n calories: number | null;\n protein: number | null;\n fiber: number | null;\n fat: number | null;\n carbs: number | null;\n } | null;\n}\n\nexport interface UpdateRecipeRequest extends Partial {\n id: string;\n}\n\nexport interface CreateGroceryListRequest {\n name: string;\n}\n\nexport interface AddGroceryItemRequest {\n name: string;\n quantity?: number | null;\n unit?: string | null;\n}\n\nexport interface AddRecipeIngredientsRequest {\n recipeId: string;\n}\n\nexport interface UpdateNutritionGoalsRequest {\n primaryGoalType: NutritionGoalType;\n primaryGoalValue: number;\n subGoal1Type?: NutritionGoalType | null;\n subGoal1Value?: number | null;\n subGoal2Type?: NutritionGoalType | null;\n subGoal2Value?: number | null;\n}\n\n// Supports adding recipes, custom foods, or FDC ingredients to meal plan\nexport interface AddMealPlanEntryRequest {\n weekStartDate: string;\n dayOfWeek: DayOfWeek;\n mealType: MealType;\n // One of these three should be provided\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number; // For custom foods and FDC ingredients\n}\n\n// Starred ingredient for quick access when linking\nexport interface StarredIngredient {\n id: string;\n userId: string;\n fdcId: number;\n fdcDescription: string;\n fdcDataType: FDCDataType;\n brandOwner: string | null;\n createdAt: string;\n}\n\nexport interface ScheduleMealRequest {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n amountGrams?: number;\n mealType: MealType;\n weekStartDate: string;\n days: DayOfWeek[]; // which days to add to\n servings?: number;\n}\n\n// Custom food request types\nexport interface CreateCustomFoodRequest {\n name: string;\n servingSizeGrams?: number; // defaults to 100\n // Macros\n calories?: number | null;\n protein?: number | null;\n fat?: number | null;\n carbs?: number | null;\n fiber?: number | null;\n // Minerals\n sodium?: number | null;\n potassium?: number | null;\n calcium?: number | null;\n iron?: number | null;\n magnesium?: number | null;\n zinc?: number | null;\n // Vitamins\n vitaminA?: number | null;\n vitaminC?: number | null;\n vitaminD?: number | null;\n vitaminE?: number | null;\n vitaminK?: number | null;\n vitaminB6?: number | null;\n vitaminB12?: number | null;\n thiamin?: number | null;\n riboflavin?: number | null;\n niacin?: number | null;\n folate?: number | null;\n}\n\nexport interface UpdateCustomFoodRequest extends Partial {\n id: string;\n}\n\n\n\n",[],[159,236],["D",1765138634405],[221],[159],"82072d06-e13d-11f0-9cc2-42dde27851f2","index.tsx","b8cb9256-d3a9-11f0-ba80-42dde27851f2",148,["D",1766631473917],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();\n\n\n\n\n",[],[166,248],"82109896-e13d-11f0-99a8-42dde27851f2","index.html","b8d03d1a-d3a9-11f0-8004-42dde27851f2",149,["D",1766631473955],"\n\n\n \n \n Carmy - Recipe & Meal Planning\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n\n\n\n\n\n\n",[],[166,256],"8307e934-e13d-11f0-b455-42dde27851f2","favicon.svg","b8f8fbb0-d3a9-11f0-897f-42dde27851f2",155,["D",1766631475442],"\n\n\n\n\n",[],[166,264],"440620a4-d92a-11f0-a349-42dde27851f2","ScraperEvalView.tsx","0850829e-d91f-11f0-bf8f-42dde27851f2","b86d06aa-d3a9-11f0-b1e3-42dde27851f2",67,["D",1765743600152],5,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useCallback, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface ScraperResult {\n scraper: string;\n success: boolean;\n data?: any;\n error?: string;\n durationMs: number;\n}\n\ninterface UrlResult {\n url: string;\n results: ScraperResult[];\n}\n\ninterface SavedUrl {\n id: string;\n url: string;\n createdAt: string;\n}\n\ntype ViewMode = \"key-fields\" | \"full-json\";\n\ninterface ExpandedCell {\n viewMode: ViewMode;\n}\n\ninterface ScraperEvalState {\n savedUrls: SavedUrl[];\n results: UrlResult[];\n loading: boolean;\n loadingUrls: boolean;\n // Map key is \"urlIndex-scraperIndex\", value is the expanded state\n expandedCells: Map;\n selectedUrlIds: Set;\n}\n\nconst SCRAPER_NAMES = [\n \"json-ld-native\",\n \"microdata-native\",\n \"html-recipe-parser\",\n \"schema-org-extractor\",\n];\n\nfunction getCellKey(urlIndex: number, scraperIndex: number): string {\n return `${urlIndex}-${scraperIndex}`;\n}\n\nexport function ScraperEvalView() {\n const [state, setState] = useState({\n savedUrls: [],\n results: [],\n loading: false,\n loadingUrls: true,\n expandedCells: new Map(),\n selectedUrlIds: new Set(),\n });\n const [urlInput, setUrlInput] = useState(\"\");\n const [bulkInput, setBulkInput] = useState(\"\");\n const [showBulkInput, setShowBulkInput] = useState(false);\n\n // Load saved URLs on mount\n useEffect(() => {\n const loadUrls = async () => {\n try {\n const response = await fetch(\"/api/scraper-eval/urls\");\n const data = await response.json();\n if (data.success) {\n setState((prev) => ({\n ...prev,\n savedUrls: data.data,\n loadingUrls: false,\n }));\n }\n } catch (err) {\n console.error(\"Failed to load saved URLs:\", err);\n setState((prev) => ({ ...prev, loadingUrls: false }));\n }\n };\n loadUrls();\n }, []);\n\n const addUrl = useCallback(async () => {\n const trimmedUrl = urlInput.trim();\n if (!trimmedUrl) return;\n \n // Check if URL already exists\n if (state.savedUrls.some((u) => u.url === trimmedUrl)) {\n setUrlInput(\"\");\n return;\n }\n \n try {\n new URL(trimmedUrl);\n } catch {\n return; // Invalid URL\n }\n \n try {\n const response = await fetch(\"/api/scraper-eval/urls\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ url: trimmedUrl }),\n });\n const data = await response.json();\n \n if (data.success && data.data.length > 0) {\n setState((prev) => ({\n ...prev,\n savedUrls: [...data.data, ...prev.savedUrls],\n }));\n }\n setUrlInput(\"\");\n } catch (err) {\n console.error(\"Failed to save URL:\", err);\n }\n }, [urlInput, state.savedUrls]);\n\n const addBulkUrls = useCallback(async () => {\n const newUrls = bulkInput\n .split(\"\\n\")\n .map((u) => u.trim())\n .filter((u) => {\n if (!u || state.savedUrls.some((saved) => saved.url === u)) return false;\n try {\n new URL(u);\n return true;\n } catch {\n return false;\n }\n });\n\n if (newUrls.length === 0) {\n setBulkInput(\"\");\n setShowBulkInput(false);\n return;\n }\n \n try {\n const response = await fetch(\"/api/scraper-eval/urls\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ urls: newUrls }),\n });\n const data = await response.json();\n \n if (data.success) {\n setState((prev) => ({\n ...prev,\n savedUrls: [...data.data, ...prev.savedUrls],\n }));\n }\n setBulkInput(\"\");\n setShowBulkInput(false);\n } catch (err) {\n console.error(\"Failed to save URLs:\", err);\n }\n }, [bulkInput, state.savedUrls]);\n\n const removeUrl = useCallback(async (savedUrl: SavedUrl) => {\n try {\n const response = await fetch(`/api/scraper-eval/urls/${savedUrl.id}`, {\n method: \"DELETE\",\n });\n const data = await response.json();\n \n if (data.success) {\n setState((prev) => {\n const newSelectedIds = new Set(prev.selectedUrlIds);\n newSelectedIds.delete(savedUrl.id);\n return {\n ...prev,\n savedUrls: prev.savedUrls.filter((u) => u.id !== savedUrl.id),\n results: prev.results.filter((r) => r.url !== savedUrl.url),\n selectedUrlIds: newSelectedIds,\n };\n });\n }\n } catch (err) {\n console.error(\"Failed to delete URL:\", err);\n }\n }, []);\n\n const clearAll = useCallback(async () => {\n try {\n const response = await fetch(\"/api/scraper-eval/urls\", {\n method: \"DELETE\",\n });\n const data = await response.json();\n \n if (data.success) {\n setState((prev) => ({\n ...prev,\n savedUrls: [],\n results: [],\n expandedCells: new Map(),\n selectedUrlIds: new Set(),\n }));\n }\n } catch (err) {\n console.error(\"Failed to clear URLs:\", err);\n }\n }, []);\n\n const toggleUrlSelection = useCallback((urlId: string) => {\n setState((prev) => {\n const newSelectedIds = new Set(prev.selectedUrlIds);\n if (newSelectedIds.has(urlId)) {\n newSelectedIds.delete(urlId);\n } else {\n newSelectedIds.add(urlId);\n }\n return { ...prev, selectedUrlIds: newSelectedIds };\n });\n }, []);\n\n const selectAllUrls = useCallback(() => {\n setState((prev) => ({\n ...prev,\n selectedUrlIds: new Set(prev.savedUrls.map((u) => u.id)),\n }));\n }, []);\n\n const deselectAllUrls = useCallback(() => {\n setState((prev) => ({\n ...prev,\n selectedUrlIds: new Set(),\n }));\n }, []);\n\n const runScrapers = useCallback(async (urlsToScrape: string[]) => {\n if (urlsToScrape.length === 0) return;\n\n setState((prev) => ({ ...prev, loading: true }));\n\n try {\n const response = await fetch(\"/api/scraper-eval\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ urls: urlsToScrape }),\n });\n const data = await response.json();\n\n if (data.success) {\n setState((prev) => {\n // Merge new results with existing results\n const existingResults = prev.results.filter(\n (r) => !urlsToScrape.includes(r.url)\n );\n return {\n ...prev,\n results: [...existingResults, ...data.data],\n loading: false,\n };\n });\n } else {\n console.error(\"Scraper eval failed:\", data.error);\n setState((prev) => ({ ...prev, loading: false }));\n }\n } catch (err) {\n console.error(\"Failed to run scrapers:\", err);\n setState((prev) => ({ ...prev, loading: false }));\n }\n }, []);\n\n const runAllScrapers = useCallback(() => {\n const urls = state.savedUrls.map((u) => u.url);\n runScrapers(urls);\n }, [state.savedUrls, runScrapers]);\n\n const runSelectedScrapers = useCallback(() => {\n const urls = state.savedUrls\n .filter((u) => state.selectedUrlIds.has(u.id))\n .map((u) => u.url);\n runScrapers(urls);\n }, [state.savedUrls, state.selectedUrlIds, runScrapers]);\n\n const toggleExpandCell = useCallback(\n (urlIndex: number, scraperIndex: number, viewMode: ViewMode = \"key-fields\") => {\n setState((prev) => {\n const key = getCellKey(urlIndex, scraperIndex);\n const newExpandedCells = new Map(prev.expandedCells);\n \n if (newExpandedCells.has(key)) {\n newExpandedCells.delete(key);\n } else {\n newExpandedCells.set(key, { viewMode });\n }\n \n return { ...prev, expandedCells: newExpandedCells };\n });\n },\n []\n );\n\n const setExpandedViewMode = useCallback((urlIndex: number, scraperIndex: number, viewMode: ViewMode) => {\n setState((prev) => {\n const key = getCellKey(urlIndex, scraperIndex);\n const newExpandedCells = new Map(prev.expandedCells);\n const existing = newExpandedCells.get(key);\n if (existing) {\n newExpandedCells.set(key, { ...existing, viewMode });\n }\n return { ...prev, expandedCells: newExpandedCells };\n });\n }, []);\n\n const isExpanded = useCallback((urlIndex: number, scraperIndex: number): boolean => {\n return state.expandedCells.has(getCellKey(urlIndex, scraperIndex));\n }, [state.expandedCells]);\n\n const getExpandedViewMode = useCallback((urlIndex: number, scraperIndex: number): ViewMode => {\n return state.expandedCells.get(getCellKey(urlIndex, scraperIndex))?.viewMode || \"key-fields\";\n }, [state.expandedCells]);\n\n // Extract key fields (name, ingredients, instructions) from scraper data\n const extractKeyFields = (data: any) => {\n if (!data) return null;\n \n const name = data.name || data.title || data.headline || null;\n \n // Get ingredients from various possible field names\n let ingredients = data.ingredients || data.recipeIngredient || [];\n if (!Array.isArray(ingredients)) {\n ingredients = ingredients ? [ingredients] : [];\n }\n ingredients = ingredients.map((i: any) => \n typeof i === \"string\" ? i : i.text || i.name || String(i)\n );\n \n // Get instructions from various possible field names\n let instructions = data.instructions || data.recipeInstructions || [];\n if (!Array.isArray(instructions)) {\n instructions = instructions ? [instructions] : [];\n }\n instructions = instructions.map((i: any) => {\n if (typeof i === \"string\") return i;\n if (i.text) return i.text;\n if (i.name) return i.name;\n if (i[\"@type\"] === \"HowToStep\") return i.text || i.name || \"\";\n return String(i);\n });\n \n return { name, ingredients, instructions };\n };\n\n const getResultForUrl = (url: string): UrlResult | undefined => {\n return state.results.find((r) => r.url === url);\n };\n\n const getScraperResultSummary = (result: ScraperResult | undefined) => {\n if (!result) return { status: \"pending\", text: \"—\" };\n if (!result.success) return { status: \"error\", text: result.error || \"Error\" };\n\n const data = result.data;\n const name = data?.name || data?.title || \"Untitled\";\n const ingredientCount =\n data?.ingredients?.length || data?.recipeIngredient?.length || 0;\n const instructionCount =\n data?.instructions?.length || data?.recipeInstructions?.length || 0;\n\n return {\n status: \"success\",\n text: name,\n ingredientCount,\n instructionCount,\n durationMs: result.durationMs,\n };\n };\n\n const allSelected = state.savedUrls.length > 0 && state.selectedUrlIds.size === state.savedUrls.length;\n const someSelected = state.selectedUrlIds.size > 0;\n\n // Show loading while fetching saved URLs\n if (state.loadingUrls) {\n return (\n

\n Loading saved URLs...\n

\n );\n }\n\n return (\n

\n {/* Header */}\n

\n Recipe Scraper Evaluation\n

\n\n {/* URL Input */}\n

\n setUrlInput(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && addUrl()}\n placeholder=\"Enter recipe URL...\"\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n />\n \n Add URL\n \n setShowBulkInput(!showBulkInput)}\n className=\"px-4 py-2 border border-gray-300 rounded-lg hover:bg-gray-50 transition-colors\"\n >\n Bulk Import\n \n

\n\n {/* Bulk Import */}\n {showBulkInput && (\n

\n setBulkInput(e.target.value)}\n placeholder=\"Paste multiple URLs (one per line)...\"\n rows={4}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent resize-none\"\n />\n

\n \n Add All URLs\n \n {\n setShowBulkInput(false);\n setBulkInput(\"\");\n }}\n className=\"px-4 py-2 border border-gray-300 rounded-lg hover:bg-gray-50 transition-colors\"\n >\n Cancel\n \n

\n )}\n\n {/* Actions */}\n {state.savedUrls.length > 0 && (\n

\n \n {state.loading && (\n

\n )}\n Run All\n \n {someSelected && (\n \n {state.loading && (\n

\n )}\n Run Selected ({state.selectedUrlIds.size})\n \n )}\n \n Clear All\n \n \n {state.savedUrls.length} URL{state.savedUrls.length !== 1 ? \"s\" : \"\"} saved\n {someSelected && ` · ${state.selectedUrlIds.size} selected`}\n \n

\n )}\n

\n\n {/* Results Table */}\n {state.savedUrls.length > 0 && (\n

\n \n \n \n \n {SCRAPER_NAMES.map((name) => (\n \n {name}\n {name.split(\"-\")[0]}\n \n ))}\n \n \n \n {state.savedUrls.map((savedUrl, urlIndex) => {\n const urlResult = getResultForUrl(savedUrl.url);\n const isSelected = state.selectedUrlIds.has(savedUrl.id);\n return (\n \n \n {SCRAPER_NAMES.map((scraperName, scraperIndex) => {\n const scraperResult = urlResult?.results.find(\n (r) => r.scraper === scraperName\n );\n const summary = getScraperResultSummary(scraperResult);\n const cellExpanded = isExpanded(urlIndex, scraperIndex);\n const cellViewMode = getExpandedViewMode(urlIndex, scraperIndex);\n\n return (\n \n {state.loading && !urlResult ? (\n

\n Loading...\n

\n ) : summary.status === \"pending\" ? (\n —\n ) : summary.status === \"error\" ? (\n

\n ❌\n Error\n

\n toggleExpandCell(urlIndex, scraperIndex)}\n className=\"text-xs text-red-500 hover:underline mt-1\"\n >\n {cellExpanded ? \"Hide details\" : \"Show details\"}\n \n {cellExpanded && (\n

\n                                  {summary.text}\n

\n )}\n

\n ) : (\n

\n ✅\n \n {summary.text}\n \n

\n {summary.ingredientCount} ingredients ·{\" \"}\n {summary.instructionCount} steps ·{\" \"}\n {summary.durationMs}ms\n

\n toggleExpandCell(urlIndex, scraperIndex, \"key-fields\")}\n className=\"text-xs text-blue-500 hover:underline\"\n >\n {cellExpanded ? \"Hide\" : \"View Details\"}\n \n

\n {cellExpanded && (\n

\n {/* View Mode Toggle */}\n

\n setExpandedViewMode(urlIndex, scraperIndex, \"key-fields\")}\n className={`px-2 py-1 text-xs rounded ${\n cellViewMode === \"key-fields\"\n ? \"bg-blue-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n Key Fields\n \n setExpandedViewMode(urlIndex, scraperIndex, \"full-json\")}\n className={`px-2 py-1 text-xs rounded ${\n cellViewMode === \"full-json\"\n ? \"bg-blue-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n Full JSON\n \n

\n \n {cellViewMode === \"key-fields\" ? (\n

\n {(() => {\n const keyFields = extractKeyFields(scraperResult?.data);\n if (!keyFields) return No data;\n return (\n <>\n

Name:

{keyFields.name || \"—\"}

\n Ingredients ({keyFields.ingredients.length}):\n

\n {keyFields.ingredients.length > 0 ? (\n

\n •{ing}\n

\n ) : (\n None found\n )}\n

\n Instructions ({keyFields.instructions.length}):\n

\n {keyFields.instructions.length > 0 ? (\n

\n {i + 1}.{inst}\n

\n ) : (\n None found\n )}\n

\n \n );\n })()}\n

\n ) : (\n

\n                                      {JSON.stringify(scraperResult?.data, null, 2)}\n

\n )}\n

\n )}\n \n );\n })}\n \n );\n })}\n \n

\n \n allSelected ? deselectAllUrls() : selectAllUrls()}\n className=\"w-4 h-4 rounded border-gray-300 text-blue-600 focus:ring-blue-500 cursor-pointer\"\n title={allSelected ? \"Deselect all\" : \"Select all\"}\n />\n Recipe URL\n \n
\n \n toggleUrlSelection(savedUrl.id)}\n className=\"w-4 h-4 mt-0.5 rounded border-gray-300 text-blue-600 focus:ring-blue-500 cursor-pointer flex-shrink-0\"\n />\n removeUrl(savedUrl)}\n className=\"text-red-500 hover:text-red-700 text-sm flex-shrink-0\"\n title=\"Remove URL\"\n >\n ✕\n \n \n {new URL(savedUrl.url).hostname}\n {new URL(savedUrl.url).pathname.slice(0, 20)}\n {new URL(savedUrl.url).pathname.length > 20 ? \"...\" : \"\"}\n \n \n

\n allSelected ? deselectAllUrls() : selectAllUrls()}\n className=\"w-4 h-4 rounded border-gray-300 text-blue-600 focus:ring-blue-500 cursor-pointer\"\n title={allSelected ? \"Deselect all\" : \"Select all\"}\n />\n Recipe URL\n

\n toggleUrlSelection(savedUrl.id)}\n className=\"w-4 h-4 mt-0.5 rounded border-gray-300 text-blue-600 focus:ring-blue-500 cursor-pointer flex-shrink-0\"\n />\n removeUrl(savedUrl)}\n className=\"text-red-500 hover:text-red-700 text-sm flex-shrink-0\"\n title=\"Remove URL\"\n >\n ✕\n \n \n {new URL(savedUrl.url).hostname}\n {new URL(savedUrl.url).pathname.slice(0, 20)}\n {new URL(savedUrl.url).pathname.length > 20 ? \"...\" : \"\"}\n \n

\n )}\n\n {/* Empty State */}\n {state.savedUrls.length === 0 && (\n

🔍

No recipe URLs saved yet

\n Add recipe URLs above to compare scraper performance\n

\n )}\n

\n );\n}\n",[],[166,281,272],"components","f9f3a880-e142-11f0-8955-42dde27851f2","RecipesView.tsx","b8e58968-d3a9-11f0-a23f-42dde27851f2",161,["D",1766633822595],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest, ParsedRecipeFromUrl, RecipeNutrition, CustomFood, CreateCustomFoodRequest } from \"../../shared/types.ts\";\nimport { NUTRIENT_INFO } from \"../../shared/types.ts\";\nimport { RecipeForm } from \"./RecipeForm.tsx\";\nimport { CustomFoodForm } from \"./CustomFoodForm.tsx\";\n\ntype ViewTab = 'recipes' | 'custom-foods';\n\ninterface RecipesViewProps {\n recipes: Recipe[];\n customFoods: CustomFood[];\n onRecipesChange: () => Promise;\n onCustomFoodsChange: () => Promise;\n}\n\n// Helper to get linked/total ingredients count\nfunction getIngredientLinkStatus(recipe: Recipe): { linked: number; total: number } {\n const total = recipe.ingredients.length;\n const linked = recipe.ingredients.filter(i => i.fdcId !== null).length;\n return { linked, total };\n}\n\n// Format nutrient value with appropriate precision\nfunction formatNutrient(value: number | null, unit: string): string {\n if (value === null) return '-';\n if (unit === 'mcg') return value.toFixed(1);\n if (unit === 'mg' && value < 1) return value.toFixed(2);\n return Math.round(value).toString();\n}\n\nexport function RecipesView({ recipes, customFoods, onRecipesChange, onCustomFoodsChange }: RecipesViewProps) {\n const [activeTab, setActiveTab] = useState('recipes');\n const [showForm, setShowForm] = useState(false);\n const [editingRecipe, setEditingRecipe] = useState(null);\n const [searchQuery, setSearchQuery] = useState('');\n const [expandedRecipe, setExpandedRecipe] = useState(null);\n const [showImportModal, setShowImportModal] = useState(false);\n const [importUrl, setImportUrl] = useState('');\n const [importLoading, setImportLoading] = useState(false);\n const [importError, setImportError] = useState(null);\n const [importedRecipe, setImportedRecipe] = useState(null);\n const [showMicronutrients, setShowMicronutrients] = useState(false);\n \n // Custom food state\n const [showCustomFoodForm, setShowCustomFoodForm] = useState(false);\n const [editingCustomFood, setEditingCustomFood] = useState(null);\n\n const filteredRecipes = recipes.filter(recipe =>\n recipe.title.toLowerCase().includes(searchQuery.toLowerCase()) ||\n recipe.ingredients.some(i => i.name.toLowerCase().includes(searchQuery.toLowerCase()))\n );\n\n const filteredCustomFoods = customFoods.filter(food =>\n food.name.toLowerCase().includes(searchQuery.toLowerCase())\n );\n\n const handleCreateRecipe = async (data: CreateRecipeRequest) => {\n const response = await fetch('/api/recipes', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(data),\n });\n \n if (response.ok) {\n await onRecipesChange();\n setShowForm(false);\n }\n };\n\n const handleUpdateRecipe = async (data: CreateRecipeRequest) => {\n if (!editingRecipe) return;\n \n const response = await fetch(`/api/recipes/${editingRecipe.id}`, {\n method: 'PATCH',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(data),\n });\n \n if (response.ok) {\n await onRecipesChange();\n setEditingRecipe(null);\n }\n };\n\n const handleDuplicate = async (recipeId: string) => {\n const response = await fetch(`/api/recipes/${recipeId}/duplicate`, {\n method: 'POST',\n });\n \n if (response.ok) {\n await onRecipesChange();\n }\n };\n\n const handleDelete = async (recipeId: string) => {\n const response = await fetch(`/api/recipes/${recipeId}`, {\n method: 'DELETE',\n });\n \n if (response.ok) {\n await onRecipesChange();\n if (expandedRecipe === recipeId) {\n setExpandedRecipe(null);\n }\n }\n };\n\n const handleImportFromUrl = async () => {\n if (!importUrl.trim()) return;\n \n setImportLoading(true);\n setImportError(null);\n \n try {\n const response = await fetch('/api/recipes/parse-url', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ url: importUrl.trim() }),\n });\n \n const result = await response.json();\n \n if (!result.success) {\n setImportError(result.error || 'Failed to import recipe');\n return;\n }\n \n // Close import modal and open recipe form with imported data\n setImportedRecipe(result.data);\n setShowImportModal(false);\n setImportUrl('');\n setShowForm(true);\n } catch (error) {\n setImportError('Failed to import recipe. Please check the URL and try again.');\n } finally {\n setImportLoading(false);\n }\n };\n\n const handleCloseForm = () => {\n setShowForm(false);\n setImportedRecipe(null);\n };\n\n // Custom food handlers\n const handleCreateCustomFood = async (data: CreateCustomFoodRequest) => {\n const response = await fetch('/api/custom-foods', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(data),\n });\n \n if (response.ok) {\n await onCustomFoodsChange();\n setShowCustomFoodForm(false);\n }\n };\n\n const handleUpdateCustomFood = async (data: CreateCustomFoodRequest) => {\n if (!editingCustomFood) return;\n \n const response = await fetch(`/api/custom-foods/${editingCustomFood.id}`, {\n method: 'PATCH',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(data),\n });\n \n if (response.ok) {\n await onCustomFoodsChange();\n setEditingCustomFood(null);\n }\n };\n\n const handleDeleteCustomFood = async (customFoodId: string) => {\n const response = await fetch(`/api/custom-foods/${customFoodId}`, {\n method: 'DELETE',\n });\n \n if (response.ok) {\n await onCustomFoodsChange();\n }\n };\n\n return (\n

\n {/* Header */}\n

Recipes & Foods

\n {recipes.length} recipes · {customFoods.length} custom foods\n

\n {activeTab === 'recipes' ? (\n <>\n setShowImportModal(true)}\n className=\"btn-secondary flex items-center gap-2\"\n >\n \n Import from URL\n \n setShowForm(true)}\n className=\"btn-primary flex items-center gap-2\"\n >\n \n Add Recipe\n \n \n ) : (\n setShowCustomFoodForm(true)}\n className=\"btn-primary flex items-center gap-2\"\n >\n \n Add Custom Food\n \n )}\n

\n \n {/* Tabs */}\n

\n setActiveTab('recipes')}\n className={`pb-3 px-1 text-sm font-medium border-b-2 transition-colors ${\n activeTab === 'recipes'\n ? 'border-current text-gray-900'\n : 'border-transparent text-gray-500 hover:text-gray-700'\n }`}\n style={activeTab === 'recipes' ? { borderColor: '#0f2763', color: '#0f2763' } : {}}\n >\n Recipes ({recipes.length})\n \n setActiveTab('custom-foods')}\n className={`pb-3 px-1 text-sm font-medium border-b-2 transition-colors ${\n activeTab === 'custom-foods'\n ? 'border-current text-gray-900'\n : 'border-transparent text-gray-500 hover:text-gray-700'\n }`}\n style={activeTab === 'custom-foods' ? { borderColor: '#0f2763', color: '#0f2763' } : {}}\n >\n Custom Foods ({customFoods.length})\n \n

\n \n {/* Search */}\n

\n setSearchQuery(e.target.value)}\n className=\"input max-w-md\"\n />\n

\n \n {/* Content */}\n

\n {/* Recipes Tab */}\n {activeTab === 'recipes' && (\n <>\n {filteredRecipes.length === 0 ? (\n

\n 📖\n

\n {searchQuery ? 'No recipes found' : 'No recipes yet'}\n

\n {searchQuery ? 'Try a different search term' : 'Add your first recipe to get started'}\n

\n ) : (\n

\n {filteredRecipes.map((recipe) => {\n const linkStatus = getIngredientLinkStatus(recipe);\n const hasNutrition = recipe.nutrition && recipe.nutrition.calories !== null;\n const isComplete = recipe.nutrition?.isComplete ?? false;\n \n return (\n \n {/* Recipe header */}\n setExpandedRecipe(expandedRecipe === recipe.id ? null : recipe.id)}\n >\n

{recipe.title}

\n {recipe.ingredients.length} ingredients · {recipe.servingSize} serving{recipe.servingSize !== 1 ? 's' : ''}\n

\n \n \n \n

\n \n {/* Nutrition preview */}\n {hasNutrition ? (\n

\n {recipe.nutrition!.calories && (\n \n {Math.round(recipe.nutrition!.calories)} kcal\n \n )}\n {recipe.nutrition!.protein && (\n \n {Math.round(recipe.nutrition!.protein)}g protein\n \n )}\n {!isComplete && (\n \n \n Partial\n \n )}\n

\n ) : (\n

\n \n No nutrition data - link ingredients\n \n

\n )}\n

\n \n {/* Expanded content */}\n {expandedRecipe === recipe.id && (\n

\n {/* URL */}\n {recipe.url && (\n

\n \n \n View original recipe\n \n

\n )}\n \n {/* Ingredient link status */}\n

\n \n Ingredients linked to USDA\n \n \n {linkStatus.linked}/{linkStatus.total}\n \n

0 ? (linkStatus.linked / linkStatus.total) * 100 : 0}%` }}\n />\n

\n \n {/* Ingredients */}\n

Ingredients

\n \n
\n \n {ing.amount && {ing.amount} }\n {ing.unit && {ing.unit} }\n {ing.name}\n \n {ing.notes && (\n ({ing.notes})\n )}\n {ing.fdcId && (\n \n [{ing.fdcDataType === 'Branded' ? 'B' : 'USDA'}]\n \n )}\n
\n

\n \n {/* Instructions */}\n {recipe.instructions && (\n

Instructions

{recipe.instructions}

\n )}\n \n {/* Nutrition details */}\n {recipe.nutrition && (\n

Nutrition (per serving)

\n setShowMicronutrients(!showMicronutrients)}\n className=\"text-xs text-blue-600 hover:text-blue-800\"\n >\n {showMicronutrients ? 'Hide details' : 'Show vitamins & minerals'}\n \n

\n \n {/* Macros */}\n

\n {formatNutrient(recipe.nutrition.calories, 'kcal')}\n

kcal

\n {formatNutrient(recipe.nutrition.protein, 'g')}g\n

protein

\n {formatNutrient(recipe.nutrition.carbs, 'g')}g\n

carbs

\n {formatNutrient(recipe.nutrition.fat, 'g')}g\n

fat

\n {formatNutrient(recipe.nutrition.fiber, 'g')}g\n

fiber

\n \n {/* Micronutrients */}\n {showMicronutrients && (\n

\n {/* Fats Breakdown */}\n {(['saturatedFat', 'transFat', 'monounsaturatedFat', 'polyunsaturatedFat', 'cholesterol'] as const).some(key => recipe.nutrition![key] !== null) && (\n

\n Fats Breakdown\n

\n {(['saturatedFat', 'transFat', 'monounsaturatedFat', 'polyunsaturatedFat', 'cholesterol'] as const).map(key => {\n const info = NUTRIENT_INFO[key];\n const value = recipe.nutrition![key];\n if (value === null) return null;\n return (\n

Diff · v163