[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_95":94,"_31":43,"_104":85,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":57,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","core.tsx","latestPath","fileId","019f191f-26a4-751b-bc0a-586b3b461a12","name","fileType","http","content","/** Living Pantry — Val Town MVP\n * Single-file HTTP val: SQLite storage + Anthropic API (recipes + receipt OCR) + mobile UI.\n * Requires env var ANTHROPIC_API_KEY (set in val settings) for recipe generation & receipt scan.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst MODEL = \"claude-sonnet-4-6\";\nconst ANTHROPIC_URL = \"https://api.anthropic.com/v1/messages\";\n\n// ---------- DB ----------\nlet schemaReady = false;\nasync function ensureSchema() {\n if (schemaReady) return;\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS pantry (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n quantity REAL,\n unit TEXT,\n category TEXT,\n added_at TEXT,\n shelf_life_days INTEGER\n )`,\n `CREATE TABLE IF NOT EXISTS shopping (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n quantity REAL,\n unit TEXT,\n checked INTEGER DEFAULT 0,\n added_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS recipes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n tier TEXT,\n active_minutes INTEGER,\n total_minutes INTEGER,\n ingredients TEXT,\n steps TEXT,\n created_at TEXT\n )`,\n ]);\n schemaReady = true;\n}\n\nfunction rows(result: any): any[] {\n const cols = result.columns as string[];\n return (result.rows as any[][]).map((r) =>\n Object.fromEntries(cols.map((c, i) => [c, r[i]]))\n );\n}\n\nconst nowISO = () => new Date().toISOString();\nconst norm = (s: string) => (s || \"\").trim().toLowerCase();\n\n// ---------- Anthropic ----------\nasync function callClaude(opts: {\n system: string;\n content: any;\n maxTokens?: number;\n}): Promise {\n const key = Deno.env.get(\"ANTHROPIC_API_KEY\");\n if (!key) throw new Error(\"NO_API_KEY\");\n const res = await fetch(ANTHROPIC_URL, {\n method: \"POST\",\n headers: {\n \"content-type\": \"application/json\",\n \"x-api-key\": key,\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: MODEL,\n max_tokens: opts.maxTokens ?? 2000,\n system: opts.system,\n messages: [{ role: \"user\", content: opts.content }],\n }),\n });\n if (!res.ok) {\n const t = await res.text();\n throw new Error(\"ANTHROPIC_ERROR \" + res.status + \" \" + t.slice(0, 300));\n }\n const data = await res.json();\n return (data.content || [])\n .filter((b: any) => b.type === \"text\")\n .map((b: any) => b.text)\n .join(\"\\n\");\n}\n\nfunction parseJSON(text: string): any {\n let t = (text || \"\").trim();\n t = t.replace(/^```(?:json)?/i, \"\").replace(/```$/i, \"\").trim();\n const firstObj = t.search(/[\\[{]/);\n if (firstObj > 0) t = t.slice(firstObj);\n const lastClose = Math.max(t.lastIndexOf(\"}\"), t.lastIndexOf(\"]\"));\n if (lastClose >= 0) t = t.slice(0, lastClose + 1);\n return JSON.parse(t);\n}\n\n// ---------- helpers ----------\nconst json = (obj: any, status = 200) =>\n new Response(JSON.stringify(obj), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n\nconst safeParse = (s: any) => {\n try { return JSON.parse(s); } catch { return []; }\n};\n\nasync function getState() {\n const pantry = rows(await sqlite.execute(`SELECT * FROM pantry ORDER BY category, name`));\n const shopping = rows(await sqlite.execute(`SELECT * FROM shopping ORDER BY checked, name`));\n const recipes = rows(await sqlite.execute(`SELECT * FROM recipes ORDER BY created_at DESC`)).map(\n (r) => ({ ...r, ingredients: safeParse(r.ingredients), steps: safeParse(r.steps) })\n );\n const today = Date.now();\n for (const p of pantry) {\n if (p.added_at && p.shelf_life_days) {\n const ageDays = (today - Date.parse(p.added_at)) / 86400000;\n p.days_left = Math.round(p.shelf_life_days - ageDays);\n } else {\n p.days_left = null;\n }\n }\n return { pantry, shopping, recipes };\n}\n\n// ---------- main handler ----------\nexport default async function (req: Request): Promise {\n await ensureSchema();\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n\n try {\n if (path === \"/\" || path === \"\") {\n return new Response(HTML, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n }\n\n if (path === \"/api/state\" && method === \"GET\") {\n return json(await getState());\n }\n\n // ---- PANTRY ----\n if (path === \"/api/pantry\" && method === \"POST\") {\n const body = await req.json();\n const items = body.items || [];\n for (const it of items) await addOrMergePantry(it);\n return json(await getState());\n }\n if (path.startsWith(\"/api/pantry/\") && method === \"PATCH\") {\n const id = Number(path.split(\"/\").pop());\n const body = await req.json();\n await sqlite.execute({\n sql: `UPDATE pantry SET quantity = ?, unit = ? WHERE id = ?`,\n args: [body.quantity ?? null, body.unit ?? null, id],\n });\n return json(await getState());\n }\n if (path.startsWith(\"/api/pantry/\") && method === \"DELETE\") {\n const id = Number(path.split(\"/\").pop());\n await sqlite.execute({ sql: `DELETE FROM pantry WHERE id = ?`, args: [id] });\n return json(await getState());\n }\n\n // ---- RECIPES ----\n if (path === \"/api/recipes/generate\" && method === \"POST\") {\n const body = await req.json();\n return json(await generateRecipes(body.tier, body.note));\n }\n if (path === \"/api/recipes/save\" && method === \"POST\") {\n const r = (await req.json()).recipe;\n await sqlite.execute({\n sql: `INSERT INTO recipes (title, tier, active_minutes, total_minutes, ingredients, steps, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [r.title, r.tier || \"\", r.activeMinutes || 0, r.totalMinutes || 0,\n JSON.stringify(r.ingredients || []), JSON.stringify(r.steps || []), nowISO()],\n });\n return json(await getState());\n }\n if (path.startsWith(\"/api/recipes/\") && method === \"DELETE\") {\n const id = Number(path.split(\"/\").pop());\n await sqlite.execute({ sql: `DELETE FROM recipes WHERE id = ?`, args: [id] });\n return json(await getState());\n }\n if (path === \"/api/cook\" && method === \"POST\") {\n const r = (await req.json()).recipe;\n const deducted = await cookRecipe(r);\n return json({ deducted, state: await getState() });\n }\n\n // ---- SHOPPING ----\n if (path === \"/api/shopping\" && method === \"POST\") {\n const items = (await req.json()).items || [];\n for (const it of items) {\n await sqlite.execute({\n sql: `INSERT INTO shopping (name, quantity, unit, checked, added_at) VALUES (?, ?, ?, 0, ?)`,\n args: [it.name, it.quantity ?? null, it.unit ?? null, nowISO()],\n });\n }\n return json(await getState());\n }\n if (path.startsWith(\"/api/shopping/\") && method === \"PATCH\") {\n const id = Number(path.split(\"/\").pop());\n const body = await req.json();\n await sqlite.execute({\n sql: `UPDATE shopping SET checked = ? WHERE id = ?`,\n args: [body.checked ? 1 : 0, id],\n });\n return json(await getState());\n }\n if (path.startsWith(\"/api/shopping/\") && method === \"DELETE\") {\n const id = Number(path.split(\"/\").pop());\n await sqlite.execute({ sql: `DELETE FROM shopping WHERE id = ?`, args: [id] });\n return json(await getState());\n }\n if (path === \"/api/shopping/clear-checked\" && method === \"POST\") {\n await sqlite.execute(`DELETE FROM shopping WHERE checked = 1`);\n return json(await getState());\n }\n\n // ---- RECEIPT ----\n if (path === \"/api/receipt\" && method === \"POST\") {\n const body = await req.json();\n return json(await parseReceipt(body.image, body.mimeType || \"image/jpeg\"));\n }\n\n return json({ error: \"not found\", path }, 404);\n } catch (e) {\n const msg = String(e && e.message ? e.message : e);\n if (msg.includes(\"NO_API_KEY\")) {\n return json({ error: \"no_api_key\", message: \"Set ANTHROPIC_API_KEY in this val's environment variables to enable recipes and receipt scanning.\" }, 400);\n }\n return json({ error: \"server_error\", message: msg }, 500);\n }\n}\n\nasync function addOrMergePantry(it: any) {\n const existing = rows(await sqlite.execute({\n sql: `SELECT * FROM pantry WHERE lower(name) = ? AND ifnull(unit,'') = ifnull(?, '')`,\n args: [norm(it.name), it.unit ?? null],\n }));\n if (existing.length && typeof it.quantity === \"number\") {\n await sqlite.execute({\n sql: `UPDATE pantry SET quantity = ifnull(quantity,0) + ?, added_at = ? WHERE id = ?`,\n args: [it.quantity, nowISO(), existing[0].id],\n });\n } else if (existing.length) {\n await sqlite.execute({ sql: `UPDATE pantry SET added_at = ? WHERE id = ?`, args: [nowISO(), existing[0].id] });\n } else {\n await sqlite.execute({\n sql: `INSERT INTO pantry (name, quantity, unit, category, added_at, shelf_life_days) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [it.name, it.quantity ?? null, it.unit ?? null, it.category ?? null, nowISO(), it.shelf_life_days ?? null],\n });\n }\n}\n\nasync function generateRecipes(tier: string, note: string) {\n const pantry = rows(await sqlite.execute(`SELECT name, quantity, unit FROM pantry`));\n const tierGuide: Record = {\n quick: \"QUICK: hands-on (active) time at most 15 minutes. Minimal chopping/steps. OK if total time is longer due to hands-off waiting.\",\n moderate: \"MODERATE: active time roughly 15-35 minutes.\",\n involved: \"INVOLVED: active time may exceed 35 minutes; more technique and components allowed.\",\n };\n const system =\n \"You are a recipe generator for a pantry app. Given a user's pantry, propose exactly 3 distinct recipes at the requested effort tier. \" +\n \"Tier is defined by ACTIVE (hands-on) time, not total clock time. \" + (tierGuide[tier] || tierGuide.moderate) + \" \" +\n \"Assume these staples are always on hand: salt, pepper, cooking oil, butter, water, common dried spices. \" +\n \"Prefer recipes that use what's in the pantry. You MAY include up to 3 items the user must buy (put them in needToBuy). \" +\n \"Respond with ONLY valid JSON, no prose, no markdown. Schema: \" +\n '{\"recipes\":[{\"title\":string,\"tier\":string,\"activeMinutes\":number,\"totalMinutes\":number,' +\n '\"ingredients\":[{\"name\":string,\"quantity\":number,\"unit\":string}],' +\n '\"needToBuy\":[{\"name\":string,\"quantity\":number,\"unit\":string}],\"steps\":[string]}]}';\n const userMsg =\n \"Pantry: \" + JSON.stringify(pantry) + \"\\nTier: \" + tier +\n (note ? \"\\nUser note: \" + note : \"\") +\n \"\\nReturn 3 recipes as JSON.\";\n const text = await callClaude({ system, content: userMsg, maxTokens: 3000 });\n const parsed = parseJSON(text);\n return { recipes: parsed.recipes || [] };\n}\n\nasync function cookRecipe(r: any) {\n const pantry = rows(await sqlite.execute(`SELECT * FROM pantry`));\n const deducted: string[] = [];\n for (const ing of (r.ingredients || [])) {\n const match = pantry.find((p) => norm(p.name) === norm(ing.name) ||\n norm(p.name).includes(norm(ing.name)) || norm(ing.name).includes(norm(p.name)));\n if (!match) continue;\n if (typeof match.quantity === \"number\" && typeof ing.quantity === \"number\" &&\n norm(match.unit) === norm(ing.unit)) {\n const newQty = match.quantity - ing.quantity;\n if (newQty <= 0) {\n await sqlite.execute({ sql: `DELETE FROM pantry WHERE id = ?`, args: [match.id] });\n deducted.push(match.name + \" (used up)\");\n } else {\n await sqlite.execute({ sql: `UPDATE pantry SET quantity = ? WHERE id = ?`, args: [newQty, match.id] });\n deducted.push(match.name + \" (-\" + ing.quantity + \" \" + (ing.unit || \"\") + \")\");\n }\n } else {\n deducted.push(match.name + \" (used)\");\n }\n }\n return deducted;\n}\n\nasync function parseReceipt(imageB64: string, mimeType: string) {\n const system =\n \"You read a photographed grocery receipt and extract food/grocery items for a pantry inventory. \" +\n \"Normalize cryptic abbreviations to clear canonical food names (e.g. 'GV SHRD CHS' -> 'Shredded cheddar cheese'). \" +\n \"For each item estimate quantity and unit if inferable from the line; if package size is unknown, set quantity to 1 and unit to 'pkg'. \" +\n \"Assign a category (produce, dairy, meat, seafood, bakery, frozen, pantry, beverage, snack, other) and an estimated shelf_life_days. \" +\n \"Skip non-food lines: totals, tax, subtotal, payment, change, loyalty, bags. \" +\n \"Respond with ONLY valid JSON, no prose. Schema: \" +\n '{\"items\":[{\"name\":string,\"quantity\":number,\"unit\":string,\"category\":string,\"shelf_life_days\":number,\"rawLine\":string}]}';\n const content = [\n { type: \"image\", source: { type: \"base64\", media_type: mimeType, data: imageB64 } },\n { type: \"text\", text: \"Extract the grocery items from this receipt as JSON.\" },\n ];\n const text = await callClaude({ system, content, maxTokens: 2500 });\n const parsed = parseJSON(text);\n return { items: parsed.items || [] };\n}\n\n// =================== FRONTEND ===================\nconst HTML = `\n\n\n\n\n\nPantry\n\n\n\n

Your Pantry

\n\n

\n \n \n

\n \n

Quick-add staples

Tap to add common items.

\n\n

\n What do you feel like cooking?\n

Effort is based on hands-on time.

\n Quick\n Moderate\n Involved\n

\n \n \n

Saved recipes

\n\n

\n \n \n

\n \n

\n\n\n\n\n

\n\n\n\n`;\n","createdAt",["D",1782832899752],"branchVersion","branchId","bbed7776-5d27-11f1-8314-1607ee4eb77e","id","bbecafbc-5d27-11f1-8314-1607ee4eb77e","pantry",["D",1780256066315],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Living pantry: receipt scan, recipe generation, shopping list","imageUrl","019c452d-eb8d-7124-ac84-fd3eee7429af","pinnedFileId","d022c0ca-7497-11f1-8760-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019c452d-eb8d-7124-ac85-003287cdb181","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":53,"_100":101,"_102":24},"branch",{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"isOwned",8,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","wohara010","handle","displayName","Billy","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/189d5be3-0aea-450f-0b6c-366cb482cb00/square512?exp=1789590541&sig=bb7fc820f7ba3566548d88d729702c9a4d8bfcca00ec0caeab2361ae7c47f024","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":160,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":161,"_79":162,"_81":163,"_83":24},"tree",[151,152],"files",[151,152],"counts",{"_141":61,"_142":135,"_143":61,"_144":145,"_146":147},"contents",[126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":138,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_133":24,"_36":139,"_13":61,"_32":33,"_34":35,"_23":24,"_136":-5,"_26":140},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":24,"_36":134,"_13":135,"_32":33,"_34":35,"_23":24,"_136":-5,"_26":137},"795bdc70-5d47-11f1-8cc6-1607ee4eb77e","main.tsx","bbf2274e-5d27-11f1-8314-1607ee4eb77e","parentId",2,"latest",["D",1780269698517],1,"label",[129],"d7afde12-d7d0-4c6c-a9cf-46d283fdc049",["D",1782832899752],[27],"pulls","branches","forks","envVars",{"_148":61,"_150":61},"connections",{"_148":61,"_149":61},"count","unfilledCount","emptyCount",{"_41":138,"_31":27,"_29":30,"_131":-5,"_39":40,"_38":14,"_133":24,"_36":157,"_13":61,"_32":33,"_34":35,"_23":24,"_136":-5,"_154":158,"_26":159},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":24,"_36":153,"_13":135,"_32":33,"_34":35,"_23":24,"_136":-5,"_154":155,"_26":156},["D",1780269698517],"children",[],[129],["D",1782832899752],[],[27],["D",1780256066315],{"_95":94,"_103":99},{"_95":94,"_96":97,"_98":99,"_18":53,"_100":101,"_102":24},{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"ctx",{"_77":-5,"_123":197,"_198":199,"_200":201,"_202":24,"_203":24,"_204":24,"_205":57,"_206":-5,"_207":-7,"_208":-7,"_209":61,"_210":24,"_211":24,"_212":-5,"_213":24,"_214":24,"_215":24,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":85,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"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 · v3