[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_497":498,"_499":500},"routes/_app.x.$handle.$name",{"_98":97,"_32":46,"_106":88,"_27":54,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":60,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",166,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/database/migrations.ts","latestPath","fileId","b92d14ae-d3a9-11f0-9955-42dde27851f2","name","migrations.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - versioned for schema changes\nexport const USERS_TABLE = 'carmy_users_v1';\nexport const SESSIONS_TABLE = 'carmy_sessions_v1';\nexport const RECIPES_TABLE = 'carmy_recipes_v1';\nexport const RECIPE_INGREDIENTS_TABLE = 'carmy_recipe_ingredients_v3'; // v3: added FDC linking\nexport const RECIPE_NUTRITION_TABLE = 'carmy_recipe_nutrition_v2'; // v2: extended micronutrients\nexport const FDC_FOODS_CACHE_TABLE = 'carmy_fdc_foods_cache_v1'; // Cache for USDA FDC food data\nexport const GROCERY_LISTS_TABLE = 'carmy_grocery_lists_v1';\nexport const GROCERY_LIST_ITEMS_TABLE = 'carmy_grocery_list_items_v1';\nexport const NUTRITION_GOALS_TABLE = 'carmy_nutrition_goals_v1';\nexport const MEAL_PLANS_TABLE = 'carmy_meal_plans_v1';\nexport const MEAL_PLAN_ENTRIES_TABLE = 'carmy_meal_plan_entries_v2'; // v2: support custom foods and FDC ingredients\nexport const SCRAPER_EVAL_URLS_TABLE = 'carmy_scraper_eval_urls_v1';\nexport const STARRED_INGREDIENTS_TABLE = 'carmy_starred_ingredients_v1';\nexport const CUSTOM_FOODS_TABLE = 'carmy_custom_foods_v1';\n\nexport async function runMigrations() {\n // Users table (Google OAuth)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL UNIQUE,\n name TEXT,\n picture TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Sessions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SESSIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n expires_at TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SESSIONS_TABLE}_user_id \n ON ${SESSIONS_TABLE}(user_id)\n `);\n\n // Recipes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n title TEXT NOT NULL,\n url TEXT,\n instructions TEXT,\n serving_size INTEGER NOT NULL DEFAULT 1,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPES_TABLE}_user_id \n ON ${RECIPES_TABLE}(user_id)\n `);\n\n // Recipe ingredients table (v3: with FDC linking)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL,\n name TEXT NOT NULL,\n amount REAL,\n unit TEXT,\n amount_grams REAL,\n notes TEXT,\n order_index INTEGER NOT NULL DEFAULT 0,\n fdc_id INTEGER,\n fdc_description TEXT,\n fdc_data_type TEXT,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPE_INGREDIENTS_TABLE}_recipe_id \n ON ${RECIPE_INGREDIENTS_TABLE}(recipe_id)\n `);\n\n // FDC foods cache table - cache USDA FDC food data to reduce API calls\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FDC_FOODS_CACHE_TABLE} (\n fdc_id INTEGER PRIMARY KEY,\n description TEXT NOT NULL,\n data_type TEXT NOT NULL,\n brand_owner TEXT,\n brand_name TEXT,\n serving_size REAL,\n serving_size_unit TEXT,\n household_serving_text TEXT,\n calories REAL,\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\n magnesium REAL,\n zinc REAL,\n cached_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Recipe nutrition table (v2: extended micronutrients, per serving)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_NUTRITION_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL UNIQUE,\n calories REAL,\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\n magnesium REAL,\n zinc REAL,\n is_complete INTEGER NOT NULL DEFAULT 0,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Grocery lists table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LISTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LISTS_TABLE}_user_id \n ON ${GROCERY_LISTS_TABLE}(user_id)\n `);\n\n // Grocery list items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LIST_ITEMS_TABLE} (\n id TEXT PRIMARY KEY,\n list_id TEXT NOT NULL,\n name TEXT NOT NULL,\n quantity REAL,\n unit TEXT,\n recipe_id TEXT,\n recipe_name TEXT,\n checked INTEGER NOT NULL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (list_id) REFERENCES ${GROCERY_LISTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LIST_ITEMS_TABLE}_list_id \n ON ${GROCERY_LIST_ITEMS_TABLE}(list_id)\n `);\n\n // Nutrition goals table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${NUTRITION_GOALS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL UNIQUE,\n primary_goal_type TEXT NOT NULL,\n primary_goal_value REAL NOT NULL,\n sub_goal_1_type TEXT,\n sub_goal_1_value REAL,\n sub_goal_2_type TEXT,\n sub_goal_2_value REAL,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Meal plans table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLANS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n week_start_date TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, week_start_date)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLANS_TABLE}_user_week \n ON ${MEAL_PLANS_TABLE}(user_id, week_start_date)\n `);\n\n // Custom foods table - user-defined foods with custom nutrition\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CUSTOM_FOODS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n serving_size_grams REAL NOT NULL DEFAULT 100,\n calories REAL,\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n magnesium REAL,\n zinc REAL,\n vitamin_a REAL,\n vitamin_c REAL,\n vitamin_d REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n folate REAL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${CUSTOM_FOODS_TABLE}_user_id \n ON ${CUSTOM_FOODS_TABLE}(user_id)\n `);\n\n // Meal plan entries table (v2: supports recipes, custom foods, and FDC ingredients)\n // Note: exactly one of recipe_id, custom_food_id, or fdc_id should be set\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLAN_ENTRIES_TABLE} (\n id TEXT PRIMARY KEY,\n meal_plan_id TEXT NOT NULL,\n day_of_week INTEGER NOT NULL,\n meal_type TEXT NOT NULL,\n recipe_id TEXT,\n custom_food_id TEXT,\n fdc_id INTEGER,\n servings REAL NOT NULL DEFAULT 1,\n amount_grams REAL,\n FOREIGN KEY (meal_plan_id) REFERENCES ${MEAL_PLANS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (custom_food_id) REFERENCES ${CUSTOM_FOODS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLAN_ENTRIES_TABLE}_meal_plan_id \n ON ${MEAL_PLAN_ENTRIES_TABLE}(meal_plan_id)\n `);\n\n // Scraper evaluation URLs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SCRAPER_EVAL_URLS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n url TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, url)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SCRAPER_EVAL_URLS_TABLE}_user_id \n ON ${SCRAPER_EVAL_URLS_TABLE}(user_id)\n `);\n\n // Starred ingredients table - user's favorite FDC foods for quick linking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STARRED_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n fdc_id INTEGER NOT NULL,\n fdc_description TEXT NOT NULL,\n fdc_data_type TEXT NOT NULL,\n brand_owner TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, fdc_id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${STARRED_INGREDIENTS_TABLE}_user_id \n ON ${STARRED_INGREDIENTS_TABLE}(user_id)\n `);\n\n // ============ DATA MIGRATIONS ============\n await seedCustomFoods();\n}\n\n// Seed custom foods data\nasync function seedCustomFoods() {\n // Check if custom foods already exist (optimization: skip if already seeded)\n const existingFoodsResult = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${CUSTOM_FOODS_TABLE} WHERE id LIKE 'huel_%' OR id LIKE 'nurri_%' OR id LIKE 'kirkland_%' OR id LIKE 'schwartz_%' OR id LIKE 'ithica_%' LIMIT 1`\n );\n \n if (existingFoodsResult.rows.length > 0 && (existingFoodsResult.rows[0].count as number) > 0) {\n // Already seeded, skip\n return;\n }\n\n // Get the first user to add the custom food for\n const usersResult = await sqlite.execute(\n `SELECT id FROM ${USERS_TABLE} LIMIT 1`\n );\n\n if (usersResult.rows.length === 0) {\n // No users yet, skip seeding\n return;\n }\n\n const userId = usersResult.rows[0].id as string;\n\n // Huel Black RTD Chocolate - per 1 bottle (500mL)\n // Using INSERT OR IGNORE to prevent duplicates\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'huel_black_rtd_chocolate_001',\n ?,\n 'Huel Black RTD Chocolate',\n 500,\n 400, 35, 17, 30, 7,\n 380, 1000, 260, 9, 100, 4,\n 180, 50, 5, 3, 35,\n 0.3, 0.8, 0.2, 0.3, 3.2, 80\n )\n `, [userId]);\n\n // Nurri Protein Shake Vanilla - per 1 can (11 fl oz ≈ 325mL)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'nurri_protein_shake_vanilla_001',\n ?,\n 'Nurri Protein Shake Vanilla',\n 325,\n 150, 30, 2.5, 2, 0,\n 180, 350, 740, 0.3, 40, 4,\n 200, NULL, 5, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Kirkland Signature Daily Multi - per 1 tablet\n // This is a multivitamin supplement with no macros\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'kirkland_daily_multi_001',\n ?,\n 'Kirkland Signature Daily Multi',\n 1,\n 0, 0, 0, 0, 0,\n 0, 80, 200, 18, 100, 11,\n 897, 90, 10, 13, 25,\n 2, 6, 1.5, 1.7, 20, 850\n )\n `, [userId]);\n\n // Schwartz Everything Bagel Chips - per 9 pieces (30g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'schwartz_everything_bagel_chips_001',\n ?,\n 'Schwartz Everything Bagel Chips',\n 30,\n 120, 2, 8, 11, 1,\n 180, 33, 11, 0, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Ithica X Graza Hummus - per 2 tbsp (28g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'ithica_graza_hummus_001',\n ?,\n 'Ithica X Graza Hummus',\n 28,\n 70, 2, 4.5, 6, 2,\n 135, 60, 20, 0.7, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Kirkland Signature Lightly Breaded Chicken Breast Chunks - per 3 oz (84g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'kirkland_breaded_chicken_chunks_001',\n ?,\n 'Kirkland Signature Lightly Breaded Chicken Breast Chunks',\n 84,\n 140, 16, 5, 9, 0,\n 530, 218, 8, 0, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n}\n\n\n","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - versioned for schema changes\nexport const USERS_TABLE = 'carmy_users_v1';\nexport const SESSIONS_TABLE = 'carmy_sessions_v1';\nexport const RECIPES_TABLE = 'carmy_recipes_v1';\nexport const RECIPE_INGREDIENTS_TABLE = 'carmy_recipe_ingredients_v3'; // v3: added FDC linking\nexport const RECIPE_NUTRITION_TABLE = 'carmy_recipe_nutrition_v3'; // v3: all USDA FDC nutrients\nexport const FDC_FOODS_CACHE_TABLE = 'carmy_fdc_foods_cache_v2'; // v2: all USDA FDC nutrients\nexport const GROCERY_LISTS_TABLE = 'carmy_grocery_lists_v1';\nexport const GROCERY_LIST_ITEMS_TABLE = 'carmy_grocery_list_items_v1';\nexport const NUTRITION_GOALS_TABLE = 'carmy_nutrition_goals_v1';\nexport const MEAL_PLANS_TABLE = 'carmy_meal_plans_v1';\nexport const MEAL_PLAN_ENTRIES_TABLE = 'carmy_meal_plan_entries_v2'; // v2: support custom foods and FDC ingredients\nexport const SCRAPER_EVAL_URLS_TABLE = 'carmy_scraper_eval_urls_v1';\nexport const STARRED_INGREDIENTS_TABLE = 'carmy_starred_ingredients_v1';\nexport const CUSTOM_FOODS_TABLE = 'carmy_custom_foods_v2'; // v2: all USDA FDC nutrients\n\nexport async function runMigrations() {\n // Users table (Google OAuth)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL UNIQUE,\n name TEXT,\n picture TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Sessions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SESSIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n expires_at TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SESSIONS_TABLE}_user_id \n ON ${SESSIONS_TABLE}(user_id)\n `);\n\n // Recipes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n title TEXT NOT NULL,\n url TEXT,\n instructions TEXT,\n serving_size INTEGER NOT NULL DEFAULT 1,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPES_TABLE}_user_id \n ON ${RECIPES_TABLE}(user_id)\n `);\n\n // Recipe ingredients table (v3: with FDC linking)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL,\n name TEXT NOT NULL,\n amount REAL,\n unit TEXT,\n amount_grams REAL,\n notes TEXT,\n order_index INTEGER NOT NULL DEFAULT 0,\n fdc_id INTEGER,\n fdc_description TEXT,\n fdc_data_type TEXT,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${RECIPE_INGREDIENTS_TABLE}_recipe_id \n ON ${RECIPE_INGREDIENTS_TABLE}(recipe_id)\n `);\n\n // FDC foods cache table v2 - comprehensive USDA FDC nutrients\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FDC_FOODS_CACHE_TABLE} (\n fdc_id INTEGER PRIMARY KEY,\n description TEXT NOT NULL,\n data_type TEXT NOT NULL,\n brand_owner TEXT,\n brand_name TEXT,\n serving_size REAL,\n serving_size_unit TEXT,\n household_serving_text TEXT,\n -- Energy\n calories REAL,\n -- Macronutrients\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sugars REAL,\n added_sugars REAL,\n starch REAL,\n -- Fats breakdown\n saturated_fat REAL,\n trans_fat REAL,\n monounsaturated_fat REAL,\n polyunsaturated_fat REAL,\n cholesterol REAL,\n -- Other macros\n water REAL,\n alcohol REAL,\n caffeine REAL,\n -- Minerals\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n magnesium REAL,\n zinc REAL,\n phosphorus REAL,\n selenium REAL,\n copper REAL,\n manganese REAL,\n fluoride REAL,\n chromium REAL,\n molybdenum REAL,\n iodine REAL,\n chloride REAL,\n -- Vitamins - Fat soluble\n vitamin_a REAL,\n retinol REAL,\n beta_carotene REAL,\n alpha_carotene REAL,\n beta_cryptoxanthin REAL,\n lycopene REAL,\n lutein_zeaxanthin REAL,\n vitamin_d REAL,\n vitamin_d2 REAL,\n vitamin_d3 REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_k2 REAL,\n -- Vitamins - Water soluble\n vitamin_c REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n pantothenic_acid REAL,\n biotin REAL,\n folate REAL,\n folic_acid REAL,\n choline REAL,\n betaine REAL,\n -- Metadata\n cached_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Recipe nutrition table v3 - comprehensive nutrients per serving\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RECIPE_NUTRITION_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL UNIQUE,\n -- Energy\n calories REAL,\n -- Macronutrients\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sugars REAL,\n added_sugars REAL,\n starch REAL,\n -- Fats breakdown\n saturated_fat REAL,\n trans_fat REAL,\n monounsaturated_fat REAL,\n polyunsaturated_fat REAL,\n cholesterol REAL,\n -- Other macros\n water REAL,\n alcohol REAL,\n caffeine REAL,\n -- Minerals\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n magnesium REAL,\n zinc REAL,\n phosphorus REAL,\n selenium REAL,\n copper REAL,\n manganese REAL,\n fluoride REAL,\n chromium REAL,\n molybdenum REAL,\n iodine REAL,\n chloride REAL,\n -- Vitamins - Fat soluble\n vitamin_a REAL,\n retinol REAL,\n beta_carotene REAL,\n alpha_carotene REAL,\n beta_cryptoxanthin REAL,\n lycopene REAL,\n lutein_zeaxanthin REAL,\n vitamin_d REAL,\n vitamin_d2 REAL,\n vitamin_d3 REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_k2 REAL,\n -- Vitamins - Water soluble\n vitamin_c REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n pantothenic_acid REAL,\n biotin REAL,\n folate REAL,\n folic_acid REAL,\n choline REAL,\n betaine REAL,\n -- Metadata\n is_complete INTEGER NOT NULL DEFAULT 0,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n // Grocery lists table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LISTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LISTS_TABLE}_user_id \n ON ${GROCERY_LISTS_TABLE}(user_id)\n `);\n\n // Grocery list items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${GROCERY_LIST_ITEMS_TABLE} (\n id TEXT PRIMARY KEY,\n list_id TEXT NOT NULL,\n name TEXT NOT NULL,\n quantity REAL,\n unit TEXT,\n recipe_id TEXT,\n recipe_name TEXT,\n checked INTEGER NOT NULL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (list_id) REFERENCES ${GROCERY_LISTS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${GROCERY_LIST_ITEMS_TABLE}_list_id \n ON ${GROCERY_LIST_ITEMS_TABLE}(list_id)\n `);\n\n // Nutrition goals table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${NUTRITION_GOALS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL UNIQUE,\n primary_goal_type TEXT NOT NULL,\n primary_goal_value REAL NOT NULL,\n sub_goal_1_type TEXT,\n sub_goal_1_value REAL,\n sub_goal_2_type TEXT,\n sub_goal_2_value REAL,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Meal plans table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLANS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n week_start_date TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, week_start_date)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLANS_TABLE}_user_week \n ON ${MEAL_PLANS_TABLE}(user_id, week_start_date)\n `);\n\n // Custom foods table v2 - comprehensive USDA FDC nutrients\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CUSTOM_FOODS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n serving_size_grams REAL NOT NULL DEFAULT 100,\n -- Energy\n calories REAL,\n -- Macronutrients\n protein REAL,\n fat REAL,\n carbs REAL,\n fiber REAL,\n sugars REAL,\n added_sugars REAL,\n starch REAL,\n -- Fats breakdown\n saturated_fat REAL,\n trans_fat REAL,\n monounsaturated_fat REAL,\n polyunsaturated_fat REAL,\n cholesterol REAL,\n -- Other macros\n water REAL,\n alcohol REAL,\n caffeine REAL,\n -- Minerals\n sodium REAL,\n potassium REAL,\n calcium REAL,\n iron REAL,\n magnesium REAL,\n zinc REAL,\n phosphorus REAL,\n selenium REAL,\n copper REAL,\n manganese REAL,\n fluoride REAL,\n chromium REAL,\n molybdenum REAL,\n iodine REAL,\n chloride REAL,\n -- Vitamins - Fat soluble\n vitamin_a REAL,\n retinol REAL,\n beta_carotene REAL,\n alpha_carotene REAL,\n beta_cryptoxanthin REAL,\n lycopene REAL,\n lutein_zeaxanthin REAL,\n vitamin_d REAL,\n vitamin_d2 REAL,\n vitamin_d3 REAL,\n vitamin_e REAL,\n vitamin_k REAL,\n vitamin_k2 REAL,\n -- Vitamins - Water soluble\n vitamin_c REAL,\n vitamin_b6 REAL,\n vitamin_b12 REAL,\n thiamin REAL,\n riboflavin REAL,\n niacin REAL,\n pantothenic_acid REAL,\n biotin REAL,\n folate REAL,\n folic_acid REAL,\n choline REAL,\n betaine REAL,\n -- Metadata\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${CUSTOM_FOODS_TABLE}_user_id \n ON ${CUSTOM_FOODS_TABLE}(user_id)\n `);\n\n // Meal plan entries table (v2: supports recipes, custom foods, and FDC ingredients)\n // Note: exactly one of recipe_id, custom_food_id, or fdc_id should be set\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MEAL_PLAN_ENTRIES_TABLE} (\n id TEXT PRIMARY KEY,\n meal_plan_id TEXT NOT NULL,\n day_of_week INTEGER NOT NULL,\n meal_type TEXT NOT NULL,\n recipe_id TEXT,\n custom_food_id TEXT,\n fdc_id INTEGER,\n servings REAL NOT NULL DEFAULT 1,\n amount_grams REAL,\n FOREIGN KEY (meal_plan_id) REFERENCES ${MEAL_PLANS_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE}(id) ON DELETE CASCADE,\n FOREIGN KEY (custom_food_id) REFERENCES ${CUSTOM_FOODS_TABLE}(id) ON DELETE CASCADE\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${MEAL_PLAN_ENTRIES_TABLE}_meal_plan_id \n ON ${MEAL_PLAN_ENTRIES_TABLE}(meal_plan_id)\n `);\n\n // Scraper evaluation URLs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SCRAPER_EVAL_URLS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n url TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, url)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${SCRAPER_EVAL_URLS_TABLE}_user_id \n ON ${SCRAPER_EVAL_URLS_TABLE}(user_id)\n `);\n\n // Starred ingredients table - user's favorite FDC foods for quick linking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STARRED_INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n fdc_id INTEGER NOT NULL,\n fdc_description TEXT NOT NULL,\n fdc_data_type TEXT NOT NULL,\n brand_owner TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n UNIQUE(user_id, fdc_id)\n )\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${STARRED_INGREDIENTS_TABLE}_user_id \n ON ${STARRED_INGREDIENTS_TABLE}(user_id)\n `);\n\n // ============ DATA MIGRATIONS ============\n await seedCustomFoods();\n}\n\n// Seed custom foods data\nasync function seedCustomFoods() {\n // Check if custom foods already exist (optimization: skip if already seeded)\n const existingFoodsResult = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${CUSTOM_FOODS_TABLE} WHERE id LIKE 'huel_%' OR id LIKE 'nurri_%' OR id LIKE 'kirkland_%' OR id LIKE 'schwartz_%' OR id LIKE 'ithica_%' LIMIT 1`\n );\n \n if (existingFoodsResult.rows.length > 0 && (existingFoodsResult.rows[0].count as number) > 0) {\n // Already seeded, skip\n return;\n }\n\n // Get the first user to add the custom food for\n const usersResult = await sqlite.execute(\n `SELECT id FROM ${USERS_TABLE} LIMIT 1`\n );\n\n if (usersResult.rows.length === 0) {\n // No users yet, skip seeding\n return;\n }\n\n const userId = usersResult.rows[0].id as string;\n\n // Huel Black RTD Chocolate - per 1 bottle (500mL)\n // Using INSERT OR IGNORE to prevent duplicates\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'huel_black_rtd_chocolate_001',\n ?,\n 'Huel Black RTD Chocolate',\n 500,\n 400, 35, 17, 30, 7,\n 380, 1000, 260, 9, 100, 4,\n 180, 50, 5, 3, 35,\n 0.3, 0.8, 0.2, 0.3, 3.2, 80\n )\n `, [userId]);\n\n // Nurri Protein Shake Vanilla - per 1 can (11 fl oz ≈ 325mL)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'nurri_protein_shake_vanilla_001',\n ?,\n 'Nurri Protein Shake Vanilla',\n 325,\n 150, 30, 2.5, 2, 0,\n 180, 350, 740, 0.3, 40, 4,\n 200, NULL, 5, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Kirkland Signature Daily Multi - per 1 tablet\n // This is a multivitamin supplement with no macros\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'kirkland_daily_multi_001',\n ?,\n 'Kirkland Signature Daily Multi',\n 1,\n 0, 0, 0, 0, 0,\n 0, 80, 200, 18, 100, 11,\n 897, 90, 10, 13, 25,\n 2, 6, 1.5, 1.7, 20, 850\n )\n `, [userId]);\n\n // Schwartz Everything Bagel Chips - per 9 pieces (30g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'schwartz_everything_bagel_chips_001',\n ?,\n 'Schwartz Everything Bagel Chips',\n 30,\n 120, 2, 8, 11, 1,\n 180, 33, 11, 0, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Ithica X Graza Hummus - per 2 tbsp (28g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'ithica_graza_hummus_001',\n ?,\n 'Ithica X Graza Hummus',\n 28,\n 70, 2, 4.5, 6, 2,\n 135, 60, 20, 0.7, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n\n // Kirkland Signature Lightly Breaded Chicken Breast Chunks - per 3 oz (84g)\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${CUSTOM_FOODS_TABLE} (\n id, user_id, name, serving_size_grams,\n calories, protein, fat, carbs, fiber,\n sodium, potassium, calcium, iron, magnesium, zinc,\n vitamin_a, vitamin_c, vitamin_d, vitamin_e, vitamin_k,\n vitamin_b6, vitamin_b12, thiamin, riboflavin, niacin, folate\n ) VALUES (\n 'kirkland_breaded_chicken_chunks_001',\n ?,\n 'Kirkland Signature Lightly Breaded Chicken Breast Chunks',\n 84,\n 140, 16, 5, 9, 0,\n 530, 218, 8, 0, NULL, NULL,\n NULL, NULL, 0, NULL, NULL,\n NULL, NULL, NULL, NULL, NULL, NULL\n )\n `, [userId]);\n}\n","createdAt",["D",1766633823621],"branchVersion","branchId","75b5bdc8-d3a6-11f0-86d1-42dde27851f2","id","75b56760-d3a6-11f0-86d1-42dde27851f2","carmy",["D",1765137234131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","b9153140-d3a9-11f0-8d63-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",251,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":493,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":494,"_82":495,"_84":496,"_86":25},"tree",[187,206,220,222,223,224],"files",[187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224],"counts",{"_177":64,"_178":168,"_179":64,"_180":181,"_182":183},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{"_58":127},"carmy.shapedlines.com",{"_44":171,"_32":172,"_30":173,"_137":-5,"_42":43,"_41":174,"_139":60,"_39":175,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":176},{"_44":165,"_32":166,"_30":167,"_137":-5,"_42":43,"_41":168,"_139":60,"_39":169,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":170},{"_44":158,"_32":159,"_30":160,"_137":-5,"_42":43,"_41":161,"_139":60,"_39":162,"_13":64,"_34":163,"_36":-5,"_24":25,"_142":-5,"_27":164},{"_44":151,"_32":152,"_30":153,"_137":-5,"_42":43,"_41":154,"_139":25,"_39":155,"_13":64,"_34":20,"_36":156,"_24":25,"_142":-5,"_27":157},{"_44":144,"_32":145,"_30":146,"_137":-5,"_42":43,"_41":147,"_139":60,"_39":148,"_13":64,"_34":20,"_36":149,"_24":25,"_142":-5,"_27":150},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":140,"_13":64,"_34":20,"_36":141,"_24":25,"_142":-5,"_27":143},"b8fc0cce-d3a9-11f0-a23f-42dde27851f2","deno.json","b8fc0d82-d3a9-11f0-a23f-42dde27851f2","parentId",16,"latest",["D",1765138635487],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[135],"b93a060a-d3a9-11f0-b1bf-42dde27851f2","AGENTS.md","b93a06dc-d3a9-11f0-b1bf-42dde27851f2",28,["D",1765138635892],"You are an advanced assistant specialized in generating Val Town code.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- If a section of code that you're working on is getting too complex, consider refactoring it into subcomponents\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious operations)\n- Follow modern ES6+ conventions and functional programming practices if possible\n\n## Types of triggers\n\n### 1. HTTP Trigger\n\n- Create web APIs and endpoints\n- Handle HTTP requests and responses\n- Example structure:\n\n```ts\nexport default async function (req: Request) {\n return new Response(\"Hello World\");\n}\n```\n\nFiles that are HTTP triggers have http in their name like `foobar.http.tsx`\n\n### 2. Cron Triggers\n\n- Run on a schedule\n- Use cron expressions for timing\n- Example structure:\n\n```ts\nexport default async function () {\n // Scheduled task code\n}\n```\n\nFiles that are Cron triggers have cron in their name like `foobar.cron.tsx`\n\n### 3. Email Triggers\n\n- Process incoming emails\n- Handle email-based workflows\n- Example structure:\n\n```ts\nexport default async function (email: Email) {\n // Process email\n}\n```\n\nFiles that are Email triggers have email in their name like `foobar.email.tsx`\n\n\n## Val Town Standard Libraries\n\nVal Town provides several hosted services and utility functions.\n\n### Blob Storage\n\n```ts\nimport { blob } from \"https://esm.town/v/std/blob\";\nawait blob.setJSON(\"myKey\", { hello: \"world\" });\nlet blobDemo = await blob.getJSON(\"myKey\");\nlet appKeys = await blob.list(\"app_\");\nawait blob.delete(\"myKey\");\n```\n\n### SQLite\n\n```ts\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nconst TABLE_NAME = 'todo_app_users_2';\n// Create table - do this before usage and change table name when modifying schema\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL\n)`);\n// Query data\nconst result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [1]);\n```\n\nNote: When changing a SQLite table's schema, change the table's name (e.g., add _2 or _3) to create a fresh table.\n\n### OpenAI\n\n```ts\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nconst openai = new OpenAI();\nconst completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: \"Say hello in a creative way\" },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 30,\n});\n```\n\n### Email\n\n```ts\nimport { email } from \"https://esm.town/v/std/email\";\n// By default emails the owner of the val\nawait email({ \n subject: \"Hi\", \n text: \"Hi\", \n html: \"

Hi

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

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

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

\n Loading saved URLs...\n

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

\n {/* Header */}\n

\n Recipe Scraper Evaluation\n

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

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

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

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

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

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

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

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

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

\n )}\n

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

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

