[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_496":497,"_498":499},"routes/_app.x.$handle.$name",{"_98":97,"_32":46,"_106":88,"_27":54,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":60,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",137,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/routes/fdc.ts","latestPath","fileId","6a2512f4-da38-11f0-86df-42dde27851f2","name","fdc.ts","fileType","script","content","// 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 {\n getStarredIngredients,\n addStarredIngredient,\n removeStarredIngredient,\n} from \"../database/queries.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 console.error(`Error fetching FDC food ${fdcId}:`, 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\n// Search FDC foods with results categorized by data type (Foundation vs Branded)\nfdcRoutes.get('/search-categorized', 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') || '15');\n\n try {\n // Search Foundation Foods and SR Legacy\n const foundationResults = await searchFDCFoods(query, {\n dataType: ['Foundation', 'SR Legacy'],\n pageSize,\n });\n\n // Search Branded Foods\n const brandedResults = await searchFDCFoods(query, {\n dataType: ['Branded'],\n pageSize,\n });\n\n return c.json({\n success: true,\n data: {\n foundation: foundationResults,\n branded: brandedResults,\n }\n });\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// ============ STARRED INGREDIENTS ============\n\n// Get user's starred ingredients\nfdcRoutes.get('/starred', async (c) => {\n const user = requireAuth(c);\n\n const starred = await getStarredIngredients(user.id);\n return c.json({ success: true, data: starred });\n});\n\n// Star an ingredient\nfdcRoutes.post('/starred', async (c) => {\n const user = requireAuth(c);\n\n const body = await c.req.json();\n const { fdcId, fdcDescription, fdcDataType, brandOwner } = body;\n\n if (!fdcId || !fdcDescription || !fdcDataType) {\n return c.json({ success: false, error: 'fdcId, fdcDescription, and fdcDataType are required' }, 400);\n }\n\n const result = await addStarredIngredient(\n user.id,\n fdcId,\n fdcDescription,\n fdcDataType,\n brandOwner || null\n );\n\n if (!result) {\n return c.json({ success: false, error: 'Already starred' }, 409);\n }\n\n return c.json({ success: true, data: result });\n});\n\n// Unstar an ingredient\nfdcRoutes.delete('/starred/:fdcId', async (c) => {\n const user = 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 const removed = await removeStarredIngredient(user.id, fdcId);\n\n if (!removed) {\n return c.json({ success: false, error: 'Not found' }, 404);\n }\n\n return c.json({ success: true });\n});\n\nexport { fdcRoutes };\n\n","// 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 {\n getStarredIngredients,\n addStarredIngredient,\n removeStarredIngredient,\n} from \"../database/queries.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 console.error(`Error fetching FDC food ${fdcId}:`, error);\n const message = error instanceof Error ? error.message : 'Unknown error';\n\n // If FDC API returned 404, return 404 to client\n if (message.includes('404')) {\n return c.json({ success: false, error: 'Food not found in USDA database. It may have been removed or archived.' }, 404);\n }\n\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\n// Search FDC foods with results categorized by data type (Foundation vs Branded)\nfdcRoutes.get('/search-categorized', 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') || '15');\n\n try {\n // Search Foundation Foods and SR Legacy\n const foundationResults = await searchFDCFoods(query, {\n dataType: ['Foundation', 'SR Legacy'],\n pageSize,\n });\n\n // Search Branded Foods\n const brandedResults = await searchFDCFoods(query, {\n dataType: ['Branded'],\n pageSize,\n });\n\n return c.json({\n success: true,\n data: {\n foundation: foundationResults,\n branded: brandedResults,\n }\n });\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// ============ STARRED INGREDIENTS ============\n\n// Get user's starred ingredients\nfdcRoutes.get('/starred', async (c) => {\n const user = requireAuth(c);\n\n const starred = await getStarredIngredients(user.id);\n return c.json({ success: true, data: starred });\n});\n\n// Star an ingredient\nfdcRoutes.post('/starred', async (c) => {\n const user = requireAuth(c);\n\n const body = await c.req.json();\n const { fdcId, fdcDescription, fdcDataType, brandOwner } = body;\n\n if (!fdcId || !fdcDescription || !fdcDataType) {\n return c.json({ success: false, error: 'fdcId, fdcDescription, and fdcDataType are required' }, 400);\n }\n\n const result = await addStarredIngredient(\n user.id,\n fdcId,\n fdcDescription,\n fdcDataType,\n brandOwner || null\n );\n\n if (!result) {\n return c.json({ success: false, error: 'Already starred' }, 409);\n }\n\n return c.json({ success: true, data: result });\n});\n\n// Unstar an ingredient\nfdcRoutes.delete('/starred/:fdcId', async (c) => {\n const user = 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 const removed = await removeStarredIngredient(user.id, fdcId);\n\n if (!removed) {\n return c.json({ success: false, error: 'Not found' }, 404);\n }\n\n return c.json({ success: true });\n});\n\nexport { fdcRoutes };\n\n","createdAt",["D",1766031817577],"branchVersion","branchId","75b5bdc8-d3a6-11f0-86d1-42dde27851f2","id","75b56760-d3a6-11f0-86d1-42dde27851f2","carmy",["D",1765137234131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","b9153140-d3a9-11f0-8d63-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",251,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":492,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":493,"_82":494,"_84":495,"_86":25},"tree",[187,206,220,222,223,224],"files",[187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224],"counts",{"_177":64,"_178":168,"_179":64,"_180":181,"_182":183},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_58":127},"carmy.shapedlines.com",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":60,"_39":175,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":176},{"_44":165,"_32":166,"_30":167,"_137":-5,"_42":43,"_41":168,"_139":60,"_39":169,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":170},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":60,"_39":162,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":164},{"_44":151,"_32":152,"_30":153,"_137":-5,"_42":43,"_41":154,"_139":25,"_39":155,"_13":64,"_34":20,"_36":156,"_24":25,"_142":-5,"_27":157},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":60,"_39":148,"_13":64,"_34":20,"_36":149,"_24":25,"_142":-5,"_27":150},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":140,"_13":64,"_34":20,"_36":141,"_24":25,"_142":-5,"_27":143},"b8fc0cce-d3a9-11f0-a23f-42dde27851f2","deno.json","b8fc0d82-d3a9-11f0-a23f-42dde27851f2","parentId",16,"latest",["D",1765138635487],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[135],"b93a060a-d3a9-11f0-b1bf-42dde27851f2","AGENTS.md","b93a06dc-d3a9-11f0-b1bf-42dde27851f2",28,["D",1765138635892],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

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

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

\n Loading saved URLs...\n

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

\n {/* Header */}\n

\n Recipe Scraper Evaluation\n

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

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

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

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

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

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

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

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

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

\n )}\n

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

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

\n Loading...\n

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

\n ❌\n Error\n

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

\n                                  {summary.text}\n

\n )}\n

\n ) : (\n

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

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

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

\n {cellExpanded && (\n

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

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

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

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

Name:

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

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

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

\n •{ing}\n

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

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

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

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

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

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

\n ) : (\n

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

\n )}\n

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

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

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

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

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

🔍

No recipe URLs saved yet

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

\n )}\n

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

\n {/* Header */}\n

Recipes & Foods

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

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

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

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

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

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

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

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

\n 📖\n

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

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

\n ) : (\n

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

{recipe.title}

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

\n \n \n \n

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

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

\n ) : (\n

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

\n )}\n

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

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

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

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

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

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

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

Ingredients

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

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

Instructions

{recipe.instructions}

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

Nutrition (per serving)

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

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

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

kcal

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

protein

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

carbs

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

fat

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

fiber

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

\n {/* Minerals */}\n

\n Minerals\n

\n {(['sodium', 'potassium', 'calcium', 'iron', 'magnesium', 'zinc'] as const).map(key => {\n const info = NUTRIENT_INFO[key];\n const value = recipe.nutrition![key];\n return (\n

\n {formatNutrient(value, info.unit)}{info.unit}\n

{info.label}

\n );\n })}\n

\n \n {/* Vitamins */}\n

\n Vitamins\n

\n {(['vitaminA', 'vitaminC', 'vitaminD', 'vitaminE', 'vitaminK', 'vitaminB6'] as const).map(key => {\n const info = NUTRIENT_INFO[key];\n const value = recipe.nutrition![key];\n return (\n

\n {formatNutrient(value, info.unit)}{info.unit}\n

{info.label.replace('Vitamin ', 'Vit ')}

\n );\n })}\n

\n {(['vitaminB12', 'thiamin', 'riboflavin', 'niacin', 'folate'] as const).map(key => {\n const info = NUTRIENT_INFO[key];\n const value = recipe.nutrition![key];\n return (\n

\n {formatNutrient(value, info.unit)}{info.unit}\n

{info.label.replace('Vitamin ', 'B').replace(' (B1)', '').replace(' (B2)', '').replace(' (B3)', '')}

\n );\n })}\n

\n )}\n

