[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_168":169,"_170":171},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_105":88,"_27":52,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":26,"_119":120,"_121":24,"_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",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":26},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","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 = [\n \"List\",\"Inventory\",\"Notes\",\"PrivateNotes\",\"Purchase\",\"Pending\",\n \"Consumed\",\"Availability\",\"Tag\",\"ProReview\",\"Bottles\",\"FoodTags\"\n];\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","createdAt",["D",1781268357907],"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",{"_98":97,"_104":52},"org",{"_98":97,"_99":52,"_100":52,"_18":54,"_101":102,"_103":26},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kobsen","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":163,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":164,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":165,"_82":166,"_84":167,"_86":26},"tree",[154,155],"files",[154,155],"counts",{"_142":61,"_143":144,"_145":61,"_146":147,"_148":149},"contents",[126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":139,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_132":26,"_37":140,"_13":61,"_33":34,"_35":36,"_23":26,"_137":-5,"_27":141},{"_42":128,"_32":129,"_30":56,"_130":-5,"_40":41,"_39":131,"_132":26,"_37":133,"_13":134,"_33":135,"_35":136,"_23":26,"_137":-5,"_27":138},"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",[129],"fc811ddb-14f9-4fe6-bf14-4edf65e3a6d0",["D",1781268357907],[28],"pulls","branches",1,"forks","envVars",{"_150":152,"_153":61},"connections",{"_150":61,"_151":61},"count","unfilledCount",3,"emptyCount",{"_42":139,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_132":26,"_37":160,"_13":61,"_33":34,"_35":36,"_23":26,"_137":-5,"_157":161,"_27":162},{"_42":128,"_32":129,"_30":56,"_130":-5,"_40":41,"_39":131,"_132":26,"_37":156,"_13":134,"_33":135,"_35":136,"_23":26,"_137":-5,"_157":158,"_27":159},["D",1781214410669],"children",[],[129],["D",1781268357907],[],[28],["D",1781213251655],["D",1789503703835],{"_98":97,"_104":52},{"_98":97,"_99":52,"_100":52,"_18":54,"_101":102,"_103":26},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_123":201,"_202":203,"_204":205,"_206":26,"_207":26,"_208":26,"_209":24,"_210":-5,"_211":-7,"_212":-7,"_213":61,"_214":26,"_215":26,"_216":-5,"_217":26,"_218":26,"_219":26,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":88,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"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 · v7