[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_424":425,"_426":427},"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",44,"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 GROCERY_LISTS_TABLE,\n GROCERY_LIST_ITEMS_TABLE,\n NUTRITION_GOALS_TABLE,\n MEAL_PLANS_TABLE,\n MEAL_PLAN_ENTRIES_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} from \"../../shared/types.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\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, order_index\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 orderIndex: i.order_index as number,\n }));\n \n // Get nutrition\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fiber, fat, carbs\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 = {\n id: n.id as string,\n recipeId: n.recipe_id as string,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fiber: n.fiber as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n };\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\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, order_index\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 orderIndex: i.order_index as number,\n }));\n \n // Get nutrition\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fiber, fat, carbs\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 = {\n id: n.id as string,\n recipeId: n.recipe_id as string,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fiber: n.fiber as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n };\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: { name: string; amount?: number | null; unit?: string | null }[],\n nutrition?: { calories?: number | null; protein?: number | null; fiber?: number | null; fat?: number | null; carbs?: number | null } | null\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\n const recipeIngredients: RecipeIngredient[] = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ing = ingredients[i];\n const ingId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} (id, recipe_id, name, amount, unit, order_index)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, i]\n );\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n orderIndex: i,\n });\n }\n \n // Insert nutrition if provided\n let recipeNutrition: RecipeNutrition | null = null;\n if (nutrition) {\n const nutId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} (id, recipe_id, calories, protein, fiber, fat, carbs)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [nutId, recipeId, nutrition.calories ?? null, nutrition.protein ?? null, nutrition.fiber ?? null, nutrition.fat ?? null, nutrition.carbs ?? null]\n );\n recipeNutrition = {\n id: nutId,\n recipeId,\n calories: nutrition.calories ?? null,\n protein: nutrition.protein ?? null,\n fiber: nutrition.fiber ?? null,\n fat: nutrition.fat ?? null,\n carbs: nutrition.carbs ?? null,\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?: { name: string; amount?: number | null; unit?: string | null }[];\n nutrition?: { calories?: number | null; protein?: number | null; fiber?: number | null; fat?: number | null; carbs?: number | null } | null;\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 // Update ingredients if provided\n if (updates.ingredients !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ?`, [recipeId]);\n for (let i = 0; i < updates.ingredients.length; i++) {\n const ing = updates.ingredients[i];\n const ingId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} (id, recipe_id, name, amount, unit, order_index)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, i]\n );\n }\n }\n \n // Update nutrition if provided\n if (updates.nutrition !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`, [recipeId]);\n if (updates.nutrition) {\n const nutId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} (id, recipe_id, calories, protein, fiber, fat, carbs)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [nutId, recipeId, updates.nutrition.calories ?? null, updates.nutrition.protein ?? null, updates.nutrition.fiber ?? null, updates.nutrition.fat ?? null, updates.nutrition.carbs ?? null]\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 => ({ name: i.name, amount: i.amount, unit: i.unit })),\n original.nutrition ? {\n calories: original.nutrition.calories,\n protein: original.nutrition.protein,\n fiber: original.nutrition.fiber,\n fat: original.nutrition.fat,\n carbs: original.nutrition.carbs,\n } : null\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 entries with recipe info\n const entriesResult = await sqlite.execute(\n `SELECT e.id, e.meal_plan_id, e.day_of_week, e.meal_type, e.recipe_id, e.servings,\n r.title as recipe_title, r.serving_size as recipe_serving_size\n FROM ${MEAL_PLAN_ENTRIES_TABLE} e\n JOIN ${RECIPES_TABLE} r ON e.recipe_id = r.id\n WHERE e.meal_plan_id = ?\n ORDER BY e.day_of_week, e.meal_type`,\n [mealPlanId]\n );\n \n const entries: MealPlanEntry[] = [];\n for (const e of entriesResult.rows) {\n const recipe = await getRecipeById(e.recipe_id as string, userId);\n entries.push({\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,\n recipe: recipe || undefined,\n servings: e.servings as number,\n });\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\nexport async function addMealPlanEntry(\n userId: string,\n weekStartDate: string,\n dayOfWeek: DayOfWeek,\n mealType: MealType,\n recipeId: string,\n servings: number = 1\n): Promise {\n // Verify recipe ownership\n const recipe = await getRecipeById(recipeId, userId);\n if (!recipe) return null;\n \n const mealPlan = await getOrCreateMealPlan(userId, weekStartDate);\n const entryId = generateId();\n \n await sqlite.execute(\n `INSERT INTO ${MEAL_PLAN_ENTRIES_TABLE} (id, meal_plan_id, day_of_week, meal_type, recipe_id, servings)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [entryId, mealPlan.id, dayOfWeek, mealType, recipeId, servings]\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,\n recipe,\n servings,\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 recipeId: string,\n mealType: MealType,\n days: DayOfWeek[],\n servings: number = 1\n): Promise {\n const entries: MealPlanEntry[] = [];\n \n for (const day of days) {\n const entry = await addMealPlanEntry(userId, weekStartDate, day, mealType, recipeId, servings);\n if (entry) entries.push(entry);\n }\n \n return entries;\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 GROCERY_LISTS_TABLE,\n GROCERY_LIST_ITEMS_TABLE,\n NUTRITION_GOALS_TABLE,\n MEAL_PLANS_TABLE,\n MEAL_PLAN_ENTRIES_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} from \"../../shared/types.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\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, order_index\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 orderIndex: i.order_index as number,\n }));\n \n // Get nutrition\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fiber, fat, carbs\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 = {\n id: n.id as string,\n recipeId: n.recipe_id as string,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fiber: n.fiber as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n };\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\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, order_index\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 orderIndex: i.order_index as number,\n }));\n \n // Get nutrition\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fiber, fat, carbs\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 = {\n id: n.id as string,\n recipeId: n.recipe_id as string,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fiber: n.fiber as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n };\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: { name: string; amount?: number | null; unit?: string | null }[],\n nutrition?: { calories?: number | null; protein?: number | null; fiber?: number | null; fat?: number | null; carbs?: number | null } | null\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\n const recipeIngredients: RecipeIngredient[] = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ing = ingredients[i];\n const ingId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} (id, recipe_id, name, amount, unit, order_index)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, i]\n );\n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n orderIndex: i,\n });\n }\n \n // Insert nutrition if provided\n let recipeNutrition: RecipeNutrition | null = null;\n if (nutrition) {\n const nutId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} (id, recipe_id, calories, protein, fiber, fat, carbs)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [nutId, recipeId, nutrition.calories ?? null, nutrition.protein ?? null, nutrition.fiber ?? null, nutrition.fat ?? null, nutrition.carbs ?? null]\n );\n recipeNutrition = {\n id: nutId,\n recipeId,\n calories: nutrition.calories ?? null,\n protein: nutrition.protein ?? null,\n fiber: nutrition.fiber ?? null,\n fat: nutrition.fat ?? null,\n carbs: nutrition.carbs ?? null,\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?: { name: string; amount?: number | null; unit?: string | null }[];\n nutrition?: { calories?: number | null; protein?: number | null; fiber?: number | null; fat?: number | null; carbs?: number | null } | null;\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 // Update ingredients if provided\n if (updates.ingredients !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ?`, [recipeId]);\n for (let i = 0; i < updates.ingredients.length; i++) {\n const ing = updates.ingredients[i];\n const ingId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} (id, recipe_id, name, amount, unit, order_index)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, i]\n );\n }\n }\n \n // Update nutrition if provided\n if (updates.nutrition !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`, [recipeId]);\n if (updates.nutrition) {\n const nutId = generateId();\n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} (id, recipe_id, calories, protein, fiber, fat, carbs)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [nutId, recipeId, updates.nutrition.calories ?? null, updates.nutrition.protein ?? null, updates.nutrition.fiber ?? null, updates.nutrition.fat ?? null, updates.nutrition.carbs ?? null]\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 => ({ name: i.name, amount: i.amount, unit: i.unit })),\n original.nutrition ? {\n calories: original.nutrition.calories,\n protein: original.nutrition.protein,\n fiber: original.nutrition.fiber,\n fat: original.nutrition.fat,\n carbs: original.nutrition.carbs,\n } : null\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 entries with recipe info\n const entriesResult = await sqlite.execute(\n `SELECT e.id, e.meal_plan_id, e.day_of_week, e.meal_type, e.recipe_id, e.servings,\n r.title as recipe_title, r.serving_size as recipe_serving_size\n FROM ${MEAL_PLAN_ENTRIES_TABLE} e\n JOIN ${RECIPES_TABLE} r ON e.recipe_id = r.id\n WHERE e.meal_plan_id = ?\n ORDER BY e.day_of_week, e.meal_type`,\n [mealPlanId]\n );\n \n const entries: MealPlanEntry[] = [];\n for (const e of entriesResult.rows) {\n const recipe = await getRecipeById(e.recipe_id as string, userId);\n entries.push({\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,\n recipe: recipe || undefined,\n servings: e.servings as number,\n });\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\nexport async function addMealPlanEntry(\n userId: string,\n weekStartDate: string,\n dayOfWeek: DayOfWeek,\n mealType: MealType,\n recipeId: string,\n servings: number = 1\n): Promise {\n // Verify recipe ownership\n const recipe = await getRecipeById(recipeId, userId);\n if (!recipe) return null;\n \n const mealPlan = await getOrCreateMealPlan(userId, weekStartDate);\n const entryId = generateId();\n \n await sqlite.execute(\n `INSERT INTO ${MEAL_PLAN_ENTRIES_TABLE} (id, meal_plan_id, day_of_week, meal_type, recipe_id, servings)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [entryId, mealPlan.id, dayOfWeek, mealType, recipeId, servings]\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,\n recipe,\n servings,\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 recipeId: string,\n mealType: MealType,\n days: DayOfWeek[],\n servings: number = 1\n): Promise {\n const entries: MealPlanEntry[] = [];\n \n for (const day of days) {\n const entry = await addMealPlanEntry(userId, weekStartDate, day, mealType, recipeId, servings);\n if (entry) entries.push(entry);\n }\n \n return entries;\n}\n\n\n","createdAt",["D",1765692340298],"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":420,"_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":421,"_82":422,"_84":423,"_86":25},"tree",[187,200,212,214,215,216],"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],"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":417,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":418,"_27":419},{"_44":412,"_32":403,"_30":399,"_137":173,"_42":43,"_41":413,"_139":60,"_39":414,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":415,"_27":416},{"_44":404,"_32":405,"_30":406,"_137":399,"_42":43,"_41":407,"_139":25,"_39":408,"_13":64,"_34":35,"_36":409,"_24":25,"_142":-5,"_218":410,"_27":411},{"_44":398,"_32":33,"_30":31,"_137":399,"_42":43,"_41":14,"_139":25,"_39":400,"_13":168,"_34":35,"_36":38,"_24":25,"_142":-5,"_218":401,"_27":402},{"_44":393,"_32":392,"_30":386,"_137":173,"_42":43,"_41":394,"_139":60,"_39":395,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":396,"_27":397},{"_44":383,"_32":384,"_30":385,"_137":386,"_42":43,"_41":387,"_139":25,"_39":388,"_13":168,"_34":35,"_36":389,"_24":25,"_142":-5,"_218":390,"_27":391},{"_44":378,"_32":345,"_30":339,"_137":173,"_42":43,"_41":379,"_139":60,"_39":380,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":381,"_27":382},{"_44":370,"_32":371,"_30":372,"_137":339,"_42":43,"_41":373,"_139":25,"_39":374,"_13":64,"_34":35,"_36":375,"_24":25,"_142":-5,"_218":376,"_27":377},{"_44":362,"_32":363,"_30":364,"_137":339,"_42":43,"_41":365,"_139":25,"_39":366,"_13":64,"_34":35,"_36":367,"_24":25,"_142":-5,"_218":368,"_27":369},{"_44":354,"_32":355,"_30":356,"_137":339,"_42":43,"_41":357,"_139":25,"_39":358,"_13":64,"_34":35,"_36":359,"_24":25,"_142":-5,"_218":360,"_27":361},{"_44":346,"_32":347,"_30":348,"_137":339,"_42":43,"_41":349,"_139":25,"_39":350,"_13":64,"_34":35,"_36":351,"_24":25,"_142":-5,"_218":352,"_27":353},{"_44":336,"_32":337,"_30":338,"_137":339,"_42":43,"_41":340,"_139":25,"_39":341,"_13":64,"_34":35,"_36":342,"_24":25,"_142":-5,"_218":343,"_27":344},{"_44":328,"_32":329,"_30":58,"_137":173,"_42":43,"_41":330,"_139":25,"_39":331,"_13":168,"_34":332,"_36":333,"_24":25,"_142":-5,"_218":334,"_27":335},{"_44":165,"_32":166,"_30":167,"_137":-5,"_42":43,"_41":168,"_139":60,"_39":325,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":326,"_27":327},{"_44":320,"_32":271,"_30":265,"_137":167,"_42":43,"_41":321,"_139":60,"_39":322,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":323,"_27":324},{"_44":312,"_32":313,"_30":314,"_137":265,"_42":43,"_41":315,"_139":25,"_39":316,"_13":168,"_34":35,"_36":317,"_24":25,"_142":-5,"_218":318,"_27":319},{"_44":304,"_32":305,"_30":306,"_137":265,"_42":43,"_41":307,"_139":25,"_39":308,"_13":174,"_34":35,"_36":309,"_24":25,"_142":-5,"_218":310,"_27":311},{"_44":296,"_32":297,"_30":298,"_137":265,"_42":43,"_41":299,"_139":25,"_39":300,"_13":64,"_34":35,"_36":301,"_24":25,"_142":-5,"_218":302,"_27":303},{"_44":288,"_32":289,"_30":290,"_137":265,"_42":43,"_41":291,"_139":25,"_39":292,"_13":168,"_34":35,"_36":293,"_24":25,"_142":-5,"_218":294,"_27":295},{"_44":280,"_32":281,"_30":282,"_137":265,"_42":43,"_41":283,"_139":25,"_39":284,"_13":168,"_34":35,"_36":285,"_24":25,"_142":-5,"_218":286,"_27":287},{"_44":272,"_32":273,"_30":274,"_137":265,"_42":43,"_41":275,"_139":25,"_39":276,"_13":161,"_34":35,"_36":277,"_24":25,"_142":-5,"_218":278,"_27":279},{"_44":262,"_32":263,"_30":264,"_137":265,"_42":43,"_41":266,"_139":25,"_39":267,"_13":168,"_34":35,"_36":268,"_24":25,"_142":-5,"_218":269,"_27":270},{"_44":254,"_32":255,"_30":256,"_137":167,"_42":43,"_41":257,"_139":25,"_39":258,"_13":64,"_34":20,"_36":259,"_24":25,"_142":-5,"_218":260,"_27":261},{"_44":246,"_32":247,"_30":248,"_137":167,"_42":43,"_41":249,"_139":25,"_39":250,"_13":168,"_34":20,"_36":251,"_24":25,"_142":-5,"_218":252,"_27":253},{"_44":238,"_32":239,"_30":240,"_137":167,"_42":43,"_41":241,"_139":25,"_39":242,"_13":168,"_34":35,"_36":243,"_24":25,"_142":-5,"_218":244,"_27":245},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":60,"_39":235,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_218":236,"_27":237},{"_44":227,"_32":228,"_30":229,"_137":160,"_42":43,"_41":230,"_139":25,"_39":231,"_13":64,"_34":35,"_36":232,"_24":25,"_142":-5,"_218":233,"_27":234},{"_44":151,"_32":152,"_30":153,"_137":-5,"_42":43,"_41":154,"_139":25,"_39":224,"_13":64,"_34":20,"_36":156,"_24":25,"_142":-5,"_218":225,"_27":226},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":60,"_39":221,"_13":64,"_34":20,"_36":149,"_24":25,"_142":-5,"_218":222,"_27":223},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":217,"_13":64,"_34":20,"_36":141,"_24":25,"_142":-5,"_218":219,"_27":220},["D",1765138635487],"children",[],[135],["D",1765138635892],[],[145],["D",1765138635895],[],[152],"b9331e80-d3a9-11f0-a755-42dde27851f2","types.ts","b9331f48-d3a9-11f0-a755-42dde27851f2",27,["D",1765138635815],"// 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 orderIndex: number;\n}\n\nexport interface RecipeNutrition {\n id: string;\n recipeId: string;\n calories: number | null;\n protein: number | null;\n fiber: number | null;\n fat: number | null;\n carbs: number | null;\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\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\nexport interface MealPlanEntry {\n id: string;\n mealPlanId: string;\n dayOfWeek: DayOfWeek;\n mealType: MealType;\n recipeId: string;\n recipe?: Recipe;\n servings: number;\n}\n\nexport interface DailyNutrition {\n calories: number;\n protein: number;\n fiber: number;\n fat: number;\n carbs: number;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\n// Request types\nexport interface CreateRecipeRequest {\n title: string;\n url?: string | null;\n instructions?: string | null;\n servingSize: number;\n ingredients: { name: string; amount?: number | null; unit?: string | null }[];\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\nexport interface AddMealPlanEntryRequest {\n weekStartDate: string;\n dayOfWeek: DayOfWeek;\n mealType: MealType;\n recipeId: string;\n servings?: number;\n}\n\nexport interface ScheduleMealRequest {\n recipeId: string;\n mealType: MealType;\n weekStartDate: string;\n days: DayOfWeek[]; // which days to add to\n servings?: number;\n}\n\n",[],[159,228],["D",1765138634405],[213],[159],"ea881e64-d8b2-11f0-8b30-42dde27851f2","index.tsx","b8cb9256-d3a9-11f0-ba80-42dde27851f2",37,["D",1765692339898],"/** @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",[],[166,239],"eaa0bd0c-d8b2-11f0-b98f-42dde27851f2","index.html","b8d03d1a-d3a9-11f0-8004-42dde27851f2",40,["D",1765692339900],"\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",[],[166,247],"b8f8fb10-d3a9-11f0-897f-42dde27851f2","favicon.svg","b8f8fbb0-d3a9-11f0-897f-42dde27851f2",15,["D",1765138635470],"\n\n",[],[166,255],"c861732c-d3ac-11f0-bea2-42dde27851f2","RecipesView.tsx","b8e58968-d3a9-11f0-a23f-42dde27851f2","b86d06aa-d3a9-11f0-b1e3-42dde27851f2",32,["D",1765139949804],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest } from \"../../shared/types.ts\";\nimport { RecipeForm } from \"./RecipeForm.tsx\";\n\ninterface RecipesViewProps {\n recipes: Recipe[];\n onRecipesChange: () => Promise;\n}\n\nexport function RecipesView({ recipes, onRecipesChange }: RecipesViewProps) {\n const [showForm, setShowForm] = useState(false);\n const [editingRecipe, setEditingRecipe] = useState(null);\n const [searchQuery, setSearchQuery] = useState('');\n const [expandedRecipe, setExpandedRecipe] = 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 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 return (\n

