[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_466":467,"_468":469},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":52,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",88,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/services/nutrition-calculator.ts","latestPath","fileId","6a3733ee-da38-11f0-8a3d-42dde27851f2","name","nutrition-calculator.ts","fileType","script","content","// Nutrition Calculator Service\n// Calculates recipe nutrition by summing ingredient nutrition from FDC data\n\nimport { getFDCFoods } from \"./fdc-client.ts\";\nimport type { RecipeIngredient, RecipeNutrition, FDCNutrition, NutrientKey, IngredientUnit } from \"../../shared/types.ts\";\n\n// Unit conversion factors to grams\nconst UNIT_TO_GRAMS: Record = {\n 'g': 1,\n 'gram': 1,\n 'grams': 1,\n 'kg': 1000,\n 'kilogram': 1000,\n 'oz': 28.3495,\n 'ounce': 28.3495,\n 'ounces': 28.3495,\n 'lb': 453.592,\n 'lbs': 453.592,\n 'pound': 453.592,\n 'pounds': 453.592,\n 'ml': 1, // Approximate, assumes density of water\n 'milliliter': 1,\n 'milliliters': 1,\n 'l': 1000,\n 'liter': 1000,\n 'liters': 1000,\n // Common cooking measurements (approximate, for water-like liquids)\n 'cup': 236.588,\n 'cups': 236.588,\n 'tbsp': 14.787,\n 'tablespoon': 14.787,\n 'tablespoons': 14.787,\n 'tsp': 4.929,\n 'teaspoon': 4.929,\n 'teaspoons': 4.929,\n};\n\n// Convert amount + unit to grams\nexport function convertToGrams(amount: number | null, unit: string | null): number | null {\n if (amount === null) return null;\n if (!unit) return amount; // Assume grams if no unit\n \n const normalizedUnit = unit.toLowerCase().trim();\n const factor = UNIT_TO_GRAMS[normalizedUnit];\n \n if (factor !== undefined) {\n return amount * factor;\n }\n \n // Handle units like \"2 cups\" where the unit includes a number\n const match = normalizedUnit.match(/^(\\d+(?:\\.\\d+)?)\\s*(.+)$/);\n if (match) {\n const [, numStr, baseUnit] = match;\n const baseFactor = UNIT_TO_GRAMS[baseUnit.trim()];\n if (baseFactor !== undefined) {\n return amount * parseFloat(numStr) * baseFactor;\n }\n }\n \n // For unknown units (like \"piece\", \"whole\", etc.), return null\n // These will need FDC portion data for accurate conversion\n return null;\n}\n\n// All nutrient keys for iteration\nconst NUTRIENT_KEYS: NutrientKey[] = [\n 'calories', 'protein', 'fat', 'carbs', 'fiber',\n 'sodium', 'potassium', 'calcium', 'iron', 'magnesium', 'zinc',\n 'vitaminA', 'vitaminC', 'vitaminD', 'vitaminE', 'vitaminK',\n 'vitaminB6', 'vitaminB12', 'thiamin', 'riboflavin', 'niacin', 'folate',\n];\n\n// Create empty nutrition object\nfunction createEmptyNutrition(): Omit & { isComplete: boolean } {\n return {\n calories: null,\n protein: null,\n fat: null,\n carbs: null,\n fiber: null,\n sodium: null,\n potassium: null,\n calcium: null,\n iron: null,\n magnesium: null,\n zinc: null,\n vitaminA: null,\n vitaminC: null,\n vitaminD: null,\n vitaminE: null,\n vitaminK: null,\n vitaminB6: null,\n vitaminB12: null,\n thiamin: null,\n riboflavin: null,\n niacin: null,\n folate: null,\n isComplete: false,\n };\n}\n\n// Scale nutrition values by a factor (amountGrams / 100)\nfunction scaleNutrition(nutrition: FDCNutrition, factor: number): Partial {\n const scaled: Partial = {};\n \n for (const key of NUTRIENT_KEYS) {\n const value = nutrition[key];\n if (value !== null && value !== undefined) {\n scaled[key] = value * factor;\n }\n }\n \n return scaled;\n}\n\n// Sum nutrition values\nfunction sumNutrition(\n total: Partial>,\n toAdd: Partial\n): void {\n for (const key of NUTRIENT_KEYS) {\n const value = toAdd[key];\n if (value !== null && value !== undefined) {\n total[key] = (total[key] || 0) + value;\n }\n }\n}\n\nexport interface CalculatedNutrition {\n nutrition: Omit;\n linkedCount: number;\n totalCount: number;\n unlinkedIngredients: string[];\n}\n\n// Calculate recipe nutrition from ingredients\nexport async function calculateRecipeNutrition(\n ingredients: RecipeIngredient[],\n servingSize: number\n): Promise {\n if (ingredients.length === 0) {\n return {\n nutrition: { ...createEmptyNutrition(), isComplete: true },\n linkedCount: 0,\n totalCount: 0,\n unlinkedIngredients: [],\n };\n }\n \n // Collect FDC IDs that need to be fetched\n const fdcIds = ingredients\n .filter(i => i.fdcId !== null)\n .map(i => i.fdcId as number);\n \n // Fetch all FDC foods at once\n const fdcFoods = fdcIds.length > 0 ? await getFDCFoods(fdcIds) : new Map();\n \n const totalNutrition: Partial> = {};\n const unlinkedIngredients: string[] = [];\n let linkedCount = 0;\n \n for (const ingredient of ingredients) {\n // Check if ingredient has FDC link\n if (!ingredient.fdcId) {\n unlinkedIngredients.push(ingredient.name);\n continue;\n }\n \n const fdcFood = fdcFoods.get(ingredient.fdcId);\n if (!fdcFood) {\n unlinkedIngredients.push(ingredient.name);\n continue;\n }\n \n // Get amount in grams\n let amountGrams = ingredient.amountGrams;\n \n // If no pre-calculated grams, try to convert\n if (amountGrams === null && ingredient.amount !== null) {\n amountGrams = convertToGrams(ingredient.amount, ingredient.unit);\n }\n \n // If still no amount, use FDC serving size as default\n if (amountGrams === null) {\n if (fdcFood.servingSize && fdcFood.servingSizeUnit?.toLowerCase() === 'g') {\n amountGrams = fdcFood.servingSize;\n } else {\n // Can't calculate without amount\n unlinkedIngredients.push(ingredient.name);\n continue;\n }\n }\n \n // FDC nutrition is per 100g, scale by actual amount\n const scaleFactor = amountGrams / 100;\n const scaledNutrition = scaleNutrition(fdcFood.nutrition, scaleFactor);\n sumNutrition(totalNutrition, scaledNutrition);\n \n linkedCount++;\n }\n \n // Divide by serving size to get per-serving values\n const perServing: Partial> = {};\n for (const key of NUTRIENT_KEYS) {\n const value = totalNutrition[key];\n if (value !== undefined) {\n perServing[key] = value / servingSize;\n } else {\n perServing[key] = null;\n }\n }\n \n const isComplete = unlinkedIngredients.length === 0 && linkedCount > 0;\n \n return {\n nutrition: {\n calories: perServing.calories ?? null,\n protein: perServing.protein ?? null,\n fat: perServing.fat ?? null,\n carbs: perServing.carbs ?? null,\n fiber: perServing.fiber ?? null,\n sodium: perServing.sodium ?? null,\n potassium: perServing.potassium ?? null,\n calcium: perServing.calcium ?? null,\n iron: perServing.iron ?? null,\n magnesium: perServing.magnesium ?? null,\n zinc: perServing.zinc ?? null,\n vitaminA: perServing.vitaminA ?? null,\n vitaminC: perServing.vitaminC ?? null,\n vitaminD: perServing.vitaminD ?? null,\n vitaminE: perServing.vitaminE ?? null,\n vitaminK: perServing.vitaminK ?? null,\n vitaminB6: perServing.vitaminB6 ?? null,\n vitaminB12: perServing.vitaminB12 ?? null,\n thiamin: perServing.thiamin ?? null,\n riboflavin: perServing.riboflavin ?? null,\n niacin: perServing.niacin ?? null,\n folate: perServing.folate ?? null,\n isComplete,\n },\n linkedCount,\n totalCount: ingredients.length,\n unlinkedIngredients,\n };\n}\n\n// Recalculate nutrition when serving size changes\nexport function recalculateForServingSize(\n originalNutrition: RecipeNutrition,\n originalServingSize: number,\n newServingSize: number\n): Omit {\n if (originalServingSize === newServingSize) {\n return { ...originalNutrition };\n }\n \n const factor = originalServingSize / newServingSize;\n \n const result: Partial> = {};\n for (const key of NUTRIENT_KEYS) {\n const value = originalNutrition[key];\n if (value !== null) {\n result[key] = value * factor;\n } else {\n result[key] = null;\n }\n }\n \n return {\n ...result,\n isComplete: originalNutrition.isComplete,\n } as Omit;\n}\n\n","createdAt",["D",1765859628346],"branchVersion","branchId","75b5bdc8-d3a6-11f0-86d1-42dde27851f2","id","75b56760-d3a6-11f0-86d1-42dde27851f2","carmy",["D",1765137234131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","b9153140-d3a9-11f0-8d63-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",251,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":462,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":463,"_80":464,"_82":465,"_84":24},"tree",[185,202,215,217,218,219],"files",[185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219],"counts",{"_175":62,"_176":166,"_177":62,"_178":179,"_180":181},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_56":125},"carmy.shapedlines.com",{"_42":169,"_31":170,"_29":171,"_135":-5,"_40":41,"_39":172,"_137":58,"_37":173,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_26":174},{"_42":163,"_31":164,"_29":165,"_135":-5,"_40":41,"_39":166,"_137":58,"_37":167,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_26":168},{"_42":156,"_31":157,"_29":158,"_135":-5,"_40":41,"_39":159,"_137":58,"_37":160,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_26":162},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":24,"_37":153,"_13":62,"_33":20,"_35":154,"_23":24,"_140":-5,"_26":155},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":58,"_37":146,"_13":62,"_33":20,"_35":147,"_23":24,"_140":-5,"_26":148},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":138,"_13":62,"_33":20,"_35":139,"_23":24,"_140":-5,"_26":141},"b8fc0cce-d3a9-11f0-a23f-42dde27851f2","deno.json","b8fc0d82-d3a9-11f0-a23f-42dde27851f2","parentId",16,"latest",["D",1765138635487],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[133],"b93a060a-d3a9-11f0-b1bf-42dde27851f2","AGENTS.md","b93a06dc-d3a9-11f0-b1bf-42dde27851f2",28,["D",1765138635892],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

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

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[143],"b93ee7d8-d3a9-11f0-b1e3-42dde27851f2",".vtignore","b93ee86e-d3a9-11f0-b1e3-42dde27851f2",29,["D",1765138635895],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[150],"b856c354-d3a9-11f0-8e4b-42dde27851f2","shared","b856c412-d3a9-11f0-8e4b-42dde27851f2",3,["D",1765138634405],"directory",[157],"b82c4976-d3a9-11f0-8e4b-42dde27851f2","frontend","b82c4a48-d3a9-11f0-8e4b-42dde27851f2",1,["D",1765138634122],[164],"b8403292-d3a9-11f0-8e76-42dde27851f2","backend","b8403350-d3a9-11f0-8e76-42dde27851f2",2,["D",1765138634257],[170],"pulls","branches","forks","envVars",{"_182":159,"_184":62},"connections",{"_182":62,"_183":62},"count","unfilledCount","emptyCount",{"_42":169,"_31":170,"_29":171,"_135":-5,"_40":41,"_39":172,"_137":58,"_37":459,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":460,"_26":461},{"_42":454,"_31":445,"_29":439,"_135":171,"_40":41,"_39":455,"_137":58,"_37":456,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":457,"_26":458},{"_42":446,"_31":447,"_29":448,"_135":439,"_40":41,"_39":449,"_137":24,"_37":450,"_13":159,"_33":34,"_35":451,"_23":24,"_140":-5,"_221":452,"_26":453},{"_42":436,"_31":437,"_29":438,"_135":439,"_40":41,"_39":440,"_137":24,"_37":441,"_13":159,"_33":34,"_35":442,"_23":24,"_140":-5,"_221":443,"_26":444},{"_42":432,"_31":431,"_29":425,"_135":171,"_40":41,"_39":271,"_137":58,"_37":433,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":434,"_26":435},{"_42":422,"_31":423,"_29":424,"_135":425,"_40":41,"_39":426,"_137":24,"_37":427,"_13":172,"_33":34,"_35":428,"_23":24,"_140":-5,"_221":429,"_26":430},{"_42":417,"_31":368,"_29":362,"_135":171,"_40":41,"_39":418,"_137":58,"_37":419,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":420,"_26":421},{"_42":409,"_31":410,"_29":411,"_135":362,"_40":41,"_39":412,"_137":24,"_37":413,"_13":172,"_33":34,"_35":414,"_23":24,"_140":-5,"_221":415,"_26":416},{"_42":401,"_31":402,"_29":403,"_135":362,"_40":41,"_39":404,"_137":24,"_37":405,"_13":62,"_33":34,"_35":406,"_23":24,"_140":-5,"_221":407,"_26":408},{"_42":393,"_31":394,"_29":395,"_135":362,"_40":41,"_39":396,"_137":24,"_37":397,"_13":172,"_33":34,"_35":398,"_23":24,"_140":-5,"_221":399,"_26":400},{"_42":385,"_31":386,"_29":387,"_135":362,"_40":41,"_39":388,"_137":24,"_37":389,"_13":172,"_33":34,"_35":390,"_23":24,"_140":-5,"_221":391,"_26":392},{"_42":377,"_31":378,"_29":379,"_135":362,"_40":41,"_39":380,"_137":24,"_37":381,"_13":172,"_33":34,"_35":382,"_23":24,"_140":-5,"_221":383,"_26":384},{"_42":369,"_31":370,"_29":371,"_135":362,"_40":41,"_39":372,"_137":24,"_37":373,"_13":172,"_33":34,"_35":374,"_23":24,"_140":-5,"_221":375,"_26":376},{"_42":359,"_31":360,"_29":361,"_135":362,"_40":41,"_39":363,"_137":58,"_37":364,"_13":172,"_33":34,"_35":365,"_23":24,"_140":-5,"_221":366,"_26":367},{"_42":354,"_31":353,"_29":349,"_135":171,"_40":41,"_39":355,"_137":58,"_37":356,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":357,"_26":358},{"_42":348,"_31":32,"_29":30,"_135":349,"_40":41,"_39":14,"_137":24,"_37":350,"_13":62,"_33":34,"_35":36,"_23":24,"_140":-5,"_221":351,"_26":352},{"_42":340,"_31":341,"_29":56,"_135":171,"_40":41,"_39":342,"_137":24,"_37":343,"_13":159,"_33":344,"_35":345,"_23":24,"_140":-5,"_221":346,"_26":347},{"_42":163,"_31":164,"_29":165,"_135":-5,"_40":41,"_39":166,"_137":58,"_37":337,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":338,"_26":339},{"_42":332,"_31":275,"_29":268,"_135":165,"_40":41,"_39":333,"_137":58,"_37":334,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":335,"_26":336},{"_42":324,"_31":325,"_29":326,"_135":268,"_40":41,"_39":327,"_137":24,"_37":328,"_13":172,"_33":34,"_35":329,"_23":24,"_140":-5,"_221":330,"_26":331},{"_42":316,"_31":317,"_29":318,"_135":268,"_40":41,"_39":319,"_137":24,"_37":320,"_13":172,"_33":34,"_35":321,"_23":24,"_140":-5,"_221":322,"_26":323},{"_42":308,"_31":309,"_29":310,"_135":268,"_40":41,"_39":311,"_137":24,"_37":312,"_13":172,"_33":34,"_35":313,"_23":24,"_140":-5,"_221":314,"_26":315},{"_42":300,"_31":301,"_29":302,"_135":268,"_40":41,"_39":303,"_137":24,"_37":304,"_13":172,"_33":34,"_35":305,"_23":24,"_140":-5,"_221":306,"_26":307},{"_42":292,"_31":293,"_29":294,"_135":268,"_40":41,"_39":295,"_137":24,"_37":296,"_13":172,"_33":34,"_35":297,"_23":24,"_140":-5,"_221":298,"_26":299},{"_42":284,"_31":285,"_29":286,"_135":268,"_40":41,"_39":287,"_137":24,"_37":288,"_13":271,"_33":34,"_35":289,"_23":24,"_140":-5,"_221":290,"_26":291},{"_42":276,"_31":277,"_29":278,"_135":268,"_40":41,"_39":279,"_137":24,"_37":280,"_13":172,"_33":34,"_35":281,"_23":24,"_140":-5,"_221":282,"_26":283},{"_42":265,"_31":266,"_29":267,"_135":268,"_40":41,"_39":269,"_137":24,"_37":270,"_13":271,"_33":34,"_35":272,"_23":24,"_140":-5,"_221":273,"_26":274},{"_42":257,"_31":258,"_29":259,"_135":165,"_40":41,"_39":260,"_137":24,"_37":261,"_13":172,"_33":20,"_35":262,"_23":24,"_140":-5,"_221":263,"_26":264},{"_42":249,"_31":250,"_29":251,"_135":165,"_40":41,"_39":252,"_137":24,"_37":253,"_13":172,"_33":20,"_35":254,"_23":24,"_140":-5,"_221":255,"_26":256},{"_42":241,"_31":242,"_29":243,"_135":165,"_40":41,"_39":244,"_137":24,"_37":245,"_13":172,"_33":34,"_35":246,"_23":24,"_140":-5,"_221":247,"_26":248},{"_42":156,"_31":157,"_29":158,"_135":-5,"_40":41,"_39":159,"_137":58,"_37":238,"_13":62,"_33":161,"_35":-5,"_23":24,"_140":-5,"_221":239,"_26":240},{"_42":230,"_31":231,"_29":232,"_135":158,"_40":41,"_39":233,"_137":24,"_37":234,"_13":172,"_33":34,"_35":235,"_23":24,"_140":-5,"_221":236,"_26":237},{"_42":149,"_31":150,"_29":151,"_135":-5,"_40":41,"_39":152,"_137":24,"_37":227,"_13":62,"_33":20,"_35":154,"_23":24,"_140":-5,"_221":228,"_26":229},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":58,"_37":224,"_13":62,"_33":20,"_35":147,"_23":24,"_140":-5,"_221":225,"_26":226},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":220,"_13":62,"_33":20,"_35":139,"_23":24,"_140":-5,"_221":222,"_26":223},["D",1765138635487],"children",[],[133],["D",1765138635892],[],[143],["D",1765138635895],[],[150],"1dc9d740-da34-11f0-9620-42dde27851f2","types.ts","b9331f48-d3a9-11f0-a755-42dde27851f2",84,["D",1765857781796],"// Shared types for Carmy - Recipe and Meal Planning App\n// NOTE: This file runs in both frontend and backend - do not use Deno APIs here\n\nexport interface User {\n id: string;\n email: string;\n name: string | null;\n picture: string | null;\n}\n\nexport interface Recipe {\n id: string;\n userId: string;\n title: string;\n url: string | null;\n instructions: string | null;\n servingSize: number;\n createdAt: string;\n updatedAt: string;\n ingredients: RecipeIngredient[];\n nutrition: RecipeNutrition | null;\n}\n\nexport interface RecipeIngredient {\n id: string;\n recipeId: string;\n name: string;\n amount: number | null;\n unit: string | null;\n notes: string | null;\n orderIndex: number;\n}\n\nexport interface RecipeNutrition {\n id: string;\n recipeId: string;\n calories: number | null;\n protein: number | null;\n fiber: number | null;\n fat: number | null;\n carbs: number | null;\n}\n\nexport interface GroceryList {\n id: string;\n userId: string;\n name: string;\n createdAt: string;\n updatedAt: string;\n items: GroceryListItem[];\n}\n\nexport interface GroceryListItem {\n id: string;\n listId: string;\n name: string;\n quantity: number | null;\n unit: string | null;\n recipeId: string | null;\n recipeName: string | null;\n checked: boolean;\n createdAt: string;\n}\n\nexport interface NutritionGoals {\n id: string;\n userId: string;\n primaryGoalType: NutritionGoalType;\n primaryGoalValue: number;\n subGoal1Type: NutritionGoalType | null;\n subGoal1Value: number | null;\n subGoal2Type: NutritionGoalType | null;\n subGoal2Value: number | null;\n updatedAt: string;\n}\n\nexport type NutritionGoalType = 'calories' | 'protein' | 'fiber' | 'fat' | 'carbs';\n\nexport const NUTRITION_GOAL_UNITS: Record = {\n calories: 'kcal',\n protein: 'g',\n fiber: 'g',\n fat: 'g',\n carbs: 'g',\n};\n\nexport const NUTRITION_GOAL_LABELS: Record = {\n calories: 'Calories',\n protein: 'Protein',\n fiber: 'Fiber',\n fat: 'Fat',\n carbs: 'Carbohydrates',\n};\n\nexport interface MealPlan {\n id: string;\n userId: string;\n weekStartDate: string; // ISO date string (Sunday)\n createdAt: string;\n updatedAt: string;\n entries: MealPlanEntry[];\n}\n\nexport type DayOfWeek = 0 | 1 | 2 | 3 | 4 | 5 | 6; // Sunday = 0\nexport type MealType = 'breakfast' | 'lunch' | 'dinner' | 'snacks';\n\nexport const DAY_NAMES: string[] = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];\nexport const MEAL_TYPES: MealType[] = ['breakfast', 'lunch', 'dinner', 'snacks'];\nexport const MEAL_TYPE_LABELS: Record = {\n breakfast: 'Breakfast',\n lunch: 'Lunch',\n dinner: 'Dinner',\n snacks: 'Snacks',\n};\n\nexport interface MealPlanEntry {\n id: string;\n mealPlanId: string;\n dayOfWeek: DayOfWeek;\n mealType: MealType;\n recipeId: string;\n recipe?: Recipe;\n servings: number;\n}\n\nexport interface DailyNutrition {\n calories: number;\n protein: number;\n fiber: number;\n fat: number;\n carbs: number;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\n// Request types\nexport interface CreateRecipeRequest {\n title: string;\n url?: string | null;\n instructions?: string | null;\n servingSize: number;\n ingredients: { name: string; amount?: number | null; unit?: string | null; notes?: 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\n// Response type for parsing a recipe from URL\nexport interface ParsedRecipeFromUrl {\n title: string;\n url: string;\n instructions: string | null;\n servingSize: number;\n ingredients: {\n name: string;\n amount: number | null;\n unit: string | null;\n notes: string | null;\n originalText: string;\n }[];\n nutrition: {\n calories: number | null;\n protein: number | null;\n fiber: number | null;\n fat: number | null;\n carbs: number | null;\n } | null;\n}\n\nexport interface UpdateRecipeRequest extends Partial {\n id: string;\n}\n\nexport interface CreateGroceryListRequest {\n name: string;\n}\n\nexport interface AddGroceryItemRequest {\n name: string;\n quantity?: number | null;\n unit?: string | null;\n}\n\nexport interface AddRecipeIngredientsRequest {\n recipeId: string;\n}\n\nexport interface UpdateNutritionGoalsRequest {\n primaryGoalType: NutritionGoalType;\n primaryGoalValue: number;\n subGoal1Type?: NutritionGoalType | null;\n subGoal1Value?: number | null;\n subGoal2Type?: NutritionGoalType | null;\n subGoal2Value?: number | null;\n}\n\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\n",[],[157,231],["D",1765138634405],[216],[157],"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",[],[164,242],"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",[],[164,250],"1d4fbf96-da34-11f0-afcf-42dde27851f2","favicon.svg","b8f8fbb0-d3a9-11f0-897f-42dde27851f2",74,["D",1765857781331],"\n\n\n\n",[],[164,258],"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",[],[164,275,266],"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",[],[164,275,277],"6a31efa6-da38-11f0-8a8e-42dde27851f2","RecipeForm.tsx","b8ea08ee-d3a9-11f0-8d63-42dde27851f2",87,["D",1765859628309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest, ParsedRecipeFromUrl, FDCDataType, FDCSearchResult, CreateRecipeIngredient } from \"../../shared/types.ts\";\nimport { COMMON_UNITS } from \"../../shared/types.ts\";\n\ninterface FormIngredient {\n amount: string;\n unit: string;\n name: string;\n notes: string;\n // FDC linking\n fdcId: number | null;\n fdcDescription: string | null;\n fdcDataType: FDCDataType | null;\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): FormIngredient[] {\n if (importedRecipe?.ingredients?.length) {\n return importedRecipe.ingredients.map(i => ({\n amount: i.amount?.toString() || '',\n unit: i.unit || '',\n name: i.name,\n notes: i.notes || '',\n fdcId: null,\n fdcDescription: null,\n fdcDataType: null,\n }));\n }\n if (recipe?.ingredients?.length) {\n return recipe.ingredients.map(i => ({\n amount: i.amount?.toString() || '',\n unit: i.unit || '',\n name: i.name,\n notes: i.notes || '',\n fdcId: i.fdcId ?? null,\n fdcDescription: i.fdcDescription ?? null,\n fdcDataType: i.fdcDataType ?? null,\n }));\n }\n return [{ amount: '', unit: '', name: '', notes: '', fdcId: null, fdcDescription: null, fdcDataType: null }];\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 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 // FDC search modal state\n const [fdcSearchOpen, setFdcSearchOpen] = useState(false);\n const [fdcSearchIndex, setFdcSearchIndex] = useState(null);\n const [fdcSearchQuery, setFdcSearchQuery] = useState('');\n const [fdcSearchResults, setFdcSearchResults] = useState([]);\n const [fdcSearchLoading, setFdcSearchLoading] = useState(false);\n\n const addIngredient = () => {\n setIngredients([...ingredients, { amount: '', unit: '', name: '', notes: '', fdcId: null, fdcDescription: null, fdcDataType: null }]);\n };\n\n const removeIngredient = (index: number) => {\n setIngredients(ingredients.filter((_, i) => i !== index));\n };\n\n const updateIngredient = (index: number, field: keyof FormIngredient, value: any) => {\n const updated = [...ingredients];\n (updated[index] as any)[field] = value;\n setIngredients(updated);\n };\n \n // Open FDC search modal for an ingredient\n const openFdcSearch = (index: number) => {\n setFdcSearchIndex(index);\n setFdcSearchQuery(ingredients[index].name);\n setFdcSearchResults([]);\n setFdcSearchOpen(true);\n };\n \n // Search FDC foods\n const handleFdcSearch = async () => {\n if (!fdcSearchQuery.trim()) return;\n \n setFdcSearchLoading(true);\n try {\n const response = await fetch(`/api/fdc/search?query=${encodeURIComponent(fdcSearchQuery)}&pageSize=15`);\n const result = await response.json();\n \n if (result.success) {\n setFdcSearchResults(result.data);\n }\n } catch (error) {\n console.error('FDC search failed:', error);\n } finally {\n setFdcSearchLoading(false);\n }\n };\n \n // Select an FDC food for an ingredient\n const selectFdcFood = (food: FDCSearchResult) => {\n if (fdcSearchIndex === null) return;\n \n const updated = [...ingredients];\n updated[fdcSearchIndex].fdcId = food.fdcId;\n updated[fdcSearchIndex].fdcDescription = food.description;\n updated[fdcSearchIndex].fdcDataType = food.dataType;\n setIngredients(updated);\n \n setFdcSearchOpen(false);\n setFdcSearchIndex(null);\n };\n \n // Clear FDC link from an ingredient\n const clearFdcLink = (index: number) => {\n const updated = [...ingredients];\n updated[index].fdcId = null;\n updated[index].fdcDescription = null;\n updated[index].fdcDataType = null;\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?.toString() || '',\n unit: i.unit || '',\n name: i.name,\n notes: i.notes || '',\n fdcId: null,\n fdcDescription: null,\n fdcDataType: null,\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: i.amount ? parseFloat(i.amount) : null,\n unit: i.unit.trim() || null,\n notes: i.notes.trim() || null,\n fdcId: i.fdcId,\n fdcDescription: i.fdcDescription,\n fdcDataType: i.fdcDataType,\n } as CreateRecipeIngredient)),\n };\n \n await onSubmit(data);\n } finally {\n setSubmitting(false);\n }\n };\n\n // Count linked ingredients\n const linkedCount = ingredients.filter(i => i.fdcId !== null).length;\n const totalCount = ingredients.filter(i => i.name.trim()).length;\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 {totalCount > 0 && (\n \n {linkedCount}/{totalCount} linked to USDA\n \n )}\n

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

