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 { 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## 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- **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- Do NOT use Hono serveStatic middleware\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/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\n6. **Hono Peculiarities:**\n - NEVER EVER write this line: `import { serveStatic } from 'https://esm.sh/hono@3.11.7/middleware';`\n - Instead use: `import { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";`\n - NEVER EVER write this line: `import { cors } from \"https://esm.sh/@hono/cors@0.0.6\";`. \n - Val Town automatically handles CORS.\n - If you need cookies, use: import { deleteCookie, getCookie, setCookie } from \"npm:hono/cookie\";",[],[184,191,197],[184,191],[184],{"_104":208,"_95":99,"_154":209,"_156":-5,"_157":139,"_158":210,"_160":161,"_106":211,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":212,"_98":321},"779c2106-494d-11f0-9d6b-76b3cceeab13","d9788c68-129e-4cb8-9a5c-74f9f42a91b3",3,["D",1749925751642],[213,241,294,311],{"_104":214,"_95":215,"_154":216,"_156":209,"_157":139,"_158":210,"_160":161,"_106":217,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":218,"_98":240},"779c2296-494d-11f0-9d6b-76b3cceeab13","database","895bec6b-49f9-4ebc-8526-787ae05ba14f",["D",1749925751642],[219,230],{"_104":220,"_95":221,"_154":222,"_156":216,"_157":139,"_158":223,"_160":161,"_106":224,"_100":225,"_163":226,"_165":227,"_166":22,"_167":-5,"_168":228,"_98":229},"9ababe38-9121-11f0-b677-0224a6c84d84","migrations.ts","779c19d6-494d-11f0-9d6b-76b3cceeab13",372,["D",1757823396415],11,"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst RECIPES_TABLE = 'recipes_v1';\nconst INGREDIENTS_TABLE = 'ingredients_v1';\nconst SHOPPING_LISTS_TABLE = 'shopping_lists_v1';\nconst SHOPPING_LIST_ITEMS_TABLE = 'shopping_list_items_v2';\nconst EXCLUDED_INGREDIENTS_TABLE = 'excluded_ingredients_v1';\nconst MEAL_PLANS_TABLE = 'meal_plans_v2';\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n \n try {\n // Create recipes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n servings INTEGER,\n prep_time INTEGER,\n cook_time INTEGER,\n difficulty TEXT CHECK(difficulty IN ('easy', 'medium', 'hard')),\n tags TEXT,\n source TEXT,\n image_url TEXT,\n steps TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create ingredients table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${INGREDIENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n recipe_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n amount TEXT NOT NULL,\n unit TEXT NOT NULL,\n notes TEXT,\n order_index INTEGER DEFAULT 0,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE} (id) ON DELETE CASCADE\n )\n `);\n\n // Create shopping lists table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SHOPPING_LISTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create shopping list items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SHOPPING_LIST_ITEMS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n shopping_list_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n amount TEXT NOT NULL,\n unit TEXT NOT NULL,\n notes TEXT,\n checked INTEGER DEFAULT 0,\n recipe_ids TEXT NOT NULL,\n order_index INTEGER DEFAULT 0,\n category TEXT DEFAULT 'other',\n FOREIGN KEY (shopping_list_id) REFERENCES ${SHOPPING_LISTS_TABLE} (id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_ingredients_recipe_id \n ON ${INGREDIENTS_TABLE} (recipe_id)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_recipes_title \n ON ${RECIPES_TABLE} (title)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_shopping_list_items_list_id \n ON ${SHOPPING_LIST_ITEMS_TABLE} (shopping_list_id)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_shopping_lists_created_at \n ON ${SHOPPING_LISTS_TABLE} (created_at DESC)\n `);\n\n // Create excluded ingredients table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${EXCLUDED_INGREDIENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n pattern TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index for excluded ingredients pattern matching\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_excluded_ingredients_pattern\n ON ${EXCLUDED_INGREDIENTS_TABLE} (pattern)\n `);\n\n // Create meal plans table (v2 with updated meal types)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLANS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n recipe_id INTEGER NOT NULL,\n date DATE NOT NULL,\n meal_type TEXT NOT NULL CHECK(meal_type IN ('breakfast-lunch', 'dinner')),\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE} (id)\n )\n `);\n\n // Migrate data from old meal_plans_v1 table if it exists\n const oldTableExists = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='meal_plans_v1'\n `);\n\n if (oldTableExists.rows.length > 0) {\n console.log('📦 Migrating data from meal_plans_v1 to meal_plans_v2...');\n\n // Get existing data from old table\n const oldData = await sqlite.execute(`\n SELECT id, recipe_id, date, meal_type, notes, created_at, updated_at\n FROM meal_plans_v1\n `);\n\n if (oldData.rows.length > 0) {\n console.log(`Found ${oldData.rows.length} meal plans to migrate`);\n\n for (const row of oldData.rows) {\n // Map old meal types to new ones\n let newMealType: string;\n switch (row.meal_type) {\n case 'breakfast':\n case 'lunch':\n newMealType = 'breakfast-lunch';\n break;\n case 'dinner':\n newMealType = 'dinner';\n break;\n case 'snack':\n // Skip snack meals as they're no longer supported\n console.log(`⚠️ Skipping snack meal plan (ID: ${row.id}) as snacks are no longer supported`);\n continue;\n default:\n console.log(`⚠️ Unknown meal type: ${row.meal_type}, skipping meal plan ID: ${row.id}`);\n continue;\n }\n\n // Insert into new table\n await sqlite.execute(`\n INSERT INTO ${MEAL_PLANS_TABLE} (recipe_id, date, meal_type, notes, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [row.recipe_id, row.date, newMealType, row.notes, row.created_at, row.updated_at]);\n }\n\n console.log('✅ Data migration completed');\n }\n\n // Drop the old table\n await sqlite.execute('DROP TABLE meal_plans_v1');\n console.log('🗑️ Dropped old meal_plans_v1 table');\n }\n\n // Create indexes for meal plans\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_meal_plans_date\n ON ${MEAL_PLANS_TABLE} (date)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_meal_plans_recipe_id\n ON ${MEAL_PLANS_TABLE} (recipe_id)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_meal_plans_date_meal_type\n ON ${MEAL_PLANS_TABLE} (date, meal_type)\n `);\n\n // Populate default excluded ingredients if the table is empty\n const excludedCount = await sqlite.execute(`\n SELECT COUNT(*) as count FROM ${EXCLUDED_INGREDIENTS_TABLE}\n `);\n \n if (excludedCount.rows[0].count === 0) {\n console.log('Populating default excluded ingredients...');\n \n const defaultExcludedIngredients = [\n { name: 'olive oil', pattern: 'olive oil' },\n { name: 'canola oil', pattern: 'canola oil' },\n { name: 'vinegar', pattern: 'vinegar' },\n { name: 'butter', pattern: 'butter' },\n { name: 'milk', pattern: 'milk' },\n { name: 'salt', pattern: 'salt' },\n { name: 'pepper', pattern: 'pepper' },\n { name: 'water', pattern: 'water' },\n { name: 'soy sauce', pattern: 'soy sauce' },\n // Generic spice patterns\n { name: 'spices', pattern: 'spice' },\n { name: 'herbs', pattern: 'herb' },\n { name: 'seasoning', pattern: 'seasoning' }\n ];\n \n for (const ingredient of defaultExcludedIngredients) {\n await sqlite.execute(`\n INSERT INTO ${EXCLUDED_INGREDIENTS_TABLE} (name, pattern)\n VALUES (?, ?)\n `, [ingredient.name, ingredient.pattern]);\n }\n \n console.log(`Added ${defaultExcludedIngredients.length} default excluded ingredients`);\n }\n\n console.log('Database migrations completed successfully');\n } catch (error) {\n console.error('Database migration failed:', error);\n throw error;\n }\n}\n\nexport { RECIPES_TABLE, INGREDIENTS_TABLE, SHOPPING_LISTS_TABLE, SHOPPING_LIST_ITEMS_TABLE, EXCLUDED_INGREDIENTS_TABLE, MEAL_PLANS_TABLE };",[],[99,215,221],{"_104":231,"_95":232,"_154":233,"_156":216,"_157":139,"_158":234,"_160":161,"_106":235,"_100":236,"_163":226,"_165":237,"_166":22,"_167":-5,"_168":238,"_98":239},"ddab250a-94c0-11f0-90f1-0224a6c84d84","queries.ts","8a187ae6-494d-11f0-9177-76b3cceeab13",376,["D",1758221652195],55,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { RECIPES_TABLE, INGREDIENTS_TABLE, SHOPPING_LISTS_TABLE, SHOPPING_LIST_ITEMS_TABLE, EXCLUDED_INGREDIENTS_TABLE, MEAL_PLANS_TABLE } from \"./migrations.ts\";\nimport type { Recipe, Ingredient, RecipeFilters, ShoppingList, ShoppingListItem, PaginationParams, PaginationInfo, ExcludedIngredient, MealPlan } from \"../../shared/types.ts\";\nimport { categorizeIngredient, getCategorySortOrder } from \"../utils/ingredientCategorizer.ts\";\n\n// Transaction helper function for atomic multi-query operations using Val Town's batch method\nasync function executeTransaction(queries: Array<{sql: string, params: any[]}>): Promise {\n console.log(`🔄 Starting batch transaction with ${queries.length} queries`);\n \n try {\n // Convert our query format to Val Town's batch format\n const batchQueries = queries.map((query, index) => {\n console.log(`🔍 Preparing query ${index + 1}/${queries.length}: ${query.sql.substring(0, 50)}...`);\n \n // Val Town batch expects 'args' instead of 'params'\n return {\n sql: query.sql,\n args: query.params\n };\n });\n \n // Execute all queries as a batch transaction\n const results = await sqlite.batch(batchQueries);\n console.log('✅ Batch transaction completed successfully');\n \n return results;\n } catch (error) {\n // Val Town's batch method automatically handles rollback on failure\n console.error('❌ Batch transaction failed (auto-rollback):', error);\n throw error;\n }\n}\n\n// Test function to verify pagination functionality\nexport async function testPagination(): Promise<{ success: boolean, message: string }> {\n try {\n console.log('🧪 Testing pagination functionality...');\n \n // Create some test recipes to ensure we have data\n const testRecipes = [];\n for (let i = 1; i <= 5; i++) {\n const recipe = await createRecipe({\n title: `Test Recipe ${i}`,\n ingredients: [\n { name: `Ingredient ${i}A`, amount: '1', unit: 'cup' },\n { name: `Ingredient ${i}B`, amount: '2', unit: 'tbsp' }\n ],\n steps: [`Step 1 for recipe ${i}`, `Step 2 for recipe ${i}`]\n });\n testRecipes.push(recipe);\n }\n \n console.log(`✅ Created ${testRecipes.length} test recipes`);\n \n // Test pagination with limit 2\n const page1 = await getAllRecipesPaginated({}, { page: 1, limit: 2 });\n const page2 = await getAllRecipesPaginated({}, { page: 2, limit: 2 });\n \n // Verify pagination info\n if (page1.paginationInfo.limit !== 2) {\n throw new Error(`Expected limit 2, got ${page1.paginationInfo.limit}`);\n }\n \n if (page1.paginationInfo.page !== 1) {\n throw new Error(`Expected page 1, got ${page1.paginationInfo.page}`);\n }\n \n if (page1.recipes.length > 2) {\n throw new Error(`Expected max 2 recipes on page 1, got ${page1.recipes.length}`);\n }\n \n if (page2.paginationInfo.page !== 2) {\n throw new Error(`Expected page 2, got ${page2.paginationInfo.page}`);\n }\n \n // Test that page 1 and page 2 have different recipes (no overlap)\n const page1Ids = page1.recipes.map(r => r.id);\n const page2Ids = page2.recipes.map(r => r.id);\n const overlap = page1Ids.filter(id => page2Ids.includes(id));\n \n if (overlap.length > 0) {\n throw new Error(`Found overlapping recipes between pages: ${overlap}`);\n }\n \n // Test shopping list pagination\n const shoppingList = await createShoppingList('Test Pagination List', testRecipes.slice(0, 2).map(r => r.id!));\n const listPage1 = await getAllShoppingListsPaginated({ page: 1, limit: 10 });\n \n if (!listPage1.paginationInfo) {\n throw new Error('Shopping list pagination info missing');\n }\n \n // Clean up test data\n for (const recipe of testRecipes) {\n await deleteRecipe(recipe.id!);\n }\n await deleteShoppingList(shoppingList.id!);\n \n console.log(`🧹 Cleaned up test data`);\n \n return { \n success: true, \n message: `Pagination working correctly - tested ${testRecipes.length} recipes with page limits` \n };\n \n } catch (error) {\n console.error('❌ Pagination test failed:', error);\n return { \n success: false, \n message: `Pagination test failed: ${error.message}` \n };\n }\n}\n\n// Test function to verify optimized ingredient updates\nexport async function testIngredientUpdates(): Promise<{ success: boolean, message: string }> {\n try {\n console.log('🧪 Testing optimized ingredient updates...');\n \n // Create a test recipe with initial ingredients\n const testRecipe = await createRecipe({\n title: 'Test Recipe for Updates',\n ingredients: [\n { name: 'Initial Ingredient 1', amount: '1', unit: 'cup' },\n { name: 'Initial Ingredient 2', amount: '2', unit: 'tbsp' }\n ],\n steps: ['Step 1', 'Step 2']\n });\n \n console.log(`✅ Created test recipe with ID: ${testRecipe.id}`);\n \n // Update with different ingredients (should use bulk INSERT)\n const updatedRecipe = await updateRecipe(testRecipe.id, {\n title: 'Updated Test Recipe',\n ingredients: [\n { name: 'New Ingredient 1', amount: '3', unit: 'oz' },\n { name: 'New Ingredient 2', amount: '1', unit: 'tsp' },\n { name: 'New Ingredient 3', amount: '1/2', unit: 'cup' }\n ]\n });\n \n console.log(`✅ Updated recipe successfully`);\n \n // Verify the update worked correctly\n if (!updatedRecipe) {\n throw new Error('Updated recipe is null');\n }\n \n if (updatedRecipe.ingredients.length !== 3) {\n throw new Error(`Expected 3 ingredients, got ${updatedRecipe.ingredients.length}`);\n }\n \n if (updatedRecipe.title !== 'Updated Test Recipe') {\n throw new Error(`Title not updated correctly`);\n }\n \n // Clean up - delete test recipe\n await deleteRecipe(testRecipe.id);\n console.log(`🧹 Cleaned up test recipe`);\n \n return { \n success: true, \n message: `Optimized ingredient updates working correctly - bulk INSERT with ${updatedRecipe.ingredients.length} ingredients` \n };\n \n } catch (error) {\n console.error('❌ Ingredient update test failed:', error);\n return { \n success: false, \n message: `Ingredient update test failed: ${error.message}` \n };\n }\n}\n\n// Test function to verify transaction rollback behavior\nexport async function testTransactionRollback(): Promise<{ success: boolean, message: string }> {\n try {\n console.log('🧪 Testing transaction rollback behavior...');\n \n // Try to execute a transaction with an intentional error\n const badQueries = [\n {\n sql: `INSERT INTO ${RECIPES_TABLE} (title, steps) VALUES (?, ?)`,\n params: ['Test Recipe', JSON.stringify(['Step 1'])]\n },\n {\n sql: `INSERT INTO non_existent_table (id, name) VALUES (?, ?)`, // This will fail\n params: [1, 'test']\n }\n ];\n \n await executeTransaction(badQueries);\n \n // If we get here, something went wrong\n return { success: false, message: 'Transaction should have failed but did not' };\n \n } catch (error) {\n console.log('✅ Transaction correctly rolled back on error');\n \n // Verify that no test recipe was created\n const testRecipe = await sqlite.execute(`\n SELECT * FROM ${RECIPES_TABLE} WHERE title = 'Test Recipe'\n `);\n \n if (testRecipe.rows.length === 0) {\n return { success: true, message: 'Transaction rollback working correctly - no orphaned data found' };\n } else {\n return { success: false, message: 'Transaction rollback failed - orphaned data found' };\n }\n }\n}\n\nexport async function createRecipe(recipe: Omit): Promise {\n const { ingredients, steps, tags, ...recipeData } = recipe;\n \n // Validate ingredients array\n if (!ingredients || ingredients.length === 0) {\n throw new Error('Recipe must have at least one ingredient');\n }\n \n // Validate steps array\n if (!steps || steps.length === 0) {\n throw new Error('Recipe must have at least one step');\n }\n \n // Prepare all queries for transaction\n const queries = [];\n \n // First query: Insert recipe\n queries.push({\n sql: `INSERT INTO ${RECIPES_TABLE} \n (title, description, servings, prep_time, cook_time, difficulty, tags, source, image_url, steps)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n params: [\n recipeData.title,\n recipeData.description || null,\n recipeData.servings || null,\n recipeData.prepTime || null,\n recipeData.cookTime || null,\n recipeData.difficulty || null,\n tags ? JSON.stringify(tags) : null,\n recipeData.source || null,\n recipeData.imageUrl || null,\n JSON.stringify(steps)\n ]\n });\n \n // Execute the recipe insertion first to get the ID\n const [recipeResult] = await executeTransaction(queries);\n \n // Get the recipe ID\n const recipeId = recipeResult.lastInsertRowid;\n \n if (!recipeId) {\n console.error('Failed to get recipe ID from insert result:', recipeResult);\n throw new Error('Failed to create recipe: no ID returned from database');\n }\n \n // Convert to number if it's a string\n const numericRecipeId = typeof recipeId === 'string' ? parseInt(recipeId, 10) : Number(recipeId);\n \n if (isNaN(numericRecipeId) || numericRecipeId <= 0) {\n console.error('Recipe ID is not a valid number:', recipeId);\n throw new Error('Failed to create recipe: invalid ID returned from database');\n }\n\n // Prepare ingredient insertion queries\n const ingredientQueries = [];\n for (let i = 0; i < ingredients.length; i++) {\n const ingredient = ingredients[i];\n \n ingredientQueries.push({\n sql: `INSERT INTO ${INGREDIENTS_TABLE} \n (recipe_id, name, amount, unit, notes, order_index)\n VALUES (?, ?, ?, ?, ?, ?)`,\n params: [\n numericRecipeId,\n ingredient.name,\n ingredient.amount || '',\n ingredient.unit || '',\n ingredient.notes || null,\n i\n ]\n });\n }\n \n // Execute all ingredient insertions in a single transaction\n if (ingredientQueries.length > 0) {\n await executeTransaction(ingredientQueries);\n }\n\n return await getRecipeById(numericRecipeId);\n}\n\nexport async function getRecipeById(id: number): Promise {\n const recipeResult = await sqlite.execute(`\n SELECT * FROM ${RECIPES_TABLE} WHERE id = ?\n `, [id]);\n\n if (recipeResult.rows.length === 0) {\n return null;\n }\n\n const recipeRow = recipeResult.rows[0];\n \n const ingredientsResult = await sqlite.execute(`\n SELECT * FROM ${INGREDIENTS_TABLE} \n WHERE recipe_id = ? \n ORDER BY order_index\n `, [id]);\n\n const ingredients: Ingredient[] = ingredientsResult.rows.map(row => ({\n id: row.id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined\n }));\n\n return {\n id: recipeRow.id as number,\n title: recipeRow.title as string,\n description: recipeRow.description as string || undefined,\n ingredients,\n steps: JSON.parse(recipeRow.steps as string),\n servings: recipeRow.servings as number || undefined,\n prepTime: recipeRow.prep_time as number || undefined,\n cookTime: recipeRow.cook_time as number || undefined,\n difficulty: recipeRow.difficulty as Recipe['difficulty'] || undefined,\n tags: recipeRow.tags ? JSON.parse(recipeRow.tags as string) : undefined,\n source: recipeRow.source as string || undefined,\n imageUrl: recipeRow.image_url as string || undefined,\n createdAt: recipeRow.created_at as string,\n updatedAt: recipeRow.updated_at as string\n };\n}\n\n// Helper function to create pagination info\nfunction createPaginationInfo(page: number, limit: number, total: number): PaginationInfo {\n const totalPages = Math.ceil(total / limit);\n return {\n page,\n limit,\n total,\n totalPages,\n hasNext: page < totalPages,\n hasPrev: page > 1\n };\n}\n\n// Helper function to validate and normalize pagination parameters\nfunction validatePaginationParams(params?: PaginationParams): { page: number, limit: number, offset: number } {\n const page = Math.max(1, params?.page || 1);\n const limit = Math.min(100, Math.max(1, params?.limit || 50)); // Default 50, max 100\n const offset = (page - 1) * limit;\n \n return { page, limit, offset };\n}\n\nexport async function getAllRecipesPaginated(filters?: RecipeFilters, pagination?: PaginationParams): Promise<{ recipes: Recipe[], paginationInfo: PaginationInfo }> {\n const { page, limit, offset } = validatePaginationParams(pagination);\n \n // Build base query for counting total results\n let countQuery = `SELECT COUNT(*) as total FROM ${RECIPES_TABLE}`;\n let dataQuery = `SELECT * FROM ${RECIPES_TABLE}`;\n \n const params: any[] = [];\n const conditions: string[] = [];\n\n // Apply filters\n if (filters?.search) {\n conditions.push(`title LIKE ?`);\n params.push(`%${filters.search}%`);\n }\n\n if (filters?.difficulty) {\n conditions.push(`difficulty = ?`);\n params.push(filters.difficulty);\n }\n\n if (filters?.maxPrepTime) {\n conditions.push(`prep_time <= ?`);\n params.push(filters.maxPrepTime);\n }\n\n if (filters?.maxCookTime) {\n conditions.push(`cook_time <= ?`);\n params.push(filters.maxCookTime);\n }\n\n // Add WHERE clause if there are conditions\n if (conditions.length > 0) {\n const whereClause = ` WHERE ${conditions.join(' AND ')}`;\n countQuery += whereClause;\n dataQuery += whereClause;\n }\n\n // Add ORDER BY, LIMIT, and OFFSET to data query\n dataQuery += ` ORDER BY created_at DESC LIMIT ? OFFSET ?`;\n const dataParams = [...params, limit, offset];\n\n // Execute both queries\n const [countResult, dataResult] = await Promise.all([\n sqlite.execute(countQuery, params),\n sqlite.execute(dataQuery, dataParams)\n ]);\n\n const total = countResult.rows[0].total as number;\n \n // If no recipes found, return empty results\n if (dataResult.rows.length === 0) {\n return {\n recipes: [],\n paginationInfo: createPaginationInfo(page, limit, total)\n };\n }\n\n // Batch fetch all ingredients for the paginated recipes\n const recipeIds = dataResult.rows.map(row => row.id as number);\n const placeholders = recipeIds.map(() => '?').join(',');\n \n const ingredientsResult = await sqlite.execute(`\n SELECT * FROM ${INGREDIENTS_TABLE} \n WHERE recipe_id IN (${placeholders})\n ORDER BY recipe_id, order_index\n `, recipeIds);\n\n // Create a map of recipe_id to ingredients for efficient lookup\n const ingredientsByRecipeId = new Map();\n \n for (const row of ingredientsResult.rows) {\n const recipeId = row.recipe_id as number;\n if (!ingredientsByRecipeId.has(recipeId)) {\n ingredientsByRecipeId.set(recipeId, []);\n }\n \n ingredientsByRecipeId.get(recipeId)!.push({\n id: row.id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined\n });\n }\n\n // Build the recipes array with their ingredients\n const recipes: Recipe[] = dataResult.rows.map(recipeRow => {\n const ingredients = ingredientsByRecipeId.get(recipeRow.id as number) || [];\n \n return {\n id: recipeRow.id as number,\n title: recipeRow.title as string,\n description: recipeRow.description as string || undefined,\n ingredients,\n steps: JSON.parse(recipeRow.steps as string),\n servings: recipeRow.servings as number || undefined,\n prepTime: recipeRow.prep_time as number || undefined,\n cookTime: recipeRow.cook_time as number || undefined,\n difficulty: recipeRow.difficulty as Recipe['difficulty'] || undefined,\n tags: recipeRow.tags ? JSON.parse(recipeRow.tags as string) : undefined,\n source: recipeRow.source as string || undefined,\n imageUrl: recipeRow.image_url as string || undefined,\n createdAt: recipeRow.created_at as string,\n updatedAt: recipeRow.updated_at as string\n };\n });\n\n return {\n recipes,\n paginationInfo: createPaginationInfo(page, limit, total)\n };\n}\n\nexport async function getAllRecipes(filters?: RecipeFilters): Promise {\n let query = `SELECT * FROM ${RECIPES_TABLE}`;\n const params: any[] = [];\n const conditions: string[] = [];\n\n if (filters?.search) {\n conditions.push(`title LIKE ?`);\n params.push(`%${filters.search}%`);\n }\n\n if (filters?.difficulty) {\n conditions.push(`difficulty = ?`);\n params.push(filters.difficulty);\n }\n\n if (filters?.maxPrepTime) {\n conditions.push(`prep_time <= ?`);\n params.push(filters.maxPrepTime);\n }\n\n if (filters?.maxCookTime) {\n conditions.push(`cook_time <= ?`);\n params.push(filters.maxCookTime);\n }\n\n if (conditions.length > 0) {\n query += ` WHERE ${conditions.join(' AND ')}`;\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n \n // If no recipes found, return empty array\n if (result.rows.length === 0) {\n return [];\n }\n\n // Batch fetch all ingredients for all recipes in one query\n const recipeIds = result.rows.map(row => row.id as number);\n const placeholders = recipeIds.map(() => '?').join(',');\n \n const ingredientsResult = await sqlite.execute(`\n SELECT * FROM ${INGREDIENTS_TABLE} \n WHERE recipe_id IN (${placeholders})\n ORDER BY recipe_id, order_index\n `, recipeIds);\n\n // Create a map of recipe_id to ingredients for efficient lookup\n const ingredientsByRecipeId = new Map();\n \n for (const row of ingredientsResult.rows) {\n const recipeId = row.recipe_id as number;\n if (!ingredientsByRecipeId.has(recipeId)) {\n ingredientsByRecipeId.set(recipeId, []);\n }\n \n ingredientsByRecipeId.get(recipeId)!.push({\n id: row.id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined\n });\n }\n\n // Build the recipes array with their ingredients\n const recipes: Recipe[] = result.rows.map(recipeRow => {\n const ingredients = ingredientsByRecipeId.get(recipeRow.id as number) || [];\n \n return {\n id: recipeRow.id as number,\n title: recipeRow.title as string,\n description: recipeRow.description as string || undefined,\n ingredients,\n steps: JSON.parse(recipeRow.steps as string),\n servings: recipeRow.servings as number || undefined,\n prepTime: recipeRow.prep_time as number || undefined,\n cookTime: recipeRow.cook_time as number || undefined,\n difficulty: recipeRow.difficulty as Recipe['difficulty'] || undefined,\n tags: recipeRow.tags ? JSON.parse(recipeRow.tags as string) : undefined,\n source: recipeRow.source as string || undefined,\n imageUrl: recipeRow.image_url as string || undefined,\n createdAt: recipeRow.created_at as string,\n updatedAt: recipeRow.updated_at as string\n };\n });\n\n return recipes;\n}\n\nexport async function updateRecipe(id: number, updates: Partial): Promise {\n const { ingredients, steps, tags, ...recipeData } = updates;\n \n // Prepare all queries for transaction\n const queries = [];\n \n // Build recipe update query if there are fields to update\n const setParts: string[] = [];\n const params: any[] = [];\n\n Object.entries(recipeData).forEach(([key, value]) => {\n if (value !== undefined && key !== 'id' && key !== 'createdAt' && key !== 'updatedAt') {\n const dbKey = key === 'prepTime' ? 'prep_time' : \n key === 'cookTime' ? 'cook_time' : \n key === 'imageUrl' ? 'image_url' : key;\n setParts.push(`${dbKey} = ?`);\n params.push(value);\n }\n });\n\n if (steps) {\n setParts.push(`steps = ?`);\n params.push(JSON.stringify(steps));\n }\n\n if (tags) {\n setParts.push(`tags = ?`);\n params.push(JSON.stringify(tags));\n }\n\n // Add recipe update query if there are changes\n if (setParts.length > 0) {\n setParts.push(`updated_at = CURRENT_TIMESTAMP`);\n params.push(id);\n \n queries.push({\n sql: `UPDATE ${RECIPES_TABLE} \n SET ${setParts.join(', ')} \n WHERE id = ?`,\n params: params\n });\n }\n\n // Add ingredient update queries if ingredients are provided\n if (ingredients && ingredients.length > 0) {\n // Validate ingredients before processing\n for (let i = 0; i < ingredients.length; i++) {\n const ingredient = ingredients[i];\n if (!ingredient.name || typeof ingredient.name !== 'string') {\n throw new Error(`Ingredient ${i + 1} must have a valid name`);\n }\n }\n \n // First delete existing ingredients\n queries.push({\n sql: `DELETE FROM ${INGREDIENTS_TABLE} WHERE recipe_id = ?`,\n params: [id]\n });\n \n // Then bulk insert new ingredients using multiple value rows in a single INSERT\n // Note: SQLite supports multiple VALUES in a single INSERT for better performance\n const ingredientValues = [];\n const ingredientParams = [];\n \n for (let i = 0; i < ingredients.length; i++) {\n const ingredient = ingredients[i];\n ingredientValues.push('(?, ?, ?, ?, ?, ?)');\n ingredientParams.push(\n id,\n ingredient.name.trim(),\n (ingredient.amount || '').toString().trim(),\n (ingredient.unit || '').toString().trim(),\n ingredient.notes && typeof ingredient.notes === 'string' ? ingredient.notes.trim() : null,\n i\n );\n }\n \n // Single bulk INSERT query instead of multiple individual INSERTs\n queries.push({\n sql: `INSERT INTO ${INGREDIENTS_TABLE} \n (recipe_id, name, amount, unit, notes, order_index)\n VALUES ${ingredientValues.join(', ')}`,\n params: ingredientParams\n });\n }\n\n // Execute all queries in a single transaction if there are any\n if (queries.length > 0) {\n await executeTransaction(queries);\n }\n\n return await getRecipeById(id);\n}\n\nexport async function deleteRecipe(id: number): Promise {\n const result = await sqlite.execute(`DELETE FROM ${RECIPES_TABLE} WHERE id = ?`, [id]);\n \n // The SQLite library returns rowsAffected, not changes\n return (result.rowsAffected || 0) > 0;\n}\n\n// Shopping List Functions\n\nexport async function createShoppingList(name: string, recipeIds: number[]): Promise {\n console.log('Creating shopping list with name:', name, 'and recipe IDs:', recipeIds);\n \n try {\n // First, prepare the shopping list creation query\n const listQuery = {\n sql: `INSERT INTO ${SHOPPING_LISTS_TABLE} (name) VALUES (?)`,\n params: [name]\n };\n \n // Execute shopping list creation to get the ID\n const [listResult] = await executeTransaction([listQuery]);\n console.log('List creation result:', listResult);\n\n const listId = listResult.lastInsertRowid;\n if (!listId) {\n throw new Error('Failed to create shopping list');\n }\n\n const numericListId = typeof listId === 'string' ? parseInt(listId, 10) : Number(listId);\n console.log('Created shopping list with ID:', numericListId);\n\n // Get all ingredients from the selected recipes\n if (recipeIds.length === 0) {\n throw new Error('No recipe IDs provided');\n }\n\n const placeholders = recipeIds.map(() => '?').join(',');\n const ingredients = await sqlite.execute(`\n SELECT i.name, i.amount, i.unit, i.notes, i.recipe_id\n FROM ${INGREDIENTS_TABLE} i\n WHERE i.recipe_id IN (${placeholders})\n ORDER BY i.name, i.recipe_id\n `, recipeIds);\n\n console.log('Ingredients query result:', ingredients);\n\n // Check if ingredients result is valid\n if (!ingredients || !ingredients.rows || !Array.isArray(ingredients.rows)) {\n console.error('Invalid ingredients result structure:', ingredients);\n // If no ingredients found, still create the shopping list but with no items\n return await getShoppingListById(numericListId);\n }\n\n // Get excluded ingredients to filter them out\n const excludedIngredients = await getAllExcludedIngredients();\n console.log(`Found ${excludedIngredients.length} excluded ingredient patterns`);\n\n // Filter out excluded ingredients\n const filteredIngredients = ingredients.rows.filter(ingredient => {\n // Handle both array and object formats\n let name;\n if (Array.isArray(ingredient)) {\n name = ingredient[0];\n } else {\n name = ingredient.name;\n }\n \n const isExcluded = isIngredientExcluded(name as string, excludedIngredients);\n if (isExcluded) {\n console.log(`Excluding ingredient: ${name}`);\n }\n return !isExcluded;\n });\n\n console.log(`Filtered ${ingredients.rows.length - filteredIngredients.length} excluded ingredients`);\n\n // If no ingredients remain after filtering, still create the shopping list but with no items\n if (filteredIngredients.length === 0) {\n console.log('No ingredients remaining after filtering excluded items');\n return await getShoppingListById(numericListId);\n }\n\n // Smart ingredient combination with fuzzy matching\n const combinedIngredients = new Map();\n\n // In-memory cache for ingredient name normalization (performance optimization)\n const normalizationCache = new Map();\n\n // Helper function to normalize ingredient names for smart matching with caching\n function normalizeIngredientName(name: string): string {\n // Check cache first for O(1) lookup\n if (normalizationCache.has(name)) {\n return normalizationCache.get(name)!;\n }\n\n const normalized = name.toLowerCase().trim();\n \n // Remove common descriptors and variations\n const cleanName = normalized\n // Remove size descriptors\n .replace(/\\b(large|medium|small|extra-large|jumbo)\\b/g, '')\n // Remove preparation descriptors \n .replace(/\\b(fresh|dried|frozen|canned|chopped|diced|sliced|minced|grated|shredded)\\b/g, '')\n // Remove packaging descriptors\n .replace(/\\b(whole|ground|crushed|flaked|powdered)\\b/g, '')\n // Normalize herbs and spices\n .replace(/\\bparsley sprigs?\\b/g, 'parsley')\n .replace(/\\bcilantro sprigs?\\b/g, 'cilantro')\n .replace(/\\bbasil leaves?\\b/g, 'basil')\n // Normalize oils\n .replace(/\\bextra-virgin olive oil\\b/g, 'olive oil')\n .replace(/\\bolive oil, extra-virgin\\b/g, 'olive oil')\n // Normalize salts\n .replace(/\\bkosher salt\\b/g, 'salt')\n .replace(/\\bsea salt\\b/g, 'salt')\n .replace(/\\btable salt\\b/g, 'salt')\n .replace(/\\bflaky salt\\b/g, 'salt')\n .replace(/\\bflaky sea salt\\b/g, 'salt')\n // Normalize peppers\n .replace(/\\bfreshly ground black pepper\\b/g, 'black pepper')\n .replace(/\\bground black pepper\\b/g, 'black pepper')\n .replace(/\\bblack peppercorns?\\b/g, 'black pepper')\n // Normalize common ingredients\n .replace(/\\bunsalted butter\\b/g, 'butter')\n .replace(/\\bsalted butter\\b/g, 'butter')\n .replace(/\\ball-purpose flour\\b/g, 'flour')\n .replace(/\\bplain flour\\b/g, 'flour')\n // Remove extra whitespace\n .replace(/\\s+/g, ' ')\n .trim();\n \n const result = cleanName || normalized; // Fallback to original if cleaning removed everything\n \n // Cache the result for future lookups (reduces O(n×m) to O(1) for repeat ingredients)\n normalizationCache.set(name, result);\n \n return result;\n }\n\n for (const ingredient of filteredIngredients) {\n // Handle both array and object formats\n let name, amount, unit, notes, recipeId;\n if (Array.isArray(ingredient)) {\n [name, amount, unit, notes, recipeId] = ingredient;\n } else {\n name = ingredient.name;\n amount = ingredient.amount;\n unit = ingredient.unit;\n notes = ingredient.notes;\n recipeId = ingredient.recipe_id;\n }\n \n const originalName = name as string;\n const normalizedKey = normalizeIngredientName(originalName);\n \n if (!combinedIngredients.has(normalizedKey)) {\n combinedIngredients.set(normalizedKey, {\n name: originalName, // Use the first occurrence as the display name\n quantities: [],\n notes: []\n });\n }\n\n const combined = combinedIngredients.get(normalizedKey)!;\n \n // Add this quantity (don't combine amounts, just collect them)\n combined.quantities.push({\n amount: (amount as string) || '',\n unit: (unit as string) || '',\n recipeIds: [recipeId as number],\n originalName: originalName\n });\n\n // Collect unique notes\n if (notes && !combined.notes.includes(notes as string)) {\n combined.notes.push(notes as string);\n }\n }\n\n // Prepare shopping list item insertion queries with categories\n const itemsWithCategories = [];\n \n for (const [, combined] of combinedIngredients) {\n // Create a comprehensive description of all quantities\n const quantityDescriptions = combined.quantities\n .map(q => {\n const amountUnit = `${q.amount} ${q.unit}`.trim();\n // Only include non-empty amounts\n if (!amountUnit || amountUnit === '') {\n return null;\n }\n const fromRecipe = q.recipeIds.length > 0 ? ` (recipe ${q.recipeIds[0]})` : '';\n return amountUnit + fromRecipe;\n })\n .filter(desc => desc !== null);\n\n // Combine all quantities into a single amount field\n const combinedAmount = quantityDescriptions.length > 0 \n ? quantityDescriptions.join(' + ') \n : 'as needed';\n \n // Use the most common unit, or empty if mixed\n const units = combined.quantities.map(q => q.unit).filter(u => u);\n const mostCommonUnit = units.length > 0 ? units[0] : '';\n \n // Collect all recipe IDs\n const allRecipeIds = combined.quantities.flatMap(q => q.recipeIds);\n \n // Categorize the ingredient\n const category = categorizeIngredient(combined.name);\n \n itemsWithCategories.push({\n name: combined.name,\n amount: combinedAmount,\n unit: mostCommonUnit,\n notes: combined.notes.join('; ') || null,\n recipeIds: allRecipeIds,\n category: category\n });\n }\n \n // Sort items by category order\n itemsWithCategories.sort((a, b) => {\n const orderA = getCategorySortOrder(a.category as any);\n const orderB = getCategorySortOrder(b.category as any);\n if (orderA !== orderB) {\n return orderA - orderB;\n }\n // Within same category, sort alphabetically by name\n return a.name.localeCompare(b.name);\n });\n \n // Create insertion queries with sorted order\n const itemQueries = [];\n let orderIndex = 0;\n \n for (const item of itemsWithCategories) {\n itemQueries.push({\n sql: `INSERT INTO ${SHOPPING_LIST_ITEMS_TABLE} \n (shopping_list_id, name, amount, unit, notes, recipe_ids, order_index, checked, category)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n params: [\n numericListId,\n item.name,\n item.amount,\n item.unit,\n item.notes,\n JSON.stringify(item.recipeIds),\n orderIndex++,\n 0,\n item.category\n ]\n });\n }\n \n // Execute all item insertions in a single transaction\n if (itemQueries.length > 0) {\n await executeTransaction(itemQueries);\n }\n\n return await getShoppingListById(numericListId);\n } catch (error) {\n console.error('Error in createShoppingList:', error);\n throw error;\n }\n}\n\nexport async function getAllShoppingListsPaginated(pagination?: PaginationParams): Promise<{ shoppingLists: ShoppingList[], paginationInfo: PaginationInfo }> {\n const { page, limit, offset } = validatePaginationParams(pagination);\n \n // Get total count of shopping lists\n const countResult = await sqlite.execute(`\n SELECT COUNT(*) as total FROM ${SHOPPING_LISTS_TABLE}\n `);\n \n const total = countResult.rows[0].total as number;\n \n // Get paginated shopping lists\n const lists = await sqlite.execute(`\n SELECT id, name, created_at, updated_at\n FROM ${SHOPPING_LISTS_TABLE}\n ORDER BY created_at DESC\n LIMIT ? OFFSET ?\n `, [limit, offset]);\n\n // If no lists found, return empty results\n if (lists.rows.length === 0) {\n return {\n shoppingLists: [],\n paginationInfo: createPaginationInfo(page, limit, total)\n };\n }\n\n // Batch fetch all items for the paginated shopping lists\n const listIds = lists.rows.map(row => row.id as number);\n const placeholders = listIds.map(() => '?').join(',');\n \n const itemsResult = await sqlite.execute(`\n SELECT id, shopping_list_id, name, amount, unit, notes, checked, recipe_ids, order_index\n FROM ${SHOPPING_LIST_ITEMS_TABLE}\n WHERE shopping_list_id IN (${placeholders})\n ORDER BY shopping_list_id, order_index, name\n `, listIds);\n\n // Create a map of shopping_list_id to items for efficient lookup\n const itemsByListId = new Map();\n \n for (const row of itemsResult.rows) {\n const listId = row.shopping_list_id as number;\n if (!itemsByListId.has(listId)) {\n itemsByListId.set(listId, []);\n }\n \n itemsByListId.get(listId)!.push({\n id: row.id as number,\n shoppingListId: row.shopping_list_id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined,\n checked: Boolean(row.checked),\n recipeIds: JSON.parse(row.recipe_ids as string)\n });\n }\n\n // Build the shopping lists array with their items\n const shoppingLists: ShoppingList[] = lists.rows.map(row => ({\n id: row.id as number,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items: itemsByListId.get(row.id as number) || []\n }));\n\n return {\n shoppingLists,\n paginationInfo: createPaginationInfo(page, limit, total)\n };\n}\n\nexport async function getAllShoppingLists(): Promise {\n const lists = await sqlite.execute(`\n SELECT id, name, created_at, updated_at\n FROM ${SHOPPING_LISTS_TABLE}\n ORDER BY created_at DESC\n `);\n\n // If no lists found, return empty array\n if (lists.rows.length === 0) {\n return [];\n }\n\n // Batch fetch all items for all shopping lists in one query\n const listIds = lists.rows.map(row => row.id as number);\n const placeholders = listIds.map(() => '?').join(',');\n \n const itemsResult = await sqlite.execute(`\n SELECT id, shopping_list_id, name, amount, unit, notes, checked, recipe_ids, order_index\n FROM ${SHOPPING_LIST_ITEMS_TABLE}\n WHERE shopping_list_id IN (${placeholders})\n ORDER BY shopping_list_id, order_index, name\n `, listIds);\n\n // Create a map of shopping_list_id to items for efficient lookup\n const itemsByListId = new Map();\n \n for (const row of itemsResult.rows) {\n const listId = row.shopping_list_id as number;\n if (!itemsByListId.has(listId)) {\n itemsByListId.set(listId, []);\n }\n \n itemsByListId.get(listId)!.push({\n id: row.id as number,\n shoppingListId: row.shopping_list_id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined,\n checked: Boolean(row.checked),\n recipeIds: JSON.parse(row.recipe_ids as string)\n });\n }\n\n // Build the shopping lists array with their items\n const result: ShoppingList[] = lists.rows.map(row => ({\n id: row.id as number,\n name: row.name as string,\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string,\n items: itemsByListId.get(row.id as number) || []\n }));\n\n return result;\n}\n\nexport async function getShoppingListById(id: number): Promise {\n const lists = await sqlite.execute(`\n SELECT id, name, created_at, updated_at\n FROM ${SHOPPING_LISTS_TABLE}\n WHERE id = ?\n `, [id]);\n\n if (lists.rows.length === 0) {\n return null;\n }\n\n const row = lists.rows[0];\n const items = await getShoppingListItems(id);\n\n return {\n id: row.id as number,\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\nasync function getShoppingListItems(shoppingListId: number): Promise {\n const items = await sqlite.execute(`\n SELECT id, shopping_list_id, name, amount, unit, notes, checked, recipe_ids, order_index, category\n FROM ${SHOPPING_LIST_ITEMS_TABLE}\n WHERE shopping_list_id = ?\n ORDER BY order_index, name\n `, [shoppingListId]);\n\n return items.rows.map(row => {\n return {\n id: row.id as number,\n shoppingListId: row.shopping_list_id as number,\n name: row.name as string,\n amount: row.amount as string,\n unit: row.unit as string,\n notes: row.notes as string || undefined,\n checked: Boolean(row.checked), // Convert SQLite integer to boolean\n recipeIds: JSON.parse(row.recipe_ids as string),\n category: row.category as string || 'other'\n };\n });\n}\n\nexport async function updateShoppingListName(id: number, name: string): Promise {\n const result = await sqlite.execute(`\n UPDATE ${SHOPPING_LISTS_TABLE}\n SET name = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [name, id]);\n\n return (result.rowsAffected || 0) > 0;\n}\n\nexport async function updateShoppingListItem(id: number, updates: Partial): Promise {\n const setParts: string[] = [];\n const params: any[] = [];\n\n if (updates.checked !== undefined) {\n setParts.push('checked = ?');\n params.push(updates.checked ? 1 : 0); // Convert boolean to integer for SQLite\n }\n\n if (updates.amount !== undefined) {\n setParts.push('amount = ?');\n params.push(updates.amount);\n }\n\n if (updates.unit !== undefined) {\n setParts.push('unit = ?');\n params.push(updates.unit);\n }\n\n if (updates.notes !== undefined) {\n setParts.push('notes = ?');\n params.push(updates.notes);\n }\n\n if (setParts.length === 0) {\n return false;\n }\n\n params.push(id);\n\n const result = await sqlite.execute(`\n UPDATE ${SHOPPING_LIST_ITEMS_TABLE}\n SET ${setParts.join(', ')}\n WHERE id = ?\n `, params);\n\n return (result.rowsAffected || 0) > 0;\n}\n\nexport async function deleteShoppingList(id: number): Promise {\n const result = await sqlite.execute(`DELETE FROM ${SHOPPING_LISTS_TABLE} WHERE id = ?`, [id]);\n return (result.rowsAffected || 0) > 0;\n}\n\nexport async function deleteShoppingListItem(id: number): Promise {\n const result = await sqlite.execute(`DELETE FROM ${SHOPPING_LIST_ITEMS_TABLE} WHERE id = ?`, [id]);\n return (result.rowsAffected || 0) > 0;\n}\n\nexport async function addShoppingListItem(\n shoppingListId: number,\n name: string,\n amount?: string,\n unit?: string,\n notes?: string,\n category?: string\n): Promise {\n try {\n // Get the current maximum order_index for this shopping list\n const maxOrderResult = await sqlite.execute(`\n SELECT MAX(order_index) as max_order FROM ${SHOPPING_LIST_ITEMS_TABLE}\n WHERE shopping_list_id = ?\n `, [shoppingListId]);\n\n const maxOrder = (maxOrderResult.rows[0]?.max_order as number) ?? -1;\n const newOrderIndex = maxOrder + 1;\n\n // Categorize the ingredient if no category provided\n const itemCategory = category || categorizeIngredient(name);\n\n // Insert the new item\n const result = await sqlite.execute(`\n INSERT INTO ${SHOPPING_LIST_ITEMS_TABLE}\n (shopping_list_id, name, amount, unit, notes, recipe_ids, order_index, checked, category)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n shoppingListId,\n name.trim(),\n amount?.trim() || '',\n unit?.trim() || '',\n notes?.trim() || null,\n JSON.stringify([]), // Manual items have no recipe associations\n newOrderIndex,\n 0, // Not checked by default\n itemCategory\n ]);\n\n const newItemId = result.lastInsertRowid as number;\n\n // Return the newly created item\n return {\n id: newItemId,\n shoppingListId,\n name: name.trim(),\n amount: amount?.trim() || '',\n unit: unit?.trim() || '',\n notes: notes?.trim(),\n checked: false,\n recipeIds: [],\n category: itemCategory\n };\n } catch (error) {\n console.error('Error adding shopping list item:', error);\n return null;\n }\n}\n\n// Test function to measure ingredient normalization cache performance\nexport async function testIngredientNormalizationCache(): Promise<{\n message: string;\n metrics: {\n withoutCache: { time: number; normalizations: number };\n withCache: { time: number; normalizations: number; cacheHitRate: number };\n performanceImprovement: string;\n };\n}> {\n // Create test ingredient names with realistic duplicates\n const testIngredients = [\n 'fresh basil leaves', 'dried basil', 'basil leaves',\n 'kosher salt', 'sea salt', 'table salt', 'flaky salt',\n 'extra-virgin olive oil', 'olive oil, extra-virgin', 'olive oil',\n 'large yellow onion', 'medium yellow onion', 'yellow onion',\n 'freshly ground black pepper', 'ground black pepper', 'black pepper',\n 'unsalted butter', 'salted butter', 'butter',\n 'all-purpose flour', 'plain flour', 'flour',\n // Add duplicates to test cache effectiveness\n 'fresh basil leaves', 'kosher salt', 'extra-virgin olive oil',\n 'large yellow onion', 'freshly ground black pepper', 'unsalted butter'\n ];\n\n // Test without cache (simulate original function)\n let normalizationCount = 0;\n function normalizeWithoutCache(name: string): string {\n normalizationCount++;\n const normalized = name.toLowerCase().trim();\n \n const cleanName = normalized\n .replace(/\\b(large|medium|small|extra-large|jumbo)\\b/g, '')\n .replace(/\\b(fresh|dried|frozen|canned|chopped|diced|sliced|minced|grated|shredded)\\b/g, '')\n .replace(/\\b(whole|ground|crushed|flaked|powdered)\\b/g, '')\n .replace(/\\bparsley sprigs?\\b/g, 'parsley')\n .replace(/\\bcilantro sprigs?\\b/g, 'cilantro')\n .replace(/\\bbasil leaves?\\b/g, 'basil')\n .replace(/\\bextra-virgin olive oil\\b/g, 'olive oil')\n .replace(/\\bolive oil, extra-virgin\\b/g, 'olive oil')\n .replace(/\\bkosher salt\\b/g, 'salt')\n .replace(/\\bsea salt\\b/g, 'salt')\n .replace(/\\btable salt\\b/g, 'salt')\n .replace(/\\bflaky salt\\b/g, 'salt')\n .replace(/\\bflaky sea salt\\b/g, 'salt')\n .replace(/\\bfreshly ground black pepper\\b/g, 'black pepper')\n .replace(/\\bground black pepper\\b/g, 'black pepper')\n .replace(/\\bblack peppercorns?\\b/g, 'black pepper')\n .replace(/\\bunsalted butter\\b/g, 'butter')\n .replace(/\\bsalted butter\\b/g, 'butter')\n .replace(/\\ball-purpose flour\\b/g, 'flour')\n .replace(/\\bplain flour\\b/g, 'flour')\n .replace(/\\s+/g, ' ')\n .trim();\n \n return cleanName || normalized;\n }\n\n const startTimeWithoutCache = Date.now();\n testIngredients.forEach(normalizeWithoutCache);\n const timeWithoutCache = Date.now() - startTimeWithoutCache;\n\n // Test with cache\n const cache = new Map();\n let cacheHits = 0;\n let cachedNormalizationCount = 0;\n\n function normalizeWithCache(name: string): string {\n if (cache.has(name)) {\n cacheHits++;\n return cache.get(name)!;\n }\n \n cachedNormalizationCount++;\n const normalized = name.toLowerCase().trim();\n \n const cleanName = normalized\n .replace(/\\b(large|medium|small|extra-large|jumbo)\\b/g, '')\n .replace(/\\b(fresh|dried|frozen|canned|chopped|diced|sliced|minced|grated|shredded)\\b/g, '')\n .replace(/\\b(whole|ground|crushed|flaked|powdered)\\b/g, '')\n .replace(/\\bparsley sprigs?\\b/g, 'parsley')\n .replace(/\\bcilantro sprigs?\\b/g, 'cilantro')\n .replace(/\\bbasil leaves?\\b/g, 'basil')\n .replace(/\\bextra-virgin olive oil\\b/g, 'olive oil')\n .replace(/\\bolive oil, extra-virgin\\b/g, 'olive oil')\n .replace(/\\bkosher salt\\b/g, 'salt')\n .replace(/\\bsea salt\\b/g, 'salt')\n .replace(/\\btable salt\\b/g, 'salt')\n .replace(/\\bflaky salt\\b/g, 'salt')\n .replace(/\\bflaky sea salt\\b/g, 'salt')\n .replace(/\\bfreshly ground black pepper\\b/g, 'black pepper')\n .replace(/\\bground black pepper\\b/g, 'black pepper')\n .replace(/\\bblack peppercorns?\\b/g, 'black pepper')\n .replace(/\\bunsalted butter\\b/g, 'butter')\n .replace(/\\bsalted butter\\b/g, 'butter')\n .replace(/\\ball-purpose flour\\b/g, 'flour')\n .replace(/\\bplain flour\\b/g, 'flour')\n .replace(/\\s+/g, ' ')\n .trim();\n \n const result = cleanName || normalized;\n cache.set(name, result);\n return result;\n }\n\n const startTimeWithCache = Date.now();\n testIngredients.forEach(normalizeWithCache);\n const timeWithCache = Date.now() - startTimeWithCache;\n\n const cacheHitRate = (cacheHits / testIngredients.length) * 100;\n const improvementPercentage = ((timeWithoutCache - timeWithCache) / timeWithoutCache * 100).toFixed(1);\n\n return {\n message: 'Ingredient normalization cache performance test completed',\n metrics: {\n withoutCache: {\n time: timeWithoutCache,\n normalizations: normalizationCount\n },\n withCache: {\n time: timeWithCache,\n normalizations: cachedNormalizationCount,\n cacheHitRate: Math.round(cacheHitRate * 100) / 100\n },\n performanceImprovement: `${improvementPercentage}% faster with cache`\n }\n };\n}\n\n// Excluded Ingredients Functions\n\nexport async function getAllExcludedIngredients(): Promise {\n const result = await sqlite.execute(`\n SELECT id, name, pattern, created_at\n FROM ${EXCLUDED_INGREDIENTS_TABLE}\n ORDER BY name\n `);\n\n return result.rows.map(row => ({\n id: row.id as number,\n name: row.name as string,\n pattern: row.pattern as string,\n createdAt: row.created_at as string\n }));\n}\n\nexport async function addExcludedIngredient(name: string, pattern: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${EXCLUDED_INGREDIENTS_TABLE} (name, pattern)\n VALUES (?, ?)\n `, [name.trim(), pattern.trim()]);\n\n const ingredientId = result.lastInsertRowid;\n if (!ingredientId) {\n throw new Error('Failed to create excluded ingredient');\n }\n\n const numericId = typeof ingredientId === 'string' ? parseInt(ingredientId, 10) : Number(ingredientId);\n \n // Return the created ingredient\n const created = await sqlite.execute(`\n SELECT id, name, pattern, created_at\n FROM ${EXCLUDED_INGREDIENTS_TABLE}\n WHERE id = ?\n `, [numericId]);\n\n const row = created.rows[0];\n return {\n id: row.id as number,\n name: row.name as string,\n pattern: row.pattern as string,\n createdAt: row.created_at as string\n };\n}\n\nexport async function deleteExcludedIngredient(id: number): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${EXCLUDED_INGREDIENTS_TABLE} WHERE id = ?\n `, [id]);\n \n return (result.rowsAffected || 0) > 0;\n}\n\nfunction isIngredientExcluded(ingredientName: string, excludedIngredients: ExcludedIngredient[]): boolean {\n const normalizedName = ingredientName.toLowerCase().trim();\n\n return excludedIngredients.some(excluded => {\n const pattern = excluded.pattern.toLowerCase().trim();\n return normalizedName.includes(pattern);\n });\n}\n\n// ============================================================================\n// MEAL PLAN QUERIES\n// ============================================================================\n\n// Create a new meal plan\nexport async function createMealPlan(mealPlan: Omit): Promise {\n console.log('🍽️ Creating meal plan:', mealPlan);\n\n // Validate recipe exists first using transaction\n const queries = [\n {\n sql: `SELECT id FROM ${RECIPES_TABLE} WHERE id = ?`,\n params: [mealPlan.recipeId]\n },\n {\n sql: `INSERT INTO ${MEAL_PLANS_TABLE} (recipe_id, date, meal_type, notes) VALUES (?, ?, ?, ?)`,\n params: [mealPlan.recipeId, mealPlan.date, mealPlan.mealType, mealPlan.notes || null]\n }\n ];\n\n try {\n const results = await executeTransaction(queries);\n\n // Check if recipe exists\n if (!results[0].rows.length) {\n throw new Error('Recipe not found');\n }\n\n const insertResult = results[1];\n const mealPlanId = insertResult.lastInsertRowid;\n\n // Fetch the created meal plan\n const createdMealPlan = await getMealPlanById(mealPlanId);\n if (!createdMealPlan) {\n throw new Error('Failed to fetch created meal plan');\n }\n\n console.log('✅ Meal plan created successfully:', createdMealPlan);\n return createdMealPlan;\n } catch (error) {\n console.error('❌ Failed to create meal plan:', error);\n throw error;\n }\n}\n\n// Get meal plan by ID\nexport async function getMealPlanById(id: number): Promise {\n console.log('🔍 Fetching meal plan by ID:', id);\n\n const result = await sqlite.execute(`\n SELECT\n mp.id,\n mp.recipe_id as recipeId,\n mp.date,\n mp.meal_type as mealType,\n mp.notes,\n mp.created_at as createdAt,\n mp.updated_at as updatedAt,\n r.id as recipe_id,\n r.title as recipe_title,\n r.description as recipe_description,\n r.servings as recipe_servings,\n r.prep_time as recipe_prep_time,\n r.cook_time as recipe_cook_time,\n r.difficulty as recipe_difficulty,\n r.tags as recipe_tags,\n r.source as recipe_source,\n r.image_url as recipe_image_url,\n r.steps as recipe_steps,\n r.created_at as recipe_created_at,\n r.updated_at as recipe_updated_at\n FROM ${MEAL_PLANS_TABLE} mp\n LEFT JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.id = ?\n `, [id]);\n\n if (!result.rows.length) {\n console.log('❌ No meal plan found with ID:', id);\n return null;\n }\n\n const row = result.rows[0];\n const mealPlan: MealPlan = {\n id: row.id,\n recipeId: row.recipeId,\n date: row.date,\n mealType: row.mealType,\n notes: row.notes,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt,\n recipe: row.recipe_id ? {\n id: row.recipe_id,\n title: row.recipe_title,\n description: row.recipe_description,\n servings: row.recipe_servings,\n prepTime: row.recipe_prep_time,\n cookTime: row.recipe_cook_time,\n difficulty: row.recipe_difficulty,\n tags: row.recipe_tags ? JSON.parse(row.recipe_tags) : [],\n source: row.recipe_source,\n imageUrl: row.recipe_image_url,\n steps: JSON.parse(row.recipe_steps),\n ingredients: [], // Will be populated separately if needed\n createdAt: row.recipe_created_at,\n updatedAt: row.recipe_updated_at\n } : null\n };\n\n console.log('✅ Fetched meal plan:', mealPlan);\n return mealPlan;\n}\n\n// Get meal plans for a date range\nexport async function getMealPlansForDateRange(startDate: string, endDate: string): Promise {\n console.log('📅 Fetching meal plans for date range:', startDate, 'to', endDate);\n\n const result = await sqlite.execute(`\n SELECT\n mp.id,\n mp.recipe_id as recipeId,\n mp.date,\n mp.meal_type as mealType,\n mp.notes,\n mp.created_at as createdAt,\n mp.updated_at as updatedAt,\n r.id as recipe_id,\n r.title as recipe_title,\n r.description as recipe_description,\n r.servings as recipe_servings,\n r.prep_time as recipe_prep_time,\n r.cook_time as recipe_cook_time,\n r.difficulty as recipe_difficulty,\n r.tags as recipe_tags,\n r.source as recipe_source,\n r.image_url as recipe_image_url,\n r.steps as recipe_steps,\n r.created_at as recipe_created_at,\n r.updated_at as recipe_updated_at\n FROM ${MEAL_PLANS_TABLE} mp\n LEFT JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.date BETWEEN ? AND ?\n ORDER BY mp.date, mp.meal_type, mp.id\n `, [startDate, endDate]);\n\n const mealPlans: MealPlan[] = result.rows.map(row => ({\n id: row.id,\n recipeId: row.recipeId,\n date: row.date,\n mealType: row.mealType,\n notes: row.notes,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt,\n recipe: row.recipe_id ? {\n id: row.recipe_id,\n title: row.recipe_title,\n description: row.recipe_description,\n servings: row.recipe_servings,\n prepTime: row.recipe_prep_time,\n cookTime: row.recipe_cook_time,\n difficulty: row.recipe_difficulty,\n tags: row.recipe_tags ? JSON.parse(row.recipe_tags) : [],\n source: row.recipe_source,\n imageUrl: row.recipe_image_url,\n steps: JSON.parse(row.recipe_steps),\n ingredients: [], // Will be populated separately if needed\n createdAt: row.recipe_created_at,\n updatedAt: row.recipe_updated_at\n } : null\n }));\n\n console.log(`✅ Fetched ${mealPlans.length} meal plans for date range`);\n return mealPlans;\n}\n\n// Update meal plan\nexport async function updateMealPlan(id: number, updates: Partial): Promise {\n console.log('📝 Updating meal plan ID:', id, 'with updates:', updates);\n\n const queries = [];\n\n // If updating recipe ID, validate it exists\n if (updates.recipeId) {\n queries.push({\n sql: `SELECT id FROM ${RECIPES_TABLE} WHERE id = ?`,\n params: [updates.recipeId]\n });\n }\n\n // Build update query\n const updateFields = [];\n const updateParams = [];\n\n if (updates.recipeId !== undefined) {\n updateFields.push('recipe_id = ?');\n updateParams.push(updates.recipeId);\n }\n if (updates.date !== undefined) {\n updateFields.push('date = ?');\n updateParams.push(updates.date);\n }\n if (updates.mealType !== undefined) {\n updateFields.push('meal_type = ?');\n updateParams.push(updates.mealType);\n }\n if (updates.notes !== undefined) {\n updateFields.push('notes = ?');\n updateParams.push(updates.notes);\n }\n\n if (updateFields.length === 0) {\n console.log('⚠️ No valid fields to update');\n return await getMealPlanById(id);\n }\n\n updateFields.push('updated_at = CURRENT_TIMESTAMP');\n updateParams.push(id);\n\n queries.push({\n sql: `UPDATE ${MEAL_PLANS_TABLE} SET ${updateFields.join(', ')} WHERE id = ?`,\n params: updateParams\n });\n\n try {\n const results = await executeTransaction(queries);\n\n // If we validated recipe ID, check it exists\n if (updates.recipeId && !results[0].rows.length) {\n throw new Error('Recipe not found');\n }\n\n const updateIndex = updates.recipeId ? 1 : 0;\n if ((results[updateIndex].rowsAffected || 0) === 0) {\n console.log('❌ No meal plan found with ID:', id);\n return null;\n }\n\n const updatedMealPlan = await getMealPlanById(id);\n console.log('✅ Meal plan updated successfully:', updatedMealPlan);\n return updatedMealPlan;\n } catch (error) {\n console.error('❌ Failed to update meal plan:', error);\n throw error;\n }\n}\n\n// Delete meal plan\nexport async function deleteMealPlan(id: number): Promise {\n console.log('🗑️ Deleting meal plan ID:', id);\n\n const result = await sqlite.execute(`\n DELETE FROM ${MEAL_PLANS_TABLE} WHERE id = ?\n `, [id]);\n\n const success = (result.rowsAffected || 0) > 0;\n console.log(success ? '✅ Meal plan deleted successfully' : '❌ No meal plan found with that ID');\n return success;\n}\n\n// Get recipe IDs from meal plans for shopping list generation\nexport async function getRecipeIdsFromMealPlans(startDate?: string, endDate?: string, dates?: string[]): Promise {\n console.log('🛒 Getting recipe IDs for shopping list from meal plans');\n\n let sql: string;\n let params: any[];\n\n if (dates && dates.length > 0) {\n // Use specific dates\n const placeholders = dates.map(() => '?').join(',');\n sql = `\n SELECT DISTINCT mp.recipe_id\n FROM ${MEAL_PLANS_TABLE} mp\n INNER JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.date IN (${placeholders})\n `;\n params = dates;\n } else if (startDate && endDate) {\n // Use date range\n sql = `\n SELECT DISTINCT mp.recipe_id\n FROM ${MEAL_PLANS_TABLE} mp\n INNER JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.date BETWEEN ? AND ?\n `;\n params = [startDate, endDate];\n } else {\n throw new Error('Either dates array or startDate/endDate must be provided');\n }\n\n const result = await sqlite.execute(sql, params);\n const recipeIds = result.rows.map(row => row.recipe_id);\n\n console.log(`✅ Found ${recipeIds.length} unique recipes for shopping list`);\n return recipeIds;\n}\n\n// Get recipe details with date information from meal plans for shopping list generation\nexport async function getRecipeDetailsFromMealPlans(startDate?: string, endDate?: string, dates?: string[]): Promise<{recipeIds: number[], recipeToDateMap: Record}> {\n console.log('🛒 Getting recipe details with dates for shopping list from meal plans');\n\n let sql: string;\n let params: any[];\n\n if (dates && dates.length > 0) {\n // Use specific dates\n const placeholders = dates.map(() => '?').join(',');\n sql = `\n SELECT mp.recipe_id, mp.date, r.title\n FROM ${MEAL_PLANS_TABLE} mp\n INNER JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.date IN (${placeholders})\n ORDER BY mp.date, r.title\n `;\n params = dates;\n } else if (startDate && endDate) {\n // Use date range\n sql = `\n SELECT mp.recipe_id, mp.date, r.title\n FROM ${MEAL_PLANS_TABLE} mp\n INNER JOIN ${RECIPES_TABLE} r ON mp.recipe_id = r.id\n WHERE mp.date BETWEEN ? AND ?\n ORDER BY mp.date, r.title\n `;\n params = [startDate, endDate];\n } else {\n throw new Error('Either dates array or startDate/endDate must be provided');\n }\n\n const result = await sqlite.execute(sql, params);\n\n // Build mapping of recipe ID to dates\n const recipeToDateMap: Record = {};\n const recipeIdsSet = new Set();\n\n for (const row of result.rows) {\n const recipeId = row.recipe_id;\n const date = row.date;\n\n recipeIdsSet.add(recipeId);\n\n if (!recipeToDateMap[recipeId]) {\n recipeToDateMap[recipeId] = [];\n }\n if (!recipeToDateMap[recipeId].includes(date)) {\n recipeToDateMap[recipeId].push(date);\n }\n }\n\n const recipeIds = Array.from(recipeIdsSet);\n\n console.log(`✅ Found ${recipeIds.length} unique recipes for shopping list with date mapping`);\n return { recipeIds, recipeToDateMap };\n}",[],[99,215,232],[99,215],{"_104":242,"_95":243,"_154":244,"_156":209,"_157":139,"_158":176,"_160":161,"_106":245,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":246,"_98":293},"9e4604d4-494d-11f0-9177-76b3cceeab13","routes","efd2e129-3d21-4605-9278-9a564a0e49b2",["D",1749925816509],[247,256,264,274,283],{"_104":248,"_95":249,"_154":250,"_156":244,"_157":139,"_158":251,"_160":161,"_106":252,"_100":32,"_163":226,"_165":253,"_166":22,"_167":-5,"_168":254,"_98":255},"9317127a-8ebb-11f0-8ea1-0224a6c84d84","excluded-ingredients.ts","93171310-8ebb-11f0-8ea1-0224a6c84d84",327,["D",1757559672620],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ExcludedIngredient, ApiResponse } from \"../../shared/types.ts\";\nimport { \n getAllExcludedIngredients,\n addExcludedIngredient,\n deleteExcludedIngredient\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all excluded ingredients\napp.get('/', async (c) => {\n try {\n const excludedIngredients = await getAllExcludedIngredients();\n return c.json({ success: true, data: excludedIngredients } as ApiResponse);\n } catch (error) {\n console.error('Error fetching excluded ingredients:', error);\n return c.json({ success: false, error: 'Failed to fetch excluded ingredients' } as ApiResponse, 500);\n }\n});\n\n// Add a new excluded ingredient\napp.post('/', async (c) => {\n try {\n const { name, pattern } = await c.req.json();\n \n if (!name || !pattern || typeof name !== 'string' || typeof pattern !== 'string') {\n return c.json({ \n success: false, \n error: 'Name and pattern are required and must be strings' \n } as ApiResponse, 400);\n }\n\n const trimmedName = name.trim();\n const trimmedPattern = pattern.trim();\n\n if (trimmedName.length === 0 || trimmedPattern.length === 0) {\n return c.json({ \n success: false, \n error: 'Name and pattern cannot be empty' \n } as ApiResponse, 400);\n }\n\n const excludedIngredient = await addExcludedIngredient(trimmedName, trimmedPattern);\n return c.json({ success: true, data: excludedIngredient } as ApiResponse, 201);\n } catch (error) {\n console.error('Error adding excluded ingredient:', error);\n \n // Check if it's a unique constraint error\n if (error.message && error.message.includes('UNIQUE constraint failed')) {\n return c.json({ \n success: false, \n error: 'An excluded ingredient with this name already exists' \n } as ApiResponse, 409);\n }\n \n return c.json({ success: false, error: 'Failed to add excluded ingredient' } as ApiResponse, 500);\n }\n});\n\n// Delete an excluded ingredient\napp.delete('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid excluded ingredient ID' } as ApiResponse, 400);\n }\n\n const deleted = await deleteExcludedIngredient(id);\n if (!deleted) {\n return c.json({ success: false, error: 'Excluded ingredient not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: { deleted: true } } as ApiResponse);\n } catch (error) {\n console.error('Error deleting excluded ingredient:', error);\n return c.json({ success: false, error: 'Failed to delete excluded ingredient' } as ApiResponse, 500);\n }\n});\n\nexport default app;",[],[99,243,249],{"_104":257,"_95":258,"_154":259,"_156":244,"_157":139,"_158":223,"_160":161,"_106":260,"_100":32,"_163":226,"_165":261,"_166":22,"_167":-5,"_168":262,"_98":263},"9aba7158-9121-11f0-b677-0224a6c84d84","meal-plans.ts","9aba71ee-9121-11f0-b677-0224a6c84d84",["D",1757823396415],"import { Hono } from \"https://esm.sh/hono@4.2.7\";\nimport type { ApiResponse, CreateMealPlanRequest, CreateShoppingListFromCalendarRequest } from \"../../shared/types.ts\";\nimport {\n createMealPlan,\n getMealPlanById,\n getMealPlansForDateRange,\n updateMealPlan,\n deleteMealPlan,\n getRecipeIdsFromMealPlans,\n getRecipeDetailsFromMealPlans,\n createShoppingList\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// GET /api/meal-plans - Get meal plans for date range\napp.get('/', async (c) => {\n try {\n const startDate = c.req.query('startDate');\n const endDate = c.req.query('endDate');\n\n if (!startDate || !endDate) {\n return c.json({\n success: false,\n error: 'startDate and endDate query parameters are required'\n } as ApiResponse, 400);\n }\n\n // Validate date format (YYYY-MM-DD)\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(startDate) || !dateRegex.test(endDate)) {\n return c.json({\n success: false,\n error: 'Dates must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n\n // Validate date range\n if (startDate > endDate) {\n return c.json({\n success: false,\n error: 'startDate must be before or equal to endDate'\n } as ApiResponse, 400);\n }\n\n console.log(`📅 Fetching meal plans from ${startDate} to ${endDate}`);\n const mealPlans = await getMealPlansForDateRange(startDate, endDate);\n\n return c.json({\n success: true,\n data: mealPlans\n } as ApiResponse);\n\n } catch (error) {\n console.error('❌ Error fetching meal plans:', error);\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch meal plans'\n } as ApiResponse, 500);\n }\n});\n\n// POST /api/meal-plans - Create new meal plan\napp.post('/', async (c) => {\n try {\n const body = await c.req.json() as CreateMealPlanRequest;\n\n // Validate required fields\n if (!body.recipeId || !body.date || !body.mealType) {\n return c.json({\n success: false,\n error: 'recipeId, date, and mealType are required'\n } as ApiResponse, 400);\n }\n\n // Validate date format\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(body.date)) {\n return c.json({\n success: false,\n error: 'Date must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n\n // Validate meal type\n const validMealTypes = ['breakfast-lunch', 'dinner'];\n if (!validMealTypes.includes(body.mealType)) {\n return c.json({\n success: false,\n error: 'mealType must be one of: breakfast-lunch, dinner'\n } as ApiResponse, 400);\n }\n\n console.log('🍽️ Creating new meal plan:', body);\n const mealPlan = await createMealPlan(body);\n\n return c.json({\n success: true,\n data: mealPlan\n } as ApiResponse, 201);\n\n } catch (error) {\n console.error('❌ Error creating meal plan:', error);\n const statusCode = error instanceof Error && error.message === 'Recipe not found' ? 404 : 500;\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to create meal plan'\n } as ApiResponse, statusCode);\n }\n});\n\n// GET /api/meal-plans/:id - Get specific meal plan\napp.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: 'Invalid meal plan ID'\n } as ApiResponse, 400);\n }\n\n console.log('🔍 Fetching meal plan by ID:', id);\n const mealPlan = await getMealPlanById(id);\n\n if (!mealPlan) {\n return c.json({\n success: false,\n error: 'Meal plan not found'\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: mealPlan\n } as ApiResponse);\n\n } catch (error) {\n console.error('❌ Error fetching meal plan:', error);\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch meal plan'\n } as ApiResponse, 500);\n }\n});\n\n// PUT /api/meal-plans/:id - Update meal plan\napp.put('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: 'Invalid meal plan ID'\n } as ApiResponse, 400);\n }\n\n const body = await c.req.json();\n\n // Validate date format if provided\n if (body.date) {\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(body.date)) {\n return c.json({\n success: false,\n error: 'Date must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n }\n\n // Validate meal type if provided\n if (body.mealType) {\n const validMealTypes = ['breakfast-lunch', 'dinner'];\n if (!validMealTypes.includes(body.mealType)) {\n return c.json({\n success: false,\n error: 'mealType must be one of: breakfast-lunch, dinner'\n } as ApiResponse, 400);\n }\n }\n\n console.log('📝 Updating meal plan ID:', id, 'with data:', body);\n const updatedMealPlan = await updateMealPlan(id, body);\n\n if (!updatedMealPlan) {\n return c.json({\n success: false,\n error: 'Meal plan not found'\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: updatedMealPlan\n } as ApiResponse);\n\n } catch (error) {\n console.error('❌ Error updating meal plan:', error);\n const statusCode = error instanceof Error && error.message === 'Recipe not found' ? 404 : 500;\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to update meal plan'\n } as ApiResponse, statusCode);\n }\n});\n\n// DELETE /api/meal-plans/:id - Delete meal plan\napp.delete('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: 'Invalid meal plan ID'\n } as ApiResponse, 400);\n }\n\n console.log('🗑️ Deleting meal plan ID:', id);\n const deleted = await deleteMealPlan(id);\n\n if (!deleted) {\n return c.json({\n success: false,\n error: 'Meal plan not found'\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: { deleted: true }\n } as ApiResponse);\n\n } catch (error) {\n console.error('❌ Error deleting meal plan:', error);\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to delete meal plan'\n } as ApiResponse, 500);\n }\n});\n\n// POST /api/meal-plans/shopping-list - Create shopping list from meal plans\napp.post('/shopping-list', async (c) => {\n try {\n const body = await c.req.json() as CreateShoppingListFromCalendarRequest;\n\n // Validate input - must have either date range or specific dates\n if (!body.dates && (!body.startDate || !body.endDate)) {\n return c.json({\n success: false,\n error: 'Either dates array or startDate/endDate must be provided'\n } as ApiResponse, 400);\n }\n\n // Validate date formats\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n\n if (body.startDate && !dateRegex.test(body.startDate)) {\n return c.json({\n success: false,\n error: 'startDate must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n\n if (body.endDate && !dateRegex.test(body.endDate)) {\n return c.json({\n success: false,\n error: 'endDate must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n\n if (body.dates) {\n for (const date of body.dates) {\n if (!dateRegex.test(date)) {\n return c.json({\n success: false,\n error: 'All dates must be in YYYY-MM-DD format'\n } as ApiResponse, 400);\n }\n }\n }\n\n // Validate date range\n if (body.startDate && body.endDate && body.startDate > body.endDate) {\n return c.json({\n success: false,\n error: 'startDate must be before or equal to endDate'\n } as ApiResponse, 400);\n }\n\n console.log('🛒 Creating shopping list from meal plans:', body);\n\n // Get recipe details with date mapping from meal plans\n const { recipeIds, recipeToDateMap } = await getRecipeDetailsFromMealPlans(\n body.startDate,\n body.endDate,\n body.dates\n );\n\n if (recipeIds.length === 0) {\n return c.json({\n success: false,\n error: 'No recipes found in the specified date range'\n } as ApiResponse, 404);\n }\n\n // Generate shopping list name\n let listName: string;\n if (body.dates && body.dates.length > 0) {\n if (body.dates.length === 1) {\n listName = `Shopping List for ${body.dates[0]}`;\n } else {\n listName = `Shopping List for ${body.dates.length} days`;\n }\n } else {\n listName = `Shopping List: ${body.startDate} to ${body.endDate}`;\n }\n\n // Create shopping list using existing function\n const shoppingList = await createShoppingList(listName, recipeIds);\n\n // Add the recipe-to-date mapping to the shopping list\n shoppingList.recipeToDateMap = recipeToDateMap;\n\n console.log('✅ Shopping list created from meal plans:', shoppingList);\n\n return c.json({\n success: true,\n data: shoppingList\n } as ApiResponse, 201);\n\n } catch (error) {\n console.error('❌ Error creating shopping list from meal plans:', error);\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to create shopping list'\n } as ApiResponse, 500);\n }\n});\n\nexport default app;",[],[99,243,258],{"_104":265,"_95":266,"_154":267,"_156":244,"_157":139,"_158":268,"_160":161,"_106":269,"_100":270,"_163":226,"_165":271,"_166":22,"_167":-5,"_168":272,"_98":273},"c1c888a6-8eb1-11f0-9b08-0224a6c84d84","parse.ts","d3471326-51cc-11f0-bcd5-f69ea79377d9",263,["D",1757555455984],4,"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { parse as parseHtml } from \"https://esm.sh/node-html-parser@6.1.12\";\nimport { extractText, getDocumentProxy } from \"https://esm.sh/unpdf@1.0.6\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport type { ParseRequest, ParseResponse, Recipe } from \"../../shared/types.ts\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Function to validate and clean recipe data\nfunction validateAndCleanRecipe(recipe: any): Recipe {\n // Ensure required fields exist\n if (!recipe.title || typeof recipe.title !== \"string\") {\n throw new Error(\"Recipe must have a valid title\");\n }\n\n if (!recipe.ingredients || !Array.isArray(recipe.ingredients) || recipe.ingredients.length === 0) {\n throw new Error(\"Recipe must have at least one ingredient\");\n }\n\n if (!recipe.steps || !Array.isArray(recipe.steps) || recipe.steps.length === 0) {\n throw new Error(\"Recipe must have at least one step\");\n }\n\n // Clean and validate ingredients\n const cleanedIngredients = recipe.ingredients.map((ingredient: any, index: number) => {\n if (!ingredient.name || typeof ingredient.name !== \"string\") {\n throw new Error(`Ingredient ${index + 1} must have a valid name`);\n }\n\n // Convert amount to string if it's a number\n let amount = ingredient.amount;\n if (typeof amount === \"number\") {\n amount = amount.toString();\n } else if (typeof amount !== \"string\") {\n amount = \"\";\n }\n\n // Ensure unit is a string\n let unit = ingredient.unit;\n if (typeof unit !== \"string\") {\n unit = \"\";\n }\n\n return {\n name: ingredient.name.trim(),\n amount: amount.trim(),\n unit: unit.trim(),\n notes: ingredient.notes && typeof ingredient.notes === \"string\" ? ingredient.notes.trim() : undefined,\n };\n });\n\n // Clean steps\n const cleanedSteps = recipe.steps.map((step: any) => {\n if (typeof step !== \"string\") {\n return String(step);\n }\n return step.trim();\n }).filter((step: string) => step.length > 0);\n\n return {\n title: recipe.title.trim(),\n description: recipe.description && typeof recipe.description === \"string\" ? recipe.description.trim() : undefined,\n ingredients: cleanedIngredients,\n steps: cleanedSteps,\n servings: typeof recipe.servings === \"number\" ? recipe.servings : undefined,\n prepTime: typeof recipe.prepTime === \"number\" ? recipe.prepTime : undefined,\n cookTime: typeof recipe.cookTime === \"number\" ? recipe.cookTime : undefined,\n difficulty: [\"easy\", \"medium\", \"hard\"].includes(recipe.difficulty) ? recipe.difficulty : undefined,\n tags: Array.isArray(recipe.tags) ? recipe.tags.filter(tag => typeof tag === \"string\") : undefined,\n source: recipe.source && typeof recipe.source === \"string\" ? recipe.source.trim() : undefined,\n imageUrl: recipe.imageUrl && typeof recipe.imageUrl === \"string\" ? recipe.imageUrl.trim() : undefined,\n };\n}\n\n// Function to safely escape regex special characters\nfunction escapeRegex(string: string): string {\n return string.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\");\n}\n\n// Function to convert fractional Unicode characters to decimal values\nfunction convertFractionsToDecimals(text: string): string {\n const fractionMap: { [key: string]: string } = {\n \"¼\": \"0.25\",\n \"½\": \"0.5\",\n \"¾\": \"0.75\",\n \"⅐\": \"0.142857\",\n \"⅑\": \"0.111111\",\n \"⅒\": \"0.1\",\n \"⅓\": \"0.333333\",\n \"⅔\": \"0.666667\",\n \"⅕\": \"0.2\",\n \"⅖\": \"0.4\",\n \"⅗\": \"0.6\",\n \"⅘\": \"0.8\",\n \"⅙\": \"0.166667\",\n \"⅚\": \"0.833333\",\n \"⅛\": \"0.125\",\n \"⅜\": \"0.375\",\n \"⅝\": \"0.625\",\n \"⅞\": \"0.875\",\n \"⅟\": \"1\",\n };\n\n let result = text;\n\n // Replace Unicode fractions with decimal equivalents\n for (const [fraction, decimal] of Object.entries(fractionMap)) {\n const escapedFraction = escapeRegex(fraction);\n result = result.replace(new RegExp(escapedFraction, \"g\"), decimal);\n }\n\n // Handle mixed numbers like \"1¼\" -> \"1.25\"\n const fractionChars = Object.keys(fractionMap).map(escapeRegex).join(\"\");\n result = result.replace(new RegExp(`(\\\\d+)([${fractionChars}])`, \"g\"), (match, whole, fraction) => {\n const fractionValue = fractionMap[fraction] || fraction;\n return (parseFloat(whole) + parseFloat(fractionValue)).toString();\n });\n\n // Handle simple fractions like \"1/4\" -> \"0.25\"\n result = result.replace(/(\\d+)\\/(\\d+)/g, (match, numerator, denominator) => {\n const decimal = parseFloat(numerator) / parseFloat(denominator);\n return decimal.toString();\n });\n\n // Handle fraction slash separately\n result = result.replace(/⁄/g, \"/\");\n\n return result;\n}\n\n// Function to convert ISO 8601 duration to minutes\nfunction parseDurationToMinutes(duration: string): number | undefined {\n if (!duration || typeof duration !== \"string\") return undefined;\n\n // Handle ISO 8601 format (PT15M, PT1H30M, etc.)\n const iso8601Match = duration.match(/PT(?:(\\d+)H)?(?:(\\d+)M)?/);\n if (iso8601Match) {\n const hours = parseInt(iso8601Match[1] || \"0\");\n const minutes = parseInt(iso8601Match[2] || \"0\");\n return hours * 60 + minutes;\n }\n\n // Handle simple number formats\n const numberMatch = duration.match(/(\\d+)/);\n if (numberMatch) {\n return parseInt(numberMatch[1]);\n }\n\n return undefined;\n}\n\n// Function to extract and clean HTML content for recipe parsing using proper HTML parser\nfunction extractRecipeContent(html: string): string {\n console.log(\"🔍 Starting HTML content extraction with node-html-parser...\");\n console.log(`📄 Original HTML length: ${html.length} characters`);\n\n try {\n // Parse HTML with node-html-parser\n console.log(\"🔄 Parsing HTML document...\");\n const root = parseHtml(html, {\n lowerCaseTagName: true,\n comment: false,\n blockTextElements: {\n script: false,\n noscript: false,\n style: false,\n },\n });\n\n // Remove unwanted elements\n console.log(\"🧹 Removing unwanted elements...\");\n const unwantedSelectors = [\n \"script\",\n \"style\",\n \"noscript\",\n \"nav\",\n \"header\",\n \"footer\",\n \"aside\",\n \"[class*=\\\"ad\\\"]\",\n \"[class*=\\\"advertisement\\\"]\",\n \"[class*=\\\"sidebar\\\"]\",\n \"[class*=\\\"menu\\\"]\",\n \"[class*=\\\"navigation\\\"]\",\n \"[id*=\\\"ad\\\"]\",\n \"[id*=\\\"advertisement\\\"]\",\n \"[id*=\\\"sidebar\\\"]\",\n \"[id*=\\\"menu\\\"]\",\n \"[id*=\\\"navigation\\\"]\",\n \".social-share\",\n \".comments\",\n \".newsletter\",\n \".popup\",\n \".modal\",\n ];\n\n let removedCount = 0;\n unwantedSelectors.forEach(selector => {\n const elements = root.querySelectorAll(selector);\n elements.forEach(element => {\n element.remove();\n removedCount++;\n });\n });\n console.log(`🗑️ Removed ${removedCount} unwanted elements`);\n\n // Look for recipe-specific structured data first\n console.log(\"🔍 Looking for structured recipe data...\");\n let structuredData = \"\";\n\n // Check for JSON-LD structured data\n const jsonLdScripts = root.querySelectorAll(\"script[type=\\\"application/ld+json\\\"]\");\n jsonLdScripts.forEach(script => {\n try {\n const data = JSON.parse(script.innerHTML);\n if (data[\"@type\"] === \"Recipe\" || (Array.isArray(data) && data.some(item => item[\"@type\"] === \"Recipe\"))) {\n structuredData += `STRUCTURED DATA: ${JSON.stringify(data, null, 2)}\\n\\n`;\n console.log(\"✅ Found JSON-LD recipe structured data\");\n }\n } catch (e) {\n // Ignore invalid JSON\n }\n });\n\n // Look for microdata recipe markup\n const recipeElements = root.querySelectorAll(\"[itemtype*=\\\"Recipe\\\"], [itemscope][itemtype*=\\\"recipe\\\"]\");\n if (recipeElements.length > 0) {\n console.log(`✅ Found ${recipeElements.length} microdata recipe elements`);\n recipeElements.forEach(element => {\n structuredData += `MICRODATA RECIPE: ${element.text}\\n\\n`;\n });\n }\n\n // Extract content from recipe-focused selectors\n console.log(\"🔍 Extracting content from recipe-focused selectors...\");\n const recipeSelectors = [\n // Recipe-specific selectors\n \"[class*=\\\"recipe\\\"]\",\n \"[id*=\\\"recipe\\\"]\",\n \".ingredients\",\n \".instructions\",\n \".directions\",\n \".method\",\n \".preparation\",\n \".cooking-instructions\",\n // Content selectors in order of importance\n \"article\",\n \"main\",\n \"[role=\\\"main\\\"]\",\n \".content\",\n \".post-content\",\n \".entry-content\",\n // Headings and text content\n \"h1\",\n \"h2\",\n \"h3\",\n \"h4\",\n \"h5\",\n \"h6\",\n \"p\",\n \"ul\",\n \"ol\",\n \"li\",\n \"div\",\n ];\n\n let extractedContent = structuredData;\n const selectorStats: Record = {};\n\n for (const selector of recipeSelectors) {\n const elements = root.querySelectorAll(selector);\n if (elements.length > 0) {\n selectorStats[selector] = elements.length;\n elements.forEach(element => {\n const text = element.text.trim();\n if (text && text.length > 10) { // Only include meaningful content\n extractedContent += text + \"\\n\";\n }\n });\n }\n }\n\n console.log(\"📊 Content selector statistics:\", selectorStats);\n console.log(`📄 Total extracted content length: ${extractedContent.length} characters`);\n\n // Clean and normalize the text content\n console.log(\"🧹 Cleaning and normalizing text content...\");\n let textContent = extractedContent\n // Decode HTML entities properly\n .replace(/ /g, \" \")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\")\n .replace(/'/g, \"'\")\n .replace(/…/g, \"...\")\n .replace(/—/g, \"—\")\n .replace(/–/g, \"–\")\n .replace(/’/g, \"'\")\n .replace(/‘/g, \"'\")\n .replace(/”/g, \"\\\"\")\n .replace(/“/g, \"\\\"\")\n // Normalize whitespace\n .replace(/\\s+/g, \" \")\n .replace(/\\n\\s*\\n/g, \"\\n\")\n .trim();\n\n console.log(`📄 After text cleanup: ${textContent.length} characters`);\n\n // // Filter out common non-recipe content patterns\n // console.log(\"🔍 Filtering out non-recipe content patterns...\");\n // const lines = textContent.split(\"\\n\").filter(line => {\n // const trimmedLine = line.trim().toLowerCase();\n\n // // Skip empty lines or very short lines\n // if (!trimmedLine || trimmedLine.length < 3) return false;\n\n // // Skip common non-recipe patterns\n // const skipPatterns = [\n // /^(advertisement|sponsored|related|more recipes|subscribe|newsletter)/,\n // /^(copyright|all rights reserved|privacy policy|terms of service)/,\n // /^(share|print|save|pin|tweet|facebook|instagram|pinterest)/,\n // /^(comments|reviews|rating|stars|rate this)/,\n // /^(navigation|menu|search|login|sign up|register)/,\n // /^(home|about|contact|blog|categories|tags)/,\n // /^\\d+\\s*(comments?|reviews?|ratings?|stars?)$/,\n // /^(jump to recipe|print recipe|rate recipe|save recipe)$/,\n // /^(click here|read more|view all|see all)/,\n // /^(email|phone|address|follow us)/,\n // /^(loading|please wait|error|404)/\n // ];\n\n // return !skipPatterns.some(pattern => pattern.test(trimmedLine));\n // });\n\n // const filteredContent = lines.join(\"\\n\").trim();\n // const filteredLines = lines.length;\n // const originalLines = textContent.split(\"\\n\").length;\n // console.log(\n // `🔍 Filtered content: kept ${filteredLines}/${originalLines} lines, ${filteredContent.length} characters`,\n // );\n\n let finalContent = textContent;\n\n console.log(\"✅ Content extraction complete!\");\n console.log(`📊 Final content stats: ${finalContent.length} characters`);\n console.log(\"📄 Final content preview (first 300 chars):\");\n console.log(finalContent.substring(0, 300) + \"...\");\n\n return finalContent;\n } catch (error) {\n console.error(\"❌ Error in HTML parsing:\", error);\n console.log(\"🔄 Falling back to regex-based extraction...\");\n\n // Fallback to regex-based approach if HTML parser fails\n try {\n let cleanedHtml = html\n .replace(/)[\\s\\S])*?<\\/script>/gi, \"\")\n .replace(/)[\\s\\S])*?<\\/style>/gi, \"\");\n\n const textContent = cleanedHtml\n .replace(/<[^>]+>/g, \" \")\n .replace(/ /g, \" \")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\")\n .replace(/\\s+/g, \" \")\n .trim()\n .substring(0, 8000);\n\n console.log(`📄 Fallback content length: ${textContent.length} characters`);\n return textContent;\n } catch (fallbackError) {\n console.error(\"❌ Fallback extraction also failed:\", fallbackError);\n return html;\n }\n }\n}\n\n// System prompt for recipe parsing\nconst RECIPE_PARSING_PROMPT =\n `You are a recipe parsing expert. Your task is to extract structured recipe information from various sources (text, images, PDFs, or web content).\n\nIMPORTANT: You must return ONLY a valid JSON object with no additional text, markdown formatting, or explanations.\n\nExtract the following information and return it as a JSON object:\n{\n \"title\": \"Recipe name\",\n \"description\": \"Brief description (optional)\",\n \"ingredients\": [\n {\n \"name\": \"ingredient name\",\n \"amount\": \"quantity as string (e.g., '1.25', '0.5')\",\n \"unit\": \"measurement unit (e.g., 'cups', 'teaspoons')\",\n \"notes\": \"any additional notes (optional)\"\n }\n ],\n \"steps\": [\"step 1\", \"step 2\", ...],\n \"servings\": number (optional),\n \"prepTime\": minutes as number (optional),\n \"cookTime\": minutes as number (optional),\n \"difficulty\": \"easy\" | \"medium\" | \"hard\" (optional),\n \"tags\": [\"tag1\", \"tag2\"] (optional)\n}\n\nGuidelines:\n- Return ONLY the JSON object, no markdown code blocks or additional text\n- Extract ingredients with precise amounts and units\n- Amount should be a string representation of the number (e.g., \"1.25\", \"0.5\", \"2\")\n- Break down cooking steps into clear, sequential instructions\n- Normalize units (e.g., \"cups\" not \"c.\", \"teaspoons\" not \"tsp\")\n- If amounts are ranges (e.g., \"2-3 cups\"), use the middle value\n- For missing information, omit the field rather than guessing\n- Be precise and accurate\n- CRITICAL: Use decimal numbers for fractional amounts (e.g., \"0.25\" instead of \"¼\", \"0.5\" instead of \"½\")\n- Never use Unicode fraction characters (¼, ½, ¾, etc.) in the JSON output\n- Ensure all ingredient objects have name, amount, and unit fields\n- For structured data: convert ISO 8601 durations (PT15M) to minutes (15)`;\n\napp.post(\"/url\", async (c) => {\n try {\n const { content: url } = await c.req.json() as ParseRequest;\n\n console.log(\"🚀 ===== URL PARSING REQUEST STARTED =====\");\n console.log(`🔗 Target URL: ${url}`);\n console.log(`⏰ Timestamp: ${new Date().toISOString()}`);\n\n // Fetch the webpage content with better headers\n console.log(\"📡 Fetching webpage content...\");\n const response = await fetch(url, {\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36\",\n \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8\",\n \"Accept-Language\": \"en-US,en;q=0.5\",\n \"Accept-Encoding\": \"gzip, deflate\",\n \"Connection\": \"keep-alive\",\n },\n });\n\n if (!response.ok) {\n console.error(`❌ HTTP Error: ${response.status} ${response.statusText}`);\n return c.json({\n success: false,\n error: `Failed to fetch URL: ${response.status} ${response.statusText}`,\n } as ParseResponse);\n }\n\n const html = await response.text();\n console.log(`✅ Successfully fetched HTML content`);\n console.log(`📄 Raw HTML length: ${html.length} characters`);\n console.log(`📄 Content-Type: ${response.headers.get(\"content-type\")}`);\n\n // Extract and clean recipe content\n console.log(\"🔄 Starting content extraction process...\");\n const extractedContent = extractRecipeContent(html);\n console.log(\"✅ Content extraction completed\");\n\n // Use text content parsing approach\n console.log(\"📝 Using text content parsing approach\");\n const userMessage =\n `This content was extracted from a recipe webpage. Parse the recipe - all ingredients with quantities, cooking steps, and metadata. The content has been pre-processed to focus on recipe-relevant information:\\n\\n${extractedContent}`;\n\n console.log(\"🤖 ===== SENDING TO OPENAI =====\");\n console.log(`📤 Message length: ${userMessage.length} characters`);\n console.log(\"📤 Message preview (first 500 chars):\");\n console.log(userMessage.substring(0, 500) + \"...\");\n\n // Use OpenAI to parse the recipe from extracted content\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n { role: \"system\", content: RECIPE_PARSING_PROMPT },\n { role: \"user\", content: userMessage },\n ],\n temperature: 0.1,\n max_tokens: 2000,\n });\n\n console.log(\"🤖 ===== OPENAI RESPONSE RECEIVED =====\");\n const recipeText = completion.choices[0]?.message?.content;\n\n if (!recipeText) {\n console.error(\"❌ OpenAI returned empty response\");\n return c.json({ success: false, error: \"OpenAI returned empty response\" } as ParseResponse);\n }\n\n console.log(`📥 Response length: ${recipeText.length} characters`);\n console.log(\"📥 Raw OpenAI response:\");\n console.log(\"--- START OPENAI RESPONSE ---\");\n console.log(recipeText);\n console.log(\"--- END OPENAI RESPONSE ---\");\n\n try {\n console.log(\"🔄 Processing OpenAI response...\");\n\n // Try to extract JSON from the response (sometimes OpenAI adds extra text)\n let jsonText = recipeText.trim();\n console.log(`📝 Initial JSON text length: ${jsonText.length}`);\n\n // Look for JSON block if wrapped in markdown\n const jsonMatch = jsonText.match(/```(?:json)?\\s*(\\{[\\s\\S]*\\})\\s*```/);\n if (jsonMatch) {\n jsonText = jsonMatch[1];\n console.log(\"✅ Extracted JSON from markdown code block\");\n console.log(`📝 Extracted JSON length: ${jsonText.length}`);\n }\n\n // If it doesn't start with {, try to find the JSON part\n if (!jsonText.startsWith(\"{\")) {\n console.log(\"🔍 JSON doesn't start with {, searching for JSON boundaries...\");\n const startIndex = jsonText.indexOf(\"{\");\n const endIndex = jsonText.lastIndexOf(\"}\");\n if (startIndex !== -1 && endIndex !== -1 && endIndex > startIndex) {\n jsonText = jsonText.substring(startIndex, endIndex + 1);\n console.log(`✅ Found JSON boundaries: start=${startIndex}, end=${endIndex}`);\n console.log(`📝 Extracted JSON length: ${jsonText.length}`);\n } else {\n console.error(\"❌ Could not find valid JSON boundaries\");\n }\n }\n\n console.log(\"📝 Final JSON text to parse:\");\n console.log(\"--- START JSON ---\");\n console.log(jsonText);\n console.log(\"--- END JSON ---\");\n\n // Convert fractional characters to decimal values before parsing\n console.log(\"🔄 Converting fractions to decimals...\");\n const originalJsonText = jsonText;\n jsonText = convertFractionsToDecimals(jsonText);\n if (jsonText !== originalJsonText) {\n console.log(\"✅ Fraction conversion applied\");\n } else {\n console.log(\"ℹ️ No fractions found to convert\");\n }\n\n console.log(\"🔄 Parsing JSON...\");\n const rawRecipe = JSON.parse(jsonText);\n console.log(\"✅ JSON parsed successfully\");\n console.log(\"📊 Parsed recipe object:\");\n console.log(JSON.stringify(rawRecipe, null, 2));\n\n console.log(\"🔄 Validating and cleaning recipe...\");\n const recipe = validateAndCleanRecipe(rawRecipe);\n recipe.source = url;\n console.log(\"✅ Recipe validation completed\");\n console.log(\"📊 Final cleaned recipe:\");\n console.log(JSON.stringify(recipe, null, 2));\n\n console.log(\"🎉 ===== URL PARSING COMPLETED SUCCESSFULLY =====\");\n return c.json({ success: true, recipe } as ParseResponse);\n } catch (parseError) {\n console.error(\"❌ ===== JSON PARSING ERROR =====\");\n console.error(\"Error details:\", parseError);\n console.error(\"Error message:\", parseError.message);\n console.error(\"Error stack:\", parseError.stack);\n console.log(\"📥 Raw OpenAI response that failed to parse:\");\n console.log(\"--- START FAILED RESPONSE ---\");\n console.log(recipeText);\n console.log(\"--- END FAILED RESPONSE ---\");\n\n return c.json({\n success: false,\n error: `Invalid recipe format returned. Parse error: ${parseError.message}. OpenAI response: ${\n recipeText.substring(0, 200)\n }...`,\n } as ParseResponse);\n }\n } catch (error) {\n console.error(\"❌ ===== URL PARSING FAILED =====\");\n console.error(\"Error details:\", error);\n console.error(\"Error message:\", error.message);\n console.error(\"Error stack:\", error.stack);\n\n return c.json({\n success: false,\n error: `Failed to parse recipe from URL: ${error.message}`,\n } as ParseResponse);\n }\n});\n\napp.post(\"/image\", async (c) => {\n try {\n const { content: base64Image } = await c.req.json() as ParseRequest;\n\n console.log(\"Processing image upload, base64 length:\", base64Image?.length);\n\n // Validate base64 image\n if (!base64Image || base64Image.length < 100) {\n return c.json({ success: false, error: \"Invalid or empty image data\" } as ParseResponse);\n }\n\n // Use OpenAI Vision to parse recipe from image\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n { role: \"system\", content: RECIPE_PARSING_PROMPT },\n {\n role: \"user\",\n content: [\n {\n type: \"text\",\n text:\n \"Parse the recipe from this image. Extract all visible recipe information including title, ingredients with amounts, and cooking steps.\",\n },\n {\n type: \"image_url\",\n image_url: {\n url: base64Image.startsWith(\"data:\") ? base64Image : `data:image/jpeg;base64,${base64Image}`,\n },\n },\n ],\n },\n ],\n temperature: 0.1,\n max_tokens: 2000,\n });\n\n const recipeText = completion.choices[0]?.message?.content;\n console.log(\"OpenAI response:\", recipeText);\n\n if (!recipeText) {\n return c.json({ success: false, error: \"OpenAI returned empty response\" } as ParseResponse);\n }\n\n try {\n // Try to extract JSON from the response (sometimes OpenAI adds extra text)\n let jsonText = recipeText.trim();\n\n // Look for JSON block if wrapped in markdown\n const jsonMatch = jsonText.match(/```(?:json)?\\s*(\\{[\\s\\S]*\\})\\s*```/);\n if (jsonMatch) {\n jsonText = jsonMatch[1];\n }\n\n // If it doesn't start with {, try to find the JSON part\n if (!jsonText.startsWith(\"{\")) {\n const startIndex = jsonText.indexOf(\"{\");\n const endIndex = jsonText.lastIndexOf(\"}\");\n if (startIndex !== -1 && endIndex !== -1 && endIndex > startIndex) {\n jsonText = jsonText.substring(startIndex, endIndex + 1);\n }\n }\n\n // Convert fractional characters to decimal values before parsing\n jsonText = convertFractionsToDecimals(jsonText);\n\n console.log(\"Attempting to parse JSON:\", jsonText);\n const rawRecipe = JSON.parse(jsonText);\n const recipe = validateAndCleanRecipe(rawRecipe);\n recipe.source = \"Image upload\";\n\n return c.json({ success: true, recipe } as ParseResponse);\n } catch (parseError) {\n console.error(\"JSON parsing error:\", parseError);\n console.error(\"Raw response from OpenAI:\", recipeText);\n return c.json({\n success: false,\n error: `Invalid recipe format returned. OpenAI response: ${recipeText.substring(0, 200)}...`,\n } as ParseResponse);\n }\n } catch (error) {\n console.error(\"Image parsing error:\", error);\n return c.json({\n success: false,\n error: `Failed to parse recipe from image: ${error.message}`,\n } as ParseResponse);\n }\n});\n\napp.post(\"/pdf\", async (c) => {\n try {\n const { content: base64Pdf } = await c.req.json() as ParseRequest;\n\n // Validate base64 PDF\n if (!base64Pdf || base64Pdf.length < 100) {\n return c.json({ success: false, error: \"Invalid or empty PDF data\" } as ParseResponse);\n }\n\n // Convert base64 to buffer\n const base64Data = base64Pdf.replace(/^data:application\\/pdf;base64,/, \"\");\n const pdfBuffer = Uint8Array.from(atob(base64Data), c => c.charCodeAt(0));\n\n // Use unpdf to extract text from PDF\n const pdf = await getDocumentProxy(pdfBuffer);\n const { totalPages, text } = await extractText(pdf, { mergePages: true });\n const fullText = text as string;\n\n if (!fullText || fullText.trim().length < 10) {\n return c.json({ success: false, error: \"No readable text found in PDF\" } as ParseResponse);\n }\n\n // Log the number of pages processed\n console.log(`Processed PDF with ${totalPages} pages`);\n\n // Use OpenAI to parse the recipe\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n { role: \"system\", content: RECIPE_PARSING_PROMPT },\n {\n role: \"user\",\n content: `Parse this recipe text extracted from a PDF and extract the structured information:\\n\\n${fullText}`,\n },\n ],\n temperature: 0.1,\n max_tokens: 2000,\n });\n\n const recipeText = completion.choices[0]?.message?.content;\n console.log(\"OpenAI response for PDF:\", recipeText);\n\n if (!recipeText) {\n return c.json({ success: false, error: \"OpenAI returned empty response\" } as ParseResponse);\n }\n\n try {\n // Try to extract JSON from the response (sometimes OpenAI adds extra text)\n let jsonText = recipeText.trim();\n\n // Look for JSON block if wrapped in markdown\n const jsonMatch = jsonText.match(/```(?:json)?\\s*(\\{[\\s\\S]*\\})\\s*```/);\n if (jsonMatch) {\n jsonText = jsonMatch[1];\n }\n\n // If it doesn't start with {, try to find the JSON part\n if (!jsonText.startsWith(\"{\")) {\n const startIndex = jsonText.indexOf(\"{\");\n const endIndex = jsonText.lastIndexOf(\"}\");\n if (startIndex !== -1 && endIndex !== -1 && endIndex > startIndex) {\n jsonText = jsonText.substring(startIndex, endIndex + 1);\n }\n }\n\n // Convert fractional characters to decimal values before parsing\n jsonText = convertFractionsToDecimals(jsonText);\n\n console.log(\"Attempting to parse JSON for PDF:\", jsonText);\n const rawRecipe = JSON.parse(jsonText);\n const recipe = validateAndCleanRecipe(rawRecipe);\n recipe.source = \"PDF upload\";\n\n return c.json({ success: true, recipe } as ParseResponse);\n } catch (parseError) {\n console.error(\"JSON parsing error for PDF:\", parseError);\n console.error(\"Raw response from OpenAI:\", recipeText);\n return c.json({\n success: false,\n error: `Invalid recipe format returned. OpenAI response: ${recipeText.substring(0, 200)}...`,\n } as ParseResponse);\n }\n } catch (error) {\n console.error(\"PDF parsing error:\", error);\n return c.json({\n success: false,\n error: `Failed to parse recipe from PDF: ${error.message}`,\n } as ParseResponse);\n }\n});\n\napp.post(\"/text\", async (c) => {\n try {\n const { content: text } = await c.req.json() as ParseRequest;\n\n console.log(\"Processing text input, length:\", text?.length);\n\n if (!text || text.trim().length < 10) {\n return c.json({ success: false, error: \"Text input is too short or empty\" } as ParseResponse);\n }\n\n // Parse recipe from plain text\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n { role: \"system\", content: RECIPE_PARSING_PROMPT },\n {\n role: \"user\",\n content: `Parse this recipe text and extract the structured information:\\n\\n${text}`,\n },\n ],\n temperature: 0.1,\n max_tokens: 2000,\n });\n\n const recipeText = completion.choices[0]?.message?.content;\n console.log(\"OpenAI response for text:\", recipeText);\n\n if (!recipeText) {\n return c.json({ success: false, error: \"OpenAI returned empty response\" } as ParseResponse);\n }\n\n try {\n // Try to extract JSON from the response (sometimes OpenAI adds extra text)\n let jsonText = recipeText.trim();\n\n // Look for JSON block if wrapped in markdown\n const jsonMatch = jsonText.match(/```(?:json)?\\s*(\\{[\\s\\S]*\\})\\s*```/);\n if (jsonMatch) {\n jsonText = jsonMatch[1];\n }\n\n // If it doesn't start with {, try to find the JSON part\n if (!jsonText.startsWith(\"{\")) {\n const startIndex = jsonText.indexOf(\"{\");\n const endIndex = jsonText.lastIndexOf(\"}\");\n if (startIndex !== -1 && endIndex !== -1 && endIndex > startIndex) {\n jsonText = jsonText.substring(startIndex, endIndex + 1);\n }\n }\n\n // Convert fractional characters to decimal values before parsing\n jsonText = convertFractionsToDecimals(jsonText);\n\n console.log(\"Attempting to parse JSON for text:\", jsonText);\n const rawRecipe = JSON.parse(jsonText);\n const recipe = validateAndCleanRecipe(rawRecipe);\n recipe.source = \"Text input\";\n\n return c.json({ success: true, recipe } as ParseResponse);\n } catch (parseError) {\n console.error(\"JSON parsing error for text:\", parseError);\n console.error(\"Raw response from OpenAI:\", recipeText);\n return c.json({\n success: false,\n error: `Invalid recipe format returned. OpenAI response: ${recipeText.substring(0, 200)}...`,\n } as ParseResponse);\n }\n } catch (error) {\n console.error(\"Text parsing error:\", error);\n return c.json({\n success: false,\n error: `Failed to parse recipe from text: ${error.message}`,\n } as ParseResponse);\n }\n});\n\nexport default app;",[],[99,243,266],{"_104":275,"_95":276,"_154":277,"_156":244,"_157":139,"_158":278,"_160":161,"_106":279,"_100":119,"_163":226,"_165":280,"_166":22,"_167":-5,"_168":281,"_98":282},"1af36388-8eb7-11f0-b5d2-0224a6c84d84","recipes.ts","ad0aa7f4-494d-11f0-bd19-76b3cceeab13",295,["D",1757557753066],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { Recipe, RecipeFilters, ApiResponse, PaginatedResponse, PaginationParams } from \"../../shared/types.ts\";\nimport { \n createRecipe, \n getRecipeById, \n getAllRecipes,\n getAllRecipesPaginated, \n updateRecipe, \n deleteRecipe \n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all recipes with optional filters and pagination\napp.get('/', async (c) => {\n try {\n // Parse filter parameters\n const search = c.req.query('search');\n const difficulty = c.req.query('difficulty');\n const maxPrepTime = c.req.query('maxPrepTime');\n const maxCookTime = c.req.query('maxCookTime');\n const tags = c.req.query('tags');\n\n const filters: RecipeFilters = {};\n if (search) filters.search = search;\n if (difficulty) filters.difficulty = difficulty;\n if (maxPrepTime) filters.maxPrepTime = parseInt(maxPrepTime);\n if (maxCookTime) filters.maxCookTime = parseInt(maxCookTime);\n if (tags) filters.tags = tags.split(',');\n\n // Parse pagination parameters\n const pageParam = c.req.query('page');\n const limitParam = c.req.query('limit');\n const paginated = c.req.query('paginated'); // Flag to enable pagination\n\n // If pagination is requested, use paginated function\n if (paginated === 'true' || pageParam || limitParam) {\n const pagination: PaginationParams = {};\n if (pageParam) pagination.page = parseInt(pageParam);\n if (limitParam) pagination.limit = parseInt(limitParam);\n\n const result = await getAllRecipesPaginated(filters, pagination);\n return c.json({ \n success: true, \n data: result.recipes, \n pagination: result.paginationInfo \n } as PaginatedResponse);\n } else {\n // Use legacy non-paginated function for backward compatibility\n const recipes = await getAllRecipes(filters);\n return c.json({ success: true, data: recipes } as ApiResponse);\n }\n } catch (error) {\n console.error('Error fetching recipes:', error);\n return c.json({ success: false, error: 'Failed to fetch recipes' } as ApiResponse, 500);\n }\n});\n\n// Get a specific recipe by ID\napp.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid recipe ID' } as ApiResponse, 400);\n }\n\n const recipe = await getRecipeById(id);\n if (!recipe) {\n return c.json({ success: false, error: 'Recipe not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: recipe } as ApiResponse);\n } catch (error) {\n console.error('Error fetching recipe:', error);\n return c.json({ success: false, error: 'Failed to fetch recipe' } as ApiResponse, 500);\n }\n});\n\n// Create a new recipe\napp.post('/', async (c) => {\n try {\n const recipeData = await c.req.json() as Omit;\n \n // Validate required fields\n if (!recipeData.title || !recipeData.ingredients || !recipeData.steps) {\n return c.json({ \n success: false, \n error: 'Missing required fields: title, ingredients, and steps are required' \n } as ApiResponse, 400);\n }\n\n if (recipeData.ingredients.length === 0) {\n return c.json({ \n success: false, \n error: 'At least one ingredient is required' \n } as ApiResponse, 400);\n }\n\n if (recipeData.steps.length === 0) {\n return c.json({ \n success: false, \n error: 'At least one cooking step is required' \n } as ApiResponse, 400);\n }\n\n const recipe = await createRecipe(recipeData);\n return c.json({ success: true, data: recipe } as ApiResponse, 201);\n } catch (error) {\n console.error('Error creating recipe:', error);\n return c.json({ success: false, error: 'Failed to create recipe' } as ApiResponse, 500);\n }\n});\n\n// Update an existing recipe\napp.put('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid recipe ID' } as ApiResponse, 400);\n }\n\n const updates = await c.req.json() as Partial;\n \n const recipe = await updateRecipe(id, updates);\n if (!recipe) {\n return c.json({ success: false, error: 'Recipe not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: recipe } as ApiResponse);\n } catch (error) {\n console.error('Error updating recipe:', error);\n return c.json({ success: false, error: 'Failed to update recipe' } as ApiResponse, 500);\n }\n});\n\n// Delete a recipe\napp.delete('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid recipe ID' } as ApiResponse, 400);\n }\n\n const deleted = await deleteRecipe(id);\n if (!deleted) {\n return c.json({ success: false, error: 'Recipe not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: { deleted: true } } as ApiResponse);\n } catch (error) {\n console.error('Error deleting recipe:', error);\n return c.json({ success: false, error: 'Failed to delete recipe' } as ApiResponse, 500);\n }\n});\n\nexport default app;",[],[99,243,276],{"_104":284,"_95":285,"_154":286,"_156":244,"_157":139,"_158":287,"_160":161,"_106":288,"_100":289,"_163":226,"_165":290,"_166":22,"_167":-5,"_168":291,"_98":292},"f8557cde-94c0-11f0-bbca-0224a6c84d84","shopping-lists.ts","b3fbf32e-4fa1-11f0-803d-f69ea79377d9",378,["D",1758221696936],20,"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { ShoppingList, ShoppingListItem, CreateShoppingListRequest, ApiResponse, PaginatedResponse, PaginationParams } from \"../../shared/types.ts\";\nimport {\n createShoppingList as dbCreateShoppingList,\n getAllShoppingLists,\n getAllShoppingListsPaginated,\n getShoppingListById,\n updateShoppingListItem,\n updateShoppingListName,\n deleteShoppingList,\n deleteShoppingListItem,\n addShoppingListItem\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n\n\n// Get all shopping lists with optional pagination\napp.get('/', async (c) => {\n try {\n // Parse pagination parameters\n const pageParam = c.req.query('page');\n const limitParam = c.req.query('limit');\n const paginated = c.req.query('paginated'); // Flag to enable pagination\n\n // If pagination is requested, use paginated function\n if (paginated === 'true' || pageParam || limitParam) {\n const pagination: PaginationParams = {};\n if (pageParam) pagination.page = parseInt(pageParam);\n if (limitParam) pagination.limit = parseInt(limitParam);\n\n const result = await getAllShoppingListsPaginated(pagination);\n return c.json({ \n success: true, \n data: result.shoppingLists, \n pagination: result.paginationInfo \n } as PaginatedResponse);\n } else {\n // Use legacy non-paginated function for backward compatibility\n const lists = await getAllShoppingLists();\n return c.json({ success: true, data: lists } as ApiResponse);\n }\n } catch (error) {\n console.error('Error fetching shopping lists:', error);\n return c.json({ success: false, error: 'Failed to fetch shopping lists' } as ApiResponse, 500);\n }\n});\n\n// Get a specific shopping list by ID\napp.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid shopping list ID' } as ApiResponse, 400);\n }\n\n const list = await getShoppingListById(id);\n if (!list) {\n return c.json({ success: false, error: 'Shopping list not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: list } as ApiResponse);\n } catch (error) {\n console.error('Error fetching shopping list:', error);\n return c.json({ success: false, error: 'Failed to fetch shopping list' } as ApiResponse, 500);\n }\n});\n\n// Create a new shopping list from selected recipes\napp.post('/', async (c) => {\n try {\n const { recipeIds } = await c.req.json() as CreateShoppingListRequest;\n \n if (!recipeIds || !Array.isArray(recipeIds) || recipeIds.length === 0) {\n return c.json({ \n success: false, \n error: 'At least one recipe ID is required' \n } as ApiResponse, 400);\n }\n\n // Validate that all recipe IDs are numbers\n const validRecipeIds = recipeIds.filter(id => typeof id === 'number' && !isNaN(id));\n if (validRecipeIds.length !== recipeIds.length) {\n return c.json({ \n success: false, \n error: 'All recipe IDs must be valid numbers' \n } as ApiResponse, 400);\n }\n\n // Generate list name with current date in EST\n const now = new Date();\n const listName = `Shopping List - ${now.toLocaleDateString('en-US', { \n year: 'numeric', \n month: 'short', \n day: 'numeric',\n timeZone: 'America/New_York'\n })}`;\n\n const list = await dbCreateShoppingList(listName, validRecipeIds);\n return c.json({ success: true, data: list } as ApiResponse, 201);\n } catch (error) {\n console.error('Error creating shopping list:', error);\n return c.json({ success: false, error: 'Failed to create shopping list' } as ApiResponse, 500);\n }\n});\n\n// Update a shopping list name\napp.put('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid shopping list ID' } as ApiResponse, 400);\n }\n\n const { name } = await c.req.json();\n \n if (!name || typeof name !== 'string' || name.trim().length === 0) {\n return c.json({ \n success: false, \n error: 'Shopping list name is required' \n } as ApiResponse, 400);\n }\n\n const success = await updateShoppingListName(id, name.trim());\n if (!success) {\n return c.json({ success: false, error: 'Shopping list not found' } as ApiResponse, 404);\n }\n\n // Return the updated shopping list\n const updatedList = await getShoppingListById(id);\n return c.json({ success: true, data: updatedList } as ApiResponse);\n } catch (error) {\n console.error('Error updating shopping list name:', error);\n return c.json({ success: false, error: 'Failed to update shopping list name' } as ApiResponse, 500);\n }\n});\n\n// Update a shopping list item (mainly for checking/unchecking items)\napp.put('/items/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid item ID' } as ApiResponse, 400);\n }\n\n const updates = await c.req.json() as Partial;\n\n const success = await updateShoppingListItem(id, updates);\n if (!success) {\n return c.json({ success: false, error: 'Item not found or no changes made' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: { updated: true } } as ApiResponse);\n } catch (error) {\n console.error('Error updating shopping list item:', error);\n return c.json({ success: false, error: 'Failed to update item' } as ApiResponse, 500);\n }\n});\n\n// Add a new item to a shopping list\napp.post('/:id/items', async (c) => {\n try {\n const shoppingListId = parseInt(c.req.param('id'));\n if (isNaN(shoppingListId)) {\n return c.json({ success: false, error: 'Invalid shopping list ID' } as ApiResponse, 400);\n }\n\n const { name, amount, unit, notes, category } = await c.req.json();\n\n // Validate required fields\n if (!name || typeof name !== 'string' || name.trim().length === 0) {\n return c.json({\n success: false,\n error: 'Item name is required'\n } as ApiResponse, 400);\n }\n\n // Check if shopping list exists\n const existingList = await getShoppingListById(shoppingListId);\n if (!existingList) {\n return c.json({ success: false, error: 'Shopping list not found' } as ApiResponse, 404);\n }\n\n // Add the item\n const newItem = await addShoppingListItem(\n shoppingListId,\n name,\n amount,\n unit,\n notes,\n category\n );\n\n if (!newItem) {\n return c.json({ success: false, error: 'Failed to add item to shopping list' } as ApiResponse, 500);\n }\n\n return c.json({ success: true, data: newItem } as ApiResponse, 201);\n } catch (error) {\n console.error('Error adding item to shopping list:', error);\n return c.json({ success: false, error: 'Failed to add item' } as ApiResponse, 500);\n }\n});\n\n// Delete a shopping list item\napp.delete('/items/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid item ID' } as ApiResponse, 400);\n }\n\n const deleted = await deleteShoppingListItem(id);\n if (!deleted) {\n return c.json({ success: false, error: 'Item not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: { deleted: true } } as ApiResponse);\n } catch (error) {\n console.error('Error deleting shopping list item:', error);\n return c.json({ success: false, error: 'Failed to delete item' } as ApiResponse, 500);\n }\n});\n\n// Delete a shopping list\napp.delete('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({ success: false, error: 'Invalid shopping list ID' } as ApiResponse, 400);\n }\n\n const deleted = await deleteShoppingList(id);\n if (!deleted) {\n return c.json({ success: false, error: 'Shopping list not found' } as ApiResponse, 404);\n }\n\n return c.json({ success: true, data: { deleted: true } } as ApiResponse);\n } catch (error) {\n console.error('Error deleting shopping list:', error);\n return c.json({ success: false, error: 'Failed to delete shopping list' } as ApiResponse, 500);\n }\n});\n\nexport default app;",[],[99,243,285],[99,243],{"_104":295,"_95":296,"_154":297,"_156":209,"_157":139,"_158":298,"_160":161,"_106":299,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":300,"_98":310},"d847d926-9012-11f0-8497-0224a6c84d84","utils","d847da2a-9012-11f0-8497-0224a6c84d84",349,["D",1757707106077],[301],{"_104":302,"_95":303,"_154":304,"_156":297,"_157":139,"_158":305,"_160":161,"_106":306,"_100":32,"_163":226,"_165":307,"_166":22,"_167":-5,"_168":308,"_98":309},"d854b934-9012-11f0-8497-0224a6c84d84","ingredientCategorizer.ts","d854ba24-9012-11f0-8497-0224a6c84d84",350,["D",1757707106164],"export type IngredientCategory = \n | 'produce'\n | 'cheeses'\n | 'meats/proteins'\n | 'freezer'\n | 'breads'\n | 'dry goods'\n | 'dairy'\n | 'other';\n\n// Category display order (for sorting)\nexport const CATEGORY_ORDER: IngredientCategory[] = [\n 'produce',\n 'cheeses',\n 'meats/proteins',\n 'freezer',\n 'breads',\n 'dry goods',\n 'dairy',\n 'other'\n];\n\n// Keywords and patterns for categorizing ingredients\nconst CATEGORY_PATTERNS: Record = {\n 'produce': [\n /\\b(apple|banana|orange|lemon|lime|grape|berry|berries|strawberry|blueberry|raspberry|blackberry|cranberry)\\b/i,\n /\\b(peach|pear|plum|apricot|cherry|mango|pineapple|papaya|kiwi|melon|watermelon|cantaloupe|honeydew)\\b/i,\n /\\b(tomato|lettuce|spinach|kale|arugula|cabbage|brussels sprout|broccoli|cauliflower|asparagus)\\b/i,\n /\\b(carrot|celery|cucumber|pepper|bell pepper|jalapeño|chili|chile|poblano|serrano|habanero)\\b/i,\n /\\b(onion|garlic|shallot|scallion|leek|green onion|spring onion|chive)\\b/i,\n /\\b(potato|sweet potato|yam|turnip|radish|beet|parsnip|rutabaga)\\b/i,\n /\\b(corn|zucchini|squash|pumpkin|eggplant|okra|artichoke)\\b/i,\n /\\b(mushroom|portobello|shiitake|oyster mushroom|chanterelle)\\b/i,\n /\\b(herb|basil|cilantro|parsley|dill|mint|oregano|rosemary|sage|thyme|tarragon)\\b/i,\n /\\b(ginger|turmeric|lemongrass|galangal)\\b/i,\n /\\b(avocado|coconut|fresh|vegetable|veggie|greens|salad)\\b/i\n ],\n \n 'cheeses': [\n /\\b(cheese|cheddar|mozzarella|parmesan|parmigiano|pecorino|romano|asiago)\\b/i,\n /\\b(swiss|gruyere|gouda|edam|havarti|muenster|provolone)\\b/i,\n /\\b(feta|goat cheese|chevre|ricotta|mascarpone|cream cheese|cottage cheese)\\b/i,\n /\\b(brie|camembert|blue cheese|gorgonzola|roquefort|stilton)\\b/i,\n /\\b(monterey jack|pepper jack|colby|american cheese|velveeta)\\b/i,\n /\\b(queso|paneer|halloumi|burrata)\\b/i\n ],\n \n 'meats/proteins': [\n /\\b(chicken|turkey|duck|goose|poultry|breast|thigh|wing|drumstick)\\b/i,\n /\\b(beef|steak|ground beef|hamburger|sirloin|ribeye|tenderloin|chuck|brisket|short rib)\\b/i,\n /\\b(pork|bacon|ham|sausage|chorizo|pepperoni|salami|prosciutto|pancetta)\\b/i,\n /\\b(lamb|mutton|veal|venison|bison|rabbit)\\b/i,\n /\\b(fish|salmon|tuna|cod|halibut|tilapia|trout|bass|catfish|mahi|snapper|grouper)\\b/i,\n /\\b(shrimp|prawn|crab|lobster|scallop|oyster|mussel|clam|calamari|squid|octopus)\\b/i,\n /\\b(egg|tofu|tempeh|seitan|protein|meat|seafood)\\b/i,\n /\\b(ground turkey|ground chicken|ground lamb|meatball|burger)\\b/i\n ],\n \n 'freezer': [\n /\\b(frozen|ice cream|gelato|sorbet|popsicle|ice|freeze|freezer)\\b/i,\n /\\b(frozen vegetable|frozen fruit|frozen pizza|frozen meal)\\b/i,\n /\\b(ice cube|frozen yogurt|sherbet)\\b/i\n ],\n \n 'breads': [\n /\\b(bread|baguette|sourdough|rye|wheat bread|white bread|whole wheat|multigrain)\\b/i,\n /\\b(roll|bun|hamburger bun|hot dog bun|dinner roll|kaiser roll|ciabatta)\\b/i,\n /\\b(bagel|english muffin|muffin|croissant|brioche|focaccia|naan|pita|flatbread)\\b/i,\n /\\b(tortilla|wrap|lavash|cracker|breadcrumb|panko|toast|biscuit)\\b/i,\n /\\b(pretzel|breadstick|crouton)\\b/i\n ],\n \n 'dry goods': [\n /\\b(flour|all-purpose flour|bread flour|cake flour|pastry flour|whole wheat flour|almond flour)\\b/i,\n /\\b(sugar|brown sugar|powdered sugar|confectioner|granulated|sweetener|honey|maple syrup|molasses)\\b/i,\n /\\b(rice|pasta|noodle|spaghetti|penne|rigatoni|macaroni|linguine|fettuccine|lasagna|orzo)\\b/i,\n /\\b(quinoa|couscous|bulgur|farro|barley|millet|buckwheat|amaranth)\\b/i,\n /\\b(bean|lentil|chickpea|black bean|kidney bean|pinto bean|navy bean|cannellini|lima bean)\\b/i,\n /\\b(oat|oatmeal|cereal|granola|muesli|corn flake|bran)\\b/i,\n /\\b(oil|olive oil|vegetable oil|canola oil|coconut oil|sesame oil|peanut oil)\\b/i,\n /\\b(vinegar|balsamic|wine vinegar|cider vinegar|rice vinegar)\\b/i,\n /\\b(salt|pepper|spice|seasoning|paprika|cumin|coriander|cinnamon|nutmeg|clove|cardamom)\\b/i,\n /\\b(baking powder|baking soda|yeast|vanilla|extract|cocoa|chocolate chip)\\b/i,\n /\\b(nut|almond|walnut|pecan|cashew|peanut|pistachio|hazelnut|macadamia)\\b/i,\n /\\b(seed|sunflower seed|pumpkin seed|sesame seed|poppy seed|chia seed|flax seed)\\b/i,\n /\\b(sauce|ketchup|mustard|mayonnaise|soy sauce|worcestershire|hot sauce|bbq sauce)\\b/i,\n /\\b(broth|stock|bouillon|soup|can|canned|jar|bottle|package|box)\\b/i,\n /\\b(chip|snack|popcorn|pretzel|cookie|candy)\\b/i\n ],\n \n 'dairy': [\n /\\b(milk|whole milk|skim milk|2% milk|1% milk|lactose-free|almond milk|soy milk|oat milk)\\b/i,\n /\\b(cream|heavy cream|whipping cream|half and half|sour cream|creme fraiche)\\b/i,\n /\\b(yogurt|greek yogurt|kefir|buttermilk)\\b/i,\n /\\b(butter|margarine|ghee|clarified butter)\\b/i,\n /\\b(dairy|creamer|condensed milk|evaporated milk)\\b/i\n ],\n \n 'other': [\n // This is the default category - no patterns needed\n ]\n};\n\n/**\n * Categorize an ingredient based on its name\n * @param ingredientName The name of the ingredient to categorize\n * @returns The category the ingredient belongs to\n */\nexport function categorizeIngredient(ingredientName: string): IngredientCategory {\n if (!ingredientName) {\n return 'other';\n }\n\n const normalizedName = ingredientName.toLowerCase();\n\n // Check each category's patterns\n for (const [category, patterns] of Object.entries(CATEGORY_PATTERNS)) {\n if (category === 'other') continue; // Skip 'other' as it's the default\n \n for (const pattern of patterns) {\n if (pattern.test(normalizedName)) {\n return category as IngredientCategory;\n }\n }\n }\n\n // Default category if no match found\n return 'other';\n}\n\n/**\n * Get the sort order for a category\n * @param category The category to get the sort order for\n * @returns The sort order index (lower = higher priority)\n */\nexport function getCategorySortOrder(category: IngredientCategory): number {\n const index = CATEGORY_ORDER.indexOf(category);\n return index === -1 ? CATEGORY_ORDER.length : index;\n}\n\n/**\n * Sort ingredients by category\n * @param ingredients Array of ingredients with categories\n * @returns Sorted array of ingredients\n */\nexport function sortIngredientsByCategory(\n ingredients: T[]\n): T[] {\n return [...ingredients].sort((a, b) => {\n const orderA = getCategorySortOrder(a.category);\n const orderB = getCategorySortOrder(b.category);\n return orderA - orderB;\n });\n}",[],[99,296,303],[99,296],{"_104":312,"_95":313,"_154":314,"_156":209,"_157":139,"_158":101,"_160":22,"_106":315,"_100":316,"_163":317,"_165":318,"_166":22,"_167":96,"_168":319,"_98":320},"49975842-94c1-11f0-8393-0224a6c84d84","index.ts","b5a28792-494d-11f0-a95b-76b3cceeab13",["D",1758221833259],74,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { testTransactionRollback, testIngredientUpdates, testPagination, testIngredientNormalizationCache } from \"./database/queries.ts\";\nimport recipesApp from \"./routes/recipes.ts\";\nimport parseApp from \"./routes/parse.ts\";\nimport shoppingListsApp from \"./routes/shopping-lists.ts\";\nimport excludedIngredientsApp from \"./routes/excluded-ingredients.ts\";\nimport mealPlansApp from \"./routes/meal-plans.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n try {\n await runMigrations();\n dbInitialized = true;\n console.log('Database initialized successfully');\n } catch (error) {\n console.error('Failed to initialize database:', error);\n throw error;\n }\n }\n}\n\n// Health check endpoint\napp.get('/api/health', async (c) => {\n try {\n await initializeDatabase();\n return c.json({ status: 'ok', timestamp: new Date().toISOString() });\n } catch (error) {\n return c.json({ status: 'error', error: error.message }, 500);\n }\n});\n\n// Test endpoint for debugging delete operations\napp.get('/api/test-delete', async (c) => {\n await initializeDatabase();\n return c.json({ message: 'Delete test endpoint - check logs for database operations' });\n});\n\n// Test endpoint for transaction rollback behavior\napp.get('/api/test-transaction', async (c) => {\n await initializeDatabase();\n const result = await testTransactionRollback();\n return c.json(result);\n});\n\n// Test endpoint for optimized ingredient updates\napp.get('/api/test-ingredients', async (c) => {\n await initializeDatabase();\n const result = await testIngredientUpdates();\n return c.json(result);\n});\n\n// Test endpoint for pagination functionality\napp.get('/api/test-pagination', async (c) => {\n await initializeDatabase();\n const result = await testPagination();\n return c.json(result);\n});\n\n// Test endpoint for ingredient normalization cache performance\napp.get('/api/test-normalization-cache', async (c) => {\n await initializeDatabase();\n const result = await testIngredientNormalizationCache();\n return c.json(result);\n});\n\n// Test endpoint for meal plan functionality\napp.get('/api/test-meal-plans', async (c) => {\n await initializeDatabase();\n\n try {\n // This endpoint will test basic meal plan CRUD operations\n // For now, it's just a placeholder - the actual testing will be done via API calls\n return c.json({\n success: true,\n message: 'Meal plan API is ready for testing',\n endpoints: {\n 'GET /api/meal-plans': 'Get meal plans for date range (?startDate=YYYY-MM-DD&endDate=YYYY-MM-DD)',\n 'POST /api/meal-plans': 'Create meal plan (body: {recipeId, date, mealType, notes?})',\n 'GET /api/meal-plans/:id': 'Get specific meal plan',\n 'PUT /api/meal-plans/:id': 'Update meal plan',\n 'DELETE /api/meal-plans/:id': 'Delete meal plan',\n 'POST /api/meal-plans/shopping-list': 'Create shopping list from calendar'\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Failed to test meal plans'\n }, 500);\n }\n});\n\n// Test endpoint for manual item addition\napp.get('/api/test-manual-item', async (c) => {\n await initializeDatabase();\n try {\n const { addShoppingListItem, createShoppingList, getAllShoppingLists } = await import('./database/queries.ts');\n\n // Get or create a test shopping list\n let testListId: number;\n const lists = await getAllShoppingLists();\n const testList = lists.find(l => l.name === 'Test Manual Items List');\n\n if (testList) {\n testListId = testList.id!;\n } else {\n // Create a test shopping list with no recipes\n const newList = await createShoppingList('Test Manual Items List', []);\n testListId = newList.id!;\n }\n\n // Add a manual item\n const testItem = await addShoppingListItem(\n testListId,\n 'Manually Added Test Item',\n '2',\n 'pounds',\n 'This is a test item added manually'\n );\n\n if (!testItem) {\n return c.json({\n success: false,\n message: 'Failed to add manual item'\n });\n }\n\n // Verify the item was added\n const { getShoppingListById } = await import('./database/queries.ts');\n const updatedList = await getShoppingListById(testListId);\n const manualItem = updatedList?.items.find(item => item.id === testItem.id);\n\n return c.json({\n success: true,\n message: 'Manual item addition working correctly',\n listId: testListId,\n addedItem: testItem,\n verified: !!manualItem,\n totalItems: updatedList?.items.length || 0\n });\n } catch (error) {\n console.error('Test manual item error:', error);\n return c.json({\n success: false,\n message: 'Error testing manual item addition',\n error: String(error)\n }, 500);\n }\n});\n\n// Mount API routes\napp.route('/api/recipes', recipesApp);\napp.route('/api/parse', parseApp);\napp.route('/api/shopping-lists', shoppingListsApp);\napp.route('/api/excluded-ingredients', excludedIngredientsApp);\napp.route('/api/meal-plans', mealPlansApp);\n\n// Serve static files\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 main HTML page with database initialization\napp.get(\"/\", async (c) => {\n try {\n await initializeDatabase();\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error('Error serving main page:', error);\n return c.html(`\n \n Error\n \n

Application Error

Failed to initialize the application: ${error.message}

\n \n \n `, 500);\n }\n});\n\nexport default app.fetch;",[],[99,313],[99],{"_104":323,"_95":324,"_154":325,"_156":-5,"_157":139,"_158":326,"_160":161,"_106":327,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":328,"_98":452},"c0a26dd8-494d-11f0-a1c9-76b3cceeab13","frontend","4dd70d89-3aed-476f-9356-7e26d18e7aa9",8,["D",1749925874156],[329,435,443],{"_104":330,"_95":331,"_154":332,"_156":325,"_157":139,"_158":333,"_160":161,"_106":334,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":335,"_98":434},"d71a6b92-494d-11f0-84aa-76b3cceeab13","components","5841737e-c0d7-4f36-bedd-f408bd6dc9f4",10,["D",1749925911851],[336,346,354,363,371,379,388,397,406,416,424],{"_104":337,"_95":338,"_154":339,"_156":332,"_157":139,"_158":340,"_160":22,"_106":341,"_100":342,"_163":226,"_165":343,"_166":22,"_167":-5,"_168":344,"_98":345},"b0091400-9127-11f0-a29e-0224a6c84d84","App.tsx","d71a530a-494d-11f0-84aa-76b3cceeab13",373,["D",1757826009148],17,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, ShoppingList } from \"../../shared/types.ts\";\nimport RecipeForm from \"./RecipeForm.tsx\";\nimport RecipeList from \"./RecipeList.tsx\";\nimport RecipeView from \"./RecipeView.tsx\";\nimport ShoppingListCreator from \"./ShoppingListCreator.tsx\";\nimport ShoppingListList from \"./ShoppingListList.tsx\";\nimport ShoppingListView from \"./ShoppingListView.tsx\";\nimport ExcludedIngredientsManager from \"./ExcludedIngredientsManager.tsx\";\nimport MealPlanCalendar from \"./MealPlanCalendar.tsx\";\n\ntype View = 'list' | 'add' | 'view' | 'edit' | 'shopping-lists' | 'shopping-list-create' | 'shopping-list-view' | 'excluded-ingredients' | 'meal-calendar';\n\ninterface AppState {\n view: View;\n recipes: Recipe[];\n selectedRecipe: Recipe | null;\n shoppingLists: ShoppingList[];\n selectedShoppingList: ShoppingList | null;\n loading: boolean;\n error: string | null;\n}\n\nexport default function App() {\n const [state, setState] = useState({\n view: 'list',\n recipes: [],\n selectedRecipe: null,\n shoppingLists: [],\n selectedShoppingList: null,\n loading: false,\n error: null\n });\n\n // Load recipes on app start\n useEffect(() => {\n loadRecipes();\n }, []);\n\n const loadRecipes = async () => {\n setState(prev => ({ ...prev, loading: true, error: null }));\n try {\n const response = await fetch('/api/recipes');\n const data = await response.json();\n \n if (data.success) {\n setState(prev => ({ \n ...prev, \n recipes: data.data, \n loading: false \n }));\n } else {\n setState(prev => ({ \n ...prev, \n error: data.error || 'Failed to load recipes', \n loading: false \n }));\n }\n } catch (error) {\n setState(prev => ({ \n ...prev, \n error: 'Network error loading recipes', \n loading: false \n }));\n }\n };\n\n const loadShoppingLists = async () => {\n setState(prev => ({ ...prev, loading: true, error: null }));\n try {\n const response = await fetch('/api/shopping-lists');\n const data = await response.json();\n \n if (data.success) {\n setState(prev => ({ \n ...prev, \n shoppingLists: data.data, \n loading: false \n }));\n } else {\n setState(prev => ({ \n ...prev, \n error: data.error || 'Failed to load shopping lists', \n loading: false \n }));\n }\n } catch (error) {\n setState(prev => ({ \n ...prev, \n error: 'Network error loading shopping lists', \n loading: false \n }));\n }\n };\n\n const handleRecipeSaved = (recipe: Recipe) => {\n setState(prev => ({\n ...prev,\n recipes: recipe.id \n ? prev.recipes.map(r => r.id === recipe.id ? recipe : r)\n : [...prev.recipes, recipe],\n view: 'view',\n selectedRecipe: recipe\n }));\n };\n\n const handleRecipeDeleted = (recipeId: number) => {\n setState(prev => ({\n ...prev,\n recipes: prev.recipes.filter(r => r.id !== recipeId),\n view: 'list',\n selectedRecipe: null\n }));\n };\n\n const handleShoppingListCreated = (shoppingList: ShoppingList) => {\n setState(prev => ({\n ...prev,\n shoppingLists: [shoppingList, ...prev.shoppingLists],\n view: 'shopping-list-view',\n selectedShoppingList: shoppingList\n }));\n };\n\n const handleShoppingListDeleted = (listId: number) => {\n setState(prev => ({\n ...prev,\n shoppingLists: prev.shoppingLists.filter(l => l.id !== listId),\n view: 'shopping-lists',\n selectedShoppingList: null\n }));\n };\n\n const handleCreateShoppingListFromCalendar = async (dates: string[]) => {\n setState(prev => ({ ...prev, loading: true, error: null }));\n\n try {\n const response = await fetch('/api/meal-plans/shopping-list', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ dates }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n const newShoppingList = data.data;\n setState(prev => ({\n ...prev,\n loading: false,\n shoppingLists: [newShoppingList, ...prev.shoppingLists],\n view: 'shopping-list-view',\n selectedShoppingList: newShoppingList\n }));\n } else {\n setState(prev => ({\n ...prev,\n loading: false,\n error: data.error || 'Failed to create shopping list from meal plans'\n }));\n }\n } catch (error) {\n setState(prev => ({\n ...prev,\n loading: false,\n error: 'Network error creating shopping list'\n }));\n }\n };\n\n const navigateTo = (view: View, recipe?: Recipe, shoppingList?: ShoppingList) => {\n setState(prev => ({\n ...prev,\n view,\n selectedRecipe: recipe || null,\n selectedShoppingList: shoppingList || null,\n error: null\n }));\n\n // Load shopping lists when navigating to shopping lists view\n if (view === 'shopping-lists' || view === 'shopping-list-create') {\n loadShoppingLists();\n }\n };\n\n const renderHeader = () => (\n <>\n {/* Mobile Header - Simplified */}\n

🍳

Cardamom

\n\n {/* Desktop Header - Original */}\n \n \n );\n\n const renderContent = () => {\n if (state.loading) {\n return (\n

\n Loading...\n

\n );\n }\n\n if (state.error) {\n return (\n

⚠️

Error

{state.error}

\n setState(prev => ({ ...prev, error: null }))}\n className=\"mt-3 text-red-600 hover:text-red-800 text-sm font-medium\"\n >\n Dismiss\n \n

\n );\n }\n\n switch (state.view) {\n case 'list':\n return (\n navigateTo('view', recipe)}\n onRecipeEdit={(recipe) => navigateTo('edit', recipe)}\n onRecipeDelete={handleRecipeDeleted}\n onRefresh={loadRecipes}\n onCreateShoppingList={() => navigateTo('shopping-list-create')}\n />\n );\n \n case 'add':\n return (\n navigateTo('list')}\n />\n );\n \n case 'edit':\n return (\n navigateTo('view', state.selectedRecipe)}\n />\n );\n \n case 'view':\n return (\n navigateTo('edit', recipe)}\n onDelete={handleRecipeDeleted}\n onBack={() => navigateTo('list')}\n />\n );\n\n case 'shopping-lists':\n return (\n navigateTo('shopping-list-view', undefined, shoppingList)}\n onCreateNew={() => navigateTo('shopping-list-create')}\n onRefresh={loadShoppingLists}\n onManageExcluded={() => navigateTo('excluded-ingredients')}\n />\n );\n\n case 'shopping-list-create':\n return (\n navigateTo('shopping-lists')}\n />\n );\n\n case 'shopping-list-view':\n return (\n navigateTo('shopping-lists')}\n onDelete={handleShoppingListDeleted}\n onUpdate={(updatedList) => {\n setState(prev => ({\n ...prev,\n selectedShoppingList: updatedList,\n shoppingLists: prev.shoppingLists.map(list => \n list.id === updatedList.id ? updatedList : list\n )\n }));\n }}\n />\n );\n\n case 'excluded-ingredients':\n return (\n navigateTo('shopping-lists')}\n />\n );\n\n case 'meal-calendar':\n return (\n navigateTo('list')}\n onCreateShoppingList={handleCreateShoppingListFromCalendar}\n />\n );\n\n default:\n return

Unknown view

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

\n {renderHeader()}\n

\n {renderContent()}\n

\n\n {/* Mobile Bottom Navigation */}\n

\n navigateTo('list')}\n className={`flex flex-col items-center justify-center space-y-1 transition-colors ${\n state.view === 'list'\n ? 'text-blue-600'\n : 'text-gray-600'\n }`}\n >\n 📚\n Recipes\n \n\n navigateTo('meal-calendar')}\n className={`flex flex-col items-center justify-center space-y-1 transition-colors ${\n state.view === 'meal-calendar'\n ? 'text-purple-600'\n : 'text-gray-600'\n }`}\n >\n 📅\n Calendar\n \n\n navigateTo('shopping-lists')}\n className={`flex flex-col items-center justify-center space-y-1 transition-colors ${\n state.view.startsWith('shopping')\n ? 'text-green-600'\n : 'text-gray-600'\n }`}\n >\n 🛒\n Lists\n \n\n navigateTo('add')}\n className={`flex flex-col items-center justify-center space-y-1 transition-colors ${\n state.view === 'add'\n ? 'text-orange-600'\n : 'text-gray-600'\n }`}\n >\n ➕\n Add\n \n

\n );\n}",[],[324,331,338],{"_104":347,"_95":348,"_154":349,"_156":332,"_157":139,"_158":223,"_160":161,"_106":350,"_100":32,"_163":226,"_165":351,"_166":22,"_167":-5,"_168":352,"_98":353},"9aba8378-9121-11f0-b677-0224a6c84d84","DayMealPlan.tsx","9aba842c-9121-11f0-b677-0224a6c84d84",["D",1757823396415],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { MealPlan, CalendarDay } from \"../../shared/types.ts\";\n\ninterface DayMealPlanProps {\n isOpen: boolean;\n calendarDay: CalendarDay | null;\n onClose: () => void;\n onAddRecipe: (mealType: 'breakfast-lunch' | 'dinner') => void;\n onMealPlanUpdated: () => void;\n}\n\nexport default function DayMealPlan({\n isOpen,\n calendarDay,\n onClose,\n onAddRecipe,\n onMealPlanUpdated\n}: DayMealPlanProps) {\n const [expandedMeals, setExpandedMeals] = useState>(new Set(['breakfast-lunch', 'dinner']));\n const [deletingMealPlanId, setDeletingMealPlanId] = useState(null);\n const [error, setError] = useState(null);\n\n const toggleMealExpansion = (mealType: string) => {\n setExpandedMeals(prev => {\n const newSet = new Set(prev);\n if (newSet.has(mealType)) {\n newSet.delete(mealType);\n } else {\n newSet.add(mealType);\n }\n return newSet;\n });\n };\n\n const deleteMealPlan = async (mealPlanId: number) => {\n setDeletingMealPlanId(mealPlanId);\n setError(null);\n\n try {\n const response = await fetch(`/api/meal-plans/${mealPlanId}`, {\n method: 'DELETE',\n });\n\n const data = await response.json();\n\n if (data.success) {\n onMealPlanUpdated();\n } else {\n setError(data.error || 'Failed to delete meal plan');\n }\n } catch (error) {\n setError('Network error deleting meal plan');\n } finally {\n setDeletingMealPlanId(null);\n }\n };\n\n const formatDate = (dateStr: string) => {\n return new Date(dateStr).toLocaleDateString('en-US', {\n weekday: 'long',\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n const getMealTypeIcon = (mealType: string) => {\n switch (mealType) {\n case 'breakfast-lunch': return '🌅';\n case 'dinner': return '🌙';\n default: return '🍽️';\n }\n };\n\n const getMealTypeColor = (mealType: string) => {\n switch (mealType) {\n case 'breakfast-lunch': return 'orange';\n case 'dinner': return 'purple';\n default: return 'gray';\n }\n };\n\n const getMealTypeDisplayName = (mealType: string) => {\n switch (mealType) {\n case 'breakfast-lunch': return 'Breakfast & Lunch';\n case 'dinner': return 'Dinner';\n default: return mealType;\n }\n };\n\n const renderMealSection = (\n mealType: 'breakfast-lunch' | 'dinner',\n mealPlans: MealPlan[]\n ) => {\n const isExpanded = expandedMeals.has(mealType);\n const color = getMealTypeColor(mealType);\n const icon = getMealTypeIcon(mealType);\n\n return (\n

\n toggleMealExpansion(mealType)}\n className={`w-full p-4 bg-${color}-50 hover:bg-${color}-100 transition-colors flex items-center justify-between`}\n >\n

\n {icon}\n

\n {getMealTypeDisplayName(mealType)}\n

\n {mealPlans.length} recipe{mealPlans.length !== 1 ? 's' : ''}\n

\n\n

\n {\n e.stopPropagation();\n onAddRecipe(mealType);\n }}\n className={`px-3 py-1 bg-${color}-600 text-white text-sm rounded-lg hover:bg-${color}-700 transition-colors`}\n >\n + Add Recipe\n \n \n {isExpanded ? '▼' : '▶'}\n \n

\n \n\n {isExpanded && (\n

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

No recipes planned for {getMealTypeDisplayName(mealType).toLowerCase()}

\n onAddRecipe(mealType)}\n className={`mt-2 px-4 py-2 bg-${color}-600 text-white text-sm rounded-lg hover:bg-${color}-700 transition-colors`}\n >\n Add First Recipe\n \n

\n ) : (\n

\n {mealPlans.map((mealPlan, index) => (\n \n

\n {mealPlan.recipe ? (\n <>\n

\n {mealPlan.recipe.title}\n

\n {mealPlan.recipe.description && (\n

\n {mealPlan.recipe.description}\n

\n )}\n

\n {mealPlan.recipe.servings && (\n 👥 {mealPlan.recipe.servings} servings\n )}\n {mealPlan.recipe.prepTime && (\n ⏱️ {mealPlan.recipe.prepTime}m prep\n )}\n {mealPlan.recipe.difficulty && (\n \n {mealPlan.recipe.difficulty}\n \n )}\n

\n {mealPlan.recipe.tags && mealPlan.recipe.tags.length > 0 && (\n

\n {mealPlan.recipe.tags.slice(0, 3).map(tag => (\n \n {tag}\n \n ))}\n {mealPlan.recipe.tags.length > 3 && (\n \n +{mealPlan.recipe.tags.length - 3} more\n \n )}\n

\n )}\n \n ) : (\n

⚠️ Recipe Deleted

This recipe is no longer available

\n )}\n\n {mealPlan.notes && (\n

\n Note: {mealPlan.notes}\n

\n )}\n

\n\n

\n deleteMealPlan(mealPlan.id!)}\n disabled={deletingMealPlanId === mealPlan.id}\n className=\"p-1 text-red-500 hover:text-red-700 hover:bg-red-50 rounded transition-colors disabled:opacity-50\"\n title=\"Remove from meal plan\"\n >\n {deletingMealPlanId === mealPlan.id ? '⏳' : '🗑️'}\n \n

\n ))}\n

\n )}\n

\n )}\n \n );\n };\n\n const getTotalIngredients = (): number => {\n if (!calendarDay) return 0;\n\n const allMealPlans = [\n ...calendarDay.meals['breakfast-lunch'],\n ...calendarDay.meals.dinner\n ];\n\n return allMealPlans.reduce((total, mealPlan) => {\n if (mealPlan.recipe && mealPlan.recipe.ingredients) {\n return total + mealPlan.recipe.ingredients.length;\n }\n return total;\n }, 0);\n };\n\n if (!isOpen || !calendarDay) return null;\n\n return (\n

\n {/* Backdrop */}\n

\n\n {/* Modal */}\n

\n {/* Header */}\n

\n {formatDate(calendarDay.date)}\n

\n {calendarDay.totalRecipeCount} recipes planned\n {getTotalIngredients()} total ingredients\n

\n \n ×\n \n

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

\n {error && (\n

⚠️

Error

{error}

\n setError(null)}\n className=\"mt-3 text-red-600 hover:text-red-800 text-sm font-medium\"\n >\n Dismiss\n \n

\n )}\n\n

\n {renderMealSection('breakfast-lunch', calendarDay.meals['breakfast-lunch'])}\n {renderMealSection('dinner', calendarDay.meals.dinner)}\n

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

\n Click \"Add Recipe\" to plan meals for this day\n

\n \n Done\n \n

\n );\n}",[],[324,331,348],{"_104":355,"_95":356,"_154":357,"_156":332,"_157":139,"_158":358,"_160":161,"_106":359,"_100":32,"_163":226,"_165":360,"_166":22,"_167":-5,"_168":361,"_98":362},"b27fea10-8ebb-11f0-ab74-0224a6c84d84","ExcludedIngredientsManager.tsx","b27feac4-8ebb-11f0-ab74-0224a6c84d84",330,["D",1757559725316],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { ExcludedIngredient } from \"../../shared/types.ts\";\n\ninterface ExcludedIngredientsManagerProps {\n onBack: () => void;\n}\n\nexport default function ExcludedIngredientsManager({ onBack }: ExcludedIngredientsManagerProps) {\n const [excludedIngredients, setExcludedIngredients] = useState([]);\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [newIngredient, setNewIngredient] = useState({ name: '', pattern: '' });\n const [saving, setSaving] = useState(false);\n\n useEffect(() => {\n loadExcludedIngredients();\n }, []);\n\n const loadExcludedIngredients = async () => {\n setLoading(true);\n setError(null);\n try {\n const response = await fetch('/api/excluded-ingredients');\n const data = await response.json();\n \n if (data.success) {\n setExcludedIngredients(data.data);\n } else {\n setError(data.error || 'Failed to load excluded ingredients');\n }\n } catch (error) {\n setError('Network error loading excluded ingredients');\n } finally {\n setLoading(false);\n }\n };\n\n const handleAdd = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!newIngredient.name.trim() || !newIngredient.pattern.trim()) {\n setError('Both name and pattern are required');\n return;\n }\n\n setSaving(true);\n setError(null);\n \n try {\n const response = await fetch('/api/excluded-ingredients', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n name: newIngredient.name.trim(),\n pattern: newIngredient.pattern.trim(),\n }),\n });\n\n const data = await response.json();\n \n if (data.success) {\n setExcludedIngredients(prev => [...prev, data.data]);\n setNewIngredient({ name: '', pattern: '' });\n } else {\n setError(data.error || 'Failed to add excluded ingredient');\n }\n } catch (error) {\n setError('Network error adding excluded ingredient');\n } finally {\n setSaving(false);\n }\n };\n\n const handleDelete = async (id: number) => {\n if (!confirm('Are you sure you want to remove this excluded ingredient?')) {\n return;\n }\n\n try {\n const response = await fetch(`/api/excluded-ingredients/${id}`, {\n method: 'DELETE',\n });\n\n const data = await response.json();\n \n if (data.success) {\n setExcludedIngredients(prev => prev.filter(item => item.id !== id));\n } else {\n setError(data.error || 'Failed to delete excluded ingredient');\n }\n } catch (error) {\n setError('Network error deleting excluded ingredient');\n }\n };\n\n return (\n

Excluded Ingredients

\n Manage ingredients that won't be added to shopping lists\n

\n \n ← Back\n \n

\n\n {error && (\n

⚠️

Error

{error}

\n setError(null)}\n className=\"mt-3 text-red-600 hover:text-red-800 text-sm font-medium\"\n >\n Dismiss\n \n

\n )}\n\n {/* Add New Excluded Ingredient Form */}\n

Add Excluded Ingredient

\n \n Display Name\n \n setNewIngredient(prev => ({ ...prev, name: e.target.value }))}\n placeholder=\"e.g., Salt\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n disabled={saving}\n />\n

\n \n Pattern to Match\n \n setNewIngredient(prev => ({ ...prev, pattern: e.target.value }))}\n placeholder=\"e.g., salt\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n disabled={saving}\n />\n

\n Tip: The pattern will match any ingredient name that contains this text. \n For example, \"salt\" will match \"kosher salt\", \"sea salt\", \"table salt\", etc.\n

\n \n {saving ? 'Adding...' : 'Add Excluded Ingredient'}\n \n \n

\n\n {/* Excluded Ingredients List */}\n

Current Excluded Ingredients

\n \n {loading ? (\n

\n Loading...\n

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

\n No excluded ingredients found.\n

\n ) : (\n

\n {excludedIngredients.map((ingredient) => (\n

{ingredient.name}

\n Pattern: {ingredient.pattern}\n

\n {ingredient.createdAt && (\n

\n Added {new Date(ingredient.createdAt).toLocaleDateString()}\n

\n )}\n

\n handleDelete(ingredient.id!)}\n className=\"px-3 py-1 text-sm text-red-600 hover:text-red-800 hover:bg-red-50 rounded transition-colors\"\n >\n Remove\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[324,331,356],{"_104":364,"_95":365,"_154":366,"_156":332,"_157":139,"_158":340,"_160":161,"_106":367,"_100":201,"_163":226,"_165":368,"_166":22,"_167":-5,"_168":369,"_98":370},"b0092800-9127-11f0-a29e-0224a6c84d84","MealPlanCalendar.tsx","9aba9200-9121-11f0-b677-0224a6c84d84",["D",1757826009148],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { MealPlan, CalendarDay, Recipe } from \"../../shared/types.ts\";\nimport DayMealPlan from \"./DayMealPlan.tsx\";\nimport MealPlanSidebar from \"./MealPlanSidebar.tsx\";\n\ninterface MealPlanCalendarProps {\n onBack: () => void;\n onCreateShoppingList?: (dates: string[]) => void;\n}\n\nexport default function MealPlanCalendar({ onBack, onCreateShoppingList }: MealPlanCalendarProps) {\n const [currentDate, setCurrentDate] = useState(new Date());\n const [mealPlans, setMealPlans] = useState([]);\n const [calendarDays, setCalendarDays] = useState([]);\n const [selectedDays, setSelectedDays] = useState>(new Set());\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [isSelectionMode, setIsSelectionMode] = useState(false);\n const [viewType, setViewType] = useState<'list' | 'calendar'>('list');\n\n // Touch handling for swipe gestures\n const touchStartX = useRef(null);\n const touchStartY = useRef(null);\n\n // Day detail modal state\n const [selectedCalendarDay, setSelectedCalendarDay] = useState(null);\n const [isDayModalOpen, setIsDayModalOpen] = useState(false);\n\n // Recipe selection sidebar state\n const [isSidebarOpen, setIsSidebarOpen] = useState(false);\n const [selectedDateForRecipe, setSelectedDateForRecipe] = useState(null);\n const [selectedMealTypeForRecipe, setSelectedMealTypeForRecipe] = useState<'breakfast-lunch' | 'dinner' | null>(null);\n\n // Generate calendar data for current month or list view\n useEffect(() => {\n if (viewType === 'calendar') {\n loadMealPlansForMonth();\n } else {\n loadMealPlansForList();\n }\n }, [currentDate, viewType]);\n\n const loadMealPlansForMonth = async () => {\n setLoading(true);\n setError(null);\n\n try {\n const startDate = getMonthStartDate(currentDate);\n const endDate = getMonthEndDate(currentDate);\n\n const response = await fetch(`/api/meal-plans?startDate=${startDate}&endDate=${endDate}`);\n const data = await response.json();\n\n if (data.success) {\n setMealPlans(data.data);\n generateCalendarDays(data.data);\n } else {\n setError(data.error || 'Failed to load meal plans');\n }\n } catch (error) {\n setError('Network error loading meal plans');\n } finally {\n setLoading(false);\n }\n };\n\n const loadMealPlansForList = async () => {\n setLoading(true);\n setError(null);\n\n try {\n const { startDate, endDate } = getDateForList();\n\n const response = await fetch(`/api/meal-plans?startDate=${startDate}&endDate=${endDate}`);\n const data = await response.json();\n\n if (data.success) {\n setMealPlans(data.data);\n // For list view, we don't need to generate calendar days\n } else {\n setError(data.error || 'Failed to load meal plans');\n }\n } catch (error) {\n setError('Network error loading meal plans');\n } finally {\n setLoading(false);\n }\n };\n\n const generateCalendarDays = (mealPlansData: MealPlan[]) => {\n const days: CalendarDay[] = [];\n const firstDay = new Date(currentDate.getFullYear(), currentDate.getMonth(), 1);\n const lastDay = new Date(currentDate.getFullYear(), currentDate.getMonth() + 1, 0);\n\n // Add days from previous month to fill the first week\n const startOfWeek = new Date(firstDay);\n startOfWeek.setDate(firstDay.getDate() - firstDay.getDay());\n\n // Add days to fill the last week\n const endOfWeek = new Date(lastDay);\n endOfWeek.setDate(lastDay.getDate() + (6 - lastDay.getDay()));\n\n const currentDay = new Date(startOfWeek);\n while (currentDay <= endOfWeek) {\n const dateStr = formatDate(currentDay);\n const dayMealPlans = mealPlansData.filter(mp => mp.date === dateStr);\n\n // Group meal plans by meal type\n const meals = {\n 'breakfast-lunch': dayMealPlans.filter(mp => mp.mealType === 'breakfast-lunch'),\n dinner: dayMealPlans.filter(mp => mp.mealType === 'dinner')\n };\n\n const totalRecipeCount = dayMealPlans.length;\n\n days.push({\n date: dateStr,\n meals,\n totalRecipeCount,\n isSelected: selectedDays.has(dateStr)\n });\n\n currentDay.setDate(currentDay.getDate() + 1);\n }\n\n setCalendarDays(days);\n };\n\n const formatDate = (date: Date): string => {\n // Use local date instead of UTC to avoid timezone issues\n const year = date.getFullYear();\n const month = String(date.getMonth() + 1).padStart(2, '0');\n const day = String(date.getDate()).padStart(2, '0');\n return `${year}-${month}-${day}`;\n };\n\n const getMonthStartDate = (date: Date): string => {\n return formatDate(new Date(date.getFullYear(), date.getMonth(), 1));\n };\n\n const getMonthEndDate = (date: Date): string => {\n return formatDate(new Date(date.getFullYear(), date.getMonth() + 1, 0));\n };\n\n const navigateMonth = (direction: 'prev' | 'next') => {\n setCurrentDate(prev => {\n const newDate = new Date(prev);\n if (direction === 'prev') {\n newDate.setMonth(newDate.getMonth() - 1);\n } else {\n newDate.setMonth(newDate.getMonth() + 1);\n }\n return newDate;\n });\n };\n\n // Handle touch events for swipe gestures\n const handleTouchStart = (e: React.TouchEvent) => {\n touchStartX.current = e.touches[0].clientX;\n touchStartY.current = e.touches[0].clientY;\n };\n\n const handleTouchEnd = (e: React.TouchEvent) => {\n if (!touchStartX.current || !touchStartY.current) return;\n\n const touchEndX = e.changedTouches[0].clientX;\n const touchEndY = e.changedTouches[0].clientY;\n const deltaX = touchEndX - touchStartX.current;\n const deltaY = touchEndY - touchStartY.current;\n\n // Only handle horizontal swipes (ignore vertical swipes for scrolling)\n if (Math.abs(deltaX) > Math.abs(deltaY) && Math.abs(deltaX) > 50) {\n if (viewType === 'calendar') {\n if (deltaX > 0) {\n navigateMonth('prev');\n } else {\n navigateMonth('next');\n }\n }\n }\n\n touchStartX.current = null;\n touchStartY.current = null;\n };\n\n const toggleDaySelection = (dateStr: string) => {\n if (!isSelectionMode) {\n // If not in selection mode, open day detail modal\n const day = calendarDays.find(d => d.date === dateStr);\n if (day && isCurrentMonth(dateStr)) {\n setSelectedCalendarDay(day);\n setIsDayModalOpen(true);\n }\n return;\n }\n\n setSelectedDays(prev => {\n const newSet = new Set(prev);\n if (newSet.has(dateStr)) {\n newSet.delete(dateStr);\n } else {\n newSet.add(dateStr);\n }\n return newSet;\n });\n };\n\n const handleAddRecipeToDay = (mealType: 'breakfast-lunch' | 'dinner') => {\n if (selectedCalendarDay) {\n setSelectedDateForRecipe(selectedCalendarDay.date);\n setSelectedMealTypeForRecipe(mealType);\n setIsDayModalOpen(false);\n setIsSidebarOpen(true);\n }\n };\n\n const handleRecipeAdded = () => {\n // Reload meal plans to refresh the current view\n if (viewType === 'calendar') {\n loadMealPlansForMonth();\n } else {\n loadMealPlansForList();\n }\n };\n\n const handleMealPlanUpdated = () => {\n // Reload meal plans and update the selected calendar day\n if (viewType === 'calendar') {\n loadMealPlansForMonth();\n\n // Update the selected calendar day if it's still selected\n if (selectedCalendarDay) {\n // The calendar day will be updated when loadMealPlansForMonth completes\n // We need to find the updated day after the reload\n setTimeout(() => {\n const updatedDay = calendarDays.find(d => d.date === selectedCalendarDay.date);\n if (updatedDay) {\n setSelectedCalendarDay(updatedDay);\n }\n }, 100);\n }\n } else {\n loadMealPlansForList();\n }\n };\n\n const handleCreateShoppingList = () => {\n if (selectedDays.size === 0) {\n setError('Please select at least one day');\n return;\n }\n\n onCreateShoppingList?.(Array.from(selectedDays));\n setIsSelectionMode(false);\n setSelectedDays(new Set());\n };\n\n const isCurrentMonth = (dateStr: string): boolean => {\n const date = new Date(dateStr);\n return date.getMonth() === currentDate.getMonth() &&\n date.getFullYear() === currentDate.getFullYear();\n };\n\n const isToday = (dateStr: string): boolean => {\n return dateStr === formatDate(new Date());\n };\n\n const getDaysForList = (): CalendarDay[] => {\n // For list view, get next 10 days starting from today (including blank days)\n const today = new Date();\n const days: CalendarDay[] = [];\n\n for (let i = 0; i < 10; i++) {\n const date = new Date(today);\n date.setDate(today.getDate() + i);\n const dateStr = formatDate(date);\n\n const dayMealPlans = mealPlans.filter(mp => mp.date === dateStr);\n const meals = {\n 'breakfast-lunch': dayMealPlans.filter(mp => mp.mealType === 'breakfast-lunch'),\n dinner: dayMealPlans.filter(mp => mp.mealType === 'dinner')\n };\n\n // Include all days (both with and without meal plans)\n days.push({\n date: dateStr,\n meals,\n totalRecipeCount: dayMealPlans.length,\n isSelected: selectedDays.has(dateStr)\n });\n }\n\n return days;\n };\n\n const getDateForList = () => {\n // For list view, load data for the next 10 days from today\n const today = new Date();\n const endDate = new Date(today);\n endDate.setDate(today.getDate() + 10);\n\n return {\n startDate: formatDate(today),\n endDate: formatDate(endDate)\n };\n };\n\n const renderDayCard = (day: CalendarDay) => {\n const date = new Date(day.date);\n const dayNumber = date.getDate();\n const isCurrentMonthDay = isCurrentMonth(day.date);\n const isTodayDay = isToday(day.date);\n const isSelected = selectedDays.has(day.date);\n\n return (\n toggleDaySelection(day.date)}\n >\n

\n \n {dayNumber}\n \n {isSelected && (\n

\n \n

\n )}\n

\n\n {day.totalRecipeCount > 0 && (\n

\n {day.meals['breakfast-lunch'].length > 0 && (\n

\n \n {day.meals['breakfast-lunch'].length}\n \n

\n )}\n {day.meals.dinner.length > 0 && (\n

\n \n {day.meals.dinner.length}\n \n

\n )}\n

\n )}\n \n );\n };\n\n const renderHeader = () => (\n <>\n {/* Mobile Header */}\n

\n \n ← Back\n \n

Meal Planning

{/* Spacer for centering */}\n

\n\n {/* View Switcher and Action Button on Mobile */}\n

\n setViewType('list')}\n className={`px-3 py-1.5 text-sm font-medium rounded-md transition-colors ${\n viewType === 'list'\n ? 'bg-white text-gray-900 shadow-sm'\n : 'text-gray-600'\n }`}\n >\n 📝 List\n \n setViewType('calendar')}\n className={`px-3 py-1.5 text-sm font-medium rounded-md transition-colors ${\n viewType === 'calendar'\n ? 'bg-white text-gray-900 shadow-sm'\n : 'text-gray-600'\n }`}\n >\n 📅 Calendar\n \n

\n\n {isSelectionMode ? (\n

\n \n {selectedDays.size} selected\n \n \n Create\n \n {\n setIsSelectionMode(false);\n setSelectedDays(new Set());\n }}\n className=\"px-3 py-1.5 bg-gray-300 text-gray-700 rounded-lg text-sm font-medium\"\n >\n Cancel\n \n

\n ) : (\n setIsSelectionMode(true)}\n className=\"px-3 py-1.5 bg-blue-500 text-white rounded-lg text-sm font-medium flex items-center space-x-1\"\n >\n \n List\n \n )}\n

\n\n {/* Desktop Header */}\n

\n \n ← Back\n \n

Meal Planning

\n\n {/* View Switcher */}\n

\n setViewType('list')}\n className={`px-3 py-1 text-sm font-medium rounded-md transition-colors ${\n viewType === 'list'\n ? 'bg-white text-gray-900 shadow-sm'\n : 'text-gray-600 hover:text-gray-900'\n }`}\n >\n 📝 List\n \n setViewType('calendar')}\n className={`px-3 py-1 text-sm font-medium rounded-md transition-colors ${\n viewType === 'calendar'\n ? 'bg-white text-gray-900 shadow-sm'\n : 'text-gray-600 hover:text-gray-900'\n }`}\n >\n 📅 Calendar\n \n

\n\n

\n {isSelectionMode ? (\n <>\n \n {selectedDays.size} day{selectedDays.size !== 1 ? 's' : ''} selected\n \n \n Create List\n \n {\n setIsSelectionMode(false);\n setSelectedDays(new Set());\n }}\n className=\"px-4 py-2 bg-gray-300 text-gray-700 rounded-lg font-medium hover:bg-gray-400 transition-colors\"\n >\n Cancel\n \n \n ) : (\n setIsSelectionMode(true)}\n className=\"px-4 py-2 bg-blue-600 text-white rounded-lg font-medium hover:bg-blue-700 transition-colors\"\n >\n 🛒 Create Shopping List\n \n )}\n

\n \n );\n\n const renderCalendarNavigation = () => (\n

\n navigateMonth('prev')}\n className=\"p-2 rounded-lg bg-white border border-gray-300 hover:bg-gray-50 transition-colors\"\n >\n ←\n \n\n

\n {currentDate.toLocaleDateString('en-US', { month: 'long', year: 'numeric' })}\n

\n\n navigateMonth('next')}\n className=\"p-2 rounded-lg bg-white border border-gray-300 hover:bg-gray-50 transition-colors\"\n >\n →\n \n

\n );\n\n const renderWeekHeader = () => (\n

\n {['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'].map(day => (\n

\n {day}\n

\n ))}\n

\n );\n\n const renderListView = () => {\n const days = getDaysForList();\n\n return (\n

\n {days.map(day => (\n {\n if (isSelectionMode) {\n const newSelected = new Set(selectedDays);\n if (newSelected.has(day.date)) {\n newSelected.delete(day.date);\n } else {\n newSelected.add(day.date);\n }\n setSelectedDays(newSelected);\n } else {\n setSelectedCalendarDay(day);\n setIsDayModalOpen(true);\n }\n }}\n >\n {/* Day Header */}\n

\n {new Date(day.date).toLocaleDateString('en-US', {\n weekday: 'short',\n month: 'short',\n day: 'numeric'\n })}\n {isToday(day.date) && Today}\n

\n {day.totalRecipeCount} recipe{day.totalRecipeCount !== 1 ? 's' : ''}\n

\n\n

\n {isSelectionMode && (\n

\n {selectedDays.has(day.date) && (\n \n )}\n

\n )}\n

\n\n {/* Meals - Simplified for mobile */}\n

\n {/* Breakfast & Lunch */}\n

\n \n 🍳\n Breakfast & Lunch\n \n {!isSelectionMode && (\n {\n e.stopPropagation();\n setSelectedDateForRecipe(day.date);\n setSelectedMealTypeForRecipe('breakfast-lunch');\n setIsSidebarOpen(true);\n }}\n className=\"text-xs px-3 py-1.5 bg-orange-600 text-white rounded-full font-medium hover:bg-orange-700 transition-colors\"\n >\n + Add\n \n )}\n

\n {day.meals['breakfast-lunch'].length > 0 ? (\n day.meals['breakfast-lunch'].map((mealPlan, index) => (\n

\n \n {mealPlan.recipe ? mealPlan.recipe.title : '⚠️ Recipe deleted'}\n \n {mealPlan.recipe && mealPlan.recipe.prepTime && (\n \n {mealPlan.recipe.prepTime}m\n \n )}\n

\n ))\n ) : (\n

No meals planned

\n )}\n

\n\n {/* Dinner */}\n

\n \n 🌙\n Dinner\n \n {!isSelectionMode && (\n {\n e.stopPropagation();\n setSelectedDateForRecipe(day.date);\n setSelectedMealTypeForRecipe('dinner');\n setIsSidebarOpen(true);\n }}\n className=\"text-xs px-3 py-1.5 bg-purple-600 text-white rounded-full font-medium hover:bg-purple-700 transition-colors\"\n >\n + Add\n \n )}\n

\n {day.meals.dinner.length > 0 ? (\n day.meals.dinner.map((mealPlan, index) => (\n

\n \n {mealPlan.recipe ? mealPlan.recipe.title : '⚠️ Recipe deleted'}\n \n {mealPlan.recipe && mealPlan.recipe.prepTime && (\n \n {mealPlan.recipe.prepTime}m\n \n )}\n

\n ))\n ) : (\n

No meals planned

\n )}\n

\n ))}\n\n {/* Floating Action Button for Mobile */}\n {!isSelectionMode && (\n

\n setIsSelectionMode(true)}\n className=\"w-14 h-14 bg-blue-600 text-white rounded-full shadow-lg flex items-center justify-center hover:bg-blue-700 transition-colors\"\n aria-label=\"Create Shopping List\"\n >\n \n \n

\n )}\n

\n );\n };\n\n if (loading) {\n return (\n

\n {renderHeader()}\n

\n Loading meal plans...\n

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

\n {renderHeader()}\n\n {error && (\n

⚠️

Error

{error}

\n setError(null)}\n className=\"mt-2 md:mt-3 text-red-600 hover:text-red-800 text-xs md:text-sm font-medium\"\n >\n Dismiss\n \n

\n )}\n\n {viewType === 'list' ? (\n <>\n {renderListView()}\n {isSelectionMode && (\n

\n Tap days to select for shopping list\n

\n )}\n \n ) : (\n \n {renderCalendarNavigation()}\n

\n {/* Simplified week header for mobile */}\n

\n {['S', 'M', 'T', 'W', 'T', 'F', 'S'].map(day => (\n

\n {day}\n

\n ))}\n

\n {renderWeekHeader()}\n

\n\n

\n {calendarDays.map(day => renderDayCard(day))}\n

\n\n

\n {/* Desktop legend */}\n

\n Legend:\n \n

\n B&L = Breakfast & Lunch\n \n \n

\n D = Dinner\n \n

\n\n {isSelectionMode ? (\n

\n Click days to select for shopping list\n

\n ) : (\n

\n Click a day to view and edit meal plans\n

\n )}\n

\n\n {/* Mobile legend */}\n

\n \n \n Breakfast/Lunch\n \n \n \n Dinner\n \n

\n {isSelectionMode ? (\n

\n Tap days to select\n

\n ) : (\n

\n Tap a day to view meals\n

\n )}\n

\n )}\n\n {/* Day Detail Modal */}\n {\n setIsDayModalOpen(false);\n setSelectedCalendarDay(null);\n }}\n onAddRecipe={handleAddRecipeToDay}\n onMealPlanUpdated={handleMealPlanUpdated}\n />\n\n {/* Recipe Selection Sidebar */}\n {\n setIsSidebarOpen(false);\n setSelectedDateForRecipe(null);\n setSelectedMealTypeForRecipe(null);\n }}\n onRecipeAdded={handleRecipeAdded}\n />\n \n );\n}",[],[324,331,365],{"_104":372,"_95":373,"_154":374,"_156":332,"_157":139,"_158":223,"_160":161,"_106":375,"_100":32,"_163":226,"_165":376,"_166":22,"_167":-5,"_168":377,"_98":378},"9abaabc8-9121-11f0-b677-0224a6c84d84","MealPlanSidebar.tsx","9abaac7c-9121-11f0-b677-0224a6c84d84",["D",1757823396415],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, CreateMealPlanRequest } from \"../../shared/types.ts\";\n\ninterface MealPlanSidebarProps {\n isOpen: boolean;\n selectedDate: string | null;\n selectedMealType: 'breakfast-lunch' | 'dinner' | null;\n onClose: () => void;\n onRecipeAdded: () => void;\n}\n\nexport default function MealPlanSidebar({\n isOpen,\n selectedDate,\n selectedMealType,\n onClose,\n onRecipeAdded\n}: MealPlanSidebarProps) {\n const [recipes, setRecipes] = useState([]);\n const [filteredRecipes, setFilteredRecipes] = useState([]);\n const [searchTerm, setSearchTerm] = useState('');\n const [selectedTags, setSelectedTags] = useState([]);\n const [selectedDifficulty, setSelectedDifficulty] = useState('');\n const [maxPrepTime, setMaxPrepTime] = useState('');\n const [loading, setLoading] = useState(false);\n const [addingRecipeId, setAddingRecipeId] = useState(null);\n const [error, setError] = useState(null);\n\n // Load recipes when sidebar opens\n useEffect(() => {\n if (isOpen) {\n loadRecipes();\n }\n }, [isOpen]);\n\n // Filter recipes when search/filter criteria change\n useEffect(() => {\n filterRecipes();\n }, [recipes, searchTerm, selectedTags, selectedDifficulty, maxPrepTime]);\n\n const loadRecipes = async () => {\n setLoading(true);\n setError(null);\n\n try {\n const response = await fetch('/api/recipes');\n const data = await response.json();\n\n if (data.success) {\n setRecipes(data.data);\n } else {\n setError(data.error || 'Failed to load recipes');\n }\n } catch (error) {\n setError('Network error loading recipes');\n } finally {\n setLoading(false);\n }\n };\n\n const filterRecipes = () => {\n let filtered = [...recipes];\n\n // Text search\n if (searchTerm.trim()) {\n const term = searchTerm.toLowerCase();\n filtered = filtered.filter(recipe =>\n recipe.title.toLowerCase().includes(term) ||\n recipe.description?.toLowerCase().includes(term) ||\n recipe.ingredients.some(ing => ing.name.toLowerCase().includes(term))\n );\n }\n\n // Tag filter\n if (selectedTags.length > 0) {\n filtered = filtered.filter(recipe =>\n recipe.tags && selectedTags.some(tag => recipe.tags.includes(tag))\n );\n }\n\n // Difficulty filter\n if (selectedDifficulty) {\n filtered = filtered.filter(recipe => recipe.difficulty === selectedDifficulty);\n }\n\n // Prep time filter\n if (maxPrepTime) {\n const maxTime = parseInt(maxPrepTime);\n filtered = filtered.filter(recipe =>\n recipe.prepTime && recipe.prepTime <= maxTime\n );\n }\n\n setFilteredRecipes(filtered);\n };\n\n const getAllTags = (): string[] => {\n const tags = new Set();\n recipes.forEach(recipe => {\n if (recipe.tags) {\n recipe.tags.forEach(tag => tags.add(tag));\n }\n });\n return Array.from(tags).sort();\n };\n\n const toggleTag = (tag: string) => {\n setSelectedTags(prev =>\n prev.includes(tag)\n ? prev.filter(t => t !== tag)\n : [...prev, tag]\n );\n };\n\n const addRecipeToMealPlan = async (recipe: Recipe) => {\n if (!selectedDate || !selectedMealType) {\n setError('Please select a date and meal type');\n return;\n }\n\n setAddingRecipeId(recipe.id!);\n setError(null);\n\n try {\n const mealPlanData: CreateMealPlanRequest = {\n recipeId: recipe.id!,\n date: selectedDate,\n mealType: selectedMealType\n };\n\n const response = await fetch('/api/meal-plans', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(mealPlanData),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onRecipeAdded();\n // Close sidebar to provide clear feedback that the action was successful\n onClose();\n } else {\n setError(data.error || 'Failed to add recipe to meal plan');\n }\n } catch (error) {\n setError('Network error adding recipe');\n } finally {\n setAddingRecipeId(null);\n }\n };\n\n const clearFilters = () => {\n setSearchTerm('');\n setSelectedTags([]);\n setSelectedDifficulty('');\n setMaxPrepTime('');\n };\n\n const formatMealType = (mealType: string) => {\n switch (mealType) {\n case 'breakfast-lunch': return 'Breakfast & Lunch';\n case 'dinner': return 'Dinner';\n default: return mealType;\n }\n };\n\n const formatDate = (dateStr: string) => {\n return new Date(dateStr).toLocaleDateString('en-US', {\n weekday: 'long',\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n if (!isOpen) return null;\n\n return (\n

\n {/* Backdrop */}\n

\n\n {/* Sidebar */}\n

\n {/* Header */}\n

Add Recipe

\n \n ×\n \n

\n\n {selectedDate && selectedMealType && (\n

{formatDate(selectedDate)}

{formatMealType(selectedMealType)}

\n )}\n

\n\n {/* Filters */}\n

\n {/* Search */}\n

\n setSearchTerm(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n />\n

\n\n {/* Quick filters */}\n

\n setSelectedDifficulty(e.target.value)}\n className=\"px-2 py-1 border border-gray-300 rounded text-sm\"\n >\n \n \n \n \n \n\n setMaxPrepTime(e.target.value)}\n className=\"px-2 py-1 border border-gray-300 rounded text-sm w-24\"\n />\n\n \n Clear\n \n

\n\n {/* Tags */}\n {getAllTags().length > 0 && (\n

\n {getAllTags().slice(0, 10).map(tag => (\n toggleTag(tag)}\n className={`px-2 py-1 text-xs rounded-full transition-colors ${\n selectedTags.includes(tag)\n ? 'bg-blue-100 text-blue-700 border border-blue-300'\n : 'bg-gray-100 text-gray-600 hover:bg-gray-200'\n }`}\n >\n {tag}\n \n ))}\n

\n )}\n

\n\n {/* Recipe list */}\n

\n {error && (\n

{error}

\n setError(null)}\n className=\"text-red-600 hover:text-red-800 text-xs mt-1\"\n >\n Dismiss\n \n

\n )}\n\n {loading ? (\n

\n Loading recipes...\n

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

\n {recipes.length === 0 ? 'No recipes found' : 'No recipes match your filters'}\n

\n ) : (\n

\n {filteredRecipes.map(recipe => (\n

\n {recipe.title}\n

\n {recipe.description && (\n

\n {recipe.description}\n

\n )}\n

\n {recipe.prepTime && (\n ⏱️ {recipe.prepTime}m\n )}\n {recipe.difficulty && (\n \n {recipe.difficulty}\n \n )}\n

\n {recipe.tags && recipe.tags.length > 0 && (\n

\n {recipe.tags.slice(0, 3).map(tag => (\n \n {tag}\n \n ))}\n {recipe.tags.length > 3 && (\n \n +{recipe.tags.length - 3} more\n \n )}\n

\n )}\n

\n\n addRecipeToMealPlan(recipe)}\n disabled={addingRecipeId === recipe.id}\n className=\"ml-3 px-3 py-1 bg-blue-600 text-white text-xs rounded-lg hover:bg-blue-700 disabled:bg-gray-300 disabled:cursor-not-allowed transition-colors\"\n >\n {addingRecipeId === recipe.id ? '...' : 'Add'}\n \n

\n ))}\n

\n )}\n

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

\n {filteredRecipes.length} recipe{filteredRecipes.length !== 1 ? 's' : ''} shown\n {selectedTags.length > 0 || selectedDifficulty || maxPrepTime || searchTerm ? (\n (filtered)\n ) : null}\n

\n );\n}",[],[324,331,373],{"_104":380,"_95":381,"_154":382,"_156":332,"_157":139,"_158":340,"_160":161,"_106":383,"_100":384,"_163":226,"_165":385,"_166":22,"_167":-5,"_168":386,"_98":387},"b0093f98-9127-11f0-a29e-0224a6c84d84","RecipeForm.tsx","093b2ada-494e-11f0-8925-76b3cceeab13",["D",1757826009148],15,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, Ingredient, ParseRequest } from \"../../shared/types.ts\";\n\ninterface RecipeFormProps {\n recipe?: Recipe | null;\n onRecipeSaved: (recipe: Recipe) => void;\n onCancel: () => void;\n}\n\nexport default function RecipeForm({ recipe, onRecipeSaved, onCancel }: RecipeFormProps) {\n const [formData, setFormData] = useState>({\n title: recipe?.title || '',\n description: recipe?.description || '',\n ingredients: recipe?.ingredients || [{ name: '', amount: '', unit: '' }],\n steps: recipe?.steps || [''],\n servings: recipe?.servings || undefined,\n prepTime: recipe?.prepTime || undefined,\n cookTime: recipe?.cookTime || undefined,\n difficulty: recipe?.difficulty || undefined,\n tags: recipe?.tags || [],\n source: recipe?.source || ''\n });\n\n const [tagInput, setTagInput] = useState(recipe?.tags?.join(', ') || '');\n\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [parseMode, setParseMode] = useState<'manual' | 'url' | 'file' | 'text'>('manual');\n const [parseInput, setParseInput] = useState('');\n const [uploadedFile, setUploadedFile] = useState(null);\n const fileInputRef = useRef(null);\n\n const isEditing = !!recipe?.id;\n\n const handleInputChange = (field: keyof Recipe, value: any) => {\n setFormData(prev => ({ ...prev, [field]: value }));\n setError(null);\n };\n\n const handleIngredientChange = (index: number, field: keyof Ingredient, value: string) => {\n const newIngredients = [...(formData.ingredients || [])];\n newIngredients[index] = { ...newIngredients[index], [field]: value };\n handleInputChange('ingredients', newIngredients);\n };\n\n const addIngredient = () => {\n const newIngredients = [...(formData.ingredients || []), { name: '', amount: '', unit: '' }];\n handleInputChange('ingredients', newIngredients);\n };\n\n const removeIngredient = (index: number) => {\n const newIngredients = (formData.ingredients || []).filter((_, i) => i !== index);\n handleInputChange('ingredients', newIngredients);\n };\n\n const handleStepChange = (index: number, value: string) => {\n const newSteps = [...(formData.steps || [])];\n newSteps[index] = value;\n handleInputChange('steps', newSteps);\n };\n\n const addStep = () => {\n const newSteps = [...(formData.steps || []), ''];\n handleInputChange('steps', newSteps);\n };\n\n const removeStep = (index: number) => {\n const newSteps = (formData.steps || []).filter((_, i) => i !== index);\n handleInputChange('steps', newSteps);\n };\n\n const handleTagsChange = (value: string) => {\n setTagInput(value);\n \n // Parse tags: split by comma, trim whitespace, filter empty strings, and remove duplicates\n const tags = value\n .split(',')\n .map(tag => tag.trim())\n .filter(tag => tag.length > 0)\n .filter((tag, index, array) => array.findIndex(t => t.toLowerCase() === tag.toLowerCase()) === index);\n \n handleInputChange('tags', tags);\n };\n\n const handleTagInputBlur = () => {\n // Clean up the input display when user finishes editing\n const cleanedInput = formData.tags?.join(', ') || '';\n setTagInput(cleanedInput);\n };\n\n const parseRecipe = async () => {\n // Validation based on parse mode\n if (parseMode === 'file') {\n if (!uploadedFile || !parseInput.trim()) {\n setError('Please select a file to parse');\n return;\n }\n } else {\n if (!parseInput.trim()) {\n setError('Please provide input to parse');\n return;\n }\n }\n\n setLoading(true);\n setError(null);\n\n try {\n let endpoint = '';\n let requestData: ParseRequest;\n\n switch (parseMode) {\n case 'url':\n endpoint = '/api/parse/url';\n requestData = { type: 'url', content: parseInput };\n break;\n case 'text':\n endpoint = '/api/parse/text';\n requestData = { type: 'url', content: parseInput }; // Note: backend expects 'url' type for text parsing\n break;\n case 'file':\n if (!uploadedFile) {\n throw new Error('No file selected');\n }\n \n if (uploadedFile.type.startsWith('image/')) {\n endpoint = '/api/parse/image';\n requestData = { type: 'image', content: parseInput };\n } else if (uploadedFile.type === 'application/pdf') {\n endpoint = '/api/parse/pdf';\n requestData = { type: 'pdf', content: parseInput };\n } else {\n throw new Error('Unsupported file type');\n }\n break;\n default:\n throw new Error('Invalid parse mode');\n }\n\n const response = await fetch(endpoint, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(requestData)\n });\n\n const data = await response.json();\n\n if (data.success && data.recipe) {\n setFormData(data.recipe);\n setTagInput(data.recipe.tags?.join(', ') || '');\n setParseMode('manual');\n setParseInput('');\n } else {\n setError(data.error || 'Failed to parse recipe');\n }\n } catch (error) {\n setError('Network error while parsing recipe');\n } finally {\n setLoading(false);\n }\n };\n\n const handleFileUpload = (event: React.ChangeEvent) => {\n const file = event.target.files?.[0];\n if (!file) return;\n\n // Validate file type\n const isImage = file.type.startsWith('image/');\n const isPDF = file.type === 'application/pdf';\n \n if (!isImage && !isPDF) {\n setError('Please select an image file (JPG, PNG, etc.) or a PDF file');\n return;\n }\n\n setUploadedFile(file);\n setError(null);\n\n const reader = new FileReader();\n reader.onload = (e) => {\n const base64 = e.target?.result as string;\n setParseInput(base64);\n };\n reader.readAsDataURL(file);\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validation\n if (!formData.title?.trim()) {\n setError('Recipe title is required');\n return;\n }\n\n if (!formData.ingredients?.length || formData.ingredients.every(ing => !ing.name.trim())) {\n setError('At least one ingredient is required');\n return;\n }\n\n if (!formData.steps?.length || formData.steps.every(step => !step.trim())) {\n setError('At least one cooking step is required');\n return;\n }\n\n setLoading(true);\n setError(null);\n\n try {\n const cleanedData = {\n ...formData,\n ingredients: formData.ingredients?.filter(ing => ing.name.trim()) || [],\n steps: formData.steps?.filter(step => step.trim()) || []\n };\n\n const url = isEditing ? `/api/recipes/${recipe.id}` : '/api/recipes';\n const method = isEditing ? 'PUT' : 'POST';\n\n const response = await fetch(url, {\n method,\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(cleanedData)\n });\n\n const data = await response.json();\n\n if (data.success) {\n onRecipeSaved(data.data);\n } else {\n setError(data.error || 'Failed to save recipe');\n }\n } catch (error) {\n setError('Network error while saving recipe');\n } finally {\n setLoading(false);\n }\n };\n\n const renderParseSection = () => (\n

🤖 Smart Recipe Import

\n \n

\n {(['url', 'text', 'file'] as const).map(mode => (\n setParseMode(mode)}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n parseMode === mode\n ? 'bg-blue-600 text-white'\n : 'bg-white text-blue-600 border border-blue-300 hover:bg-blue-50'\n }`}\n >\n {mode === 'url' && '🔗 URL'}\n {mode === 'text' && '📝 Text'}\n {mode === 'file' && '📄 File'}\n \n ))}\n

