\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",[196,97,75],"6882dd10-de73-4bd0-bda2-a0f2ed5c5534",["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",[196,97,86],"pulls","branches","forks","envVars",{"_82":26,"_215":26},"connections",{"_82":26,"_214":26},"unfilledCount","emptyCount",{"_34":287,"_13":196,"_73":189,"_44":-5,"_36":37,"_190":41,"_191":24,"_38":288,"_40":26,"_76":98,"_193":-5,"_78":30,"_194":-5,"_232":289,"_17":290},{"_34":188,"_13":97,"_73":96,"_44":189,"_36":37,"_190":41,"_191":24,"_38":284,"_40":26,"_76":98,"_193":-5,"_78":30,"_194":-5,"_232":285,"_17":286},{"_34":203,"_13":86,"_73":85,"_44":96,"_36":37,"_190":89,"_191":24,"_38":281,"_40":41,"_76":77,"_193":205,"_78":30,"_194":-5,"_232":282,"_17":283},{"_34":199,"_13":75,"_73":74,"_44":96,"_36":37,"_190":41,"_191":24,"_38":278,"_40":26,"_76":77,"_193":201,"_78":30,"_194":-5,"_232":279,"_17":280},{"_34":271,"_13":272,"_73":273,"_44":189,"_36":37,"_190":41,"_191":24,"_38":274,"_40":26,"_76":21,"_193":275,"_78":30,"_194":-5,"_232":276,"_17":277},{"_34":263,"_13":264,"_73":265,"_44":189,"_36":37,"_190":266,"_191":24,"_38":267,"_40":41,"_76":21,"_193":268,"_78":30,"_194":-5,"_232":269,"_17":270},{"_34":256,"_13":257,"_73":258,"_44":189,"_36":37,"_190":41,"_191":24,"_38":259,"_40":26,"_76":77,"_193":260,"_78":30,"_194":-5,"_232":261,"_17":262},{"_34":251,"_13":250,"_73":245,"_44":-5,"_36":37,"_190":252,"_191":24,"_38":253,"_40":26,"_76":98,"_193":-5,"_78":30,"_194":-5,"_232":254,"_17":255},{"_34":242,"_13":243,"_73":244,"_44":245,"_36":37,"_190":138,"_191":24,"_38":246,"_40":41,"_76":77,"_193":247,"_78":30,"_194":-5,"_232":248,"_17":249},{"_34":235,"_13":236,"_73":237,"_44":-5,"_36":37,"_190":41,"_191":24,"_38":238,"_40":26,"_76":21,"_193":239,"_78":30,"_194":-5,"_232":240,"_17":241},{"_34":227,"_13":228,"_73":111,"_44":-5,"_36":37,"_190":83,"_191":24,"_38":229,"_40":41,"_76":230,"_193":231,"_78":30,"_194":-5,"_232":233,"_17":234},"97ff35b1-5e3b-49fb-ba29-a694fd4f2897","index.ts",["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",[],[228],"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",[],[236],"38d5a21e-f302-4ada-97a4-89b65ebdbd07","import-archive.ts","a4e9dc34-719c-11f1-bc07-1607ee4eb77e","e5cbff70-cdda-4058-9573-63adeceb23e5",["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",[],[250,243],"scripts","444b1995-5c2a-49ec-a410-cd94c5ac0162",5,["D",1782505302068],[224],[250],"f53584c0-101e-4fcb-92c6-998a9675f4ae","index.tsx","019f0594-e762-709d-bcd4-eee68a14b224",["D",1782505072423],"/** @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();",[],[196,257],"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",[],[196,264],"d1a572f3-1a50-40a4-bd9b-2fd0f15e94fd","favicon.svg","019f0594-e762-709d-bcd4-e5248efd08af",["D",1782505072423],"\n",[],[196,272],["D",1782505072423],[],[196,97,75],["D",1782505146495],[],[196,97,86],["D",1782505072423],[218,219],[196,97],"3b06a731-899f-40e0-b822-fb8f63345e17",["D",1782505072423],[217,220,221,222],[196],["D",1782505072423],["D",1789500689328],{"_11":12,"_155":81},{"_11":12,"_150":151,"_80":81,"_31":79,"_152":153,"_154":30},{"_40":138,"_13":16,"_34":37,"_139":100,"_140":70,"_141":142,"_143":104,"_144":145,"_146":147,"_148":14,"_149":12},"ctx",{"_53":-5,"_176":329,"_330":331,"_332":333,"_334":30,"_335":30,"_336":30,"_337":24,"_338":-5,"_339":-7,"_340":-7,"_341":26,"_342":30,"_343":30,"_344":-5,"_345":30,"_346":30,"_347":30,"_348":-5},"ENV",{"_300":301,"_302":303,"_304":16,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

History · components