Forkcast - Meal Planning

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_255":256,"_257":258},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","28b76762-f519-11f0-aef0-42dde27851f2","name","queries.ts","fileType","script","content","// Database query functions\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAMES } from \"./migrations.ts\";\nimport type { Recipe, MealLogEntry, MealPlan, ConversationMessage } from \"../../shared/types.ts\";\n\n// ============ RECIPES ============\n\nexport async function getAllRecipes(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAMES.recipes} ORDER BY name`);\n return result.rows.map(parseRecipeRow);\n}\n\nexport async function getRecipeById(id: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAMES.recipes} WHERE id = ?`,\n args: [id],\n });\n return result.rows.length > 0 ? parseRecipeRow(result.rows[0]) : null;\n}\n\nexport async function getRecipesByTag(tag: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAMES.recipes} WHERE tags LIKE ?`,\n args: [`%\"${tag}\"%`],\n });\n return result.rows.map(parseRecipeRow);\n}\n\nexport async function getTriedRecipes(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAMES.recipes} WHERE tried = 1 ORDER BY rating DESC NULLS LAST`\n );\n return result.rows.map(parseRecipeRow);\n}\n\nexport async function createRecipe(recipe: Omit): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAMES.recipes} (id, name, source, url, tags, portions, tried, rating, notes, last_made, ingredients)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n recipe.id,\n recipe.name,\n recipe.source,\n recipe.url,\n JSON.stringify(recipe.tags),\n recipe.portions,\n recipe.tried ? 1 : 0,\n recipe.rating,\n recipe.notes,\n recipe.last_made,\n JSON.stringify(recipe.ingredients),\n ],\n });\n}\n\nexport async function updateRecipe(id: string, updates: Partial): Promise {\n const fields: string[] = [];\n const values: any[] = [];\n\n if (updates.name !== undefined) { fields.push(\"name = ?\"); values.push(updates.name); }\n if (updates.source !== undefined) { fields.push(\"source = ?\"); values.push(updates.source); }\n if (updates.url !== undefined) { fields.push(\"url = ?\"); values.push(updates.url); }\n if (updates.tags !== undefined) { fields.push(\"tags = ?\"); values.push(JSON.stringify(updates.tags)); }\n if (updates.portions !== undefined) { fields.push(\"portions = ?\"); values.push(updates.portions); }\n if (updates.tried !== undefined) { fields.push(\"tried = ?\"); values.push(updates.tried ? 1 : 0); }\n if (updates.rating !== undefined) { fields.push(\"rating = ?\"); values.push(updates.rating); }\n if (updates.notes !== undefined) { fields.push(\"notes = ?\"); values.push(updates.notes); }\n if (updates.last_made !== undefined) { fields.push(\"last_made = ?\"); values.push(updates.last_made); }\n if (updates.ingredients !== undefined) { fields.push(\"ingredients = ?\"); values.push(JSON.stringify(updates.ingredients)); }\n\n if (fields.length === 0) return;\n\n values.push(id);\n await sqlite.execute({\n sql: `UPDATE ${TABLE_NAMES.recipes} SET ${fields.join(\", \")} WHERE id = ?`,\n args: values,\n });\n}\n\nfunction parseRecipeRow(row: any): Recipe {\n return {\n id: row.id,\n name: row.name,\n source: row.source,\n url: row.url,\n tags: JSON.parse(row.tags || \"[]\"),\n portions: row.portions,\n tried: row.tried === 1,\n rating: row.rating,\n notes: row.notes,\n last_made: row.last_made,\n ingredients: JSON.parse(row.ingredients || \"[]\"),\n created_at: row.created_at,\n };\n}\n\n// ============ MEAL LOG ============\n\nexport async function getRecentMeals(days: number): Promise {\n const cutoffDate = new Date();\n cutoffDate.setDate(cutoffDate.getDate() - days);\n const dateStr = cutoffDate.toISOString().split(\"T\")[0];\n\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAMES.mealLog} WHERE date >= ? ORDER BY date DESC`,\n args: [dateStr],\n });\n return result.rows.map(parseMealLogRow);\n}\n\nexport async function logMeal(recipeId: string, date: string, notes?: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAMES.mealLog} (recipe_id, date, notes) VALUES (?, ?, ?)`,\n args: [recipeId, date, notes || null],\n });\n\n // Update last_made on recipe\n await sqlite.execute({\n sql: `UPDATE ${TABLE_NAMES.recipes} SET last_made = ? WHERE id = ?`,\n args: [date, recipeId],\n });\n}\n\nfunction parseMealLogRow(row: any): MealLogEntry {\n return {\n id: row.id,\n recipe_id: row.recipe_id,\n date: row.date,\n notes: row.notes,\n created_at: row.created_at,\n };\n}\n\n// ============ ALWAYS STOCKED ============\n\nexport async function getAlwaysStocked(): Promise {\n const result = await sqlite.execute(`SELECT item FROM ${TABLE_NAMES.alwaysStocked}`);\n return result.rows.map((row: any) => row.item);\n}\n\n// ============ MEAL PLANS ============\n\nexport async function getMealPlan(id: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAMES.mealPlans} WHERE id = ?`,\n args: [id],\n });\n return result.rows.length > 0 ? parseMealPlanRow(result.rows[0]) : null;\n}\n\nexport async function createMealPlan(plan: Omit): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAMES.mealPlans} (id, week_of, status, saturday_meal_1, saturday_meal_2, wednesday_meal, baby_meal_1, baby_meal_2, grocery_list)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n plan.id,\n plan.week_of,\n plan.status,\n plan.saturday_meal_1,\n plan.saturday_meal_2,\n plan.wednesday_meal,\n plan.baby_meal_1,\n plan.baby_meal_2,\n JSON.stringify(plan.grocery_list),\n ],\n });\n}\n\nexport async function updateMealPlan(id: string, updates: Partial): Promise {\n const fields: string[] = [];\n const values: any[] = [];\n\n if (updates.status !== undefined) { fields.push(\"status = ?\"); values.push(updates.status); }\n if (updates.saturday_meal_1 !== undefined) { fields.push(\"saturday_meal_1 = ?\"); values.push(updates.saturday_meal_1); }\n if (updates.saturday_meal_2 !== undefined) { fields.push(\"saturday_meal_2 = ?\"); values.push(updates.saturday_meal_2); }\n if (updates.wednesday_meal !== undefined) { fields.push(\"wednesday_meal = ?\"); values.push(updates.wednesday_meal); }\n if (updates.baby_meal_1 !== undefined) { fields.push(\"baby_meal_1 = ?\"); values.push(updates.baby_meal_1); }\n if (updates.baby_meal_2 !== undefined) { fields.push(\"baby_meal_2 = ?\"); values.push(updates.baby_meal_2); }\n if (updates.grocery_list !== undefined) { fields.push(\"grocery_list = ?\"); values.push(JSON.stringify(updates.grocery_list)); }\n if (updates.confirmed_at !== undefined) { fields.push(\"confirmed_at = ?\"); values.push(updates.confirmed_at); }\n\n if (fields.length === 0) return;\n\n values.push(id);\n await sqlite.execute({\n sql: `UPDATE ${TABLE_NAMES.mealPlans} SET ${fields.join(\", \")} WHERE id = ?`,\n args: values,\n });\n}\n\nfunction parseMealPlanRow(row: any): MealPlan {\n return {\n id: row.id,\n week_of: row.week_of,\n status: row.status,\n saturday_meal_1: row.saturday_meal_1,\n saturday_meal_2: row.saturday_meal_2,\n wednesday_meal: row.wednesday_meal,\n baby_meal_1: row.baby_meal_1,\n baby_meal_2: row.baby_meal_2,\n grocery_list: JSON.parse(row.grocery_list || \"[]\"),\n created_at: row.created_at,\n confirmed_at: row.confirmed_at,\n };\n}\n\n// ============ CONVERSATIONS ============\n\nexport async function getConversation(mealPlanId: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAMES.conversations} WHERE meal_plan_id = ? ORDER BY created_at ASC`,\n args: [mealPlanId],\n });\n return result.rows.map(parseConversationRow);\n}\n\nexport async function addMessage(mealPlanId: string, role: \"user\" | \"assistant\", content: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAMES.conversations} (meal_plan_id, role, content) VALUES (?, ?, ?)`,\n args: [mealPlanId, role, content],\n });\n}\n\nfunction parseConversationRow(row: any): ConversationMessage {\n return {\n id: row.id,\n meal_plan_id: row.meal_plan_id,\n role: row.role,\n content: row.content,\n created_at: row.created_at,\n };\n}\n","createdAt",["D",1768814885444],"branchVersion","branchId","e7fd5566-f508-11f0-ad2b-42dde27851f2","id","e7fd07dc-f508-11f0-ad2b-42dde27851f2","Forkcast",["D",1768807904911],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Weekly meal planning with Claude","imageUrl","c1581319-2055-4b96-8d90-df9e2ed84bb8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","9beaee1b-2364-4d5f-b79e-564cd78b2da0","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",31,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","maggieappleton","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2NuD5HJbuTw9MbEmMStA1YWKWK8.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":251,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":252,"_78":253,"_80":254,"_82":24},"tree",[175,180,184,185,186],"files",[175,176,177,178,179,180,181,182,183,184,185,186],"counts",{"_165":60,"_166":133,"_167":60,"_168":169,"_170":171},"contents",[124,125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":159,"_31":160,"_29":161,"_132":-5,"_40":41,"_39":162,"_134":149,"_37":163,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_132":-5,"_40":41,"_39":156,"_134":149,"_37":157,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_26":158},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":149,"_37":150,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_26":152},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":24,"_37":142,"_13":60,"_33":20,"_35":143,"_23":24,"_136":-5,"_26":144},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":60,"_33":34,"_35":103,"_23":24,"_136":-5,"_26":137},"e7ff8be2-f508-11f0-ad2b-42dde27851f2","main.ts","e7ff8c96-f508-11f0-ad2b-42dde27851f2","parentId",1,"latest",["D",1768807904924],"label",[130],"1e065226-f512-11f0-8f92-42dde27851f2","README.md","1e0652d0-f512-11f0-8f92-42dde27851f2",2,["D",1768811861017],"# Forkcast",[139],"27fa880e-f519-11f0-ae1f-42dde27851f2","shared","27fa88ae-f519-11f0-ae1f-42dde27851f2",5,true,["D",1768814884215],"directory",[146],"27bfa11c-f519-11f0-ae1f-42dde27851f2","frontend","27bfa1d0-f519-11f0-ae1f-42dde27851f2",3,["D",1768814883828],[154],"27e1d232-f519-11f0-ae1f-42dde27851f2","backend","27e1d318-f519-11f0-ae1f-42dde27851f2",4,["D",1768814884010],[160],"pulls","branches","forks","envVars",{"_172":148,"_174":60},"connections",{"_172":60,"_173":60},"count","unfilledCount","emptyCount",{"_42":159,"_31":160,"_29":161,"_132":-5,"_40":41,"_39":162,"_134":149,"_37":248,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":249,"_26":250},{"_42":243,"_31":242,"_29":238,"_132":161,"_40":41,"_39":244,"_134":149,"_37":245,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":246,"_26":247},{"_42":237,"_31":32,"_29":30,"_132":238,"_40":41,"_39":14,"_134":149,"_37":239,"_13":60,"_33":34,"_35":36,"_23":24,"_136":-5,"_188":240,"_26":241},{"_42":230,"_31":231,"_29":232,"_132":161,"_40":41,"_39":233,"_134":149,"_37":234,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":235,"_26":236},{"_42":223,"_31":224,"_29":225,"_132":161,"_40":41,"_39":226,"_134":149,"_37":227,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":228,"_26":229},{"_42":153,"_31":154,"_29":155,"_132":-5,"_40":41,"_39":156,"_134":149,"_37":220,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":221,"_26":222},{"_42":213,"_31":214,"_29":215,"_132":155,"_40":41,"_39":216,"_134":149,"_37":217,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":218,"_26":219},{"_42":205,"_31":206,"_29":207,"_132":155,"_40":41,"_39":208,"_134":149,"_37":209,"_13":60,"_33":20,"_35":210,"_23":24,"_136":-5,"_188":211,"_26":212},{"_42":197,"_31":198,"_29":199,"_132":155,"_40":41,"_39":200,"_134":149,"_37":201,"_13":60,"_33":34,"_35":202,"_23":24,"_136":-5,"_188":203,"_26":204},{"_42":145,"_31":146,"_29":147,"_132":-5,"_40":41,"_39":148,"_134":149,"_37":194,"_13":60,"_33":151,"_35":-5,"_23":24,"_136":-5,"_188":195,"_26":196},{"_42":138,"_31":139,"_29":140,"_132":-5,"_40":41,"_39":141,"_134":24,"_37":191,"_13":60,"_33":20,"_35":143,"_23":24,"_136":-5,"_188":192,"_26":193},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":187,"_13":60,"_33":34,"_35":103,"_23":24,"_136":-5,"_188":189,"_26":190},["D",1768807904924],"children",[],[130],["D",1768811861017],[],[139],["D",1768814884215],[],[146],"28ac3572-f519-11f0-b490-42dde27851f2","index.tsx","28ac3630-f519-11f0-b490-42dde27851f2",10,["D",1768814885379],"/** @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?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[154,198],"28b1cc6c-f519-11f0-85ec-42dde27851f2","index.html","28b1cd5c-f519-11f0-85ec-42dde27851f2",11,["D",1768814885413],"\n\n\n \n \n Forkcast - Meal Planning\n \n \n \n\n\n

\n \n\n\n",[],[154,206],"281a5760-f519-11f0-97a0-42dde27851f2","components","281a581e-f519-11f0-97a0-42dde27851f2",6,["D",1768814884421],[],[154,214],["D",1768814883828],[181,182,183],[154],"28908408-f519-11f0-baf1-42dde27851f2","services","289084b2-f519-11f0-baf1-42dde27851f2",9,["D",1768814885198],[],[160,224],"2856e220-f519-11f0-841c-42dde27851f2","routes","2856e2d4-f519-11f0-841c-42dde27851f2",8,["D",1768814884819],[],[160,231],"28b76672-f519-11f0-aef0-42dde27851f2","28364344-f519-11f0-ae1f-42dde27851f2",["D",1768814885444],[],[160,242,32],"database","28364268-f519-11f0-ae1f-42dde27851f2",7,["D",1768814884606],[177],[160,242],["D",1768814884010],[176,178,179],[160],["D",1768807904911],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":288,"_289":290,"_291":292,"_293":24,"_294":24,"_295":24,"_296":149,"_297":-5,"_298":-7,"_299":-7,"_300":60,"_301":24,"_302":24,"_303":-5,"_304":24,"_305":24,"_306":24,"_307":-5},"ENV",{"_259":260,"_261":262,"_263":84,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12