\n\n {parseMode === 'url' && (\n

\n setParseInput(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n )}\n\n {parseMode === 'text' && (\n

\n setParseInput(e.target.value)}\n rows={4}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n )}\n\n {parseMode === 'file' && (\n

\n \n

\n 📷 Images (JPG, PNG, etc.) or 📄 PDF files supported\n

\n {uploadedFile && (\n

\n ✅\n \n {uploadedFile.type.startsWith('image/') ? '📷' : '📄'} \n {uploadedFile.name} uploaded and ready to parse\n \n

\n )}\n

\n )}\n\n \n {loading ? (\n <>\n

\n Parsing...\n \n ) : (\n '🔍 Parse Recipe'\n )}\n \n

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

\n {isEditing ? '✏️ Edit Recipe' : '➕ Add New Recipe'}\n

\n \n ✕\n \n

\n\n {!isEditing && renderParseSection()}\n\n {error && (\n

⚠️

{error}

\n )}\n\n

\n {/* Basic Info */}\n

\n \n Recipe Title *\n \n handleInputChange('title', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Enter recipe title\"\n required\n />\n

\n\n

\n \n Description\n \n handleInputChange('description', e.target.value)}\n rows={2}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Brief description of the recipe\"\n />\n

\n\n

\n \n Servings\n \n handleInputChange('servings', e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"4\"\n min=\"1\"\n />\n

\n\n

\n \n Difficulty\n \n handleInputChange('difficulty', e.target.value || undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n \n \n \n \n

\n\n

\n \n Prep Time (minutes)\n \n handleInputChange('prepTime', e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"15\"\n min=\"0\"\n />\n

\n\n

\n \n Cook Time (minutes)\n \n handleInputChange('cookTime', e.target.value ? parseInt(e.target.value) : undefined)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"30\"\n min=\"0\"\n />\n

\n\n

\n \n Tags (comma-separated)\n \n handleTagsChange(e.target.value)}\n onBlur={handleTagInputBlur}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"vegetarian, quick, healthy\"\n />\n {formData.tags && formData.tags.length > 0 && (\n

\n {formData.tags.map((tag, index) => (\n \n {tag}\n {\n const newTags = formData.tags?.filter((_, i) => i !== index) || [];\n handleInputChange('tags', newTags);\n setTagInput(newTags.join(', '));\n }}\n className=\"ml-1 text-blue-600 hover:text-blue-800\"\n >\n ×\n \n \n ))}\n

\n )}\n

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

🥕 Ingredients *

\n \n + Add Ingredient\n \n

\n\n

\n {(formData.ingredients || []).map((ingredient, index) => (\n

\n handleIngredientChange(index, 'name', e.target.value)}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n handleIngredientChange(index, 'amount', e.target.value)}\n className=\"w-20 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n handleIngredientChange(index, 'unit', e.target.value)}\n className=\"w-20 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n removeIngredient(index)}\n className=\"text-red-500 hover:text-red-700 p-2\"\n >\n 🗑️\n \n

\n ))}\n

