[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_171":172,"_173":174},"routes/_app.x.$handle.$name",{"_100":99,"_33":46,"_107":90,"_28":54,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":27,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":27},"version",9,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","_analyze.ts","latestPath","fileId","a8bc7e48-665c-11f1-8aa6-1607ee4eb77e","name","fileType","script","content","const CT_USER = Deno.env.get(\"CT_USER\")!;\nconst CT_PASSWORD = Deno.env.get(\"CT_PASSWORD\")!;\n\nconst TABLES = [\"Notes\",\"PrivateNotes\",\"Purchase\",\"Pending\",\"Consumed\",\"Availability\",\"Tag\",\"ProReview\",\"Bottles\",\"FoodTags\"];\n\nasync function ctTable(table: string) {\n const url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab&Location=1&Table=${table}`;\n const res = await fetch(url);\n if (!res.ok) return { table, error: res.status };\n const text = (await res.text()).trim();\n if (!text) return { table, rows: 0, columns: [] };\n const lines = text.split(\"\\n\").map(l => l.split(\"\\t\"));\n const header = lines.shift()!.map(h => h.trim());\n const rows = lines.map(cells =>\n Object.fromEntries(header.map((h, i) => [h, (cells[i] ?? \"\").trim()]))\n );\n return { table, rows: rows.length, columns: header, sample: rows.slice(0, 2) };\n}\n\nconst results = await Promise.all(TABLES.map(ctTable));\nconsole.log(JSON.stringify(results, null, 2));\n","const CT_USER = Deno.env.get(\"CT_USER\")!;\nconst CT_PASSWORD = Deno.env.get(\"CT_PASSWORD\")!;\n\nconst TABLES = [\"Consumed\",\"Availability\",\"Tag\",\"ProReview\",\"Bottles\",\"FoodTags\"];\n\nasync function ctTable(table: string) {\n const url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab&Location=1&Table=${table}`;\n const res = await fetch(url);\n if (!res.ok) return { table, error: res.status };\n const text = (await res.text()).trim();\n if (!text) return { table, rows: 0, columns: [] };\n const lines = text.split(\"\\n\").map(l => l.split(\"\\t\"));\n const header = lines.shift()!.map(h => h.trim());\n const rows = lines.length;\n const sample = lines.slice(0, 1).map(cells =>\n Object.fromEntries(header.map((h, i) => [h, (cells[i] ?? \"\").trim()]))\n );\n return { table, rows, columns: header, sample };\n}\n\nconst results = await Promise.all(TABLES.map(ctTable));\n// Log one table at a time to avoid truncation\nfor (const r of results) console.log(JSON.stringify(r));\n","createdAt",["D",1781268483469],"branchVersion","branchId","36cfc87c-a4c8-49b5-bf14-074e4bd3255c","id","e48085b0-9b92-431e-96e8-2a32f9cd22e3","cellar-tracker",["D",1781213251655],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","48a2156b-e1a5-4055-b03d-dccd0fb6681f","pinnedFileId","5ae1a8cc-65dc-11f1-9887-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019eb890-6dc0-7559-bd59-1875b0fc637d","tursoName","e48085b09b92431e96e82a32f9cd22e3","tursoHostname","e48085b09b92431e96e82a32f9cd22e3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789503703835],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_106":54},"org",{"_100":99,"_101":54,"_102":54,"_18":56,"_103":104,"_105":27},"branch",{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kobsen","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_33":46,"_39":166,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":167,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":168,"_84":169,"_86":170,"_88":27},"tree",[157,158],"files",[157,158],"counts",{"_145":63,"_146":147,"_148":63,"_149":150,"_151":152},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":141,"_33":29,"_31":32,"_132":-5,"_42":43,"_41":14,"_134":27,"_39":142,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_28":144},{"_44":130,"_33":131,"_31":58,"_132":-5,"_42":43,"_41":133,"_134":27,"_39":135,"_13":136,"_34":137,"_36":138,"_24":27,"_139":-5,"_28":140},"b0fdb597-551d-497f-881e-5c97aa5ea232","main.ts","parentId",6,"latest",["D",1781214410669],5,"http","// Val Town HTTP val — serves an aggregated, cleaned view of the cellar as JSON.\n//\n// Setup (all in the Val Town UI — no infra):\n// 1. New val → HTTP val → paste this in.\n// 2. Settings → Environment Variables, add:\n// CT_USER your CellarTracker handle (kobsen)\n// CT_PASSWORD your CellarTracker password\n// CELLAR_TOKEN any long random string — guards this URL\n// 3. Save. Val Town gives you a URL like https://-cellar.web.val.run\n// 4. Read it at https://-cellar.web.val.run?token=YOUR_TOKEN\n//\n// No cron needed: it fetches live on each request, so the data is always current.\n// Reads are occasional and CellarTracker responds fast, so this stays simple.\n\nconst CT_USER = Deno.env.get(\"CT_USER\")!;\nconst CT_PASSWORD = Deno.env.get(\"CT_PASSWORD\")!;\nconst CELLAR_TOKEN = Deno.env.get(\"CELLAR_TOKEN\")!;\nconst YEAR = new Date().getFullYear();\n\n// Fetch one CellarTracker table as array-of-objects. Tab-delimited = trivial,\n// robust parsing (no field ever contains a tab, unlike commas in wine names).\nasync function ctTable(table: string): Promise[]> {\n const url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab&Location=1&Table=${table}`;\n const res = await fetch(url);\n if (!res.ok) {\n throw new Error(`CellarTracker ${table} fetch failed: ${res.status}`);\n }\n const lines = (await res.text()).trim().split(\"\\n\").map((l) => l.split(\"\\t\"));\n const header = lines.shift()!.map((h) => h.trim());\n return lines.map((cells) =>\n Object.fromEntries(header.map((h, i) => [h, (cells[i] ?? \"\").trim()]))\n );\n}\n\nconst num = (v: string) => {\n const n = parseFloat(v);\n return isFinite(n) ? n : 0;\n};\n\n// Compare Begin/End (years) to today, per the cellar's own rules.\nfunction drinkStatus(begin: string, end: string): string {\n const b = parseInt(begin), e = parseInt(end);\n if (e && YEAR > e) return \"past peak\"; // window already closed\n if (b && YEAR < b) return \"hold\"; // not open yet\n if (b || e) return \"ready\"; // in window\n return \"unknown\"; // no window recorded → estimate elsewhere\n}\n\nexport default async function (req: Request): Promise {\n if (new URL(req.url).searchParams.get(\"token\") !== CELLAR_TOKEN) {\n return new Response(\"Forbidden\", { status: 403 });\n }\n\n // The three tables the recommendation logic actually uses.\n const [list, notes, consumed] = await Promise.all([\n ctTable(\"List\"), // current inventory — one row per wine per location\n ctTable(\"Notes\"), // personal tasting notes (Rating 0–100)\n ctTable(\"Consumed\"), // drinking history\n ]);\n\n // --- palate model: average personal Rating by MasterVarietal -------------\n // Includes wines no longer in stock — it models taste, not inventory.\n const varAgg: Record = {};\n const wineAgg: Record = {};\n for (const n of notes) {\n const r = num(n.Rating);\n if (!r) continue;\n const v = n.MasterVarietal || n.Varietal || \"Unknown\";\n varAgg[v] ??= { sum: 0, n: 0 };\n varAgg[v].sum += r;\n varAgg[v].n++;\n wineAgg[n.iWine] ??= { sum: 0, n: 0 };\n wineAgg[n.iWine].sum += r;\n wineAgg[n.iWine].n++;\n }\n const palate = Object.fromEntries(\n Object.entries(varAgg).map(([v, a]) => [v, +(a.sum / a.n).toFixed(1)]),\n );\n\n // --- last-consumed date per wine (for repeat-fatigue checks) --------------\n const lastConsumed: Record = {};\n for (const c of consumed) {\n const prev = lastConsumed[c.iWine];\n if (!prev || new Date(c.Consumed) > new Date(prev)) {\n lastConsumed[c.iWine] = c.Consumed;\n }\n }\n\n // --- aggregate inventory by iWine + Vintage, keep per-location detail -----\n const wines: Record = {};\n for (const w of list) {\n const key = `${w.iWine}|${w.Vintage}`;\n const price = num(w.Price);\n const rec = (wines[key] ??= {\n iWine: w.iWine,\n wine: w.Wine,\n producer: w.Producer,\n vintage: w.Vintage, // \"N.V.\" preserved as-is\n type: w.Type,\n category: w.Category,\n varietal: w.MasterVarietal || w.Varietal,\n designation: w.Designation || \"\",\n price, // 0 = gift / unrecorded, NOT cheap\n isGift: price === 0,\n begin: w.Begin || \"\",\n end: w.End || \"\",\n drinkStatus: drinkStatus(w.Begin, w.End),\n rating: null as number | null,\n ratingSource: null as string | null, // \"personal\" | \"varietal-avg\"\n lastConsumed: lastConsumed[w.iWine] ?? null,\n qty: 0,\n locations: [] as { location: string; bin: string; qty: number }[],\n });\n rec.qty += num(w.Quantity);\n rec.locations.push({\n location: w.Location,\n bin: w.Bin,\n qty: num(w.Quantity),\n });\n }\n\n // Attach a rating: this wine's own notes if any, else its varietal average.\n for (const w of Object.values(wines)) {\n if (wineAgg[w.iWine]) {\n w.rating = +(wineAgg[w.iWine].sum / wineAgg[w.iWine].n).toFixed(1);\n w.ratingSource = \"personal\";\n } else if (palate[w.varietal] != null) {\n w.rating = palate[w.varietal];\n w.ratingSource = \"varietal-avg\";\n }\n }\n\n // --- priciest-10% threshold (priced bottles only; €0 gifts excluded) ------\n const priced = Object.values(wines).map((w) => w.price).filter((p) => p > 0)\n .sort((a, b) => a - b);\n const splurgeThreshold = priced.length\n ? priced[Math.floor(priced.length * 0.9)]\n : null;\n\n return Response.json({\n generatedAt: new Date().toISOString(),\n year: YEAR,\n summary: {\n bottleCount: Object.values(wines).reduce((s, w) => s + w.qty, 0),\n distinctWines: Object.keys(wines).length,\n palateAveragesByVarietal: palate,\n splurgeThreshold, // wines priced above this are the top ~10% — hold for occasions\n },\n wines: Object.values(wines).sort((a, b) =>\n (b.rating ?? 0) - (a.rating ?? 0)\n ),\n },\n { headers: { \"Cache-Control\": \"no-store\" } });\n}","label",[131],"9f26888e-e885-4d22-a8d1-1698c46e06ce",["D",1781268483469],2,[29],"pulls","branches",1,"forks","envVars",{"_153":155,"_156":63},"connections",{"_153":63,"_154":63},"count","unfilledCount",3,"emptyCount",{"_44":141,"_33":29,"_31":32,"_132":-5,"_42":43,"_41":14,"_134":27,"_39":163,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_160":164,"_28":165},{"_44":130,"_33":131,"_31":58,"_132":-5,"_42":43,"_41":133,"_134":27,"_39":159,"_13":136,"_34":137,"_36":138,"_24":27,"_139":-5,"_160":161,"_28":162},["D",1781214410669],"children",[],[131],["D",1781268483469],[],[29],["D",1781213251655],["D",1789503703835],{"_100":99,"_106":54},{"_100":99,"_101":54,"_102":54,"_18":56,"_103":104,"_105":27},{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_125":204,"_205":206,"_207":208,"_209":27,"_210":27,"_211":27,"_212":25,"_213":-5,"_214":-7,"_215":-7,"_216":63,"_217":27,"_218":27,"_219":-5,"_220":27,"_221":27,"_222":27,"_223":-5},"ENV",{"_175":176,"_177":178,"_179":90,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203},"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 · v9