\n {/* Header */}\n

Recipes

{recipes.length} recipes saved

\n setShowForm(true)}\n className=\"btn-primary flex items-center gap-2\"\n >\n \n Add Recipe\n \n

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

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

\n \n {/* Recipe list */}\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 \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 {recipe.nutrition && (\n

\n {recipe.nutrition.calories && (\n \n {recipe.nutrition.calories} kcal\n \n )}\n {recipe.nutrition.protein && (\n \n {recipe.nutrition.protein}g protein\n \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 {/* Ingredients */}\n

Ingredients

\n \n {ing.unit && {ing.unit}}\n {ing.name}\n

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

Instructions

{recipe.instructions}

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

Nutrition (per serving)

{recipe.nutrition.calories || '-'}

kcal

{recipe.nutrition.protein || '-'}g

protein

{recipe.nutrition.carbs || '-'}g

carbs

{recipe.nutrition.fat || '-'}g

fat

{recipe.nutrition.fiber || '-'}g

fiber

\n )}\n \n {/* Actions */}\n

\n setEditingRecipe(recipe)}\n className=\"btn-secondary text-sm flex-1\"\n >\n Edit\n \n handleDuplicate(recipe.id)}\n className=\"btn-secondary text-sm flex-1\"\n >\n Duplicate\n \n handleDelete(recipe.id)}\n className=\"btn-secondary text-sm text-red-600 hover:bg-red-50\"\n >\n Delete\n \n

\n )}\n

\n ))}\n

