[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_309":310,"_311":312},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_228":-5,"_20":229,"_22":230,"_231":232,"_233":234,"_26":235,"_24":236,"_237":238,"_239":240,"_241":51,"_242":243,"_244":75,"_245":-5,"_246":-5,"_247":248},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","potluck","name","connections-searcher","branchName","main","version","path","frontend","project",{"_36":178,"_13":14,"_38":179,"_49":-5,"_180":51,"_52":53,"_181":53,"_182":183,"_184":185,"_186":187,"_188":113,"_189":75,"_190":-5,"_191":-5,"_192":77,"_56":193,"_194":195,"_196":197,"_198":199,"_200":-5,"_201":202,"_203":202,"_204":205,"_206":205,"_207":205,"_208":202,"_209":202,"_210":211,"_212":213,"_214":215,"_50":51},"tree",[107,108,109,110],"file",{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":105,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":106},"contents",[60,61,62,63],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",5,"behind",2,"envVars","id","961078ea-f528-11ef-aa68-569c3dd06744","createdAt",["D",1740674013689],"updatedAt",["D",1785420707976],"projectId","96102714-f528-11ef-aa68-569c3dd06744",91,"forkedBranchId","forkedBranchVersion","lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","deletedAt","isOwned",false,"privacy","public","userHandle","templates","orgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","react-hono-starter",{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":101,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":103},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":95,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_18":97},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":89,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_18":91},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":76,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_18":84},"f53584c0-101e-4fcb-92c6-998a9675f4ae","index.tsx","fileId","019f0594-e762-709d-bcd4-eee68a14b224","parentId","019f0594-e762-709d-bcd4-f3d86c7ef7c0","branchId","70f1b1fe-7e5e-4fa5-9c66-316ad2a08da9","branchVersion",1,"latest",true,["D",1782505072423],0,"fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();","deleted","label",[19,65],"67404c56-7330-4fc5-abfe-98432c01356d","index.html","019f0594-e762-709d-bcd4-e9b4b395ed08",4,["D",1782505152099],"\n\n \n \n \n Connections Archive\n \n \n \n \n