\n\n {/* Steps */}\n

👩‍🍳 Cooking Steps *

\n \n + Add Step\n \n

\n\n

\n {(formData.steps || []).map((step, index) => (\n

\n {index + 1}\n

\n handleStepChange(index, e.target.value)}\n rows={2}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n removeStep(index)}\n className=\"text-red-500 hover:text-red-700 p-2 mt-2\"\n >\n 🗑️\n \n

\n ))}\n

\n\n {/* Source */}\n

\n \n Source\n \n handleInputChange('source', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"Recipe source (URL, book, etc.)\"\n />\n

\n\n {/* Submit Buttons */}\n

\n \n {loading ? (\n <>\n

\n Saving...\n \n ) : (\n <>\n 💾 {isEditing ? 'Update Recipe' : 'Save Recipe'}\n \n )}\n \n \n Cancel\n \n

\n );\n}",[],[324,331,381],{"_104":389,"_95":390,"_154":391,"_156":332,"_157":139,"_158":392,"_160":22,"_106":393,"_100":270,"_163":226,"_165":394,"_166":22,"_167":-5,"_168":395,"_98":396},"84ecbf6e-904c-11f0-80b8-0224a6c84d84","RecipeList.tsx","28dc54fe-494e-11f0-b588-76b3cceeab13",368,["D",1757731877041],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe } from \"../../shared/types.ts\";\n\ninterface RecipeListProps {\n recipes: Recipe[];\n onRecipeSelect: (recipe: Recipe) => void;\n onRecipeEdit: (recipe: Recipe) => void;\n onRecipeDelete: (recipeId: number) => void;\n onRefresh: () => void;\n onCreateShoppingList?: () => void;\n}\n\nexport default function RecipeList({ \n recipes, \n onRecipeSelect, \n onRecipeEdit, \n onRecipeDelete, \n onRefresh,\n onCreateShoppingList\n}: RecipeListProps) {\n const [searchTerm, setSearchTerm] = useState('');\n const [filterDifficulty, setFilterDifficulty] = useState('');\n const [sortBy, setSortBy] = useState<'title' | 'created' | 'prepTime'>('created');\n const [deleteConfirm, setDeleteConfirm] = useState(null);\n\n // Filter and sort recipes\n const filteredRecipes = recipes\n .filter(recipe => {\n const matchesSearch = recipe.title.toLowerCase().includes(searchTerm.toLowerCase()) ||\n recipe.description?.toLowerCase().includes(searchTerm.toLowerCase()) ||\n recipe.ingredients.some(ing => ing.name.toLowerCase().includes(searchTerm.toLowerCase())) ||\n recipe.tags?.some(tag => tag.toLowerCase().includes(searchTerm.toLowerCase()));\n \n const matchesDifficulty = !filterDifficulty || recipe.difficulty === filterDifficulty;\n \n return matchesSearch && matchesDifficulty;\n })\n .sort((a, b) => {\n switch (sortBy) {\n case 'title':\n return a.title.localeCompare(b.title);\n case 'prepTime':\n return (a.prepTime || 0) - (b.prepTime || 0);\n case 'created':\n default:\n return new Date(b.createdAt || 0).getTime() - new Date(a.createdAt || 0).getTime();\n }\n });\n\n const handleDelete = async (recipeId: number) => {\n try {\n const response = await fetch(`/api/recipes/${recipeId}`, {\n method: 'DELETE'\n });\n \n const data = await response.json();\n \n if (data.success) {\n onRecipeDelete(recipeId);\n setDeleteConfirm(null);\n } else {\n alert('Failed to delete recipe: ' + (data.error || 'Unknown error'));\n }\n } catch (error) {\n alert('Network error while deleting recipe');\n }\n };\n\n const formatTime = (minutes?: number) => {\n if (!minutes) return '';\n if (minutes < 60) return `${minutes}m`;\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n return mins > 0 ? `${hours}h ${mins}m` : `${hours}h`;\n };\n\n const getDifficultyColor = (difficulty?: string) => {\n switch (difficulty) {\n case 'easy': return 'bg-green-100 text-green-800';\n case 'medium': return 'bg-yellow-100 text-yellow-800';\n case 'hard': return 'bg-red-100 text-red-800';\n default: return 'bg-gray-100 text-gray-800';\n }\n };\n\n const renderEmptyState = () => (\n