\n )}\n \n \n {/* Create recipe modal */}\n {showForm && (\n setShowForm(false)}\n />\n )}\n \n {/* Edit recipe modal */}\n {editingRecipe && (\n setEditingRecipe(null)}\n />\n )}\n \n );\n}\n\n",[],[166,271,263],"components","eaa64790-d8b2-11f0-8b30-42dde27851f2","RecipeForm.tsx","b8ea08ee-d3a9-11f0-8d63-42dde27851f2",41,["D",1765692340096],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest } from \"../../shared/types.ts\";\n\ninterface Ingredient {\n amount: string; // Combined amount + unit, e.g., \"2 cups\" or \"1 lb\"\n name: string; // Ingredient name\n}\n\ninterface RecipeFormProps {\n recipe?: Recipe;\n onSubmit: (data: CreateRecipeRequest) => Promise;\n onClose: () => void;\n}\n\nexport function RecipeForm({ recipe, onSubmit, onClose }: RecipeFormProps) {\n const [title, setTitle] = useState(recipe?.title || '');\n const [url, setUrl] = useState(recipe?.url || '');\n const [servingSize, setServingSize] = useState(recipe?.servingSize?.toString() || '1');\n const [instructions, setInstructions] = useState(recipe?.instructions || '');\n const [ingredients, setIngredients] = useState(\n recipe?.ingredients.map(i => ({\n // Combine amount and unit for display\n amount: [i.amount, i.unit].filter(Boolean).join(' ').trim(),\n name: i.name,\n })) || [{ amount: '', name: '' }]\n );\n const [showNutrition, setShowNutrition] = useState(!!recipe?.nutrition);\n const [nutrition, setNutrition] = useState({\n calories: recipe?.nutrition?.calories?.toString() || '',\n protein: recipe?.nutrition?.protein?.toString() || '',\n carbs: recipe?.nutrition?.carbs?.toString() || '',\n fat: recipe?.nutrition?.fat?.toString() || '',\n fiber: recipe?.nutrition?.fiber?.toString() || '',\n });\n const [submitting, setSubmitting] = useState(false);\n\n const addIngredient = () => {\n setIngredients([...ingredients, { amount: '', name: '' }]);\n };\n\n const removeIngredient = (index: number) => {\n setIngredients(ingredients.filter((_, i) => i !== index));\n };\n\n const updateIngredient = (index: number, field: keyof Ingredient, value: string) => {\n const updated = [...ingredients];\n updated[index][field] = value;\n setIngredients(updated);\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!title.trim()) return;\n \n setSubmitting(true);\n \n try {\n const data: CreateRecipeRequest = {\n title: title.trim(),\n url: url.trim() || null,\n servingSize: parseInt(servingSize) || 1,\n instructions: instructions.trim() || null,\n ingredients: ingredients\n .filter(i => i.name.trim())\n .map(i => ({\n name: i.name.trim(),\n amount: null, // Store combined amount in unit field\n unit: i.amount.trim() || null, // e.g., \"2 cups\", \"1 lb\"\n })),\n nutrition: showNutrition ? {\n calories: nutrition.calories ? parseFloat(nutrition.calories) : null,\n protein: nutrition.protein ? parseFloat(nutrition.protein) : null,\n carbs: nutrition.carbs ? parseFloat(nutrition.carbs) : null,\n fat: nutrition.fat ? parseFloat(nutrition.fat) : null,\n fiber: nutrition.fiber ? parseFloat(nutrition.fiber) : null,\n } : null,\n };\n \n await onSubmit(data);\n } finally {\n setSubmitting(false);\n }\n };\n\n return (\n

\n e.stopPropagation()}\n >\n

\n {/* Header */}\n

\n {recipe ? 'Edit Recipe' : 'Add Recipe'}\n

\n \n \n \n

\n \n {/* Body */}\n

\n {/* Title */}\n

\n \n Recipe Title *\n \n setTitle(e.target.value)}\n className=\"input\"\n placeholder=\"e.g., Chicken Stir Fry\"\n required\n />\n

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

\n \n Recipe URL (optional)\n \n setUrl(e.target.value)}\n className=\"input\"\n placeholder=\"https://...\"\n />\n

\n \n {/* Serving size */}\n

\n \n Serving Size\n \n setServingSize(e.target.value)}\n className=\"input w-32\"\n min=\"1\"\n />\n

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

\n \n Ingredients\n \n

\n {ingredients.map((ing, index) => (\n

\n updateIngredient(index, 'amount', e.target.value)}\n className=\"input flex-shrink-0\"\n style={{ width: '4.5rem', minWidth: '4.5rem', maxWidth: '4.5rem' }}\n placeholder=\"Amt\"\n />\n updateIngredient(index, 'name', e.target.value)}\n className=\"input flex-1 min-w-0\"\n placeholder=\"Ingredient name or description\"\n />\n {ingredients.length > 1 && (\n removeIngredient(index)}\n className=\"text-gray-400 hover:text-red-500 transition-colors flex-shrink-0 p-1\"\n >\n \n \n )}\n

\n ))}\n

\n \n \n Add ingredient\n \n

\n \n {/* Instructions */}\n

\n \n Instructions (optional)\n \n setInstructions(e.target.value)}\n className=\"input min-h-[100px] resize-y\"\n placeholder=\"Enter cooking instructions...\"\n />\n

\n \n {/* Nutrition toggle */}\n

\n setShowNutrition(!showNutrition)}\n className=\"text-sm font-medium flex items-center gap-2\"\n style={{ color: '#0f2763' }}\n >\n \n \n \n {showNutrition ? 'Hide' : 'Add'} nutrition information\n \n

\n \n {/* Nutrition fields */}\n {showNutrition && (\n

Nutrition per serving

\n Calories\n setNutrition({ ...nutrition, calories: e.target.value })}\n className=\"input text-sm\"\n placeholder=\"kcal\"\n />\n

\n Protein (g)\n setNutrition({ ...nutrition, protein: e.target.value })}\n className=\"input text-sm\"\n placeholder=\"g\"\n />\n

\n Carbs (g)\n setNutrition({ ...nutrition, carbs: e.target.value })}\n className=\"input text-sm\"\n placeholder=\"g\"\n />\n

\n Fat (g)\n setNutrition({ ...nutrition, fat: e.target.value })}\n className=\"input text-sm\"\n placeholder=\"g\"\n />\n

\n Fiber (g)\n setNutrition({ ...nutrition, fiber: e.target.value })}\n className=\"input text-sm\"\n placeholder=\"g\"\n />\n

\n )}\n

\n \n {/* Footer */}\n

\n \n Cancel\n \n \n {submitting ? 'Saving...' : (recipe ? 'Save Changes' : 'Add Recipe')}\n \n

\n \n );\n}\n\n",[],[166,271,273],"ea971284-d8b2-11f0-8b30-42dde27851f2","NutritionView.tsx","b8f099c0-d3a9-11f0-8d63-42dde27851f2",39,["D",1765692339997],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { NutritionGoals, NutritionGoalType, DailyNutrition } from \"../../shared/types.ts\";\nimport { NUTRITION_GOAL_LABELS, NUTRITION_GOAL_UNITS } from \"../../shared/types.ts\";\n\ninterface NutritionViewProps {\n goals: NutritionGoals | null;\n onGoalsChange: () => Promise;\n}\n\nconst GOAL_TYPES: NutritionGoalType[] = ['calories', 'protein', 'fiber', 'fat', 'carbs'];\n\nfunction getWeekStartDate(date: Date): string {\n const d = new Date(date);\n const day = d.getDay();\n d.setDate(d.getDate() - day);\n d.setHours(0, 0, 0, 0);\n return d.toISOString().split('T')[0];\n}\n\nexport function NutritionView({ goals, onGoalsChange }: NutritionViewProps) {\n const [editing, setEditing] = useState(false);\n const [primaryType, setPrimaryType] = useState(goals?.primaryGoalType || 'calories');\n const [primaryValue, setPrimaryValue] = useState(goals?.primaryGoalValue?.toString() || '2000');\n const [sub1Type, setSub1Type] = useState(goals?.subGoal1Type || '');\n const [sub1Value, setSub1Value] = useState(goals?.subGoal1Value?.toString() || '');\n const [sub2Type, setSub2Type] = useState(goals?.subGoal2Type || '');\n const [sub2Value, setSub2Value] = useState(goals?.subGoal2Value?.toString() || '');\n const [submitting, setSubmitting] = useState(false);\n \n const [weeklyData, setWeeklyData] = useState<{\n daily: Record;\n weeklyAverage: DailyNutrition;\n } | null>(null);\n const [loadingWeekly, setLoadingWeekly] = useState(false);\n\n const fetchWeeklyData = useCallback(async () => {\n setLoadingWeekly(true);\n try {\n const weekStart = getWeekStartDate(new Date());\n const response = await fetch(`/api/nutrition/weekly?weekStartDate=${weekStart}`);\n const data = await response.json();\n if (data.success) {\n setWeeklyData(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch weekly nutrition:', err);\n } finally {\n setLoadingWeekly(false);\n }\n }, []);\n\n useEffect(() => {\n fetchWeeklyData();\n }, [fetchWeeklyData]);\n\n // Update form when goals change\n useEffect(() => {\n if (goals) {\n setPrimaryType(goals.primaryGoalType);\n setPrimaryValue(goals.primaryGoalValue.toString());\n setSub1Type(goals.subGoal1Type || '');\n setSub1Value(goals.subGoal1Value?.toString() || '');\n setSub2Type(goals.subGoal2Type || '');\n setSub2Value(goals.subGoal2Value?.toString() || '');\n }\n }, [goals]);\n\n const handleSave = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!primaryValue) return;\n \n setSubmitting(true);\n \n try {\n const response = await fetch('/api/nutrition/goals', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n primaryGoalType: primaryType,\n primaryGoalValue: parseFloat(primaryValue),\n subGoal1Type: sub1Type || null,\n subGoal1Value: sub1Value ? parseFloat(sub1Value) : null,\n subGoal2Type: sub2Type || null,\n subGoal2Value: sub2Value ? parseFloat(sub2Value) : null,\n }),\n });\n \n if (response.ok) {\n await onGoalsChange();\n setEditing(false);\n }\n } finally {\n setSubmitting(false);\n }\n };\n\n const getProgressColor = (percent: number): string => {\n if (percent >= 90 && percent <= 110) return '#4ade80'; // success\n if (percent > 110) return '#fbbf24'; // warning\n return '#0f2763'; // primary\n };\n\n const renderGoalCard = (\n type: NutritionGoalType,\n targetValue: number,\n currentValue: number,\n isPrimary: boolean\n ) => {\n const percent = (currentValue / targetValue) * 100;\n const cappedPercent = Math.min(percent, 100);\n \n return (\n \n

\n \n {type === 'calories' ? '🔥' : type === 'protein' ? '💪' : type === 'fiber' ? '🥬' : type === 'fat' ? '🥑' : '🍞'}\n \n

{NUTRITION_GOAL_LABELS[type]}

\n {isPrimary && (\n \n Primary Goal\n \n )}\n

{Math.round(currentValue)}

of {targetValue} {NUTRITION_GOAL_UNITS[type]}

\n \n

