\n \n\n",[],[284,294],"57868c1e-b296-11f0-bdc2-0224a6c84d84","WeeklyCalendar.tsx","57868ce6-b296-11f0-bdc2-0224a6c84d84","61f3492f-2a78-49f2-a1bc-a845cd2f2d6f",11,["D",1761501923164],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport type { WeekData, DayData } from '../../shared/types.ts';\n\ninterface WeeklyCalendarProps {\n currentWeekStart: string;\n}\n\nconst DAYS_OF_WEEK = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];\n\nexport default function WeeklyCalendar({ currentWeekStart }: WeeklyCalendarProps) {\n const [weekData, setWeekData] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n fetchWeekData(currentWeekStart);\n }, [currentWeekStart]);\n\n const fetchWeekData = async (startDate: string) => {\n try {\n setLoading(true);\n setError(null);\n \n const response = await fetch(`/api/meals/week/${startDate}`);\n if (!response.ok) {\n throw new Error('Failed to fetch week data');\n }\n \n const data = await response.json();\n setWeekData(data);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setLoading(false);\n }\n };\n\n const formatDate = (dateStr: string) => {\n const date = new Date(dateStr);\n return date.getDate();\n };\n\n const isToday = (dateStr: string) => {\n const today = new Date().toISOString().split('T')[0];\n return dateStr === today;\n };\n\n const formatNutrition = (nutrition: { calories: number; protein: number; carbs: number; fat: number }) => {\n if (nutrition.calories === 0) return 'No meals planned';\n return `${nutrition.calories} cal • ${nutrition.protein}g protein`;\n };\n\n if (loading) {\n return (\n

This Week's Meal Plan

Loading week data...

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

This Week's Meal Plan

Error: {error}