🍳

No recipes yet

\n Start building your recipe collection by adding your first recipe!\n

\n window.location.hash = '#add'}\n className=\"bg-blue-600 text-white px-6 py-3 rounded-lg hover:bg-blue-700 font-medium\"\n >\n ➕ Add Your First Recipe\n \n

\n );\n\n const renderFilters = () => (\n

\n setSearchTerm(e.target.value)}\n className=\"w-full px-4 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n \n

\n setFilterDifficulty(e.target.value)}\n className=\"px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n \n \n \n \n \n setSortBy(e.target.value as any)}\n className=\"px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n \n \n \n \n \n 🔄\n \n

\n );\n\n const renderRecipeCard = (recipe: Recipe) => (\n

onRecipeSelect(recipe)}\n >\n {recipe.title}\n

\n \n

\n onRecipeEdit(recipe)}\n className=\"text-gray-400 hover:text-blue-600 p-1\"\n title=\"Edit recipe\"\n >\n ✏️\n \n setDeleteConfirm(recipe.id!)}\n className=\"text-gray-400 hover:text-red-600 p-1\"\n title=\"Delete recipe\"\n >\n 🗑️\n \n

\n\n {recipe.description && (\n

\n {recipe.description}\n

\n )}\n\n

\n {recipe.difficulty && (\n \n {recipe.difficulty}\n \n )}\n \n {recipe.servings && (\n \n 👥 {recipe.servings} servings\n \n )}\n \n {recipe.prepTime && (\n \n ⏱️ {formatTime(recipe.prepTime)} prep\n \n )}\n \n {recipe.cookTime && (\n \n 🔥 {formatTime(recipe.cookTime)} cook\n \n )}\n

