= {\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\n",[],[158,229],["D",1765138634405],[214],[158],"1d2c03a8-da34-11f0-a8c1-42dde27851f2","index.tsx","b8cb9256-d3a9-11f0-ba80-42dde27851f2",69,["D",1765857781098],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();\n\n\n\n",[],[165,241],"1d30355e-da34-11f0-9620-42dde27851f2","index.html","b8d03d1a-d3a9-11f0-8004-42dde27851f2",70,["D",1765857781121],"\n\n\n \n \n Carmy - Recipe & Meal Planning\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

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

\n Loading saved URLs...\n

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

\n {/* Header */}\n

\n Recipe Scraper Evaluation\n

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

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

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

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

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

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

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

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

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

\n )}\n

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

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

\n Loading...\n

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

\n ❌\n Error\n

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

\n                                  {summary.text}\n

\n )}\n

\n ) : (\n

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

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

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

\n {cellExpanded && (\n

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

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

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

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

Name:

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

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

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

\n •{ing}\n

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

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

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

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

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

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

\n ) : (\n

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

\n )}\n

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

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

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

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

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

🔍

No recipe URLs saved yet

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

\n )}\n

\n );\n}\n",[],[165,270,261],"components","1d3e9cd4-da34-11f0-8bb0-42dde27851f2","RecipesView.tsx","b8e58968-d3a9-11f0-a23f-42dde27851f2",72,["D",1765857781210],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest, ParsedRecipeFromUrl } 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 const [showImportModal, setShowImportModal] = useState(false);\n const [importUrl, setImportUrl] = useState('');\n const [importLoading, setImportLoading] = useState(false);\n const [importError, setImportError] = useState(null);\n const [importedRecipe, setImportedRecipe] = useState(null);\n\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 const handleImportFromUrl = async () => {\n if (!importUrl.trim()) return;\n \n setImportLoading(true);\n setImportError(null);\n \n try {\n const response = await fetch('/api/recipes/parse-url', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ url: importUrl.trim() }),\n });\n \n const result = await response.json();\n \n if (!result.success) {\n setImportError(result.error || 'Failed to import recipe');\n return;\n }\n \n // Close import modal and open recipe form with imported data\n setImportedRecipe(result.data);\n setShowImportModal(false);\n setImportUrl('');\n setShowForm(true);\n } catch (error) {\n setImportError('Failed to import recipe. Please check the URL and try again.');\n } finally {\n setImportLoading(false);\n }\n };\n\n const handleCloseForm = () => {\n setShowForm(false);\n setImportedRecipe(null);\n };\n\n return (\n

\n {/* Header */}\n

Recipes

{recipes.length} recipes saved

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

\n \n {/* 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
\n \n {ing.unit && {ing.unit} }\n {ing.name}\n \n {ing.notes && (\n ({ing.notes})\n )}\n
\n

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

Instructions

{recipe.instructions}

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

Nutrition (per serving)

{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 {/* Import from URL modal */}\n {showImportModal && (\n

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

Import from URL

\n setShowImportModal(false)}\n className=\"text-gray-400 hover:text-gray-600 transition-colors\"\n >\n \n \n

\n \n

\n Paste a recipe URL to automatically extract ingredients, instructions, and nutrition info.\n

\n \n setImportUrl(e.target.value)}\n placeholder=\"https://www.example.com/recipe/...\"\n className=\"input w-full mb-4\"\n disabled={importLoading}\n onKeyDown={(e) => {\n if (e.key === 'Enter' && !importLoading) {\n handleImportFromUrl();\n }\n }}\n />\n \n {importError && (\n

\n {importError}\n

\n )}\n \n

\n setShowImportModal(false)}\n className=\"btn-secondary flex-1\"\n disabled={importLoading}\n >\n Cancel\n \n \n {importLoading ? (\n <>\n \n Importing...\n \n ) : (\n 'Import'\n )}\n \n