\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 )}\n\n {/* Custom Foods Tab */}\n {activeTab === 'custom-foods' && (\n <>\n {filteredCustomFoods.length === 0 ? (\n

\n 🍎\n

\n {searchQuery ? 'No custom foods found' : 'No custom foods yet'}\n

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

\n ) : (\n

\n {filteredCustomFoods.map((food) => (\n

{food.name}

\n Per {food.servingSizeGrams}g serving\n

\n \n Custom\n \n

\n \n {/* Nutrition preview */}\n

\n {food.calories !== null && (\n \n {Math.round(food.calories)} kcal\n \n )}\n {food.protein !== null && (\n \n {Math.round(food.protein)}g protein\n \n )}\n {food.carbs !== null && (\n \n {Math.round(food.carbs)}g carbs\n \n )}\n {food.fat !== null && (\n \n {Math.round(food.fat)}g fat\n \n )}\n

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

\n setEditingCustomFood(food)}\n className=\"btn-secondary text-sm flex-1\"\n >\n Edit\n \n handleDeleteCustomFood(food.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 and instructions. You'll need to link ingredients to USDA foods for nutrition data.\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 {/* Create custom food modal */}\n {showCustomFoodForm && (\n setShowCustomFoodForm(false)}\n />\n )}\n \n {/* Edit custom food modal */}\n {editingCustomFood && (\n setEditingCustomFood(null)}\n />\n )}\n \n );\n}\n",[],[166,281,283],"f0a88956-db04-11f0-9ff7-42dde27851f2","RecipeForm.tsx","b8ea08ee-d3a9-11f0-8d63-42dde27851f2",108,["D",1765947471218],11,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateRecipeRequest, ParsedRecipeFromUrl, FDCDataType, FDCSearchResult, CreateRecipeIngredient, FDCFood, StarredIngredient } 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 // Store initial values for dirty checking\n const initialTitle = importedRecipe?.title || recipe?.title || '';\n const initialUrl = importedRecipe?.url || recipe?.url || '';\n const initialServingSize = importedRecipe?.servingSize?.toString() || recipe?.servingSize?.toString() || '1';\n const initialInstructions = importedRecipe?.instructions || recipe?.instructions || '';\n \n const [title, setTitle] = useState(initialTitle);\n const [url, setUrl] = useState(initialUrl);\n const [servingSize, setServingSize] = useState(initialServingSize);\n const [instructions, setInstructions] = useState(initialInstructions);\n const [ingredients, setIngredients] = useState(\n getInitialIngredients(recipe, importedRecipe)\n );\n const [submitting, setSubmitting] = useState(false);\n \n // Exit confirmation state\n const [showExitConfirm, setShowExitConfirm] = useState(false);\n \n // Track unmatched ingredients for passive alert\n const [unmatchedIngredients, setUnmatchedIngredients] = useState([]);\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 [fdcSearchLoading, setFdcSearchLoading] = useState(false);\n \n // Tabbed search results\n const [fdcActiveTab, setFdcActiveTab] = useState<'starred' | 'foundation' | 'branded'>('starred');\n const [fdcFoundationResults, setFdcFoundationResults] = useState([]);\n \n // Starred ingredients\n const [starredIngredients, setStarredIngredients] = useState([]);\n const [starredLoading, setStarredLoading] = useState(false);\n const [starredLoaded, setStarredLoaded] = useState(false);\n \n // Food detail view state\n const [fdcDetailFood, setFdcDetailFood] = useState(null);\n const [fdcDetailLoading, setFdcDetailLoading] = useState(false);\n const [fdcDetailSearchResult, setFdcDetailSearchResult] = useState(null);\n \n // Check if form has unsaved changes\n const hasUnsavedChanges = () => {\n if (title !== initialTitle) return true;\n if (url !== initialUrl) return true;\n if (servingSize !== initialServingSize) return true;\n if (instructions !== initialInstructions) return true;\n // Check if any ingredient has content\n const hasIngredientContent = ingredients.some(i => i.name.trim() || i.amount || i.notes.trim());\n if (hasIngredientContent) return true;\n return false;\n };\n \n // Handle close attempt (backdrop click or X button)\n const handleCloseAttempt = () => {\n if (hasUnsavedChanges()) {\n setShowExitConfirm(true);\n } else {\n onClose();\n }\n };\n const [fdcBrandedResults, setFdcBrandedResults] = useState([]);\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 // Load starred ingredients\n const loadStarredIngredients = async () => {\n if (starredLoaded) return;\n setStarredLoading(true);\n try {\n const response = await fetch('/api/fdc/starred');\n const result = await response.json();\n if (result.success) {\n setStarredIngredients(result.data);\n setStarredLoaded(true);\n }\n } catch (error) {\n console.error('Failed to load starred ingredients:', error);\n } finally {\n setStarredLoading(false);\n }\n };\n \n // Load starred ingredients on mount\n useEffect(() => {\n loadStarredIngredients();\n }, []);\n \n // Star an ingredient\n const starIngredient = async (food: FDCSearchResult | FDCFood) => {\n try {\n const response = await fetch('/api/fdc/starred', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n fdcId: food.fdcId,\n fdcDescription: food.description,\n fdcDataType: food.dataType,\n brandOwner: food.brandOwner || null,\n }),\n });\n const result = await response.json();\n if (result.success) {\n setStarredIngredients(prev => [result.data, ...prev]);\n }\n } catch (error) {\n console.error('Failed to star ingredient:', error);\n }\n };\n \n // Unstar an ingredient\n const unstarIngredient = async (fdcId: number) => {\n try {\n const response = await fetch(`/api/fdc/starred/${fdcId}`, { method: 'DELETE' });\n const result = await response.json();\n if (result.success) {\n setStarredIngredients(prev => prev.filter(s => s.fdcId !== fdcId));\n }\n } catch (error) {\n console.error('Failed to unstar ingredient:', error);\n }\n };\n \n // Check if an ingredient is starred\n const isStarred = (fdcId: number): boolean => {\n return starredIngredients.some(s => s.fdcId === fdcId);\n };\n \n // Open FDC search modal for an ingredient\n const openFdcSearch = (index: number) => {\n setFdcSearchIndex(index);\n setFdcSearchQuery(ingredients[index].name);\n setFdcFoundationResults([]);\n setFdcBrandedResults([]);\n setFdcActiveTab('starred'); // Start with starred tab\n setFdcDetailFood(null);\n setFdcDetailSearchResult(null);\n setFdcSearchOpen(true);\n };\n \n // Search FDC foods with categorized results\n const handleFdcSearch = async () => {\n if (!fdcSearchQuery.trim()) return;\n \n setFdcSearchLoading(true);\n try {\n const response = await fetch(`/api/fdc/search-categorized?query=${encodeURIComponent(fdcSearchQuery)}&pageSize=15`);\n const result = await response.json();\n \n if (result.success) {\n setFdcFoundationResults(result.data.foundation || []);\n setFdcBrandedResults(result.data.branded || []);\n }\n } catch (error) {\n console.error('FDC search failed:', error);\n } finally {\n setFdcSearchLoading(false);\n }\n };\n \n // View food details before selecting\n const viewFoodDetails = async (searchResult: FDCSearchResult) => {\n setFdcDetailLoading(true);\n setFdcDetailSearchResult(searchResult);\n try {\n const response = await fetch(`/api/fdc/food/${searchResult.fdcId}`);\n const result = await response.json();\n \n if (result.success) {\n setFdcDetailFood(result.data);\n }\n } catch (error) {\n console.error('Failed to fetch food details:', error);\n } finally {\n setFdcDetailLoading(false);\n }\n };\n \n // Go back from detail view to search results\n const backToSearchResults = () => {\n setFdcDetailFood(null);\n setFdcDetailSearchResult(null);\n };\n \n // Select food from detail view\n const selectFoodFromDetail = () => {\n if (fdcDetailSearchResult) {\n selectFdcFood(fdcDetailSearchResult);\n setFdcDetailFood(null);\n setFdcDetailSearchResult(null);\n }\n };\n \n // Count micronutrients that have data\n const countMicronutrients = (food: FDCFood): number => {\n const micronutrientKeys = [\n 'potassium', 'calcium', 'iron', 'magnesium', 'zinc',\n 'vitaminA', 'vitaminC', 'vitaminD', 'vitaminE', 'vitaminK',\n 'vitaminB6', 'vitaminB12', 'thiamin', 'riboflavin', 'niacin', 'folate'\n ] as const;\n \n return micronutrientKeys.filter(key => food.nutrition[key] !== null).length;\n };\n \n // Select an FDC food for an ingredient\n const selectFdcFood = (food: FDCSearchResult | StarredIngredient) => {\n if (fdcSearchIndex === null) return;\n \n const updated = [...ingredients];\n updated[fdcSearchIndex].fdcId = food.fdcId;\n updated[fdcSearchIndex].fdcDescription = food.fdcDescription ?? (food as FDCSearchResult).description;\n updated[fdcSearchIndex].fdcDataType = food.fdcDataType ?? (food as FDCSearchResult).dataType;\n setIngredients(updated);\n \n // Remove from unmatched if it was there\n setUnmatchedIngredients(prev => prev.filter(name => name !== updated[fdcSearchIndex].name));\n \n setFdcSearchOpen(false);\n setFdcSearchIndex(null);\n };\n \n // Select a starred ingredient directly (quick select)\n const selectStarredIngredient = (starred: StarredIngredient) => {\n if (fdcSearchIndex === null) return;\n \n const updated = [...ingredients];\n updated[fdcSearchIndex].fdcId = starred.fdcId;\n updated[fdcSearchIndex].fdcDescription = starred.fdcDescription;\n updated[fdcSearchIndex].fdcDataType = starred.fdcDataType;\n setIngredients(updated);\n \n // Remove from unmatched if it was there\n setUnmatchedIngredients(prev => prev.filter(name => name !== updated[fdcSearchIndex].name));\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 // Clear unmatched state\n setUnmatchedIngredients([]);\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 // Get ingredient names that don't have FDC links\n const unmatchedNames = ingredients\n .filter(i => i.name.trim() && !i.fdcId)\n .map(i => i.name.trim());\n \n let updatedIngredients = [...ingredients];\n const stillUnmatched: string[] = [];\n \n // Auto-match unlinked ingredients from Foundation Foods\n if (unmatchedNames.length > 0) {\n try {\n const matchResponse = await fetch('/api/fdc/auto-match-batch', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ ingredientNames: unmatchedNames }),\n });\n \n const matchResult = await matchResponse.json();\n \n if (matchResult.success) {\n // Apply matches to ingredients\n for (let i = 0; i < updatedIngredients.length; i++) {\n const ing = updatedIngredients[i];\n const name = ing.name.trim();\n \n if (name && !ing.fdcId && matchResult.data[name]) {\n const matchData = matchResult.data[name];\n if (matchData.match) {\n updatedIngredients[i] = {\n ...ing,\n fdcId: matchData.match.fdcId,\n fdcDescription: matchData.match.description,\n fdcDataType: matchData.match.dataType,\n };\n } else {\n stillUnmatched.push(name);\n }\n } else if (name && !ing.fdcId) {\n stillUnmatched.push(name);\n }\n }\n }\n } catch (error) {\n console.error('Auto-match failed:', error);\n // Continue with submission even if auto-match fails\n }\n }\n \n // Update state with matched ingredients\n setIngredients(updatedIngredients);\n setUnmatchedIngredients(stillUnmatched);\n \n // Build the recipe data\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: updatedIngredients\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 // Get current tab results\n const currentTabResults = fdcActiveTab === 'foundation' ? fdcFoundationResults : fdcBrandedResults;\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 {/* Passive alert for unmatched ingredients */}\n {unmatchedIngredients.length > 0 && (\n

\n \n

\n {unmatchedIngredients.length} ingredient(s) need manual linking:{' '}\n {unmatchedIngredients.join(', ')}. Click \"Link to USDA food\" to search manually.\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' : 'Foundation'}\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 Ingredients are auto-matched to Foundation Foods when you save. 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 {/* Exit Confirmation Dialog */}\n {showExitConfirm && (\n

setShowExitConfirm(false)}\n >\n

e.stopPropagation()}\n >\n

\n \n

Unsaved Changes

\n You have unsaved changes. What would you like to do?\n

\n {\n setShowExitConfirm(false);\n // Trigger form submission\n const form = document.querySelector('form');\n if (form) {\n form.requestSubmit();\n }\n }}\n className=\"btn-primary w-full flex items-center justify-center gap-2\"\n disabled={!title.trim()}\n >\n \n Save & Exit\n \n {\n setShowExitConfirm(false);\n onClose();\n }}\n className=\"btn-secondary w-full flex items-center justify-center gap-2 text-red-600 border-red-200 hover:bg-red-50\"\n >\n \n Discard & Exit\n \n setShowExitConfirm(false)}\n className=\"btn-secondary w-full flex items-center justify-center gap-2\"\n >\n \n Go Back\n \n

\n )}\n \n {/* FDC Search Modal with Tabs */}\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 {/* Tabs */}\n

\n setFdcActiveTab('starred')}\n className={`flex-1 px-4 py-3 text-sm font-medium transition-colors ${\n fdcActiveTab === 'starred'\n ? 'text-amber-600 border-b-2 border-amber-500 bg-amber-50'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-50'\n }`}\n >\n ★ Starred\n {starredIngredients.length > 0 && (\n \n {starredIngredients.length}\n \n )}\n \n setFdcActiveTab('foundation')}\n className={`flex-1 px-4 py-3 text-sm font-medium transition-colors ${\n fdcActiveTab === 'foundation'\n ? 'text-blue-600 border-b-2 border-blue-600 bg-blue-50'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-50'\n }`}\n >\n Foundation\n {fdcFoundationResults.length > 0 && (\n \n {fdcFoundationResults.length}\n \n )}\n \n setFdcActiveTab('branded')}\n className={`flex-1 px-4 py-3 text-sm font-medium transition-colors ${\n fdcActiveTab === 'branded'\n ? 'text-blue-600 border-b-2 border-blue-600 bg-blue-50'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-50'\n }`}\n >\n Branded\n {fdcBrandedResults.length > 0 && (\n \n {fdcBrandedResults.length}\n \n )}\n \n

\n \n