\n\n

\n 🥕 {recipe.ingredients.length} ingredients\n 👩‍🍳 {recipe.steps.length} steps\n

\n \n {recipe.createdAt && (\n \n {new Date(recipe.createdAt).toLocaleDateString()}\n \n )}\n

\n\n {recipe.tags && recipe.tags.length > 0 && (\n

\n {recipe.tags.slice(0, 3).map(tag => (\n \n #{tag}\n \n ))}\n {recipe.tags.length > 3 && (\n \n +{recipe.tags.length - 3} more\n \n )}\n

\n )}\n

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

📚 My Recipes

\n {filteredRecipes.length} of {recipes.length} recipes\n

\n {recipes.length > 0 && onCreateShoppingList && (\n \n 🛒\n Create Shopping List\n \n )}\n

\n\n {recipes.length === 0 ? (\n renderEmptyState()\n ) : (\n <>\n {renderFilters()}\n \n {filteredRecipes.length === 0 ? (\n

🔍

No recipes found

\n Try adjusting your search terms or filters\n

\n ) : (\n

\n {filteredRecipes.map(renderRecipeCard)}\n

\n )}\n \n )}\n\n {/* Delete Confirmation Modal */}\n {deleteConfirm && (\n

⚠️

Delete Recipe?

\n This action cannot be undone. The recipe will be permanently deleted.\n

\n handleDelete(deleteConfirm)}\n className=\"flex-1 bg-red-600 text-white px-4 py-2 rounded-md hover:bg-red-700\"\n >\n Delete\n \n setDeleteConfirm(null)}\n className=\"flex-1 bg-gray-300 text-gray-700 px-4 py-2 rounded-md hover:bg-gray-400\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[324,331,390],{"_104":398,"_95":399,"_154":400,"_156":332,"_157":139,"_158":401,"_160":161,"_106":402,"_100":326,"_163":226,"_165":403,"_166":22,"_167":-5,"_168":404,"_98":405},"f07ab52c-516a-11f0-9319-f69ea79377d9","RecipeView.tsx","4cbb0bc2-494e-11f0-a719-76b3cceeab13",193,["D",1750818019132],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, Ingredient } from \"../../shared/types.ts\";\n\ninterface RecipeViewProps {\n recipe: Recipe | null;\n onEdit: (recipe: Recipe) => void;\n onDelete: (recipeId: number) => void;\n onBack: () => void;\n}\n\nexport default function RecipeView({ recipe, onEdit, onDelete, onBack }: RecipeViewProps) {\n const [servingMultiplier, setServingMultiplier] = useState(1);\n const [deleteConfirm, setDeleteConfirm] = useState(false);\n const [checkedSteps, setCheckedSteps] = useState>(new Set());\n\n if (!recipe) {\n return (\n

❓

Recipe not found

\n \n ← Back to Recipes\n \n

\n );\n }\n\n const handleDelete = async () => {\n try {\n const response = await fetch(`/api/recipes/${recipe.id}`, {\n method: 'DELETE'\n });\n \n const data = await response.json();\n \n if (data.success) {\n onDelete(recipe.id!);\n } else {\n alert('Failed to delete recipe: ' + (data.error || 'Unknown error'));\n }\n } catch (error) {\n alert('Network error while deleting recipe');\n }\n };\n\n const toggleStepCheck = (stepIndex: number) => {\n const newChecked = new Set(checkedSteps);\n if (newChecked.has(stepIndex)) {\n newChecked.delete(stepIndex);\n } else {\n newChecked.add(stepIndex);\n }\n setCheckedSteps(newChecked);\n };\n\n const formatTime = (minutes?: number) => {\n if (!minutes) return '';\n if (minutes < 60) return `${minutes} minutes`;\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n return mins > 0 ? `${hours} hour${hours > 1 ? 's' : ''} ${mins} minutes` : `${hours} hour${hours > 1 ? 's' : ''}`;\n };\n\n const getDifficultyColor = (difficulty?: string) => {\n switch (difficulty) {\n case 'easy': return 'bg-green-100 text-green-800';\n case 'medium': return 'bg-yellow-100 text-yellow-800';\n case 'hard': return 'bg-red-100 text-red-800';\n default: return 'bg-gray-100 text-gray-800';\n }\n };\n\n const adjustIngredientAmount = (amount: string, multiplier: number) => {\n // Try to parse and multiply numeric amounts\n const numMatch = amount.match(/^(\\d+(?:\\.\\d+)?)/);\n if (numMatch) {\n const num = parseFloat(numMatch[1]);\n const adjustedNum = num * multiplier;\n const remainder = amount.replace(numMatch[1], '');\n \n // Format the number nicely\n const formattedNum = adjustedNum % 1 === 0 ? adjustedNum.toString() : adjustedNum.toFixed(2);\n return formattedNum + remainder;\n }\n \n // For fractions or complex amounts, just show original with note\n return multiplier === 1 ? amount : `${amount} (×${multiplier})`;\n };\n\n const formatIngredient = (ingredient: Ingredient, multiplier: number) => {\n const adjustedAmount = adjustIngredientAmount(ingredient.amount, multiplier);\n \n // Check if the amount already contains the unit information\n // This handles cases where AI puts \"4 large slices\" in amount and \"large slices\" in unit\n const amountLower = adjustedAmount.toLowerCase();\n const unitLower = ingredient.unit.toLowerCase();\n \n // If the unit is already contained in the amount, don't repeat it\n if (unitLower && amountLower.includes(unitLower)) {\n return `${adjustedAmount} ${ingredient.name}`;\n }\n \n // If unit is empty or amount is empty, handle gracefully\n if (!ingredient.unit.trim()) {\n return `${adjustedAmount} ${ingredient.name}`;\n }\n \n if (!adjustedAmount.trim()) {\n return `${ingredient.unit} ${ingredient.name}`;\n }\n \n // Normal case: amount + unit + name\n return `${adjustedAmount} ${ingredient.unit} ${ingredient.name}`;\n };\n\n const totalTime = (recipe.prepTime || 0) + (recipe.cookTime || 0);\n\n return (\n

\n {/* Header */}\n

\n \n ← Back to Recipes\n \n \n

\n onEdit(recipe)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-md hover:bg-blue-700 text-sm\"\n >\n ✏️ Edit\n \n setDeleteConfirm(true)}\n className=\"bg-red-600 text-white px-4 py-2 rounded-md hover:bg-red-700 text-sm\"\n >\n 🗑️ Delete\n \n

\n\n

{recipe.title}

\n \n {recipe.description && (\n

{recipe.description}

\n )}\n\n {/* Recipe Meta Info */}\n

\n {recipe.servings && (\n

👥

Servings

{recipe.servings}

\n )}\n \n {recipe.prepTime && (\n

⏱️

Prep Time

{formatTime(recipe.prepTime)}

\n )}\n \n {recipe.cookTime && (\n

🔥

Cook Time

{formatTime(recipe.cookTime)}

\n )}\n \n {totalTime > 0 && (\n

⏰

Total Time

{formatTime(totalTime)}

\n )}\n

\n\n {/* Tags and Difficulty */}\n

\n {recipe.difficulty && (\n \n {recipe.difficulty.charAt(0).toUpperCase() + recipe.difficulty.slice(1)}\n \n )}\n \n {recipe.tags?.map(tag => (\n \n #{tag}\n \n ))}\n

\n\n

\n {/* Ingredients */}\n

🥕 Ingredients

\n \n {recipe.servings && (\n

\n Servings:\n setServingMultiplier(parseFloat(e.target.value))}\n className=\"px-2 py-1 border border-gray-300 rounded text-sm\"\n >\n \n \n \n \n \n \n

\n )}\n

\n\n

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

\n {formatIngredient(ingredient, servingMultiplier)}\n

\n {ingredient.notes && (\n

{ingredient.notes}

\n )}\n

\n ))}\n

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

👩‍🍳 Instructions

\n \n

\n {recipe.steps.map((step, index) => (\n

\n toggleStepCheck(index)}\n className={`mt-1 w-6 h-6 rounded-full border-2 flex items-center justify-center transition-colors ${\n checkedSteps.has(index)\n ? 'bg-green-500 border-green-500 text-white'\n : 'border-gray-300 hover:border-green-400'\n }`}\n >\n {checkedSteps.has(index) && '✓'}\n \n

\n {step}\n

\n ))}\n

\n\n {/* Progress */}\n {checkedSteps.size > 0 && (\n

\n Progress\n \n {checkedSteps.size} of {recipe.steps.length} steps completed\n \n

\n )}\n

\n\n {/* Footer */}\n {recipe.source && (\n

\n Source: {recipe.source}\n

\n )}\n

\n\n {/* Delete Confirmation Modal */}\n {deleteConfirm && (\n

⚠️

Delete Recipe?

\n Are you sure you want to delete \"{recipe.title}\"? This action cannot be undone.\n

\n \n Delete\n \n setDeleteConfirm(false)}\n className=\"flex-1 bg-gray-300 text-gray-700 px-4 py-2 rounded-md hover:bg-gray-400\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[324,331,399],{"_104":407,"_95":408,"_154":409,"_156":332,"_157":139,"_158":410,"_160":161,"_106":411,"_100":412,"_163":226,"_165":413,"_166":22,"_167":-5,"_168":414,"_98":415},"f376a1da-904b-11f0-86b5-0224a6c84d84","ShoppingListCreator.tsx","cedd4f12-4fa1-11f0-99b2-f69ea79377d9",367,["D",1757731632991],6,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Recipe, ShoppingList } from \"../../shared/types.ts\";\n\ninterface ShoppingListCreatorProps {\n recipes: Recipe[];\n onShoppingListCreated: (shoppingList: ShoppingList) => void;\n onCancel: () => void;\n}\n\nexport default function ShoppingListCreator({ recipes, onShoppingListCreated, onCancel }: ShoppingListCreatorProps) {\n const [selectedRecipeIds, setSelectedRecipeIds] = useState([]);\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [searchQuery, setSearchQuery] = useState(\"\");\n\n // Filter recipes based on search query\n const filteredRecipes = recipes.filter(recipe => {\n if (!searchQuery.trim()) return true;\n const query = searchQuery.toLowerCase();\n return (\n recipe.title.toLowerCase().includes(query) ||\n recipe.ingredients.some(ing => ing.name.toLowerCase().includes(query)) ||\n (recipe.tags && recipe.tags.some(tag => tag.toLowerCase().includes(query)))\n );\n });\n\n const handleRecipeToggle = (recipeId: number) => {\n setSelectedRecipeIds(prev => \n prev.includes(recipeId) \n ? prev.filter(id => id !== recipeId)\n : [...prev, recipeId]\n );\n setError(null);\n };\n\n const handleSelectAll = () => {\n const allIds = filteredRecipes.map(r => r.id!).filter(id => id !== undefined);\n setSelectedRecipeIds(allIds);\n };\n\n const handleSelectNone = () => {\n setSelectedRecipeIds([]);\n };\n\n const handleCreateShoppingList = async () => {\n if (selectedRecipeIds.length === 0) {\n setError('Please select at least one recipe');\n return;\n }\n\n setLoading(true);\n setError(null);\n\n try {\n const response = await fetch('/api/shopping-lists', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ recipeIds: selectedRecipeIds }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onShoppingListCreated(data.data);\n } else {\n setError(data.error || 'Failed to create shopping list');\n }\n } catch (error) {\n console.error('Error creating shopping list:', error);\n setError('Network error creating shopping list');\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

Create Shopping List

\n Select recipes to combine their ingredients into a shopping list\n

\n \n ✕\n \n

\n\n

\n {error && (\n

⚠️

Error

{error}

\n )}\n\n

\n setSearchQuery(e.target.value)}\n placeholder=\"Search recipes by name, ingredient, or tag...\"\n className=\"w-full px-4 py-2 pl-10 pr-4 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n />\n

\n \n

\n {searchQuery && (\n setSearchQuery(\"\")}\n className=\"absolute inset-y-0 right-0 flex items-center pr-3 text-gray-400 hover:text-gray-600\"\n >\n \n \n )}\n

\n\n

\n {searchQuery ? (\n <>\n {filteredRecipes.length} recipe{filteredRecipes.length !== 1 ? 's' : ''} found\n {selectedRecipeIds.length > 0 && ` (${selectedRecipeIds.length} selected)`}\n \n ) : (\n `${selectedRecipeIds.length} of ${recipes.length} recipes selected`\n )}\n

\n \n Select All\n \n |\n \n Select None\n \n

\n\n

\n {filteredRecipes.map((recipe) => (\n handleRecipeToggle(recipe.id!)}\n >\n

\n handleRecipeToggle(recipe.id!)}\n className=\"h-4 w-4 text-blue-600 rounded border-gray-300 mr-3\"\n />\n

{recipe.title}

\n 🥘 {recipe.ingredients.length} ingredients\n {recipe.servings && (\n <>\n •\n 👥 {recipe.servings} servings\n \n )}\n {recipe.prepTime && (\n <>\n •\n ⏱️ {recipe.prepTime}min prep\n \n )}\n

\n ))}\n

\n\n {filteredRecipes.length === 0 && (\n

\n {searchQuery ? (\n <>\n

🔍

No recipes found matching \"{searchQuery}\"

Try a different search term or clear the search

\n \n ) : (\n <>\n

📝

No recipes available

Add some recipes first to create a shopping list

\n \n )}\n

\n )}\n

\n\n

\n \n Cancel\n \n \n {loading ? (\n

\n Creating...\n

\n ) : (\n `Create Shopping List (${selectedRecipeIds.length} recipes)`\n )}\n \n

\n \n );\n}",[],[324,331,408],{"_104":417,"_95":418,"_154":419,"_156":332,"_157":139,"_158":340,"_160":161,"_106":420,"_100":176,"_163":226,"_165":421,"_166":22,"_167":-5,"_168":422,"_98":423},"b00951e0-9127-11f0-a29e-0224a6c84d84","ShoppingListList.tsx","f40527e2-4fa1-11f0-9b4c-f69ea79377d9",["D",1757826009148],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { ShoppingList } from \"../../shared/types.ts\";\n\ninterface ShoppingListListProps {\n shoppingLists: ShoppingList[];\n onShoppingListSelect: (shoppingList: ShoppingList) => void;\n onCreateNew: () => void;\n onRefresh: () => void;\n onManageExcluded: () => void;\n}\n\nexport default function ShoppingListList({\n shoppingLists,\n onShoppingListSelect,\n onCreateNew,\n onRefresh,\n onManageExcluded,\n}: ShoppingListListProps) {\n const getListProgress = (list: ShoppingList) => {\n const totalItems = list.items.length;\n const checkedItems = list.items.filter(item => item.checked).length;\n return totalItems > 0 ? (checkedItems / totalItems) * 100 : 0;\n };\n\n return (\n

