USPS Trivia Challenge

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_278":279,"_280":281},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_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",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",9,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/NameEntry.tsx","latestPath","fileId","b070df40-487a-11f0-bbee-76b3cceeab13","name","NameEntry.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from 'https://esm.sh/react@18.2.0';\n\ninterface NameEntryProps {\n onJoin: (name: string) => void;\n isConnecting: boolean;\n error: string | null;\n}\n\nexport function NameEntry({ onJoin, isConnecting, error }: NameEntryProps) {\n const [name, setName] = useState('');\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (name.trim() && !isConnecting) {\n onJoin(name.trim());\n }\n };\n\n return (\n

\n 📮\n Join the Postal Service Trivia Challenge\n

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n );\n}","createdAt",["D",1749835223180],"branchVersion","branchId","24d6b1a4-4879-11f0-9b62-76b3cceeab13",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","5fae50f9-7d03-4f29-a772-7b21c26ce8cd","components","directory",["D",1749835223180],"id","24d66550-4879-11f0-9b62-76b3cceeab13","factoid-trivia",["D",1749834559473],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","04e56ba7-c54a-427f-8070-67219b83ca20","pinnedFileId","9127face-487a-11f0-8b45-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2e901eee-3aff-4826-99a0-ea4001a41cef","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",96,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","bmitchinson","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybGNycExZSzZneWRkMGZuTGRiSDlsZjNSU3MifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":274,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":275,"_86":276,"_88":277,"_90":25},"tree",[174,181,186,188],"files",[174,175,176,177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_164":68,"_165":149,"_166":68,"_167":168,"_169":170},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":162,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":163},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":156,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":157},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":150,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":151},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_27":145},"6db5227e-487a-11f0-816c-76b3cceeab13","README.md","6db52314-487a-11f0-816c-76b3cceeab13","parentId",1,"latest",["D",1749835111222],"# USPS Trivia Game\n\nA realtime trivia game themed like a USPS post office, supporting up to 10 concurrent users.\n\n## Features\n\n- USPS post office themed design\n- Real-time user presence (see who's online)\n- Name entry and user management\n- Prepared for trivia functionality\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server with WebSocket support\n│ ├── database/\n│ │ ├── migrations.ts # SQLite schema setup\n│ │ └── queries.ts # Database query functions\n│ └── routes/\n│ └── websocket.ts # WebSocket connection handling\n├── frontend/\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # React frontend entry point\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── NameEntry.tsx # Name entry form\n│ │ └── UserList.tsx # Online users display\n│ └── style.css # USPS-themed styles\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The backend runs on Hono with WebSocket support for real-time features\n2. Frontend uses React with WebSocket client for real-time updates\n3. SQLite stores user sessions and game state\n4. USPS-themed styling with postal colors and typography\n\n## Current Status\n\n- ✅ User name entry\n- ✅ Real-time user presence\n- ✅ USPS theming\n- 🚧 Trivia functionality (coming next)","label",[137],"7205417e-487a-11f0-aed0-76b3cceeab13","shared","871b29af-733c-45f6-a07c-d1731f9bbc70",2,["D",1749835118445],[147],"95d110ba-487a-11f0-a9ec-76b3cceeab13","frontend","17fa2a23-aa00-4bd0-bfd3-b43b6bc9c778",7,["D",1749835178513],[153],"76334980-487a-11f0-b784-76b3cceeab13","backend","379e532e-042e-4e9e-8f33-6863d167ea3b",3,["D",1749835125467],[159],"pulls","branches","forks","envVars",{"_171":68,"_173":68},"connections",{"_171":68,"_172":68},"count","unfilledCount","emptyCount",{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":271,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":272,"_27":273},{"_49":267,"_32":259,"_30":253,"_139":160,"_41":42,"_40":161,"_141":64,"_38":268,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":269,"_27":270},{"_49":260,"_32":261,"_30":262,"_139":253,"_41":42,"_40":161,"_141":25,"_38":263,"_13":68,"_34":35,"_36":264,"_24":25,"_144":-5,"_190":265,"_27":266},{"_49":250,"_32":251,"_30":252,"_139":253,"_41":42,"_40":254,"_141":25,"_38":255,"_13":68,"_34":35,"_36":256,"_24":25,"_144":-5,"_190":257,"_27":258},{"_49":246,"_32":245,"_30":239,"_139":160,"_41":42,"_40":240,"_141":64,"_38":247,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":248,"_27":249},{"_49":236,"_32":237,"_30":238,"_139":239,"_41":42,"_40":240,"_141":25,"_38":241,"_13":68,"_34":35,"_36":242,"_24":25,"_144":-5,"_190":243,"_27":244},{"_49":229,"_32":230,"_30":62,"_139":160,"_41":42,"_40":231,"_141":25,"_38":232,"_13":68,"_34":35,"_36":233,"_24":25,"_144":-5,"_190":234,"_27":235},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":226,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":227,"_27":228},{"_49":222,"_32":46,"_30":45,"_139":154,"_41":42,"_40":14,"_141":64,"_38":223,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":224,"_27":225},{"_49":218,"_32":33,"_30":31,"_139":45,"_41":42,"_40":14,"_141":25,"_38":219,"_13":68,"_34":35,"_36":37,"_24":25,"_144":-5,"_190":220,"_27":221},{"_49":211,"_32":212,"_30":213,"_139":154,"_41":42,"_40":155,"_141":25,"_38":214,"_13":68,"_34":21,"_36":215,"_24":25,"_144":-5,"_190":216,"_27":217},{"_49":203,"_32":204,"_30":205,"_139":154,"_41":42,"_40":206,"_141":25,"_38":207,"_13":68,"_34":21,"_36":208,"_24":25,"_144":-5,"_190":209,"_27":210},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":200,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_190":201,"_27":202},{"_49":193,"_32":194,"_30":195,"_139":148,"_41":42,"_40":149,"_141":25,"_38":196,"_13":68,"_34":35,"_36":197,"_24":25,"_144":-5,"_190":198,"_27":199},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":189,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_190":191,"_27":192},["D",1749835111222],"children",[],[137],"720539e0-487a-11f0-aed0-76b3cceeab13","types.ts","72053a8a-487a-11f0-aed0-76b3cceeab13",["D",1749835118445],"// Shared types for USPS Trivia Game\n\nexport interface User {\n id: string;\n name: string;\n joinedAt: number;\n isActive: boolean;\n}\n\nexport interface GameState {\n users: User[];\n maxUsers: number;\n gameStatus: 'waiting' | 'playing' | 'finished';\n}\n\n// WebSocket message types\nexport type WSMessage = \n | { type: 'user_joined'; user: User }\n | { type: 'user_left'; userId: string }\n | { type: 'users_update'; users: User[] }\n | { type: 'game_state'; state: GameState }\n | { type: 'error'; message: string };\n\nexport interface WSClientMessage {\n type: 'join' | 'leave';\n name?: string;\n userId?: string;\n}",[],[147,194],["D",1749835118445],[187],[147],"a830b47c-487a-11f0-9dd0-76b3cceeab13","style.css","a830b530-487a-11f0-9dd0-76b3cceeab13",8,["D",1749835209340],"/* USPS Trivia Game Styles */\n\n:root {\n --usps-blue: #004B87;\n --usps-red: #DA020E;\n --usps-light-blue: #0077BE;\n --usps-gray: #5A5A5A;\n --usps-light-gray: #F5F5F5;\n --usps-white: #FFFFFF;\n}\n\n* {\n box-sizing: border-box;\n}\n\nbody {\n font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif;\n margin: 0;\n padding: 0;\n background: linear-gradient(135deg, var(--usps-blue) 0%, var(--usps-light-blue) 100%);\n min-height: 100vh;\n}\n\n.bg-usps-blue {\n background: linear-gradient(135deg, var(--usps-blue) 0%, var(--usps-light-blue) 100%);\n}\n\n.usps-container {\n max-width: 800px;\n margin: 0 auto;\n padding: 2rem;\n}\n\n.usps-header {\n text-align: center;\n margin-bottom: 3rem;\n color: white;\n}\n\n.usps-logo {\n font-size: 2.5rem;\n font-weight: 700;\n margin-bottom: 0.5rem;\n text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.3);\n}\n\n.usps-tagline {\n font-size: 1.1rem;\n opacity: 0.9;\n font-weight: 500;\n}\n\n.usps-card {\n background: white;\n border-radius: 12px;\n padding: 2rem;\n box-shadow: 0 8px 32px rgba(0, 0, 0, 0.1);\n border: 3px solid var(--usps-red);\n margin-bottom: 2rem;\n}\n\n.usps-card-header {\n border-bottom: 2px solid var(--usps-light-gray);\n padding-bottom: 1rem;\n margin-bottom: 1.5rem;\n}\n\n.usps-card-title {\n color: var(--usps-blue);\n font-size: 1.5rem;\n font-weight: 600;\n margin: 0;\n display: flex;\n align-items: center;\n gap: 0.5rem;\n}\n\n.usps-form {\n display: flex;\n flex-direction: column;\n gap: 1rem;\n}\n\n.usps-input {\n padding: 0.75rem 1rem;\n border: 2px solid var(--usps-light-gray);\n border-radius: 6px;\n font-size: 1rem;\n transition: border-color 0.2s;\n}\n\n.usps-input:focus {\n outline: none;\n border-color: var(--usps-blue);\n box-shadow: 0 0 0 3px rgba(0, 75, 135, 0.1);\n}\n\n.usps-button {\n background: var(--usps-red);\n color: white;\n border: none;\n padding: 0.75rem 1.5rem;\n border-radius: 6px;\n font-size: 1rem;\n font-weight: 600;\n cursor: pointer;\n transition: background-color 0.2s;\n}\n\n.usps-button:hover {\n background: #B8001A;\n}\n\n.usps-button:disabled {\n background: var(--usps-gray);\n cursor: not-allowed;\n}\n\n.users-grid {\n display: grid;\n grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));\n gap: 1rem;\n margin-top: 1rem;\n}\n\n.user-badge {\n background: var(--usps-light-blue);\n color: white;\n padding: 0.75rem 1rem;\n border-radius: 8px;\n text-align: center;\n font-weight: 500;\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 0.5rem;\n}\n\n.user-badge.current-user {\n background: var(--usps-red);\n border: 2px solid white;\n box-shadow: 0 0 0 2px var(--usps-red);\n}\n\n.status-indicator {\n width: 8px;\n height: 8px;\n background: #00FF00;\n border-radius: 50%;\n display: inline-block;\n}\n\n.error-message {\n background: #FEE;\n color: var(--usps-red);\n padding: 1rem;\n border-radius: 6px;\n border: 1px solid var(--usps-red);\n margin-bottom: 1rem;\n}\n\n.loading-spinner {\n display: inline-block;\n width: 20px;\n height: 20px;\n border: 2px solid #f3f3f3;\n border-top: 2px solid var(--usps-blue);\n border-radius: 50%;\n animation: spin 1s linear infinite;\n}\n\n@keyframes spin {\n 0% { transform: rotate(0deg); }\n 100% { transform: rotate(360deg); }\n}\n\n.connection-status {\n position: fixed;\n top: 1rem;\n right: 1rem;\n padding: 0.5rem 1rem;\n border-radius: 20px;\n font-size: 0.875rem;\n font-weight: 500;\n display: flex;\n align-items: center;\n gap: 0.5rem;\n}\n\n.connection-status.connected {\n background: #D4EDDA;\n color: #155724;\n border: 1px solid #C3E6CB;\n}\n\n.connection-status.disconnected {\n background: #F8D7DA;\n color: #721C24;\n border: 1px solid #F5C6CB;\n}\n\n.postal-icon {\n font-size: 1.2em;\n}\n\n@media (max-width: 640px) {\n .usps-container {\n padding: 1rem;\n }\n \n .usps-logo {\n font-size: 2rem;\n }\n \n .users-grid {\n grid-template-columns: 1fr;\n }\n}",[],[153,204],"95d107aa-487a-11f0-a9ec-76b3cceeab13","index.html","95d10886-487a-11f0-a9ec-76b3cceeab13",["D",1749835178513],"\n\n\n \n \n USPS Trivia Challenge\n \n \n \n \n \n \n\n\n

