Forkcast - Meal Planning

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_266":267,"_268":269},"routes/_app.x.$handle.$name",{"_92":91,"_31":42,"_100":82,"_26":101,"_13":14,"_102":-5,"_11":103,"_104":105,"_106":107,"_108":109,"_110":111,"_20":-5,"_112":-5,"_113":-5,"_114":24,"_115":116,"_117":24,"_118":-5,"_119":-5,"_120":121},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_40":41,"_31":42,"_35":43,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":50,"_51":-5,"_18":52,"_53":-5,"_54":24,"_55":-5,"_56":-5,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":66,"_67":66,"_68":69,"_70":69,"_71":69,"_72":66,"_73":66,"_74":75,"_76":77,"_78":79,"_80":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":20,"_33":34,"_35":36,"_37":14,"_38":39,"_23":24},"previous","deleted",false,"deletedHere","path","deno.json","latestPath","fileId","28bd1f0e-f519-11f0-97a0-42dde27851f2","name","fileType","content","{\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}","createdAt",["D",1768814885414],"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",{"_92":91,"_99":95},"org",{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},"branch",{"_13":81,"_31":82,"_40":39,"_83":41,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":42,"_90":91},"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",{"_40":41,"_31":42,"_35":262,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":50,"_51":-5,"_18":52,"_53":-5,"_54":24,"_55":-5,"_56":-5,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":66,"_67":66,"_68":69,"_70":69,"_71":69,"_72":66,"_73":66,"_74":263,"_76":264,"_78":265,"_80":24},"tree",[178,183,187,188,189,190],"files",[178,179,180,181,182,183,184,185,186,187,188,189,190],"counts",{"_168":58,"_169":132,"_170":58,"_171":172,"_173":174},"contents",[122,123,124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_40":162,"_31":163,"_29":164,"_131":-5,"_38":39,"_37":165,"_133":139,"_35":166,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_26":167},{"_40":156,"_31":157,"_29":158,"_131":-5,"_38":39,"_37":159,"_133":139,"_35":160,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_26":161},{"_40":149,"_31":150,"_29":151,"_131":-5,"_38":39,"_37":152,"_133":139,"_35":153,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_26":155},{"_40":142,"_31":143,"_29":144,"_131":-5,"_38":39,"_37":145,"_133":24,"_35":146,"_13":58,"_32":20,"_33":147,"_23":24,"_136":-5,"_26":148},{"_40":138,"_31":27,"_29":30,"_131":-5,"_38":39,"_37":14,"_133":139,"_35":140,"_13":58,"_32":20,"_33":34,"_23":24,"_136":-5,"_26":141},{"_40":128,"_31":129,"_29":130,"_131":-5,"_38":39,"_37":132,"_133":24,"_35":134,"_13":58,"_32":135,"_33":101,"_23":24,"_136":-5,"_26":137},"e7ff8be2-f508-11f0-ad2b-42dde27851f2","main.ts","e7ff8c96-f508-11f0-ad2b-42dde27851f2","parentId",1,"latest",["D",1768807904924],"script","label",[129],"28bd1e32-f519-11f0-97a0-42dde27851f2",true,["D",1768814885414],[27],"1e065226-f512-11f0-8f92-42dde27851f2","README.md","1e0652d0-f512-11f0-8f92-42dde27851f2",2,["D",1768811861017],"# Forkcast",[143],"27fa880e-f519-11f0-ae1f-42dde27851f2","shared","27fa88ae-f519-11f0-ae1f-42dde27851f2",5,["D",1768814884215],"directory",[150],"27bfa11c-f519-11f0-ae1f-42dde27851f2","frontend","27bfa1d0-f519-11f0-ae1f-42dde27851f2",3,["D",1768814883828],[157],"27e1d232-f519-11f0-ae1f-42dde27851f2","backend","27e1d318-f519-11f0-ae1f-42dde27851f2",4,["D",1768814884010],[163],"pulls","branches","forks","envVars",{"_175":152,"_177":58},"connections",{"_175":58,"_176":58},"count","unfilledCount","emptyCount",{"_40":162,"_31":163,"_29":164,"_131":-5,"_38":39,"_37":165,"_133":139,"_35":259,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":260,"_26":261},{"_40":254,"_31":253,"_29":247,"_131":164,"_38":39,"_37":255,"_133":139,"_35":256,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":257,"_26":258},{"_40":244,"_31":245,"_29":246,"_131":247,"_38":39,"_37":248,"_133":139,"_35":249,"_13":58,"_32":135,"_33":250,"_23":24,"_136":-5,"_192":251,"_26":252},{"_40":237,"_31":238,"_29":239,"_131":164,"_38":39,"_37":240,"_133":139,"_35":241,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":242,"_26":243},{"_40":230,"_31":231,"_29":232,"_131":164,"_38":39,"_37":233,"_133":139,"_35":234,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":235,"_26":236},{"_40":156,"_31":157,"_29":158,"_131":-5,"_38":39,"_37":159,"_133":139,"_35":227,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":228,"_26":229},{"_40":220,"_31":221,"_29":222,"_131":158,"_38":39,"_37":223,"_133":139,"_35":224,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":225,"_26":226},{"_40":212,"_31":213,"_29":214,"_131":158,"_38":39,"_37":215,"_133":139,"_35":216,"_13":58,"_32":20,"_33":217,"_23":24,"_136":-5,"_192":218,"_26":219},{"_40":204,"_31":205,"_29":206,"_131":158,"_38":39,"_37":207,"_133":139,"_35":208,"_13":58,"_32":135,"_33":209,"_23":24,"_136":-5,"_192":210,"_26":211},{"_40":149,"_31":150,"_29":151,"_131":-5,"_38":39,"_37":152,"_133":139,"_35":201,"_13":58,"_32":154,"_33":-5,"_23":24,"_136":-5,"_192":202,"_26":203},{"_40":142,"_31":143,"_29":144,"_131":-5,"_38":39,"_37":145,"_133":24,"_35":198,"_13":58,"_32":20,"_33":147,"_23":24,"_136":-5,"_192":199,"_26":200},{"_40":138,"_31":27,"_29":30,"_131":-5,"_38":39,"_37":14,"_133":139,"_35":195,"_13":58,"_32":20,"_33":34,"_23":24,"_136":-5,"_192":196,"_26":197},{"_40":128,"_31":129,"_29":130,"_131":-5,"_38":39,"_37":132,"_133":24,"_35":191,"_13":58,"_32":135,"_33":101,"_23":24,"_136":-5,"_192":193,"_26":194},["D",1768807904924],"children",[],[129],["D",1768814885414],[],[27],["D",1768811861017],[],[143],["D",1768814884215],[],[150],"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",[],[157,205],"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",[],[157,213],"281a5760-f519-11f0-97a0-42dde27851f2","components","281a581e-f519-11f0-97a0-42dde27851f2",6,["D",1768814884421],[],[157,221],["D",1768814883828],[184,185,186],[157],"28908408-f519-11f0-baf1-42dde27851f2","services","289084b2-f519-11f0-baf1-42dde27851f2",9,["D",1768814885198],[],[163,231],"2856e220-f519-11f0-841c-42dde27851f2","routes","2856e2d4-f519-11f0-841c-42dde27851f2",8,["D",1768814884819],[],[163,238],"28b76672-f519-11f0-aef0-42dde27851f2","queries.ts","28b76762-f519-11f0-aef0-42dde27851f2","28364344-f519-11f0-ae1f-42dde27851f2",12,["D",1768814885444],"// 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",[],[163,253,245],"database","28364268-f519-11f0-ae1f-42dde27851f2",7,["D",1768814884606],[180],[163,253],["D",1768814884010],[179,181,182],[163],["D",1768807904911],{"_92":91,"_99":95},{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},{"_13":81,"_31":82,"_40":39,"_83":41,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":42,"_90":91},"ctx",{"_74":-5,"_119":299,"_300":301,"_302":303,"_304":24,"_305":24,"_306":24,"_307":139,"_308":-5,"_309":-7,"_310":-7,"_311":58,"_312":24,"_313":24,"_314":-5,"_315":24,"_316":24,"_317":24,"_318":-5},"ENV",{"_270":271,"_272":273,"_274":82,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298},"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 · v13