\n {Math.round(percent)}% of daily goal\n = 90 && percent <= 110 ? 'text-green-600' : percent > 110 ? 'text-amber-600' : 'text-gray-600'}`}>\n {targetValue - currentValue > 0 ? `${Math.round(targetValue - currentValue)} ${NUTRITION_GOAL_UNITS[type]} remaining` : 'Goal reached!'}\n \n

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

\n {/* Header */}\n

Nutrition Goals

Track your daily nutrition against your goals

\n setEditing(true)}\n className=\"btn-secondary text-sm\"\n >\n {goals ? 'Edit Goals' : 'Set Goals'}\n \n

\n \n {/* Goals display */}\n {goals ? (\n

\n {/* Primary goal */}\n

\n {renderGoalCard(\n goals.primaryGoalType,\n goals.primaryGoalValue,\n weeklyData?.weeklyAverage[goals.primaryGoalType as keyof DailyNutrition] || 0,\n true\n )}\n \n {/* Sub goals */}\n {goals.subGoal1Type && goals.subGoal1Value && (\n renderGoalCard(\n goals.subGoal1Type,\n goals.subGoal1Value,\n weeklyData?.weeklyAverage[goals.subGoal1Type as keyof DailyNutrition] || 0,\n false\n )\n )}\n \n {goals.subGoal2Type && goals.subGoal2Value && (\n renderGoalCard(\n goals.subGoal2Type,\n goals.subGoal2Value,\n weeklyData?.weeklyAverage[goals.subGoal2Type as keyof DailyNutrition] || 0,\n false\n )\n )}\n

\n \n {/* Weekly overview */}\n {weeklyData && (\n

This Week's Overview

\n {['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'].map((day, i) => {\n const dayData = weeklyData.daily[i];\n const percent = (dayData[goals.primaryGoalType as keyof DailyNutrition] / goals.primaryGoalValue) * 100;\n \n return (\n

{day}

\n \n

\n {Math.round(dayData[goals.primaryGoalType as keyof DailyNutrition])}\n

\n );\n })}\n

\n On target (90-110%)\n

\n Over target\n

\n Under target\n

\n )}\n \n {/* All nutrition breakdown */}\n

Weekly Average Breakdown

\n {GOAL_TYPES.map((type) => {\n const value = weeklyData?.weeklyAverage[type as keyof DailyNutrition] || 0;\n let goal: number | null = null;\n \n if (goals.primaryGoalType === type) goal = goals.primaryGoalValue;\n else if (goals.subGoal1Type === type) goal = goals.subGoal1Value;\n else if (goals.subGoal2Type === type) goal = goals.subGoal2Value;\n \n return (\n

\n {type === 'calories' ? '🔥' : type === 'protein' ? '💪' : type === 'fiber' ? '🥬' : type === 'fat' ? '🥑' : '🍞'}\n

\n {Math.round(value)}\n {NUTRITION_GOAL_UNITS[type]}\n

{NUTRITION_GOAL_LABELS[type]}

\n {goal && (\n

\n {Math.round((value / goal) * 100)}% of goal\n

\n )}\n

\n );\n })}\n

\n ) : (\n

\n 🎯\n

Set Your Nutrition Goals

\n Define your daily nutrition targets to track your progress and stay on track with your health goals.\n

\n \n

\n )}\n

\n \n {/* Edit goals modal */}\n {editing && (\n

setEditing(false)}>\n

e.stopPropagation()}>\n

\n {goals ? 'Edit Nutrition Goals' : 'Set Nutrition Goals'}\n

\n Set one primary goal and up to two sub-goals\n

\n \n

\n {/* Primary goal */}\n

\n \n Primary Goal\n \n

\n Type\n setPrimaryType(e.target.value as NutritionGoalType)}\n className=\"input\"\n >\n {GOAL_TYPES.map((type) => (\n \n ))}\n \n

\n \n Target ({NUTRITION_GOAL_UNITS[primaryType]})\n \n setPrimaryValue(e.target.value)}\n className=\"input\"\n required\n />\n

\n \n {/* Sub-goal 1 */}\n

\n Sub-Goal 1 (Optional)\n {sub1Type && (\n { setSub1Type(''); setSub1Value(''); }}\n className=\"text-xs text-gray-500 hover:text-red-500\"\n >\n Remove\n \n )}\n

\n setSub1Type(e.target.value as NutritionGoalType)}\n className=\"input\"\n >\n \n {GOAL_TYPES.filter(t => t !== primaryType && t !== sub2Type).map((type) => (\n \n ))}\n \n

\n setSub1Value(e.target.value)}\n className=\"input\"\n placeholder={sub1Type ? NUTRITION_GOAL_UNITS[sub1Type] : 'Target'}\n disabled={!sub1Type}\n />\n

\n \n {/* Sub-goal 2 */}\n

\n Sub-Goal 2 (Optional)\n {sub2Type && (\n { setSub2Type(''); setSub2Value(''); }}\n className=\"text-xs text-gray-500 hover:text-red-500\"\n >\n Remove\n \n )}\n

\n setSub2Type(e.target.value as NutritionGoalType)}\n className=\"input\"\n >\n \n {GOAL_TYPES.filter(t => t !== primaryType && t !== sub1Type).map((type) => (\n \n ))}\n \n

\n setSub2Value(e.target.value)}\n className=\"input\"\n placeholder={sub2Type ? NUTRITION_GOAL_UNITS[sub2Type] : 'Target'}\n disabled={!sub2Type}\n />\n

\n \n

\n \n \n

\n )}\n

\n );\n}\n\n\n",[],[166,271,281],"eaadfd1e-d8b2-11f0-b955-42dde27851f2","MealPlanView.tsx","b9076826-d3a9-11f0-8004-42dde27851f2",42,["D",1765692340147],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, MealPlan, MealPlanEntry, NutritionGoals, DayOfWeek, MealType, DailyNutrition } from \"../../shared/types.ts\";\nimport { DAY_NAMES, MEAL_TYPES, MEAL_TYPE_LABELS } from \"../../shared/types.ts\";\n\ninterface MealPlanViewProps {\n recipes: Recipe[];\n nutritionGoals: NutritionGoals | null;\n}\n\ninterface WeeklyNutritionData {\n daily: Record;\n weeklyAverage: DailyNutrition;\n goals: NutritionGoals | null;\n}\n\nfunction getWeekStartDate(date: Date): string {\n const d = new Date(date);\n const day = d.getDay();\n d.setDate(d.getDate() - day);\n d.setHours(0, 0, 0, 0);\n return d.toISOString().split('T')[0];\n}\n\nfunction formatDate(dateStr: string, dayOffset: number): string {\n const date = new Date(dateStr);\n date.setDate(date.getDate() + dayOffset);\n return date.toLocaleDateString('en-US', { month: 'short', day: 'numeric' });\n}\n\nexport function MealPlanView({ recipes, nutritionGoals }: MealPlanViewProps) {\n const [currentWeek, setCurrentWeek] = useState(() => getWeekStartDate(new Date()));\n const [mealPlan, setMealPlan] = useState(null);\n const [nutritionData, setNutritionData] = useState(null);\n const [loading, setLoading] = useState(true);\n const [showAddMeal, setShowAddMeal] = useState<{ day: DayOfWeek; mealType: MealType } | null>(null);\n const [showSchedule, setShowSchedule] = useState(false);\n const [scheduleRecipe, setScheduleRecipe] = useState('');\n const [scheduleMealType, setScheduleMealType] = useState('breakfast');\n const [scheduleDays, setScheduleDays] = useState([]);\n\n const fetchMealPlan = useCallback(async () => {\n setLoading(true);\n try {\n const [planRes, nutritionRes] = await Promise.all([\n fetch(`/api/meal-plans?weekStartDate=${currentWeek}`),\n fetch(`/api/nutrition/weekly?weekStartDate=${currentWeek}`),\n ]);\n \n const planData = await planRes.json();\n const nutritionDataJson = await nutritionRes.json();\n \n if (planData.success) {\n setMealPlan(planData.data);\n }\n if (nutritionDataJson.success) {\n setNutritionData(nutritionDataJson.data);\n }\n } catch (err) {\n console.error('Failed to fetch meal plan:', err);\n } finally {\n setLoading(false);\n }\n }, [currentWeek]);\n\n useEffect(() => {\n fetchMealPlan();\n }, [fetchMealPlan]);\n\n const navigateWeek = (direction: number) => {\n const date = new Date(currentWeek);\n date.setDate(date.getDate() + (direction * 7));\n setCurrentWeek(getWeekStartDate(date));\n };\n\n const goToCurrentWeek = () => {\n setCurrentWeek(getWeekStartDate(new Date()));\n };\n\n const handleAddMeal = async (recipeId: string) => {\n if (!showAddMeal) return;\n \n const response = await fetch('/api/meal-plans/entries', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n weekStartDate: currentWeek,\n dayOfWeek: showAddMeal.day,\n mealType: showAddMeal.mealType,\n recipeId,\n servings: 1,\n }),\n });\n \n if (response.ok) {\n await fetchMealPlan();\n setShowAddMeal(null);\n }\n };\n\n const handleRemoveMeal = async (entryId: string) => {\n const response = await fetch(`/api/meal-plans/entries/${entryId}`, {\n method: 'DELETE',\n });\n \n if (response.ok) {\n await fetchMealPlan();\n }\n };\n\n const handleScheduleMeals = async () => {\n if (!scheduleRecipe || scheduleDays.length === 0) return;\n \n const response = await fetch('/api/meal-plans/schedule', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n weekStartDate: currentWeek,\n recipeId: scheduleRecipe,\n mealType: scheduleMealType,\n days: scheduleDays,\n servings: 1,\n }),\n });\n \n if (response.ok) {\n await fetchMealPlan();\n setShowSchedule(false);\n setScheduleRecipe('');\n setScheduleDays([]);\n }\n };\n\n const getEntriesForCell = (day: DayOfWeek, mealType: MealType): MealPlanEntry[] => {\n if (!mealPlan?.entries) return [];\n return mealPlan.entries.filter(e => e.dayOfWeek === day && e.mealType === mealType);\n };\n\n const getNutritionProgress = (value: number, goal: number): { percent: number; status: 'success' | 'warning' | 'primary' } => {\n const percent = Math.min((value / goal) * 100, 100);\n if (percent >= 90 && percent <= 110) return { percent, status: 'success' };\n if (percent > 110) return { percent: 100, status: 'warning' };\n return { percent, status: 'primary' };\n };\n\n if (loading) {\n return (\n

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

\n {/* Header */}\n

\n navigateWeek(-1)}\n className=\"p-2 rounded-lg hover:bg-gray-200 transition-colors\"\n >\n \n \n

\n Week of {formatDate(currentWeek, 0)}\n

\n {formatDate(currentWeek, 0)} - {formatDate(currentWeek, 6)}\n

\n navigateWeek(1)}\n className=\"p-2 rounded-lg hover:bg-gray-200 transition-colors\"\n >\n \n \n

\n \n

\n \n \n

\n \n {/* Weekly average nutrition */}\n {nutritionData && nutritionGoals && (\n

Weekly Average

\n {[\n { key: 'calories', label: 'Calories', unit: 'kcal', goalKey: 'primaryGoalType' },\n { key: 'protein', label: 'Protein', unit: 'g', goalKey: 'subGoal1Type' },\n { key: 'carbs', label: 'Carbs', unit: 'g', goalKey: 'subGoal2Type' },\n { key: 'fat', label: 'Fat', unit: 'g', goalKey: null },\n { key: 'fiber', label: 'Fiber', unit: 'g', goalKey: null },\n ].map(({ key, label, unit }) => {\n const value = nutritionData.weeklyAverage[key as keyof DailyNutrition];\n let goal: number | null = null;\n \n if (nutritionGoals.primaryGoalType === key) goal = nutritionGoals.primaryGoalValue;\n else if (nutritionGoals.subGoal1Type === key) goal = nutritionGoals.subGoal1Value;\n else if (nutritionGoals.subGoal2Type === key) goal = nutritionGoals.subGoal2Value;\n \n return (\n

\n {Math.round(value)}\n {unit}\n

{label}

\n {goal && (\n

\n \n

of {goal}

\n )}\n

\n );\n })}\n

\n )}\n

\n \n {/* Calendar grid */}\n

\n {/* Day headers */}\n

\n {DAY_NAMES.map((day, i) => (\n

{day}

{formatDate(currentWeek, i)}

\n ))}\n

\n \n {/* Meal rows */}\n {MEAL_TYPES.map((mealType) => (\n

\n {MEAL_TYPE_LABELS[mealType]}\n

\n {[0, 1, 2, 3, 4, 5, 6].map((day) => {\n const entries = getEntriesForCell(day as DayOfWeek, mealType);\n const dayNutrition = nutritionData?.daily[day];\n \n return (\n \n {entries.length > 0 ? (\n

\n {entries.map((entry) => (\n \n

\n \n {entry.recipe?.title || 'Unknown'}\n \n handleRemoveMeal(entry.id)}\n className=\"opacity-0 group-hover/item:opacity-100 text-gray-400 hover:text-red-500 transition-all ml-1 flex-shrink-0\"\n >\n \n \n

\n {entry.recipe?.nutrition?.calories && (\n \n {entry.recipe.nutrition.calories} kcal\n \n )}\n

\n ))}\n

\n ) : (\n setShowAddMeal({ day: day as DayOfWeek, mealType })}\n className=\"w-full h-full min-h-[60px] flex items-center justify-center text-gray-400 hover:text-gray-600 transition-colors opacity-0 group-hover:opacity-100\"\n >\n \n \n )}\n \n {/* Add more button when has entries */}\n {entries.length > 0 && (\n setShowAddMeal({ day: day as DayOfWeek, mealType })}\n className=\"absolute bottom-1 right-1 p-1 rounded text-gray-400 hover:text-gray-600 hover:bg-gray-200 opacity-0 group-hover:opacity-100 transition-all\"\n >\n \n \n )}\n

\n );\n })}\n

\n ))}\n \n {/* Daily totals row */}\n {nutritionData && nutritionGoals && (\n

\n Daily Totals\n

\n {[0, 1, 2, 3, 4, 5, 6].map((day) => {\n const dayNutrition = nutritionData.daily[day];\n const primaryGoal = nutritionGoals.primaryGoalValue;\n const progress = getNutritionProgress(dayNutrition.calories, primaryGoal);\n \n return (\n

\n {Math.round(dayNutrition.calories)} kcal\n

\n \n

\n );\n })}\n

\n )}\n

\n \n \n {/* Add meal modal */}\n {showAddMeal && (\n

setShowAddMeal(null)}>\n

e.stopPropagation()}>\n

\n Add {MEAL_TYPE_LABELS[showAddMeal.mealType]} - {DAY_NAMES[showAddMeal.day]}\n

\n {recipes.length === 0 ? (\n

\n No recipes yet. Create a recipe first.\n

\n ) : (\n

\n {recipes.map((recipe) => (\n handleAddMeal(recipe.id)}\n className=\"w-full p-3 text-left rounded-lg hover:bg-gray-50 transition-colors flex items-center justify-between\"\n >\n

{recipe.title}

\n {recipe.nutrition?.calories && (\n

\n {recipe.nutrition.calories} kcal per serving\n

\n )}\n

\n \n \n ))}\n

\n )}\n

\n \n

\n )}\n \n {/* Schedule meals modal */}\n {showSchedule && (\n

setShowSchedule(false)}>\n

e.stopPropagation()}>\n

Schedule Meals

Add a recipe to multiple days at once

\n {/* Recipe selection */}\n

\n Recipe\n setScheduleRecipe(e.target.value)}\n className=\"input\"\n >\n \n {recipes.map((recipe) => (\n \n ))}\n \n

\n \n {/* Meal type */}\n

\n Meal Type\n setScheduleMealType(e.target.value as MealType)}\n className=\"input\"\n >\n {MEAL_TYPES.map((type) => (\n \n ))}\n \n

\n \n {/* Days selection */}\n

\n Days\n

\n {DAY_NAMES.map((day, i) => (\n {\n if (scheduleDays.includes(i as DayOfWeek)) {\n setScheduleDays(scheduleDays.filter(d => d !== i));\n } else {\n setScheduleDays([...scheduleDays, i as DayOfWeek]);\n }\n }}\n className={`px-3 py-1.5 rounded-lg text-sm font-medium transition-colors ${\n scheduleDays.includes(i as DayOfWeek)\n ? 'text-white'\n : 'bg-gray-100 text-gray-700 hover:bg-gray-200'\n }`}\n style={scheduleDays.includes(i as DayOfWeek) ? { background: '#0f2763' } : {}}\n >\n {day.slice(0, 3)}\n \n ))}\n

\n setScheduleDays([0, 1, 2, 3, 4, 5, 6])}\n className=\"text-xs mt-2 hover:underline\"\n style={{ color: '#0f2763' }}\n >\n Select all (repeat daily)\n \n

\n \n \n Schedule\n \n

\n )}\n \n );\n}\n\n\n",[],[166,271,289],"b9001cec-d3a9-11f0-a755-42dde27851f2","Login.tsx","b9001dfa-d3a9-11f0-a755-42dde27851f2",17,["D",1765138635199],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\nexport function Login() {\n return (\n

\n {/* Logo and branding */}\n

\n \n

Carmy

Recipe Saver, Meal Planning & Nutrition

\n \n {/* Login card */}\n

Welcome back

\n \n \n \n Continue with Google\n \n \n

\n By signing in, you agree to our terms of service\n

\n \n {/* Features preview */}\n

\n 📖\n

Save Recipes

\n 🛒\n

Grocery Lists

\n 📅\n

Meal Planning

\n 💪\n

Track Nutrition

\n );\n}\n\n",[],[166,271,297],"0a9fe7e6-d3ad-11f0-a356-42dde27851f2","GroceryListsView.tsx","b8d2d002-d3a9-11f0-8e4b-42dde27851f2",35,["D",1765140060936],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { GroceryList, GroceryListItem, Recipe } from \"../../shared/types.ts\";\n\ninterface GroceryListsViewProps {\n lists: GroceryList[];\n recipes: Recipe[];\n onListsChange: () => Promise;\n}\n\nexport function GroceryListsView({ lists, recipes, onListsChange }: GroceryListsViewProps) {\n const [selectedList, setSelectedList] = useState(null);\n const [showNewListForm, setShowNewListForm] = useState(false);\n const [newListName, setNewListName] = useState('');\n const [showAddItem, setShowAddItem] = useState(false);\n const [newItemName, setNewItemName] = useState('');\n const [newItemAmount, setNewItemAmount] = useState(''); // Combined amount, e.g., \"2 cups\"\n const [showAddRecipe, setShowAddRecipe] = useState(false);\n\n // Group items by recipe\n const groupItemsByRecipe = (items: GroceryListItem[]) => {\n const groups: { recipeName: string | null; recipeId: string | null; items: GroceryListItem[] }[] = [];\n const individualItems: GroceryListItem[] = [];\n const recipeGroups: Map = new Map();\n\n for (const item of items) {\n if (item.recipeId && item.recipeName) {\n if (!recipeGroups.has(item.recipeId)) {\n recipeGroups.set(item.recipeId, []);\n }\n recipeGroups.get(item.recipeId)!.push(item);\n } else {\n individualItems.push(item);\n }\n }\n\n recipeGroups.forEach((items, recipeId) => {\n groups.push({\n recipeName: items[0].recipeName,\n recipeId,\n items,\n });\n });\n\n if (individualItems.length > 0) {\n groups.push({\n recipeName: null,\n recipeId: null,\n items: individualItems,\n });\n }\n\n return groups;\n };\n\n const handleCreateList = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!newListName.trim()) return;\n\n const response = await fetch('/api/grocery-lists', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ name: newListName.trim() }),\n });\n\n if (response.ok) {\n await onListsChange();\n setNewListName('');\n setShowNewListForm(false);\n }\n };\n\n const handleDeleteList = async (listId: string) => {\n const response = await fetch(`/api/grocery-lists/${listId}`, {\n method: 'DELETE',\n });\n\n if (response.ok) {\n await onListsChange();\n if (selectedList?.id === listId) {\n setSelectedList(null);\n }\n }\n };\n\n const handleAddItem = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!selectedList || !newItemName.trim()) return;\n\n const response = await fetch(`/api/grocery-lists/${selectedList.id}/items`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n name: newItemName.trim(),\n quantity: null, // Store combined amount in unit field\n unit: newItemAmount.trim() || null, // e.g., \"2 cups\"\n }),\n });\n\n if (response.ok) {\n await onListsChange();\n setNewItemName('');\n setNewItemAmount('');\n setShowAddItem(false);\n // Update selected list\n const updatedLists = await fetch('/api/grocery-lists').then(r => r.json());\n if (updatedLists.success) {\n const updated = updatedLists.data.find((l: GroceryList) => l.id === selectedList.id);\n if (updated) setSelectedList(updated);\n }\n }\n };\n\n const handleAddRecipeIngredients = async (recipeId: string) => {\n if (!selectedList) return;\n\n const response = await fetch(`/api/grocery-lists/${selectedList.id}/add-recipe`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ recipeId }),\n });\n\n if (response.ok) {\n await onListsChange();\n setShowAddRecipe(false);\n // Update selected list\n const updatedLists = await fetch('/api/grocery-lists').then(r => r.json());\n if (updatedLists.success) {\n const updated = updatedLists.data.find((l: GroceryList) => l.id === selectedList.id);\n if (updated) setSelectedList(updated);\n }\n }\n };\n\n const handleToggleItem = async (item: GroceryListItem) => {\n if (!selectedList) return;\n\n await fetch(`/api/grocery-lists/${selectedList.id}/items/${item.id}`, {\n method: 'PATCH',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ checked: !item.checked }),\n });\n\n // Optimistically update\n setSelectedList({\n ...selectedList,\n items: selectedList.items.map(i =>\n i.id === item.id ? { ...i, checked: !i.checked } : i\n ),\n });\n };\n\n const handleDeleteItem = async (itemId: string) => {\n if (!selectedList) return;\n\n await fetch(`/api/grocery-lists/${selectedList.id}/items/${itemId}`, {\n method: 'DELETE',\n });\n\n // Optimistically update\n setSelectedList({\n ...selectedList,\n items: selectedList.items.filter(i => i.id !== itemId),\n });\n };\n\n return (\n

\n {/* Sidebar - Lists */}\n

Grocery Lists

\n setShowNewListForm(true)}\n className=\"p-1 rounded hover:bg-gray-200 transition-colors\"\n style={{ color: '#0f2763' }}\n >\n \n \n

\n \n {showNewListForm && (\n

\n \n

\n {lists.length === 0 ? (\n

\n No lists yet. Create one to get started.\n

\n ) : (\n

\n {lists.map((list) => (\n setSelectedList(list)}\n >\n

{list.name}

\n {list.items.length} item{list.items.length !== 1 ? 's' : ''}\n

\n {\n e.stopPropagation();\n handleDeleteList(list.id);\n }}\n className=\"opacity-0 group-hover:opacity-100 p-1 text-gray-400 hover:text-red-500 transition-all\"\n >\n \n \n

\n ))}\n

\n )}\n

\n \n {/* Main content - List details */}\n

\n {selectedList ? (\n <>\n {/* Header */}\n

{selectedList.name}

\n {selectedList.items.filter(i => i.checked).length} of {selectedList.items.length} checked\n

\n setShowAddItem(true)}\n className=\"btn-secondary text-sm flex items-center gap-1\"\n >\n \n Add Item\n \n setShowAddRecipe(true)}\n className=\"btn-primary text-sm flex items-center gap-1\"\n >\n \n Add Recipe\n \n

\n \n {/* Items */}\n

\n {selectedList.items.length === 0 ? (\n

\n 🛒\n

No items yet

Add items or import from a recipe

\n ) : (\n

\n {groupItemsByRecipe(selectedList.items).map((group, groupIndex) => (\n

\n {group.recipeName ? (\n <>\n \n From: {group.recipeName}\n \n \n ) : (\n Individual Items\n )}\n

\n {group.items.map((item) => (\n \n handleToggleItem(item)}\n className={`checkbox ${item.checked ? 'checked' : ''}`}\n >\n {item.checked && (\n \n )}\n \n

\n {item.unit && {item.unit} }\n {item.name}\n

\n handleDeleteItem(item.id)}\n className=\"text-gray-400 hover:text-red-500 transition-colors\"\n >\n \n \n

\n ))}\n

\n )}\n

\n \n ) : (\n

\n 👈\n

Select a list to view items

\n )}\n \n \n {/* Add item modal */}\n {showAddItem && selectedList && (\n

setShowAddItem(false)}>\n

e.stopPropagation()}>\n

Add Item

\n \n

\n )}\n \n {/* Add recipe modal */}\n {showAddRecipe && selectedList && (\n

setShowAddRecipe(false)}>\n

e.stopPropagation()}>\n

Add Recipe Ingredients

Select a recipe to add all its ingredients

\n {recipes.length === 0 ? (\n

\n No recipes yet. Create a recipe first.\n

\n ) : (\n

\n {recipes.map((recipe) => (\n handleAddRecipeIngredients(recipe.id)}\n className=\"w-full p-3 text-left rounded-lg hover:bg-gray-50 transition-colors flex items-center justify-between\"\n >\n

{recipe.title}

\n {recipe.ingredients.length} ingredients\n

\n \n \n ))}\n

\n )}\n

\n \n

\n )}\n \n );\n}\n\n",[],[166,271,305],"ea8ce6ec-d8b2-11f0-b955-42dde27851f2","App.tsx","b8d991d0-d3a9-11f0-8d63-42dde27851f2",38,["D",1765692339898],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Recipe, GroceryList, NutritionGoals } from \"../../shared/types.ts\";\nimport { Login } from \"./Login.tsx\";\nimport { RecipesView } from \"./RecipesView.tsx\";\nimport { GroceryListsView } from \"./GroceryListsView.tsx\";\nimport { MealPlanView } from \"./MealPlanView.tsx\";\nimport { NutritionView } from \"./NutritionView.tsx\";\n\ntype Tab = 'recipes' | 'grocery' | 'mealplan' | 'nutrition';\n\nexport function App() {\n const [user, setUser] = useState(undefined);\n const [activeTab, setActiveTab] = useState('recipes');\n const [recipes, setRecipes] = useState([]);\n const [groceryLists, setGroceryLists] = useState([]);\n const [nutritionGoals, setNutritionGoals] = useState(null);\n const [loading, setLoading] = useState(true);\n\n // Fetch current user\n const fetchUser = useCallback(async () => {\n try {\n const response = await fetch('/api/auth/me');\n const data = await response.json();\n if (data.success) {\n setUser(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch user:', err);\n setUser(null);\n }\n }, []);\n\n // Fetch recipes\n const fetchRecipes = useCallback(async () => {\n try {\n const response = await fetch('/api/recipes');\n const data = await response.json();\n if (data.success) {\n setRecipes(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch recipes:', err);\n }\n }, []);\n\n // Fetch grocery lists\n const fetchGroceryLists = useCallback(async () => {\n try {\n const response = await fetch('/api/grocery-lists');\n const data = await response.json();\n if (data.success) {\n setGroceryLists(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch grocery lists:', err);\n }\n }, []);\n\n // Fetch nutrition goals\n const fetchNutritionGoals = useCallback(async () => {\n try {\n const response = await fetch('/api/nutrition/goals');\n const data = await response.json();\n if (data.success) {\n setNutritionGoals(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch nutrition goals:', err);\n }\n }, []);\n\n // Initial load\n useEffect(() => {\n fetchUser();\n }, [fetchUser]);\n\n // Fetch data when user is authenticated\n useEffect(() => {\n if (user) {\n setLoading(true);\n Promise.all([\n fetchRecipes(),\n fetchGroceryLists(),\n fetchNutritionGoals(),\n ]).finally(() => {\n setLoading(false);\n });\n } else if (user === null) {\n setLoading(false);\n }\n }, [user, fetchRecipes, fetchGroceryLists, fetchNutritionGoals]);\n\n const handleLogout = async () => {\n try {\n await fetch('/api/auth/logout', { method: 'POST' });\n setUser(null);\n setRecipes([]);\n setGroceryLists([]);\n setNutritionGoals(null);\n } catch (err) {\n console.error('Failed to logout:', err);\n }\n };\n\n // Show loading while checking auth\n if (user === undefined) {\n return (\n

\n );\n }\n\n // Show login if not authenticated\n if (user === null) {\n return ;\n }\n\n // Loading data\n if (loading) {\n return (\n

\n Loading your data...\n

\n );\n }\n\n const tabs: { id: Tab; label: string; icon: string }[] = [\n { id: 'recipes', label: 'Recipes', icon: '📖' },\n { id: 'grocery', label: 'Grocery Lists', icon: '🛒' },\n { id: 'mealplan', label: 'Meal Plan', icon: '📅' },\n { id: 'nutrition', label: 'Nutrition', icon: '💪' },\n ];\n\n return (\n

\n {/* Header */}\n

\n {/* Logo */}\n

\n \n

\n Carmy\n

\n \n {/* User menu */}\n

\n {user.picture ? (\n $\"\"$ \n ) : (\n

\n {user.name?.charAt(0).toUpperCase() || user.email.charAt(0).toUpperCase()}\n

\n )}\n \n

\n \n Sign out\n \n

\n \n {/* Tab navigation */}\n

\n \n

\n \n {/* Main content */}\n

\n {activeTab === 'recipes' && (\n \n )}\n {activeTab === 'grocery' && (\n \n )}\n {activeTab === 'mealplan' && (\n \n )}\n {activeTab === 'nutrition' && (\n \n )}\n

\n );\n}\n\n\n",[],[166,271,313],"b86d0600-d3a9-11f0-b1e3-42dde27851f2",4,["D",1765138634552],[202,203,204,205,206,207,208],[166,271],["D",1765138634122],[201,209,210,211],[166],"2e8da884-d3ab-11f0-b900-42dde27851f2","index.ts",31,["D",1765139262230],"http","import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { authRoutes } from \"./routes/auth.ts\";\nimport { recipesRoutes } from \"./routes/recipes.ts\";\nimport { groceryListsRoutes } from \"./routes/grocery-lists.ts\";\nimport { mealPlansRoutes } from \"./routes/meal-plans.ts\";\nimport { nutritionRoutes } from \"./routes/nutrition.ts\";\nimport { sessionMiddleware } from \"./middleware/session.ts\";\n\nconst app = new Hono();\n\n// Run migrations on startup\nawait runMigrations();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error('Error:', err);\n if (err.message === 'Unauthorized') {\n return c.json({ success: false, error: 'Unauthorized' }, 401);\n }\n throw err;\n});\n\n// Apply session middleware to all routes\napp.use('*', sessionMiddleware);\n\n// API routes\napp.route('/api/auth', authRoutes);\napp.route('/api/recipes', recipesRoutes);\napp.route('/api/grocery-lists', groceryListsRoutes);\napp.route('/api/meal-plans', mealPlansRoutes);\napp.route('/api/nutrition', nutritionRoutes);\n\n// Serve static files from 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// Serve index.html for root route\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Serve favicon\napp.get(\"/favicon.svg\", c => serveFile(\"/frontend/favicon.svg\", import.meta.url));\n\n// This is the entry point for HTTP vals\nexport default app.fetch;\n\n",[],[172,329],"b91ae9dc-d3a9-11f0-897f-42dde27851f2","recipes.ts","b91aea68-d3a9-11f0-897f-42dde27851f2","b8ad56f6-d3a9-11f0-8e4b-42dde27851f2",23,["D",1765138635693],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getRecipesByUser,\n getRecipeById,\n createRecipe,\n updateRecipe,\n deleteRecipe,\n duplicateRecipe,\n} from \"../database/queries.ts\";\nimport type { CreateRecipeRequest, UpdateRecipeRequest } from \"../../shared/types.ts\";\n\nconst recipesRoutes = new Hono();\n\n// Get all recipes for user\nrecipesRoutes.get('/', async (c) => {\n const user = requireAuth(c);\n const recipes = await getRecipesByUser(user.id);\n return c.json({ success: true, data: recipes });\n});\n\n// Get single recipe\nrecipesRoutes.get('/:id', async (c) => {\n const user = requireAuth(c);\n const recipeId = c.req.param('id');\n \n const recipe = await getRecipeById(recipeId, user.id);\n \n if (!recipe) {\n return c.json({ success: false, error: 'Recipe not found' }, 404);\n }\n \n return c.json({ success: true, data: recipe });\n});\n\n// Create new recipe\nrecipesRoutes.post('/', async (c) => {\n const user = requireAuth(c);\n const body: CreateRecipeRequest = await c.req.json();\n \n if (!body.title) {\n return c.json({ success: false, error: 'Title is required' }, 400);\n }\n \n const recipe = await createRecipe(\n user.id,\n body.title,\n body.url ?? null,\n body.instructions ?? null,\n body.servingSize || 1,\n body.ingredients || [],\n body.nutrition\n );\n \n return c.json({ success: true, data: recipe });\n});\n\n// Update recipe\nrecipesRoutes.patch('/:id', async (c) => {\n const user = requireAuth(c);\n const recipeId = c.req.param('id');\n const body: UpdateRecipeRequest = await c.req.json();\n \n const recipe = await updateRecipe(recipeId, user.id, {\n title: body.title,\n url: body.url,\n instructions: body.instructions,\n servingSize: body.servingSize,\n ingredients: body.ingredients,\n nutrition: body.nutrition,\n });\n \n if (!recipe) {\n return c.json({ success: false, error: 'Recipe not found' }, 404);\n }\n \n return c.json({ success: true, data: recipe });\n});\n\n// Delete recipe\nrecipesRoutes.delete('/:id', async (c) => {\n const user = requireAuth(c);\n const recipeId = c.req.param('id');\n \n const deleted = await deleteRecipe(recipeId, user.id);\n \n if (!deleted) {\n return c.json({ success: false, error: 'Recipe not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\n// Duplicate recipe\nrecipesRoutes.post('/:id/duplicate', async (c) => {\n const user = requireAuth(c);\n const recipeId = c.req.param('id');\n \n const recipe = await duplicateRecipe(recipeId, user.id);\n \n if (!recipe) {\n return c.json({ success: false, error: 'Recipe not found' }, 404);\n }\n \n return c.json({ success: true, data: recipe });\n});\n\nexport { recipesRoutes };\n\n",[],[172,345,337],"routes","b92223be-d3a9-11f0-893e-42dde27851f2","nutrition.ts","b92224d6-d3a9-11f0-893e-42dde27851f2",24,["D",1765138635735],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getNutritionGoals,\n setNutritionGoals,\n getMealPlan,\n} from \"../database/queries.ts\";\nimport type { UpdateNutritionGoalsRequest, DailyNutrition, NutritionGoalType } from \"../../shared/types.ts\";\n\nconst nutritionRoutes = new Hono();\n\n// Get nutrition goals\nnutritionRoutes.get('/goals', async (c) => {\n const user = requireAuth(c);\n const goals = await getNutritionGoals(user.id);\n return c.json({ success: true, data: goals });\n});\n\n// Set nutrition goals\nnutritionRoutes.post('/goals', async (c) => {\n const user = requireAuth(c);\n const body: UpdateNutritionGoalsRequest = await c.req.json();\n \n if (!body.primaryGoalType || body.primaryGoalValue === undefined) {\n return c.json({ success: false, error: 'Primary goal is required' }, 400);\n }\n \n const validTypes: NutritionGoalType[] = ['calories', 'protein', 'fiber', 'fat', 'carbs'];\n if (!validTypes.includes(body.primaryGoalType)) {\n return c.json({ success: false, error: 'Invalid goal type' }, 400);\n }\n \n const goals = await setNutritionGoals(\n user.id,\n body.primaryGoalType,\n body.primaryGoalValue,\n body.subGoal1Type ?? null,\n body.subGoal1Value ?? null,\n body.subGoal2Type ?? null,\n body.subGoal2Value ?? null\n );\n \n return c.json({ success: true, data: goals });\n});\n\n// Calculate daily nutrition for a week (for meal plan view)\nnutritionRoutes.get('/weekly', async (c) => {\n const user = requireAuth(c);\n const weekStartDate = c.req.query('weekStartDate');\n \n if (!weekStartDate) {\n return c.json({ success: false, error: 'weekStartDate is required' }, 400);\n }\n \n const mealPlan = await getMealPlan(user.id, weekStartDate);\n \n // Calculate daily totals\n const dailyNutrition: Record = {};\n \n for (let day = 0; day < 7; day++) {\n dailyNutrition[day] = { calories: 0, protein: 0, fiber: 0, fat: 0, carbs: 0 };\n }\n \n if (mealPlan) {\n for (const entry of mealPlan.entries) {\n if (entry.recipe?.nutrition) {\n const n = entry.recipe.nutrition;\n const servings = entry.servings;\n const day = entry.dayOfWeek;\n \n dailyNutrition[day].calories += (n.calories || 0) * servings;\n dailyNutrition[day].protein += (n.protein || 0) * servings;\n dailyNutrition[day].fiber += (n.fiber || 0) * servings;\n dailyNutrition[day].fat += (n.fat || 0) * servings;\n dailyNutrition[day].carbs += (n.carbs || 0) * servings;\n }\n }\n }\n \n // Calculate weekly average\n const weeklyAverage: DailyNutrition = {\n calories: 0,\n protein: 0,\n fiber: 0,\n fat: 0,\n carbs: 0,\n };\n \n let daysWithMeals = 0;\n for (let day = 0; day < 7; day++) {\n const d = dailyNutrition[day];\n if (d.calories > 0 || d.protein > 0 || d.fiber > 0 || d.fat > 0 || d.carbs > 0) {\n daysWithMeals++;\n weeklyAverage.calories += d.calories;\n weeklyAverage.protein += d.protein;\n weeklyAverage.fiber += d.fiber;\n weeklyAverage.fat += d.fat;\n weeklyAverage.carbs += d.carbs;\n }\n }\n \n if (daysWithMeals > 0) {\n weeklyAverage.calories /= daysWithMeals;\n weeklyAverage.protein /= daysWithMeals;\n weeklyAverage.fiber /= daysWithMeals;\n weeklyAverage.fat /= daysWithMeals;\n weeklyAverage.carbs /= daysWithMeals;\n }\n \n const goals = await getNutritionGoals(user.id);\n \n return c.json({\n success: true,\n data: {\n daily: dailyNutrition,\n weeklyAverage,\n goals,\n },\n });\n});\n\nexport { nutritionRoutes };\n\n",[],[172,345,347],"b9172630-d3a9-11f0-9cb5-42dde27851f2","meal-plans.ts","b91726c6-d3a9-11f0-9cb5-42dde27851f2",22,["D",1765138635656],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getMealPlan,\n getOrCreateMealPlan,\n addMealPlanEntry,\n deleteMealPlanEntry,\n scheduleMeals,\n} from \"../database/queries.ts\";\nimport type { AddMealPlanEntryRequest, ScheduleMealRequest } from \"../../shared/types.ts\";\n\nconst mealPlansRoutes = new Hono();\n\n// Get meal plan for a specific week\nmealPlansRoutes.get('/', async (c) => {\n const user = requireAuth(c);\n const weekStartDate = c.req.query('weekStartDate');\n \n if (!weekStartDate) {\n return c.json({ success: false, error: 'weekStartDate is required' }, 400);\n }\n \n const mealPlan = await getMealPlan(user.id, weekStartDate);\n \n // Return empty plan structure if none exists\n if (!mealPlan) {\n return c.json({ \n success: true, \n data: {\n id: null,\n userId: user.id,\n weekStartDate,\n entries: [],\n createdAt: null,\n updatedAt: null,\n }\n });\n }\n \n return c.json({ success: true, data: mealPlan });\n});\n\n// Add entry to meal plan\nmealPlansRoutes.post('/entries', async (c) => {\n const user = requireAuth(c);\n const body: AddMealPlanEntryRequest = await c.req.json();\n \n if (!body.weekStartDate || body.dayOfWeek === undefined || !body.mealType || !body.recipeId) {\n return c.json({ success: false, error: 'Missing required fields' }, 400);\n }\n \n const entry = await addMealPlanEntry(\n user.id,\n body.weekStartDate,\n body.dayOfWeek,\n body.mealType,\n body.recipeId,\n body.servings || 1\n );\n \n if (!entry) {\n return c.json({ success: false, error: 'Failed to add entry (recipe not found?)' }, 404);\n }\n \n return c.json({ success: true, data: entry });\n});\n\n// Schedule meals (add to multiple days)\nmealPlansRoutes.post('/schedule', async (c) => {\n const user = requireAuth(c);\n const body: ScheduleMealRequest = await c.req.json();\n \n if (!body.weekStartDate || !body.mealType || !body.recipeId || !body.days || body.days.length === 0) {\n return c.json({ success: false, error: 'Missing required fields' }, 400);\n }\n \n const entries = await scheduleMeals(\n user.id,\n body.weekStartDate,\n body.recipeId,\n body.mealType,\n body.days,\n body.servings || 1\n );\n \n return c.json({ success: true, data: entries });\n});\n\n// Delete meal plan entry\nmealPlansRoutes.delete('/entries/:id', async (c) => {\n const user = requireAuth(c);\n const entryId = c.req.param('id');\n \n const deleted = await deleteMealPlanEntry(entryId, user.id);\n \n if (!deleted) {\n return c.json({ success: false, error: 'Entry not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\nexport { mealPlansRoutes };\n\n",[],[172,345,355],"b95a4456-d3a9-11f0-897f-42dde27851f2","grocery-lists.ts","b95a451e-d3a9-11f0-897f-42dde27851f2",30,["D",1765138635780],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getGroceryListsByUser,\n getGroceryListById,\n createGroceryList,\n updateGroceryList,\n deleteGroceryList,\n addGroceryItem,\n addRecipeIngredientsToList,\n updateGroceryItemChecked,\n deleteGroceryItem,\n} from \"../database/queries.ts\";\nimport type { CreateGroceryListRequest, AddGroceryItemRequest, AddRecipeIngredientsRequest } from \"../../shared/types.ts\";\n\nconst groceryListsRoutes = new Hono();\n\n// Get all grocery lists\ngroceryListsRoutes.get('/', async (c) => {\n const user = requireAuth(c);\n const lists = await getGroceryListsByUser(user.id);\n return c.json({ success: true, data: lists });\n});\n\n// Get single grocery list\ngroceryListsRoutes.get('/:id', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('id');\n \n const list = await getGroceryListById(listId, user.id);\n \n if (!list) {\n return c.json({ success: false, error: 'List not found' }, 404);\n }\n \n return c.json({ success: true, data: list });\n});\n\n// Create new grocery list\ngroceryListsRoutes.post('/', async (c) => {\n const user = requireAuth(c);\n const body: CreateGroceryListRequest = await c.req.json();\n \n if (!body.name) {\n return c.json({ success: false, error: 'Name is required' }, 400);\n }\n \n const list = await createGroceryList(user.id, body.name);\n return c.json({ success: true, data: list });\n});\n\n// Update grocery list name\ngroceryListsRoutes.patch('/:id', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('id');\n const body: { name: string } = await c.req.json();\n \n if (!body.name) {\n return c.json({ success: false, error: 'Name is required' }, 400);\n }\n \n const list = await updateGroceryList(listId, user.id, body.name);\n \n if (!list) {\n return c.json({ success: false, error: 'List not found' }, 404);\n }\n \n return c.json({ success: true, data: list });\n});\n\n// Delete grocery list\ngroceryListsRoutes.delete('/:id', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('id');\n \n const deleted = await deleteGroceryList(listId, user.id);\n \n if (!deleted) {\n return c.json({ success: false, error: 'List not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\n// Add item to grocery list\ngroceryListsRoutes.post('/:id/items', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('id');\n const body: AddGroceryItemRequest = await c.req.json();\n \n if (!body.name) {\n return c.json({ success: false, error: 'Name is required' }, 400);\n }\n \n const item = await addGroceryItem(\n listId,\n user.id,\n body.name,\n body.quantity ?? null,\n body.unit ?? null\n );\n \n if (!item) {\n return c.json({ success: false, error: 'List not found' }, 404);\n }\n \n return c.json({ success: true, data: item });\n});\n\n// Add recipe ingredients to grocery list\ngroceryListsRoutes.post('/:id/add-recipe', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('id');\n const body: AddRecipeIngredientsRequest = await c.req.json();\n \n if (!body.recipeId) {\n return c.json({ success: false, error: 'Recipe ID is required' }, 400);\n }\n \n const items = await addRecipeIngredientsToList(listId, user.id, body.recipeId);\n \n return c.json({ success: true, data: items });\n});\n\n// Update item checked status\ngroceryListsRoutes.patch('/:listId/items/:itemId', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('listId');\n const itemId = c.req.param('itemId');\n const body: { checked: boolean } = await c.req.json();\n \n const updated = await updateGroceryItemChecked(itemId, listId, user.id, body.checked);\n \n if (!updated) {\n return c.json({ success: false, error: 'Item not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\n// Delete item from grocery list\ngroceryListsRoutes.delete('/:listId/items/:itemId', async (c) => {\n const user = requireAuth(c);\n const listId = c.req.param('listId');\n const itemId = c.req.param('itemId');\n \n const deleted = await deleteGroceryItem(itemId, listId, user.id);\n \n if (!deleted) {\n return c.json({ success: false, error: 'Item not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\nexport { groceryListsRoutes };\n\n",[],[172,345,363],"b928cf8e-d3a9-11f0-9cb5-42dde27851f2","auth.ts","b928d074-d3a9-11f0-9cb5-42dde27851f2",25,["D",1765138635766],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { getCookie, setCookie, deleteCookie } from \"https://esm.sh/hono@4.4.2/cookie\";\nimport { createOrUpdateUser, createSession, deleteSession, getSessionUser } from \"../database/queries.ts\";\n\nconst authRoutes = new Hono();\n\n// Get Google OAuth credentials\nfunction getGoogleCredentials() {\n const clientId = Deno.env.get('GOOGLE_CLIENT_ID');\n const clientSecret = Deno.env.get('GOOGLE_CLIENT_SECRET');\n \n if (!clientId || !clientSecret) {\n throw new Error('Google OAuth credentials not configured');\n }\n \n return { clientId, clientSecret };\n}\n\n// Get the app's base URL for OAuth callbacks\nfunction getBaseUrl(c: { req: { url: string } }): string {\n const url = new URL(c.req.url);\n return `${url.protocol}//${url.host}`;\n}\n\n// Google OAuth: Redirect to Google authorization\nauthRoutes.get('/google', (c) => {\n const { clientId } = getGoogleCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/google/callback`;\n \n const params = new URLSearchParams({\n client_id: clientId,\n redirect_uri: redirectUri,\n response_type: 'code',\n scope: 'openid email profile',\n access_type: 'offline',\n prompt: 'consent',\n });\n \n const authUrl = `https://accounts.google.com/o/oauth2/v2/auth?${params}`;\n \n return new Response(null, {\n status: 302,\n headers: { Location: authUrl },\n });\n});\n\n// Google OAuth: Handle callback\nauthRoutes.get('/google/callback', async (c) => {\n const code = c.req.query('code');\n const error = c.req.query('error');\n \n if (error) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=google_auth_denied' },\n });\n }\n \n if (!code) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=missing_code' },\n });\n }\n \n const { clientId, clientSecret } = getGoogleCredentials();\n const baseUrl = getBaseUrl(c);\n const redirectUri = `${baseUrl}/api/auth/google/callback`;\n \n // Exchange code for tokens\n const tokenResponse = await fetch('https://oauth2.googleapis.com/token', {\n method: 'POST',\n headers: { 'Content-Type': 'application/x-www-form-urlencoded' },\n body: new URLSearchParams({\n client_id: clientId,\n client_secret: clientSecret,\n code,\n redirect_uri: redirectUri,\n grant_type: 'authorization_code',\n }),\n });\n \n if (!tokenResponse.ok) {\n const errorText = await tokenResponse.text();\n console.error('Google token exchange failed:', errorText);\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=token_exchange_failed' },\n });\n }\n \n const tokenData = await tokenResponse.json();\n const accessToken = tokenData.access_token;\n \n // Fetch user info from Google\n const userInfoResponse = await fetch('https://www.googleapis.com/oauth2/v2/userinfo', {\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n },\n });\n \n if (!userInfoResponse.ok) {\n return new Response(null, {\n status: 302,\n headers: { Location: '/?error=user_fetch_failed' },\n });\n }\n \n const userInfo = await userInfoResponse.json();\n \n // Create or update user in database\n const user = await createOrUpdateUser(\n userInfo.email,\n userInfo.name || null,\n userInfo.picture || null\n );\n \n // Create session\n const sessionId = await createSession(user.id);\n \n // Set session cookie and redirect\n setCookie(c, 'session', sessionId, {\n path: '/',\n httpOnly: true,\n secure: true,\n sameSite: 'Lax',\n maxAge: 30 * 24 * 60 * 60, // 30 days\n });\n \n return new Response(null, {\n status: 302,\n headers: { \n Location: '/',\n 'Set-Cookie': `session=${sessionId}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=${30 * 24 * 60 * 60}`,\n },\n });\n});\n\n// Get current user info\nauthRoutes.get('/me', async (c) => {\n const sessionId = getCookie(c, 'session');\n \n if (!sessionId) {\n return c.json({ success: true, data: null });\n }\n \n const user = await getSessionUser(sessionId);\n \n if (!user) {\n return c.json({ success: true, data: null });\n }\n \n return c.json({\n success: true,\n data: user,\n });\n});\n\n// Logout\nauthRoutes.post('/logout', async (c) => {\n const sessionId = getCookie(c, 'session');\n \n if (sessionId) {\n await deleteSession(sessionId);\n deleteCookie(c, 'session', { path: '/' });\n }\n \n return c.json({ success: true });\n});\n\nexport { authRoutes };\n\n",[],[172,345,371],"b8ad561a-d3a9-11f0-8e4b-42dde27851f2",7,["D",1765138634968],[194,195,196,197,198],[172,345],"eab7920c-d8b2-11f0-ab60-42dde27851f2","session.ts","b9030f74-d3a9-11f0-b1e3-42dde27851f2","b882c990-d3a9-11f0-8004-42dde27851f2",43,["D",1765692340210],"import { getCookie } from \"https://esm.sh/hono@4.4.2/cookie\";\nimport { getSessionUser } from \"../database/queries.ts\";\nimport type { User } from \"../../shared/types.ts\";\n\n// Extend Hono context with user\ndeclare module \"https://esm.sh/hono@4.4.2\" {\n interface ContextVariableMap {\n user: User | null;\n }\n}\n\nexport async function sessionMiddleware(c: any, next: () => Promise) {\n const sessionId = getCookie(c, 'session');\n \n if (sessionId) {\n const user = await getSessionUser(sessionId);\n c.set('user', user);\n } else {\n c.set('user', null);\n }\n \n await next();\n}\n\n// Helper to require authentication\nexport function requireAuth(c: any): User {\n const user = c.get('user');\n if (!user) {\n throw new Error('Unauthorized');\n }\n return user;\n}\n\n\n",[],[172,392,384],"middleware","b882c86e-d3a9-11f0-8004-42dde27851f2",5,["D",1765138634693],[192],[172,392],"eac5b6d4-d8b2-11f0-b955-42dde27851f2","b896776a-d3a9-11f0-8e4b-42dde27851f2",["D",1765692340298],[],[172,403,33],"database","b92d13fa-d3a9-11f0-9955-42dde27851f2","migrations.ts","b92d14ae-d3a9-11f0-9955-42dde27851f2",26,["D",1765138635774],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - versioned for schema changes\nexport const USERS_TABLE = 'carmy_users_v1';\nexport const SESSIONS_TABLE = 'carmy_sessions_v1';\nexport const RECIPES_TABLE = 'carmy_recipes_v1';\nexport const RECIPE_INGREDIENTS_TABLE = 'carmy_recipe_ingredients_v1';\nexport const RECIPE_NUTRITION_TABLE = 'carmy_recipe_nutrition_v1';\nexport const GROCERY_LISTS_TABLE = 'carmy_grocery_lists_v1';\nexport const GROCERY_LIST_ITEMS_TABLE = 'carmy_grocery_list_items_v1';\nexport const NUTRITION_GOALS_TABLE = 'carmy_nutrition_goals_v1';\nexport const MEAL_PLANS_TABLE = 'carmy_meal_plans_v1';\nexport const MEAL_PLAN_ENTRIES_TABLE = 'carmy_meal_plan_entries_v1';\n\nexport async function runMigrations() {\n // Users table (Google OAuth)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL UNIQUE,\n name TEXT,\n picture TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Sessions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SESSIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n expires_at TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SESSIONS_TABLE}_user_id \n ON ${SESSIONS_TABLE}(user_id)\n `);\n\n // Recipes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n title TEXT NOT NULL,\n url TEXT,\n instructions TEXT,\n serving_size INTEGER NOT NULL DEFAULT 1,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPES_TABLE}_user_id \n ON ${RECIPES_TABLE}(user_id)\n `);\n\n // Recipe ingredients table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL,\n name TEXT NOT NULL,\n amount REAL,\n unit TEXT,\n order_index INTEGER NOT NULL DEFAULT 0,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPE_INGREDIENTS_TABLE}_recipe_id \n ON ${RECIPE_INGREDIENTS_TABLE}(recipe_id)\n `);\n\n // Recipe nutrition table (per serving)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_NUTRITION_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL UNIQUE,\n calories REAL,\n protein REAL,\n fiber REAL,\n fat REAL,\n carbs REAL,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Grocery lists table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LISTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LISTS_TABLE}_user_id \n ON ${GROCERY_LISTS_TABLE}(user_id)\n `);\n\n // Grocery list items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LIST_ITEMS_TABLE} (\n id TEXT PRIMARY KEY,\n list_id TEXT NOT NULL,\n name TEXT NOT NULL,\n quantity REAL,\n unit TEXT,\n recipe_id TEXT,\n recipe_name TEXT,\n checked INTEGER NOT NULL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (list_id) REFERENCES ${GROCERY_LISTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LIST_ITEMS_TABLE}_list_id \n ON ${GROCERY_LIST_ITEMS_TABLE}(list_id)\n `);\n\n // Nutrition goals table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${NUTRITION_GOALS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL UNIQUE,\n primary_goal_type TEXT NOT NULL,\n primary_goal_value REAL NOT NULL,\n sub_goal_1_type TEXT,\n sub_goal_1_value REAL,\n sub_goal_2_type TEXT,\n sub_goal_2_value REAL,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Meal plans table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLANS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n week_start_date TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, week_start_date)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLANS_TABLE}_user_week \n ON ${MEAL_PLANS_TABLE}(user_id, week_start_date)\n `);\n\n // Meal plan entries table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLAN_ENTRIES_TABLE} (\n id TEXT PRIMARY KEY,\n meal_plan_id TEXT NOT NULL,\n day_of_week INTEGER NOT NULL,\n meal_type TEXT NOT NULL,\n recipe_id TEXT NOT NULL,\n servings REAL NOT NULL DEFAULT 1,\n FOREIGN KEY (meal_plan_id) REFERENCES ${MEAL_PLANS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLAN_ENTRIES_TABLE}_meal_plan_id \n ON ${MEAL_PLAN_ENTRIES_TABLE}(meal_plan_id)\n `);\n\n console.log('Carmy migrations complete');\n}\n\n",[],[172,403,405],"b89676ac-d3a9-11f0-8e4b-42dde27851f2",6,["D",1765138634821],[189,190],[172,403],["D",1765138634257],[188,191,193,199],[172],["D",1765137234131],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_124":457,"_458":459,"_460":461,"_462":25,"_463":25,"_464":25,"_465":60,"_466":-5,"_467":-7,"_468":-7,"_469":64,"_470":25,"_471":25,"_472":-5,"_473":25,"_474":25,"_475":25,"_476":-5},"ENV",{"_428":429,"_430":431,"_432":88,"_433":434,"_435":436,"_437":438,"_439":440,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v44