\n \n \n\n",[],[153,212],"b070de32-487a-11f0-bbee-76b3cceeab13",["D",1749835223180],[],[153,46,33],"b070eefe-487a-11f0-bbee-76b3cceeab13",["D",1749835223180],[183],[153,46],["D",1749835178513],[182,184,185],[153],"9127fa10-487a-11f0-8b45-76b3cceeab13","index.ts",6,["D",1749835170695],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { upgradeWebSocket } from \"https://esm.sh/hono@3.11.7/deno\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { getActiveUsers } from \"./database/queries.ts\";\nimport { handleWebSocket } from \"./routes/websocket.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait runMigrations();\n\n// WebSocket endpoint\napp.get('/ws', upgradeWebSocket((c) => ({\n onOpen: handleWebSocket\n})));\n\n// API endpoints\napp.get('/api/users', async (c) => {\n const users = await getActiveUsers();\n return c.json({ users });\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data\n const users = await getActiveUsers();\n const initialData = { users };\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[159,230],"89bfe152-487a-11f0-a94d-76b3cceeab13","websocket.ts","89bfe224-487a-11f0-a94d-76b3cceeab13","6632b6df-bc4c-494c-a4ec-af84ee2c1d2e",5,["D",1749835158263],"import type { WSMessage, WSClientMessage, User } from \"../../shared/types.ts\";\nimport { addUser, removeUser, getActiveUsers, updateUserLastSeen } from \"../database/queries.ts\";\n\n// Store active WebSocket connections\nconst connections = new Map();\n\nexport function handleWebSocket(ws: WebSocket) {\n let userId: string | null = null;\n \n ws.onopen = () => {\n console.log('WebSocket connection opened');\n };\n \n ws.onmessage = async (event) => {\n try {\n const message: WSClientMessage = JSON.parse(event.data);\n \n switch (message.type) {\n case 'join':\n if (message.name && message.name.trim()) {\n userId = crypto.randomUUID();\n const user: User = {\n id: userId,\n name: message.name.trim(),\n joinedAt: Date.now(),\n isActive: true\n };\n \n // Check if we're at capacity (10 users max)\n const activeUsers = await getActiveUsers();\n if (activeUsers.length >= 10) {\n sendMessage(ws, { type: 'error', message: 'Game is full! Maximum 10 players allowed.' });\n return;\n }\n \n // Add user to database and connections\n await addUser(user);\n connections.set(userId, ws);\n \n // Broadcast user joined to all clients\n const updatedUsers = await getActiveUsers();\n broadcastToAll({ type: 'user_joined', user });\n broadcastToAll({ type: 'users_update', users: updatedUsers });\n \n console.log(`User ${user.name} joined with ID ${userId}`);\n }\n break;\n \n case 'leave':\n if (userId) {\n await handleUserLeave(userId);\n }\n break;\n }\n } catch (error) {\n console.error('WebSocket message error:', error);\n sendMessage(ws, { type: 'error', message: 'Invalid message format' });\n }\n };\n \n ws.onclose = async () => {\n if (userId) {\n await handleUserLeave(userId);\n }\n console.log('WebSocket connection closed');\n };\n \n ws.onerror = (error) => {\n console.error('WebSocket error:', error);\n };\n \n // Send periodic heartbeat to keep connection alive\n const heartbeat = setInterval(() => {\n if (ws.readyState === WebSocket.OPEN && userId) {\n updateUserLastSeen(userId);\n } else {\n clearInterval(heartbeat);\n }\n }, 30000); // 30 seconds\n}\n\nasync function handleUserLeave(userId: string) {\n connections.delete(userId);\n await removeUser(userId);\n \n const updatedUsers = await getActiveUsers();\n broadcastToAll({ type: 'user_left', userId });\n broadcastToAll({ type: 'users_update', users: updatedUsers });\n \n console.log(`User ${userId} left`);\n}\n\nfunction sendMessage(ws: WebSocket, message: WSMessage) {\n if (ws.readyState === WebSocket.OPEN) {\n ws.send(JSON.stringify(message));\n }\n}\n\nfunction broadcastToAll(message: WSMessage) {\n connections.forEach((ws) => {\n sendMessage(ws, message);\n });\n}\n\n// Cleanup inactive users periodically\nsetInterval(async () => {\n const activeUsers = await getActiveUsers();\n const connectedUserIds = new Set(connections.keys());\n \n // Remove users who are in DB but not connected\n for (const user of activeUsers) {\n if (!connectedUserIds.has(user.id)) {\n await removeUser(user.id);\n }\n }\n}, 60000); // Every minute",[],[159,245,237],"routes","89bff9a8-487a-11f0-a94d-76b3cceeab13",["D",1749835158263],[179],[159,245],"7d9c5aea-487a-11f0-810d-76b3cceeab13","queries.ts","7d9c5bbc-487a-11f0-810d-76b3cceeab13","3b28ec05-0c71-4810-a4d1-e1c4f1963b39",4,["D",1749835137903],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE } from \"./migrations.ts\";\nimport type { User } from \"../../shared/types.ts\";\n\nexport async function addUser(user: User): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${USERS_TABLE} (id, name, joined_at, last_seen, is_active) \n VALUES (?, ?, ?, ?, ?)`,\n [user.id, user.name, user.joinedAt, Date.now(), 1]\n );\n}\n\nexport async function removeUser(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE id = ?`,\n [userId]\n );\n}\n\nexport async function getActiveUsers(): Promise {\n const result = await sqlite.execute(\n `SELECT id, name, joined_at as joinedAt, is_active as isActive \n FROM ${USERS_TABLE} \n WHERE is_active = 1 \n ORDER BY joined_at ASC`\n );\n \n return result.rows.map(row => ({\n id: row.id as string,\n name: row.name as string,\n joinedAt: row.joinedAt as number,\n isActive: Boolean(row.isActive)\n }));\n}\n\nexport async function updateUserLastSeen(userId: string): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET last_seen = ? WHERE id = ?`,\n [Date.now(), userId]\n );\n}\n\nexport async function cleanupInactiveUsers(): Promise {\n // Remove users who haven't been seen in 5 minutes\n const fiveMinutesAgo = Date.now() - (5 * 60 * 1000);\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET is_active = 0 WHERE last_seen < ?`,\n [fiveMinutesAgo]\n );\n}",[],[159,259,251],"database","76333ff8-487a-11f0-b784-76b3cceeab13","migrations.ts","763340c0-487a-11f0-b784-76b3cceeab13",["D",1749835125467],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'usps_trivia_users_v1';\n\nexport async function runMigrations() {\n // Create users table for tracking active sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n joined_at INTEGER NOT NULL,\n last_seen INTEGER NOT NULL,\n is_active BOOLEAN DEFAULT 1\n )\n `);\n \n console.log('Database migrations completed');\n}\n\nexport { USERS_TABLE };",[],[159,259,261],"76334b60-487a-11f0-b784-76b3cceeab13",["D",1749835125467],[176,177],[159,259],["D",1749835125467],[175,178,180],[159],["D",1749834559473],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":311,"_312":313,"_314":315,"_316":25,"_317":25,"_318":25,"_319":64,"_320":-5,"_321":-7,"_322":-7,"_323":68,"_324":25,"_325":25,"_326":-5,"_327":25,"_328":25,"_329":25,"_330":-5},"ENV",{"_282":283,"_284":285,"_286":92,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v9