\n Loading...\n

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

\n ❌\n Error\n

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

\n                                  {summary.text}\n

\n )}\n

\n ) : (\n

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

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

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

\n {cellExpanded && (\n

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

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

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

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

Name:

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

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

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

\n •{ing}\n

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

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

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

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

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

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

\n ) : (\n

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

\n )}\n

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

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

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

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

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

🔍

No recipe URLs saved yet

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

\n )}\n

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

\n {/* Header */}\n

Recipes & Foods

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

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

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

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

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

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

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

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

\n 📖\n

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

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

\n ) : (\n

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

{recipe.title}

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

\n \n \n \n

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

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

\n ) : (\n

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

\n )}\n

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

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

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

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

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

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

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

Ingredients

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

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

Instructions

{recipe.instructions}

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

Nutrition (per serving)

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

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

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

kcal

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

protein

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

carbs

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

fat

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

fiber

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

\n {/* Fats Breakdown */}\n {(['saturatedFat', 'transFat', 'monounsaturatedFat', 'polyunsaturatedFat', 'cholesterol'] as const).some(key => recipe.nutrition![key] !== null) && (\n

\n Fats Breakdown\n

\n {(['saturatedFat', 'transFat', 'monounsaturatedFat', 'polyunsaturatedFat', 'cholesterol'] as const).map(key => {\n const info = NUTRIENT_INFO[key];\n const value = recipe.nutrition![key];\n if (value === null) return null;\n return (\n

Diff · v166