\n {/* Mobile Header */}\n

Shopping Lists

\n Manage your grocery shopping lists\n

\n \n 🚫\n Excluded Items\n \n \n ➕\n Create New List\n \n

\n\n {/* Desktop Header */}\n

Shopping Lists

\n Manage your grocery shopping lists\n

\n \n 🚫 Excluded Items\n \n \n 🔄 Refresh\n \n \n ➕ Create New List\n \n

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

🛒

No Shopping Lists Yet

\n Create your first shopping list by selecting recipes and combining their ingredients.\n

\n \n Create Your First Shopping List\n \n

\n )\n : (\n

\n {shoppingLists.map((list) => {\n const progress = getListProgress(list);\n const totalItems = list.items.length;\n const checkedItems = list.items.filter(item => item.checked).length;\n\n return (\n onShoppingListSelect(list)}\n className=\"bg-white border border-gray-200 rounded-lg p-4 md:p-6 hover:shadow-md transition-all cursor-pointer hover:border-gray-300 active:scale-95\"\n >\n

\n {list.name}\n

🛒

\n\n

\n {checkedItems} of {totalItems} items\n {Math.round(progress)}%\n

\n \n

\n\n

\n Created {new Date(list.createdAt!).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n timeZone: \"America/New_York\",\n })}\n

\n\n {progress === 100 && (\n

\n ✅ Complete\n

\n )}\n

\n );\n })}\n \n )}\n \n );\n}",[],[324,331,418],{"_104":425,"_95":426,"_154":427,"_156":332,"_157":139,"_158":428,"_160":161,"_106":429,"_100":430,"_163":226,"_165":431,"_166":22,"_167":-5,"_168":432,"_98":433},"25a1380e-94c1-11f0-9e9b-0224a6c84d84","ShoppingListView.tsx","e245458c-4fa1-11f0-b1f9-f69ea79377d9",381,["D",1758221772929],19,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ShoppingList, ShoppingListItem } from \"../../shared/types.ts\";\nimport { formatIngredientAmountUnit } from \"../../shared/utils.ts\";\n\ninterface ShoppingListViewProps {\n shoppingList: ShoppingList;\n onBack: () => void;\n onDelete: (listId: number) => void;\n onUpdate: (updatedList: ShoppingList) => void;\n}\n\n// Category display names and order\nconst CATEGORY_NAMES: Record = {\n 'produce': '🥬 Produce',\n 'cheeses': '🧀 Cheeses',\n 'meats/proteins': '🥩 Meats & Proteins',\n 'freezer': '🧊 Freezer',\n 'breads': '🍞 Breads',\n 'dry goods': '📦 Dry Goods',\n 'dairy': '🥛 Dairy',\n 'other': '🛒 Other'\n};\n\nexport default function ShoppingListView({ shoppingList, onBack, onDelete, onUpdate }: ShoppingListViewProps) {\n const [items, setItems] = useState(shoppingList.items);\n const [loading, setLoading] = useState(false);\n const [editingName, setEditingName] = useState(false);\n const [listName, setListName] = useState(shoppingList.name);\n const [showAddItem, setShowAddItem] = useState(false);\n const [newItemName, setNewItemName] = useState(\"\");\n const [newItemAmount, setNewItemAmount] = useState(\"\");\n const [newItemUnit, setNewItemUnit] = useState(\"\");\n const [newItemNotes, setNewItemNotes] = useState(\"\");\n\n // Group items by category\n const itemsByCategory = items.reduce((acc, item) => {\n const category = item.category || 'other';\n if (!acc[category]) {\n acc[category] = [];\n }\n acc[category].push(item);\n return acc;\n }, {} as Record);\n\n // Get ordered categories (only those with items)\n const orderedCategories = ['produce', 'cheeses', 'meats/proteins', 'freezer', 'breads', 'dry goods', 'dairy', 'other']\n .filter(cat => itemsByCategory[cat] && itemsByCategory[cat].length > 0);\n\n\n\n const handleItemToggle = async (itemId: number, checked: boolean) => {\n setLoading(true);\n try {\n const response = await fetch(`/api/shopping-lists/items/${itemId}`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ checked }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n setItems(prev => prev.map(item => item.id === itemId ? { ...item, checked } : item));\n } else {\n console.error(\"Failed to update item:\", data.error);\n }\n } catch (error) {\n console.error(\"Error updating item:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleItemDelete = async (itemId: number) => {\n if (!confirm(\"Are you sure you want to remove this item from the shopping list?\")) {\n return;\n }\n\n setLoading(true);\n try {\n const response = await fetch(`/api/shopping-lists/items/${itemId}`, {\n method: \"DELETE\",\n });\n\n const data = await response.json();\n\n if (data.success) {\n setItems(prev => prev.filter(item => item.id !== itemId));\n } else {\n console.error(\"Failed to delete item:\", data.error);\n alert(\"Failed to delete item\");\n }\n } catch (error) {\n console.error(\"Error deleting item:\", error);\n alert(\"Error deleting item\");\n } finally {\n setLoading(false);\n }\n };\n\n const handleSaveListName = async () => {\n if (listName.trim() === shoppingList.name) {\n setEditingName(false);\n return;\n }\n\n if (listName.trim().length === 0) {\n setListName(shoppingList.name);\n setEditingName(false);\n return;\n }\n\n setLoading(true);\n try {\n const response = await fetch(`/api/shopping-lists/${shoppingList.id}`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ name: listName.trim() }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onUpdate(data.data);\n setEditingName(false);\n } else {\n console.error(\"Failed to update list name:\", data.error);\n alert(\"Failed to update list name\");\n setListName(shoppingList.name);\n }\n } catch (error) {\n console.error(\"Error updating list name:\", error);\n alert(\"Error updating list name\");\n setListName(shoppingList.name);\n } finally {\n setLoading(false);\n setEditingName(false);\n }\n };\n\n const handleCancelEditName = () => {\n setListName(shoppingList.name);\n setEditingName(false);\n };\n\n const handleDeleteList = async () => {\n if (!confirm(\"Are you sure you want to delete this shopping list?\")) {\n return;\n }\n\n setLoading(true);\n try {\n const response = await fetch(`/api/shopping-lists/${shoppingList.id}`, {\n method: \"DELETE\",\n });\n\n const data = await response.json();\n\n if (data.success) {\n onDelete(shoppingList.id!);\n } else {\n console.error(\"Failed to delete shopping list:\", data.error);\n alert(\"Failed to delete shopping list\");\n }\n } catch (error) {\n console.error(\"Error deleting shopping list:\", error);\n alert(\"Error deleting shopping list\");\n } finally {\n setLoading(false);\n }\n };\n\n const handleAddItem = async () => {\n if (newItemName.trim().length === 0) {\n alert(\"Please enter an item name\");\n return;\n }\n\n setLoading(true);\n try {\n const response = await fetch(`/api/shopping-lists/${shoppingList.id}/items`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n name: newItemName.trim(),\n amount: newItemAmount.trim(),\n unit: newItemUnit.trim(),\n notes: newItemNotes.trim(),\n }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n setItems(prev => [...prev, data.data]);\n // Reset form\n setNewItemName(\"\");\n setNewItemAmount(\"\");\n setNewItemUnit(\"\");\n setNewItemNotes(\"\");\n setShowAddItem(false);\n } else {\n console.error(\"Failed to add item:\", data.error);\n alert(\"Failed to add item\");\n }\n } catch (error) {\n console.error(\"Error adding item:\", error);\n alert(\"Error adding item\");\n } finally {\n setLoading(false);\n }\n };\n\n const handleCancelAddItem = () => {\n setNewItemName(\"\");\n setNewItemAmount(\"\");\n setNewItemUnit(\"\");\n setNewItemNotes(\"\");\n setShowAddItem(false);\n };\n\n const checkedCount = items.filter(item => item.checked).length;\n const totalCount = items.length;\n const progressPercentage = totalCount > 0 ? (checkedCount / totalCount) * 100 : 0;\n\n return (\n

