[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4207e8ad4ddbe7f6e8b804339ca1b2ec4ab76c50","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_171":172,"_173":-5},"handle","maggieappleton","name","Forkcast","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","e7fd07dc-f508-11f0-ad2b-42dde27851f2","createdAt",["D",1768807904911],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c1581319-2055-4b96-8d90-df9e2ed84bb8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","9beaee1b-2364-4d5f-b79e-564cd78b2da0","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2NuD5HJbuTw9MbEmMStA1YWKWK8.jpeg","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",29,"e7fd5566-f508-11f0-ad2b-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"28b76672-f519-11f0-aef0-42dde27851f2","queries.ts","fileId","28b76762-f519-11f0-aef0-42dde27851f2","parentId","28364344-f519-11f0-ae1f-42dde27851f2","branchId","branchVersion",12,"latest",true,["D",1768814885444],"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","deleted","label",[169,170,151],"backend","database","permalink","https://www.val.town/x/maggieappleton/Forkcast/code/backend/database/queries.ts","extension","actionData","errors"]