\n {/* Starred Ingredients Tab */}\n {fdcActiveTab === 'starred' && !fdcDetailFood && !fdcDetailLoading && (\n

\n {starredLoading ? (\n

\n \n

\n ) : starredIngredients.length === 0 ? (\n

⭐

No starred ingredients yet

\n Star your commonly used ingredients from the search results for quick access\n

\n ) : (\n

\n {starredIngredients.map((starred) => (\n \n unstarIngredient(starred.fdcId)}\n className=\"text-amber-500 hover:text-amber-600 flex-shrink-0\"\n title=\"Unstar\"\n >\n \n \n selectStarredIngredient(starred)}\n className=\"flex-1 text-left min-w-0\"\n >\n

{starred.fdcDescription}

\n \n {starred.fdcDataType}\n \n {starred.brandOwner && (\n {starred.brandOwner}\n )}\n

\n \n \n

\n ))}\n

\n )}\n

\n )}\n \n {/* Food Detail View */}\n {(fdcDetailFood || fdcDetailLoading) && (\n

\n {fdcDetailLoading ? (\n

\n \n

\n ) : fdcDetailFood && (\n

\n {/* Food Header */}\n

{fdcDetailFood.description}

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

\n {fdcDetailFood.householdServingText && (\n

\n Serving: {fdcDetailFood.householdServingText}\n {fdcDetailFood.servingSize && fdcDetailFood.servingSizeUnit && \n ` (${fdcDetailFood.servingSize}${fdcDetailFood.servingSizeUnit})`\n }\n

\n )}\n

\n \n {/* Nutrition Facts */}\n

Nutrition Facts

\n \n {/* Header Row */}\n

Per 100g

\n {fdcDetailFood.servingSize && fdcDetailFood.servingSizeUnit \n ? `Per Serving (${fdcDetailFood.servingSize}${fdcDetailFood.servingSizeUnit})`\n : 'Per Serving'\n }\n

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

\n {/* Calories */}\n

Calories

\n {fdcDetailFood.nutrition.calories !== null \n ? `${Math.round(fdcDetailFood.nutrition.calories)} kcal` \n : '—'}\n

\n {fdcDetailFood.nutrition.calories !== null && fdcDetailFood.servingSize\n ? `${Math.round(fdcDetailFood.nutrition.calories * fdcDetailFood.servingSize / 100)} kcal`\n : fdcDetailFood.nutrition.calories !== null ? `${Math.round(fdcDetailFood.nutrition.calories)} kcal` : '—'}\n

\n \n

\n \n {/* Protein */}\n

Protein

\n {fdcDetailFood.nutrition.protein !== null \n ? `${fdcDetailFood.nutrition.protein.toFixed(1)}g` \n : '—'}\n

\n {fdcDetailFood.nutrition.protein !== null && fdcDetailFood.servingSize\n ? `${(fdcDetailFood.nutrition.protein * fdcDetailFood.servingSize / 100).toFixed(1)}g`\n : fdcDetailFood.nutrition.protein !== null ? `${fdcDetailFood.nutrition.protein.toFixed(1)}g` : '—'}\n

\n \n {/* Fat */}\n

Fat

\n {fdcDetailFood.nutrition.fat !== null \n ? `${fdcDetailFood.nutrition.fat.toFixed(1)}g` \n : '—'}\n

\n {fdcDetailFood.nutrition.fat !== null && fdcDetailFood.servingSize\n ? `${(fdcDetailFood.nutrition.fat * fdcDetailFood.servingSize / 100).toFixed(1)}g`\n : fdcDetailFood.nutrition.fat !== null ? `${fdcDetailFood.nutrition.fat.toFixed(1)}g` : '—'}\n

\n \n {/* Carbs */}\n

Carbohydrates

\n {fdcDetailFood.nutrition.carbs !== null \n ? `${fdcDetailFood.nutrition.carbs.toFixed(1)}g` \n : '—'}\n

\n {fdcDetailFood.nutrition.carbs !== null && fdcDetailFood.servingSize\n ? `${(fdcDetailFood.nutrition.carbs * fdcDetailFood.servingSize / 100).toFixed(1)}g`\n : fdcDetailFood.nutrition.carbs !== null ? `${fdcDetailFood.nutrition.carbs.toFixed(1)}g` : '—'}\n

\n \n {/* Fiber */}\n

Fiber

\n {fdcDetailFood.nutrition.fiber !== null \n ? `${fdcDetailFood.nutrition.fiber.toFixed(1)}g` \n : '—'}\n

\n {fdcDetailFood.nutrition.fiber !== null && fdcDetailFood.servingSize\n ? `${(fdcDetailFood.nutrition.fiber * fdcDetailFood.servingSize / 100).toFixed(1)}g`\n : fdcDetailFood.nutrition.fiber !== null ? `${fdcDetailFood.nutrition.fiber.toFixed(1)}g` : '—'}\n

\n \n

\n \n {/* Sodium */}\n

Sodium

\n {fdcDetailFood.nutrition.sodium !== null \n ? `${Math.round(fdcDetailFood.nutrition.sodium)}mg` \n : '—'}\n

\n {fdcDetailFood.nutrition.sodium !== null && fdcDetailFood.servingSize\n ? `${Math.round(fdcDetailFood.nutrition.sodium * fdcDetailFood.servingSize / 100)}mg`\n : fdcDetailFood.nutrition.sodium !== null ? `${Math.round(fdcDetailFood.nutrition.sodium)}mg` : '—'}\n

\n \n {/* Micronutrients Count */}\n

\n Micronutrients available:\n \n {countMicronutrients(fdcDetailFood)} / 16\n \n

\n \n {/* Action Buttons */}\n

\n {/* Star/Unstar Button */}\n {isStarred(fdcDetailFood.fdcId) ? (\n unstarIngredient(fdcDetailFood.fdcId)}\n className=\"w-full py-2 px-4 rounded-lg border border-amber-300 bg-amber-50 text-amber-700 font-medium text-sm flex items-center justify-center gap-2 hover:bg-amber-100 transition-colors\"\n >\n \n Remove from Starred\n \n ) : (\n starIngredient(fdcDetailFood)}\n className=\"w-full py-2 px-4 rounded-lg border border-gray-300 bg-white text-gray-700 font-medium text-sm flex items-center justify-center gap-2 hover:bg-amber-50 hover:border-amber-300 hover:text-amber-700 transition-colors\"\n >\n \n Add to Starred\n \n )}\n \n

\n \n \n Back\n \n \n \n Select This Food\n \n

\n )}\n

\n )}\n \n {/* Search Results List (Foundation/Branded tabs only) */}\n {fdcActiveTab !== 'starred' && !fdcDetailFood && !fdcDetailLoading && (\n currentTabResults.length === 0 ? (\n

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

\n ) : (\n

\n {currentTabResults.map((food) => (\n \n {/* Star button */}\n {\n e.stopPropagation();\n if (isStarred(food.fdcId)) {\n unstarIngredient(food.fdcId);\n } else {\n starIngredient(food);\n }\n }}\n className={`flex-shrink-0 ${isStarred(food.fdcId) ? 'text-amber-500' : 'text-gray-300 hover:text-amber-400'}`}\n title={isStarred(food.fdcId) ? 'Unstar' : 'Add to starred'}\n >\n \n \n \n viewFoodDetails(food)}\n className=\"flex-1 text-left min-w-0\"\n >\n

{food.description}

\n \n {food.dataType}\n \n {food.micronutrientCount !== null && (\n = 12 \n ? 'bg-emerald-100 text-emerald-700' \n : food.micronutrientCount >= 6 \n ? 'bg-amber-100 text-amber-700' \n : 'bg-gray-100 text-gray-600'\n }`} title=\"Micronutrients available\">\n 🧬 {food.micronutrientCount}/16\n \n )}\n {food.brandOwner && (\n {food.brandOwner}\n )}\n

\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 );\n}\n",[],[166,281,292],"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",[],[166,281,301],"929802ce-db09-11f0-8d0c-42dde27851f2","MealPlanView.tsx","b9076826-d3a9-11f0-8004-42dde27851f2",113,["D",1765949460901],"/** @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, CustomFood, FDCSearchResult } from \"../../shared/types.ts\";\nimport { DAY_NAMES, MEAL_TYPES, MEAL_TYPE_LABELS } from \"../../shared/types.ts\";\n\ntype AddMealTab = 'recipes' | 'custom-foods' | 'ingredients';\n\ninterface MealPlanViewProps {\n recipes: Recipe[];\n customFoods: CustomFood[];\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, customFoods, 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 [addMealTab, setAddMealTab] = useState('recipes');\n const [showSchedule, setShowSchedule] = useState(false);\n const [scheduleRecipe, setScheduleRecipe] = useState('');\n const [scheduleMealType, setScheduleMealType] = useState('breakfast');\n const [scheduleDays, setScheduleDays] = useState([]);\n \n // FDC search state for ingredients tab\n const [fdcSearchQuery, setFdcSearchQuery] = useState('');\n const [fdcSearchResults, setFdcSearchResults] = useState([]);\n const [fdcSearchLoading, setFdcSearchLoading] = useState(false);\n const [selectedFdcId, setSelectedFdcId] = useState(null);\n const [fdcAmountGrams, setFdcAmountGrams] = useState('100');\n const [customFoodAmountGrams, setCustomFoodAmountGrams] = 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 handleAddRecipe = 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 handleAddCustomFood = async (customFoodId: string, food: CustomFood) => {\n if (!showAddMeal) return;\n \n const amountGrams = customFoodAmountGrams ? parseFloat(customFoodAmountGrams) : food.servingSizeGrams;\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 customFoodId,\n amountGrams,\n }),\n });\n \n if (response.ok) {\n await fetchMealPlan();\n setShowAddMeal(null);\n setCustomFoodAmountGrams('');\n }\n };\n\n const handleAddFdcIngredient = async () => {\n if (!showAddMeal || !selectedFdcId) return;\n \n const amountGrams = parseFloat(fdcAmountGrams) || 100;\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 fdcId: selectedFdcId,\n amountGrams,\n }),\n });\n \n if (response.ok) {\n await fetchMealPlan();\n setShowAddMeal(null);\n setSelectedFdcId(null);\n setFdcSearchQuery('');\n setFdcSearchResults([]);\n setFdcAmountGrams('100');\n }\n };\n\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)}`);\n const data = await response.json();\n if (data.success) {\n setFdcSearchResults(data.data);\n }\n } catch (err) {\n console.error('FDC search failed:', err);\n } finally {\n setFdcSearchLoading(false);\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 // Determine entry type and display info\n let name = 'Unknown';\n let calories: number | null = null;\n let badge: { text: string; color: string } | null = null;\n \n if (entry.recipeId && entry.recipe) {\n name = entry.recipe.title;\n calories = entry.recipe.nutrition?.calories ?? null;\n } else if (entry.customFoodId && entry.customFood) {\n name = entry.customFood.name;\n // Scale calories by amount\n const scale = (entry.amountGrams ?? entry.customFood.servingSizeGrams) / entry.customFood.servingSizeGrams;\n calories = entry.customFood.calories ? entry.customFood.calories * scale : null;\n badge = { text: 'Custom', color: 'bg-purple-100 text-purple-700' };\n } else if (entry.fdcId && entry.fdcFood) {\n name = entry.fdcFood.description;\n // FDC nutrition is per 100g\n const scale = (entry.amountGrams ?? 100) / 100;\n calories = entry.fdcFood.nutrition.calories ? entry.fdcFood.nutrition.calories * scale : null;\n badge = { text: 'USDA', color: 'bg-green-100 text-green-700' };\n }\n \n return (\n \n

\n \n {name}\n \n {badge && (\n \n {badge.text}\n \n )}\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 {calories !== null && (\n \n {Math.round(calories)} kcal\n \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 - with tabs for recipes, custom foods, and ingredients */}\n {showAddMeal && (\n

setShowAddMeal(null)}>\n

e.stopPropagation()}>\n

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

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

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

\n \n

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

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

\n ) : (\n

\n {recipes.map((recipe) => (\n handleAddRecipe(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 {Math.round(recipe.nutrition.calories)} kcal per serving\n

\n )}\n

\n \n \n ))}\n

\n )}\n \n )}\n \n {/* Custom Foods Tab */}\n {addMealTab === 'custom-foods' && (\n <>\n {customFoods.length === 0 ? (\n

\n No custom foods yet. Create one in the Recipes tab.\n

\n ) : (\n

\n {customFoods.map((food) => (\n

\n {food.name}\n Custom\n

\n {food.calories && (\n

\n {Math.round(food.calories)} kcal per {food.servingSizeGrams}g\n

\n )}\n

\n setCustomFoodAmountGrams(e.target.value)}\n className=\"input w-24 text-sm py-1\"\n min=\"1\"\n />\n grams\n handleAddCustomFood(food.id, food)}\n className=\"btn-primary text-sm py-1 px-3 ml-auto\"\n >\n Add\n \n

\n ))}\n

\n )}\n \n )}\n \n {/* USDA Foods/Ingredients Tab */}\n {addMealTab === 'ingredients' && (\n

\n {/* Search */}\n

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

\n \n {/* Search results */}\n {fdcSearchResults.length > 0 && (\n

\n {fdcSearchResults.map((result) => (\n setSelectedFdcId(result.fdcId)}\n className={`w-full p-2 text-left rounded-lg border transition-colors ${\n selectedFdcId === result.fdcId\n ? 'border-blue-500 bg-blue-50'\n : 'border-gray-200 hover:bg-gray-50'\n }`}\n >\n

{result.description}

\n \n {result.dataType === 'Branded' ? 'Branded' : 'USDA'}\n \n {result.brandOwner && {result.brandOwner}}\n

\n \n ))}\n

\n )}\n \n {/* Amount and Add button */}\n {selectedFdcId && (\n

\n Amount:\n setFdcAmountGrams(e.target.value)}\n className=\"input w-24 text-sm py-1\"\n min=\"1\"\n />\n grams\n \n Add to Meal\n \n

\n )}\n

\n \n

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

setShowSchedule(false)}>\n

e.stopPropagation()}>\n

Schedule Meals

Add a recipe to multiple days at once

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

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

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

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

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

\n Days\n

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

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

\n \n \n Schedule\n \n

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

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

Grocery Lists

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

\n \n {showNewListForm && (\n

\n \n

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

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

\n ) : (\n

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

{list.name}

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

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

\n ))}\n

\n )}\n

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

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

{selectedList.name}

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

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

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

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

\n 🛒\n

No items yet

Add items or import from a recipe

\n ) : (\n

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

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

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

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

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

\n ))}\n

\n )}\n

\n \n ) : (\n

\n 👈\n

Select a list to view items

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

setShowAddItem(false)}>\n

e.stopPropagation()}>\n

Add Item

\n \n

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

setShowAddRecipe(false)}>\n

e.stopPropagation()}>\n

Add Recipe Ingredients

Select a recipe to add all its ingredients

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

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

\n ) : (\n

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

{recipe.title}

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

\n \n \n ))}\n

\n )}\n

\n \n

\n )}\n \n );\n}\n\n",[],[166,281,325],"92a69438-db09-11f0-a68d-42dde27851f2","CustomFoodForm.tsx","92a694ec-db09-11f0-a68d-42dde27851f2",114,["D",1765949460842],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CustomFood, CreateCustomFoodRequest } from \"../../shared/types.ts\";\nimport { NUTRIENT_INFO, NutrientKey } from \"../../shared/types.ts\";\n\ninterface CustomFoodFormProps {\n customFood?: CustomFood;\n onSubmit: (data: CreateCustomFoodRequest) => Promise;\n onClose: () => void;\n}\n\n// Nutrient keys grouped by category\nconst MACRO_KEYS: NutrientKey[] = ['calories', 'protein', 'fat', 'carbs', 'fiber'];\nconst MINERAL_KEYS: NutrientKey[] = ['sodium', 'potassium', 'calcium', 'iron', 'magnesium', 'zinc'];\nconst VITAMIN_KEYS: NutrientKey[] = ['vitaminA', 'vitaminC', 'vitaminD', 'vitaminE', 'vitaminK', 'vitaminB6', 'vitaminB12', 'thiamin', 'riboflavin', 'niacin', 'folate'];\n\nexport function CustomFoodForm({ customFood, onSubmit, onClose }: CustomFoodFormProps) {\n const [name, setName] = useState(customFood?.name || '');\n const [servingSizeGrams, setServingSizeGrams] = useState(customFood?.servingSizeGrams?.toString() || '100');\n const [nutrients, setNutrients] = useState>(() => {\n const initial: Record = {};\n const allKeys = [...MACRO_KEYS, ...MINERAL_KEYS, ...VITAMIN_KEYS];\n for (const key of allKeys) {\n const value = customFood?.[key as keyof CustomFood];\n initial[key] = value !== null && value !== undefined ? value.toString() : '';\n }\n return initial as Record;\n });\n const [submitting, setSubmitting] = useState(false);\n const [showMicronutrients, setShowMicronutrients] = useState(false);\n\n const handleNutrientChange = (key: NutrientKey, value: string) => {\n setNutrients(prev => ({ ...prev, [key]: value }));\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!name.trim()) return;\n\n setSubmitting(true);\n try {\n const data: CreateCustomFoodRequest = {\n name: name.trim(),\n servingSizeGrams: parseFloat(servingSizeGrams) || 100,\n };\n\n // Add all nutrient values\n const allKeys = [...MACRO_KEYS, ...MINERAL_KEYS, ...VITAMIN_KEYS];\n for (const key of allKeys) {\n const value = nutrients[key];\n if (value !== '') {\n (data as any)[key] = parseFloat(value) || null;\n } else {\n (data as any)[key] = null;\n }\n }\n\n await onSubmit(data);\n } finally {\n setSubmitting(false);\n }\n };\n\n const renderNutrientInput = (key: NutrientKey) => {\n const info = NUTRIENT_INFO[key];\n return (\n