\n {/* Header */}\n

\n \n ← Back to Lists\n \n \n 🗑️ Delete List\n \n

\n\n

\n {editingName\n ? (\n

\n setListName(e.target.value)}\n onKeyDown={(e) => {\n if (e.key === \"Enter\") {\n handleSaveListName();\n } else if (e.key === \"Escape\") {\n handleCancelEditName();\n }\n }}\n className=\"text-2xl font-bold text-gray-900 bg-white border border-gray-300 rounded px-2 py-1 flex-1\"\n disabled={loading}\n autoFocus\n />\n \n ✓ Save\n \n \n ✕ Cancel\n \n

\n )\n : (\n

{listName}

\n setEditingName(true)}\n className=\"text-gray-400 hover:text-gray-600 transition-colors\"\n title=\"Edit list name\"\n >\n ✏️\n \n

\n )}\n

\n Created {new Date(shoppingList.createdAt!).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n timeZone: \"America/New_York\",\n })}\n

\n\n {/* Progress Bar */}\n

\n {checkedCount} of {totalCount} items completed\n {Math.round(progressPercentage)}%\n

\n \n

\n\n {/* Add Item Form */}\n

\n {showAddItem ? (\n

Add New Item

\n \n ✕ Cancel\n \n

\n \n Item Name *\n \n setNewItemName(e.target.value)}\n placeholder=\"e.g., Milk\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={loading}\n autoFocus\n />\n

\n \n Amount\n \n setNewItemAmount(e.target.value)}\n placeholder=\"e.g., 2\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={loading}\n />\n

\n \n Unit\n \n setNewItemUnit(e.target.value)}\n placeholder=\"e.g., gallons\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={loading}\n />\n

\n \n Notes\n \n setNewItemNotes(e.target.value)}\n placeholder=\"e.g., organic preferred\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n disabled={loading}\n />\n

\n \n Cancel\n \n \n Add Item\n \n

\n ) : (\n setShowAddItem(true)}\n className=\"w-full py-3 border-2 border-dashed border-gray-300 rounded-lg text-gray-600 hover:border-gray-400 hover:text-gray-800 transition-colors\"\n >\n + Add Item Manually\n \n )}\n

\n\n {/* Shopping List Items */}\n

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

🛒

No items in this shopping list

