[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_106":89,"_27":53,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":58,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",52,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","5ae1a8cc-65dc-11f1-9887-1607ee4eb77e","name","fileType","http","content","// Cellar API — one HTTP val, three views.\n// Views: cellar (default), history, debug\n// Auth: ?token= on every request.\n// Encoding: CellarTracker serves Windows-1252; decoded explicitly below.\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\")!;\n\nconst TODAY = new Date();\nconst YEAR = TODAY.getFullYear();\n\n// ── Tiny helpers ──────────────────────────────────────────────────────────────\n\nconst num = (v: string) => {\n const n = parseFloat(v);\n return isFinite(n) ? n : 0;\n};\nconst clean = (v = \"\") => (v === \"Unknown\" ? \"\" : v);\nconst mapVintage = (v: string) => (v === \"1001\" ? \"N.V.\" : v);\n\nfunction abbrevLoc(s: string): string {\n if (!s || s === \"Unknown\") return \"\";\n return s.replace(\"Wine Fridge\", \"Fridge\").replace(\"Wine Wall\", \"Wall\");\n}\n\n// M/D/YYYY → YYYY-MM-DD (avoids timezone-shift of new Date())\nfunction isoDate(s: string): string {\n const m = s.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n return m ? `${m[3]}-${m[1].padStart(2, \"0\")}-${m[2].padStart(2, \"0\")}` : s;\n}\n\nfunction monthsSince(d: Date): number {\n return (TODAY.getFullYear() - d.getFullYear()) * 12 +\n (TODAY.getMonth() - d.getMonth());\n}\n\n// Build one TSV row; scrubs tabs/newlines from every cell value.\nfunction tsvRow(...vals: (string | number | null | undefined)[]): string {\n return vals.map((v) => (v == null ? \"\" : String(v).replace(/[\\t\\r\\n]/g, \" \")))\n .join(\"\\t\");\n}\n\n// Pro reviews run long; collapse whitespace and cap for the TSV.\nconst PRO_NOTE_MAX = 600;\n\nfunction truncate(s: string, max: number): string {\n const one = s.replace(/\\s+/g, \" \").trim();\n return one.length <= max ? one : one.slice(0, max - 1).trimEnd() + \"…\";\n}\n\n// ctTable throws on zero rows, which is the right default but wrong for the\n// optional tables — most cellars have no PrivateNotes and few ProReviews.\nconst EMPTY_TABLE = (): CtResult => ({ header: [], rows: [], skipped: 0 });\n\n// ── Drink-window column detection ─────────────────────────────────────────────\n\nfunction detectWindowCols(\n header: string[],\n): { begin: string | null; end: string | null } {\n for (\n const [b, e] of [\n [\"BeginConsume\", \"EndConsume\"],\n [\"Begin\", \"End\"],\n [\"Drink From\", \"Drink To\"],\n [\"CTBeginConsume\", \"CTEndConsume\"],\n ] as [string, string][]\n ) {\n if (header.includes(b) && header.includes(e)) return { begin: b, end: e };\n }\n return { begin: null, end: null };\n}\n\nfunction drinkStatus(begin: string, end: string): string {\n if (!begin && !end) return \"\";\n const b = parseInt(begin), e = parseInt(end);\n if (e && YEAR > e) return \"past\";\n if (b && YEAR < b) return \"hold\";\n return \"ready\";\n}\n\ntype TempStatus = \"ready\" | \"nearReady\" | \"notReady\";\n\ntype WineLocation = {\n location: string;\n rawLocation: string;\n bin: string;\n qty: number;\n};\n\nfunction temperatureStatus(\n type: string,\n locations: WineLocation[],\n): TempStatus {\n const isColdStyle = /white|sparkling|ros[eé]/i.test(type);\n const isRedStyle = /red/i.test(type) && !isColdStyle;\n\n const isActualFridge = (l: WineLocation) => /^fridge$/i.test(l.rawLocation);\n const isWineFridge = (l: WineLocation) =>\n /^wine fridge$/i.test(l.rawLocation);\n const isWhiteBin = (l: WineLocation) => /^white\\b/i.test(l.bin);\n const isRedBin = (l: WineLocation) => /^red\\b/i.test(l.bin);\n const isAnyFridge = (l: WineLocation) => isActualFridge(l) || isWineFridge(l);\n\n const onTemp = locations.some((l) => {\n if (isColdStyle) {\n return isActualFridge(l) || (isWineFridge(l) && isWhiteBin(l));\n }\n if (isRedStyle) return isWineFridge(l) && isRedBin(l);\n return false;\n });\n if (onTemp) return \"ready\";\n\n // Any fridge placement that is not ideal is still closer to serving temp than\n // wine wall / cellar / outside storage.\n const nearServing = locations.some(isAnyFridge);\n\n return nearServing ? \"nearReady\" : \"notReady\";\n}\n\nfunction priceCategory(\n price: number | null,\n isGift: boolean,\n type: string,\n appellation: string,\n designation: string,\n cellarP50: number,\n cellarP90: number,\n): string {\n if (price == null) return \"Unknown\";\n\n // Base tier from absolute price\n let tier = price >= 40 ? 4 : price >= 20 ? 3 : price >= 10 ? 2 : 1;\n\n // Signal 1 — Champagne AOC sparkling: prestige bump regardless of price\n if (/sparkling/i.test(type) && /champagne/i.test(appellation) && tier < 4) {\n tier++;\n }\n\n // Signal 2 — top 10% of this cellar's price distribution: clearly premium here\n if (price >= cellarP90 && tier < 4) tier++;\n\n // Signal 3 — named designation + above-median price: above generic in same band\n if (designation && price >= cellarP50 && tier === 2) tier++;\n\n return ([\"\", \"Cheap\", \"Average\", \"Expensive\", \"Splurge\"] as const)[\n Math.min(4, Math.max(1, tier))\n ];\n}\n\n// ── CT fetch ──────────────────────────────────────────────────────────────────\n\ninterface CtResult {\n header: string[];\n rows: Record[];\n skipped: number;\n}\n\nasync function ctTable(table: string, location = false): Promise {\n const url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab${location ? \"&Location=1\" : \"\"}` +\n `&Table=${table}`;\n\n const res = await fetch(url);\n if (!res.ok) {\n throw Object.assign(new Error(`HTTP ${res.status} fetching ${table}`), {\n table,\n hint: \"check CT_USER / CT_PASSWORD\",\n });\n }\n\n const buf = await res.arrayBuffer();\n const text = new TextDecoder(\"windows-1252\").decode(buf).trim();\n\n if (/ h.trim());\n let skipped = 0;\n const rows: Record[] = [];\n for (const line of dataLines) {\n if (!line.trim()) continue;\n const cells = line.split(\"\\t\");\n if (cells.length < Math.ceil(header.length / 2)) {\n skipped++;\n continue;\n }\n rows.push(\n Object.fromEntries(header.map((h, i) => [h, (cells[i] ?? \"\").trim()])),\n );\n }\n\n if (rows.length === 0) {\n throw Object.assign(new Error(`0 data rows from ${table}`), {\n table,\n hint: \"check CT_USER / CT_PASSWORD\",\n });\n }\n\n return { header, rows, skipped };\n}\n\n// ── Constants ─────────────────────────────────────────────────────────────────\n\nconst HDRS = { \"Cache-Control\": \"no-store\" };\nconst PLAIN = { ...HDRS, \"Content-Type\": \"text/plain; charset=utf-8\" };\nconst VALID_VIEWS = [\"cellar\", \"history\", \"debug\"] as const;\n\n// ── Handler ───────────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request): Promise {\n const u = new URL(req.url);\n\n if (u.searchParams.get(\"token\") !== CELLAR_TOKEN) {\n return new Response(\"Forbidden\", { status: 403 });\n }\n\n const view = (u.searchParams.get(\"view\") ?? \"cellar\") as string;\n const asJson = u.searchParams.get(\"format\") === \"json\";\n\n if (!(VALID_VIEWS as readonly string[]).includes(view)) {\n return Response.json(\n { error: `Unknown view \"${view}\". Valid: ${VALID_VIEWS.join(\", \")}` },\n { status: 400, headers: HDRS },\n );\n }\n\n try {\n // ── DEBUG ────────────────────────────────────────────────────────────────\n if (view === \"debug\") {\n const tables = [\n \"List\",\n \"Notes\",\n \"PrivateNotes\",\n \"Consumed\",\n \"Purchase\",\n \"ProReview\",\n ];\n const info: Record = {};\n let windowMapping: unknown = null;\n for (const t of tables) {\n try {\n const { header, rows, skipped } = await ctTable(t, t === \"List\");\n info[t] = { columns: header, rows: rows.length, skipped };\n if (t === \"List\") windowMapping = detectWindowCols(header);\n } catch (e: unknown) {\n info[t] = { error: (e as Error).message };\n }\n }\n return Response.json(\n { tables: info, drinkWindowMapping: windowMapping },\n { headers: HDRS },\n );\n }\n\n // ── HISTORY ──────────────────────────────────────────────────────────────\n if (view === \"history\") {\n const { rows: consumed } = await ctTable(\"Consumed\");\n consumed.sort((a, b) =>\n new Date(b.Consumed).getTime() - new Date(a.Consumed).getTime()\n );\n\n const DAYS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n const MONTHS = [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\",\n ];\n const dayCounts = Object.fromEntries(DAYS.map((d) => [d, 0])) as Record<\n string,\n number\n >;\n const moCounts = Object.fromEntries(MONTHS.map((m) => [m, 0])) as Record<\n string,\n number\n >;\n let wsCount = 0;\n const wineFreq: Record<\n string,\n { wine: string; producer: string; n: number }\n > = {};\n\n for (const c of consumed) {\n const d = new Date(c.Consumed);\n if (!isNaN(d.getTime())) {\n dayCounts[DAYS[d.getDay()]]++;\n moCounts[MONTHS[d.getMonth()]]++;\n }\n if (/white|sparkling/i.test(c.Type || c.Color || \"\")) wsCount++;\n wineFreq[c.iWine] ??= { wine: c.Wine, producer: c.Producer, n: 0 };\n wineFreq[c.iWine].n++;\n }\n\n const total = consumed.length;\n const wsPct = total ? Math.round(wsCount / total * 100) : 0;\n const topWines = Object.values(wineFreq).sort((a, b) => b.n - a.n).slice(\n 0,\n 5,\n );\n\n if (asJson) {\n return Response.json({\n summary: {\n total,\n weekdays: dayCounts,\n months: moCounts,\n whiteSparklingPct: wsPct,\n topRepeated: topWines,\n },\n events: consumed.map((c) => ({\n date: isoDate(c.Consumed),\n wine: c.Wine,\n producer: c.Producer,\n vintage: mapVintage(c.Vintage),\n type: c.Type || c.Color,\n varietal: c.MasterVarietal || c.Varietal,\n })),\n }, { headers: HDRS });\n }\n\n const summaryBlock = [\n `total: ${total}`,\n `weekdays: ${DAYS.map((d) => `${d}=${dayCounts[d]}`).join(\", \")}`,\n `months: ${MONTHS.map((m) => `${m}=${moCounts[m]}`).join(\", \")}`,\n `whiteSparkling: ${wsPct}%`,\n `topWines: ${topWines.map((w) => `${w.wine} ×${w.n}`).join(\", \")}`,\n ].join(\"\\n\");\n\n const tsvData = consumed.map((c) =>\n tsvRow(\n isoDate(c.Consumed),\n c.Wine,\n c.Producer,\n mapVintage(c.Vintage),\n c.Type || c.Color,\n c.MasterVarietal || c.Varietal,\n )\n ).join(\"\\n\");\n\n return new Response(\n `${summaryBlock}\\n\\ndate\\twine\\tproducer\\tvintage\\ttype\\tvarietal\\n${tsvData}`,\n { headers: PLAIN },\n );\n }\n\n // ── CELLAR (default) ─────────────────────────────────────────────────────\n const [\n listResult,\n notesResult,\n pvtResult,\n consumedResult,\n purchaseResult,\n proResult,\n ] = await Promise.all([\n ctTable(\"List\", true),\n ctTable(\"Notes\"),\n ctTable(\"PrivateNotes\").catch(EMPTY_TABLE),\n ctTable(\"Consumed\"),\n ctTable(\"Purchase\"),\n ctTable(\"ProReview\").catch(EMPTY_TABLE),\n ]);\n\n const { header: listHdr, rows: list } = listResult;\n const { rows: notes } = notesResult;\n const { rows: pvtNotes } = pvtResult;\n const { rows: consumed } = consumedResult;\n const { rows: purchase } = purchaseResult;\n const { header: proHdr, rows: proReviews } = proResult;\n\n const winCols = detectWindowCols(listHdr);\n\n // ── ProReview index ──────────────────────────────────────────────────────\n // Reviews are keyed by iWine+Vintage — the same grain as the cellar rows.\n // Text and drink window are picked independently: the review carrying the\n // prose is often not the one carrying the dates.\n const proWinCols = detectWindowCols(proHdr);\n const proNotes: Record = {};\n const proWindows: Record<\n string,\n { begin: string; end: string; rank: number }\n > = {};\n\n for (const r of proReviews) {\n const key = `${r.iWine}|${r.Vintage}`;\n // Newest review wins; undated ones rank below every dated one.\n const rank = new Date(r.ReviewDate).getTime() || 0;\n\n const text = (r.ReviewText || \"\").trim();\n if (text && (!proNotes[key] || rank >= proNotes[key].rank)) {\n proNotes[key] = { text: truncate(text, PRO_NOTE_MAX), rank };\n }\n\n const begin = proWinCols.begin ? (r[proWinCols.begin] || \"\").trim() : \"\";\n const end = proWinCols.end ? (r[proWinCols.end] || \"\").trim() : \"\";\n if ((begin || end) && (!proWindows[key] || rank >= proWindows[key].rank)) {\n proWindows[key] = { begin, end, rank };\n }\n }\n\n // Palate model (personal ratings, with PrivateNotes as note fallback)\n const varAgg: Record = {};\n const wineAgg: Record = {};\n const wineNotes: Record = {};\n const addNote = (id: string, text: string | undefined) => {\n const t = (text || \"\").trim();\n if (!t) return;\n wineNotes[id] ??= [];\n if (!wineNotes[id].includes(t)) wineNotes[id].push(t);\n };\n\n for (const n of notes) {\n const r = num(n.Rating);\n if (!r) continue;\n const v = n.MasterVarietal || n.Varietal;\n if (v && v !== \"Unknown\") {\n varAgg[v] ??= { sum: 0, n: 0 };\n varAgg[v].sum += r;\n varAgg[v].n++;\n }\n wineAgg[n.iWine] ??= { sum: 0, n: 0 };\n wineAgg[n.iWine].sum += r;\n wineAgg[n.iWine].n++;\n addNote(n.iWine, n.TastingNotes);\n }\n for (const p of pvtNotes) {\n addNote(p.iWine, p.PrivateNote);\n }\n for (const c of consumed) {\n addNote(c.iWine, c.ConsumptionNote);\n addNote(c.iWine, c.BottleNote);\n }\n\n const palate = Object.fromEntries(\n Object.entries(varAgg)\n .map(([v, a]) => [v, +(a.sum / a.n).toFixed(1)])\n .sort(([, a], [, b]) => (b as number) - (a as number)),\n ) as Record;\n\n // Last consumed per wine\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 // Rhythm from consumed history\n let weekendCount = 0, wsCount = 0;\n for (const c of consumed) {\n const day = new Date(c.Consumed).getDay();\n if (day === 0 || day === 6) weekendCount++;\n if (/white|sparkling/i.test(c.Type || c.Color || \"\")) wsCount++;\n }\n const cTotal = consumed.length;\n const weekendPct = cTotal ? Math.round(weekendCount / cTotal * 100) : 0;\n const wsPct = cTotal ? Math.round(wsCount / cTotal * 100) : 0;\n\n // Latest purchase date per wine (for stale-months)\n const latestPurchase: Record = {};\n for (const p of purchase) {\n const d = new Date(p.PurchaseDate);\n if (isNaN(d.getTime())) continue;\n if (!latestPurchase[p.iWine] || d > latestPurchase[p.iWine]) {\n latestPurchase[p.iWine] = d;\n }\n }\n\n // Gift detection: scan all available note fields for the word \"gift\"\n const giftWines = new Set();\n for (const c of consumed) {\n if (\n /gift/i.test(`${c.ConsumptionNote} ${c.PurchaseNote} ${c.BottleNote}`)\n ) {\n giftWines.add(c.iWine);\n }\n }\n for (const n of notes) {\n if (/gift/i.test(n.TastingNotes || \"\")) giftWines.add(n.iWine);\n }\n for (const p of pvtNotes) {\n if (/gift/i.test(p.PrivateNote || \"\")) giftWines.add(p.iWine);\n }\n\n // Aggregate List rows by iWine+Vintage\n const wines: Record = {};\n\n for (const w of list) {\n const key = `${w.iWine}|${w.Vintage}`;\n const proWin = proWindows[key];\n const rec = (wines[key] ??= {\n iWine: w.iWine,\n wine: w.Wine,\n producer: w.Producer,\n vintage: mapVintage(w.Vintage),\n type: w.Type,\n varietal: clean(w.MasterVarietal) || clean(w.Varietal),\n designation: clean(w.Designation),\n price: num(w.Price) > 0 ? Math.round(num(w.Price)) : null,\n isGift: giftWines.has(w.iWine),\n qty: 0,\n locations: [],\n appellation: clean(w.Appellation),\n // Fall back to the pro review's window per bound: CellarTracker often\n // carries one of the two and leaves the other blank.\n _begin: (winCols.begin ? (w[winCols.begin] || \"\") : \"\") ||\n (proWin?.begin ?? \"\"),\n _end: (winCols.end ? (w[winCols.end] || \"\") : \"\") || (proWin?.end ?? \"\"),\n proNote: proNotes[key]?.text ?? \"\",\n });\n rec.qty += num(w.Quantity);\n rec.locations.push({\n location: abbrevLoc(w.Location),\n rawLocation: clean(w.Location),\n bin: clean(w.Bin),\n qty: num(w.Quantity),\n });\n }\n\n // Cellar price distribution for relative categorization\n const _pricedVals = Object.values(wines)\n .map((w) => w.price)\n .filter((p): p is number => p != null)\n .sort((a, b) => a - b);\n const cellarP50 = _pricedVals[Math.floor(_pricedVals.length * 0.5)] ?? 15;\n const cellarP90 = _pricedVals[Math.floor(_pricedVals.length * 0.9)] ?? 40;\n\n // Attach computed fields and flatten to sorted list\n const wineList = Object.values(wines).map((w) => {\n const lp = latestPurchase[w.iWine];\n let rating: number | null = null, rSrc: string | null = null;\n if (wineAgg[w.iWine]) {\n rating = +(wineAgg[w.iWine].sum / wineAgg[w.iWine].n).toFixed(1);\n rSrc = \"p\";\n } else if (palate[w.varietal] != null) {\n rating = palate[w.varietal];\n rSrc = \"v\";\n }\n const locStr = w.locations.map((l) => `${l.location}:${l.bin}:${l.qty}`)\n .join(\"; \");\n const tempStatus = temperatureStatus(w.type, w.locations);\n return {\n wine: w.wine,\n producer: w.producer,\n vintage: w.vintage,\n type: w.type,\n varietal: w.varietal,\n designation: w.designation,\n price: w.price,\n isGift: w.isGift,\n rating,\n rSrc,\n lastDrunk: lastConsumed[w.iWine] ? isoDate(lastConsumed[w.iWine]) : \"\",\n drink: drinkStatus(w._begin, w._end),\n tempStatus,\n staleMonths: lp ? monthsSince(lp) : null,\n qty: w.qty,\n locStr,\n note: (wineNotes[w.iWine] ?? []).join(\" | \"),\n proNote: w.proNote,\n priceCat: priceCategory(\n w.price,\n w.isGift,\n w.type,\n w.appellation,\n w.designation,\n cellarP50,\n cellarP90,\n ),\n };\n }).sort((a, b) => (b.rating ?? 0) - (a.rating ?? 0));\n\n const priced = wineList.map((w) => w.price).filter((p): p is number =>\n p != null\n ).sort((a, b) => a - b);\n const splurgeThreshold = priced.length\n ? Math.round(priced[Math.floor(priced.length * 0.9)])\n : null;\n const bottleCount = wineList.reduce((s, w) => s + w.qty, 0);\n const generated = new Date().toISOString();\n const palateStr = Object.entries(palate).map(([v, r]) => `${v} ${r}`).join(\n \", \",\n );\n\n if (asJson) {\n return Response.json({\n generated,\n summary: {\n bottles: bottleCount,\n wines: wineList.length,\n splurgeThreshold,\n palate,\n rhythm: { weekendPct, whiteSparklingPct: wsPct },\n },\n wines: wineList.map(({ locStr, ...w }) => ({\n ...w,\n locations: locStr,\n })),\n }, { headers: HDRS });\n }\n\n const summaryBlock = [\n `generated: ${generated}`,\n `bottles: ${bottleCount}`,\n `wines: ${wineList.length}`,\n `splurgeThreshold: ${splurgeThreshold ?? \"\"}`,\n `palate: ${palateStr}`,\n `rhythm: weekend ${weekendPct}%, whiteSparkling ${wsPct}%`,\n ].join(\"\\n\");\n\n const COL_HDR =\n \"wine\\tproducer\\tvintage\\ttype\\tvarietal\\tdesignation\\tprice\\tpriceCat\\tgift\\trating\\t\" +\n \"rSrc\\tlastDrunk\\tdrink\\ttempStatus\\tstaleMonths\\tqty\\tlocations\\tnote\\tproNote\";\n\n const tsvData = wineList.map((w) =>\n tsvRow(\n w.wine,\n w.producer,\n w.vintage,\n w.type,\n w.varietal,\n w.designation,\n w.price ?? \"\",\n w.priceCat,\n w.isGift ? \"gift\" : \"\",\n w.rating ?? \"\",\n w.rSrc ?? \"\",\n w.lastDrunk,\n w.drink,\n w.tempStatus,\n w.staleMonths ?? \"\",\n w.qty,\n w.locStr,\n w.note,\n )\n ).join(\"\\n\");\n\n return new Response(\n `${summaryBlock}\\n\\n${COL_HDR}\\n${tsvData}`,\n { headers: PLAIN },\n );\n } catch (e: unknown) {\n const err = e as { table?: string; hint?: string; message?: string };\n if (err.table) {\n return Response.json(\n {\n error: err.message,\n table: err.table,\n hint: err.hint ?? \"check CT_USER / CT_PASSWORD\",\n },\n { status: 502, headers: HDRS },\n );\n }\n throw e;\n }\n}","// Cellar API — one HTTP val, three views.\n// Views: cellar (default), history, debug\n// Auth: ?token= on every request.\n// Encoding: CellarTracker serves Windows-1252; decoded explicitly below.\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\")!;\n\nconst TODAY = new Date();\nconst YEAR = TODAY.getFullYear();\n\n// ── Tiny helpers ──────────────────────────────────────────────────────────────\n\nconst num = (v: string) => {\n const n = parseFloat(v);\n return isFinite(n) ? n : 0;\n};\nconst clean = (v = \"\") => (v === \"Unknown\" ? \"\" : v);\nconst mapVintage = (v: string) => (v === \"1001\" ? \"N.V.\" : v);\n\nfunction abbrevLoc(s: string): string {\n if (!s || s === \"Unknown\") return \"\";\n return s.replace(\"Wine Fridge\", \"Fridge\").replace(\"Wine Wall\", \"Wall\");\n}\n\n// M/D/YYYY → YYYY-MM-DD (avoids timezone-shift of new Date())\nfunction isoDate(s: string): string {\n const m = s.match(/^(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})$/);\n return m ? `${m[3]}-${m[1].padStart(2, \"0\")}-${m[2].padStart(2, \"0\")}` : s;\n}\n\nfunction monthsSince(d: Date): number {\n return (TODAY.getFullYear() - d.getFullYear()) * 12 +\n (TODAY.getMonth() - d.getMonth());\n}\n\n// Build one TSV row; scrubs tabs/newlines from every cell value.\nfunction tsvRow(...vals: (string | number | null | undefined)[]): string {\n return vals.map((v) => (v == null ? \"\" : String(v).replace(/[\\t\\r\\n]/g, \" \")))\n .join(\"\\t\");\n}\n\n// Pro reviews run long; collapse whitespace and cap for the TSV.\nconst PRO_NOTE_MAX = 600;\n\nfunction truncate(s: string, max: number): string {\n const one = s.replace(/\\s+/g, \" \").trim();\n return one.length <= max ? one : one.slice(0, max - 1).trimEnd() + \"…\";\n}\n\n// ctTable throws on zero rows, which is the right default but wrong for the\n// optional tables — most cellars have no PrivateNotes and few ProReviews.\nconst EMPTY_TABLE = (): CtResult => ({ header: [], rows: [], skipped: 0 });\n\n// ── Drink-window column detection ─────────────────────────────────────────────\n\nfunction detectWindowCols(\n header: string[],\n): { begin: string | null; end: string | null } {\n for (\n const [b, e] of [\n [\"BeginConsume\", \"EndConsume\"],\n [\"Begin\", \"End\"],\n [\"Drink From\", \"Drink To\"],\n [\"CTBeginConsume\", \"CTEndConsume\"],\n ] as [string, string][]\n ) {\n if (header.includes(b) && header.includes(e)) return { begin: b, end: e };\n }\n return { begin: null, end: null };\n}\n\nfunction drinkStatus(begin: string, end: string): string {\n if (!begin && !end) return \"\";\n const b = parseInt(begin), e = parseInt(end);\n if (e && YEAR > e) return \"past\";\n if (b && YEAR < b) return \"hold\";\n return \"ready\";\n}\n\ntype TempStatus = \"ready\" | \"nearReady\" | \"notReady\";\n\ntype WineLocation = {\n location: string;\n rawLocation: string;\n bin: string;\n qty: number;\n};\n\nfunction temperatureStatus(\n type: string,\n locations: WineLocation[],\n): TempStatus {\n const isColdStyle = /white|sparkling|ros[eé]/i.test(type);\n const isRedStyle = /red/i.test(type) && !isColdStyle;\n\n const isActualFridge = (l: WineLocation) => /^fridge$/i.test(l.rawLocation);\n const isWineFridge = (l: WineLocation) =>\n /^wine fridge$/i.test(l.rawLocation);\n const isWhiteBin = (l: WineLocation) => /^white\\b/i.test(l.bin);\n const isRedBin = (l: WineLocation) => /^red\\b/i.test(l.bin);\n const isAnyFridge = (l: WineLocation) => isActualFridge(l) || isWineFridge(l);\n\n const onTemp = locations.some((l) => {\n if (isColdStyle) {\n return isActualFridge(l) || (isWineFridge(l) && isWhiteBin(l));\n }\n if (isRedStyle) return isWineFridge(l) && isRedBin(l);\n return false;\n });\n if (onTemp) return \"ready\";\n\n // Any fridge placement that is not ideal is still closer to serving temp than\n // wine wall / cellar / outside storage.\n const nearServing = locations.some(isAnyFridge);\n\n return nearServing ? \"nearReady\" : \"notReady\";\n}\n\nfunction priceCategory(\n price: number | null,\n isGift: boolean,\n type: string,\n appellation: string,\n designation: string,\n cellarP50: number,\n cellarP90: number,\n): string {\n if (price == null) return \"Unknown\";\n\n // Base tier from absolute price\n let tier = price >= 40 ? 4 : price >= 20 ? 3 : price >= 10 ? 2 : 1;\n\n // Signal 1 — Champagne AOC sparkling: prestige bump regardless of price\n if (/sparkling/i.test(type) && /champagne/i.test(appellation) && tier < 4) {\n tier++;\n }\n\n // Signal 2 — top 10% of this cellar's price distribution: clearly premium here\n if (price >= cellarP90 && tier < 4) tier++;\n\n // Signal 3 — named designation + above-median price: above generic in same band\n if (designation && price >= cellarP50 && tier === 2) tier++;\n\n return ([\"\", \"Cheap\", \"Average\", \"Expensive\", \"Splurge\"] as const)[\n Math.min(4, Math.max(1, tier))\n ];\n}\n\n// ── CT fetch ──────────────────────────────────────────────────────────────────\n\ninterface CtResult {\n header: string[];\n rows: Record[];\n skipped: number;\n}\n\nasync function ctTable(table: string, location = false): Promise {\n const url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab${location ? \"&Location=1\" : \"\"}` +\n `&Table=${table}`;\n\n const res = await fetch(url);\n if (!res.ok) {\n throw Object.assign(new Error(`HTTP ${res.status} fetching ${table}`), {\n table,\n hint: \"check CT_USER / CT_PASSWORD\",\n });\n }\n\n const buf = await res.arrayBuffer();\n const text = new TextDecoder(\"windows-1252\").decode(buf).trim();\n\n if (/ h.trim());\n let skipped = 0;\n const rows: Record[] = [];\n for (const line of dataLines) {\n if (!line.trim()) continue;\n const cells = line.split(\"\\t\");\n if (cells.length < Math.ceil(header.length / 2)) {\n skipped++;\n continue;\n }\n rows.push(\n Object.fromEntries(header.map((h, i) => [h, (cells[i] ?? \"\").trim()])),\n );\n }\n\n if (rows.length === 0) {\n throw Object.assign(new Error(`0 data rows from ${table}`), {\n table,\n hint: \"check CT_USER / CT_PASSWORD\",\n });\n }\n\n return { header, rows, skipped };\n}\n\n// ── Constants ─────────────────────────────────────────────────────────────────\n\nconst HDRS = { \"Cache-Control\": \"no-store\" };\nconst PLAIN = { ...HDRS, \"Content-Type\": \"text/plain; charset=utf-8\" };\nconst VALID_VIEWS = [\"cellar\", \"history\", \"debug\"] as const;\n\n// ── Handler ───────────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request): Promise {\n const u = new URL(req.url);\n\n if (u.searchParams.get(\"token\") !== CELLAR_TOKEN) {\n return new Response(\"Forbidden\", { status: 403 });\n }\n\n const view = (u.searchParams.get(\"view\") ?? \"cellar\") as string;\n const asJson = u.searchParams.get(\"format\") === \"json\";\n\n if (!(VALID_VIEWS as readonly string[]).includes(view)) {\n return Response.json(\n { error: `Unknown view \"${view}\". Valid: ${VALID_VIEWS.join(\", \")}` },\n { status: 400, headers: HDRS },\n );\n }\n\n try {\n // ── DEBUG ────────────────────────────────────────────────────────────────\n if (view === \"debug\") {\n const tables = [\n \"List\",\n \"Notes\",\n \"PrivateNotes\",\n \"Consumed\",\n \"Purchase\",\n \"ProReview\",\n ];\n const info: Record = {};\n let windowMapping: unknown = null;\n for (const t of tables) {\n try {\n const { header, rows, skipped } = await ctTable(t, t === \"List\");\n info[t] = { columns: header, rows: rows.length, skipped };\n if (t === \"List\") windowMapping = detectWindowCols(header);\n } catch (e: unknown) {\n info[t] = { error: (e as Error).message };\n }\n }\n return Response.json(\n { tables: info, drinkWindowMapping: windowMapping },\n { headers: HDRS },\n );\n }\n\n // ── HISTORY ──────────────────────────────────────────────────────────────\n if (view === \"history\") {\n const { rows: consumed } = await ctTable(\"Consumed\");\n consumed.sort((a, b) =>\n new Date(b.Consumed).getTime() - new Date(a.Consumed).getTime()\n );\n\n const DAYS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n const MONTHS = [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\",\n ];\n const dayCounts = Object.fromEntries(DAYS.map((d) => [d, 0])) as Record<\n string,\n number\n >;\n const moCounts = Object.fromEntries(MONTHS.map((m) => [m, 0])) as Record<\n string,\n number\n >;\n let wsCount = 0;\n const wineFreq: Record<\n string,\n { wine: string; producer: string; n: number }\n > = {};\n\n for (const c of consumed) {\n const d = new Date(c.Consumed);\n if (!isNaN(d.getTime())) {\n dayCounts[DAYS[d.getDay()]]++;\n moCounts[MONTHS[d.getMonth()]]++;\n }\n if (/white|sparkling/i.test(c.Type || c.Color || \"\")) wsCount++;\n wineFreq[c.iWine] ??= { wine: c.Wine, producer: c.Producer, n: 0 };\n wineFreq[c.iWine].n++;\n }\n\n const total = consumed.length;\n const wsPct = total ? Math.round(wsCount / total * 100) : 0;\n const topWines = Object.values(wineFreq).sort((a, b) => b.n - a.n).slice(\n 0,\n 5,\n );\n\n if (asJson) {\n return Response.json({\n summary: {\n total,\n weekdays: dayCounts,\n months: moCounts,\n whiteSparklingPct: wsPct,\n topRepeated: topWines,\n },\n events: consumed.map((c) => ({\n date: isoDate(c.Consumed),\n wine: c.Wine,\n producer: c.Producer,\n vintage: mapVintage(c.Vintage),\n type: c.Type || c.Color,\n varietal: c.MasterVarietal || c.Varietal,\n })),\n }, { headers: HDRS });\n }\n\n const summaryBlock = [\n `total: ${total}`,\n `weekdays: ${DAYS.map((d) => `${d}=${dayCounts[d]}`).join(\", \")}`,\n `months: ${MONTHS.map((m) => `${m}=${moCounts[m]}`).join(\", \")}`,\n `whiteSparkling: ${wsPct}%`,\n `topWines: ${topWines.map((w) => `${w.wine} ×${w.n}`).join(\", \")}`,\n ].join(\"\\n\");\n\n const tsvData = consumed.map((c) =>\n tsvRow(\n isoDate(c.Consumed),\n c.Wine,\n c.Producer,\n mapVintage(c.Vintage),\n c.Type || c.Color,\n c.MasterVarietal || c.Varietal,\n )\n ).join(\"\\n\");\n\n return new Response(\n `${summaryBlock}\\n\\ndate\\twine\\tproducer\\tvintage\\ttype\\tvarietal\\n${tsvData}`,\n { headers: PLAIN },\n );\n }\n\n // ── CELLAR (default) ─────────────────────────────────────────────────────\n const [\n listResult,\n notesResult,\n pvtResult,\n consumedResult,\n purchaseResult,\n proResult,\n ] = await Promise.all([\n ctTable(\"List\", true),\n ctTable(\"Notes\"),\n ctTable(\"PrivateNotes\").catch(EMPTY_TABLE),\n ctTable(\"Consumed\"),\n ctTable(\"Purchase\"),\n ctTable(\"ProReview\").catch(EMPTY_TABLE),\n ]);\n\n const { header: listHdr, rows: list } = listResult;\n const { rows: notes } = notesResult;\n const { rows: pvtNotes } = pvtResult;\n const { rows: consumed } = consumedResult;\n const { rows: purchase } = purchaseResult;\n const { header: proHdr, rows: proReviews } = proResult;\n\n const winCols = detectWindowCols(listHdr);\n\n // ── ProReview index ──────────────────────────────────────────────────────\n // Reviews are keyed by iWine+Vintage — the same grain as the cellar rows.\n // Text and drink window are picked independently: the review carrying the\n // prose is often not the one carrying the dates.\n const proWinCols = detectWindowCols(proHdr);\n const proNotes: Record = {};\n const proWindows: Record<\n string,\n { begin: string; end: string; rank: number }\n > = {};\n\n for (const r of proReviews) {\n const key = `${r.iWine}|${r.Vintage}`;\n // Newest review wins; undated ones rank below every dated one.\n const rank = new Date(r.ReviewDate).getTime() || 0;\n\n const text = (r.ReviewText || \"\").trim();\n if (text && (!proNotes[key] || rank >= proNotes[key].rank)) {\n proNotes[key] = { text: truncate(text, PRO_NOTE_MAX), rank };\n }\n\n const begin = proWinCols.begin ? (r[proWinCols.begin] || \"\").trim() : \"\";\n const end = proWinCols.end ? (r[proWinCols.end] || \"\").trim() : \"\";\n if ((begin || end) && (!proWindows[key] || rank >= proWindows[key].rank)) {\n proWindows[key] = { begin, end, rank };\n }\n }\n\n // Palate model (personal ratings, with PrivateNotes as note fallback)\n const varAgg: Record = {};\n const wineAgg: Record = {};\n const wineNotes: Record = {};\n const addNote = (id: string, text: string | undefined) => {\n const t = (text || \"\").trim();\n if (!t) return;\n wineNotes[id] ??= [];\n if (!wineNotes[id].includes(t)) wineNotes[id].push(t);\n };\n\n for (const n of notes) {\n const r = num(n.Rating);\n if (!r) continue;\n const v = n.MasterVarietal || n.Varietal;\n if (v && v !== \"Unknown\") {\n varAgg[v] ??= { sum: 0, n: 0 };\n varAgg[v].sum += r;\n varAgg[v].n++;\n }\n wineAgg[n.iWine] ??= { sum: 0, n: 0 };\n wineAgg[n.iWine].sum += r;\n wineAgg[n.iWine].n++;\n addNote(n.iWine, n.TastingNotes);\n }\n for (const p of pvtNotes) {\n addNote(p.iWine, p.PrivateNote);\n }\n for (const c of consumed) {\n addNote(c.iWine, c.ConsumptionNote);\n addNote(c.iWine, c.BottleNote);\n }\n\n const palate = Object.fromEntries(\n Object.entries(varAgg)\n .map(([v, a]) => [v, +(a.sum / a.n).toFixed(1)])\n .sort(([, a], [, b]) => (b as number) - (a as number)),\n ) as Record;\n\n // Last consumed per wine\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 // Rhythm from consumed history\n let weekendCount = 0, wsCount = 0;\n for (const c of consumed) {\n const day = new Date(c.Consumed).getDay();\n if (day === 0 || day === 6) weekendCount++;\n if (/white|sparkling/i.test(c.Type || c.Color || \"\")) wsCount++;\n }\n const cTotal = consumed.length;\n const weekendPct = cTotal ? Math.round(weekendCount / cTotal * 100) : 0;\n const wsPct = cTotal ? Math.round(wsCount / cTotal * 100) : 0;\n\n // Latest purchase date per wine (for stale-months)\n const latestPurchase: Record = {};\n for (const p of purchase) {\n const d = new Date(p.PurchaseDate);\n if (isNaN(d.getTime())) continue;\n if (!latestPurchase[p.iWine] || d > latestPurchase[p.iWine]) {\n latestPurchase[p.iWine] = d;\n }\n }\n\n // Gift detection: scan all available note fields for the word \"gift\"\n const giftWines = new Set();\n for (const c of consumed) {\n if (\n /gift/i.test(`${c.ConsumptionNote} ${c.PurchaseNote} ${c.BottleNote}`)\n ) {\n giftWines.add(c.iWine);\n }\n }\n for (const n of notes) {\n if (/gift/i.test(n.TastingNotes || \"\")) giftWines.add(n.iWine);\n }\n for (const p of pvtNotes) {\n if (/gift/i.test(p.PrivateNote || \"\")) giftWines.add(p.iWine);\n }\n\n // Aggregate List rows by iWine+Vintage\n const wines: Record = {};\n\n for (const w of list) {\n const key = `${w.iWine}|${w.Vintage}`;\n const proWin = proWindows[key];\n const rec = (wines[key] ??= {\n iWine: w.iWine,\n wine: w.Wine,\n producer: w.Producer,\n vintage: mapVintage(w.Vintage),\n type: w.Type,\n varietal: clean(w.MasterVarietal) || clean(w.Varietal),\n designation: clean(w.Designation),\n price: num(w.Price) > 0 ? Math.round(num(w.Price)) : null,\n isGift: giftWines.has(w.iWine),\n qty: 0,\n locations: [],\n appellation: clean(w.Appellation),\n // Fall back to the pro review's window per bound: CellarTracker often\n // carries one of the two and leaves the other blank.\n _begin: (winCols.begin ? (w[winCols.begin] || \"\") : \"\") ||\n (proWin?.begin ?? \"\"),\n _end: (winCols.end ? (w[winCols.end] || \"\") : \"\") || (proWin?.end ?? \"\"),\n proNote: proNotes[key]?.text ?? \"\",\n });\n rec.qty += num(w.Quantity);\n rec.locations.push({\n location: abbrevLoc(w.Location),\n rawLocation: clean(w.Location),\n bin: clean(w.Bin),\n qty: num(w.Quantity),\n });\n }\n\n // Cellar price distribution for relative categorization\n const _pricedVals = Object.values(wines)\n .map((w) => w.price)\n .filter((p): p is number => p != null)\n .sort((a, b) => a - b);\n const cellarP50 = _pricedVals[Math.floor(_pricedVals.length * 0.5)] ?? 15;\n const cellarP90 = _pricedVals[Math.floor(_pricedVals.length * 0.9)] ?? 40;\n\n // Attach computed fields and flatten to sorted list\n const wineList = Object.values(wines).map((w) => {\n const lp = latestPurchase[w.iWine];\n let rating: number | null = null, rSrc: string | null = null;\n if (wineAgg[w.iWine]) {\n rating = +(wineAgg[w.iWine].sum / wineAgg[w.iWine].n).toFixed(1);\n rSrc = \"p\";\n } else if (palate[w.varietal] != null) {\n rating = palate[w.varietal];\n rSrc = \"v\";\n }\n const locStr = w.locations.map((l) => `${l.location}:${l.bin}:${l.qty}`)\n .join(\"; \");\n const tempStatus = temperatureStatus(w.type, w.locations);\n return {\n wine: w.wine,\n producer: w.producer,\n vintage: w.vintage,\n type: w.type,\n varietal: w.varietal,\n designation: w.designation,\n price: w.price,\n isGift: w.isGift,\n rating,\n rSrc,\n lastDrunk: lastConsumed[w.iWine] ? isoDate(lastConsumed[w.iWine]) : \"\",\n drink: drinkStatus(w._begin, w._end),\n tempStatus,\n staleMonths: lp ? monthsSince(lp) : null,\n qty: w.qty,\n locStr,\n note: (wineNotes[w.iWine] ?? []).join(\" | \"),\n proNote: w.proNote,\n priceCat: priceCategory(\n w.price,\n w.isGift,\n w.type,\n w.appellation,\n w.designation,\n cellarP50,\n cellarP90,\n ),\n };\n }).sort((a, b) => (b.rating ?? 0) - (a.rating ?? 0));\n\n const priced = wineList.map((w) => w.price).filter((p): p is number =>\n p != null\n ).sort((a, b) => a - b);\n const splurgeThreshold = priced.length\n ? Math.round(priced[Math.floor(priced.length * 0.9)])\n : null;\n const bottleCount = wineList.reduce((s, w) => s + w.qty, 0);\n const generated = new Date().toISOString();\n const palateStr = Object.entries(palate).map(([v, r]) => `${v} ${r}`).join(\n \", \",\n );\n\n if (asJson) {\n return Response.json({\n generated,\n summary: {\n bottles: bottleCount,\n wines: wineList.length,\n splurgeThreshold,\n palate,\n rhythm: { weekendPct, whiteSparklingPct: wsPct },\n },\n wines: wineList.map(({ locStr, ...w }) => ({\n ...w,\n locations: locStr,\n })),\n }, { headers: HDRS });\n }\n\n const summaryBlock = [\n `generated: ${generated}`,\n `bottles: ${bottleCount}`,\n `wines: ${wineList.length}`,\n `splurgeThreshold: ${splurgeThreshold ?? \"\"}`,\n `palate: ${palateStr}`,\n `rhythm: weekend ${weekendPct}%, whiteSparkling ${wsPct}%`,\n ].join(\"\\n\");\n\n const COL_HDR =\n \"wine\\tproducer\\tvintage\\ttype\\tvarietal\\tdesignation\\tprice\\tpriceCat\\tgift\\trating\\t\" +\n \"rSrc\\tlastDrunk\\tdrink\\ttempStatus\\tstaleMonths\\tqty\\tlocations\\tnote\\tproNote\";\n\n const tsvData = wineList.map((w) =>\n tsvRow(\n w.wine,\n w.producer,\n w.vintage,\n w.type,\n w.varietal,\n w.designation,\n w.price ?? \"\",\n w.priceCat,\n w.isGift ? \"gift\" : \"\",\n w.rating ?? \"\",\n w.rSrc ?? \"\",\n w.lastDrunk,\n w.drink,\n w.tempStatus,\n w.staleMonths ?? \"\",\n w.qty,\n w.locStr,\n w.note,\n w.proNote,\n )\n ).join(\"\\n\");\n\n return new Response(\n `${summaryBlock}\\n\\n${COL_HDR}\\n${tsvData}`,\n { headers: PLAIN },\n );\n } catch (e: unknown) {\n const err = e as { table?: string; hint?: string; message?: string };\n if (err.table) {\n return Response.json(\n {\n error: err.message,\n table: err.table,\n hint: err.hint ?? \"check CT_USER / CT_PASSWORD\",\n },\n { status: 502, headers: HDRS },\n );\n }\n throw e;\n }\n}","createdAt",["D",1789396832747],"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","pinPreview",true,"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",{"_99":98,"_105":53},"org",{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",58,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kobsen","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":165,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":166,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":167,"_83":168,"_85":169,"_87":25},"tree",[156,157],"files",[156,157],"counts",{"_144":62,"_145":146,"_147":62,"_148":149,"_150":151},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":140,"_13":62,"_33":141,"_35":142,"_24":25,"_134":-5,"_27":143},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"07e0f935-38f4-41aa-aecd-708075c9d9a6","parentId","latest",["D",1789396832747],46,"label",[28],"fe71ce67-fbf1-489e-a6ae-944f7592b200","_probe.ts","f7c30106-b049-11f1-ac8b-1607ee4eb77e",43,["D",1789396716059],"script","// Throwaway: inspect the ProReview export shape. Delete after use.\nconst CT_USER = Deno.env.get(\"CT_USER\")!;\nconst CT_PASSWORD = Deno.env.get(\"CT_PASSWORD\")!;\n\nconst url = `https://www.cellartracker.com/xlquery.asp` +\n `?User=${encodeURIComponent(CT_USER)}` +\n `&Password=${encodeURIComponent(CT_PASSWORD)}` +\n `&Format=tab&Table=ProReview`;\n\nconst res = await fetch(url);\nconst text = new TextDecoder(\"windows-1252\").decode(await res.arrayBuffer())\n .trim();\nconst [hdrLine, ...dataLines] = text.split(\"\\n\");\nconst header = hdrLine.split(\"\\t\").map((h) => h.trim());\n\nconsole.log(\"status:\", res.status);\nconsole.log(\"columns:\", JSON.stringify(header));\nconsole.log(\"dataRows:\", dataLines.filter((l) => l.trim()).length);\n\nconst first = dataLines.find((l) => l.trim());\nif (first) {\n const cells = first.split(\"\\t\");\n const sample = Object.fromEntries(\n header.map((h, i) => [h, (cells[i] ?? \"\").trim().slice(0, 120)]),\n );\n console.log(\"sampleRow:\", JSON.stringify(sample, null, 2));\n}\n",[137],"pulls","branches",1,"forks","envVars",{"_152":154,"_155":62},"connections",{"_152":62,"_153":62},"count","unfilledCount",3,"emptyCount",{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":162,"_13":62,"_33":141,"_35":142,"_24":25,"_134":-5,"_159":163,"_27":164},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":158,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_159":160,"_27":161},["D",1789396832747],"children",[],[28],["D",1789396716059],[],[137],["D",1781213251655],["D",1789503703835],{"_99":98,"_105":53},{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_124":203,"_204":205,"_206":207,"_208":25,"_209":25,"_210":25,"_211":58,"_212":-5,"_213":-7,"_214":-7,"_215":62,"_216":25,"_217":25,"_218":-5,"_219":25,"_220":25,"_221":25,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":89,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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 · v52