\n \n {info.label} ({info.unit})\n \n handleNutrientChange(key, e.target.value)}\n className=\"input text-sm py-1.5\"\n placeholder=\"0\"\n />\n

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

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

\n {/* Header */}\n

\n {customFood ? 'Edit Custom Food' : 'Add Custom Food'}\n

\n \n \n \n

\n Create a food with custom nutrition values\n

\n\n {/* Scrollable content */}\n

\n {/* Name */}\n

\n \n Name *\n \n setName(e.target.value)}\n className=\"input\"\n placeholder=\"e.g., Homemade Protein Shake\"\n required\n />\n

\n\n {/* Serving Size */}\n

\n \n Serving Size (grams)\n \n setServingSizeGrams(e.target.value)}\n className=\"input w-32\"\n placeholder=\"100\"\n />\n

\n Nutrition values are per this serving size\n

\n\n {/* Macronutrients */}\n

Macronutrients

\n {MACRO_KEYS.map(key => renderNutrientInput(key))}\n

\n\n {/* Toggle for micronutrients */}\n

\n setShowMicronutrients(!showMicronutrients)}\n className=\"text-sm font-medium flex items-center gap-2 hover:text-gray-900\"\n style={{ color: '#0f2763' }}\n >\n \n \n \n {showMicronutrients ? 'Hide' : 'Show'} Vitamins & Minerals (optional)\n \n

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

\n {/* Minerals */}\n

Minerals

\n {MINERAL_KEYS.map(key => renderNutrientInput(key))}\n

\n\n {/* Vitamins */}\n

Vitamins

\n {VITAMIN_KEYS.map(key => renderNutrientInput(key))}\n

\n )}\n

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

\n \n Cancel\n \n \n {submitting ? 'Saving...' : customFood ? 'Save Changes' : 'Create Food'}\n \n