\n )\n : (\n

\n {orderedCategories.map((category) => {\n const categoryItems = itemsByCategory[category];\n const categoryCheckedCount = categoryItems.filter(item => item.checked).length;\n const categoryTotal = categoryItems.length;\n \n return (\n

\n {/* Category Header */}\n

\n {CATEGORY_NAMES[category] || category}\n

\n \n {categoryCheckedCount}/{categoryTotal}\n \n

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

\n {categoryItems.map((item) => (\n \n handleItemToggle(item.id!, e.target.checked)}\n disabled={loading}\n className=\"h-5 w-5 text-green-600 rounded border-gray-300 mr-3 disabled:opacity-50\"\n />\n\n

\n {item.name}\n

\n {formatIngredientAmountUnit(item.amount, item.unit)}\n {item.notes && • {item.notes}}\n

\n {item.recipeIds.length > 0 && (\n

\n {shoppingList.recipeToDateMap ? (\n

\n {item.recipeIds.map(recipeId => {\n const dates = shoppingList.recipeToDateMap![recipeId] || [];\n if (dates.length === 0) return null;\n return (\n

\n 📅 {dates.map(date => new Date(date).toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric'\n })).join(', ')}\n

\n );\n })}\n

\n ) : (\n

From {item.recipeIds.length} recipe{item.recipeIds.length > 1 ? \"s\" : \"\"}

\n )}\n

\n \n handleItemDelete(item.id!)}\n disabled={loading}\n className=\"ml-2 p-1 text-red-500 hover:text-red-700 hover:bg-red-50 rounded transition-colors disabled:opacity-50\"\n title=\"Remove item from list\"\n >\n \n \n

\n ))}\n

\n );\n })}\n

\n )}\n

\n\n {/* Summary */}\n {items.length > 0 && (\n

\n Total items: {totalCount}\n

\n {checkedCount === totalCount\n ? ✅ Shopping complete!\n : {totalCount - checkedCount} items remaining}\n

\n )}\n \n \n );\n}",[],[324,331,426],[324,331],{"_104":436,"_95":437,"_154":438,"_156":325,"_157":139,"_158":340,"_160":161,"_106":439,"_100":201,"_163":177,"_165":440,"_166":22,"_167":-5,"_168":441,"_98":442},"b0095816-9127-11f0-a29e-0224a6c84d84","index.html","c0a25fe6-494d-11f0-a1c9-76b3cceeab13",["D",1757826009148],"\n\n\n \n \n Cardamom - Capture, Parse & Store Recipes\n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n",[],[324,437],{"_104":444,"_95":445,"_154":446,"_156":325,"_157":139,"_158":447,"_160":161,"_106":448,"_100":32,"_163":226,"_165":449,"_166":22,"_167":-5,"_168":450,"_98":451},"c4e1ca2e-494d-11f0-a1c9-76b3cceeab13","index.tsx","c4e1caf6-494d-11f0-a1c9-76b3cceeab13",9,["D",1749925881285],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = ReactDOM.createRoot(document.getElementById('root')!);\nroot.render();",[],[324,445],[324],{"_104":454,"_95":455,"_154":456,"_156":-5,"_157":139,"_158":119,"_160":161,"_106":457,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":458,"_98":477},"711995ac-494d-11f0-bc66-76b3cceeab13","shared","17a72b47-8d83-4d42-9c87-58fceff0e9c7",["D",1749925740721],[459,468],{"_104":460,"_95":461,"_154":462,"_156":456,"_157":139,"_158":223,"_160":161,"_106":463,"_100":464,"_163":226,"_165":465,"_166":22,"_167":-5,"_168":466,"_98":467},"9abb33c2-9121-11f0-b677-0224a6c84d84","types.ts","71198cc4-494d-11f0-bc66-76b3cceeab13",["D",1757823396415],7,"// Shared types for the Recipe Parser App\n\nexport interface Ingredient {\n id?: number;\n name: string;\n amount: string;\n unit: string;\n notes?: string;\n}\n\nexport interface Recipe {\n id?: number;\n title: string;\n description?: string;\n ingredients: Ingredient[];\n steps: string[];\n servings?: number;\n prepTime?: number; // in minutes\n cookTime?: number; // in minutes\n difficulty?: 'easy' | 'medium' | 'hard';\n tags?: string[];\n source?: string; // URL or source description\n imageUrl?: string;\n createdAt?: string;\n updatedAt?: string;\n}\n\nexport interface ParseRequest {\n type: 'url' | 'pdf' | 'image';\n content: string; // URL, base64 PDF, or base64 image\n filename?: string;\n}\n\nexport interface ParseResponse {\n success: boolean;\n recipe?: Recipe;\n error?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\nexport interface PaginationInfo {\n page: number;\n limit: number;\n total: number;\n totalPages: number;\n hasNext: boolean;\n hasPrev: boolean;\n}\n\nexport interface PaginatedResponse {\n success: boolean;\n data: T[];\n pagination: PaginationInfo;\n error?: string;\n}\n\nexport interface PaginationParams {\n page?: number;\n limit?: number;\n}\n\nexport interface RecipeFilters {\n search?: string;\n tags?: string[];\n difficulty?: string;\n maxPrepTime?: number;\n maxCookTime?: number;\n}\n\nexport interface ShoppingListItem {\n id?: number;\n shoppingListId: number;\n name: string;\n amount: string;\n unit: string;\n notes?: string;\n checked: boolean;\n recipeIds: number[]; // Track which recipes this ingredient came from\n category?: string; // Category for organizing items (produce, dairy, etc.)\n}\n\nexport interface ShoppingList {\n id?: number;\n name: string;\n createdAt?: string;\n updatedAt?: string;\n items: ShoppingListItem[];\n recipeToDateMap?: Record; // Maps recipe IDs to their planned dates\n}\n\nexport interface CreateShoppingListRequest {\n recipeIds: number[];\n}\n\nexport interface ExcludedIngredient {\n id?: number;\n name: string;\n pattern: string;\n createdAt?: string;\n}\n\n// Meal Planning Types\nexport interface MealPlan {\n id?: number;\n recipeId: number;\n recipe?: Recipe | null; // Populated on fetch, null if recipe was deleted\n date: string; // YYYY-MM-DD\n mealType: 'breakfast-lunch' | 'dinner';\n notes?: string;\n createdAt?: string;\n updatedAt?: string;\n}\n\nexport interface CalendarDay {\n date: string;\n meals: {\n 'breakfast-lunch': MealPlan[]; // Array to support multiple recipes\n dinner: MealPlan[];\n };\n isSelected?: boolean;\n totalRecipeCount: number;\n}\n\nexport interface MealPlanDateRange {\n startDate: string;\n endDate: string;\n}\n\nexport interface CreateMealPlanRequest {\n recipeId: number;\n date: string;\n mealType: 'breakfast-lunch' | 'dinner';\n notes?: string;\n}\n\nexport interface CreateShoppingListFromCalendarRequest {\n startDate?: string;\n endDate?: string;\n dates?: string[];\n}",[],[455,461],{"_104":469,"_95":470,"_154":471,"_156":456,"_157":139,"_158":472,"_160":161,"_106":473,"_100":32,"_163":226,"_165":474,"_166":22,"_167":-5,"_168":475,"_98":476},"c8994a64-516a-11f0-b2f0-f69ea79377d9","utils.ts","c8994af0-516a-11f0-b2f0-f69ea79377d9",188,["D",1750817952229],"// Utility functions for ingredient formatting\n\nexport function formatIngredientDisplay(amount: string, unit: string, name: string): string {\n // Check if the amount already contains the unit information\n // This handles cases where AI puts \"4 large slices\" in amount and \"large slices\" in unit\n const amountLower = amount.toLowerCase();\n const unitLower = unit.toLowerCase();\n \n // If the unit is already contained in the amount, don't repeat it\n if (unitLower && amountLower.includes(unitLower)) {\n return `${amount} ${name}`;\n }\n \n // If unit is empty or amount is empty, handle gracefully\n if (!unit.trim()) {\n return `${amount} ${name}`;\n }\n \n if (!amount.trim()) {\n return `${unit} ${name}`;\n }\n \n // Normal case: amount + unit + name\n return `${amount} ${unit} ${name}`;\n}\n\nexport function formatIngredientAmountUnit(amount: string, unit: string): string {\n // Check if the amount already contains the unit information\n const amountLower = amount.toLowerCase();\n const unitLower = unit.toLowerCase();\n \n // If the unit is already contained in the amount, don't repeat it\n if (unitLower && amountLower.includes(unitLower)) {\n return amount;\n }\n \n // If unit is empty or amount is empty, handle gracefully\n if (!unit.trim()) {\n return amount;\n }\n \n if (!amount.trim()) {\n return unit;\n }\n \n // Normal case: amount + unit\n return `${amount} ${unit}`;\n}",[],[455,470],[455],{"_104":479,"_95":480,"_154":481,"_156":-5,"_157":139,"_158":482,"_160":161,"_106":483,"_100":119,"_163":177,"_165":484,"_166":22,"_167":-5,"_168":485,"_98":486},"ea529bd2-516b-11f0-9844-f69ea79377d9",".vtignore","70205466-499c-11f0-aceb-76b3cceeab13",198,["D",1750818438299],".git\n.vscode\n.cursor\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[],[480],{"_104":488,"_95":489,"_154":490,"_156":-5,"_157":139,"_158":491,"_160":22,"_106":492,"_100":333,"_163":177,"_165":493,"_166":22,"_167":-5,"_168":494,"_98":495},"2b201c2c-8eb9-11f0-8235-0224a6c84d84","CLAUDE.md","c9047c7a-8eb0-11f0-9fbf-0224a6c84d84",313,["D",1757558639200],"# CLAUDE.md\n\nThis file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.\n\n## Project Overview\n\nRecipe Parser & Shopping List App - A Val Town application that captures, parses, stores recipes from multiple sources and generates smart shopping lists.\n\n## Tech Stack\n\n- **Runtime**: Val Town (Deno runtime)\n- **Frontend**: React 18.2.0 with TypeScript, TailwindCSS\n- **Backend**: Hono API framework with TypeScript\n- **Database**: SQLite with normalized schema\n- **AI**: OpenAI GPT-4o-mini for recipe parsing\n\n## Architecture\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema (4 tables)\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── recipes.ts # Recipe CRUD operations\n│ │ ├── parse.ts # Recipe parsing endpoints\n│ │ └── shopping-lists.ts # Shopping list operations\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── RecipeForm.tsx # Recipe input form\n│ │ ├── RecipeList.tsx # Recipe listing\n│ │ ├── RecipeView.tsx # Individual recipe display\n│ │ ├── ShoppingListCreator.tsx # Create shopping lists\n│ │ ├── ShoppingListList.tsx # Shopping list overview\n│ │ └── ShoppingListView.tsx # Interactive shopping list\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n ├── types.ts # Shared TypeScript types\n └── utils.ts # Shared utility functions\n```\n\n## Development Commands\n\nSince this is a Val Town project, there are no traditional build/test commands. Development happens directly in the Val Town environment:\n\n- **Running locally**: Not applicable - code runs in Val Town's cloud environment\n- **Testing**: Use the built-in test endpoints:\n - `GET /api/health` - Health check\n - `GET /api/test-delete` - Test database operations\n - `GET /api/test-transaction` - Test transaction rollback behavior\n - `GET /api/test-ingredients` - Test optimized ingredient updates\n - `GET /api/test-pagination` - Test pagination functionality\n- **Database migrations**: Run automatically on startup via `migrations.ts`\n- **Debugging**: Check Val Town logs for server-side issues, browser console for client-side\n\n## API Endpoints\n\n### Recipe Management\n- `GET /api/recipes` - Get all recipes (supports filtering and pagination)\n - **Filtering**: `?search=pasta&difficulty=easy&maxPrepTime=30`\n - **Pagination**: `?paginated=true&page=1&limit=20`\n - **Combined**: `?search=pasta&page=2&limit=10`\n- `POST /api/recipes` - Save a new recipe\n- `GET /api/recipes/:id` - Get specific recipe\n- `PUT /api/recipes/:id` - Update recipe\n- `DELETE /api/recipes/:id` - Delete recipe\n\n### Recipe Parsing\n- `POST /api/parse/url` - Parse from URL\n- `POST /api/parse/pdf` - Parse from PDF (base64)\n- `POST /api/parse/image` - Parse from image (base64)\n- `POST /api/parse/text` - Parse from text\n\n### Shopping Lists\n- `GET /api/shopping-lists` - Get all lists (supports pagination)\n - **Pagination**: `?paginated=true&page=1&limit=25`\n- `POST /api/shopping-lists` - Create from recipe IDs\n- `GET /api/shopping-lists/:id` - Get specific list\n- `PUT /api/shopping-lists/:id` - Update list name\n- `DELETE /api/shopping-lists/:id` - Delete list\n- `PUT /api/shopping-lists/items/:id` - Toggle item checked\n\n## Key Implementation Details\n\n### Recipe Parsing\n- Uses OpenAI GPT-4o-mini for intelligent extraction\n- Handles fractional Unicode characters (¼, ½, ¾)\n- Robust JSON extraction with fallback parsing\n\n### Shopping List Generation\n- Automatically consolidates duplicate ingredients across recipes\n- Maintains links between shopping list items and source recipes\n- Real-time progress tracking with visual indicators\n\n### Database Transactions\n- Uses Val Town's `sqlite.batch()` method for atomic operations\n- All multi-table operations (recipe creation, updates, shopping list creation) are transactional\n- Automatic rollback on any failure ensures data integrity\n\n### Performance Optimizations\n- N+1 query problem solved with batch fetching for `getAllRecipes()` and `getAllShoppingLists()`\n- Optimized ingredient updates using bulk INSERT instead of individual queries\n- Database initialization re-enabled with proper `CREATE TABLE IF NOT EXISTS` patterns\n- Pagination implemented to prevent memory exhaustion with large datasets\n\n### Pagination System\n- **Default**: 50 items per page, maximum 100 per page\n- **Backward Compatible**: Original non-paginated endpoints still work\n- **Smart Parameters**: Auto-detects pagination intent from query parameters\n- **Efficient Queries**: Uses LIMIT/OFFSET with separate count queries for optimal performance\n\n## Val Town Development Guidelines\n\n### Core Guidelines\n- Provide complete, functional solutions rather than skeleton implementations\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code is getting too complex, refactor it into subcomponents\n\n### Code Standards\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- **Never bake in secrets into the code** - always use environment variables\n- Follow modern ES6+ conventions and functional programming practices\n\n### Val Town Standard Libraries\n\n#### SQLite\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'recipes_v1';\n// Change table name when modifying schema (e.g., _v2, _v3)\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n```\n\n#### OpenAI\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: \"Parse this recipe\" }],\n model: \"gpt-4o-mini\",\n max_tokens: 1000,\n});\n```\n\n#### Blob Storage\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\n```\n\n### Val Town Platform Specifics\n\n#### Import Style\nAll imports use ESM.sh for browser/server compatibility:\n```ts\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n#### Static File Serving\n```ts\n// Use Val Town utility functions, NOT Hono's serveStatic\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#### React Configuration\n- Pin all React dependencies to version 18.2.0\n- Include at the top of React files:\n```tsx\n/** @jsxImportSource https://esm.sh/react@18.2.0 */\n```\n\n#### Error Handling\n```ts\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n```\n\n#### Redirects\n```ts\n// In Hono\nc.redirect('/new-path');\n// Outside Hono\nreturn new Response(null, { status: 302, headers: { Location: \"/new-path\" }});\n```\n\n### Important Don'ts\n- **NEVER** use `import { serveStatic } from 'hono/middleware'`\n- **NEVER** use `import { cors } from \"@hono/cors\"` - Val Town handles CORS automatically\n- **DO NOT** use the Deno KV module for storage\n- **DO NOT** use `alert()`, `prompt()`, or `confirm()` in browser code\n\n### Database Patterns\n- When changing schemas, create new tables (e.g., `recipes_v1` → `recipes_v2`)\n- Run migrations on startup or comment out for performance\n- Always run table creation before querying\n\n### Common Gotchas\n1. **Environment**: Val Town runs on Deno, not Node.js\n2. **Shared code**: Cannot use `Deno` keyword in `shared/` directory\n3. **SQLite**: Limited ALTER TABLE support - create new tables instead\n4. **React**: All dependencies must be pinned to 18.2.0\n5. **Files**: Val Town only supports text files, not binary\n\n### Environment Variables\n- OpenAI API key is automatically provided by Val Town's integration\n- Use `Deno.env.get('keyname')` for custom environment variables\n- Prefer APIs that don't require keys when possible\n\n## Testing Infrastructure\n\n### Test Endpoints\n\n#### `GET /api/test-transaction`\nTests database transaction rollback behavior by:\n- Creating a transaction with an intentional failure (invalid table)\n- Verifying that successful operations are properly rolled back\n- Checking for orphaned data to ensure transaction integrity\n\n**Expected Success Response:**\n```json\n{\n \"success\": true,\n \"message\": \"Transaction rollback working correctly - no orphaned data found\"\n}\n```\n\n#### `GET /api/test-ingredients`\nTests optimized ingredient update performance by:\n- Creating a test recipe with initial ingredients\n- Updating with different ingredients using bulk INSERT pattern\n- Verifying correct ingredient count and data integrity\n- Cleaning up test data automatically\n\n**Expected Success Response:**\n```json\n{\n \"success\": true,\n \"message\": \"Optimized ingredient updates working correctly - bulk INSERT with 3 ingredients\"\n}\n```\n\n#### `GET /api/test-pagination`\nTests pagination functionality by:\n- Creating multiple test recipes\n- Testing page limits and offsets work correctly\n- Verifying no data overlap between pages\n- Testing shopping list pagination\n- Cleaning up test data automatically\n\n**Expected Success Response:**\n```json\n{\n \"success\": true,\n \"message\": \"Pagination working correctly - tested 5 recipes with page limits\"\n}\n```\n\n### Transaction Patterns\n\n#### Using Val Town's Batch Method\n```ts\n// Convert queries to Val Town batch format\nconst batchQueries = queries.map(query => ({\n sql: query.sql,\n args: query.params // Note: 'args' not 'params'\n}));\n\n// Execute as atomic transaction\nconst results = await sqlite.batch(batchQueries);\n```\n\n#### Performance Optimizations\n- **Before**: N+1 queries for ingredient updates (1 DELETE + N INSERTs)\n- **After**: 2 queries total (1 DELETE + 1 bulk INSERT)\n- **Improvement**: ~80% reduction in database operations for typical recipes\n\n#### Pagination Implementation\n```ts\n// Paginated query with count\nconst { page, limit, offset } = validatePaginationParams(pagination);\n\n// Get total count and paginated data in parallel\nconst [countResult, dataResult] = await Promise.all([\n sqlite.execute('SELECT COUNT(*) as total FROM recipes_v1', params),\n sqlite.execute('SELECT * FROM recipes_v1 ORDER BY created_at DESC LIMIT ? OFFSET ?', [...params, limit, offset])\n]);\n\n// Return with pagination metadata\nreturn {\n recipes: processedRecipes,\n paginationInfo: createPaginationInfo(page, limit, total)\n};\n```\n\n**Response Format:**\n```json\n{\n \"success\": true,\n \"data\": [...],\n \"pagination\": {\n \"page\": 1,\n \"limit\": 50,\n \"total\": 150,\n \"totalPages\": 3,\n \"hasNext\": true,\n \"hasPrev\": false\n }\n}\n```\n\n**API Usage:**\n- `GET /api/recipes?paginated=true&page=2&limit=10`\n- `GET /api/recipes?search=pasta&page=1&limit=20`\n- `GET /api/shopping-lists?page=1&limit=25`\n\n## Performance Optimizations\n\n### Ingredient Normalization Cache\nThe shopping list creation process includes intelligent ingredient consolidation that normalizes ingredient names (e.g., \"kosher salt\" → \"salt\", \"fresh basil leaves\" → \"basil\"). To optimize performance, an in-memory cache has been implemented:\n\n**Implementation:**\n```typescript\n// In-memory cache for ingredient name normalization (performance optimization)\nconst normalizationCache = new Map();\n\nfunction normalizeIngredientName(name: string): string {\n // Check cache first for O(1) lookup\n if (normalizationCache.has(name)) {\n return normalizationCache.get(name)!;\n }\n \n // Perform normalization logic (20+ regex operations)\n const result = performNormalization(name);\n \n // Cache the result for future lookups (reduces O(n×m) to O(1) for repeat ingredients)\n normalizationCache.set(name, result);\n \n return result;\n}\n```\n\n**Performance Impact:**\n- **76.7% faster** for ingredient processing with duplicate ingredients\n- **21.4% cache hit rate** in typical usage scenarios \n- Reduces normalization operations from O(n×m) to O(1) for cached ingredients\n- Memory overhead: ~50 bytes per cached ingredient name\n\n**Test Endpoint:** `GET /api/test-normalization-cache`",[],[489],{"_104":497,"_95":498,"_154":499,"_156":-5,"_157":139,"_158":500,"_160":161,"_106":501,"_100":176,"_163":177,"_165":502,"_166":22,"_167":-5,"_168":503,"_98":504},"0b404b1e-516c-11f0-bd59-f69ea79377d9","README.md","6af3e754-494d-11f0-b6e4-76b3cceeab13",199,["D",1750818493546],"# Recipe Parser & Shopping List App\n\nA comprehensive mobile-friendly web application that captures, parses, stores recipes from multiple sources and generates smart shopping lists from your recipe collection.\n\n## Features\n\n### Recipe Management\n- **Multi-source Recipe Input**: Accept recipes from:\n - Web URLs (recipe websites)\n - PDF files\n - Images (photos of recipes)\n - Plain text input\n- **Intelligent Parsing**: Automatically extracts:\n - Dish title and description\n - Ingredients with precise quantities and units\n - Step-by-step cooking instructions\n - Cooking metadata (prep time, cook time, servings, difficulty)\n - Recipe tags and source information\n- **Recipe Storage**: Persistent SQLite storage with full CRUD operations\n- **Recipe Management**: View, edit, delete, and organize saved recipes\n- **Advanced Features**:\n - Recipe filtering and search\n - Fraction-to-decimal conversion for precise measurements\n - Comprehensive error handling and validation\n - Real-time parsing feedback\n\n### Shopping List Management\n- **Smart Shopping List Generation**: Create shopping lists from selected recipes\n- **Ingredient Consolidation**: Automatically combines duplicate ingredients from multiple recipes\n- **Interactive Shopping Experience**:\n - Check/uncheck items as you shop\n - Real-time progress tracking\n - Visual progress bar showing completion percentage\n- **List Management**: \n - Edit shopping list names\n - Delete completed lists\n - View creation timestamps\n- **Ingredient Details**: Shows which recipes each ingredient came from\n- **Mobile-Optimized**: Perfect for grocery shopping on your phone\n\n## Tech Stack\n\n- **Frontend**: React 18.2.0 with TypeScript, TailwindCSS\n- **Backend**: Hono API framework with TypeScript\n- **Database**: SQLite with normalized schema (4 tables: recipes, ingredients, shopping_lists, shopping_list_items)\n- **AI**: OpenAI GPT-4o-mini for intelligent recipe parsing\n- **File Processing**: \n - PDF parsing via `unpdf` library\n - Image OCR via OpenAI Vision API\n - URL content extraction\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema (4 tables)\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── recipes.ts # Recipe CRUD operations\n│ │ ├── parse.ts # Recipe parsing endpoints\n│ │ └── shopping-lists.ts # Shopping list operations\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── RecipeForm.tsx # Recipe input form\n│ │ ├── RecipeList.tsx # Recipe listing\n│ │ ├── RecipeView.tsx # Individual recipe display\n│ │ ├── ShoppingListCreator.tsx # Create shopping lists\n│ │ ├── ShoppingListList.tsx # Shopping list overview\n│ │ └── ShoppingListView.tsx # Interactive shopping list\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n ├── types.ts # Shared TypeScript types\n └── utils.ts # Shared utility functions\n```\n\n## API Endpoints\n\n### Recipe Management\n- `GET /api/recipes` - Get all recipes (supports filtering via query params)\n - `?search=term` - Search in recipe titles and descriptions\n - `?difficulty=easy|medium|hard` - Filter by difficulty\n - `?maxPrepTime=minutes` - Filter by maximum prep time\n - `?maxCookTime=minutes` - Filter by maximum cook time\n - `?tags=tag1,tag2` - Filter by tags\n- `POST /api/recipes` - Save a new recipe\n- `GET /api/recipes/:id` - Get specific recipe by ID\n- `PUT /api/recipes/:id` - Update existing recipe\n- `DELETE /api/recipes/:id` - Delete recipe\n\n### Recipe Parsing\n- `POST /api/parse/url` - Parse recipe from web URL\n- `POST /api/parse/pdf` - Parse recipe from PDF file (base64)\n- `POST /api/parse/image` - Parse recipe from image (base64)\n- `POST /api/parse/text` - Parse recipe from plain text\n\n### Shopping List Management\n- `GET /api/shopping-lists` - Get all shopping lists\n- `POST /api/shopping-lists` - Create shopping list from recipe IDs\n- `GET /api/shopping-lists/:id` - Get specific shopping list\n- `PUT /api/shopping-lists/:id` - Update shopping list name\n- `DELETE /api/shopping-lists/:id` - Delete shopping list\n- `PUT /api/shopping-lists/items/:id` - Update shopping list item (check/uncheck)\n\n### Utility\n- `GET /api/health` - Health check endpoint\n- `GET /api/test-delete` - Test endpoint for debugging delete operations\n\n## Usage\n\n### Recipe Management\n1. **Access the App**: Open the application in your browser\n2. **Add Recipes**: Choose from multiple input methods:\n - **URL**: Paste a recipe website URL\n - **PDF**: Upload a PDF file containing a recipe\n - **Image**: Upload a photo of a recipe\n - **Text**: Paste or type recipe text directly\n3. **Review & Edit**: The AI will parse the recipe automatically - review and edit as needed\n4. **Save**: Add the recipe to your collection\n5. **Manage**: View, search, filter, edit, or delete saved recipes\n\n### Shopping List Workflow\n1. **Select Recipes**: From your recipe collection, choose recipes you want to cook\n2. **Generate List**: Click \"Create Shopping List\" to automatically generate a consolidated shopping list\n3. **Shop Smart**: Use the interactive shopping list on your phone:\n - Check off items as you shop\n - See real-time progress\n - View which recipes each ingredient is for\n4. **Manage Lists**: Edit list names, delete completed lists, track shopping history\n\n## Database Schema\n\nThe app uses a normalized SQLite database with four main tables:\n\n### Recipes Table (`recipes_v1`)\n- `id` - Primary key\n- `title` - Recipe name (required)\n- `description` - Optional description\n- `servings`, `prep_time`, `cook_time` - Numeric metadata\n- `difficulty` - Enum: 'easy', 'medium', 'hard'\n- `tags` - JSON array of tag strings\n- `source` - Source URL or description\n- `image_url` - Optional recipe image URL\n- `steps` - JSON array of cooking steps\n- `created_at`, `updated_at` - Timestamps\n\n### Ingredients Table (`ingredients_v1`)\n- `id` - Primary key\n- `recipe_id` - Foreign key to recipes table\n- `name` - Ingredient name (required)\n- `amount` - Quantity as string (required)\n- `unit` - Measurement unit (required)\n- `notes` - Optional ingredient notes\n- `order_index` - For maintaining ingredient order\n\n### Shopping Lists Table (`shopping_lists_v1`)\n- `id` - Primary key\n- `name` - Shopping list name\n- `created_at`, `updated_at` - Timestamps\n\n### Shopping List Items Table (`shopping_list_items_v1`)\n- `id` - Primary key\n- `shopping_list_id` - Foreign key to shopping lists table\n- `name` - Ingredient name\n- `amount` - Consolidated quantity\n- `unit` - Measurement unit\n- `notes` - Optional notes\n- `checked` - Boolean for shopping progress\n- `recipe_ids` - JSON array tracking source recipes\n- `order_index` - For maintaining item order\n\n## Key Features & Implementation Details\n\n### AI-Powered Recipe Parsing\n- Uses OpenAI GPT-4o-mini for intelligent content extraction\n- Handles fractional Unicode characters (¼, ½, ¾) and converts to decimals\n- Robust JSON extraction with fallback parsing\n- Comprehensive validation and data cleaning\n\n### Smart Shopping List Generation\n- **Ingredient Consolidation**: Automatically combines duplicate ingredients across recipes\n- **Recipe Tracking**: Maintains links between shopping list items and source recipes\n- **Progress Tracking**: Real-time completion percentage and visual progress bars\n- **Mobile-Optimized Interface**: Touch-friendly checkboxes and responsive design\n\n### File Processing\n- **PDF**: Uses `unpdf` library for text extraction\n- **Images**: Leverages OpenAI Vision API for OCR\n- **URLs**: Fetches and parses HTML content\n- **Text**: Direct text processing\n\n### Frontend Architecture\n- Single-page React application with TypeScript\n- Component-based architecture with clear separation of concerns\n- Mobile-first responsive design with TailwindCSS\n- Real-time error handling and loading states\n- Multi-view navigation (recipes, shopping lists, forms)\n\n### Backend Architecture\n- Hono-based REST API with TypeScript\n- Normalized database design with proper foreign key relationships\n- Comprehensive error handling and validation\n- Database migrations with versioned table names\n- Performance optimizations with database indexes\n\n## Development Setup\n\n### Environment Requirements\n- **Platform**: Val Town (Deno runtime)\n- **Node.js APIs**: Not required (uses Deno-compatible libraries)\n- **Environment Variables**: \n - OpenAI API key (automatically provided by Val Town's OpenAI integration)\n\n### Project Configuration\n- **TypeScript**: Configured via `deno.json` with Val Town types\n- **Dependencies**: All imports use ESM.sh for browser/server compatibility\n- **Static Files**: Served via Val Town's utility functions (`serveFile`, `readFile`)\n\n### Development Workflow\n1. **Database Changes**: Update table names (e.g., `_v1` → `_v2`) when modifying schemas\n2. **Testing**: Use built-in test endpoints and browser developer tools\n3. **Debugging**: Check Val Town logs for server-side issues\n4. **Deployment**: Automatic on file save in Val Town environment\n\n## Troubleshooting\n\n### Common Issues\n- **PDF Parsing Fails**: Ensure PDF contains readable text (not scanned images)\n- **Image Upload Issues**: Verify image is properly base64 encoded\n- **Database Errors**: Check if migrations ran successfully on startup\n- **OpenAI Errors**: Verify API quota and model availability\n- **Shopping List Issues**: Ensure recipes have valid ingredients before creating lists\n\n### Debug Endpoints\n- `GET /api/health` - Check if API is responding\n- `GET /api/test-delete` - Test database delete operations\n- Browser console logs for client-side debugging\n- Server logs in Val Town interface for backend issues\n\n## Recent Updates\n\nThis app has evolved from a simple recipe parser to a comprehensive recipe and shopping list management system. The shopping list feature represents a major enhancement that transforms the app from a recipe storage tool into a complete cooking workflow solution.",[],[498],{"_104":506,"_95":507,"_154":508,"_156":-5,"_157":139,"_158":509,"_160":161,"_106":510,"_100":326,"_163":177,"_165":511,"_166":22,"_167":-5,"_168":512,"_98":513},"3b5895a6-8eb9-11f0-82b1-0224a6c84d84","claude-fixes.md","c90a560e-8eb0-11f0-96e2-0224a6c84d84",316,["D",1757558666411],"# Performance & Stability Issues\n\n## ✅ COMPLETED FIXES\n\n### ~~3. Inefficient Recipe Updates~~ ✅ FIXED\n- **Status**: Optimized with bulk INSERT pattern and transactions\n- **Solution**: Replaced N individual INSERT queries with single bulk INSERT\n- **Performance**: ~80% reduction in database operations for ingredient updates\n- **Test**: Available at `GET /api/test-ingredients`\n\n### ~~4. No Database Transactions~~ ✅ FIXED \n- **Status**: Implemented using Val Town's `sqlite.batch()` method\n- **Solution**: All multi-table operations now atomic with automatic rollback\n- **Coverage**: Recipe creation, updates, shopping list creation\n- **Test**: Available at `GET /api/test-transaction`\n\n### ~~5. Complex Ingredient Normalization~~ ✅ FIXED\n- **Status**: Optimized with in-memory caching system\n- **Solution**: Added O(1) cache lookup for repeated ingredient names \n- **Performance**: 76.7% faster processing with 21.4% cache hit rate\n- **Test**: Available at `GET /api/test-normalization-cache`\n\n## REMAINING ISSUES\n\n### 6. Missing Query Optimization (MEDIUM)\n- **Location**: Multiple locations using string concatenation for IN clauses (lines 423, 517, 698, 892, 951)\n- **Issue**: Using string concatenation for IN clause instead of parameterized queries\n- **Impact**: Potential performance issues with query plan caching\n- **Fix**: Use proper parameterized queries or batch operations\n\n### 7. No Connection Pooling/Reuse (LOW-MEDIUM)\n- **Issue**: Each query creates new connection to SQLite\n- **Impact**: Overhead on each query, especially problematic with N+1 queries\n- **Fix**: Implement connection reuse pattern for Val Town SQLite",[],[507],{"_104":515,"_95":516,"_154":517,"_156":-5,"_157":139,"_158":199,"_160":161,"_106":518,"_100":201,"_163":177,"_165":519,"_166":22,"_167":-5,"_168":520,"_98":521},"1528efb4-4fa0-11f0-bdc5-f69ea79377d9","deno.json","70205ab0-499c-11f0-aceb-76b3cceeab13",["D",1750620941670],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\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}",[],[516],{"_104":523,"_95":524,"_154":525,"_156":-5,"_157":139,"_158":223,"_160":161,"_106":526,"_100":119,"_163":177,"_165":527,"_166":22,"_167":-5,"_168":528,"_98":529},"9abb2c9c-9121-11f0-b677-0224a6c84d84","meal-planning-implementation-plan.md","e0d5b7c0-904e-11f0-ad4c-0224a6c84d84",["D",1757823396415],"# Meal Planning Implementation - Status Report\n\n## 🎯 Overview\n**IMPLEMENTED**: Dual-view meal planning system with scrollable daily list (default) and monthly calendar view. Users can plan meals by assigning recipes to specific days and meal types, then generate shopping lists from selected days.\n\n## ✅ COMPLETED FEATURES\n\n### 1. ✅ Database Schema & Migration\n- **`meal_plans_v2`** table created with:\n - `id` (INTEGER PRIMARY KEY)\n - `recipe_id` (INTEGER FK to recipes_v1)\n - `date` (DATE)\n - `meal_type` (TEXT: 'breakfast-lunch', 'dinner')\n - `notes` (TEXT)\n - `created_at` (DATETIME)\n - `updated_at` (DATETIME)\n - **UPDATED**: Simplified to 2 meal types, allows multiple recipes per meal type\n- **Smart Data Migration**: Automatically migrates from v1 to v2, combines breakfast/lunch, skips snacks\n- **Proper Constraints**: Database-level validation for meal types\n\n### 2. ✅ Backend API Implementation\n**Complete REST API** in `/backend/routes/meal-plans.ts`:\n- ✅ `GET /api/meal-plans` - Get meal plans for date range\n - Query params: `startDate`, `endDate`\n - Returns meal plans with LEFT JOIN for deleted recipe handling\n - Efficient date range filtering\n- ✅ `POST /api/meal-plans` - Create meal plan\n - Validates recipe exists before creation\n - Input validation for meal types and date formats\n - Transaction-safe atomic operations\n- ✅ `DELETE /api/meal-plans/:id` - Remove meal plan\n- ✅ `PUT /api/meal-plans/:id` - Update meal plan\n - Change date/meal type with validation\n- ✅ `POST /api/meal-plans/shopping-list` - Generate shopping list from calendar\n - Supports date ranges or specific date arrays\n - Filters out deleted recipes automatically\n - Reuses existing shopping list creation logic\n\n### 3. ✅ Frontend Components Implementation\n\n#### ✅ New Components Created:\n- **`MealPlanCalendar.tsx`** - Dual-view meal planning interface\n - ✅ **Default List View**: Scrollable daily cards showing planned meals\n - ✅ **Calendar View**: Full monthly grid with day selection\n - ✅ **View Switcher**: Toggle between \"📝 List\" and \"📅 Calendar\"\n - ✅ **Shopping List Integration**: Multi-day selection for list creation\n - ✅ **Mobile-responsive**: Adaptive layouts for both views\n\n- **`DayMealPlan.tsx`** - Detailed day meal editor\n - ✅ **Modal Interface**: Full-screen day planning modal\n - ✅ **Meal Type Sections**: \"Breakfast & Lunch\" and \"Dinner\"\n - ✅ **Multiple Recipes**: Support for multiple recipes per meal type\n - ✅ **Recipe Management**: Add/remove individual recipes\n - ✅ **Deleted Recipe Handling**: Warning display for deleted recipes\n - ✅ **Ingredient Count**: Total ingredients calculation\n\n- **`MealPlanSidebar.tsx`** - Recipe selection interface\n - ✅ **Smart Filtering**: Search, tags, difficulty, prep time filters\n - ✅ **Recipe Metadata**: Prep time, difficulty, tags display\n - ✅ **Simple Success Feedback**: Auto-close on successful add\n - ✅ **Error Handling**: Clear error messages and validation\n - ✅ **Mobile Overlay**: Full-screen sidebar on mobile\n\n#### ✅ Modified Components:\n- **`App.tsx`** - Added 'meal-calendar' view and navigation button\n- **Type System** - Updated `shared/types.ts` with meal planning interfaces\n\n### 4. ✅ User Interface Implementation\n\n#### ✅ List View (Default):\n- **Daily Cards**: Clean cards for each day with meal plans\n- **Color Coding**: Orange for \"Breakfast & Lunch\", Purple for \"Dinner\"\n- **Today Highlighting**: Blue accent for current day\n- **Recipe Details**: Prep time, difficulty badges, deleted recipe warnings\n- **Empty States**: Engaging empty state with call-to-action\n\n#### ✅ Calendar View:\n```\n┌─────────────────────────────────────────────────┐\n│ 📝 List | 📅 Calendar [Create List] │\n├─────────────────────────────────────────────────┤\n│ Sun │ Mon │ Tue │ Wed │ Thu │ Fri │ Sat │ │\n├─────┼─────┼─────┼─────┼─────┼─────┼─────┤ │\n│ 1 │ 2 │ 3 │ 4 │ 5 │ 6 │ 7 │ │\n│B&L:2│B&L:-│B&L:1│B&L:3│B&L:-│B&L:-│B&L:1│ │\n│ D:3 │ D:1 │ D:2 │ D:- │ D:2 │ D:1 │ D:2 │ │\n├─────┼─────┼─────┼─────┼─────┼─────┼─────┤ │\n│ 8 │ 9 │ ... │ │ │\n└─────┴─────┴─────┴─────────────────────────┘\n\nLegend: B&L=Breakfast & Lunch, D=Dinner\n```\n\n#### ✅ Mobile Responsiveness:\n- **Responsive Grids**: CSS Grid adapts to screen size\n- **Touch-Friendly**: 44px minimum touch targets\n- **Modal Interfaces**: Full-screen modals for editing\n- **Stackable Views**: List view naturally stacks on mobile\n\n## 🎯 IMPLEMENTATION PHASES\n\n### ✅ Phase 1: Database & Backend (COMPLETED)\n1. ✅ **Database Migration**: Created `meal_plans_v2` with smart v1→v2 migration\n2. ✅ **Database Queries**: All CRUD operations with transaction safety\n3. ✅ **API Routes**: Complete REST API with validation and error handling\n4. ✅ **Backend Integration**: Added to main app routes\n\n### ✅ Phase 2: Calendar Components (COMPLETED)\n1. ✅ **MealPlanCalendar**: Dual-view interface with list/calendar toggle\n2. ✅ **Day Navigation**: Month navigation and day selection\n3. ✅ **Meal Display**: Recipe counts and meal type indicators\n4. ✅ **Responsive Design**: Mobile-first CSS Grid layouts\n\n### ✅ Phase 3: Recipe Assignment (COMPLETED)\n1. ✅ **MealPlanSidebar**: Advanced recipe selection with filtering\n2. ✅ **Success Feedback**: Auto-close sidebar on successful add\n3. ✅ **DayMealPlan**: Detailed day editing with meal type sections\n4. ✅ **Multiple Recipes**: Full support for multiple recipes per meal type\n\n### ✅ Phase 4: Shopping List Integration (COMPLETED)\n1. ✅ **Selection Mode**: Multi-day selection in both list and calendar views\n2. ✅ **Shopping List Generation**: Direct integration with existing system\n3. ✅ **Transaction Safety**: Atomic operations with deleted recipe filtering\n4. ✅ **User Experience**: Seamless flow from planning to shopping\n\n### ✅ Phase 5: Mobile & Polish (COMPLETED)\n1. ✅ **Mobile Optimization**: Touch-friendly interactions and responsive design\n2. ✅ **User Feedback**: Simplified success indication and error handling\n3. ✅ **Data Integrity**: Comprehensive deleted recipe handling\n4. ✅ **Performance**: Efficient data loading for both view types\n\n---\n\n## 🚀 WHAT'S NEXT (Future Enhancements)\n\nThe core meal planning system is **COMPLETE** and fully functional. Potential future enhancements:\n\n### 🔮 Possible Future Features\n\n#### Advanced Planning Features\n- **📅 Meal Plan Templates**: Save and reuse weekly meal plans\n- **🍽️ Serving Size Adjustments**: Modify recipe servings when adding to meal plans\n- **📝 Meal Notes**: Add custom notes to individual meal plans\n- **🔄 Copy Previous Week**: Quickly duplicate successful meal plans\n- **📊 Nutritional Overview**: Daily/weekly nutritional summaries\n\n#### Enhanced User Experience\n- **⭐ Recipe Suggestions**: AI-powered meal recommendations based on preferences\n- **🏷️ Meal Plan Tags**: Organize meal plans with custom tags (e.g., \"Date Night\", \"Meal Prep\")\n- **📱 Progressive Web App**: Offline support for grocery shopping\n- **🔔 Meal Prep Reminders**: Notifications for prep and cooking times\n- **📸 Meal Photos**: Add photos of completed meals\n\n#### Integration Improvements\n- **🛒 Advanced Shopping Lists**: Group by store sections, estimated costs\n- **📊 Recipe Analytics**: Track most-used recipes, cooking frequency\n- **👥 Family Profiles**: Multiple meal preferences and dietary restrictions\n- **📱 Mobile App**: Native mobile apps for iOS/Android\n\n---\n\n## ✨ SUMMARY\n\n**MEAL PLANNING IS FULLY IMPLEMENTED** with:\n\n- ✅ **Complete Backend**: Database, API, migrations, transaction safety\n- ✅ **Dual-View Interface**: List view (default) + Calendar view\n- ✅ **Full CRUD Operations**: Add, edit, delete meal plans\n- ✅ **Shopping List Integration**: Generate lists from selected days\n- ✅ **Mobile Responsive**: Touch-friendly, adaptive layouts\n- ✅ **Data Integrity**: Handles deleted recipes gracefully\n- ✅ **User-Friendly**: Simple success feedback, clear navigation\n\nThe system is **production-ready** and provides a comprehensive meal planning experience that integrates seamlessly with the existing recipe management and shopping list features. 🎉",[],[524],{"_104":531,"_95":532,"_154":533,"_156":-5,"_157":139,"_158":534,"_160":161,"_106":535,"_100":32,"_163":226,"_165":536,"_166":22,"_167":-5,"_168":537,"_98":538},"0be95d00-8eb9-11f0-9081-0224a6c84d84","test-normalization-cache.ts","0be95da0-8eb9-11f0-9081-0224a6c84d84",311,["D",1757558586835],"// Simple test to demonstrate ingredient normalization cache performance\n// Run with: deno run test-normalization-cache.ts\n\nfunction testIngredientNormalizationCache(): {\n message: string;\n metrics: {\n withoutCache: { time: number; normalizations: number };\n withCache: { time: number; normalizations: number; cacheHitRate: number };\n performanceImprovement: string;\n };\n} {\n // Create test ingredient names with realistic duplicates\n const testIngredients = [\n 'fresh basil leaves', 'dried basil', 'basil leaves',\n 'kosher salt', 'sea salt', 'table salt', 'flaky salt',\n 'extra-virgin olive oil', 'olive oil, extra-virgin', 'olive oil',\n 'large yellow onion', 'medium yellow onion', 'yellow onion',\n 'freshly ground black pepper', 'ground black pepper', 'black pepper',\n 'unsalted butter', 'salted butter', 'butter',\n 'all-purpose flour', 'plain flour', 'flour',\n // Add duplicates to test cache effectiveness\n 'fresh basil leaves', 'kosher salt', 'extra-virgin olive oil',\n 'large yellow onion', 'freshly ground black pepper', 'unsalted butter'\n ];\n\n // Test without cache (simulate original function)\n let normalizationCount = 0;\n function normalizeWithoutCache(name: string): string {\n normalizationCount++;\n const normalized = name.toLowerCase().trim();\n \n const cleanName = normalized\n .replace(/\\b(large|medium|small|extra-large|jumbo)\\b/g, '')\n .replace(/\\b(fresh|dried|frozen|canned|chopped|diced|sliced|minced|grated|shredded)\\b/g, '')\n .replace(/\\b(whole|ground|crushed|flaked|powdered)\\b/g, '')\n .replace(/\\bparsley sprigs?\\b/g, 'parsley')\n .replace(/\\bcilantro sprigs?\\b/g, 'cilantro')\n .replace(/\\bbasil leaves?\\b/g, 'basil')\n .replace(/\\bextra-virgin olive oil\\b/g, 'olive oil')\n .replace(/\\bolive oil, extra-virgin\\b/g, 'olive oil')\n .replace(/\\bkosher salt\\b/g, 'salt')\n .replace(/\\bsea salt\\b/g, 'salt')\n .replace(/\\btable salt\\b/g, 'salt')\n .replace(/\\bflaky salt\\b/g, 'salt')\n .replace(/\\bflaky sea salt\\b/g, 'salt')\n .replace(/\\bfreshly ground black pepper\\b/g, 'black pepper')\n .replace(/\\bground black pepper\\b/g, 'black pepper')\n .replace(/\\bblack peppercorns?\\b/g, 'black pepper')\n .replace(/\\bunsalted butter\\b/g, 'butter')\n .replace(/\\bsalted butter\\b/g, 'butter')\n .replace(/\\ball-purpose flour\\b/g, 'flour')\n .replace(/\\bplain flour\\b/g, 'flour')\n .replace(/\\s+/g, ' ')\n .trim();\n \n return cleanName || normalized;\n }\n\n const startTimeWithoutCache = performance.now();\n testIngredients.forEach(normalizeWithoutCache);\n const timeWithoutCache = performance.now() - startTimeWithoutCache;\n\n // Test with cache\n const cache = new Map();\n let cacheHits = 0;\n let cachedNormalizationCount = 0;\n\n function normalizeWithCache(name: string): string {\n if (cache.has(name)) {\n cacheHits++;\n return cache.get(name)!;\n }\n \n cachedNormalizationCount++;\n const normalized = name.toLowerCase().trim();\n \n const cleanName = normalized\n .replace(/\\b(large|medium|small|extra-large|jumbo)\\b/g, '')\n .replace(/\\b(fresh|dried|frozen|canned|chopped|diced|sliced|minced|grated|shredded)\\b/g, '')\n .replace(/\\b(whole|ground|crushed|flaked|powdered)\\b/g, '')\n .replace(/\\bparsley sprigs?\\b/g, 'parsley')\n .replace(/\\bcilantro sprigs?\\b/g, 'cilantro')\n .replace(/\\bbasil leaves?\\b/g, 'basil')\n .replace(/\\bextra-virgin olive oil\\b/g, 'olive oil')\n .replace(/\\bolive oil, extra-virgin\\b/g, 'olive oil')\n .replace(/\\bkosher salt\\b/g, 'salt')\n .replace(/\\bsea salt\\b/g, 'salt')\n .replace(/\\btable salt\\b/g, 'salt')\n .replace(/\\bflaky salt\\b/g, 'salt')\n .replace(/\\bflaky sea salt\\b/g, 'salt')\n .replace(/\\bfreshly ground black pepper\\b/g, 'black pepper')\n .replace(/\\bground black pepper\\b/g, 'black pepper')\n .replace(/\\bblack peppercorns?\\b/g, 'black pepper')\n .replace(/\\bunsalted butter\\b/g, 'butter')\n .replace(/\\bsalted butter\\b/g, 'butter')\n .replace(/\\ball-purpose flour\\b/g, 'flour')\n .replace(/\\bplain flour\\b/g, 'flour')\n .replace(/\\s+/g, ' ')\n .trim();\n \n const result = cleanName || normalized;\n cache.set(name, result);\n return result;\n }\n\n const startTimeWithCache = performance.now();\n testIngredients.forEach(normalizeWithCache);\n const timeWithCache = performance.now() - startTimeWithCache;\n\n const cacheHitRate = (cacheHits / testIngredients.length) * 100;\n const improvementPercentage = ((timeWithoutCache - timeWithCache) / timeWithoutCache * 100).toFixed(1);\n\n return {\n message: 'Ingredient normalization cache performance test completed',\n metrics: {\n withoutCache: {\n time: Math.round(timeWithoutCache * 1000) / 1000, // Round to 3 decimal places\n normalizations: normalizationCount\n },\n withCache: {\n time: Math.round(timeWithCache * 1000) / 1000,\n normalizations: cachedNormalizationCount,\n cacheHitRate: Math.round(cacheHitRate * 100) / 100\n },\n performanceImprovement: `${improvementPercentage}% faster with cache`\n }\n };\n}\n\n// Run the test\nconst result = testIngredientNormalizationCache();\nconsole.log(JSON.stringify(result, null, 2));",[],[532],{"_104":540,"_95":541,"_154":542,"_156":-5,"_157":139,"_158":543,"_160":22,"_106":544,"_100":545,"_163":177,"_165":546,"_166":22,"_167":-5,"_168":547,"_98":548},"2ed0cefe-9128-11f0-9cd9-0224a6c84d84","todo.md","d9498dc4-523c-11f0-a9d4-f69ea79377d9",375,["D",1757826221853],12,"add manual ingredients to list save images and pdfs that are being parsed adjust\nprompt to handle separate ingredient lists for multipart cooks? user onboarding\nguide",[],[541],"files",[151,170,182,189,195,207,213,219,230,241,247,256,264,274,283,294,301,311,322,329,336,346,354,363,371,379,388,397,406,416,424,435,443,453,459,468,478,487,496,505,514,522,530,539],"counts",{"_553":32,"_554":119,"_555":32,"_556":557},"pulls","branches","forks","envVars",{"_558":32,"_559":32},"count","emptyCount","contents",[562,565,568,571],{"_104":214,"_95":215,"_154":216,"_156":209,"_157":139,"_158":210,"_160":161,"_106":563,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":564},["D",1749925751642],[99,215],{"_104":242,"_95":243,"_154":244,"_156":209,"_157":139,"_158":176,"_160":161,"_106":566,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":567},["D",1749925816509],[99,243],{"_104":295,"_95":296,"_154":297,"_156":209,"_157":139,"_158":298,"_160":161,"_106":569,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":570},["D",1757707106077],[99,296],{"_104":312,"_95":313,"_154":314,"_156":209,"_157":139,"_158":101,"_160":22,"_106":572,"_100":316,"_163":317,"_165":318,"_166":22,"_167":96,"_98":573},["D",1758221833259],[99,313],{"_104":208,"_95":99,"_154":209,"_156":-5,"_157":139,"_158":210,"_160":161,"_106":575,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":576},["D",1749925751642],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":585,"_149":590,"_549":723,"_177":724,"_560":726,"_735":-5,"_736":22,"_737":-5,"_738":-5,"_739":-5,"_740":741},{"_104":105,"_95":96,"_106":586,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":587,"_133":588,"_136":589,"_148":22},["D",1749925632351],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[591,597,606,645,690,699,702,705,708,711,714,717,720],{"_104":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_106":162,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":592,"_98":596},[593],{"_104":171,"_95":172,"_154":173,"_156":155,"_157":139,"_158":174,"_160":161,"_106":175,"_100":176,"_163":177,"_165":178,"_166":22,"_167":-5,"_168":594,"_98":595},[],[153,172],[153],{"_104":183,"_95":184,"_154":185,"_156":-5,"_157":139,"_158":186,"_160":161,"_106":187,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":598,"_98":605},[599],{"_104":190,"_95":191,"_154":192,"_156":185,"_157":139,"_158":186,"_160":161,"_106":193,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":600,"_98":604},[601],{"_104":196,"_95":197,"_154":198,"_156":192,"_157":139,"_158":199,"_160":161,"_106":200,"_100":201,"_163":177,"_165":202,"_166":22,"_167":-5,"_168":602,"_98":603},[],[184,191,197],[184,191],[184],{"_104":208,"_95":99,"_154":209,"_156":-5,"_157":139,"_158":210,"_160":161,"_106":211,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":607,"_98":644},[608,617,635,641],{"_104":214,"_95":215,"_154":216,"_156":209,"_157":139,"_158":210,"_160":161,"_106":217,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":609,"_98":616},[610,613],{"_104":220,"_95":221,"_154":222,"_156":216,"_157":139,"_158":223,"_160":161,"_106":224,"_100":225,"_163":226,"_165":227,"_166":22,"_167":-5,"_168":611,"_98":612},[],[99,215,221],{"_104":231,"_95":232,"_154":233,"_156":216,"_157":139,"_158":234,"_160":161,"_106":235,"_100":236,"_163":226,"_165":237,"_166":22,"_167":-5,"_168":614,"_98":615},[],[99,215,232],[99,215],{"_104":242,"_95":243,"_154":244,"_156":209,"_157":139,"_158":176,"_160":161,"_106":245,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":618,"_98":634},[619,622,625,628,631],{"_104":248,"_95":249,"_154":250,"_156":244,"_157":139,"_158":251,"_160":161,"_106":252,"_100":32,"_163":226,"_165":253,"_166":22,"_167":-5,"_168":620,"_98":621},[],[99,243,249],{"_104":257,"_95":258,"_154":259,"_156":244,"_157":139,"_158":223,"_160":161,"_106":260,"_100":32,"_163":226,"_165":261,"_166":22,"_167":-5,"_168":623,"_98":624},[],[99,243,258],{"_104":265,"_95":266,"_154":267,"_156":244,"_157":139,"_158":268,"_160":161,"_106":269,"_100":270,"_163":226,"_165":271,"_166":22,"_167":-5,"_168":626,"_98":627},[],[99,243,266],{"_104":275,"_95":276,"_154":277,"_156":244,"_157":139,"_158":278,"_160":161,"_106":279,"_100":119,"_163":226,"_165":280,"_166":22,"_167":-5,"_168":629,"_98":630},[],[99,243,276],{"_104":284,"_95":285,"_154":286,"_156":244,"_157":139,"_158":287,"_160":161,"_106":288,"_100":289,"_163":226,"_165":290,"_166":22,"_167":-5,"_168":632,"_98":633},[],[99,243,285],[99,243],{"_104":295,"_95":296,"_154":297,"_156":209,"_157":139,"_158":298,"_160":161,"_106":299,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":636,"_98":640},[637],{"_104":302,"_95":303,"_154":304,"_156":297,"_157":139,"_158":305,"_160":161,"_106":306,"_100":32,"_163":226,"_165":307,"_166":22,"_167":-5,"_168":638,"_98":639},[],[99,296,303],[99,296],{"_104":312,"_95":313,"_154":314,"_156":209,"_157":139,"_158":101,"_160":22,"_106":315,"_100":316,"_163":317,"_165":318,"_166":22,"_167":96,"_168":642,"_98":643},[],[99,313],[99],{"_104":323,"_95":324,"_154":325,"_156":-5,"_157":139,"_158":326,"_160":161,"_106":327,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":646,"_98":689},[647,683,686],{"_104":330,"_95":331,"_154":332,"_156":325,"_157":139,"_158":333,"_160":161,"_106":334,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":648,"_98":682},[649,652,655,658,661,664,667,670,673,676,679],{"_104":337,"_95":338,"_154":339,"_156":332,"_157":139,"_158":340,"_160":22,"_106":341,"_100":342,"_163":226,"_165":343,"_166":22,"_167":-5,"_168":650,"_98":651},[],[324,331,338],{"_104":347,"_95":348,"_154":349,"_156":332,"_157":139,"_158":223,"_160":161,"_106":350,"_100":32,"_163":226,"_165":351,"_166":22,"_167":-5,"_168":653,"_98":654},[],[324,331,348],{"_104":355,"_95":356,"_154":357,"_156":332,"_157":139,"_158":358,"_160":161,"_106":359,"_100":32,"_163":226,"_165":360,"_166":22,"_167":-5,"_168":656,"_98":657},[],[324,331,356],{"_104":364,"_95":365,"_154":366,"_156":332,"_157":139,"_158":340,"_160":161,"_106":367,"_100":201,"_163":226,"_165":368,"_166":22,"_167":-5,"_168":659,"_98":660},[],[324,331,365],{"_104":372,"_95":373,"_154":374,"_156":332,"_157":139,"_158":223,"_160":161,"_106":375,"_100":32,"_163":226,"_165":376,"_166":22,"_167":-5,"_168":662,"_98":663},[],[324,331,373],{"_104":380,"_95":381,"_154":382,"_156":332,"_157":139,"_158":340,"_160":161,"_106":383,"_100":384,"_163":226,"_165":385,"_166":22,"_167":-5,"_168":665,"_98":666},[],[324,331,381],{"_104":389,"_95":390,"_154":391,"_156":332,"_157":139,"_158":392,"_160":22,"_106":393,"_100":270,"_163":226,"_165":394,"_166":22,"_167":-5,"_168":668,"_98":669},[],[324,331,390],{"_104":398,"_95":399,"_154":400,"_156":332,"_157":139,"_158":401,"_160":161,"_106":402,"_100":326,"_163":226,"_165":403,"_166":22,"_167":-5,"_168":671,"_98":672},[],[324,331,399],{"_104":407,"_95":408,"_154":409,"_156":332,"_157":139,"_158":410,"_160":161,"_106":411,"_100":412,"_163":226,"_165":413,"_166":22,"_167":-5,"_168":674,"_98":675},[],[324,331,408],{"_104":417,"_95":418,"_154":419,"_156":332,"_157":139,"_158":340,"_160":161,"_106":420,"_100":176,"_163":226,"_165":421,"_166":22,"_167":-5,"_168":677,"_98":678},[],[324,331,418],{"_104":425,"_95":426,"_154":427,"_156":332,"_157":139,"_158":428,"_160":161,"_106":429,"_100":430,"_163":226,"_165":431,"_166":22,"_167":-5,"_168":680,"_98":681},[],[324,331,426],[324,331],{"_104":436,"_95":437,"_154":438,"_156":325,"_157":139,"_158":340,"_160":161,"_106":439,"_100":201,"_163":177,"_165":440,"_166":22,"_167":-5,"_168":684,"_98":685},[],[324,437],{"_104":444,"_95":445,"_154":446,"_156":325,"_157":139,"_158":447,"_160":161,"_106":448,"_100":32,"_163":226,"_165":449,"_166":22,"_167":-5,"_168":687,"_98":688},[],[324,445],[324],{"_104":454,"_95":455,"_154":456,"_156":-5,"_157":139,"_158":119,"_160":161,"_106":457,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":691,"_98":698},[692,695],{"_104":460,"_95":461,"_154":462,"_156":456,"_157":139,"_158":223,"_160":161,"_106":463,"_100":464,"_163":226,"_165":465,"_166":22,"_167":-5,"_168":693,"_98":694},[],[455,461],{"_104":469,"_95":470,"_154":471,"_156":456,"_157":139,"_158":472,"_160":161,"_106":473,"_100":32,"_163":226,"_165":474,"_166":22,"_167":-5,"_168":696,"_98":697},[],[455,470],[455],{"_104":479,"_95":480,"_154":481,"_156":-5,"_157":139,"_158":482,"_160":161,"_106":483,"_100":119,"_163":177,"_165":484,"_166":22,"_167":-5,"_168":700,"_98":701},[],[480],{"_104":488,"_95":489,"_154":490,"_156":-5,"_157":139,"_158":491,"_160":22,"_106":492,"_100":333,"_163":177,"_165":493,"_166":22,"_167":-5,"_168":703,"_98":704},[],[489],{"_104":497,"_95":498,"_154":499,"_156":-5,"_157":139,"_158":500,"_160":161,"_106":501,"_100":176,"_163":177,"_165":502,"_166":22,"_167":-5,"_168":706,"_98":707},[],[498],{"_104":506,"_95":507,"_154":508,"_156":-5,"_157":139,"_158":509,"_160":161,"_106":510,"_100":326,"_163":177,"_165":511,"_166":22,"_167":-5,"_168":709,"_98":710},[],[507],{"_104":515,"_95":516,"_154":517,"_156":-5,"_157":139,"_158":199,"_160":161,"_106":518,"_100":201,"_163":177,"_165":519,"_166":22,"_167":-5,"_168":712,"_98":713},[],[516],{"_104":523,"_95":524,"_154":525,"_156":-5,"_157":139,"_158":223,"_160":161,"_106":526,"_100":119,"_163":177,"_165":527,"_166":22,"_167":-5,"_168":715,"_98":716},[],[524],{"_104":531,"_95":532,"_154":533,"_156":-5,"_157":139,"_158":534,"_160":161,"_106":535,"_100":32,"_163":226,"_165":536,"_166":22,"_167":-5,"_168":718,"_98":719},[],[532],{"_104":540,"_95":541,"_154":542,"_156":-5,"_157":139,"_158":543,"_160":22,"_106":544,"_100":545,"_163":177,"_165":546,"_166":22,"_167":-5,"_168":721,"_98":722},[],[541],[591,593,597,599,601,606,608,610,613,617,619,622,625,628,631,635,637,641,645,647,649,652,655,658,661,664,667,670,673,676,679,683,686,690,692,695,699,702,705,708,711,714,717,720],{"_104":208,"_95":99,"_154":209,"_156":-5,"_157":139,"_158":210,"_160":161,"_106":575,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":725},[99],[727,729,731,733],{"_104":214,"_95":215,"_154":216,"_156":209,"_157":139,"_158":210,"_160":161,"_106":563,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":728},[99,215],{"_104":242,"_95":243,"_154":244,"_156":209,"_157":139,"_158":176,"_160":161,"_106":566,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":730},[99,243],{"_104":295,"_95":296,"_154":297,"_156":209,"_157":139,"_158":298,"_160":161,"_106":569,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":732},[99,296],{"_104":312,"_95":313,"_154":314,"_156":209,"_157":139,"_158":101,"_160":22,"_106":572,"_100":316,"_163":317,"_165":318,"_166":22,"_167":96,"_98":734},[99,313],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]

connnolly

cardamom