\n );\n }\n\n if (!weekData) {\n return (\n

This Week's Meal Plan

No data available

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

This Week's Meal Plan

\n {weekData.days.map((day, index) => (\n

{DAYS_OF_WEEK[index]}

{formatDate(day.date)}

\n \n

\n {day.meals.length > 0 ? (\n

\n {day.meals.length} meal{day.meals.length !== 1 ? 's' : ''} planned\n

\n ) : (\n

No meals planned

\n )}\n

\n \n

\n {formatNutrition(day.totalNutrition)}\n

\n ))}\n

\n );\n}",[],[284,310,302],"components","6df3806e-b297-11f0-9c17-0224a6c84d84","RecipeView.tsx","6df38172-b297-11f0-9c17-0224a6c84d84",30,["D",1761502390283],"/** @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 RecipeViewProps {\n recipe: Recipe;\n onEdit: () => void;\n onDelete: () => void;\n onBack: () => void;\n}\n\nexport default function RecipeView({ recipe, onEdit, onDelete, onBack }: RecipeViewProps) {\n const [deleting, setDeleting] = useState(false);\n const [showDeleteConfirm, setShowDeleteConfirm] = useState(false);\n\n const handleDelete = async () => {\n try {\n setDeleting(true);\n \n const response = await fetch(`/api/recipes/${recipe.id}`, {\n method: 'DELETE'\n });\n\n if (!response.ok) {\n throw new Error('Failed to delete recipe');\n }\n\n onDelete();\n } catch (error) {\n console.error('Error deleting recipe:', error);\n alert('Failed to delete recipe. Please try again.');\n } finally {\n setDeleting(false);\n setShowDeleteConfirm(false);\n }\n };\n\n const formatDate = (dateStr: string) => {\n return new Date(dateStr).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n return (\n

\n \n

\n \n \n

\n\n

{recipe.name}

\n {recipe.url && (\n \n View Original Recipe 🔗\n \n )}\n

\n\n

\n Serves: {recipe.servingSize}\n

Created: {formatDate(recipe.createdAt)}

Updated: {formatDate(recipe.updatedAt)}

\n\n

Ingredients

\n \n {ingredient.quantity} {ingredient.unit}\n \n {ingredient.name}\n {ingredient.description && (\n \n ({ingredient.description})\n \n )}\n

\n\n {showDeleteConfirm && (\n

Delete Recipe

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

\n \n \n

\n )}\n

\n );\n}",[],[284,310,312],"73e9999a-b297-11f0-98be-0224a6c84d84","RecipeManager.tsx","73e99a8a-b297-11f0-98be-0224a6c84d84",31,["D",1761502400270],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\nimport RecipeList from './RecipeList.tsx';\nimport RecipeForm from './RecipeForm.tsx';\nimport RecipeView from './RecipeView.tsx';\nimport type { Recipe } from '../../shared/types.ts';\n\ntype ViewMode = 'list' | 'create' | 'edit' | 'view';\n\nexport default function RecipeManager() {\n const [viewMode, setViewMode] = useState('list');\n const [selectedRecipe, setSelectedRecipe] = useState(null);\n const [refreshKey, setRefreshKey] = useState(0);\n\n const handleSelectRecipe = (recipe: Recipe) => {\n setSelectedRecipe(recipe);\n setViewMode('view');\n };\n\n const handleCreateNew = () => {\n setSelectedRecipe(null);\n setViewMode('create');\n };\n\n const handleEdit = () => {\n setViewMode('edit');\n };\n\n const handleSave = () => {\n setViewMode('list');\n setSelectedRecipe(null);\n setRefreshKey(prev => prev + 1); // Force refresh of recipe list\n };\n\n const handleDelete = () => {\n setViewMode('list');\n setSelectedRecipe(null);\n setRefreshKey(prev => prev + 1); // Force refresh of recipe list\n };\n\n const handleCancel = () => {\n if (viewMode === 'edit' && selectedRecipe) {\n setViewMode('view');\n } else {\n setViewMode('list');\n setSelectedRecipe(null);\n }\n };\n\n const handleBack = () => {\n setViewMode('list');\n setSelectedRecipe(null);\n };\n\n return (\n

\n {viewMode === 'list' && (\n \n )}\n \n {(viewMode === 'create' || viewMode === 'edit') && (\n \n )}\n \n {viewMode === 'view' && selectedRecipe && (\n \n )}\n

\n );\n}",[],[284,310,320],"59b67dae-b297-11f0-81cd-0224a6c84d84","RecipeList.tsx","59b67e9e-b297-11f0-81cd-0224a6c84d84",28,["D",1761502356329],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport type { Recipe } from '../../shared/types.ts';\n\ninterface RecipeListProps {\n onSelectRecipe: (recipe: Recipe) => void;\n onCreateNew: () => void;\n}\n\nexport default function RecipeList({ onSelectRecipe, onCreateNew }: RecipeListProps) {\n const [recipes, setRecipes] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n fetchRecipes();\n }, []);\n\n const fetchRecipes = async () => {\n try {\n setLoading(true);\n setError(null);\n \n const response = await fetch('/api/recipes');\n if (!response.ok) {\n throw new Error('Failed to fetch recipes');\n }\n \n const data = await response.json();\n setRecipes(data);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setLoading(false);\n }\n };\n\n const formatDate = (dateStr: string) => {\n return new Date(dateStr).toLocaleDateString();\n };\n\n if (loading) {\n return (\n

My Recipes

\n \n

Loading recipes...

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

My Recipes

\n \n

Error: {error}

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

My Recipes

\n \n

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

No recipes yet. Create your first recipe to get started!

\n ) : (\n

\n {recipes.map((recipe) => (\n

onSelectRecipe(recipe)}\n >\n

{recipe.name}

\n {recipe.url && (\n e.stopPropagation()}\n >\n 🔗\n \n )}\n

\n \n

\n Serves {recipe.servingSize}\n

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

\n \n

\n Updated {formatDate(recipe.updatedAt)}\n

\n ))}\n

\n )}\n

\n );\n}",[],[284,310,328],"660a6b24-b297-11f0-bedb-0224a6c84d84","RecipeForm.tsx","660a6bd8-b297-11f0-bedb-0224a6c84d84",29,["D",1761502377014],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport type { Recipe, Ingredient } from '../../shared/types.ts';\n\ninterface RecipeFormProps {\n recipe?: Recipe;\n onSave: () => void;\n onCancel: () => void;\n}\n\nexport default function RecipeForm({ recipe, onSave, onCancel }: RecipeFormProps) {\n const [name, setName] = useState('');\n const [servingSize, setServingSize] = useState(1);\n const [url, setUrl] = useState('');\n const [ingredients, setIngredients] = useState[]>([\n { name: '', quantity: 1, unit: '', description: '' }\n ]);\n const [saving, setSaving] = useState(false);\n const [error, setError] = useState(null);\n\n const isEditing = !!recipe;\n\n useEffect(() => {\n if (recipe) {\n setName(recipe.name);\n setServingSize(recipe.servingSize);\n setUrl(recipe.url || '');\n setIngredients(recipe.ingredients.map(ing => ({\n name: ing.name,\n quantity: ing.quantity,\n unit: ing.unit,\n description: ing.description || ''\n })));\n }\n }, [recipe]);\n\n const addIngredient = () => {\n setIngredients([...ingredients, { name: '', quantity: 1, unit: '', description: '' }]);\n };\n\n const removeIngredient = (index: number) => {\n if (ingredients.length > 1) {\n setIngredients(ingredients.filter((_, i) => i !== index));\n }\n };\n\n const updateIngredient = (index: number, field: keyof Omit, value: string | number) => {\n const updated = [...ingredients];\n updated[index] = { ...updated[index], [field]: value };\n setIngredients(updated);\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!name.trim()) {\n setError('Recipe name is required');\n return;\n }\n \n if (servingSize <= 0) {\n setError('Serving size must be greater than 0');\n return;\n }\n \n const validIngredients = ingredients.filter(ing => \n ing.name.trim() && ing.unit.trim() && ing.quantity > 0\n );\n \n if (validIngredients.length === 0) {\n setError('At least one valid ingredient is required');\n return;\n }\n\n try {\n setSaving(true);\n setError(null);\n\n const recipeData = {\n name: name.trim(),\n servingSize,\n url: url.trim() || undefined,\n ingredients: validIngredients.map(ing => ({\n name: ing.name.trim(),\n quantity: ing.quantity,\n unit: ing.unit.trim(),\n description: ing.description?.trim() || undefined\n }))\n };\n\n const response = await fetch(\n isEditing ? `/api/recipes/${recipe.id}` : '/api/recipes',\n {\n method: isEditing ? 'PUT' : 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(recipeData)\n }\n );\n\n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to save recipe');\n }\n\n onSave();\n } catch (err) {\n setError(err instanceof Error ? err.message : 'An error occurred');\n } finally {\n setSaving(false);\n }\n };\n\n return (\n

{isEditing ? 'Edit Recipe' : 'Create New Recipe'}

\n \n

\n\n {error &&

{error}

}\n\n

\n Recipe Name *\n setName(e.target.value)}\n placeholder=\"Enter recipe name\"\n required\n />\n

\n\n

\n Serving Size *\n setServingSize(parseInt(e.target.value) || 1)}\n min=\"1\"\n required\n />\n

\n\n

\n Recipe URL (optional)\n setUrl(e.target.value)}\n placeholder=\"https://example.com/recipe\"\n />\n

\n\n

Ingredients

\n \n

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

\n updateIngredient(index, 'name', e.target.value)}\n />\n updateIngredient(index, 'quantity', parseFloat(e.target.value) || 0)}\n min=\"0\"\n step=\"0.1\"\n />\n updateIngredient(index, 'unit', e.target.value)}\n />\n updateIngredient(index, 'description', e.target.value)}\n />\n

\n {ingredients.length > 1 && (\n removeIngredient(index)}\n >\n Remove\n \n )}\n

\n ))}\n

\n\n

\n \n

\n );\n}",[],[284,310,336],"4fc04254-b296-11f0-bdbc-0224a6c84d84","DailyGoals.tsx","4fc04312-b296-11f0-bdbc-0224a6c84d84",10,["D",1761501910118],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from 'https://esm.sh/react@18.2.0';\nimport type { NutritionGoals } from '../../shared/types.ts';\n\ninterface DailyGoalsProps {\n goals: NutritionGoals;\n}\n\nexport default function DailyGoals({ goals }: DailyGoalsProps) {\n return (\n

Daily Nutrition Goals

{goals.calories}

Calories

{goals.protein}g

Protein

{goals.carbs}g

Carbs

{goals.fat}g

Fat

\n );\n}",[],[284,310,344],"827fb444-b297-11f0-bef3-0224a6c84d84","App.tsx","5b75c0c4-b296-11f0-965e-0224a6c84d84",32,["D",1761502424754],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\nimport DailyGoals from './DailyGoals.tsx';\nimport WeeklyCalendar from './WeeklyCalendar.tsx';\nimport RecipeManager from './RecipeManager.tsx';\nimport type { NutritionGoals } from '../../shared/types.ts';\n\ninterface AppProps {\n initialGoals: NutritionGoals;\n currentWeekStart: string;\n}\n\ntype ActiveTab = 'dashboard' | 'recipes';\n\nexport default function App({ initialGoals, currentWeekStart }: AppProps) {\n const [activeTab, setActiveTab] = useState('dashboard');\n\n return (\n

🍽️ Carmy

Your personal meal planner, recipe manager & nutrition tracker

\n \n \n

\n \n

\n {activeTab === 'dashboard' && (\n <>\n \n \n \n )}\n \n {activeTab === 'recipes' && (\n \n )}\n

\n );\n}",[],[284,310,352],"4fc04cae-b296-11f0-bdbc-0224a6c84d84",["D",1761501910118],[230,231,232,233,234,235,236],[284,310],"4bda8730-b296-11f0-8320-0224a6c84d84",9,["D",1761501903573],[229,237,238,239],[284],"ce9db510-b297-11f0-9b96-0224a6c84d84","index.ts","408645cc-b296-11f0-b5e9-0224a6c84d84",38,["D",1761502552455],5,"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 { getNutritionGoals } from \"./database/queries.ts\";\nimport goals from \"./routes/goals.ts\";\nimport meals from \"./routes/meals.ts\";\nimport recipes from \"./routes/recipes.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database\nawait runMigrations();\n\n// API routes\napp.route(\"/api/goals\", goals);\napp.route(\"/api/meals\", meals);\napp.route(\"/api/recipes\", recipes);\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 page with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n try {\n const nutritionGoals = await getNutritionGoals();\n \n // Get current week's Sunday\n const today = new Date();\n const currentDay = today.getDay(); // 0 = Sunday, 1 = Monday, etc.\n const sunday = new Date(today);\n sunday.setDate(today.getDate() - currentDay);\n const startDate = sunday.toISOString().split('T')[0];\n \n const initialData = {\n nutritionGoals,\n currentWeekStart: startDate\n };\n \n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n\n return c.html(html);\n});\n\nexport default app.fetch;",[],[191,369],["D",1761502672105],[],[191,111,93],["D",1761501874448],[],[191,111,83],["D",1761501860944],[],[191,111,68],["D",1761501860944],[224,225,226],[191,111],"269961b4-b299-11f0-9064-0224a6c84d84","queries.ts","2e5518c4-b296-11f0-b037-0224a6c84d84","07ed9c99-e92a-41f2-b432-9e8e20b8a830",43,["D",1761503129536],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { GOALS_TABLE, MEALS_TABLE, RECIPES_TABLE, INGREDIENTS_TABLE } from \"./migrations.ts\";\nimport type { NutritionGoals, Meal, NutritionInfo, Recipe, Ingredient } from \"../../shared/types.ts\";\n\nexport async function getNutritionGoals(userId: string = 'default'): Promise {\n const { rows } = await sqlite.execute(\n `SELECT calories, protein, carbs, fat FROM ${GOALS_TABLE} WHERE user_id = ? ORDER BY updated_at DESC LIMIT 1`,\n [userId]\n );\n \n if (rows.length === 0) {\n // Return default goals if none found\n return { calories: 2000, protein: 150, carbs: 250, fat: 67 };\n }\n \n const row = rows[0];\n return {\n calories: row.calories,\n protein: row.protein,\n carbs: row.carbs,\n fat: row.fat\n };\n}\n\nexport async function updateNutritionGoals(goals: NutritionGoals, userId: string = 'default'): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${GOALS_TABLE} (user_id, calories, protein, carbs, fat, updated_at) \n VALUES (?, ?, ?, ?, ?, CURRENT_TIMESTAMP)`,\n [userId, goals.calories, goals.protein, goals.carbs, goals.fat]\n );\n}\n\nexport async function getMealsForDateRange(startDate: string, endDate: string, userId: string = 'default'): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, type, date, calories, protein, carbs, fat \n FROM ${MEALS_TABLE} \n WHERE user_id = ? AND date >= ? AND date <= ?\n ORDER BY date, type`,\n [userId, startDate, endDate]\n );\n \n return rows.map(row => ({\n id: row.id,\n name: row.name,\n type: row.type as 'breakfast' | 'lunch' | 'dinner' | 'snack',\n date: row.date,\n nutrition: {\n calories: row.calories,\n protein: row.protein,\n carbs: row.carbs,\n fat: row.fat\n }\n }));\n}\n\nexport async function addMeal(meal: Omit, userId: string = 'default'): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${MEALS_TABLE} (id, user_id, name, type, date, calories, protein, carbs, fat)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, userId, meal.name, meal.type, meal.date,\n meal.nutrition.calories, meal.nutrition.protein, meal.nutrition.carbs, meal.nutrition.fat\n ]\n );\n return id;\n}\n\nexport async function deleteMeal(mealId: string, userId: string = 'default'): Promise {\n await sqlite.execute(\n `DELETE FROM ${MEALS_TABLE} WHERE id = ? AND user_id = ?`,\n [mealId, userId]\n );\n}\n\n// Recipe queries\nexport async function getAllRecipes(userId: string = 'default'): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, serving_size, url, created_at, updated_at \n FROM ${RECIPES_TABLE} \n WHERE user_id = ? \n ORDER BY updated_at DESC`,\n [userId]\n );\n \n const recipes: Recipe[] = [];\n \n for (const row of rows) {\n const ingredients = await getRecipeIngredients(row.id);\n recipes.push({\n id: row.id,\n name: row.name,\n servingSize: row.serving_size,\n url: row.url || undefined,\n ingredients,\n createdAt: row.created_at,\n updatedAt: row.updated_at\n });\n }\n \n return recipes;\n}\n\nexport async function getRecipeById(recipeId: string, userId: string = 'default'): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, serving_size, url, created_at, updated_at \n FROM ${RECIPES_TABLE} \n WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n \n if (rows.length === 0) return null;\n \n const row = rows[0];\n const ingredients = await getRecipeIngredients(recipeId);\n \n return {\n id: row.id,\n name: row.name,\n servingSize: row.serving_size,\n url: row.url || undefined,\n ingredients,\n createdAt: row.created_at,\n updatedAt: row.updated_at\n };\n}\n\nexport async function createRecipe(recipe: Omit, userId: string = 'default'): Promise {\n const recipeId = crypto.randomUUID();\n \n // Insert recipe\n await sqlite.execute(\n `INSERT INTO ${RECIPES_TABLE} (id, user_id, name, serving_size, url)\n VALUES (?, ?, ?, ?, ?)`,\n [recipeId, userId, recipe.name, recipe.servingSize, recipe.url || null]\n );\n \n // Insert ingredients\n for (const ingredient of recipe.ingredients) {\n const ingredientId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${INGREDIENTS_TABLE} (id, recipe_id, name, quantity, unit, description)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingredientId, recipeId, ingredient.name, ingredient.quantity, ingredient.unit, ingredient.description || null]\n );\n }\n \n return recipeId;\n}\n\nexport async function updateRecipe(recipeId: string, recipe: Omit, userId: string = 'default'): Promise {\n // Update recipe\n await sqlite.execute(\n `UPDATE ${RECIPES_TABLE} \n SET name = ?, serving_size = ?, url = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ? AND user_id = ?`,\n [recipe.name, recipe.servingSize, recipe.url || null, recipeId, userId]\n );\n \n // Delete existing ingredients\n await sqlite.execute(\n `DELETE FROM ${INGREDIENTS_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n \n // Insert new ingredients\n for (const ingredient of recipe.ingredients) {\n const ingredientId = crypto.randomUUID();\n await sqlite.execute(\n `INSERT INTO ${INGREDIENTS_TABLE} (id, recipe_id, name, quantity, unit, description)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [ingredientId, recipeId, ingredient.name, ingredient.quantity, ingredient.unit, ingredient.description || null]\n );\n }\n}\n\nexport async function deleteRecipe(recipeId: string, userId: string = 'default'): Promise {\n // Delete ingredients first (due to foreign key constraint)\n await sqlite.execute(\n `DELETE FROM ${INGREDIENTS_TABLE} WHERE recipe_id = ?`,\n [recipeId]\n );\n \n // Delete recipe\n await sqlite.execute(\n `DELETE FROM ${RECIPES_TABLE} WHERE id = ? AND user_id = ?`,\n [recipeId, userId]\n );\n}\n\nasync function getRecipeIngredients(recipeId: string): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, quantity, unit, description \n FROM ${INGREDIENTS_TABLE} \n WHERE recipe_id = ?\n ORDER BY name`,\n [recipeId]\n );\n \n return rows.map(row => ({\n id: row.id,\n name: row.name,\n quantity: row.quantity,\n unit: row.unit,\n description: row.description || undefined\n }));\n}",[],[191,398,390],"database","a61f3118-b297-11f0-adb6-0224a6c84d84","migrations.ts","27999a3c-b296-11f0-b853-0224a6c84d84",34,["D",1761502484516],4,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nconst GOALS_TABLE = 'carmy_nutrition_goals_1';\nconst MEALS_TABLE = 'carmy_meals_1';\nconst RECIPES_TABLE = 'carmy_recipes_1';\nconst INGREDIENTS_TABLE = 'carmy_ingredients_1';\n\nexport async function runMigrations() {\n // Create nutrition goals table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${GOALS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id TEXT NOT NULL DEFAULT 'default',\n calories INTEGER NOT NULL,\n protein INTEGER NOT NULL,\n carbs INTEGER NOT NULL,\n fat INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create meals table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${MEALS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL DEFAULT 'default',\n name TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('breakfast', 'lunch', 'dinner', 'snack')),\n date TEXT NOT NULL,\n calories INTEGER NOT NULL,\n protein INTEGER NOT NULL,\n carbs INTEGER NOT NULL,\n fat INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Insert default nutrition goals if none exist\n const { rows } = await sqlite.execute(`SELECT COUNT(*) as count FROM ${GOALS_TABLE} WHERE user_id = 'default'`);\n if (rows[0].count === 0) {\n await sqlite.execute(`INSERT INTO ${GOALS_TABLE} (calories, protein, carbs, fat) VALUES (2000, 150, 250, 67)`);\n }\n\n // Create recipes table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${RECIPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL DEFAULT 'default',\n name TEXT NOT NULL,\n serving_size INTEGER NOT NULL,\n url TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create ingredients table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${INGREDIENTS_TABLE} (\n id TEXT PRIMARY KEY,\n recipe_id TEXT NOT NULL,\n name TEXT NOT NULL,\n quantity REAL NOT NULL,\n unit TEXT NOT NULL,\n description TEXT,\n FOREIGN KEY (recipe_id) REFERENCES ${RECIPES_TABLE} (id) ON DELETE CASCADE\n )`);\n}\n\nexport { GOALS_TABLE, MEALS_TABLE, RECIPES_TABLE, INGREDIENTS_TABLE };",[],[191,398,400],"2799b260-b296-11f0-b853-0224a6c84d84",["D",1761501842754],[221,222],[191,398],"2799ae8c-b296-11f0-b853-0224a6c84d84",["D",1761501842754],[220,223,227],[191],["D",1761501608681],{"_11":12,"_161":74},{"_11":12,"_157":-5,"_73":74,"_31":72,"_158":159,"_160":30},{"_43":148,"_13":16,"_37":40,"_149":114,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":14,"_156":12},"ctx",{"_56":-5,"_180":453,"_454":455,"_456":457,"_458":30,"_459":30,"_460":30,"_461":24,"_462":-5,"_463":-7,"_464":-7,"_465":26,"_466":30,"_467":30,"_468":-5,"_469":30,"_470":30,"_471":30,"_472":-5},"ENV",{"_424":425,"_426":427,"_428":16,"_429":430,"_431":432,"_433":434,"_435":436,"_437":438,"_439":440,"_441":442,"_443":444,"_445":446,"_447":448,"_449":450,"_451":452},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · routes