\n \n );\n}\n\n",[],[166,281,333],"92f4c72a-db09-11f0-b8e0-42dde27851f2","App.tsx","b8d991d0-d3a9-11f0-8d63-42dde27851f2",119,["D",1765949460847],"/** @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, CustomFood } 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 [customFoods, setCustomFoods] = 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 custom foods\n const fetchCustomFoods = useCallback(async () => {\n try {\n const response = await fetch('/api/custom-foods');\n const data = await response.json();\n if (data.success) {\n setCustomFoods(data.data);\n }\n } catch (err) {\n console.error('Failed to fetch custom foods:', 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 fetchCustomFoods(),\n fetchGroceryLists(),\n fetchNutritionGoals(),\n ]).finally(() => {\n setLoading(false);\n });\n } else if (user === null) {\n setLoading(false);\n }\n }, [user, fetchRecipes, fetchCustomFoods, fetchGroceryLists, fetchNutritionGoals]);\n\n const handleLogout = async () => {\n try {\n await fetch('/api/auth/logout', { method: 'POST' });\n setUser(null);\n setRecipes([]);\n setCustomFoods([]);\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",[],[166,281,341],"b86d0600-d3a9-11f0-b1e3-42dde27851f2",["D",1765138634552],[208,209,210,211,212,213,214,215,216],[166,281],["D",1765138634122],[207,217,218,219],[166],"937c6518-db09-11f0-82a1-42dde27851f2","index.ts",121,["D",1765949461117],"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 { fdcRoutes } from \"./routes/fdc.ts\";\nimport { customFoodsRoutes } from \"./routes/custom-foods.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);\napp.route('/api/fdc', fdcRoutes);\napp.route('/api/custom-foods', customFoodsRoutes);\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",[],[172,356],"da6935b0-dbc6-11f0-b48a-42dde27851f2","nutrition-calculator.ts","6a3733ee-da38-11f0-8a3d-42dde27851f2","6a0c0b60-da38-11f0-8f3b-42dde27851f2",131,["D",1766030756263],"// 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 null; // Don't 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 * (ingredient.amount || 1);\n }\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",[],[172,372,364],"services","e33fd18c-dbbf-11f0-b7bf-42dde27851f2","fdc-client.ts","6a3ab8ca-da38-11f0-8f3b-42dde27851f2",126,["D",1766027764613],"// USDA FoodData Central API Client\n// Documentation: https://fdc.nal.usda.gov/api-guide.html\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { FDC_FOODS_CACHE_TABLE } from \"../database/migrations.ts\";\nimport type { FDCFood, FDCNutrition, FDCSearchResult, FDCDataType } from \"../../shared/types.ts\";\n\nconst FDC_API_BASE = \"https://api.nal.usda.gov/fdc/v1\";\n\n// USDA FDC Nutrient IDs (per USDA FDC documentation)\nconst NUTRIENT_IDS = {\n calories: 1008, // Energy (kcal)\n protein: 1003, // Protein\n fat: 1004, // Total lipid (fat)\n carbs: 1005, // Carbohydrate, by difference\n fiber: 1079, // Fiber, total dietary\n sodium: 1093, // Sodium, Na\n potassium: 1092, // Potassium, K\n calcium: 1087, // Calcium, Ca\n iron: 1089, // Iron, Fe\n magnesium: 1090, // Magnesium, Mg\n zinc: 1095, // Zinc, Zn\n vitaminA: 1106, // Vitamin A, RAE\n vitaminC: 1162, // Vitamin C, total ascorbic acid\n vitaminD: 1114, // Vitamin D (D2 + D3)\n vitaminE: 1109, // Vitamin E (alpha-tocopherol)\n vitaminK: 1185, // Vitamin K (phylloquinone)\n vitaminB6: 1175, // Vitamin B-6\n vitaminB12: 1178, // Vitamin B-12\n thiamin: 1165, // Thiamin\n riboflavin: 1166, // Riboflavin\n niacin: 1167, // Niacin\n folate: 1177, // Folate, total\n};\n\nfunction getApiKey(): string {\n const apiKey = Deno.env.get(\"FDC_API_KEY\");\n if (!apiKey) {\n throw new Error(\"FDC_API_KEY environment variable is not set\");\n }\n return apiKey;\n}\n\n// Micronutrient IDs for counting available data\nconst MICRONUTRIENT_IDS = [\n NUTRIENT_IDS.potassium,\n NUTRIENT_IDS.calcium,\n NUTRIENT_IDS.iron,\n NUTRIENT_IDS.magnesium,\n NUTRIENT_IDS.zinc,\n NUTRIENT_IDS.vitaminA,\n NUTRIENT_IDS.vitaminC,\n NUTRIENT_IDS.vitaminD,\n NUTRIENT_IDS.vitaminE,\n NUTRIENT_IDS.vitaminK,\n NUTRIENT_IDS.vitaminB6,\n NUTRIENT_IDS.vitaminB12,\n NUTRIENT_IDS.thiamin,\n NUTRIENT_IDS.riboflavin,\n NUTRIENT_IDS.niacin,\n NUTRIENT_IDS.folate,\n];\n\n// Count micronutrients from food nutrients array\nfunction countMicronutrientsFromNutrients(nutrients: any[]): number {\n if (!nutrients || !Array.isArray(nutrients)) return 0;\n\n let count = 0;\n for (const nutrientId of MICRONUTRIENT_IDS) {\n const nutrient = nutrients.find((n: any) =>\n n.nutrientId === nutrientId || n.nutrient?.id === nutrientId\n );\n if (nutrient && (nutrient.amount != null || nutrient.value != null)) {\n count++;\n }\n }\n return count;\n}\n\n// Search FDC foods\nexport async function searchFDCFoods(\n query: string,\n options?: {\n dataType?: FDCDataType[];\n pageSize?: number;\n pageNumber?: number;\n sortBy?: string;\n sortOrder?: 'asc' | 'desc';\n }\n): Promise {\n const apiKey = getApiKey();\n const pageSize = options?.pageSize ?? 25;\n const pageNumber = options?.pageNumber ?? 1;\n\n // Build data type filter\n const dataTypes = options?.dataType ?? ['Branded', 'Foundation', 'SR Legacy'];\n\n const response = await fetch(`${FDC_API_BASE}/foods/search?api_key=${apiKey}`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n query: query.trim(),\n dataType: dataTypes,\n pageSize,\n pageNumber,\n sortBy: options?.sortBy,\n sortOrder: options?.sortOrder,\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`FDC API search failed: ${response.status} ${errorText}`);\n }\n\n const data = await response.json();\n\n return (data.foods || []).map((food: any) => ({\n fdcId: food.fdcId,\n description: food.description,\n dataType: food.dataType,\n brandOwner: food.brandOwner || null,\n brandName: food.brandName || null,\n score: food.score || 0,\n micronutrientCount: food.foodNutrients\n ? countMicronutrientsFromNutrients(food.foodNutrients)\n : null,\n }));\n}\n\n// Extract nutrition from FDC food nutrients array\nfunction extractNutrition(nutrients: any[]): FDCNutrition {\n const getNutrientValue = (nutrientId: number): number | null => {\n const nutrient = nutrients.find((n: any) => n.nutrientId === nutrientId || n.nutrient?.id === nutrientId);\n if (!nutrient) return null;\n return nutrient.amount ?? nutrient.value ?? null;\n };\n\n return {\n calories: getNutrientValue(NUTRIENT_IDS.calories),\n protein: getNutrientValue(NUTRIENT_IDS.protein),\n fat: getNutrientValue(NUTRIENT_IDS.fat),\n carbs: getNutrientValue(NUTRIENT_IDS.carbs),\n fiber: getNutrientValue(NUTRIENT_IDS.fiber),\n sodium: getNutrientValue(NUTRIENT_IDS.sodium),\n potassium: getNutrientValue(NUTRIENT_IDS.potassium),\n calcium: getNutrientValue(NUTRIENT_IDS.calcium),\n iron: getNutrientValue(NUTRIENT_IDS.iron),\n magnesium: getNutrientValue(NUTRIENT_IDS.magnesium),\n zinc: getNutrientValue(NUTRIENT_IDS.zinc),\n vitaminA: getNutrientValue(NUTRIENT_IDS.vitaminA),\n vitaminC: getNutrientValue(NUTRIENT_IDS.vitaminC),\n vitaminD: getNutrientValue(NUTRIENT_IDS.vitaminD),\n vitaminE: getNutrientValue(NUTRIENT_IDS.vitaminE),\n vitaminK: getNutrientValue(NUTRIENT_IDS.vitaminK),\n vitaminB6: getNutrientValue(NUTRIENT_IDS.vitaminB6),\n vitaminB12: getNutrientValue(NUTRIENT_IDS.vitaminB12),\n thiamin: getNutrientValue(NUTRIENT_IDS.thiamin),\n riboflavin: getNutrientValue(NUTRIENT_IDS.riboflavin),\n niacin: getNutrientValue(NUTRIENT_IDS.niacin),\n folate: getNutrientValue(NUTRIENT_IDS.folate),\n };\n}\n\n// Get detailed food info from FDC API\nexport async function getFDCFoodFromApi(fdcId: number): Promise {\n const apiKey = getApiKey();\n\n const response = await fetch(`${FDC_API_BASE}/food/${fdcId}?api_key=${apiKey}`);\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`FDC API food fetch failed: ${response.status} ${errorText}`);\n }\n\n const food = await response.json();\n\n // Extract nutrients (different structure for different data types)\n const nutrients = food.foodNutrients || [];\n\n return {\n fdcId: food.fdcId,\n description: food.description,\n dataType: food.dataType,\n brandOwner: food.brandOwner || null,\n brandName: food.brandName || null,\n servingSize: food.servingSize || null,\n servingSizeUnit: food.servingSizeUnit || null,\n householdServingText: food.householdServingFullText || null,\n nutrition: extractNutrition(nutrients),\n cachedAt: new Date().toISOString(),\n };\n}\n\n// Cache FDC food to database\nexport async function cacheFDCFood(food: FDCFood): Promise {\n const n = food.nutrition;\n\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${FDC_FOODS_CACHE_TABLE} (\n fdc_id, description, data_type, brand_owner, brand_name,\n serving_size, serving_size_unit, household_serving_text,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n magnesium, zinc, cached_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n food.fdcId, food.description, food.dataType, food.brandOwner, food.brandName,\n food.servingSize, food.servingSizeUnit, food.householdServingText,\n n.calories, n.protein, n.fat, n.carbs, n.fiber,\n n.sodium, n.potassium, n.calcium, n.iron,\n n.vitaminA, n.vitaminC, n.vitaminD, n.vitaminE, n.vitaminK,\n n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin, n.folate,\n n.magnesium, n.zinc, food.cachedAt,\n ]);\n}\n\n// Get FDC food from cache\nexport async function getFDCFoodFromCache(fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${FDC_FOODS_CACHE_TABLE} WHERE fdc_id = ?`,\n [fdcId]\n );\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n fdcId: row.fdc_id as number,\n description: row.description as string,\n dataType: row.data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n brandName: row.brand_name as string | null,\n servingSize: row.serving_size as number | null,\n servingSizeUnit: row.serving_size_unit as string | null,\n householdServingText: row.household_serving_text as string | null,\n nutrition: {\n calories: row.calories as number | null,\n protein: row.protein as number | null,\n fat: row.fat as number | null,\n carbs: row.carbs as number | null,\n fiber: row.fiber as number | null,\n sodium: row.sodium as number | null,\n potassium: row.potassium as number | null,\n calcium: row.calcium as number | null,\n iron: row.iron as number | null,\n magnesium: row.magnesium as number | null,\n zinc: row.zinc as number | null,\n vitaminA: row.vitamin_a as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k as number | null,\n vitaminB6: row.vitamin_b6 as number | null,\n vitaminB12: row.vitamin_b12 as number | null,\n thiamin: row.thiamin as number | null,\n riboflavin: row.riboflavin as number | null,\n niacin: row.niacin as number | null,\n folate: row.folate as number | null,\n },\n cachedAt: row.cached_at as string,\n };\n}\n\n// Get FDC food with caching (fetches from API if not cached or cache is old)\nexport async function getFDCFood(fdcId: number, maxCacheAgeHours = 24 * 7): Promise {\n // Try cache first\n const cached = await getFDCFoodFromCache(fdcId);\n\n if (cached) {\n // Check if cache is still valid\n const cacheAge = Date.now() - new Date(cached.cachedAt).getTime();\n const maxAge = maxCacheAgeHours * 60 * 60 * 1000;\n\n if (cacheAge < maxAge) {\n return cached;\n }\n }\n\n // Fetch from API\n const food = await getFDCFoodFromApi(fdcId);\n\n // Cache the result\n await cacheFDCFood(food);\n\n return food;\n}\n\n// Get multiple FDC foods (batch with caching)\nexport async function getFDCFoods(fdcIds: number[]): Promise> {\n const result = new Map();\n const toFetch: number[] = [];\n\n // Check cache for each\n for (const fdcId of fdcIds) {\n const cached = await getFDCFoodFromCache(fdcId);\n if (cached) {\n const cacheAge = Date.now() - new Date(cached.cachedAt).getTime();\n const maxAge = 24 * 7 * 60 * 60 * 1000; // 7 days\n if (cacheAge < maxAge) {\n result.set(fdcId, cached);\n continue;\n }\n }\n toFetch.push(fdcId);\n }\n\n // Fetch missing from API (one by one to avoid rate limits)\n for (const fdcId of toFetch) {\n try {\n const food = await getFDCFoodFromApi(fdcId);\n await cacheFDCFood(food);\n result.set(fdcId, food);\n } catch (error) {\n console.error(`Failed to fetch FDC food ${fdcId}:`, error);\n }\n }\n\n return result;\n}\n\n// Auto-match ingredient name to FDC food (Foundation Foods only)\nexport async function autoMatchIngredient(ingredientName: string): Promise<{\n match: FDCSearchResult | null;\n confidence: number;\n alternatives: FDCSearchResult[];\n}> {\n // Clean up ingredient name for better matching\n const cleanName = ingredientName\n .toLowerCase()\n .replace(/[,()]/g, ' ')\n .replace(/\\s+/g, ' ')\n .trim();\n\n // Search only Foundation Foods and SR Legacy for auto-matching (not Branded)\n const results = await searchFDCFoods(cleanName, {\n dataType: ['Foundation', 'SR Legacy'],\n pageSize: 5\n });\n\n if (results.length === 0) {\n return { match: null, confidence: 0, alternatives: [] };\n }\n\n // Return the first result as the match (per user request)\n return {\n match: results[0],\n confidence: 100,\n alternatives: results.slice(1, 5),\n };\n}\n\n",[],[172,372,374],"6a0c0aa2-da38-11f0-8f3b-42dde27851f2",85,["D",1765859628057],[203,204],[172,372],"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",[],[172,395,387],"routes","9dbacb2c-dbc3-11f0-a82a-42dde27851f2","recipes.ts","b91aea68-d3a9-11f0-897f-42dde27851f2",128,["D",1766029365973],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport * as cheerio from \"https://esm.sh/cheerio@1.0.0-rc.12\";\nimport { parseIngredient as sharpParseIngredient } from \"https://esm.sh/@jlucaspains/sharp-recipe-parser@1.1.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 // Note: nutrition is now calculated from FDC-linked ingredients, not passed in\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 );\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 // Note: nutrition is recalculated from FDC-linked ingredients when ingredients change\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 });\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// Map full unit names to Carmy's canonical shorthands\nconst UNIT_SHORTHANDS: Record = {\n 'tablespoon': 'tbsp',\n 'teaspoon': 'tsp',\n 'pound': 'lb',\n 'gram': 'g',\n 'ounce': 'oz',\n 'milliliter': 'ml',\n};\n\n// Normalize ingredient text to handle specific edge cases\nexport function normalizeIngredientText(text: string): string {\n let normalized = text.trim();\n\n // Rule 1: Add space between number and unit (e.g., 500g -> 500 g)\n normalized = normalized.replace(/(\\d+)([a-zA-Z]+)/g, '$1 $2');\n\n // Rule 2: Handle \"T\" as tablespoon (both parsers often mistake it for teaspoon)\n // Only match \"T\" as a standalone word (possibly with punctuation)\n normalized = normalized.replace(/\\bT\\b/g, 'tablespoon');\n\n return normalized;\n}\n\n// Extract notes from ingredient string using Sharp's result or fallback\nfunction extractNotes(originalText: string, sharpExtra: string, parsedIngredient: string): string | null {\n // If Sharp found an \"extra\", use it\n if (sharpExtra && sharpExtra.length > 1) {\n return sharpExtra.trim();\n }\n\n // Fallback: Check for parentheticals or commas in the original text that might have been missed\n const notesPatterns = [\n /,\\s*(.+)$/, // Everything after comma\n /\$([^)]+)\$/, // Parenthetical notes\n ];\n\n for (const pattern of notesPatterns) {\n const match = originalText.match(pattern);\n if (match && match[1]) {\n const note = match[1].trim();\n // Only use if it's not the same as the ingredient name\n if (note.toLowerCase() !== parsedIngredient.toLowerCase()) {\n return note;\n }\n }\n }\n\n return null;\n}\n\n// Parse a single ingredient string into structured data\nexport function parseIngredientString(text: string): {\n name: string;\n amount: number | null;\n unit: string | null;\n notes: string | null;\n originalText: string;\n} {\n const originalText = text.trim();\n const normalizedText = normalizeIngredientText(originalText);\n\n try {\n // Use @jlucaspains/sharp-recipe-parser\n const parsed = sharpParseIngredient(normalizedText, 'en');\n\n // Extract notes\n const notes = extractNotes(\n originalText,\n parsed.extra,\n parsed.ingredient\n );\n\n // Map to canonical shorthands if possible\n let unit = parsed.unit || null;\n if (unit && UNIT_SHORTHANDS[unit.toLowerCase()]) {\n unit = UNIT_SHORTHANDS[unit.toLowerCase()];\n }\n\n return {\n name: parsed.ingredient || originalText,\n amount: parsed.quantity || null,\n unit,\n notes,\n originalText,\n };\n } catch (e) {\n // Fallback: return the whole string as the ingredient name\n return {\n name: originalText,\n amount: null,\n unit: null,\n notes: null,\n originalText,\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",[],[172,395,397],"92e5417e-db09-11f0-b9b4-42dde27851f2","nutrition.ts","b92224d6-d3a9-11f0-893e-42dde27851f2",118,["D",1765949461397],"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, NutrientKey, RecipeNutrition, CustomFood, FDCNutrition, MealPlanEntry } from \"../../shared/types.ts\";\nimport { createEmptyDailyNutrition } from \"../../shared/types.ts\";\n\nconst nutritionRoutes = new Hono();\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// 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 (now with all micronutrients)\n const dailyNutrition: Record = {};\n \n for (let day = 0; day < 7; day++) {\n dailyNutrition[day] = createEmptyDailyNutrition();\n }\n \n if (mealPlan) {\n for (const entry of mealPlan.entries) {\n const day = entry.dayOfWeek;\n \n if (entry.recipeId && entry.recipe?.nutrition) {\n // Recipe entry - multiply nutrition per serving by servings\n const n = entry.recipe.nutrition;\n const servings = entry.servings;\n \n for (const key of NUTRIENT_KEYS) {\n const value = n[key as keyof RecipeNutrition];\n if (typeof value === 'number') {\n dailyNutrition[day][key] += value * servings;\n }\n }\n } else if (entry.customFoodId && entry.customFood) {\n // Custom food entry - scale by amountGrams / servingSizeGrams\n const cf = entry.customFood;\n const scaleFactor = (entry.amountGrams ?? cf.servingSizeGrams) / cf.servingSizeGrams;\n \n for (const key of NUTRIENT_KEYS) {\n const value = cf[key as keyof CustomFood];\n if (typeof value === 'number') {\n dailyNutrition[day][key] += value * scaleFactor;\n }\n }\n } else if (entry.fdcId && entry.fdcFood) {\n // FDC ingredient entry - nutrition is per 100g, scale by amountGrams / 100\n const fdc = entry.fdcFood.nutrition;\n const amountGrams = entry.amountGrams ?? 100;\n const scaleFactor = amountGrams / 100;\n \n for (const key of NUTRIENT_KEYS) {\n const value = fdc[key as keyof FDCNutrition];\n if (typeof value === 'number') {\n dailyNutrition[day][key] += value * scaleFactor;\n }\n }\n }\n }\n }\n \n // Calculate weekly average\n const weeklyAverage: DailyNutrition = createEmptyDailyNutrition();\n \n let daysWithMeals = 0;\n for (let day = 0; day < 7; day++) {\n const d = dailyNutrition[day];\n // Check if any nutrition value is present\n const hasNutrition = NUTRIENT_KEYS.some(key => d[key] > 0);\n \n if (hasNutrition) {\n daysWithMeals++;\n for (const key of NUTRIENT_KEYS) {\n weeklyAverage[key] += d[key];\n }\n }\n }\n \n if (daysWithMeals > 0) {\n for (const key of NUTRIENT_KEYS) {\n weeklyAverage[key] /= daysWithMeals;\n }\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",[],[172,395,405],"92cfeaae-db09-11f0-882a-42dde27851f2","meal-plans.ts","b91726c6-d3a9-11f0-9cb5-42dde27851f2",117,["D",1765949461269],"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 (supports recipes, custom foods, and FDC ingredients)\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) {\n return c.json({ success: false, error: 'Missing required fields' }, 400);\n }\n \n // Validate that exactly one of recipeId, customFoodId, or fdcId is provided\n const idCount = [body.recipeId, body.customFoodId, body.fdcId].filter(Boolean).length;\n if (idCount !== 1) {\n return c.json({ success: false, error: 'Exactly one of recipeId, customFoodId, or fdcId must be provided' }, 400);\n }\n \n const entry = await addMealPlanEntry(\n user.id,\n body.weekStartDate,\n body.dayOfWeek,\n body.mealType,\n {\n recipeId: body.recipeId,\n customFoodId: body.customFoodId,\n fdcId: body.fdcId,\n servings: body.servings || 1,\n amountGrams: body.amountGrams,\n }\n );\n \n if (!entry) {\n return c.json({ success: false, error: 'Failed to add entry (item 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",[],[172,395,413],"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",[],[172,395,421],"530012e4-dbc9-11f0-8756-42dde27851f2",["D",1766031817577],[],[172,395,33],"928db6e8-db09-11f0-8d0c-42dde27851f2","custom-foods.ts","928db788-db09-11f0-8d0c-42dde27851f2",111,["D",1765949460836],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { requireAuth } from \"../middleware/session.ts\";\nimport {\n getCustomFoodsByUser,\n getCustomFoodById,\n createCustomFood,\n updateCustomFood,\n deleteCustomFood,\n} from \"../database/queries.ts\";\nimport type { CreateCustomFoodRequest } from \"../../shared/types.ts\";\n\nconst customFoodsRoutes = new Hono();\n\n// Get all custom foods for the user\ncustomFoodsRoutes.get('/', async (c) => {\n const user = requireAuth(c);\n const customFoods = await getCustomFoodsByUser(user.id);\n return c.json({ success: true, data: customFoods });\n});\n\n// Get a single custom food\ncustomFoodsRoutes.get('/:id', async (c) => {\n const user = requireAuth(c);\n const customFoodId = c.req.param('id');\n \n const customFood = await getCustomFoodById(customFoodId, user.id);\n \n if (!customFood) {\n return c.json({ success: false, error: 'Custom food not found' }, 404);\n }\n \n return c.json({ success: true, data: customFood });\n});\n\n// Create a new custom food\ncustomFoodsRoutes.post('/', async (c) => {\n const user = requireAuth(c);\n const body: CreateCustomFoodRequest = await c.req.json();\n \n if (!body.name || body.name.trim() === '') {\n return c.json({ success: false, error: 'Name is required' }, 400);\n }\n \n const customFood = await createCustomFood(user.id, {\n ...body,\n name: body.name.trim(),\n });\n \n return c.json({ success: true, data: customFood });\n});\n\n// Update a custom food\ncustomFoodsRoutes.patch('/:id', async (c) => {\n const user = requireAuth(c);\n const customFoodId = c.req.param('id');\n const body: Partial = await c.req.json();\n \n // Trim name if provided\n if (body.name !== undefined) {\n body.name = body.name.trim();\n if (body.name === '') {\n return c.json({ success: false, error: 'Name cannot be empty' }, 400);\n }\n }\n \n const customFood = await updateCustomFood(customFoodId, user.id, body);\n \n if (!customFood) {\n return c.json({ success: false, error: 'Custom food not found' }, 404);\n }\n \n return c.json({ success: true, data: customFood });\n});\n\n// Delete a custom food\ncustomFoodsRoutes.delete('/:id', async (c) => {\n const user = requireAuth(c);\n const customFoodId = c.req.param('id');\n \n const deleted = await deleteCustomFood(customFoodId, user.id);\n \n if (!deleted) {\n return c.json({ success: false, error: 'Custom food not found' }, 404);\n }\n \n return c.json({ success: true });\n});\n\nexport { customFoodsRoutes };\n\n",[],[172,395,433],"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",[],[172,395,441],"b8ad561a-d3a9-11f0-8e4b-42dde27851f2",7,["D",1765138634968],[194,195,196,197,198,199,200,201],[172,395],"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",[],[172,462,454],"middleware","b882c86e-d3a9-11f0-8004-42dde27851f2",["D",1765138634693],[192],[172,462],"92c6b8b2-db09-11f0-8d0c-42dde27851f2","queries.ts","b90da5f6-d3a9-11f0-a23f-42dde27851f2","b896776a-d3a9-11f0-8e4b-42dde27851f2",116,["D",1765949461207],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport {\n USERS_TABLE,\n SESSIONS_TABLE,\n RECIPES_TABLE,\n RECIPE_INGREDIENTS_TABLE,\n RECIPE_NUTRITION_TABLE,\n FDC_FOODS_CACHE_TABLE,\n GROCERY_LISTS_TABLE,\n GROCERY_LIST_ITEMS_TABLE,\n NUTRITION_GOALS_TABLE,\n MEAL_PLANS_TABLE,\n MEAL_PLAN_ENTRIES_TABLE,\n SCRAPER_EVAL_URLS_TABLE,\n STARRED_INGREDIENTS_TABLE,\n CUSTOM_FOODS_TABLE,\n} from \"./migrations.ts\";\nimport type {\n User,\n Recipe,\n RecipeIngredient,\n RecipeNutrition,\n GroceryList,\n GroceryListItem,\n NutritionGoals,\n MealPlan,\n MealPlanEntry,\n DayOfWeek,\n MealType,\n FDCDataType,\n CreateRecipeIngredient,\n StarredIngredient,\n CustomFood,\n CreateCustomFoodRequest,\n FDCFood,\n FDCNutrition,\n} from \"../../shared/types.ts\";\nimport { calculateRecipeNutrition, convertToGrams } from \"../services/nutrition-calculator.ts\";\n\n// Generate unique IDs\nfunction generateId(): string {\n return crypto.randomUUID();\n}\n\n// ============ USER QUERIES ============\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, email, name, picture FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function createOrUpdateUser(\n email: string,\n name: string | null,\n picture: string | null\n): Promise {\n const existing = await getUserByEmail(email);\n \n if (existing) {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET name = ?, picture = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [name, picture, existing.id]\n );\n return { ...existing, name, picture };\n }\n \n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, email, name, picture) VALUES (?, ?, ?, ?)`,\n [id, email, name, picture]\n );\n return { id, email, name, picture };\n}\n\n// ============ SESSION QUERIES ============\n\nexport async function createSession(userId: string): Promise {\n const sessionId = generateId();\n const expiresAt = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString(); // 30 days\n \n await sqlite.execute(\n `INSERT INTO ${SESSIONS_TABLE} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n [sessionId, userId, expiresAt]\n );\n \n return sessionId;\n}\n\nexport async function getSessionUser(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT u.id, u.email, u.name, u.picture\n FROM ${SESSIONS_TABLE} s\n JOIN ${USERS_TABLE} u ON s.user_id = u.id\n WHERE s.id = ? AND s.expires_at > datetime('now')`,\n [sessionId]\n );\n \n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n email: row.email as string,\n name: row.name as string | null,\n picture: row.picture as string | null,\n };\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(`DELETE FROM ${SESSIONS_TABLE} WHERE id = ?`, [sessionId]);\n}\n\n// ============ RECIPE QUERIES ============\n\nexport async function getRecipesByUser(userId: string): Promise {\n const recipesResult = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n const recipes: Recipe[] = [];\n \n for (const row of recipesResult.rows) {\n const recipeId = row.id as string;\n \n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n \n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n \n // Get nutrition with extended micronutrients\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete\n FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n \n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n \n recipes.push({\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n });\n }\n \n return recipes;\n}\n\n// Helper to map nutrition row to RecipeNutrition\nfunction mapNutritionRow(n: any, recipeId: string): RecipeNutrition {\n return {\n id: n.id as string,\n recipeId: recipeId,\n calories: n.calories as number | null,\n protein: n.protein as number | null,\n fat: n.fat as number | null,\n carbs: n.carbs as number | null,\n fiber: n.fiber as number | null,\n sodium: n.sodium as number | null,\n potassium: n.potassium as number | null,\n calcium: n.calcium as number | null,\n iron: n.iron as number | null,\n magnesium: n.magnesium as number | null,\n zinc: n.zinc as number | null,\n vitaminA: n.vitamin_a as number | null,\n vitaminC: n.vitamin_c as number | null,\n vitaminD: n.vitamin_d as number | null,\n vitaminE: n.vitamin_e as number | null,\n vitaminK: n.vitamin_k as number | null,\n vitaminB6: n.vitamin_b6 as number | null,\n vitaminB12: n.vitamin_b12 as number | null,\n thiamin: n.thiamin as number | null,\n riboflavin: n.riboflavin as number | null,\n niacin: n.niacin as number | null,\n folate: n.folate as number | null,\n isComplete: Boolean(n.is_complete),\n };\n}\n\nexport async function getRecipeById(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, title, url, instructions, serving_size, created_at, updated_at\n FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n \n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n \n // Get ingredients with FDC fields\n const ingredientsResult = await sqlite.execute(\n `SELECT id, recipe_id, name, amount, unit, amount_grams, notes, order_index,\n fdc_id, fdc_description, fdc_data_type\n FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ? ORDER BY order_index`,\n [recipeId]\n );\n \n const ingredients: RecipeIngredient[] = ingredientsResult.rows.map((i) => ({\n id: i.id as string,\n recipeId: i.recipe_id as string,\n name: i.name as string,\n amount: i.amount as number | null,\n unit: i.unit as string | null,\n amountGrams: i.amount_grams as number | null,\n notes: i.notes as string | null,\n orderIndex: i.order_index as number,\n fdcId: i.fdc_id as number | null,\n fdcDescription: i.fdc_description as string | null,\n fdcDataType: i.fdc_data_type as FDCDataType | null,\n }));\n \n // Get nutrition with extended micronutrients\n const nutritionResult = await sqlite.execute(\n `SELECT id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete\n FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n \n let nutrition: RecipeNutrition | null = null;\n if (nutritionResult.rows.length > 0) {\n const n = nutritionResult.rows[0];\n nutrition = mapNutritionRow(n, recipeId);\n }\n \n return {\n id: recipeId,\n userId: row.user_id as string,\n title: row.title as string,\n url: row.url as string | null,\n instructions: row.instructions as string | null,\n servingSize: row.serving_size as number,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n ingredients,\n nutrition,\n };\n}\n\nexport async function createRecipe(\n userId: string,\n title: string,\n url: string | null,\n instructions: string | null,\n servingSize: number,\n ingredients: CreateRecipeIngredient[]\n): Promise {\n const recipeId = generateId();\n \n await sqlite.execute(\n `INSERT INTO ${RECIPES_TABLE} (id, user_id, title, url, instructions, serving_size)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [recipeId, userId, title, url, instructions, servingSize]\n );\n \n // Insert ingredients with FDC fields\n const recipeIngredients: RecipeIngredient[] = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ing = ingredients[i];\n const ingId = generateId();\n \n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n \n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name, \n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n \n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n \n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n \n // Insert calculated nutrition\n let recipeNutrition: RecipeNutrition | null = null;\n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n \n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} \n (id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n nutId, recipeId,\n n.calories, n.protein, n.fat, n.carbs, n.fiber,\n n.sodium, n.potassium, n.calcium, n.iron, n.magnesium, n.zinc,\n n.vitaminA, n.vitaminC, n.vitaminD, n.vitaminE, n.vitaminK,\n n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin, n.folate,\n n.isComplete ? 1 : 0\n ]\n );\n \n recipeNutrition = {\n id: nutId,\n recipeId,\n ...n,\n };\n \n const now = new Date().toISOString();\n return {\n id: recipeId,\n userId,\n title,\n url,\n instructions,\n servingSize,\n createdAt: now,\n updatedAt: now,\n ingredients: recipeIngredients,\n nutrition: recipeNutrition,\n };\n}\n\nexport async function updateRecipe(\n recipeId: string,\n userId: string,\n updates: {\n title?: string;\n url?: string | null;\n instructions?: string | null;\n servingSize?: number;\n ingredients?: CreateRecipeIngredient[];\n }\n): Promise {\n // Check ownership\n const existing = await getRecipeById(recipeId, userId);\n if (!existing) return null;\n \n // Update recipe\n const fields: string[] = [];\n const values: any[] = [];\n \n if (updates.title !== undefined) {\n fields.push('title = ?');\n values.push(updates.title);\n }\n if (updates.url !== undefined) {\n fields.push('url = ?');\n values.push(updates.url);\n }\n if (updates.instructions !== undefined) {\n fields.push('instructions = ?');\n values.push(updates.instructions);\n }\n if (updates.servingSize !== undefined) {\n fields.push('serving_size = ?');\n values.push(updates.servingSize);\n }\n \n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(recipeId, userId);\n await sqlite.execute(\n `UPDATE ${RECIPES_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n \n // Determine the serving size to use for nutrition calculation\n const servingSize = updates.servingSize ?? existing.servingSize;\n \n // Update ingredients if provided\n let recipeIngredients: RecipeIngredient[] = existing.ingredients;\n if (updates.ingredients !== undefined) {\n await sqlite.execute(`DELETE FROM ${RECIPE_INGREDIENTS_TABLE} WHERE recipe_id = ?`, [recipeId]);\n recipeIngredients = [];\n \n for (let i = 0; i < updates.ingredients.length; i++) {\n const ing = updates.ingredients[i];\n const ingId = generateId();\n \n // Calculate amount in grams if possible\n const amountGrams = convertToGrams(ing.amount ?? null, ing.unit ?? null);\n \n await sqlite.execute(\n `INSERT INTO ${RECIPE_INGREDIENTS_TABLE} \n (id, recipe_id, name, amount, unit, amount_grams, notes, order_index, fdc_id, fdc_description, fdc_data_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n ingId, recipeId, ing.name,\n ing.amount ?? null, ing.unit ?? null, amountGrams,\n ing.notes ?? null, i,\n ing.fdcId ?? null, ing.fdcDescription ?? null, ing.fdcDataType ?? null\n ]\n );\n \n recipeIngredients.push({\n id: ingId,\n recipeId,\n name: ing.name,\n amount: ing.amount ?? null,\n unit: ing.unit ?? null,\n amountGrams,\n notes: ing.notes ?? null,\n orderIndex: i,\n fdcId: ing.fdcId ?? null,\n fdcDescription: ing.fdcDescription ?? null,\n fdcDataType: ing.fdcDataType ?? null,\n });\n }\n }\n \n // Recalculate nutrition if ingredients or serving size changed\n if (updates.ingredients !== undefined || updates.servingSize !== undefined) {\n // Calculate nutrition from FDC-linked ingredients\n const calculatedNutrition = await calculateRecipeNutrition(recipeIngredients, servingSize);\n \n // Update nutrition\n await sqlite.execute(`DELETE FROM ${RECIPE_NUTRITION_TABLE} WHERE recipe_id = ?`, [recipeId]);\n \n const nutId = generateId();\n const n = calculatedNutrition.nutrition;\n \n await sqlite.execute(\n `INSERT INTO ${RECIPE_NUTRITION_TABLE} \n (id, recipe_id, calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n is_complete)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n nutId, recipeId,\n n.calories, n.protein, n.fat, n.carbs, n.fiber,\n n.sodium, n.potassium, n.calcium, n.iron, n.magnesium, n.zinc,\n n.vitaminA, n.vitaminC, n.vitaminD, n.vitaminE, n.vitaminK,\n n.vitaminB6, n.vitaminB12, n.thiamin, n.riboflavin, n.niacin, n.folate,\n n.isComplete ? 1 : 0\n ]\n );\n }\n \n return getRecipeById(recipeId, userId);\n}\n\nexport async function deleteRecipe(recipeId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function duplicateRecipe(recipeId: string, userId: string): Promise {\n const original = await getRecipeById(recipeId, userId);\n if (!original) return null;\n \n return createRecipe(\n userId,\n `${original.title} (Copy)`,\n original.url,\n original.instructions,\n original.servingSize,\n original.ingredients.map(i => ({\n name: i.name,\n amount: i.amount,\n unit: i.unit,\n notes: i.notes,\n fdcId: i.fdcId,\n fdcDescription: i.fdcDescription,\n fdcDataType: i.fdcDataType,\n }))\n );\n}\n\n// ============ GROCERY LIST QUERIES ============\n\nexport async function getGroceryListsByUser(userId: string): Promise {\n const listsResult = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n const lists: GroceryList[] = [];\n \n for (const row of listsResult.rows) {\n const listId = row.id as string;\n \n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n \n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n \n lists.push({\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n });\n }\n \n return lists;\n}\n\nexport async function getGroceryListById(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, created_at, updated_at\n FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n \n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n \n const itemsResult = await sqlite.execute(\n `SELECT id, list_id, name, quantity, unit, recipe_id, recipe_name, checked, created_at\n FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE list_id = ? ORDER BY created_at`,\n [listId]\n );\n \n const items: GroceryListItem[] = itemsResult.rows.map((i) => ({\n id: i.id as string,\n listId: i.list_id as string,\n name: i.name as string,\n quantity: i.quantity as number | null,\n unit: i.unit as string | null,\n recipeId: i.recipe_id as string | null,\n recipeName: i.recipe_name as string | null,\n checked: Boolean(i.checked),\n createdAt: i.created_at as string,\n }));\n \n return {\n id: listId,\n userId: row.user_id as string,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items,\n };\n}\n\nexport async function createGroceryList(userId: string, name: string): Promise {\n const listId = generateId();\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${GROCERY_LISTS_TABLE} (id, user_id, name) VALUES (?, ?, ?)`,\n [listId, userId, name]\n );\n \n return {\n id: listId,\n userId,\n name,\n createdAt: now,\n updatedAt: now,\n items: [],\n };\n}\n\nexport async function updateGroceryList(listId: string, userId: string, name: string): Promise {\n const existing = await getGroceryListById(listId, userId);\n if (!existing) return null;\n \n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET name = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ? AND user_id = ?`,\n [name, listId, userId]\n );\n \n return getGroceryListById(listId, userId);\n}\n\nexport async function deleteGroceryList(listId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LISTS_TABLE} WHERE id = ? AND user_id = ?`,\n [listId, userId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function addGroceryItem(\n listId: string,\n userId: string,\n name: string,\n quantity: number | null,\n unit: string | null,\n recipeId: string | null = null,\n recipeName: string | null = null\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return null;\n \n const itemId = generateId();\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${GROCERY_LIST_ITEMS_TABLE} (id, list_id, name, quantity, unit, recipe_id, recipe_name)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [itemId, listId, name, quantity, unit, recipeId, recipeName]\n );\n \n await sqlite.execute(\n `UPDATE ${GROCERY_LISTS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [listId]\n );\n \n return {\n id: itemId,\n listId,\n name,\n quantity,\n unit,\n recipeId,\n recipeName,\n checked: false,\n createdAt: now,\n };\n}\n\nexport async function addRecipeIngredientsToList(\n listId: string,\n userId: string,\n recipeId: string\n): Promise {\n const recipe = await getRecipeById(recipeId, userId);\n if (!recipe) return [];\n \n const items: GroceryListItem[] = [];\n \n for (const ing of recipe.ingredients) {\n const item = await addGroceryItem(\n listId,\n userId,\n ing.name,\n ing.amount,\n ing.unit,\n recipeId,\n recipe.title\n );\n if (item) items.push(item);\n }\n \n return items;\n}\n\nexport async function updateGroceryItemChecked(\n itemId: string,\n listId: string,\n userId: string,\n checked: boolean\n): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n \n const result = await sqlite.execute(\n `UPDATE ${GROCERY_LIST_ITEMS_TABLE} SET checked = ? WHERE id = ? AND list_id = ?`,\n [checked ? 1 : 0, itemId, listId]\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function deleteGroceryItem(itemId: string, listId: string, userId: string): Promise {\n // Verify list ownership\n const list = await getGroceryListById(listId, userId);\n if (!list) return false;\n \n const result = await sqlite.execute(\n `DELETE FROM ${GROCERY_LIST_ITEMS_TABLE} WHERE id = ? AND list_id = ?`,\n [itemId, listId]\n );\n \n return result.rowsAffected > 0;\n}\n\n// ============ NUTRITION GOALS QUERIES ============\n\nexport async function getNutritionGoals(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, primary_goal_type, primary_goal_value, \n sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value, updated_at\n FROM ${NUTRITION_GOALS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n \n return {\n id: row.id as string,\n userId: row.user_id as string,\n primaryGoalType: row.primary_goal_type as any,\n primaryGoalValue: row.primary_goal_value as number,\n subGoal1Type: row.sub_goal_1_type as any | null,\n subGoal1Value: row.sub_goal_1_value as number | null,\n subGoal2Type: row.sub_goal_2_type as any | null,\n subGoal2Value: row.sub_goal_2_value as number | null,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function setNutritionGoals(\n userId: string,\n primaryGoalType: string,\n primaryGoalValue: number,\n subGoal1Type: string | null,\n subGoal1Value: number | null,\n subGoal2Type: string | null,\n subGoal2Value: number | null\n): Promise {\n const existing = await getNutritionGoals(userId);\n const now = new Date().toISOString();\n \n if (existing) {\n await sqlite.execute(\n `UPDATE ${NUTRITION_GOALS_TABLE} \n SET primary_goal_type = ?, primary_goal_value = ?,\n sub_goal_1_type = ?, sub_goal_1_value = ?,\n sub_goal_2_type = ?, sub_goal_2_value = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE user_id = ?`,\n [primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value, userId]\n );\n \n return {\n ...existing,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n }\n \n const id = generateId();\n await sqlite.execute(\n `INSERT INTO ${NUTRITION_GOALS_TABLE} \n (id, user_id, primary_goal_type, primary_goal_value, sub_goal_1_type, sub_goal_1_value, sub_goal_2_type, sub_goal_2_value)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, userId, primaryGoalType, primaryGoalValue, subGoal1Type, subGoal1Value, subGoal2Type, subGoal2Value]\n );\n \n return {\n id,\n userId,\n primaryGoalType: primaryGoalType as any,\n primaryGoalValue,\n subGoal1Type: subGoal1Type as any,\n subGoal1Value,\n subGoal2Type: subGoal2Type as any,\n subGoal2Value,\n updatedAt: now,\n };\n}\n\n// ============ MEAL PLAN QUERIES ============\n\nexport async function getMealPlan(userId: string, weekStartDate: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, week_start_date, created_at, updated_at\n FROM ${MEAL_PLANS_TABLE} WHERE user_id = ? AND week_start_date = ?`,\n [userId, weekStartDate]\n );\n \n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const mealPlanId = row.id as string;\n \n // Get all entries (recipes, custom foods, and FDC ingredients)\n const entriesResult = await sqlite.execute(\n `SELECT id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams\n FROM ${MEAL_PLAN_ENTRIES_TABLE}\n WHERE meal_plan_id = ?\n ORDER BY day_of_week, meal_type`,\n [mealPlanId]\n );\n \n const entries: MealPlanEntry[] = [];\n for (const e of entriesResult.rows) {\n const entry: MealPlanEntry = {\n id: e.id as string,\n mealPlanId: e.meal_plan_id as string,\n dayOfWeek: e.day_of_week as DayOfWeek,\n mealType: e.meal_type as MealType,\n recipeId: e.recipe_id as string | null,\n customFoodId: e.custom_food_id as string | null,\n fdcId: e.fdc_id as number | null,\n servings: e.servings as number,\n amountGrams: e.amount_grams as number | null,\n };\n \n // Populate associated data based on entry type\n if (entry.recipeId) {\n const recipe = await getRecipeById(entry.recipeId, userId);\n if (recipe) entry.recipe = recipe;\n } else if (entry.customFoodId) {\n const customFood = await getCustomFoodById(entry.customFoodId, userId);\n if (customFood) entry.customFood = customFood;\n } else if (entry.fdcId) {\n const fdcFood = await getFDCFoodFromCache(entry.fdcId);\n if (fdcFood) entry.fdcFood = fdcFood;\n }\n \n entries.push(entry);\n }\n \n return {\n id: mealPlanId,\n userId: row.user_id as string,\n weekStartDate: row.week_start_date as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n entries,\n };\n}\n\nexport async function getOrCreateMealPlan(userId: string, weekStartDate: string): Promise {\n const existing = await getMealPlan(userId, weekStartDate);\n if (existing) return existing;\n \n const id = generateId();\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${MEAL_PLANS_TABLE} (id, user_id, week_start_date) VALUES (?, ?, ?)`,\n [id, userId, weekStartDate]\n );\n \n return {\n id,\n userId,\n weekStartDate,\n createdAt: now,\n updatedAt: now,\n entries: [],\n };\n}\n\n// Add entry to meal plan - supports recipes, custom foods, or FDC ingredients\nexport async function addMealPlanEntry(\n userId: string,\n weekStartDate: string,\n dayOfWeek: DayOfWeek,\n mealType: MealType,\n options: {\n recipeId?: string;\n customFoodId?: string;\n fdcId?: number;\n servings?: number;\n amountGrams?: number;\n }\n): Promise {\n const { recipeId, customFoodId, fdcId, servings = 1, amountGrams } = options;\n \n // Validate that exactly one of the IDs is provided\n const idCount = [recipeId, customFoodId, fdcId].filter(Boolean).length;\n if (idCount !== 1) {\n return null;\n }\n \n // Verify ownership/existence based on entry type\n let recipe: Recipe | undefined;\n let customFood: CustomFood | undefined;\n let fdcFood: FDCFood | undefined;\n \n if (recipeId) {\n const r = await getRecipeById(recipeId, userId);\n if (!r) return null;\n recipe = r;\n } else if (customFoodId) {\n const cf = await getCustomFoodById(customFoodId, userId);\n if (!cf) return null;\n customFood = cf;\n } else if (fdcId) {\n const fdc = await getFDCFoodFromCache(fdcId);\n if (!fdc) return null;\n fdcFood = fdc;\n }\n \n const mealPlan = await getOrCreateMealPlan(userId, weekStartDate);\n const entryId = generateId();\n \n await sqlite.execute(\n `INSERT INTO ${MEAL_PLAN_ENTRIES_TABLE} \n (id, meal_plan_id, day_of_week, meal_type, recipe_id, custom_food_id, fdc_id, servings, amount_grams)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [entryId, mealPlan.id, dayOfWeek, mealType, recipeId ?? null, customFoodId ?? null, fdcId ?? null, servings, amountGrams ?? null]\n );\n \n await sqlite.execute(\n `UPDATE ${MEAL_PLANS_TABLE} SET updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [mealPlan.id]\n );\n \n return {\n id: entryId,\n mealPlanId: mealPlan.id,\n dayOfWeek,\n mealType,\n recipeId: recipeId ?? null,\n customFoodId: customFoodId ?? null,\n fdcId: fdcId ?? null,\n recipe,\n customFood,\n fdcFood,\n servings,\n amountGrams: amountGrams ?? null,\n };\n}\n\nexport async function deleteMealPlanEntry(entryId: string, userId: string): Promise {\n // Get entry and verify ownership through meal plan\n const entryResult = await sqlite.execute(\n `SELECT e.id, e.meal_plan_id, m.user_id\n FROM ${MEAL_PLAN_ENTRIES_TABLE} e\n JOIN ${MEAL_PLANS_TABLE} m ON e.meal_plan_id = m.id\n WHERE e.id = ?`,\n [entryId]\n );\n \n if (entryResult.rows.length === 0) return false;\n if (entryResult.rows[0].user_id !== userId) return false;\n \n const result = await sqlite.execute(\n `DELETE FROM ${MEAL_PLAN_ENTRIES_TABLE} WHERE id = ?`,\n [entryId]\n );\n \n return result.rowsAffected > 0;\n}\n\nexport async function scheduleMeals(\n userId: string,\n weekStartDate: string,\n 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// ============ STARRED INGREDIENTS QUERIES ============\n\nexport async function getStarredIngredients(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner, created_at\n FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.rows.map((row) => ({\n id: row.id as string,\n userId: row.user_id as string,\n fdcId: row.fdc_id as number,\n fdcDescription: row.fdc_description as string,\n fdcDataType: row.fdc_data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n createdAt: row.created_at as string,\n }));\n}\n\nexport async function addStarredIngredient(\n userId: string,\n fdcId: number,\n fdcDescription: string,\n fdcDataType: FDCDataType,\n brandOwner: string | null\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${STARRED_INGREDIENTS_TABLE} (id, user_id, fdc_id, fdc_description, fdc_data_type, brand_owner)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, userId, fdcId, fdcDescription, fdcDataType, brandOwner]\n );\n \n return { id, userId, fdcId, fdcDescription, fdcDataType, brandOwner, createdAt: now };\n } catch (error) {\n // Already starred (unique constraint on user_id + fdc_id)\n return null;\n }\n}\n\nexport async function removeStarredIngredient(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ?`,\n [userId, fdcId]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function isIngredientStarred(userId: string, fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT 1 FROM ${STARRED_INGREDIENTS_TABLE} WHERE user_id = ? AND fdc_id = ? LIMIT 1`,\n [userId, fdcId]\n );\n return result.rows.length > 0;\n}\n\n// ============ CUSTOM FOODS QUERIES ============\n\nfunction mapCustomFoodRow(row: any): CustomFood {\n return {\n id: row.id as string,\n userId: row.user_id as string,\n name: row.name as string,\n servingSizeGrams: row.serving_size_grams as number,\n calories: row.calories as number | null,\n protein: row.protein as number | null,\n fat: row.fat as number | null,\n carbs: row.carbs as number | null,\n fiber: row.fiber as number | null,\n sodium: row.sodium as number | null,\n potassium: row.potassium as number | null,\n calcium: row.calcium as number | null,\n iron: row.iron as number | null,\n magnesium: row.magnesium as number | null,\n zinc: row.zinc as number | null,\n vitaminA: row.vitamin_a as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k as number | null,\n vitaminB6: row.vitamin_b6 as number | null,\n vitaminB12: row.vitamin_b12 as number | null,\n thiamin: row.thiamin as number | null,\n riboflavin: row.riboflavin as number | null,\n niacin: row.niacin as number | null,\n folate: row.folate as number | null,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n };\n}\n\nexport async function getCustomFoodsByUser(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n created_at, updated_at\n FROM ${CUSTOM_FOODS_TABLE} WHERE user_id = ? ORDER BY name`,\n [userId]\n );\n \n return result.rows.map(mapCustomFoodRow);\n}\n\nexport async function getCustomFoodById(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n created_at, updated_at\n FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n \n if (result.rows.length === 0) return null;\n return mapCustomFoodRow(result.rows[0]);\n}\n\nexport async function createCustomFood(\n userId: string,\n data: CreateCustomFoodRequest\n): Promise {\n const id = generateId();\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, userId, data.name, data.servingSizeGrams ?? 100,\n data.calories ?? null, data.protein ?? null, data.fat ?? null, data.carbs ?? null, data.fiber ?? null,\n data.sodium ?? null, data.potassium ?? null, data.calcium ?? null, data.iron ?? null, data.magnesium ?? null, data.zinc ?? null,\n data.vitaminA ?? null, data.vitaminC ?? null, data.vitaminD ?? null, data.vitaminE ?? null, data.vitaminK ?? null,\n data.vitaminB6 ?? null, data.vitaminB12 ?? null, data.thiamin ?? null, data.riboflavin ?? null, data.niacin ?? null, data.folate ?? null,\n ]\n );\n \n return {\n id,\n userId,\n name: data.name,\n servingSizeGrams: data.servingSizeGrams ?? 100,\n calories: data.calories ?? null,\n protein: data.protein ?? null,\n fat: data.fat ?? null,\n carbs: data.carbs ?? null,\n fiber: data.fiber ?? null,\n sodium: data.sodium ?? null,\n potassium: data.potassium ?? null,\n calcium: data.calcium ?? null,\n iron: data.iron ?? null,\n magnesium: data.magnesium ?? null,\n zinc: data.zinc ?? null,\n vitaminA: data.vitaminA ?? null,\n vitaminC: data.vitaminC ?? null,\n vitaminD: data.vitaminD ?? null,\n vitaminE: data.vitaminE ?? null,\n vitaminK: data.vitaminK ?? null,\n vitaminB6: data.vitaminB6 ?? null,\n vitaminB12: data.vitaminB12 ?? null,\n thiamin: data.thiamin ?? null,\n riboflavin: data.riboflavin ?? null,\n niacin: data.niacin ?? null,\n folate: data.folate ?? null,\n createdAt: now,\n updatedAt: now,\n };\n}\n\nexport async function updateCustomFood(\n customFoodId: string,\n userId: string,\n data: Partial\n): Promise {\n // Check ownership\n const existing = await getCustomFoodById(customFoodId, userId);\n if (!existing) return null;\n \n const fields: string[] = [];\n const values: any[] = [];\n \n if (data.name !== undefined) { fields.push('name = ?'); values.push(data.name); }\n if (data.servingSizeGrams !== undefined) { fields.push('serving_size_grams = ?'); values.push(data.servingSizeGrams); }\n if (data.calories !== undefined) { fields.push('calories = ?'); values.push(data.calories); }\n if (data.protein !== undefined) { fields.push('protein = ?'); values.push(data.protein); }\n if (data.fat !== undefined) { fields.push('fat = ?'); values.push(data.fat); }\n if (data.carbs !== undefined) { fields.push('carbs = ?'); values.push(data.carbs); }\n if (data.fiber !== undefined) { fields.push('fiber = ?'); values.push(data.fiber); }\n if (data.sodium !== undefined) { fields.push('sodium = ?'); values.push(data.sodium); }\n if (data.potassium !== undefined) { fields.push('potassium = ?'); values.push(data.potassium); }\n if (data.calcium !== undefined) { fields.push('calcium = ?'); values.push(data.calcium); }\n if (data.iron !== undefined) { fields.push('iron = ?'); values.push(data.iron); }\n if (data.magnesium !== undefined) { fields.push('magnesium = ?'); values.push(data.magnesium); }\n if (data.zinc !== undefined) { fields.push('zinc = ?'); values.push(data.zinc); }\n if (data.vitaminA !== undefined) { fields.push('vitamin_a = ?'); values.push(data.vitaminA); }\n if (data.vitaminC !== undefined) { fields.push('vitamin_c = ?'); values.push(data.vitaminC); }\n if (data.vitaminD !== undefined) { fields.push('vitamin_d = ?'); values.push(data.vitaminD); }\n if (data.vitaminE !== undefined) { fields.push('vitamin_e = ?'); values.push(data.vitaminE); }\n if (data.vitaminK !== undefined) { fields.push('vitamin_k = ?'); values.push(data.vitaminK); }\n if (data.vitaminB6 !== undefined) { fields.push('vitamin_b6 = ?'); values.push(data.vitaminB6); }\n if (data.vitaminB12 !== undefined) { fields.push('vitamin_b12 = ?'); values.push(data.vitaminB12); }\n if (data.thiamin !== undefined) { fields.push('thiamin = ?'); values.push(data.thiamin); }\n if (data.riboflavin !== undefined) { fields.push('riboflavin = ?'); values.push(data.riboflavin); }\n if (data.niacin !== undefined) { fields.push('niacin = ?'); values.push(data.niacin); }\n if (data.folate !== undefined) { fields.push('folate = ?'); values.push(data.folate); }\n \n if (fields.length > 0) {\n fields.push('updated_at = CURRENT_TIMESTAMP');\n values.push(customFoodId, userId);\n await sqlite.execute(\n `UPDATE ${CUSTOM_FOODS_TABLE} SET ${fields.join(', ')} WHERE id = ? AND user_id = ?`,\n values\n );\n }\n \n return getCustomFoodById(customFoodId, userId);\n}\n\nexport async function deleteCustomFood(customFoodId: string, userId: string): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CUSTOM_FOODS_TABLE} WHERE id = ? AND user_id = ?`,\n [customFoodId, userId]\n );\n return result.rowsAffected > 0;\n}\n\n// ============ FDC FOOD CACHE QUERIES ============\n\nfunction mapFDCFoodRow(row: any): FDCFood {\n return {\n fdcId: row.fdc_id as number,\n description: row.description as string,\n dataType: row.data_type as FDCDataType,\n brandOwner: row.brand_owner as string | null,\n brandName: row.brand_name as string | null,\n servingSize: row.serving_size as number | null,\n servingSizeUnit: row.serving_size_unit as string | null,\n householdServingText: row.household_serving_text as string | null,\n nutrition: {\n calories: row.calories as number | null,\n protein: row.protein as number | null,\n fat: row.fat as number | null,\n carbs: row.carbs as number | null,\n fiber: row.fiber as number | null,\n sodium: row.sodium as number | null,\n potassium: row.potassium as number | null,\n calcium: row.calcium as number | null,\n iron: row.iron as number | null,\n magnesium: row.magnesium as number | null,\n zinc: row.zinc as number | null,\n vitaminA: row.vitamin_a as number | null,\n vitaminC: row.vitamin_c as number | null,\n vitaminD: row.vitamin_d as number | null,\n vitaminE: row.vitamin_e as number | null,\n vitaminK: row.vitamin_k as number | null,\n vitaminB6: row.vitamin_b6 as number | null,\n vitaminB12: row.vitamin_b12 as number | null,\n thiamin: row.thiamin as number | null,\n riboflavin: row.riboflavin as number | null,\n niacin: row.niacin as number | null,\n folate: row.folate as number | null,\n },\n cachedAt: row.cached_at as string,\n };\n}\n\nexport async function getFDCFoodFromCache(fdcId: number): Promise {\n const result = await sqlite.execute(\n `SELECT fdc_id, description, data_type, brand_owner, brand_name,\n serving_size, serving_size_unit, household_serving_text,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate,\n cached_at\n FROM ${FDC_FOODS_CACHE_TABLE} WHERE fdc_id = ?`,\n [fdcId]\n );\n \n if (result.rows.length === 0) return null;\n return mapFDCFoodRow(result.rows[0]);\n}\n\n\n",[],[172,476,468],"database","92b5bed6-db09-11f0-bcf8-42dde27851f2","migrations.ts","b92d14ae-d3a9-11f0-9955-42dde27851f2",115,["D",1765949461097],"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_v3'; // v3: added FDC linking\nexport const RECIPE_NUTRITION_TABLE = 'carmy_recipe_nutrition_v2'; // v2: extended micronutrients\nexport const FDC_FOODS_CACHE_TABLE = 'carmy_fdc_foods_cache_v1'; // Cache for USDA FDC food data\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_v2'; // v2: support custom foods and FDC ingredients\nexport const SCRAPER_EVAL_URLS_TABLE = 'carmy_scraper_eval_urls_v1';\nexport const STARRED_INGREDIENTS_TABLE = 'carmy_starred_ingredients_v1';\nexport const CUSTOM_FOODS_TABLE = 'carmy_custom_foods_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 (v3: with FDC linking)\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 amount_grams REAL,\n notes TEXT,\n order_index INTEGER NOT NULL DEFAULT 0,\n fdc_id INTEGER,\n fdc_description TEXT,\n fdc_data_type TEXT,\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 // FDC foods cache table - cache USDA FDC food data to reduce API calls\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FDC_FOODS_CACHE_TABLE} (\n fdc_id INTEGER PRIMARY KEY,\n description TEXT NOT NULL,\n data_type TEXT NOT NULL,\n brand_owner TEXT,\n brand_name TEXT,\n serving_size REAL,\n serving_size_unit TEXT,\n household_serving_text TEXT,\n calories REAL,\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\n magnesium REAL,\n zinc REAL,\n cached_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Recipe nutrition table (v2: extended micronutrients, 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 fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\n magnesium REAL,\n zinc REAL,\n is_complete INTEGER NOT NULL DEFAULT 0,\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 // Custom foods table - user-defined foods with custom nutrition\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CUSTOM_FOODS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n serving_size_grams REAL NOT NULL DEFAULT 100,\n calories REAL,\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n magnesium REAL,\n zinc REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\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_${CUSTOM_FOODS_TABLE}_user_id \n ON ${CUSTOM_FOODS_TABLE}(user_id)\n `);\n\n // Meal plan entries table (v2: supports recipes, custom foods, and FDC ingredients)\n // Note: exactly one of recipe_id, custom_food_id, or fdc_id should be set\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,\n custom_food_id TEXT,\n fdc_id INTEGER,\n servings REAL NOT NULL DEFAULT 1,\n amount_grams REAL,\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 FOREIGN KEY (custom_food_id) REFERENCES ${CUSTOM_FOODS_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 // Starred ingredients table - user's favorite FDC foods for quick linking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STARRED_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n fdc_id INTEGER NOT NULL,\n fdc_description TEXT NOT NULL,\n fdc_data_type TEXT NOT NULL,\n brand_owner TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, fdc_id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${STARRED_INGREDIENTS_TABLE}_user_id \n ON ${STARRED_INGREDIENTS_TABLE}(user_id)\n `);\n\n console.log('Carmy migrations complete');\n}\n\n\n",[],[172,476,478],"b89676ac-d3a9-11f0-8e4b-42dde27851f2",["D",1765138634821],[189,190],[172,476],["D",1765138634257],[188,191,193,202,205],[172],["D",1765137234131],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_124":529,"_530":531,"_532":533,"_534":25,"_535":25,"_536":25,"_537":60,"_538":-5,"_539":-7,"_540":-7,"_541":64,"_542":25,"_543":25,"_544":-5,"_545":25,"_546":25,"_547":25,"_548":-5},"ENV",{"_500":501,"_502":503,"_504":88,"_505":506,"_507":508,"_509":510,"_511":512,"_513":514,"_515":516,"_517":518,"_519":520,"_521":522,"_523":524,"_525":526,"_527":528},"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 · v137