\n \n \n \n",[],[193,274],"51a11e68-07cd-11f1-9631-42dde27851f2","favicon.svg","51a11ef4-07cd-11f1-9631-42dde27851f2",["D",1770871384419],"\n",[],[193,281],"51a101ee-07cd-11f1-9631-42dde27851f2","App.tsx","51a102b6-07cd-11f1-9631-42dde27851f2","019c5028-e961-70b8-9c87-b144cb98315b",["D",1770871384419],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [clicked, setClicked] = useState(0);\n return (\n

Val Town React + Hono Starter

\n I've been clicked times\n

\n );\n}",[],[193,295,288],"components","51a135d8-07cd-11f1-9631-42dde27851f2",["D",1770871384419],[220],[193,295],["D",1770871384419],[219,221,222,223,224,225],[193],"b92fdb7a-07c6-11f1-9d4c-42dde27851f2","schema.ts","b92fdc1a-07c6-11f1-9d4c-42dde27851f2",6,["D",1770868551696],"import { sqliteTable, text, integer, uniqueIndex } from \"npm:drizzle-orm/sqlite-core\";\nimport { sql } from \"npm:drizzle-orm\";\n\n// ─── Table prefix to avoid collisions with other vals ─────\n\nexport const events = sqliteTable(\"ll_events\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n date: text(\"date\").notNull(),\n active: integer(\"active\", { mode: \"boolean\" }).default(false),\n});\n\nexport const sessions = sqliteTable(\"ll_sessions\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n eventId: integer(\"event_id\")\n .notNull()\n .references(() => events.id),\n name: text(\"name\").notNull(),\n startTime: text(\"start_time\"),\n endTime: text(\"end_time\"),\n sortOrder: integer(\"sort_order\").default(0),\n});\n\nexport const books = sqliteTable(\"ll_books\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n eventId: integer(\"event_id\")\n .notNull()\n .references(() => events.id),\n title: text(\"title\").notNull(),\n authorName: text(\"author_name\").notNull(),\n synopsis: text(\"synopsis\").default(\"\"),\n});\n\nexport const bookSessions = sqliteTable(\n \"ll_book_sessions\",\n {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n bookId: integer(\"book_id\")\n .notNull()\n .references(() => books.id),\n sessionId: integer(\"session_id\")\n .notNull()\n .references(() => sessions.id),\n maxSlots: integer(\"max_slots\").notNull().default(8),\n },\n (table) => [uniqueIndex(\"book_session_uniq\").on(table.bookId, table.sessionId)],\n);\n\nexport const readers = sqliteTable(\"ll_readers\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n email: text(\"email\").notNull().unique(),\n createdAt: text(\"created_at\").default(sql`(datetime('now'))`),\n});\n\nexport const registrations = sqliteTable(\n \"ll_registrations\",\n {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n readerId: integer(\"reader_id\")\n .notNull()\n .references(() => readers.id),\n bookSessionId: integer(\"book_session_id\")\n .notNull()\n .references(() => bookSessions.id),\n sessionId: integer(\"session_id\")\n .notNull()\n .references(() => sessions.id),\n createdAt: text(\"created_at\").default(sql`(datetime('now'))`),\n },\n (table) => [uniqueIndex(\"reader_session_uniq\").on(table.readerId, table.sessionId)],\n);\n",[],[199,304],"8bd9f0be-07c8-11f1-bb1a-42dde27851f2","queries.ts","d37e0b8c-07c6-11f1-ab37-42dde27851f2",28,["D",1770869334626],"import { eq, and, sql, count } from \"npm:drizzle-orm\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { db, schema } from \"./client.ts\";\n\nconst { events, sessions, books, bookSessions, readers, registrations } = schema;\n\n// ─── Schema bootstrap ────────────────────────────────────────\n// We use raw SQL here because Drizzle doesn't generate\n// CREATE TABLE IF NOT EXISTS. This runs once on cold start.\n\nexport async function initSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS ll_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n date TEXT NOT NULL,\n active INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS ll_sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL REFERENCES ll_events(id),\n name TEXT NOT NULL,\n start_time TEXT,\n end_time TEXT,\n sort_order INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS ll_books (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL REFERENCES ll_events(id),\n title TEXT NOT NULL,\n author_name TEXT NOT NULL,\n synopsis TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS ll_book_sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n book_id INTEGER NOT NULL REFERENCES ll_books(id),\n session_id INTEGER NOT NULL REFERENCES ll_sessions(id),\n max_slots INTEGER NOT NULL DEFAULT 8,\n UNIQUE(book_id, session_id)\n )`,\n `CREATE TABLE IF NOT EXISTS ll_readers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS ll_registrations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n reader_id INTEGER NOT NULL REFERENCES ll_readers(id),\n book_session_id INTEGER NOT NULL REFERENCES ll_book_sessions(id),\n session_id INTEGER NOT NULL REFERENCES ll_sessions(id),\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(reader_id, session_id)\n )`,\n ]);\n}\n\n// ─── Events ──────────────────────────────────────────────────\n\nexport async function getActiveEvent() {\n const result = await db\n .select({\n id: events.id,\n name: events.name,\n date: events.date,\n })\n .from(events)\n .where(eq(events.active, true))\n .limit(1);\n\n return result[0] ?? null;\n}\n\n// ─── Availability ────────────────────────────────────────────\n// This is the hot path — polled every 3s by 250 clients.\n// Single query, no N+1.\n\nexport async function getEventAvailability(eventId: number, readerId?: number) {\n const result = await sqlite.execute({\n sql: `\n SELECT \n s.id as session_id,\n s.name as session_name,\n s.start_time,\n s.end_time,\n s.sort_order,\n bs.id as book_session_id,\n b.id as book_id,\n b.title,\n b.author_name,\n b.synopsis,\n bs.max_slots,\n (SELECT COUNT(*) FROM ll_registrations r WHERE r.book_session_id = bs.id) as registered_count\n FROM ll_sessions s\n JOIN ll_book_sessions bs ON bs.session_id = s.id\n JOIN ll_books b ON b.id = bs.book_id\n WHERE s.event_id = ?\n ORDER BY s.sort_order, s.id, b.title\n `,\n args: [eventId],\n });\n\n // Fetch reader's current registrations if logged in\n let myRegs: { sessionId: number; bookSessionId: number }[] = [];\n if (readerId) {\n const regsResult = await db\n .select({\n sessionId: registrations.sessionId,\n bookSessionId: registrations.bookSessionId,\n })\n .from(registrations)\n .where(eq(registrations.readerId, readerId));\n\n myRegs = regsResult;\n }\n\n // Group flat rows into session → books structure\n const sessionsMap = new Map();\n\n for (const row of result.rows) {\n const r = row as any;\n const sessionId = r.session_id;\n const sessionName = r.session_name;\n const startTime = r.start_time;\n const endTime = r.end_time;\n const bookSessionId = r.book_session_id;\n const bookId = r.book_id;\n const title = r.title;\n const authorName = r.author_name;\n const synopsis = r.synopsis;\n const maxSlots = r.max_slots;\n const registeredCount = r.registered_count;\n\n if (!sessionsMap.has(sessionId)) {\n sessionsMap.set(sessionId, {\n id: sessionId,\n name: sessionName,\n startTime,\n endTime,\n books: [],\n });\n }\n\n const myReg = myRegs.find((mr) => mr.sessionId === sessionId);\n\n sessionsMap.get(sessionId).books.push({\n bookSessionId,\n bookId,\n title,\n authorName,\n synopsis,\n maxSlots,\n registeredCount,\n slotsLeft: maxSlots - registeredCount,\n isRegistered: myReg?.bookSessionId === bookSessionId,\n });\n }\n\n return {\n sessions: Array.from(sessionsMap.values()),\n myRegistrations: myRegs,\n };\n}\n\n// ─── Readers ─────────────────────────────────────────────────\n\nexport async function findOrCreateReader(name: string, email: string) {\n const normalizedEmail = email.toLowerCase().trim();\n\n const existing = await db\n .select({ id: readers.id, name: readers.name, email: readers.email })\n .from(readers)\n .where(eq(readers.email, normalizedEmail))\n .limit(1);\n\n if (existing.length > 0) {\n const reader = existing[0];\n // Update name if changed (e.g. typo fix)\n if (reader.name !== name) {\n await db\n .update(readers)\n .set({ name })\n .where(eq(readers.id, reader.id));\n }\n return { id: reader.id, name, email: reader.email };\n }\n\n const result = await db\n .insert(readers)\n .values({ name, email: normalizedEmail })\n .returning({ id: readers.id, name: readers.name, email: readers.email });\n\n return result[0];\n}\n\n// ─── Registration ────────────────────────────────────────────\n// Atomic: delete existing pick for this session, then conditionally\n// insert if slots remain. Both in a single batch (transaction).\n\nexport async function registerForBook(\n readerId: number,\n bookSessionId: number,\n sessionId: number,\n) {\n const results = await sqlite.batch([\n {\n sql: `DELETE FROM ll_registrations WHERE reader_id = ? AND session_id = ?`,\n args: [readerId, sessionId],\n },\n {\n sql: `\n INSERT INTO ll_registrations (reader_id, book_session_id, session_id)\n SELECT ?, ?, ?\n WHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n `,\n args: [readerId, bookSessionId, sessionId, bookSessionId, bookSessionId],\n },\n ]);\n\n return { ok: results[1].rowsAffected > 0 };\n}\n\nexport async function unregisterFromSession(readerId: number, sessionId: number) {\n await db\n .delete(registrations)\n .where(\n and(\n eq(registrations.readerId, readerId),\n eq(registrations.sessionId, sessionId),\n ),\n );\n\n return { ok: true };\n}\n\n// ─── Library Card ────────────────────────────────────────────\n\nexport async function getReaderCard(readerId: number) {\n const readerResult = await db\n .select({ id: readers.id, name: readers.name, email: readers.email })\n .from(readers)\n .where(eq(readers.id, readerId))\n .limit(1);\n\n if (readerResult.length === 0) return null;\n const reader = readerResult[0];\n\n const regsResult = await sqlite.execute({\n sql: `\n SELECT \n s.name as session_name,\n s.start_time,\n s.end_time,\n b.title,\n b.author_name,\n e.name as event_name,\n e.date as event_date\n FROM ll_registrations r\n JOIN ll_book_sessions bs ON bs.id = r.book_session_id\n JOIN ll_sessions s ON s.id = r.session_id\n JOIN ll_books b ON b.id = bs.book_id\n JOIN ll_events e ON e.id = s.event_id\n WHERE r.reader_id = ?\n ORDER BY e.date DESC, s.sort_order, s.id\n `,\n args: [readerId],\n });\n\n const readings = regsResult.rows.map((row: any) => ({\n sessionName: row.session_name,\n startTime: row.start_time,\n endTime: row.end_time,\n title: row.title,\n authorName: row.author_name,\n eventName: row.event_name,\n eventDate: row.event_date,\n }));\n\n return { ...reader, readings };\n}\n",[],[199,312],"52f5f068-07c8-11f1-b235-42dde27851f2","client.ts","bfc988aa-07c6-11f1-ab3d-42dde27851f2",21,["D",1770869239116],"/**\n * Drizzle ORM instance using Val Town's built-in SQLite.\n *\n * Uses val-scoped sqlite (isolated to this project) with\n * drizzle-orm/libsql/web as recommended by Val Town docs.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { drizzle } from \"npm:drizzle-orm/libsql/web\";\nimport * as schema from \"./schema.ts\";\n\nexport const db = drizzle(sqlite as any, { schema });\n\nexport { schema };\n",[],[199,320],["D",1770868539664],[215,216,217],[199],["D",1770868165845],["D",1789518064818],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":26},{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_127":368,"_369":370,"_371":372,"_373":26,"_374":26,"_375":26,"_376":24,"_377":-5,"_378":-7,"_379":-7,"_380":63,"_381":26,"_382":26,"_383":-5,"_384":26,"_385":26,"_386":26,"_387":-5},"ENV",{"_339":340,"_341":342,"_343":90,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v31