\n \n )}\n \n {/* Create recipe modal */}\n {showForm && (\n \n )}\n \n {/* Edit recipe modal */}\n {editingRecipe && (\n setEditingRecipe(null)}\n />\n )}\n \n );\n}\n\n",[],[165,270,272],"1d4ae2be-da34-11f0-9620-42dde27851f2","RecipeForm.tsx","b8ea08ee-d3a9-11f0-8d63-42dde27851f2",73,["D",1765857781298],4,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest, ParsedRecipeFromUrl } 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 notes: string; // Additional notes (e.g., \"sifted\", \"divided\")\n}\n\ninterface RecipeFormProps {\n recipe?: Recipe;\n importedRecipe?: ParsedRecipeFromUrl | null;\n onSubmit: (data: CreateRecipeRequest) => Promise;\n onClose: () => void;\n}\n\n// Helper to initialize form state from either recipe or importedRecipe\nfunction getInitialIngredients(recipe?: Recipe, importedRecipe?: ParsedRecipeFromUrl | null): Ingredient[] {\n if (importedRecipe?.ingredients?.length) {\n return importedRecipe.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 notes: i.notes || '',\n }));\n }\n if (recipe?.ingredients?.length) {\n return 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 notes: i.notes || '',\n }));\n }\n return [{ amount: '', name: '', notes: '' }];\n}\n\nexport function RecipeForm({ recipe, importedRecipe, onSubmit, onClose }: RecipeFormProps) {\n const [title, setTitle] = useState(importedRecipe?.title || recipe?.title || '');\n const [url, setUrl] = useState(importedRecipe?.url || recipe?.url || '');\n const [servingSize, setServingSize] = useState(\n importedRecipe?.servingSize?.toString() || recipe?.servingSize?.toString() || '1'\n );\n const [instructions, setInstructions] = useState(importedRecipe?.instructions || recipe?.instructions || '');\n const [ingredients, setIngredients] = useState(\n getInitialIngredients(recipe, importedRecipe)\n );\n \n // Determine initial nutrition state\n const initialNutrition = importedRecipe?.nutrition || recipe?.nutrition;\n const [showNutrition, setShowNutrition] = useState(!!initialNutrition);\n const [nutrition, setNutrition] = useState({\n calories: initialNutrition?.calories?.toString() || '',\n protein: initialNutrition?.protein?.toString() || '',\n carbs: initialNutrition?.carbs?.toString() || '',\n fat: initialNutrition?.fat?.toString() || '',\n fiber: initialNutrition?.fiber?.toString() || '',\n });\n const [submitting, setSubmitting] = useState(false);\n \n // Import from URL state\n const [showImportUrl, setShowImportUrl] = useState(false);\n const [importUrl, setImportUrl] = useState('');\n const [importLoading, setImportLoading] = useState(false);\n const [importError, setImportError] = useState(null);\n\n const addIngredient = () => {\n setIngredients([...ingredients, { amount: '', name: '', notes: '' }]);\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 handleImportFromUrl = async () => {\n if (!importUrl.trim()) return;\n \n setImportLoading(true);\n setImportError(null);\n \n try {\n const response = await fetch('/api/recipes/parse-url', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ url: importUrl.trim() }),\n });\n \n const result = await response.json();\n \n if (!result.success) {\n setImportError(result.error || 'Failed to import recipe');\n return;\n }\n \n const imported: ParsedRecipeFromUrl = result.data;\n \n // Update form fields with imported data\n setTitle(imported.title);\n setUrl(imported.url);\n setServingSize(imported.servingSize?.toString() || '1');\n setInstructions(imported.instructions || '');\n setIngredients(\n imported.ingredients.map(i => ({\n amount: [i.amount, i.unit].filter(Boolean).join(' ').trim(),\n name: i.name,\n notes: i.notes || '',\n }))\n );\n \n if (imported.nutrition) {\n setShowNutrition(true);\n setNutrition({\n calories: imported.nutrition.calories?.toString() || '',\n protein: imported.nutrition.protein?.toString() || '',\n carbs: imported.nutrition.carbs?.toString() || '',\n fat: imported.nutrition.fat?.toString() || '',\n fiber: imported.nutrition.fiber?.toString() || '',\n });\n }\n \n // Close import section\n setShowImportUrl(false);\n setImportUrl('');\n } catch (error) {\n setImportError('Failed to import recipe. Please check the URL and try again.');\n } finally {\n setImportLoading(false);\n }\n };\n\n const 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 notes: i.notes.trim() || null,\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 {/* Import from URL section - only show when not editing */}\n {!recipe && (\n

