[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_272":273,"_274":275},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","frontend","latestPath","fileId","95a26ea6-8d67-4c51-ba11-4ce34f06b3e0","name","fileType","directory","content","createdAt",["D",1761501903573],"branchVersion","branchId","9c145010-b295-11f0-b212-0224a6c84d84",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"frontend/style.css","4bda777c-b296-11f0-8320-0224a6c84d84","style.css","/* Carmy App Styles */\n\n* {\n box-sizing: border-box;\n}\n\nbody {\n margin: 0;\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', 'Roboto', 'Oxygen',\n 'Ubuntu', 'Cantarell', 'Fira Sans', 'Droid Sans', 'Helvetica Neue',\n sans-serif;\n -webkit-font-smoothing: antialiased;\n -moz-osx-font-smoothing: grayscale;\n background-color: #f8fafc;\n color: #1e293b;\n}\n\n.container {\n max-width: 1200px;\n margin: 0 auto;\n padding: 20px;\n}\n\n.header {\n text-align: center;\n margin-bottom: 40px;\n}\n\n.header h1 {\n color: #059669;\n font-size: 2.5rem;\n margin: 0;\n font-weight: 700;\n}\n\n.header p {\n color: #64748b;\n font-size: 1.1rem;\n margin: 8px 0 0 0;\n}\n\n.main-content {\n display: grid;\n grid-template-columns: 1fr 2fr;\n gap: 30px;\n align-items: start;\n}\n\n@media (max-width: 768px) {\n .main-content {\n grid-template-columns: 1fr;\n gap: 20px;\n }\n}\n\n/* Daily Goals Section */\n.daily-goals {\n background: white;\n border-radius: 12px;\n padding: 24px;\n box-shadow: 0 1px 3px 0 rgb(0 0 0 / 0.1), 0 1px 2px -1px rgb(0 0 0 / 0.1);\n border: 1px solid #e2e8f0;\n}\n\n.daily-goals h2 {\n color: #1e293b;\n font-size: 1.5rem;\n margin: 0 0 20px 0;\n font-weight: 600;\n}\n\n.goals-grid {\n display: grid;\n grid-template-columns: 1fr 1fr;\n gap: 16px;\n}\n\n.goal-item {\n text-align: center;\n padding: 16px;\n background: #f8fafc;\n border-radius: 8px;\n border: 1px solid #e2e8f0;\n}\n\n.goal-value {\n font-size: 1.5rem;\n font-weight: 700;\n color: #059669;\n margin: 0;\n}\n\n.goal-label {\n font-size: 0.875rem;\n color: #64748b;\n margin: 4px 0 0 0;\n text-transform: uppercase;\n letter-spacing: 0.05em;\n}\n\n/* Weekly Calendar */\n.weekly-calendar {\n background: white;\n border-radius: 12px;\n padding: 24px;\n box-shadow: 0 1px 3px 0 rgb(0 0 0 / 0.1), 0 1px 2px -1px rgb(0 0 0 / 0.1);\n border: 1px solid #e2e8f0;\n}\n\n.weekly-calendar h2 {\n color: #1e293b;\n font-size: 1.5rem;\n margin: 0 0 20px 0;\n font-weight: 600;\n}\n\n.calendar-grid {\n display: grid;\n grid-template-columns: repeat(7, 1fr);\n gap: 12px;\n}\n\n@media (max-width: 768px) {\n .calendar-grid {\n grid-template-columns: 1fr;\n gap: 8px;\n }\n}\n\n.day-card {\n border: 1px solid #e2e8f0;\n border-radius: 8px;\n padding: 12px;\n background: #fafafa;\n min-height: 120px;\n transition: all 0.2s ease;\n}\n\n.day-card:hover {\n border-color: #059669;\n box-shadow: 0 2px 4px 0 rgb(0 0 0 / 0.1);\n}\n\n.day-card.today {\n border-color: #059669;\n background: #f0fdf4;\n}\n\n.day-header {\n text-align: center;\n margin-bottom: 8px;\n}\n\n.day-name {\n font-size: 0.75rem;\n color: #64748b;\n text-transform: uppercase;\n letter-spacing: 0.05em;\n margin: 0;\n}\n\n.day-date {\n font-size: 1.125rem;\n font-weight: 600;\n color: #1e293b;\n margin: 2px 0 0 0;\n}\n\n.day-card.today .day-date {\n color: #059669;\n}\n\n.day-nutrition {\n font-size: 0.75rem;\n color: #64748b;\n text-align: center;\n margin-top: 8px;\n}\n\n.meals-preview {\n margin-top: 8px;\n}\n\n.meal-count {\n font-size: 0.75rem;\n color: #64748b;\n text-align: center;\n font-style: italic;\n}\n\n.loading {\n text-align: center;\n color: #64748b;\n font-style: italic;\n padding: 20px;\n}\n\n.error {\n color: #dc2626;\n background: #fef2f2;\n border: 1px solid #fecaca;\n border-radius: 8px;\n padding: 12px;\n text-align: center;\n font-size: 0.875rem;\n}",["D",1761501903573],"id","9c13cb7c-b295-11f0-b212-0224a6c84d84","carmy-mvp",["D",1761501608681],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","9c19e642-b295-11f0-b212-0224a6c84d84","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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",44,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":268,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":269,"_84":270,"_86":271,"_88":25},"tree",[176,184,186,188,189],"files",[176,177,178,179,180,181,182,183,184,185,186,187,188,189],"counts",{"_166":66,"_167":138,"_168":66,"_169":170,"_171":172},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":160,"_32":161,"_30":162,"_137":-5,"_39":40,"_38":163,"_139":62,"_36":164,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":165},{"_47":157,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":158,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":159},{"_47":151,"_32":152,"_30":153,"_137":-5,"_39":40,"_38":154,"_139":62,"_36":155,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_27":156},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":25,"_36":148,"_13":66,"_33":21,"_35":149,"_24":25,"_142":-5,"_27":150},{"_47":135,"_32":136,"_30":60,"_137":-5,"_39":40,"_38":138,"_139":25,"_36":140,"_13":66,"_33":141,"_35":109,"_24":25,"_142":-5,"_27":143},"9c19e598-b295-11f0-b212-0224a6c84d84","main.ts","parentId",1,"latest",["D",1761501608706],"script","label",[136],"1eed298a-b296-11f0-b31d-0224a6c84d84","README.md","1eed2a20-b296-11f0-b31d-0224a6c84d84",2,["D",1761501828192],"# Carmy - Meal Planner, Recipe Manager & Nutrition Tracker\n\nCarmy is a comprehensive meal planning application that helps users track their nutrition goals, manage recipes, and plan meals throughout the week.\n\n## Features\n\n- **Daily Goals Tracking**: Monitor nutritional goals including calories, protein, carbs, and fat\n- **7-Day Calendar**: Weekly meal planning view anchored to the current week (Sunday start)\n- **Recipe Management**: Store and organize favorite recipes\n- **Nutrition Tracking**: Track nutritional information for planned meals\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database queries\n│ └── routes/\n│ ├── goals.ts # Nutrition goals API\n│ └── meals.ts # Meals API\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React app entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── DailyGoals.tsx # Daily goals section\n│ │ └── WeeklyCalendar.tsx # 7-day calendar\n│ └── style.css # Styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\nThe application runs on a Hono backend with a React frontend. The main entry point is `backend/index.ts`.",[145],"2285500e-b296-11f0-a4bc-0224a6c84d84","shared","1ddebf71-04bb-4f76-b677-604c275015d5",3,["D",1761501834233],[152],"4bda8730-b296-11f0-8320-0224a6c84d84",["D",1761501903573],[28],"2799ae8c-b296-11f0-b853-0224a6c84d84","backend","033c335d-be55-4674-904a-042e49f46249",4,["D",1761501842754],[161],"pulls","branches","forks","envVars",{"_173":66,"_175":66},"connections",{"_173":66,"_174":66},"count","unfilledCount","emptyCount",{"_47":160,"_32":161,"_30":162,"_137":-5,"_39":40,"_38":163,"_139":62,"_36":265,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_191":266,"_27":267},{"_47":261,"_32":253,"_30":247,"_137":162,"_39":40,"_38":163,"_139":62,"_36":262,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_191":263,"_27":264},{"_47":254,"_32":255,"_30":256,"_137":247,"_39":40,"_38":163,"_139":25,"_36":257,"_13":66,"_33":141,"_35":258,"_24":25,"_142":-5,"_191":259,"_27":260},{"_47":244,"_32":245,"_30":246,"_137":247,"_39":40,"_38":248,"_139":25,"_36":249,"_13":66,"_33":141,"_35":250,"_24":25,"_142":-5,"_191":251,"_27":252},{"_47":240,"_32":231,"_30":225,"_137":162,"_39":40,"_38":235,"_139":62,"_36":241,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_191":242,"_27":243},{"_47":232,"_32":233,"_30":234,"_137":225,"_39":40,"_38":235,"_139":62,"_36":236,"_13":66,"_33":141,"_35":237,"_24":25,"_142":-5,"_191":238,"_27":239},{"_47":222,"_32":223,"_30":224,"_137":225,"_39":40,"_38":226,"_139":62,"_36":227,"_13":66,"_33":141,"_35":228,"_24":25,"_142":-5,"_191":229,"_27":230},{"_47":214,"_32":215,"_30":216,"_137":162,"_39":40,"_38":217,"_139":25,"_36":218,"_13":66,"_33":141,"_35":219,"_24":25,"_142":-5,"_191":220,"_27":221},{"_47":157,"_32":28,"_30":31,"_137":-5,"_39":40,"_38":14,"_139":62,"_36":211,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_191":212,"_27":213},{"_47":207,"_32":44,"_30":43,"_137":31,"_39":40,"_38":14,"_139":25,"_36":208,"_13":66,"_33":21,"_35":45,"_24":25,"_142":-5,"_191":209,"_27":210},{"_47":151,"_32":152,"_30":153,"_137":-5,"_39":40,"_38":154,"_139":62,"_36":204,"_13":66,"_33":34,"_35":-5,"_24":25,"_142":-5,"_191":205,"_27":206},{"_47":197,"_32":198,"_30":199,"_137":153,"_39":40,"_38":154,"_139":25,"_36":200,"_13":66,"_33":141,"_35":201,"_24":25,"_142":-5,"_191":202,"_27":203},{"_47":144,"_32":145,"_30":146,"_137":-5,"_39":40,"_38":147,"_139":25,"_36":194,"_13":66,"_33":21,"_35":149,"_24":25,"_142":-5,"_191":195,"_27":196},{"_47":135,"_32":136,"_30":60,"_137":-5,"_39":40,"_38":138,"_139":25,"_36":190,"_13":66,"_33":141,"_35":109,"_24":25,"_142":-5,"_191":192,"_27":193},["D",1761501608706],"children",[],[136],["D",1761501828192],[],[145],"228544ec-b296-11f0-a4bc-0224a6c84d84","types.ts","228545a0-b296-11f0-a4bc-0224a6c84d84",["D",1761501834233],"// Shared types for Carmy application\n\nexport interface NutritionGoals {\n calories: number;\n protein: number; // grams\n carbs: number; // grams\n fat: number; // grams\n}\n\nexport interface NutritionInfo {\n calories: number;\n protein: number;\n carbs: number;\n fat: number;\n}\n\nexport interface Meal {\n id: string;\n name: string;\n type: 'breakfast' | 'lunch' | 'dinner' | 'snack';\n nutrition: NutritionInfo;\n date: string; // ISO date string\n}\n\nexport interface DayData {\n date: string; // ISO date string\n meals: Meal[];\n totalNutrition: NutritionInfo;\n}\n\nexport interface WeekData {\n startDate: string; // ISO date string (Sunday)\n days: DayData[];\n}",[],[152,198],["D",1761501834233],[187],[152],"4bda76c8-b296-11f0-8320-0224a6c84d84",["D",1761501903573],[],[28,44],["D",1761501903573],[185],[28],"4086441e-b296-11f0-b5e9-0224a6c84d84","index.ts","408645cc-b296-11f0-b5e9-0224a6c84d84",8,["D",1761501884574],"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\";\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);\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;",[],[161,215],"3a7d233a-b296-11f0-b0c3-0224a6c84d84","meals.ts","3a7d23ee-b296-11f0-b0c3-0224a6c84d84","06a984c8-8de5-43af-818a-fe9e1f73e16f",7,["D",1761501874448],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getMealsForDateRange, addMeal, deleteMeal } from \"../database/queries.ts\";\nimport type { Meal, WeekData, DayData, NutritionInfo } from \"../../shared/types.ts\";\n\nconst meals = new Hono();\n\n// Get meals for a week starting from a given Sunday\nmeals.get(\"/week/:startDate\", async (c) => {\n try {\n const startDate = c.req.param(\"startDate\");\n \n // Validate date format\n if (!startDate || !/^\\d{4}-\\d{2}-\\d{2}$/.test(startDate)) {\n return c.json({ error: \"Invalid date format. Use YYYY-MM-DD\" }, 400);\n }\n \n // Calculate end date (6 days after start date)\n const start = new Date(startDate);\n const end = new Date(start);\n end.setDate(end.getDate() + 6);\n const endDate = end.toISOString().split('T')[0];\n \n const mealsData = await getMealsForDateRange(startDate, endDate);\n \n // Group meals by date and calculate daily totals\n const daysMap = new Map();\n \n // Initialize all 7 days\n for (let i = 0; i < 7; i++) {\n const date = new Date(start);\n date.setDate(date.getDate() + i);\n const dateStr = date.toISOString().split('T')[0];\n \n daysMap.set(dateStr, {\n date: dateStr,\n meals: [],\n totalNutrition: { calories: 0, protein: 0, carbs: 0, fat: 0 }\n });\n }\n \n // Add meals to their respective days\n mealsData.forEach(meal => {\n const dayData = daysMap.get(meal.date);\n if (dayData) {\n dayData.meals.push(meal);\n dayData.totalNutrition.calories += meal.nutrition.calories;\n dayData.totalNutrition.protein += meal.nutrition.protein;\n dayData.totalNutrition.carbs += meal.nutrition.carbs;\n dayData.totalNutrition.fat += meal.nutrition.fat;\n }\n });\n \n const weekData: WeekData = {\n startDate,\n days: Array.from(daysMap.values())\n };\n \n return c.json(weekData);\n } catch (error) {\n console.error(\"Error fetching week meals:\", error);\n return c.json({ error: \"Failed to fetch week meals\" }, 500);\n }\n});\n\nmeals.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as Omit;\n \n // Validate the input\n if (!body.name || !body.type || !body.date || !body.nutrition) {\n return c.json({ error: \"Missing required meal fields\" }, 400);\n }\n \n if (!['breakfast', 'lunch', 'dinner', 'snack'].includes(body.type)) {\n return c.json({ error: \"Invalid meal type\" }, 400);\n }\n \n const mealId = await addMeal(body);\n return c.json({ id: mealId, success: true });\n } catch (error) {\n console.error(\"Error adding meal:\", error);\n return c.json({ error: \"Failed to add meal\" }, 500);\n }\n});\n\nmeals.delete(\"/:id\", async (c) => {\n try {\n const mealId = c.req.param(\"id\");\n await deleteMeal(mealId);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting meal:\", error);\n return c.json({ error: \"Failed to delete meal\" }, 500);\n }\n});\n\nexport default meals;",[],[161,231,223],"routes","32718226-b296-11f0-86b4-0224a6c84d84","goals.ts","327182c6-b296-11f0-86b4-0224a6c84d84",6,["D",1761501860944],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getNutritionGoals, updateNutritionGoals } from \"../database/queries.ts\";\nimport type { NutritionGoals } from \"../../shared/types.ts\";\n\nconst goals = new Hono();\n\ngoals.get(\"/\", async (c) => {\n try {\n const nutritionGoals = await getNutritionGoals();\n return c.json(nutritionGoals);\n } catch (error) {\n console.error(\"Error fetching nutrition goals:\", error);\n return c.json({ error: \"Failed to fetch nutrition goals\" }, 500);\n }\n});\n\ngoals.put(\"/\", async (c) => {\n try {\n const body = await c.req.json() as NutritionGoals;\n \n // Validate the input\n if (!body.calories || !body.protein || !body.carbs || !body.fat) {\n return c.json({ error: \"Missing required nutrition goal fields\" }, 400);\n }\n \n if (body.calories < 0 || body.protein < 0 || body.carbs < 0 || body.fat < 0) {\n return c.json({ error: \"Nutrition values must be positive\" }, 400);\n }\n \n await updateNutritionGoals(body);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating nutrition goals:\", error);\n return c.json({ error: \"Failed to update nutrition goals\" }, 500);\n }\n});\n\nexport default goals;",[],[161,231,233],"32718e7e-b296-11f0-86b4-0224a6c84d84",["D",1761501860944],[181,182],[161,231],"2e551806-b296-11f0-b037-0224a6c84d84","queries.ts","2e5518c4-b296-11f0-b037-0224a6c84d84","07ed9c99-e92a-41f2-b432-9e8e20b8a830",5,["D",1761501854055],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { GOALS_TABLE, MEALS_TABLE } from \"./migrations.ts\";\nimport type { NutritionGoals, Meal, NutritionInfo } 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}",[],[161,253,245],"database","2799996a-b296-11f0-b853-0224a6c84d84","migrations.ts","27999a3c-b296-11f0-b853-0224a6c84d84",["D",1761501842754],"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';\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\nexport { GOALS_TABLE, MEALS_TABLE };",[],[161,253,255],"2799b260-b296-11f0-b853-0224a6c84d84",["D",1761501842754],[178,179],[161,253],["D",1761501842754],[177,180,183],[161],["D",1761501608681],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":40,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":305,"_306":307,"_308":309,"_310":25,"_311":25,"_312":25,"_313":62,"_314":-5,"_315":-7,"_316":-7,"_317":66,"_318":25,"_319":25,"_320":-5,"_321":25,"_322":25,"_323":25,"_324":-5},"ENV",{"_276":277,"_278":279,"_280":90,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v9