\n {/* Amount */}\n updateIngredient(index, 'amount', e.target.value)}\n className=\"input flex-shrink-0\"\n style={{ width: '4rem' }}\n placeholder=\"Amt\"\n />\n {/* Unit */}\n updateIngredient(index, 'unit', e.target.value)}\n className=\"input flex-shrink-0\"\n style={{ width: '5rem' }}\n >\n \n {COMMON_UNITS.map(u => (\n \n ))}\n \n {/* Name */}\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 {/* Notes */}\n updateIngredient(index, 'notes', e.target.value)}\n className=\"input flex-shrink-0 text-sm text-gray-500\"\n style={{ width: '6rem' }}\n placeholder=\"Notes\"\n />\n {/* Remove button */}\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 {/* FDC Link Row */}\n

\n {ing.fdcId ? (\n <>\n \n \n {ing.fdcDataType === 'Branded' ? 'Branded' : 'USDA'}\n \n \n {ing.fdcDescription}\n \n clearFdcLink(index)}\n className=\"text-xs text-gray-400 hover:text-red-500\"\n >\n Clear\n \n openFdcSearch(index)}\n className=\"text-xs text-blue-600 hover:text-blue-800\"\n >\n Change\n \n \n ) : (\n openFdcSearch(index)}\n className=\"text-xs flex items-center gap-1 text-blue-600 hover:text-blue-800\"\n >\n \n Link to USDA food for nutrition\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 info note */}\n

\n Nutrition is calculated automatically from linked ingredients using USDA FoodData Central.\n Link all ingredients to get complete nutrition information.\n

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

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

\n \n {/* FDC Search Modal */}\n {fdcSearchOpen && (\n

setFdcSearchOpen(false)}\n >\n

e.stopPropagation()}\n >\n

Search USDA Foods

\n Find a food to link for nutrition data\n

\n \n

\n setFdcSearchQuery(e.target.value)}\n placeholder=\"Search foods...\"\n className=\"input flex-1\"\n onKeyDown={(e) => {\n if (e.key === 'Enter') {\n e.preventDefault();\n handleFdcSearch();\n }\n }}\n />\n \n {fdcSearchLoading ? 'Searching...' : 'Search'}\n \n

