[{"_1":2,"_174":-5,"_175":-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","7037b4412b49b7328160fa57e59f17dfe8779fc7","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,"_149":150,"_171":172,"_173":-5},"handle","Bpexch","name","equitableAmaranthGoat","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":113,"_114":115,"_116":117,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","d83a36ea-26d6-11f0-a5b3-569c3dd06744","createdAt",["D",1746136464101],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1b281be0-ec10-11ef-af12-67b5d5b0b458","pinnedFileId","3778fa02-39dc-11f0-b02b-9e149126039e","pinPreview",true,"screenshotVersion",26,"likeCount","d2b56615-581f-441d-ac8b-1fd4cdb7a1a0","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydDZZSzhiaEhweVVSZk5aOXdkQlBGYnRPbmEifQ","org",{"_93":94,"_134":131,"_12":111},"avatar","branch",{"_137":138,"_95":43,"_101":139,"_140":102,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"version",28,"d83a82f8-26d6-11f0-a5b3-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":139,"_158":159,"_160":115,"_103":161,"_137":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"f79738ae-39db-11f0-98ae-9e149126039e","queries.ts","fileId","f7973962-39db-11f0-98ae-9e149126039e","parentId","0ac93c3b-3d3b-4ed5-98ed-d75f2d1c518b","branchId","branchVersion",11,"latest",["D",1748227736294],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Company, Bet, Match, UserRole, CreateUserRequest } from \"../../shared/types.ts\";\n\n// User queries\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM users_v1 WHERE username = ? AND is_active = 1\",\n [username]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n username: row.username,\n password: row.password,\n role: row.role as UserRole,\n parentId: row.parent_id,\n companyId: row.company_id,\n balance: row.balance,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n lastLogin: row.last_login,\n commissionRate: row.commission_rate,\n creditLimit: row.credit_limit\n };\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM users_v1 WHERE id = ? AND is_active = 1\",\n [id]\n );\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n username: row.username,\n password: row.password,\n role: row.role as UserRole,\n parentId: row.parent_id,\n companyId: row.company_id,\n balance: row.balance,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n lastLogin: row.last_login,\n commissionRate: row.commission_rate,\n creditLimit: row.credit_limit\n };\n}\n\nexport async function createUser(userData: CreateUserRequest, parentId: number, companyId?: number): Promise {\n const result = await sqlite.execute(`\n INSERT INTO users_v1 \n (username, password, role, parent_id, company_id, balance, commission_rate, credit_limit)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n userData.username,\n userData.password,\n userData.role,\n parentId,\n companyId || null,\n userData.balance || 0,\n userData.commissionRate || 0,\n userData.creditLimit || 0\n ]);\n\n return await getUserById(result.lastInsertRowid as number) as User;\n}\n\nexport async function getUsersByParent(parentId: number): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM users_v1 WHERE parent_id = ? AND is_active = 1 ORDER BY created_at DESC\",\n [parentId]\n );\n \n return result.map(row => ({\n id: row.id,\n username: row.username,\n password: row.password,\n role: row.role as UserRole,\n parentId: row.parent_id,\n companyId: row.company_id,\n balance: row.balance,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n lastLogin: row.last_login,\n commissionRate: row.commission_rate,\n creditLimit: row.credit_limit\n }));\n}\n\nexport async function updateUserBalance(userId: number, newBalance: number): Promise {\n await sqlite.execute(\n \"UPDATE users_v1 SET balance = ? WHERE id = ?\",\n [newBalance, userId]\n );\n}\n\nexport async function updateLastLogin(userId: number): Promise {\n await sqlite.execute(\n \"UPDATE users_v1 SET last_login = CURRENT_TIMESTAMP WHERE id = ?\",\n [userId]\n );\n}\n\n// Company queries\nexport async function createCompany(name: string, ownerId: number): Promise {\n const result = await sqlite.execute(`\n INSERT INTO companies_v1 (name, owner_id)\n VALUES (?, ?)\n `, [name, ownerId]);\n\n const companyResult = await sqlite.execute(\n \"SELECT * FROM companies_v1 WHERE id = ?\",\n [result.lastInsertRowid]\n );\n\n const row = companyResult[0];\n return {\n id: row.id,\n name: row.name,\n ownerId: row.owner_id,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n settings: {\n maxSuperAdmins: row.max_super_admins,\n defaultCommissionRate: row.default_commission_rate,\n maxCreditLimit: row.max_credit_limit,\n allowedSports: JSON.parse(row.allowed_sports)\n }\n };\n}\n\nexport async function getCompaniesByOwner(ownerId: number): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM companies_v1 WHERE owner_id = ? AND is_active = 1 ORDER BY created_at DESC\",\n [ownerId]\n );\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n ownerId: row.owner_id,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n settings: {\n maxSuperAdmins: row.max_super_admins,\n defaultCommissionRate: row.default_commission_rate,\n maxCreditLimit: row.max_credit_limit,\n allowedSports: JSON.parse(row.allowed_sports)\n }\n }));\n}\n\n// Match queries\nexport async function getAllMatches(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM matches_v1 ORDER BY start_time ASC\"\n );\n \n return result.map(row => ({\n id: row.id,\n sport: row.sport,\n team1: row.team1,\n team2: row.team2,\n startTime: row.start_time,\n status: row.status as 'upcoming' | 'live' | 'finished',\n odds: {\n team1: row.team1_odds,\n team2: row.team2_odds,\n draw: row.draw_odds\n }\n }));\n}\n\n// Bet queries\nexport async function placeBet(userId: number, matchId: string, betType: string, amount: number, odds: number): Promise {\n const potentialWin = amount * odds;\n \n const result = await sqlite.execute(`\n INSERT INTO bets_v1 (user_id, match_id, bet_type, amount, odds, potential_win)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [userId, matchId, betType, amount, odds, potentialWin]);\n\n const betResult = await sqlite.execute(\n \"SELECT * FROM bets_v1 WHERE id = ?\",\n [result.lastInsertRowid]\n );\n\n const row = betResult[0];\n return {\n id: row.id,\n userId: row.user_id,\n matchId: row.match_id,\n betType: row.bet_type,\n amount: row.amount,\n odds: row.odds,\n potentialWin: row.potential_win,\n status: row.status as 'pending' | 'won' | 'lost' | 'cancelled',\n placedAt: row.placed_at,\n settledAt: row.settled_at\n };\n}\n\nexport async function getBetsByUser(userId: number): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM bets_v1 WHERE user_id = ? ORDER BY placed_at DESC\",\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n matchId: row.match_id,\n betType: row.bet_type,\n amount: row.amount,\n odds: row.odds,\n potentialWin: row.potential_win,\n status: row.status as 'pending' | 'won' | 'lost' | 'cancelled',\n placedAt: row.placed_at,\n settledAt: row.settled_at\n }));\n}\n\n// Session management\nexport async function createSession(userId: number): Promise {\n const sessionId = crypto.randomUUID();\n const expiresAt = new Date(Date.now() + 24 * 60 * 60 * 1000).toISOString(); // 24 hours\n \n await sqlite.execute(`\n INSERT INTO sessions_v1 (id, user_id, expires_at)\n VALUES (?, ?, ?)\n `, [sessionId, userId, expiresAt]);\n \n return sessionId;\n}\n\nexport async function getSessionUser(sessionId: string): Promise {\n const result = await sqlite.execute(`\n SELECT u.* FROM users_v1 u\n JOIN sessions_v1 s ON u.id = s.user_id\n WHERE s.id = ? AND s.expires_at > CURRENT_TIMESTAMP AND u.is_active = 1\n `, [sessionId]);\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n username: row.username,\n password: row.password,\n role: row.role as UserRole,\n parentId: row.parent_id,\n companyId: row.company_id,\n balance: row.balance,\n isActive: row.is_active === 1,\n createdAt: row.created_at,\n lastLogin: row.last_login,\n commissionRate: row.commission_rate,\n creditLimit: row.credit_limit\n };\n}\n\nexport async function deleteSession(sessionId: string): Promise {\n await sqlite.execute(\"DELETE FROM sessions_v1 WHERE id = ?\", [sessionId]);\n}","deleted","label",[169,170,152],"backend","database","permalink","https://www.val.town/x/Bpexch/equitableAmaranthGoat/code/backend/database/queries.ts","extension","actionData","errors"]