[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","c2ca74b25698bc62f1250d595e4f42af9437a7d5","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_172":173,"_174":-5},"handle","Zoemedia","name","TOS","path","backend/database/users.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","415ae048-325d-11f0-a41d-569c3dd06744","createdAt",["D",1747403655828],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","e0e0bf30-247e-11f0-9d73-cd8227da5cf6","pinnedFileId","67c216de-325d-11f0-a529-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","b2a21fd4-ab59-49d8-875e-54408060892a","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3Tk9tUnpQcTRjejVsVzFsdlV1VlRrU0JPNiJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",22,"415b32b4-325d-11f0-a41d-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"1a49c972-325f-11f0-b2c1-569c3dd06744","users.ts","fileId","1a49ca4e-325f-11f0-b2c1-569c3dd06744","parentId","08a0b4a1-f6b8-46b4-9a73-a244d91bcba4","branchId","branchVersion",13,"latest",["D",1747404449275],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { User, PublicUser } from \"../../shared/types.ts\";\n\n// Get user by ID\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM users WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\n// Get user by email\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM users WHERE email = ?`,\n [email]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\n// Get user by username\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM users WHERE username = ?`,\n [username]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\n// Create a new user\nexport async function createUser(\n username: string,\n email: string,\n passwordHash: string\n): Promise {\n const now = new Date().toISOString();\n \n const result = await sqlite.execute(\n `INSERT INTO users (username, email, password_hash, created_at, last_active)\n VALUES (?, ?, ?, ?, ?)\n RETURNING *`,\n [username, email, passwordHash, now, now]\n );\n \n return result.rows[0] as User;\n}\n\n// Update user profile\nexport async function updateUserProfile(\n userId: number,\n updates: {\n username?: string;\n profile_picture?: string;\n bio?: string;\n }\n): Promise {\n // Build the SET clause dynamically based on provided updates\n const setClauses = [];\n const values = [];\n \n if (updates.username) {\n setClauses.push('username = ?');\n values.push(updates.username);\n }\n \n if (updates.profile_picture !== undefined) {\n setClauses.push('profile_picture = ?');\n values.push(updates.profile_picture);\n }\n \n if (updates.bio !== undefined) {\n setClauses.push('bio = ?');\n values.push(updates.bio);\n }\n \n if (setClauses.length === 0) {\n return await getUserById(userId);\n }\n \n // Add the user ID to the values array\n values.push(userId);\n \n const result = await sqlite.execute(\n `UPDATE users SET ${setClauses.join(', ')} WHERE id = ? RETURNING *`,\n values\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as User;\n}\n\n// Update user's last active timestamp\nexport async function updateLastActive(userId: number): Promise {\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `UPDATE users SET last_active = ? WHERE id = ?`,\n [now, userId]\n );\n \n // Also update or insert into online_status\n await sqlite.execute(\n `INSERT INTO online_status (user_id, last_heartbeat)\n VALUES (?, ?)\n ON CONFLICT(user_id) DO UPDATE SET last_heartbeat = ?`,\n [userId, now, now]\n );\n}\n\n// Get public user data (safe to send to client)\nexport async function getPublicUserData(userId: number): Promise {\n const user = await getUserById(userId);\n \n if (!user) {\n return null;\n }\n \n // Check if user is online (active in the last 5 minutes)\n const isOnline = await isUserOnline(userId);\n \n return {\n id: user.id,\n username: user.username,\n profile_picture: user.profile_picture,\n bio: user.bio,\n created_at: user.created_at,\n is_admin: user.is_admin,\n is_online: isOnline\n };\n}\n\n// Get all online users\nexport async function getOnlineUsers(): Promise {\n const fiveMinutesAgo = new Date();\n fiveMinutesAgo.setMinutes(fiveMinutesAgo.getMinutes() - 5);\n const cutoffTime = fiveMinutesAgo.toISOString();\n \n const result = await sqlite.execute(\n `SELECT u.id, u.username, u.profile_picture, u.bio, u.created_at, u.is_admin\n FROM users u\n JOIN online_status os ON u.id = os.user_id\n WHERE os.last_heartbeat > ?\n ORDER BY u.username`,\n [cutoffTime]\n );\n \n return result.rows.map(user => ({\n ...user,\n is_online: true\n })) as PublicUser[];\n}\n\n// Check if a user is online\nexport async function isUserOnline(userId: number): Promise {\n const fiveMinutesAgo = new Date();\n fiveMinutesAgo.setMinutes(fiveMinutesAgo.getMinutes() - 5);\n const cutoffTime = fiveMinutesAgo.toISOString();\n \n const result = await sqlite.execute(\n `SELECT COUNT(*) as count\n FROM online_status\n WHERE user_id = ? AND last_heartbeat > ?`,\n [userId, cutoffTime]\n );\n \n return result.rows[0].count > 0;\n}\n\n// Search users by username\nexport async function searchUsers(query: string, limit: number = 10): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, profile_picture, bio, created_at, is_admin\n FROM users\n WHERE username LIKE ?\n ORDER BY username\n LIMIT ?`,\n [`%${query}%`, limit]\n );\n \n const users = result.rows as Omit[];\n \n // Check online status for each user\n const publicUsers: PublicUser[] = await Promise.all(\n users.map(async (user) => ({\n ...user,\n is_online: await isUserOnline(user.id)\n }))\n );\n \n return publicUsers;\n}","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/Zoemedia/TOS/code/backend/database/users.ts","extension","actionData","errors"]