\n \n

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

\n {fdcSearchLoading ? 'Searching...' : 'Enter a search term and click Search'}\n

\n ) : (\n

\n {fdcSearchResults.map((food) => (\n selectFdcFood(food)}\n className=\"w-full text-left p-3 rounded-lg border border-gray-200 hover:bg-gray-50 transition-colors\"\n >\n

{food.description}

\n \n {food.dataType}\n \n {food.brandOwner && (\n {food.brandOwner}\n )}\n

\n \n ))}\n

\n )}\n

\n \n

\n setFdcSearchOpen(false)}\n className=\"btn-secondary w-full\"\n >\n Cancel\n \n

\n )}\n \n );\n}\n",[],[164,275,285],"1da7637c-da34-11f0-82ab-42dde27851f2","NutritionView.tsx","b8f099c0-d3a9-11f0-8d63-42dde27851f2",83,["D",1765857781269],"/** @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\n",[],[164,275,293],"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",[],[164,275,301],"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",[],[164,275,309],"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",[],[164,275,317],"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",[],[164,275,325],"b86d0600-d3a9-11f0-b1e3-42dde27851f2",4,["D",1765138634552],[204,205,206,207,208,209,210,211],[164,275],["D",1765138634122],[203,212,213,214],[164],"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",[],[170,341],"6a373344-da38-11f0-8a3d-42dde27851f2","6a0c0b60-da38-11f0-8f3b-42dde27851f2",["D",1765859628346],[],[170,353,32],"services","6a0c0aa2-da38-11f0-8f3b-42dde27851f2",85,["D",1765859628057],[200],[170,353],"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",[],[170,368,360],"routes","1d7ac0ba-da34-11f0-a8c1-42dde27851f2","recipes.ts","b91aea68-d3a9-11f0-897f-42dde27851f2",79,["D",1765857781599],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\nimport { parse as parseIngredient } from \"https://esm.sh/recipe-ingredient-parser-v3@1.5.0\";\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, ParsedRecipeFromUrl } 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\n// ============ RECIPE URL PARSING ============\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// 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// Parse JSON-LD from HTML\nfunction parseJsonLd(html: 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 recipe;\n }\n } catch (e) {\n // Continue to next script\n }\n }\n \n return null;\n}\n\n// Extract notes from ingredient string by comparing with parsed result\nfunction extractNotes(originalText: string, parsedQuantity: string | number | null, parsedUnit: string | null, parsedIngredient: string): string | null {\n // Build a pattern of what was parsed to find remaining text\n let remaining = originalText;\n \n // Remove quantity\n if (parsedQuantity !== null) {\n const qtyStr = String(parsedQuantity);\n remaining = remaining.replace(new RegExp(`^\\\\s*${qtyStr.replace(/[.*+?^${}()|[\\]\\\\]/g, '\\\\$&')}\\\\s*`, 'i'), '');\n }\n \n // Remove unit\n if (parsedUnit) {\n remaining = remaining.replace(new RegExp(`^\\\\s*${parsedUnit.replace(/[.*+?^${}()|[\\]\\\\]/g, '\\\\$&')}\\\\s+`, 'i'), '');\n }\n \n // Remove ingredient name\n if (parsedIngredient) {\n remaining = remaining.replace(new RegExp(parsedIngredient.replace(/[.*+?^${}()|[\\]\\\\]/g, '\\\\$&'), 'i'), '');\n }\n \n // Clean up remaining text\n remaining = remaining.replace(/^[\\s,;-]+/, '').replace(/[\\s,;-]+$/, '').trim();\n \n // Common preparation notes patterns to extract\n const notesPatterns = [\n /,\\s*(.+)$/, // Everything after comma\n /\$([^)]+)\$/, // Parenthetical notes\n ];\n \n // Try to extract from original text if remaining didn't work well\n if (!remaining || remaining.length < 2) {\n for (const pattern of notesPatterns) {\n const match = originalText.match(pattern);\n if (match && match[1]) {\n remaining = match[1].trim();\n break;\n }\n }\n }\n \n return remaining && remaining.length > 1 ? remaining : null;\n}\n\n// Parse a single ingredient string into structured data\nfunction parseIngredientString(text: string): {\n name: string;\n amount: number | null;\n unit: string | null;\n notes: string | null;\n originalText: string;\n} {\n const trimmedText = text.trim();\n \n try {\n // Use recipe-ingredient-parser-v3\n const parsed = parseIngredient(trimmedText, 'eng');\n \n // Extract notes from remaining text\n const notes = extractNotes(\n trimmedText, \n parsed.quantity, \n parsed.unit, \n parsed.ingredient\n );\n \n return {\n name: parsed.ingredient || trimmedText,\n amount: parsed.quantity ? Number(parsed.quantity) : null,\n unit: parsed.unit || null,\n notes,\n originalText: trimmedText,\n };\n } catch (e) {\n // Fallback: return the whole string as the ingredient name\n return {\n name: trimmedText,\n amount: null,\n unit: null,\n notes: null,\n originalText: trimmedText,\n };\n }\n}\n\n// Parse recipe from URL\nrecipesRoutes.post('/parse-url', async (c) => {\n requireAuth(c);\n \n const body = await c.req.json();\n const { url } = body;\n \n if (!url) {\n return c.json({ success: false, error: 'URL is required' }, 400);\n }\n \n // Validate URL\n try {\n new URL(url);\n } catch {\n return c.json({ success: false, error: 'Invalid URL' }, 400);\n }\n \n try {\n // Fetch HTML\n const html = await fetchHtml(url);\n \n // Parse JSON-LD\n const recipeData = parseJsonLd(html);\n \n if (!recipeData) {\n return c.json({ \n success: false, \n error: 'Could not find recipe data on this page. The page may not have schema.org recipe markup.' \n }, 400);\n }\n \n // Extract recipe title\n const title = recipeData.name || recipeData.headline || 'Untitled Recipe';\n \n // Extract ingredients\n const rawIngredients = recipeData.recipeIngredient || recipeData.ingredients || [];\n const ingredientsList = Array.isArray(rawIngredients) ? rawIngredients : [rawIngredients];\n \n const parsedIngredients = ingredientsList\n .filter((ing: any) => ing && typeof ing === 'string')\n .map((ing: string) => parseIngredientString(ing));\n \n // Extract instructions\n let instructions: string | null = null;\n const rawInstructions = recipeData.recipeInstructions || recipeData.instructions || [];\n if (rawInstructions) {\n if (Array.isArray(rawInstructions)) {\n 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 const steps = i.itemListElement || [];\n return steps.map((s: any) => s.text || s.name || \"\").join(\"\\n\");\n }\n return String(i);\n }).filter(Boolean).join(\"\\n\\n\");\n } else {\n instructions = String(rawInstructions);\n }\n }\n \n // Extract serving size\n let servingSize = 1;\n if (recipeData.recipeYield) {\n const yieldStr = Array.isArray(recipeData.recipeYield) \n ? recipeData.recipeYield[0] \n : recipeData.recipeYield;\n const match = String(yieldStr).match(/\\d+/);\n if (match) {\n servingSize = parseInt(match[0]) || 1;\n }\n }\n \n // Extract nutrition if available\n let nutrition: ParsedRecipeFromUrl['nutrition'] = null;\n if (recipeData.nutrition) {\n const n = recipeData.nutrition;\n const parseNutritionValue = (val: any): number | null => {\n if (!val) return null;\n const match = String(val).match(/[\\d.]+/);\n return match ? parseFloat(match[0]) : null;\n };\n \n nutrition = {\n calories: parseNutritionValue(n.calories),\n protein: parseNutritionValue(n.proteinContent),\n fiber: parseNutritionValue(n.fiberContent),\n fat: parseNutritionValue(n.fatContent),\n carbs: parseNutritionValue(n.carbohydrateContent),\n };\n \n // Only include nutrition if at least one value is present\n if (!nutrition.calories && !nutrition.protein && !nutrition.fiber && !nutrition.fat && !nutrition.carbs) {\n nutrition = null;\n }\n }\n \n const result: ParsedRecipeFromUrl = {\n title,\n url,\n instructions,\n servingSize,\n ingredients: parsedIngredients,\n nutrition,\n };\n \n return c.json({ success: true, data: result });\n } catch (error) {\n const message = error instanceof Error ? error.message : 'Unknown error occurred';\n return c.json({ success: false, error: `Failed to parse recipe: ${message}` }, 500);\n }\n});\n\nexport { recipesRoutes };\n\n\n\n",[],[170,368,370],"1d7e20a2-da34-11f0-90b3-42dde27851f2","nutrition.ts","b92224d6-d3a9-11f0-893e-42dde27851f2",80,["D",1765857781637],"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\n",[],[170,368,378],"1d757b50-da34-11f0-9714-42dde27851f2","meal-plans.ts","b91726c6-d3a9-11f0-9cb5-42dde27851f2",78,["D",1765857781536],"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\n",[],[170,368,386],"1d9743c0-da34-11f0-be9c-42dde27851f2","grocery-lists.ts","b95a451e-d3a9-11f0-897f-42dde27851f2",82,["D",1765857781799],"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\n",[],[170,368,394],"6a251236-da38-11f0-86df-42dde27851f2","fdc.ts","6a2512f4-da38-11f0-86df-42dde27851f2",86,["D",1765859628228],"// USDA FoodData Central API Routes\nimport { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n searchFDCFoods,\n getFDCFood,\n autoMatchIngredient,\n} from \"../services/fdc-client.ts\";\nimport type { FDCDataType } from \"../../shared/types.ts\";\n\nconst fdcRoutes = new Hono();\n\n// Search FDC foods\nfdcRoutes.get('/search', async (c) => {\n requireAuth(c);\n \n const query = c.req.query('query');\n if (!query) {\n return c.json({ success: false, error: 'Query parameter is required' }, 400);\n }\n \n const pageSize = parseInt(c.req.query('pageSize') || '25');\n const pageNumber = parseInt(c.req.query('pageNumber') || '1');\n const dataTypeParam = c.req.query('dataType');\n \n let dataTypes: FDCDataType[] | undefined;\n if (dataTypeParam) {\n dataTypes = dataTypeParam.split(',') as FDCDataType[];\n }\n \n try {\n const results = await searchFDCFoods(query, {\n dataType: dataTypes,\n pageSize,\n pageNumber,\n });\n \n return c.json({ success: true, data: results });\n } catch (error) {\n const message = error instanceof Error ? error.message : 'Unknown error';\n return c.json({ success: false, error: message }, 500);\n }\n});\n\n// Get detailed food info by FDC ID\nfdcRoutes.get('/food/:fdcId', async (c) => {\n requireAuth(c);\n \n const fdcId = parseInt(c.req.param('fdcId'));\n if (isNaN(fdcId)) {\n return c.json({ success: false, error: 'Invalid FDC ID' }, 400);\n }\n \n try {\n const food = await getFDCFood(fdcId);\n return c.json({ success: true, data: food });\n } catch (error) {\n const message = error instanceof Error ? error.message : 'Unknown error';\n return c.json({ success: false, error: message }, 500);\n }\n});\n\n// Auto-match a single ingredient to FDC food\nfdcRoutes.post('/auto-match', async (c) => {\n requireAuth(c);\n \n const body = await c.req.json();\n const { ingredientName } = body;\n \n if (!ingredientName || typeof ingredientName !== 'string') {\n return c.json({ success: false, error: 'ingredientName is required' }, 400);\n }\n \n try {\n const result = await autoMatchIngredient(ingredientName);\n return c.json({ success: true, data: result });\n } catch (error) {\n const message = error instanceof Error ? error.message : 'Unknown error';\n return c.json({ success: false, error: message }, 500);\n }\n});\n\n// Auto-match multiple ingredients\nfdcRoutes.post('/auto-match-batch', async (c) => {\n requireAuth(c);\n \n const body = await c.req.json();\n const { ingredientNames } = body;\n \n if (!Array.isArray(ingredientNames)) {\n return c.json({ success: false, error: 'ingredientNames must be an array' }, 400);\n }\n \n try {\n const results: Record>> = {};\n \n for (const name of ingredientNames) {\n if (typeof name === 'string' && name.trim()) {\n results[name] = await autoMatchIngredient(name);\n }\n }\n \n return c.json({ success: true, data: results });\n } catch (error) {\n const message = error instanceof Error ? error.message : 'Unknown error';\n return c.json({ success: false, error: message }, 500);\n }\n});\n\nexport { fdcRoutes };\n\n",[],[170,368,402],"1d872e90-da34-11f0-b40a-42dde27851f2","auth.ts","b928d074-d3a9-11f0-9cb5-42dde27851f2",81,["D",1765857781696],"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\n",[],[170,368,410],"b8ad561a-d3a9-11f0-8e4b-42dde27851f2",7,["D",1765138634968],[192,193,194,195,196,197,198],[170,368],"1d5b4c3a-da34-11f0-9714-42dde27851f2","session.ts","b9030f74-d3a9-11f0-b1e3-42dde27851f2","b882c990-d3a9-11f0-8004-42dde27851f2",75,["D",1765857781403],"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\n",[],[170,431,423],"middleware","b882c86e-d3a9-11f0-8004-42dde27851f2",["D",1765138634693],[190],[170,431],"1d629a76-da34-11f0-a8c1-42dde27851f2","queries.ts","b90da5f6-d3a9-11f0-a23f-42dde27851f2","b896776a-d3a9-11f0-8e4b-42dde27851f2",76,["D",1765857781455],"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, notes, 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 notes: i.notes 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, notes, 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 notes: i.notes 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; notes?: 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, notes, order_index)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, ing.notes ?? 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 notes: ing.notes ?? 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; notes?: 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, notes, order_index)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [ingId, recipeId, ing.name, ing.amount ?? null, ing.unit ?? null, ing.notes ?? 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, notes: i.notes })),\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",[],[170,445,437],"database","1d698336-da34-11f0-87c5-42dde27851f2","migrations.ts","b92d14ae-d3a9-11f0-9955-42dde27851f2",77,["D",1765857781500],"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_v2';\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 notes 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",[],[170,445,447],"b89676ac-d3a9-11f0-8e4b-42dde27851f2",6,["D",1765138634821],[187,188],[170,445],["D",1765138634257],[186,189,191,199,201],[170],["D",1765137234131],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_122":499,"_500":501,"_502":503,"_504":24,"_505":24,"_506":24,"_507":58,"_508":-5,"_509":-7,"_510":-7,"_511":62,"_512":24,"_513":24,"_514":-5,"_515":24,"_516":24,"_517":24,"_518":-5},"ENV",{"_470":471,"_472":473,"_474":86,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498},"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 · v88