[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4665abaede64d7a40f12c22a2a13ecb98867c1ee","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_169":170,"_171":-5},"handle","Siney","name","AppTram","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","ba6324ec-30f9-11f0-a79e-569c3dd06744","createdAt",["D",1747250958051],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","075c5e90-08cc-11f0-8bdc-77ef218dd677","pinnedFileId","pinPreview","screenshotVersion","likeCount","6c965bc5-864e-4890-882a-58e5f9e395ac","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydWxweGRDRVR4SnlGYnR4WXpqdGMyc1ZOWXEifQ","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",16,"ba637cb2-30f9-11f0-a79e-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"008dbab8-30fa-11f0-b604-569c3dd06744","queries.ts","fileId","008dbb8a-30fa-11f0-b604-569c3dd06744","parentId","4b0bd1af-af5e-41d6-bb6a-9f8580a8dc76","branchId","branchVersion",3,"latest",true,["D",1747251075766],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, TICKETS_TABLE, TICKET_STATUS, TICKET_TYPES } from \"./migrations.ts\";\nimport { User, Ticket, TicketType } from \"../../shared/types.ts\";\nimport { createHash } from \"https://deno.land/std@0.177.0/node/crypto.ts\";\n\n// User-related queries\nexport async function createUser(username: string, password: string, email: string): Promise {\n const passwordHash = hashPassword(password);\n const now = Date.now();\n \n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (username, password_hash, email, created_at) \n VALUES (?, ?, ?, ?)\n RETURNING id`,\n [username, passwordHash, email, now]\n );\n \n return result.rows[0].id as number;\n}\n\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, password_hash, email, created_at, is_admin \n FROM ${USERS_TABLE} \n WHERE username = ?`,\n [username]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return {\n id: result.rows[0].id,\n username: result.rows[0].username,\n passwordHash: result.rows[0].password_hash,\n email: result.rows[0].email,\n createdAt: result.rows[0].created_at,\n isAdmin: Boolean(result.rows[0].is_admin)\n };\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, password_hash, email, created_at, is_admin \n FROM ${USERS_TABLE} \n WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return {\n id: result.rows[0].id,\n username: result.rows[0].username,\n passwordHash: result.rows[0].password_hash,\n email: result.rows[0].email,\n createdAt: result.rows[0].created_at,\n isAdmin: Boolean(result.rows[0].is_admin)\n };\n}\n\n// Ticket-related queries\nexport async function createTicket(userId: number, ticketType: TicketType): Promise {\n const now = Date.now();\n const typeInfo = TICKET_TYPES[ticketType];\n const expirationTime = now + typeInfo.duration * 60 * 1000; // Convert minutes to milliseconds\n const verificationCode = generateVerificationCode(userId, now);\n \n const result = await sqlite.execute(\n `INSERT INTO ${TICKETS_TABLE} \n (user_id, ticket_type, purchase_time, expiration_time, status, verification_code) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [userId, ticketType, now, expirationTime, TICKET_STATUS.ACTIVE, verificationCode]\n );\n \n return {\n id: result.rows[0].id,\n userId,\n ticketType,\n purchaseTime: now,\n expirationTime,\n status: TICKET_STATUS.ACTIVE,\n verificationCode,\n lastVerifiedAt: null\n };\n}\n\nexport async function getUserTickets(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, ticket_type, purchase_time, expiration_time, status, verification_code, last_verified_at\n FROM ${TICKETS_TABLE} \n WHERE user_id = ?\n ORDER BY purchase_time DESC`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n userId: row.user_id,\n ticketType: row.ticket_type as TicketType,\n purchaseTime: row.purchase_time,\n expirationTime: row.expiration_time,\n status: row.status,\n verificationCode: row.verification_code,\n lastVerifiedAt: row.last_verified_at\n }));\n}\n\nexport async function getTicketByVerificationCode(code: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, ticket_type, purchase_time, expiration_time, status, verification_code, last_verified_at\n FROM ${TICKETS_TABLE} \n WHERE verification_code = ?`,\n [code]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return {\n id: result.rows[0].id,\n userId: result.rows[0].user_id,\n ticketType: result.rows[0].ticket_type as TicketType,\n purchaseTime: result.rows[0].purchase_time,\n expirationTime: result.rows[0].expiration_time,\n status: result.rows[0].status,\n verificationCode: result.rows[0].verification_code,\n lastVerifiedAt: result.rows[0].last_verified_at\n };\n}\n\nexport async function verifyTicket(ticketId: number): Promise {\n const now = Date.now();\n \n // First, check if the ticket is valid\n const ticket = await getTicketById(ticketId);\n if (!ticket || ticket.status !== TICKET_STATUS.ACTIVE || ticket.expirationTime < now) {\n return false;\n }\n \n // Update the ticket's last verified time\n await sqlite.execute(\n `UPDATE ${TICKETS_TABLE} \n SET last_verified_at = ?\n WHERE id = ?`,\n [now, ticketId]\n );\n \n return true;\n}\n\nexport async function updateTicketStatuses(): Promise {\n const now = Date.now();\n \n // Update expired tickets\n await sqlite.execute(\n `UPDATE ${TICKETS_TABLE} \n SET status = ?\n WHERE status = ? AND expiration_time < ?`,\n [TICKET_STATUS.EXPIRED, TICKET_STATUS.ACTIVE, now]\n );\n}\n\n// Helper functions\nfunction hashPassword(password: string): string {\n return createHash(\"sha256\").update(password).digest(\"hex\");\n}\n\nfunction generateVerificationCode(userId: number, timestamp: number): string {\n const baseString = `${userId}-${timestamp}-${Math.random()}`;\n return createHash(\"sha256\").update(baseString).digest(\"hex\").substring(0, 16);\n}\n\nasync function getTicketById(ticketId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, user_id, ticket_type, purchase_time, expiration_time, status, verification_code, last_verified_at\n FROM ${TICKETS_TABLE} \n WHERE id = ?`,\n [ticketId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return {\n id: result.rows[0].id,\n userId: result.rows[0].user_id,\n ticketType: result.rows[0].ticket_type as TicketType,\n purchaseTime: result.rows[0].purchase_time,\n expirationTime: result.rows[0].expiration_time,\n status: result.rows[0].status,\n verificationCode: result.rows[0].verification_code,\n lastVerifiedAt: result.rows[0].last_verified_at\n };\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/Siney/AppTram/code/backend/database/queries.ts","extension","actionData","errors"]