\n setShowImportUrl(!showImportUrl)}\n className=\"text-sm font-medium flex items-center gap-2 mb-2\"\n style={{ color: '#0f2763' }}\n >\n \n Import from URL\n \n \n {showImportUrl && (\n

\n Paste a recipe URL to auto-fill the form with ingredients and instructions.\n

\n setImportUrl(e.target.value)}\n placeholder=\"https://www.example.com/recipe/...\"\n className=\"input flex-1\"\n disabled={importLoading}\n onKeyDown={(e) => {\n if (e.key === 'Enter') {\n e.preventDefault();\n handleImportFromUrl();\n }\n }}\n />\n \n {importLoading ? (\n <>\n \n Importing...\n \n ) : (\n 'Import'\n )}\n \n

\n {importError && (\n

\n {importError}\n

\n )}\n

\n )}\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 style={{ minWidth: '120px' }}\n placeholder=\"Ingredient name\"\n />\n updateIngredient(index, 'notes', e.target.value)}\n className=\"input flex-shrink-0 text-sm text-gray-500\"\n style={{ width: '8rem', minWidth: '8rem' }}\n placeholder=\"Notes\"\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",[],[165,270,280],"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",[],[165,270,289],"587024da-d92b-11f0-a73c-42dde27851f2","MealPlanView.tsx","b9076826-d3a9-11f0-8004-42dde27851f2",68,["D",1765744063898],"/** @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 // Define all macronutrients\n const allMacros = [\n { key: 'calories', label: 'Calories', unit: 'kcal' },\n { key: 'protein', label: 'Protein', unit: 'g' },\n { key: 'carbs', label: 'Carbs', unit: 'g' },\n { key: 'fat', label: 'Fat', unit: 'g' },\n { key: 'fiber', label: 'Fiber', unit: 'g' },\n ];\n \n // Sort macros: ones with goals first, then others\n const sortedMacros = allMacros.sort((a, b) => {\n const aHasGoal = \n nutritionGoals.primaryGoalType === a.key ||\n nutritionGoals.subGoal1Type === a.key ||\n nutritionGoals.subGoal2Type === a.key;\n const bHasGoal = \n nutritionGoals.primaryGoalType === b.key ||\n nutritionGoals.subGoal1Type === b.key ||\n nutritionGoals.subGoal2Type === b.key;\n \n if (aHasGoal && !bHasGoal) return -1;\n if (!aHasGoal && bHasGoal) return 1;\n \n // If both have goals, prioritize by goal order (primary > sub1 > sub2)\n if (aHasGoal && bHasGoal) {\n const aPriority = \n nutritionGoals.primaryGoalType === a.key ? 1 :\n nutritionGoals.subGoal1Type === a.key ? 2 :\n nutritionGoals.subGoal2Type === a.key ? 3 : 99;\n const bPriority = \n nutritionGoals.primaryGoalType === b.key ? 1 :\n nutritionGoals.subGoal1Type === b.key ? 2 :\n nutritionGoals.subGoal2Type === b.key ? 3 : 99;\n return aPriority - bPriority;\n }\n \n return 0;\n });\n \n return (\n

Weekly Average