\n \n \n \n\n",[19,86],"d1a572f3-1a50-40a4-bd9b-2fd0f15e94fd","favicon.svg","019f0594-e762-709d-bcd4-e5248efd08af",["D",1782505072423],"\n",[19,93],"99a38126-ca12-44bc-b88f-bc015696ea5b","components","019f0594-e762-709d-bcd4-e076aae9ad15",["D",1782505072423],"directory",[19,99],"3b06a731-899f-40e0-b822-fb8f63345e17",["D",1782505072423],[19],{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":142,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":143,"_18":144},{"_36":127,"_13":128,"_66":129,"_68":-5,"_70":71,"_72":32,"_74":75,"_38":130,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":131,"_18":132},{"_36":120,"_13":121,"_66":122,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":123,"_17":77,"_78":24,"_80":124,"_82":51,"_83":-5,"_117":125,"_18":126},{"_36":111,"_13":112,"_66":113,"_68":-5,"_70":71,"_72":34,"_74":75,"_38":114,"_17":73,"_78":115,"_80":116,"_82":51,"_83":-5,"_117":118,"_18":119},"97ff35b1-5e3b-49fb-ba29-a694fd4f2897","index.ts","019f0594-e762-709d-bcd4-fba649db20e4",["D",1782505098026],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Initialize DB schema\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS puzzles (\n id INTEGER PRIMARY KEY,\n puzzle_number INTEGER UNIQUE NOT NULL,\n puzzle_date TEXT NOT NULL\n )\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS clues (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n puzzle_id INTEGER NOT NULL REFERENCES puzzles(id),\n color TEXT NOT NULL,\n category TEXT NOT NULL,\n word TEXT NOT NULL\n )\n`);\n\nawait sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_clues_word ON clues(word COLLATE NOCASE)\n`);\n\n// Serve frontend\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// --- API ---\n\n// GET /api/search?q=WORD&mode=exact|substring\napp.get(\"/api/search\", async (c) => {\n const q = (c.req.query(\"q\") ?? \"\").trim();\n const mode = c.req.query(\"mode\") ?? \"substring\";\n\n if (!q) return c.json({ results: [] });\n\n let whereClause: string;\n let args: string[];\n\n if (mode === \"exact\") {\n whereClause = \"LOWER(cl.word) = LOWER(?)\";\n args = [q];\n } else {\n whereClause = \"LOWER(cl.word) LIKE LOWER(?)\";\n args = [`%${q}%`];\n }\n\n // Find puzzles that contain a matching clue\n const matchingPuzzles = await sqlite.execute({\n sql: `\n SELECT DISTINCT p.id, p.puzzle_number, p.puzzle_date\n FROM puzzles p\n JOIN clues cl ON cl.puzzle_id = p.id\n WHERE ${whereClause}\n ORDER BY p.puzzle_number DESC\n `,\n args,\n });\n\n if (matchingPuzzles.rows.length === 0) return c.json({ results: [] });\n\n const puzzleIds = matchingPuzzles.rows.map((r) => r.id as number);\n\n // Fetch all clues for those puzzles\n const placeholders = puzzleIds.map(() => \"?\").join(\",\");\n const allClues = await sqlite.execute({\n sql: `\n SELECT puzzle_id, color, category, word\n FROM clues\n WHERE puzzle_id IN (${placeholders})\n ORDER BY puzzle_id, color, word\n `,\n args: puzzleIds,\n });\n\n // Group clues by puzzle\n type Clue = { color: string; category: string; word: string };\n type Group = { color: string; category: string; words: string[] };\n const cluesByPuzzle = new Map();\n for (const row of allClues.rows) {\n const pid = row.puzzle_id as number;\n if (!cluesByPuzzle.has(pid)) cluesByPuzzle.set(pid, []);\n cluesByPuzzle.get(pid)!.push({\n color: row.color as string,\n category: row.category as string,\n word: row.word as string,\n });\n }\n\n const results = matchingPuzzles.rows.map((p) => {\n const clues = cluesByPuzzle.get(p.id as number) ?? [];\n // Group by color/category\n const groups: Group[] = [];\n const seen = new Map();\n for (const cl of clues) {\n const key = `${cl.color}::${cl.category}`;\n if (!seen.has(key)) {\n const g: Group = { color: cl.color, category: cl.category, words: [] };\n seen.set(key, g);\n groups.push(g);\n }\n seen.get(key)!.words.push(cl.word);\n }\n return {\n puzzle_number: p.puzzle_number,\n puzzle_date: p.puzzle_date,\n groups,\n };\n });\n\n return c.json({ results });\n});\n\n// GET /api/puzzles - list all puzzles (for stats)\napp.get(\"/api/puzzles\", async (c) => {\n const result = await sqlite.execute(\n `SELECT puzzle_number, puzzle_date FROM puzzles ORDER BY puzzle_number DESC LIMIT 100`,\n );\n return c.json({ puzzles: result.rows });\n});\n\n// POST /api/puzzles - add a puzzle\napp.post(\"/api/puzzles\", async (c) => {\n const body = await c.req.json();\n const { puzzle_number, puzzle_date, groups } = body;\n // groups: [{ color, category, words: string[] }]\n\n if (!puzzle_number || !puzzle_date || !Array.isArray(groups)) {\n return c.json({ error: \"Invalid payload\" }, 400);\n }\n\n // Insert puzzle\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO puzzles (puzzle_number, puzzle_date) VALUES (?, ?)`,\n args: [puzzle_number, puzzle_date],\n });\n\n const puzzleRow = await sqlite.execute({\n sql: `SELECT id FROM puzzles WHERE puzzle_number = ?`,\n args: [puzzle_number],\n });\n const puzzleId = puzzleRow.rows[0].id as number;\n\n // Delete existing clues for this puzzle (in case of re-import)\n await sqlite.execute({\n sql: `DELETE FROM clues WHERE puzzle_id = ?`,\n args: [puzzleId],\n });\n\n // Insert clues\n const stmts = [];\n for (const group of groups) {\n for (const word of group.words) {\n stmts.push({\n sql: `INSERT INTO clues (puzzle_id, color, category, word) VALUES (?, ?, ?, ?)`,\n args: [puzzleId, group.color, group.category, word],\n });\n }\n }\n if (stmts.length > 0) await sqlite.batch(stmts);\n\n return c.json({ ok: true, puzzle_number, clues_inserted: stmts.length });\n});\n\n// DELETE /api/puzzles/:number - remove a puzzle\napp.delete(\"/api/puzzles/:number\", async (c) => {\n const num = parseInt(c.req.param(\"number\"));\n const row = await sqlite.execute({\n sql: `SELECT id FROM puzzles WHERE puzzle_number = ?`,\n args: [num],\n });\n if (!row.rows.length) return c.json({ error: \"Not found\" }, 404);\n const id = row.rows[0].id as number;\n await sqlite.batch([\n { sql: `DELETE FROM clues WHERE puzzle_id = ?`, args: [id] },\n { sql: `DELETE FROM puzzles WHERE id = ?`, args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\n// GET /api/stats\napp.get(\"/api/stats\", async (c) => {\n const puzzleCount = await sqlite.execute(`SELECT COUNT(*) as n FROM puzzles`);\n const clueCount = await sqlite.execute(`SELECT COUNT(*) as n FROM clues`);\n return c.json({\n puzzles: puzzleCount.rows[0].n,\n clues: clueCount.rows[0].n,\n });\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","children",[],[112],"96542375-b3d3-4e0c-bdce-83069b926fd9","README.md","019f0594-e762-709d-bcd4-f5173084ebc7",["D",1782505072423],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[],[121],"444b1995-5c2a-49ec-a410-cd94c5ac0162","scripts","e5cbff70-cdda-4058-9573-63adeceb23e5",["D",1782505302068],[133],[128],{"_36":134,"_13":135,"_66":136,"_68":129,"_70":71,"_72":137,"_74":75,"_38":138,"_17":73,"_78":79,"_80":139,"_82":51,"_83":-5,"_117":140,"_18":141},"38d5a21e-f302-4ada-97a4-89b65ebdbd07","import-archive.ts","a4e9dc34-719c-11f1-bc07-1607ee4eb77e",6,["D",1782505313591],"/**\n * Bulk import script: fetches all past NYT Connections puzzles from wordsrated.com\n * and POSTs each puzzle to the /api/puzzles endpoint.\n *\n * Run this once (or re-run safely — the API uses INSERT OR REPLACE).\n *\n * Usage: run this file as a Val Town script.\n */\n\nconst API_BASE = \"https://potluck--019f0594e762709dbcd4fba649db20e4.web.val.run\";\nconst SOURCE_URL = \"https://wordsrated.com/solvers/nyt-connections-archive-all-past-answers/\";\n\nconst COLOR_NAMES = [\"Yellow\", \"Green\", \"Blue\", \"Purple\"] as const;\nconst COLOR_KEYS = [\"yellow\", \"green\", \"blue\", \"purple\"] as const;\n\ntype PuzzlePayload = {\n puzzle_number: number;\n puzzle_date: string;\n groups: { color: string; category: string; words: string[] }[];\n};\n\n// Fetch the full page (it's ~300KB of text, need to paginate)\nasync function fetchFullPage(): Promise {\n const PAGE_SIZE = 50000;\n let text = \"\";\n let offset = 0;\n let hasMore = true;\n\n while (hasMore) {\n const url = `${SOURCE_URL}?_offset=${offset}`; // not a real param — we just need to loop\n const res = await fetch(SOURCE_URL, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (compatible; archive-importer/1.0)\" },\n });\n if (!res.ok) throw new Error(`HTTP ${res.status} fetching source page`);\n const full = await res.text();\n text = full; // we get the whole thing each time; we'll chunk it ourselves\n hasMore = false; // fetch() gives us everything at once\n }\n\n return text;\n}\n\n// Strip HTML tags and decode common HTML entities\nfunction stripHtml(html: string): string {\n return html\n .replace(/<[^>]*>/g, \" \")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, '\"')\n .replace(/'/g, \"'\")\n .replace(/’/g, \"'\")\n .replace(/“/g, '\"')\n .replace(/”/g, '\"')\n .replace(/ /g, \" \")\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\n// Convert a date string like \"June 25, 2026\" to \"2026-06-25\"\nfunction parseDate(dateStr: string): string {\n const months: Record = {\n January: \"01\", February: \"02\", March: \"03\", April: \"04\",\n May: \"05\", June: \"06\", July: \"07\", August: \"08\",\n September: \"09\", October: \"10\", November: \"11\", December: \"12\",\n };\n const m = dateStr.match(/(\\w+)\\s+(\\d+),\\s+(\\d{4})/);\n if (!m) throw new Error(`Can't parse date: ${dateStr}`);\n const [, month, day, year] = m;\n return `${year}-${months[month]}-${day.padStart(2, \"0\")}`;\n}\n\nfunction parsePuzzles(text: string): PuzzlePayload[] {\n const puzzles: PuzzlePayload[] = [];\n\n // Each puzzle block looks like:\n // \"Month Day, Year, #NUMBER Yellow Group: CATEGORY: WORD, WORD ... Purple Group: CATEGORY: WORD, WORD\"\n // We split on the date+number pattern\n const puzzlePattern =\n /(\\w+ \\d+, \\d{4}),\\s*#(\\d+)\\s+(Yellow Group:.*?Purple Group:.*?)(?=(?:\\w+ \\d+, \\d{4}),\\s*#\\d+|$)/gs;\n\n let match: RegExpExecArray | null;\n while ((match = puzzlePattern.exec(text)) !== null) {\n const [, dateStr, numStr, body] = match;\n\n let puzzle_date: string;\n try {\n puzzle_date = parseDate(dateStr);\n } catch {\n console.warn(`Skipping puzzle #${numStr}: bad date \"${dateStr}\"`);\n continue;\n }\n\n const puzzle_number = parseInt(numStr, 10);\n const groups: PuzzlePayload[\"groups\"] = [];\n\n for (let i = 0; i < COLOR_NAMES.length; i++) {\n const color = COLOR_NAMES[i];\n const colorKey = COLOR_KEYS[i];\n const nextColor = COLOR_NAMES[i + 1] ? `${COLOR_NAMES[i + 1]} Group:` : \"$\";\n\n // Match \"Yellow Group: CATEGORY: WORD, WORD, WORD, WORD\"\n const groupRe = new RegExp(\n `${color} Group:\\\\s*([^:]+?):\\\\s*(.*?)(?=${nextColor}|$)`,\n \"s\",\n );\n const gm = body.match(groupRe);\n if (!gm) {\n console.warn(`Puzzle #${puzzle_number}: missing ${color} group`);\n continue;\n }\n\n const category = gm[1].trim();\n const wordsRaw = gm[2].trim();\n const words = wordsRaw\n .split(\",\")\n .map((w) => w.trim())\n .filter((w) => w.length > 0);\n\n if (words.length === 0) {\n console.warn(`Puzzle #${puzzle_number}: ${color} group has no words (skipping group)`);\n continue;\n }\n\n groups.push({ color: colorKey, category, words });\n }\n\n if (groups.length < 4) {\n console.warn(`Puzzle #${puzzle_number}: only ${groups.length}/4 groups parsed — skipping`);\n continue;\n }\n\n puzzles.push({ puzzle_number, puzzle_date, groups });\n }\n\n return puzzles;\n}\n\nasync function importPuzzle(puzzle: PuzzlePayload): Promise {\n const res = await fetch(`${API_BASE}/api/puzzles`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(puzzle),\n });\n if (!res.ok) {\n const text = await res.text();\n console.error(`Failed #${puzzle.puzzle_number}: HTTP ${res.status} — ${text}`);\n return false;\n }\n return true;\n}\n\n// Main\nconsole.log(\"Fetching archive page...\");\nconst html = await fetchFullPage();\nconst text = stripHtml(html);\n\nconsole.log(`Page fetched (${text.length} chars). Parsing puzzles...`);\nconst puzzles = parsePuzzles(text);\nconsole.log(`Found ${puzzles.length} puzzles. Importing...`);\n\nlet imported = 0;\nlet failed = 0;\nlet skipped = 0;\n\n// Check which puzzles are already in the DB\nconst statsRes = await fetch(`${API_BASE}/api/stats`);\nconst stats = await statsRes.json();\nconst alreadyHas = (stats.puzzles as number) > 0;\n\nif (alreadyHas) {\n console.log(`DB already has ${stats.puzzles} puzzles. Re-importing all (INSERT OR REPLACE)...`);\n}\n\n// Import in batches to avoid hammering the API\nconst BATCH = 20;\nfor (let i = 0; i < puzzles.length; i += BATCH) {\n const batch = puzzles.slice(i, i + BATCH);\n await Promise.all(\n batch.map(async (p) => {\n const ok = await importPuzzle(p);\n if (ok) imported++;\n else failed++;\n }),\n );\n console.log(`Progress: ${Math.min(i + BATCH, puzzles.length)}/${puzzles.length}`);\n}\n\nconsole.log(`\\n✅ Done!`);\nconsole.log(` Imported: ${imported}`);\nconsole.log(` Failed: ${failed}`);\nconsole.log(` Skipped (parse): ${puzzles.length - imported - failed + skipped}`);\n\nconst finalStats = await fetch(`${API_BASE}/api/stats`).then((r) => r.json());\nconsole.log(`\\nDB now has ${finalStats.puzzles} puzzles, ${finalStats.clues} clues.`);\n",[],[128,135],["D",1782505072423],[145,146,147,148],[19],{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":158,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":159,"_18":160},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":155,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_117":156,"_18":157},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":152,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_117":153,"_18":154},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":149,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_117":150,"_18":151},["D",1782505072423],[],[19,65],["D",1782505152099],[],[19,86],["D",1782505072423],[],[19,93],["D",1782505072423],[161,162],[19,99],{"_36":170,"_13":171,"_66":172,"_68":100,"_70":71,"_72":173,"_74":75,"_38":174,"_17":73,"_78":79,"_80":175,"_82":51,"_83":-5,"_117":176,"_18":177},{"_36":163,"_13":164,"_66":165,"_68":100,"_70":71,"_72":73,"_74":75,"_38":166,"_17":77,"_78":79,"_80":167,"_82":51,"_83":-5,"_117":168,"_18":169},"aa85801a-6b8c-48d0-9478-5745e06089b5","Counter.tsx","019f0594-e762-709d-bcd4-df3bad74b386",["D",1782505072423],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[19,99,164],"6882dd10-de73-4bd0-bda2-a0f2ed5c5534","App.tsx","019f0594-e762-709d-bcd4-dbf591fa996b",3,["D",1782505146495],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\n\nconst COLOR_STYLES: Record = {\n yellow: { bg: \"bg-yellow-100 border-yellow-300\", dot: \"bg-yellow-400\", label: \"Yellow\" },\n green: { bg: \"bg-green-100 border-green-300\", dot: \"bg-green-500\", label: \"Green\" },\n blue: { bg: \"bg-blue-100 border-blue-300\", dot: \"bg-blue-400\", label: \"Blue\" },\n purple: { bg: \"bg-purple-100 border-purple-300\", dot: \"bg-purple-500\", label: \"Purple\" },\n};\n\nconst COLOR_ORDER = [\"yellow\", \"green\", \"blue\", \"purple\"];\n\ntype Group = { color: string; category: string; words: string[] };\ntype PuzzleResult = { puzzle_number: number; puzzle_date: string; groups: Group[] };\n\nfunction formatDate(dateStr: string): string {\n try {\n const d = new Date(dateStr + \"T12:00:00Z\");\n return d.toLocaleDateString(\"en-US\", { year: \"numeric\", month: \"long\", day: \"numeric\", timeZone: \"UTC\" });\n } catch {\n return dateStr;\n }\n}\n\nfunction highlight(text: string, query: string, mode: string): JSX.Element {\n if (!query) return <>{text};\n const needle = query.toLowerCase();\n const haystack = text.toLowerCase();\n if (mode === \"exact\") {\n if (haystack === needle) {\n return {text};\n }\n return <>{text};\n }\n const idx = haystack.indexOf(needle);\n if (idx === -1) return <>{text};\n return (\n <>\n {text.slice(0, idx)}\n {text.slice(idx, idx + query.length)}\n {text.slice(idx + query.length)}\n \n );\n}\n\nfunction PuzzleCard({ puzzle, query, mode }: { puzzle: PuzzleResult; query: string; mode: string }) {\n const sorted = [...puzzle.groups].sort((a, b) => {\n const ai = COLOR_ORDER.indexOf(a.color.toLowerCase());\n const bi = COLOR_ORDER.indexOf(b.color.toLowerCase());\n return (ai === -1 ? 99 : ai) - (bi === -1 ? 99 : bi);\n });\n\n return (\n

\n {formatDate(puzzle.puzzle_date)}, #{puzzle.puzzle_number}\n

\n {sorted.map((g) => {\n const style = COLOR_STYLES[g.color.toLowerCase()] ?? {\n bg: \"bg-gray-100 border-gray-300\",\n dot: \"bg-gray-400\",\n label: g.color,\n };\n return (\n

\n \n

\n {g.category}:\n {g.words.map((w, i) => (\n \n {highlight(w, query, mode)}\n {i < g.words.length - 1 ? \", \" : \"\"}\n \n ))}\n

\n );\n })}\n

\n );\n}\n\ntype Tab = \"search\" | \"add\";\n\nexport function App() {\n const [tab, setTab] = useState(\"search\");\n const [stats, setStats] = useState<{ puzzles: number; clues: number } | null>(null);\n\n useEffect(() => {\n fetch(\"/api/stats\")\n .then((r) => r.json())\n .then(setStats)\n .catch(console.error);\n }, [tab]);\n\n return (\n

\n {/* Header */}\n

\n 🔗 Connections Archive\n

\n Search all words from past NYT Connections puzzles\n

\n {stats && (\n

\n {stats.puzzles} puzzle{stats.puzzles !== 1 ? \"s\" : \"\"} · {stats.clues} clues archived\n

\n )}\n

\n\n {/* Tabs */}\n

\n {([\"search\", \"add\"] as Tab[]).map((t) => (\n setTab(t)}\n class={`flex-1 py-1.5 text-sm font-medium rounded-md transition-all capitalize ${\n tab === t ? \"bg-white text-gray-900 shadow-sm\" : \"text-gray-500 hover:text-gray-700\"\n }`}\n >\n {t === \"search\" ? \"🔍 Search\" : \"➕ Add Puzzle\"}\n \n ))}\n

\n\n {tab === \"search\" ? : setTab(\"search\")} />}\n

\n );\n}\n\nfunction SearchTab() {\n const [query, setQuery] = useState(\"\");\n const [mode, setMode] = useState<\"substring\" | \"exact\">(\"substring\");\n const [results, setResults] = useState(null);\n const [loading, setLoading] = useState(false);\n const inputRef = useRef(null);\n\n useEffect(() => {\n inputRef.current?.focus();\n }, []);\n\n async function search(q: string, m: string) {\n if (!q.trim()) { setResults(null); return; }\n setLoading(true);\n try {\n const r = await fetch(`/api/search?q=${encodeURIComponent(q)}&mode=${m}`);\n const data = await r.json();\n setResults(data.results);\n } finally {\n setLoading(false);\n }\n }\n\n function handleSubmit(e: Event) {\n e.preventDefault();\n search(query, mode);\n }\n\n function handleModeChange(m: \"substring\" | \"exact\") {\n setMode(m);\n if (results !== null) search(query, m);\n }\n\n return (\n

\n setQuery((e.target as HTMLInputElement).value)}\n placeholder=\"Search for a word…\"\n class=\"flex-1 border border-gray-300 rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n \n Search\n \n \n\n {/* Mode toggle */}\n

\n \n handleModeChange(\"substring\")}\n class=\"accent-blue-600\"\n />\n Substring match\n \n \n handleModeChange(\"exact\")}\n class=\"accent-blue-600\"\n />\n Exact match\n \n

\n\n {loading && (\n

Searching…

\n )}\n\n {!loading && results !== null && (\n

\n {results.length === 0\n ? `No puzzles found for \"${query}\"`\n : `${results.length} puzzle${results.length !== 1 ? \"s\" : \"\"} found for \"${query}\"`}\n

\n {results.map((p) => (\n \n ))}\n

\n )}\n\n {!loading && results === null && (\n

🔍

Type a word and hit Search

\n )}\n

\n );\n}\n\nfunction AddTab({ onAdded }: { onAdded: () => void }) {\n const [puzzleNumber, setPuzzleNumber] = useState(\"\");\n const [puzzleDate, setPuzzleDate] = useState(\"\");\n const [groups, setGroups] = useState([\n { color: \"yellow\", category: \"\", words: \"\" },\n { color: \"green\", category: \"\", words: \"\" },\n { color: \"blue\", category: \"\", words: \"\" },\n { color: \"purple\", category: \"\", words: \"\" },\n ]);\n const [status, setStatus] = useState<{ type: \"success\" | \"error\"; msg: string } | null>(null);\n const [loading, setLoading] = useState(false);\n\n async function handleSubmit(e: Event) {\n e.preventDefault();\n setStatus(null);\n setLoading(true);\n try {\n const payload = {\n puzzle_number: parseInt(puzzleNumber),\n puzzle_date: puzzleDate,\n groups: groups.map((g) => ({\n color: g.color,\n category: g.category.trim(),\n words: g.words.split(\",\").map((w) => w.trim().toUpperCase()).filter(Boolean),\n })),\n };\n const r = await fetch(\"/api/puzzles\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n const data = await r.json();\n if (!r.ok) throw new Error(data.error ?? \"Unknown error\");\n setStatus({ type: \"success\", msg: `Puzzle #${data.puzzle_number} added (${data.clues_inserted} clues)` });\n setPuzzleNumber(\"\");\n setPuzzleDate(\"\");\n setGroups([\n { color: \"yellow\", category: \"\", words: \"\" },\n { color: \"green\", category: \"\", words: \"\" },\n { color: \"blue\", category: \"\", words: \"\" },\n { color: \"purple\", category: \"\", words: \"\" },\n ]);\n } catch (err: unknown) {\n setStatus({ type: \"error\", msg: String(err) });\n } finally {\n setLoading(false);\n }\n }\n\n return (\n

\n Puzzle #\n setPuzzleNumber((e.target as HTMLInputElement).value)}\n required\n placeholder=\"e.g. 365\"\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n

\n Date\n setPuzzleDate((e.target as HTMLInputElement).value)}\n required\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n

\n\n {groups.map((g, i) => {\n const style = COLOR_STYLES[g.color] ?? { dot: \"bg-gray-400\", bg: \"\", label: g.color };\n return (\n

\n \n {g.color}\n

\n {\n const updated = [...groups];\n updated[i] = { ...g, category: (e.target as HTMLInputElement).value };\n setGroups(updated);\n }}\n required\n placeholder=\"Category name (e.g. TIGHTLY PACKED)\"\n class=\"w-full border border-gray-300 rounded-md px-2.5 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n {\n const updated = [...groups];\n updated[i] = { ...g, words: (e.target as HTMLInputElement).value };\n setGroups(updated);\n }}\n required\n placeholder=\"Words, comma-separated (e.g. COMPACT, DENSE, SQUASHED, COMPRESSED)\"\n class=\"w-full border border-gray-300 rounded-md px-2.5 py-1.5 text-sm focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n

\n );\n })}\n\n {status && (\n \n {status.msg}\n \n )}\n\n \n {loading ? \"Adding…\" : \"Add Puzzle\"}\n \n \n );\n}\n",[],[19,99,171],"fcd5a565-8cff-4b4a-886e-c6decfe884f2",["D",1782505072423],"legacyEnvVars","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789534799&sig=2fe932419d898cd124d0961cab25a5a9c3bd76c8b30cb3b9e71257c7b34e60a2","userId","4672fa32-1c6f-4907-899e-57b7e45b1dcb","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019e83d1-d41f-725b-9693-b632d430a029","tursoName","fcd5a5658cff4b4a886ec6decfe884f2","tursoHostname","fcd5a5658cff4b4a886ec6decfe884f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789500689328],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_227":223},"org",{"_11":12,"_220":221,"_222":223,"_186":187,"_224":225,"_226":51},"branch",{"_17":137,"_13":16,"_36":71,"_42":178,"_45":37,"_46":216,"_217":53,"_218":43,"_219":57,"_58":14,"_54":12},89,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Potluck Mittal","avatar","https://lh3.googleusercontent.com/a/ACg8ocJYeiSQ8_eyVYtUAg9f5qRwEXzS1AreFm572a1csvZx7c6b_S8=s96-c","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":178,"_13":14,"_38":304,"_49":-5,"_180":51,"_52":53,"_181":53,"_182":183,"_184":185,"_186":187,"_188":113,"_189":75,"_190":-5,"_191":-5,"_192":77,"_56":193,"_194":195,"_196":197,"_198":305,"_200":-5,"_201":202,"_203":202,"_204":205,"_206":205,"_207":205,"_208":202,"_209":202,"_210":306,"_212":307,"_214":308,"_50":51},[271,278,280,281],"files",[271,272,273,274,275,276,277,278,279,280,281],"counts",{"_262":77,"_263":73,"_264":77,"_35":265,"_266":267},[254,255,256,257],{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":105,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":253},"upstreamProject",{"_36":43,"_13":59,"_182":183,"_184":185,"_52":53,"_210":251},"upstreamBranch",{"_36":37,"_38":249,"_40":250,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],{"_11":55,"_227":252},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789534799&sig=94d49ad984a50880ef894a3794e08842e7b9b626be771ff48da114d7d9a149ed",[19],{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":101,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_18":261},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":95,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_18":260},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":89,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_18":259},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":76,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_18":258},[19,65],[19,86],[19,93],[19,99],"pulls","branches","forks",{"_268":77,"_270":77},"connections",{"_268":77,"_269":77},"count","unfilledCount","emptyCount",{"_36":104,"_13":19,"_66":69,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":142,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":302,"_18":303},{"_36":98,"_13":99,"_66":100,"_68":69,"_70":71,"_72":73,"_74":75,"_38":158,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":300,"_18":301},{"_36":170,"_13":171,"_66":172,"_68":100,"_70":71,"_72":173,"_74":75,"_38":174,"_17":73,"_78":79,"_80":175,"_82":51,"_83":-5,"_117":298,"_18":299},{"_36":163,"_13":164,"_66":165,"_68":100,"_70":71,"_72":73,"_74":75,"_38":166,"_17":77,"_78":79,"_80":167,"_82":51,"_83":-5,"_117":296,"_18":297},{"_36":92,"_13":93,"_66":94,"_68":69,"_70":71,"_72":73,"_74":75,"_38":155,"_17":77,"_78":24,"_80":96,"_82":51,"_83":-5,"_117":294,"_18":295},{"_36":85,"_13":86,"_66":87,"_68":69,"_70":71,"_72":88,"_74":75,"_38":152,"_17":73,"_78":24,"_80":90,"_82":51,"_83":-5,"_117":292,"_18":293},{"_36":64,"_13":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_38":149,"_17":77,"_78":79,"_80":81,"_82":51,"_83":-5,"_117":290,"_18":291},{"_36":127,"_13":128,"_66":129,"_68":-5,"_70":71,"_72":32,"_74":75,"_38":130,"_17":77,"_78":102,"_80":-5,"_82":51,"_83":-5,"_117":288,"_18":289},{"_36":134,"_13":135,"_66":136,"_68":129,"_70":71,"_72":137,"_74":75,"_38":138,"_17":73,"_78":79,"_80":139,"_82":51,"_83":-5,"_117":286,"_18":287},{"_36":120,"_13":121,"_66":122,"_68":-5,"_70":71,"_72":73,"_74":75,"_38":123,"_17":77,"_78":24,"_80":124,"_82":51,"_83":-5,"_117":284,"_18":285},{"_36":111,"_13":112,"_66":113,"_68":-5,"_70":71,"_72":34,"_74":75,"_38":114,"_17":73,"_78":115,"_80":116,"_82":51,"_83":-5,"_117":282,"_18":283},[],[112],[],[121],[],[128,135],[279],[128],[],[19,65],[],[19,86],[],[19,93],[],[19,99,164],[],[19,99,171],[273,274],[19,99],[272,275,276,277],[19],["D",1782505072423],["D",1789500689328],{"_11":12,"_227":223},{"_11":12,"_220":221,"_222":223,"_186":187,"_224":225,"_226":51},{"_17":137,"_13":16,"_36":71,"_42":178,"_45":37,"_46":216,"_217":53,"_218":43,"_219":57,"_58":14,"_54":12},"ctx",{"_210":-5,"_246":342,"_343":344,"_345":346,"_347":51,"_348":51,"_349":51,"_350":75,"_351":-5,"_352":-7,"_353":-7,"_354":77,"_355":51,"_356":51,"_357":-5,"_358":51,"_359":51,"_360":51,"_361":-5},"ENV",{"_313":314,"_315":316,"_317":16,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341},"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"]