[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_100":99,"_32":46,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":127,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",24,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","db/queries.ts","latestPath","fileId","d37e0b8c-07c6-11f1-ab37-42dde27851f2","name","queries.ts","fileType","script","content","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 sqlite-proxy doesn't support\n// CREATE TABLE IF NOT EXISTS directly. 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 [\n sessionId, sessionName, startTime, endTime, _sortOrder,\n bookSessionId, bookId, title, authorName, synopsis,\n maxSlots, registeredCount,\n ] = row;\n\n if (!sessionsMap.has(sessionId as number)) {\n sessionsMap.set(sessionId as number, {\n id: sessionId,\n name: sessionName,\n startTime,\n endTime,\n books: [],\n });\n }\n\n const myReg = myRegs.find((r) => r.sessionId === sessionId);\n\n sessionsMap.get(sessionId as number).books.push({\n bookSessionId,\n bookId,\n title,\n authorName,\n synopsis,\n maxSlots,\n registeredCount,\n slotsLeft: (maxSlots as number) - (registeredCount as number),\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(\n ([sessionName, startTime, endTime, title, authorName, eventName, eventDate]) => ({\n sessionName,\n startTime,\n endTime,\n title,\n authorName,\n eventName,\n eventDate,\n }),\n );\n\n return { ...reader, readings };\n}\n","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 sqlite-proxy doesn't support\n// CREATE TABLE IF NOT EXISTS directly. 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(\n ([sessionName, startTime, endTime, title, authorName, eventName, eventDate]) => ({\n sessionName,\n startTime,\n endTime,\n title,\n authorName,\n eventName,\n eventDate,\n }),\n );\n\n return { ...reader, readings };\n}\n","createdAt",["D",1770869303672],"branchVersion","branchId","d33342ec-07c5-11f1-8d85-42dde27851f2","id","d3330110-07c5-11f1-8d85-42dde27851f2","living-stories-self-registration",["D",1770868165845],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Registration for sessions at LSC Events","imageUrl","3ee322c5-8742-48e0-86c7-5f3ae129683b","pinnedFileId","dee11794-07c6-11f1-9da1-42dde27851f2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","f427167a-3263-4778-81d8-f79626323ff5","tursoName","d333011007c511f18d8542dde27851f2","tursoHostname","d333011007c511f18d8542dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518064818],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",117,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kamalnrf","handle","displayName","Kamal","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaVpXT3l1d2hWSFdtWTNoZFIwZ0lFUUhOd2oifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":278,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":279,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":280,"_84":281,"_86":282,"_88":25},"tree",[217,221,222,223,224,225,226,227,228],"files",[217,218,219,220,221,222,223,224,225,226,227,228],"counts",{"_207":63,"_208":169,"_209":63,"_210":211,"_212":213},"contents",[132,133,134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_44":200,"_32":201,"_30":202,"_144":-5,"_42":43,"_41":203,"_146":127,"_39":204,"_13":63,"_34":205,"_36":-5,"_24":25,"_150":-5,"_27":206},{"_44":194,"_32":195,"_30":196,"_144":-5,"_42":43,"_41":148,"_146":127,"_39":197,"_13":63,"_34":20,"_36":198,"_24":25,"_150":-5,"_27":199},{"_44":187,"_32":188,"_30":189,"_144":-5,"_42":43,"_41":190,"_146":25,"_39":191,"_13":169,"_34":20,"_36":192,"_24":25,"_150":-5,"_27":193},{"_44":180,"_32":181,"_30":182,"_144":-5,"_42":43,"_41":183,"_146":25,"_39":184,"_13":169,"_34":20,"_36":185,"_24":25,"_150":-5,"_27":186},{"_44":173,"_32":174,"_30":175,"_144":-5,"_42":43,"_41":176,"_146":127,"_39":177,"_13":63,"_34":35,"_36":178,"_24":25,"_150":-5,"_27":179},{"_44":166,"_32":167,"_30":168,"_144":-5,"_42":43,"_41":169,"_146":127,"_39":170,"_13":63,"_34":20,"_36":171,"_24":25,"_150":-5,"_27":172},{"_44":159,"_32":160,"_30":58,"_144":-5,"_42":43,"_41":161,"_146":25,"_39":162,"_13":63,"_34":163,"_36":164,"_24":25,"_150":-5,"_27":165},{"_44":152,"_32":153,"_30":154,"_144":-5,"_42":43,"_41":155,"_146":25,"_39":156,"_13":148,"_34":35,"_36":157,"_24":25,"_150":-5,"_27":158},{"_44":141,"_32":142,"_30":143,"_144":-5,"_42":43,"_41":145,"_146":25,"_39":147,"_13":148,"_34":35,"_36":149,"_24":25,"_150":-5,"_27":151},"7dbd6dc2-07c7-11f1-8289-42dde27851f2","views.ts","e505d0c4-07c6-11f1-8d61-42dde27851f2","parentId",18,"latest",["D",1770868881450],2,"/**\n * Minimal placeholder view. The full React SPA will be built\n * in a separate iteration — for now this confirms the API is wired up.\n */\nexport function renderApp(): string {\n return `\n\n\n \n \n Living Library\n \n \n\n\n

📖 Living Library

API is running.

API Endpoints

\nGET  /api/events/active           → Active event\nGET  /api/events/:id/availability → Sessions + slot counts\nPOST /api/reader                  → { name, email } → find/create reader\nPOST /api/register                → { readerId, bookSessionId, sessionId }\nDEL  /api/register                → { readerId, sessionId }\nGET  /api/readers/:id/card        → Library card\n

\n\n`;\n}","label",[142],"58fa9df6-07c8-11f1-9025-42dde27851f2","seed.ts","f1a63db4-07c6-11f1-9554-42dde27851f2",23,["D",1770869249279],"/**\n * Seed script — run once as a \"script\" file to populate sample data.\n * Edit EVENT, SESSIONS, BOOKS below to match your actual event.\n * Re-running is safe: clears existing data first.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initSchema } from \"./db/queries.ts\";\n\n// ─── Your event config ───────────────────────────────────────\n\nconst EVENT = {\n name: \"Living Library Hyderabad #6\",\n date: \"2026-02-22\",\n};\n\nconst SESSIONS = [\n { name: \"Session 1\", startTime: \"10:00 AM\", endTime: \"10:45 AM\", sortOrder: 1 },\n { name: \"Session 2\", startTime: \"11:00 AM\", endTime: \"11:45 AM\", sortOrder: 2 },\n { name: \"Session 3\", startTime: \"12:00 PM\", endTime: \"12:45 PM\", sortOrder: 3 },\n];\n\nconst MAX_SLOTS_PER_BOOK = 8;\n\nconst BOOKS = [\n {\n title: \"From Hacker to Healer\",\n authorName: \"Arjun\",\n synopsis: \"A former cybersecurity expert's journey into mental health advocacy.\",\n },\n {\n title: \"Living with Invisible Illness\",\n authorName: \"Meera\",\n synopsis: \"Navigating life with a chronic condition that no one can see.\",\n },\n {\n title: \"The Queer Almanac\",\n authorName: \"Ravi\",\n synopsis: \"Growing up queer in a small Indian town.\",\n },\n {\n title: \"Colours of Grief\",\n authorName: \"Priya\",\n synopsis: \"A mother's experience of loss and finding meaning after.\",\n },\n {\n title: \"Between Two Worlds\",\n authorName: \"Fatima\",\n synopsis: \"The immigrant experience — belonging everywhere and nowhere.\",\n },\n {\n title: \"Off the Grid\",\n authorName: \"Karthik\",\n synopsis: \"Leaving a tech career to farm — and what I learned about life.\",\n },\n];\n\n// Optional: restrict specific books to specific sessions.\n// Keys are book titles, values are 1-indexed session numbers.\n// null = every book in every session (default)\nconst BOOK_SESSION_OVERRIDES: Record | null = null;\n\n// ─── Seed ────────────────────────────────────────────────────\n\nawait initSchema();\n\n// Clear (order matters for FK constraints)\nawait sqlite.batch([\n \"DELETE FROM ll_registrations\",\n \"DELETE FROM ll_book_sessions\",\n \"DELETE FROM ll_books\",\n \"DELETE FROM ll_sessions\",\n \"DELETE FROM ll_events\",\n]);\n\n// Event\nconst eventResult = await sqlite.execute({\n sql: \"INSERT INTO ll_events (name, date, active) VALUES (?, ?, 1)\",\n args: [EVENT.name, EVENT.date],\n});\nconst eventId = eventResult.lastInsertRowid;\nconsole.log(`Created event: ${EVENT.name} (id=${eventId})`);\n\n// Sessions\nconst sessionIds: number[] = [];\nfor (const s of SESSIONS) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO ll_sessions (event_id, name, start_time, end_time, sort_order) VALUES (?, ?, ?, ?, ?)\",\n args: [eventId, s.name, s.startTime, s.endTime, s.sortOrder],\n });\n sessionIds.push(Number(r.lastInsertRowid));\n console.log(` Session: ${s.name} (id=${r.lastInsertRowid})`);\n}\n\n// Books + book_sessions\nfor (const b of BOOKS) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO ll_books (event_id, title, author_name, synopsis) VALUES (?, ?, ?, ?)\",\n args: [eventId, b.title, b.authorName, b.synopsis],\n });\n const bookId = Number(r.lastInsertRowid);\n\n const allowedSessions = BOOK_SESSION_OVERRIDES?.[b.title]\n ? BOOK_SESSION_OVERRIDES[b.title].map((i) => sessionIds[i - 1])\n : sessionIds;\n\n for (const sessionId of allowedSessions) {\n await sqlite.execute({\n sql: \"INSERT INTO ll_book_sessions (book_id, session_id, max_slots) VALUES (?, ?, ?)\",\n args: [bookId, sessionId, MAX_SLOTS_PER_BOOK],\n });\n }\n console.log(` Book: \"${b.title}\" by ${b.authorName} → ${allowedSessions.length} sessions`);\n}\n\nconsole.log(\"\\n✅ Seed complete!\");\n",[153],"dee116c2-07c6-11f1-9da1-42dde27851f2","index.ts",10,["D",1770868614934],"http","import { Hono } from \"npm:hono\";\nimport { initSchema } from \"./db/queries.ts\";\nimport api from \"./api.ts\";\nimport { renderApp } from \"./views.ts\";\n\nconst app = new Hono();\n\n// Initialize schema once on cold start\nlet schemaReady = false;\napp.use(\"*\", async (_c, next) => {\n if (!schemaReady) {\n await initSchema();\n schemaReady = true;\n }\n await next();\n});\n\n// API routes\napp.route(\"/api\", api);\n\n// SPA shell\napp.get(\"*\", (c) => {\n return c.html(renderApp());\n});\n\n// Surface real errors during development\napp.onError((err, c) => {\n console.error(err);\n return c.json({ error: err.message }, 500);\n});\n\nexport default app.fetch;\n",[160],"03abc354-07c6-11f1-b71e-42dde27851f2","deno.json","03abc3fe-07c6-11f1-b71e-42dde27851f2",1,["D",1770868247163],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[167],"da44c924-07c6-11f1-931b-42dde27851f2","api.ts","da44c9c4-07c6-11f1-931b-42dde27851f2",9,["D",1770868607201],"import { Hono } from \"npm:hono\";\nimport {\n getActiveEvent,\n getEventAvailability,\n findOrCreateReader,\n registerForBook,\n unregisterFromSession,\n getReaderCard,\n} from \"./db/queries.ts\";\n\nconst api = new Hono();\n\n// ─── Event ───────────────────────────────────────────────────\n\napi.get(\"/events/active\", async (c) => {\n const event = await getActiveEvent();\n if (!event) return c.json({ error: \"No active event\" }, 404);\n return c.json(event);\n});\n\napi.get(\"/events/:id/availability\", async (c) => {\n const eventId = Number(c.req.param(\"id\"));\n const readerId = c.req.query(\"readerId\")\n ? Number(c.req.query(\"readerId\"))\n : undefined;\n const data = await getEventAvailability(eventId, readerId);\n return c.json(data);\n});\n\n// ─── Reader ──────────────────────────────────────────────────\n\napi.post(\"/reader\", async (c) => {\n const { name, email } = await c.req.json();\n if (!name?.trim() || !email?.trim()) {\n return c.json({ error: \"Name and email are required\" }, 400);\n }\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email.trim())) {\n return c.json({ error: \"Please enter a valid email\" }, 400);\n }\n const reader = await findOrCreateReader(name.trim(), email.trim());\n return c.json(reader);\n});\n\napi.get(\"/readers/:id/card\", async (c) => {\n const readerId = Number(c.req.param(\"id\"));\n const card = await getReaderCard(readerId);\n if (!card) return c.json({ error: \"Reader not found\" }, 404);\n return c.json(card);\n});\n\n// ─── Registration ────────────────────────────────────────────\n\napi.post(\"/register\", async (c) => {\n const { readerId, bookSessionId, sessionId } = await c.req.json();\n if (!readerId || !bookSessionId || !sessionId) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n const result = await registerForBook(readerId, bookSessionId, sessionId);\n if (!result.ok) {\n return c.json(\n { error: \"This book is full — please pick another\", ok: false },\n 409,\n );\n }\n return c.json({ ok: true });\n});\n\napi.delete(\"/register\", async (c) => {\n const { readerId, sessionId } = await c.req.json();\n if (!readerId || !sessionId) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n return c.json(await unregisterFromSession(readerId, sessionId));\n});\n\nexport default api;\n",[174],"230cbb26-07c7-11f1-996c-42dde27851f2","CLAUDE.md","af3d9332-07c6-11f1-8fba-42dde27851f2",15,["D",1770868729260],"# Living Library — Self-Registration System\n\nA self-service registration app for Living Library events in Hyderabad. Readers register with name + email, browse available \"books\" (people sharing their stories), and claim reading slots — all in real-time as 250+ people sign up simultaneously.\n\n## Architecture\n\n```\n┌─────────────────────────────────────────────────────────┐\n│ Client (React + Pico CSS) │\n│ ┌──────────┐ ┌──────────────┐ ┌──────────────────┐ │\n│ │ Register │→ │ Browse Books │→ │ Library Card View │ │\n│ │ (name + │ │ (polls every │ │ (reading history) │ │\n│ │ email) │ │ 3 seconds) │ │ │ │\n│ └──────────┘ └──────┬───────┘ └──────────────────┘ │\n│ │ │\n│ localStorage: { id, name, email } │\n└───────────────────────┼─────────────────────────────────┘\n │ HTTP\n┌───────────────────────┼─────────────────────────────────┐\n│ Server (Hono) │ │\n│ ▼ │\n│ /api/events/active GET → active event │\n│ /api/events/:id/availability GET → sessions + slot counts│\n│ /api/reader POST → find-or-create reader│\n│ /api/register POST → atomic slot booking │\n│ /api/register DELETE → cancel booking │\n│ /api/readers/:id/card GET → library card data │\n│ │\n│ DB Layer: Drizzle ORM (sqlite-proxy → Val Town SQLite) │\n└──────────────────────────────────────────────────────────┘\n```\n\n## Key Design Decisions\n\n### Polling over SSE/WebSocket\nVal Town's serverless model keeps a Deno isolate alive per SSE connection. With 250 concurrent readers, that's 250 long-lived isolates — unsustainable. Instead, we poll every 3s. That's ~83 req/s of fast SQLite reads, which Val Town handles fine.\n\n### Atomic slot booking (race condition safety)\nThe critical path is two readers grabbing the last slot simultaneously. We solve this with a conditional INSERT:\n```sql\nINSERT INTO ll_registrations (reader_id, book_session_id, session_id)\nSELECT ?, ?, ?\nWHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n```\nIf the slot was taken between the reader's last poll and their click, 0 rows are affected → friendly error.\n\n### Drizzle ORM with sqlite-proxy\nVal Town provides SQLite via `https://esm.town/v/std/sqlite` (a Turso HTTP wrapper). We bridge it with `drizzle-orm/sqlite-proxy` which lets us plug in custom execute/batch callbacks. This gives us type-safe queries while staying on Val Town's native SQLite.\n\n### One book per session per reader\nEnforced at the DB level with `UNIQUE(reader_id, session_id)` on `ll_registrations`. The API deletes any existing registration for a session before inserting a new one (in a transaction), so changing your pick is seamless.\n\n## Data Model\n\n```\nll_events → An event (e.g. \"Living Library Hyderabad #6\")\nll_sessions → Time slots within an event (Session 1, 2, 3...)\nll_books → \"Books\" (people) available at an event\nll_book_sessions → Junction: which books are in which sessions (with max_slots)\nll_readers → Registered readers (name + email, unique on email)\nll_registrations → Reader ↔ BookSession assignments\n```\n\n## File Structure\n\n```\n├── CLAUDE.md ← You are here\n├── AGENTS.md ← Val Town agent instructions\n├── db/\n│ ├── schema.ts ← Drizzle table definitions (source of truth)\n│ ├── client.ts ← Drizzle instance via sqlite-proxy\n│ └── queries.ts ← All query functions\n├── api.ts ← Hono API routes\n├── views.ts ← React SPA (HTML shell + embedded React)\n├── index.ts ← HTTP entry point (Hono app)\n└── seed.ts ← Script: populate sample data\n```\n\n## Development\n\n### Seeding data\nEdit `seed.ts` with your event/book/session details, then run it as a script in Val Town. Re-running clears and re-inserts.\n\n### Schema changes\n1. Update `db/schema.ts` (Drizzle table definitions)\n2. Update `db/queries.ts` if query logic changed\n3. The schema is applied via `CREATE TABLE IF NOT EXISTS` on cold start — for breaking changes, either drop tables manually or bump table names\n\n### Adding a new API endpoint\n1. Add the query function in `db/queries.ts`\n2. Add the route in `api.ts`\n3. Update the React app in `views.ts` if it needs to call the new endpoint\n\n## Trust model\nWe trust readers to provide accurate name/email. No auth, no verification. The `UNIQUE(email)` constraint on readers means returning with the same email resumes their session.",[181],"310e142c-07c7-11f1-bcfc-42dde27851f2","AGENTS.md","03f9a1f0-07c6-11f1-bdf4-42dde27851f2",16,["D",1770868752797],"# Living Library — Self-Registration System\n\nA self-service registration app for Living Library events in Hyderabad. Readers\nregister with name + email, browse available \"books\" (people sharing their\nstories), and claim reading slots — all in real-time as 250+ people sign up\nsimultaneously.\n\n## Architecture\n\n```\n┌─────────────────────────────────────────────────────────┐\n│ Client (React + Pico CSS) │\n│ ┌──────────┐ ┌──────────────┐ ┌──────────────────┐ │\n│ │ Register │→ │ Browse Books │→ │ Library Card View │ │\n│ │ (name + │ │ (polls every │ │ (reading history) │ │\n│ │ email) │ │ 3 seconds) │ │ │ │\n│ └──────────┘ └──────┬───────┘ └──────────────────┘ │\n│ │ │\n│ localStorage: { id, name, email } │\n└───────────────────────┼─────────────────────────────────┘\n │ HTTP\n┌───────────────────────┼─────────────────────────────────┐\n│ Server (Hono) │ │\n│ ▼ │\n│ /api/events/active GET → active event │\n│ /api/events/:id/availability GET → sessions + slot counts│\n│ /api/reader POST → find-or-create reader│\n│ /api/register POST → atomic slot booking │\n│ /api/register DELETE → cancel booking │\n│ /api/readers/:id/card GET → library card data │\n│ │\n│ DB Layer: Drizzle ORM (sqlite-proxy → Val Town SQLite) │\n└──────────────────────────────────────────────────────────┘\n```\n\n## Key Design Decisions\n\n### Polling over SSE/WebSocket\n\nVal Town's serverless model keeps a Deno isolate alive per SSE connection. With\n250 concurrent readers, that's 250 long-lived isolates — unsustainable. Instead,\nwe poll every 3s. That's ~83 req/s of fast SQLite reads, which Val Town handles\nfine.\n\n### Atomic slot booking (race condition safety)\n\nThe critical path is two readers grabbing the last slot simultaneously. We solve\nthis with a conditional INSERT:\n\n```sql\nINSERT INTO ll_registrations (reader_id, book_session_id, session_id)\nSELECT ?, ?, ?\nWHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n```\n\nIf the slot was taken between the reader's last poll and their click, 0 rows are\naffected → friendly error.\n\n### Drizzle ORM with sqlite-proxy\n\nVal Town provides SQLite via `https://esm.town/v/std/sqlite` (a Turso HTTP\nwrapper). We bridge it with `drizzle-orm/sqlite-proxy` which lets us plug in\ncustom execute/batch callbacks. This gives us type-safe queries while staying on\nVal Town's native SQLite.\n\n### One book per session per reader\n\nEnforced at the DB level with `UNIQUE(reader_id, session_id)` on\n`ll_registrations`. The API deletes any existing registration for a session\nbefore inserting a new one (in a transaction), so changing your pick is\nseamless.\n\n## Data Model\n\n```\nll_events → An event (e.g. \"Living Library Hyderabad #6\")\nll_sessions → Time slots within an event (Session 1, 2, 3...)\nll_books → \"Books\" (people) available at an event\nll_book_sessions → Junction: which books are in which sessions (with max_slots)\nll_readers → Registered readers (name + email, unique on email)\nll_registrations → Reader ↔ BookSession assignments\n```\n\n## File Structure\n\n```\n├── CLAUDE.md ← You are here\n├── AGENTS.md ← Val Town agent instructions\n├── db/\n│ ├── schema.ts ← Drizzle table definitions (source of truth)\n│ ├── client.ts ← Drizzle instance via sqlite-proxy\n│ └── queries.ts ← All query functions\n├── api.ts ← Hono API routes\n├── views.ts ← React SPA (HTML shell + embedded React)\n├── index.ts ← HTTP entry point (Hono app)\n└── seed.ts ← Script: populate sample data\n```\n\n## Development\n\n### Seeding data\n\nEdit `seed.ts` with your event/book/session details, then run it as a script in\nVal Town. Re-running clears and re-inserts.\n\n### Schema changes\n\n1. Update `db/schema.ts` (Drizzle table definitions)\n2. Update `db/queries.ts` if query logic changed\n3. The schema is applied via `CREATE TABLE IF NOT EXISTS` on cold start — for\n breaking changes, either drop tables manually or bump table names\n\n### Adding a new API endpoint\n\n1. Add the query function in `db/queries.ts`\n2. Add the route in `api.ts`\n3. Update the React app in `views.ts` if it needs to call the new endpoint\n\n## Trust model\n\nWe trust readers to provide accurate name/email. No auth, no verification. The\n`UNIQUE(email)` constraint on readers means returning with the same email\nresumes their session.",[188],"03b2562e-07c6-11f1-8153-42dde27851f2",".vtignore","03b25796-07c6-11f1-8153-42dde27851f2",["D",1770868247174],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[195],"b20402cc-07c6-11f1-b4ca-42dde27851f2","db","b204038a-07c6-11f1-b4ca-42dde27851f2",5,["D",1770868539664],"directory",[201],"pulls","branches","forks","envVars",{"_214":63,"_216":63},"connections",{"_214":63,"_215":63},"count","unfilledCount","emptyCount",{"_44":200,"_32":201,"_30":202,"_144":-5,"_42":43,"_41":203,"_146":127,"_39":275,"_13":63,"_34":205,"_36":-5,"_24":25,"_150":-5,"_230":276,"_27":277},{"_44":267,"_32":268,"_30":269,"_144":202,"_42":43,"_41":270,"_146":127,"_39":271,"_13":264,"_34":35,"_36":272,"_24":25,"_150":-5,"_230":273,"_27":274},{"_44":262,"_32":33,"_30":31,"_144":202,"_42":43,"_41":14,"_146":25,"_39":263,"_13":264,"_34":35,"_36":38,"_24":25,"_150":-5,"_230":265,"_27":266},{"_44":254,"_32":255,"_30":256,"_144":202,"_42":43,"_41":257,"_146":25,"_39":258,"_13":63,"_34":35,"_36":259,"_24":25,"_150":-5,"_230":260,"_27":261},{"_44":194,"_32":195,"_30":196,"_144":-5,"_42":43,"_41":148,"_146":127,"_39":251,"_13":63,"_34":20,"_36":198,"_24":25,"_150":-5,"_230":252,"_27":253},{"_44":187,"_32":188,"_30":189,"_144":-5,"_42":43,"_41":190,"_146":25,"_39":248,"_13":169,"_34":20,"_36":192,"_24":25,"_150":-5,"_230":249,"_27":250},{"_44":180,"_32":181,"_30":182,"_144":-5,"_42":43,"_41":183,"_146":25,"_39":245,"_13":169,"_34":20,"_36":185,"_24":25,"_150":-5,"_230":246,"_27":247},{"_44":173,"_32":174,"_30":175,"_144":-5,"_42":43,"_41":176,"_146":127,"_39":242,"_13":63,"_34":35,"_36":178,"_24":25,"_150":-5,"_230":243,"_27":244},{"_44":166,"_32":167,"_30":168,"_144":-5,"_42":43,"_41":169,"_146":127,"_39":239,"_13":63,"_34":20,"_36":171,"_24":25,"_150":-5,"_230":240,"_27":241},{"_44":159,"_32":160,"_30":58,"_144":-5,"_42":43,"_41":161,"_146":25,"_39":236,"_13":63,"_34":163,"_36":164,"_24":25,"_150":-5,"_230":237,"_27":238},{"_44":152,"_32":153,"_30":154,"_144":-5,"_42":43,"_41":155,"_146":25,"_39":233,"_13":148,"_34":35,"_36":157,"_24":25,"_150":-5,"_230":234,"_27":235},{"_44":141,"_32":142,"_30":143,"_144":-5,"_42":43,"_41":145,"_146":25,"_39":229,"_13":148,"_34":35,"_36":149,"_24":25,"_150":-5,"_230":231,"_27":232},["D",1770868881450],"children",[],[142],["D",1770869249279],[],[153],["D",1770868614934],[],[160],["D",1770868247163],[],[167],["D",1770868607201],[],[174],["D",1770868729260],[],[181],["D",1770868752797],[],[188],["D",1770868247174],[],[195],"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",[],[201,255],"7968d102-07c8-11f1-b468-42dde27851f2",["D",1770869303672],3,[],[201,33],"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",[],[201,268],["D",1770868539664],[218,219,220],[201],["D",1770868165845],["D",1789518064818],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":25},{"_13":89,"_32":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_129":316,"_317":318,"_319":320,"_321":25,"_322":25,"_323":25,"_324":127,"_325":-5,"_326":-7,"_327":-7,"_328":63,"_329":25,"_330":25,"_331":-5,"_332":25,"_333":25,"_334":25,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":90,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"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 · v24