\n {sortedMacros.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 \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",[],[165,270,297],"1d3a30fe-da34-11f0-82ab-42dde27851f2","Login.tsx","b9001dfa-d3a9-11f0-a755-42dde27851f2",71,["D",1765857781116],"/** @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\n\n",[],[165,270,305],"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",[],[165,270,313],"08577e32-d91f-11f0-8bc1-42dde27851f2","App.tsx","b8d991d0-d3a9-11f0-8d63-42dde27851f2",56,["D",1765738775535],"/** @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\";\nimport { ScraperEvalView } from \"./ScraperEvalView.tsx\";\n\ntype Tab = 'recipes' | 'grocery' | 'mealplan' | 'nutrition' | 'scraper-eval';\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 { id: 'scraper-eval', label: 'Scraper Eval', 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 {activeTab === 'scraper-eval' && (\n \n )}\n

\n );\n}\n\n\n",[],[165,270,321],"b86d0600-d3a9-11f0-b1e3-42dde27851f2",["D",1765138634552],[202,203,204,205,206,207,208,209],[165,270],["D",1765138634122],[201,210,211,212],[165],"086d38f8-d91f-11f0-a23a-42dde27851f2","index.ts",58,["D",1765738775652],"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 { scraperEvalRoutes } from \"./routes/scraper-eval.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);\napp.route('/api/scraper-eval', scraperEvalRoutes);\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\n",[],[171,336],"8d1e60f2-d926-11f0-8373-42dde27851f2","scraper-eval.ts","085d9006-d91f-11f0-9791-42dde27851f2","b8ad56f6-d3a9-11f0-8e4b-42dde27851f2",63,["D",1765742004797],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getScraperEvalUrls,\n addScraperEvalUrl,\n addScraperEvalUrls,\n deleteScraperEvalUrl,\n deleteAllScraperEvalUrls,\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Scraper names for consistent reference\nconst SCRAPER_NAMES = [\n \"json-ld-native\",\n \"microdata-native\",\n \"html-recipe-parser\",\n \"schema-org-extractor\",\n] as const;\n\ntype ScraperName = typeof SCRAPER_NAMES[number];\n\ninterface ScraperResult {\n scraper: ScraperName;\n success: boolean;\n data?: any;\n error?: string;\n durationMs: number;\n}\n\ninterface UrlResult {\n url: string;\n results: ScraperResult[];\n}\n\n// Helper to fetch HTML with proper headers\nasync function fetchHtml(url: string): Promise {\n const response = await fetch(url, {\n headers: {\n \"User-Agent\": \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\",\n \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\",\n \"Accept-Language\": \"en-US,en;q=0.9\",\n },\n });\n if (!response.ok) {\n throw new Error(`HTTP ${response.status}: ${response.statusText}`);\n }\n return await response.text();\n}\n\n// Native JSON-LD parser - extracts schema.org Recipe from JSON-LD scripts\nfunction parseJsonLd(html: string, sourceUrl: string): any {\n const $ = cheerio.load(html);\n const scripts = $('script[type=\"application/ld+json\"]');\n \n for (let i = 0; i < scripts.length; i++) {\n try {\n const content = $(scripts[i]).html();\n if (!content) continue;\n \n const data = JSON.parse(content);\n const recipe = findRecipeInData(data);\n if (recipe) {\n return normalizeRecipe(recipe, sourceUrl);\n }\n } catch (e) {\n // Continue to next script\n }\n }\n \n throw new Error(\"No JSON-LD Recipe schema found\");\n}\n\n// Native Microdata parser - extracts schema.org Recipe from microdata attributes\nfunction parseMicrodata(html: string, sourceUrl: string): any {\n const $ = cheerio.load(html);\n \n // Look for itemtype=\"https://schema.org/Recipe\" or \"http://schema.org/Recipe\"\n const recipeElement = $('[itemtype*=\"schema.org/Recipe\"]').first();\n \n if (recipeElement.length === 0) {\n throw new Error(\"No Microdata Recipe schema found\");\n }\n \n const recipe: any = {\n \"@type\": \"Recipe\",\n sourceUrl,\n };\n \n // Extract itemprop values\n recipeElement.find('[itemprop]').each((_, el) => {\n const prop = $(el).attr('itemprop');\n if (!prop) return;\n \n let value: string | undefined;\n if ($(el).attr('content')) {\n value = $(el).attr('content');\n } else if ($(el).is('meta')) {\n value = $(el).attr('content');\n } else if ($(el).is('time')) {\n value = $(el).attr('datetime') || $(el).text().trim();\n } else if ($(el).is('img')) {\n value = $(el).attr('src');\n } else if ($(el).is('a')) {\n value = $(el).attr('href') || $(el).text().trim();\n } else {\n value = $(el).text().trim();\n }\n \n if (value) {\n // Handle arrays (ingredients, instructions)\n if (prop === 'recipeIngredient' || prop === 'ingredients') {\n if (!recipe.recipeIngredient) recipe.recipeIngredient = [];\n recipe.recipeIngredient.push(value);\n } else if (prop === 'recipeInstructions' || prop === 'instructions') {\n if (!recipe.recipeInstructions) recipe.recipeInstructions = [];\n recipe.recipeInstructions.push(value);\n } else {\n recipe[prop] = value;\n }\n }\n });\n \n return normalizeRecipe(recipe, sourceUrl);\n}\n\n// Schema.org extractor - combines multiple extraction methods\nfunction parseSchemaOrg(html: string, sourceUrl: string): any {\n const $ = cheerio.load(html);\n \n // Try JSON-LD first\n try {\n return parseJsonLd(html, sourceUrl);\n } catch (e) {\n // Continue\n }\n \n // Try Microdata\n try {\n return parseMicrodata(html, sourceUrl);\n } catch (e) {\n // Continue\n }\n \n // Fallback: Try to extract common recipe patterns from HTML\n const recipe: any = {\n sourceUrl,\n extractionMethod: \"heuristic\",\n };\n \n // Try to find title\n recipe.name = $('h1').first().text().trim() || \n $('meta[property=\"og:title\"]').attr('content') ||\n $('title').text().trim();\n \n // Try to find ingredients by common class names\n const ingredientSelectors = [\n '.ingredients li',\n '.ingredient-list li',\n '[class*=\"ingredient\"] li',\n '.recipe-ingredients li',\n 'ul.ingredients li',\n ];\n \n for (const selector of ingredientSelectors) {\n const items = $(selector);\n if (items.length > 0) {\n recipe.recipeIngredient = items.map((_, el) => $(el).text().trim()).get();\n break;\n }\n }\n \n // Try to find instructions\n const instructionSelectors = [\n '.instructions li',\n '.instruction-list li',\n '[class*=\"instruction\"] li',\n '.recipe-instructions li',\n '.directions li',\n '.steps li',\n ];\n \n for (const selector of instructionSelectors) {\n const items = $(selector);\n if (items.length > 0) {\n recipe.recipeInstructions = items.map((_, el) => $(el).text().trim()).get();\n break;\n }\n }\n \n if (!recipe.recipeIngredient && !recipe.recipeInstructions) {\n throw new Error(\"Could not extract recipe data using any method\");\n }\n \n return recipe;\n}\n\n// HTML Recipe Parser - simulates the npm package behavior using JSON-LD\nasync function parseHtmlRecipeParser(html: string, sourceUrl: string): Promise {\n // This mimics html-recipe-parser which primarily uses JSON-LD\n return parseJsonLd(html, sourceUrl);\n}\n\n// Find Recipe in nested JSON-LD data\nfunction findRecipeInData(data: any): any {\n if (!data) return null;\n \n // Direct Recipe type\n if (data[\"@type\"] === \"Recipe\") {\n return data;\n }\n \n // Array of types (e.g., [\"Recipe\", \"HowTo\"])\n if (Array.isArray(data[\"@type\"]) && data[\"@type\"].includes(\"Recipe\")) {\n return data;\n }\n \n // Check in @graph\n if (data[\"@graph\"] && Array.isArray(data[\"@graph\"])) {\n for (const item of data[\"@graph\"]) {\n const recipe = findRecipeInData(item);\n if (recipe) return recipe;\n }\n }\n \n // Check in array\n if (Array.isArray(data)) {\n for (const item of data) {\n const recipe = findRecipeInData(item);\n if (recipe) return recipe;\n }\n }\n \n return null;\n}\n\n// Normalize recipe data to a consistent format\nfunction normalizeRecipe(recipe: any, sourceUrl: string): any {\n const normalized: any = {\n name: recipe.name || recipe.headline || \"Untitled Recipe\",\n sourceUrl,\n ingredients: [],\n instructions: [],\n };\n \n // Normalize ingredients\n const rawIngredients = recipe.recipeIngredient || recipe.ingredients || [];\n normalized.ingredients = Array.isArray(rawIngredients) \n ? rawIngredients.map((i: any) => typeof i === 'string' ? i : i.text || String(i))\n : [rawIngredients];\n \n // Normalize instructions\n const rawInstructions = recipe.recipeInstructions || recipe.instructions || [];\n if (Array.isArray(rawInstructions)) {\n normalized.instructions = rawInstructions.map((i: any) => {\n if (typeof i === 'string') return i;\n if (i.text) return i.text;\n if (i[\"@type\"] === \"HowToStep\") return i.text || i.name || \"\";\n if (i[\"@type\"] === \"HowToSection\") {\n // Handle sections with nested steps\n const steps = i.itemListElement || [];\n return steps.map((s: any) => s.text || s.name || \"\").join(\" \");\n }\n return String(i);\n });\n } else {\n normalized.instructions = [rawInstructions];\n }\n \n // Copy other useful fields\n if (recipe.image) {\n normalized.imageUrl = Array.isArray(recipe.image) \n ? recipe.image[0] \n : (typeof recipe.image === 'string' ? recipe.image : recipe.image.url);\n }\n if (recipe.author) {\n normalized.author = typeof recipe.author === 'string' \n ? recipe.author \n : recipe.author.name || recipe.author[0]?.name;\n }\n if (recipe.prepTime) normalized.prepTime = recipe.prepTime;\n if (recipe.cookTime) normalized.cookTime = recipe.cookTime;\n if (recipe.totalTime) normalized.totalTime = recipe.totalTime;\n if (recipe.recipeYield) normalized.yield = recipe.recipeYield;\n if (recipe.nutrition) normalized.nutrition = recipe.nutrition;\n if (recipe.recipeCategory) normalized.category = recipe.recipeCategory;\n if (recipe.recipeCuisine) normalized.cuisine = recipe.recipeCuisine;\n if (recipe.description) normalized.description = recipe.description;\n \n // Include raw data for debugging\n normalized._raw = recipe;\n \n return normalized;\n}\n\n// Individual scraper runners\nasync function runJsonLdNative(html: string, url: string): Promise {\n const start = Date.now();\n try {\n const data = parseJsonLd(html, url);\n return {\n scraper: \"json-ld-native\",\n success: true,\n data,\n durationMs: Date.now() - start,\n };\n } catch (error) {\n return {\n scraper: \"json-ld-native\",\n success: false,\n error: error instanceof Error ? error.message : String(error),\n durationMs: Date.now() - start,\n };\n }\n}\n\nasync function runMicrodataNative(html: string, url: string): Promise {\n const start = Date.now();\n try {\n const data = parseMicrodata(html, url);\n return {\n scraper: \"microdata-native\",\n success: true,\n data,\n durationMs: Date.now() - start,\n };\n } catch (error) {\n return {\n scraper: \"microdata-native\",\n success: false,\n error: error instanceof Error ? error.message : String(error),\n durationMs: Date.now() - start,\n };\n }\n}\n\nasync function runHtmlRecipeParser(html: string, url: string): Promise {\n const start = Date.now();\n try {\n const data = await parseHtmlRecipeParser(html, url);\n return {\n scraper: \"html-recipe-parser\",\n success: true,\n data,\n durationMs: Date.now() - start,\n };\n } catch (error) {\n return {\n scraper: \"html-recipe-parser\",\n success: false,\n error: error instanceof Error ? error.message : String(error),\n durationMs: Date.now() - start,\n };\n }\n}\n\nasync function runSchemaOrgExtractor(html: string, url: string): Promise {\n const start = Date.now();\n try {\n const data = parseSchemaOrg(html, url);\n return {\n scraper: \"schema-org-extractor\",\n success: true,\n data,\n durationMs: Date.now() - start,\n };\n } catch (error) {\n return {\n scraper: \"schema-org-extractor\",\n success: false,\n error: error instanceof Error ? error.message : String(error),\n durationMs: Date.now() - start,\n };\n }\n}\n\n// Run all scrapers for a single URL\nasync function scrapeUrl(url: string): Promise {\n let html: string;\n const fetchStart = Date.now();\n \n try {\n html = await fetchHtml(url);\n } catch (error) {\n const errorMsg = error instanceof Error ? error.message : String(error);\n // Return error for all scrapers if fetch fails\n return {\n url,\n results: SCRAPER_NAMES.map(scraper => ({\n scraper,\n success: false,\n error: `Failed to fetch: ${errorMsg}`,\n durationMs: Date.now() - fetchStart,\n })),\n };\n }\n \n // Run all scrapers in parallel on the fetched HTML\n const results = await Promise.all([\n runJsonLdNative(html, url),\n runMicrodataNative(html, url),\n runHtmlRecipeParser(html, url),\n runSchemaOrgExtractor(html, url),\n ]);\n\n return { url, results };\n}\n\n// POST endpoint to scrape multiple URLs\napp.post(\"/\", async (c) => {\n const body = await c.req.json();\n const urls: string[] = body.urls;\n\n if (!Array.isArray(urls) || urls.length === 0) {\n return c.json({ success: false, error: \"urls must be a non-empty array\" }, 400);\n }\n\n // Validate URLs\n const validUrls = urls.filter((url) => {\n try {\n new URL(url);\n return true;\n } catch {\n return false;\n }\n });\n\n if (validUrls.length === 0) {\n return c.json({ success: false, error: \"No valid URLs provided\" }, 400);\n }\n\n // Run scrapers for all URLs in parallel\n const results = await Promise.all(validUrls.map(scrapeUrl));\n\n return c.json({\n success: true,\n data: results,\n scraperNames: SCRAPER_NAMES,\n });\n});\n\n// GET endpoint to get scraper info\napp.get(\"/info\", (c) => {\n return c.json({\n success: true,\n data: {\n scrapers: SCRAPER_NAMES,\n description: \"Recipe scraper evaluation tool - compares different extraction methods\",\n methods: {\n \"json-ld-native\": \"Extracts Recipe schema from JSON-LD script tags\",\n \"microdata-native\": \"Extracts Recipe schema from microdata attributes\",\n \"html-recipe-parser\": \"Simulates html-recipe-parser npm package (JSON-LD based)\",\n \"schema-org-extractor\": \"Combines JSON-LD, Microdata, and heuristic fallback\",\n },\n },\n });\n});\n\n// ============ URL PERSISTENCE ENDPOINTS ============\n\n// GET /urls - Get all saved URLs for the user\napp.get(\"/urls\", async (c) => {\n const user = requireAuth(c);\n const urls = await getScraperEvalUrls(user.id);\n return c.json({ success: true, data: urls });\n});\n\n// POST /urls - Add new URLs\napp.post(\"/urls\", async (c) => {\n const user = requireAuth(c);\n const body = await c.req.json();\n \n // Support both single URL and array of URLs\n const urlsToAdd: string[] = Array.isArray(body.urls) \n ? body.urls \n : (body.url ? [body.url] : []);\n \n // Validate URLs\n const validUrls = urlsToAdd.filter((url) => {\n try {\n new URL(url);\n return true;\n } catch {\n return false;\n }\n });\n \n if (validUrls.length === 0) {\n return c.json({ success: false, error: \"No valid URLs provided\" }, 400);\n }\n \n const added = await addScraperEvalUrls(user.id, validUrls);\n return c.json({ \n success: true, \n data: added,\n message: `Added ${added.length} URL(s)` \n });\n});\n\n// DELETE /urls/:id - Delete a specific URL\napp.delete(\"/urls/:id\", async (c) => {\n const user = requireAuth(c);\n const urlId = c.req.param(\"id\");\n \n const deleted = await deleteScraperEvalUrl(user.id, urlId);\n \n if (!deleted) {\n return c.json({ success: false, error: \"URL not found\" }, 404);\n }\n \n return c.json({ success: true });\n});\n\n// DELETE /urls - Clear all URLs\napp.delete(\"/urls\", async (c) => {\n const user = requireAuth(c);\n const count = await deleteAllScraperEvalUrls(user.id);\n return c.json({ success: true, deleted: count });\n});\n\nexport const scraperEvalRoutes = app;\n",[],[171,352,344],"routes","eaf65190-d8b2-11f0-a21f-42dde27851f2","recipes.ts","b91aea68-d3a9-11f0-897f-42dde27851f2",48,["D",1765692340603],"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\n",[],[171,352,354],"eb216dee-d8b2-11f0-a0e4-42dde27851f2","nutrition.ts","b92224d6-d3a9-11f0-893e-42dde27851f2",51,["D",1765692340885],"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\n",[],[171,352,362],"eaf2da1a-d8b2-11f0-abf7-42dde27851f2","meal-plans.ts","b91726c6-d3a9-11f0-9cb5-42dde27851f2",47,["D",1765692340597],"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\n",[],[171,352,370],"eb10d858-d8b2-11f0-ab60-42dde27851f2","grocery-lists.ts","b95a451e-d3a9-11f0-897f-42dde27851f2",49,["D",1765692340795],"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\n",[],[171,352,378],"eb165968-d8b2-11f0-abf7-42dde27851f2","auth.ts","b928d074-d3a9-11f0-9cb5-42dde27851f2",50,["D",1765692340795],"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\n",[],[171,352,386],"b8ad561a-d3a9-11f0-8e4b-42dde27851f2",7,["D",1765138634968],[193,194,195,196,197,198],[171,352],"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",[],[171,407,399],"middleware","b882c86e-d3a9-11f0-8004-42dde27851f2",["D",1765138634693],[191],[171,407],"8d22d556-d926-11f0-9ad3-42dde27851f2","queries.ts","b90da5f6-d3a9-11f0-a23f-42dde27851f2","b896776a-d3a9-11f0-8e4b-42dde27851f2",64,["D",1765742004789],"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 SCRAPER_EVAL_URLS_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// ============ SCRAPER EVAL URL QUERIES ============\n\nexport interface ScraperEvalUrl {\n id: string;\n userId: string;\n url: string;\n createdAt: string;\n}\n\nexport async function getScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, url, created_at FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n url: row.url as string,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addScraperEvalUrl(userId: string, url: string): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${SCRAPER_EVAL_URLS_TABLE} (id, user_id, url) VALUES (?, ?, ?)`,\n [id, userId, url]\n );\n \n return { id, userId, url, createdAt: now };\n } catch (error) {\n // URL already exists for this user (unique constraint)\n return null;\n }\n}\n\nexport async function addScraperEvalUrls(userId: string, urls: string[]): Promise {\n const added: ScraperEvalUrl[] = [];\n \n for (const url of urls) {\n const result = await addScraperEvalUrl(userId, url);\n if (result) added.push(result);\n }\n \n return added;\n}\n\nexport async function deleteScraperEvalUrl(userId: string, urlId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE id = ? AND user_id = ?`,\n [urlId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function deleteAllScraperEvalUrls(userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${SCRAPER_EVAL_URLS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n return result.rowsAffected;\n}\n\n\n",[],[171,421,413],"database","8d1af674-d926-11f0-863e-42dde27851f2","migrations.ts","b92d14ae-d3a9-11f0-9955-42dde27851f2",62,["D",1765742004771],"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';\nexport const SCRAPER_EVAL_URLS_TABLE = 'carmy_scraper_eval_urls_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 // Scraper evaluation URLs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SCRAPER_EVAL_URLS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n url TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, url)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SCRAPER_EVAL_URLS_TABLE}_user_id \n ON ${SCRAPER_EVAL_URLS_TABLE}(user_id)\n `);\n\n console.log('Carmy migrations complete');\n}\n\n\n",[],[171,421,423],"b89676ac-d3a9-11f0-8e4b-42dde27851f2",6,["D",1765138634821],[188,189],[171,421],["D",1765138634257],[187,190,192,199],[171],["D",1765137234131],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_123":475,"_476":477,"_478":479,"_480":25,"_481":25,"_482":25,"_483":59,"_484":-5,"_485":-7,"_486":-7,"_487":63,"_488":25,"_489":25,"_490":-5,"_491":25,"_492":25,"_493":25,"_494":-5},"ENV",{"_446":447,"_448":449,"_450":87,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v74