[{"_1":2,"_173":-5,"_174":-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","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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,"_147":148,"_170":171,"_172":-5},"handle","loading","name","pixelart","path","backend/database/users.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":116,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_146":20},"id","15ac9522-429d-11f0-a0da-76b3cceeab13","createdAt",["D",1749190288939],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c7d91915-4070-4350-8e28-6c792ff73b1c","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"9ee5b56c-6e87-47cb-98e4-c31219468b31","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","org",{"_93":94,"_132":129},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",252,"15ace734-429d-11f0-a0da-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":150,"_151":152,"_153":154,"_155":137,"_156":157,"_158":159,"_103":160,"_135":32,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"9b782954-4442-11f0-a1a0-76b3cceeab13","users.ts","fileId","9b782a76-4442-11f0-a1a0-76b3cceeab13","parentId","c2009741-52a8-43db-88c9-3d474d518681","branchId","branchVersion",224,"latest",true,["D",1749371331528],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from './schema.ts';\n\nexport interface User {\n id: number;\n username: string;\n email: string;\n display_name?: string;\n avatar_url?: string;\n created_at: string;\n updated_at: string;\n last_login?: string;\n is_active: boolean;\n}\n\nexport interface CreateUserData {\n username: string;\n email: string;\n password_hash: string;\n display_name?: string;\n}\n\nexport interface Session {\n id: string;\n user_id: number;\n expires_at: string;\n created_at: string;\n}\n\n// Create a new user\nexport async function createUser(userData: CreateUserData): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.USERS} (username, email, password_hash, display_name)\n VALUES (?, ?, ?, ?)\n `, [userData.username, userData.email, userData.password_hash, userData.display_name || userData.username]);\n\n const user = await getUserById(result.lastInsertRowid as number);\n if (!user) {\n throw new Error('Failed to create user');\n }\n return user;\n } catch (error) {\n console.error('Error creating user:', error);\n throw error;\n }\n}\n\n// Get user by ID\nexport async function getUserById(id: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, username, email, display_name, avatar_url, created_at, updated_at, last_login, is_active\n FROM ${TABLES.USERS}\n WHERE id = ? AND is_active = 1\n `, [id]);\n\n return result.rows.length > 0 ? result.rows[0] as User : null;\n } catch (error) {\n console.error('Error getting user by ID:', error);\n return null;\n }\n}\n\n// Get user by username\nexport async function getUserByUsername(username: string): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, username, email, display_name, avatar_url, created_at, updated_at, last_login, is_active\n FROM ${TABLES.USERS}\n WHERE username = ? AND is_active = 1\n `, [username]);\n\n return result.rows.length > 0 ? result.rows[0] as User : null;\n } catch (error) {\n console.error('Error getting user by username:', error);\n return null;\n }\n}\n\n// Get user by email\nexport async function getUserByEmail(email: string): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, username, email, display_name, avatar_url, created_at, updated_at, last_login, is_active\n FROM ${TABLES.USERS}\n WHERE email = ? AND is_active = 1\n `, [email]);\n\n return result.rows.length > 0 ? result.rows[0] as User : null;\n } catch (error) {\n console.error('Error getting user by email:', error);\n return null;\n }\n}\n\n// Get user with password hash for authentication\nexport async function getUserWithPassword(username: string): Promise<(User & { password_hash: string }) | null> {\n try {\n const result = await sqlite.execute(`\n SELECT id, username, email, password_hash, display_name, avatar_url, created_at, updated_at, last_login, is_active\n FROM ${TABLES.USERS}\n WHERE username = ? AND is_active = 1\n `, [username]);\n\n return result.rows.length > 0 ? result.rows[0] as (User & { password_hash: string }) : null;\n } catch (error) {\n console.error('Error getting user with password:', error);\n return null;\n }\n}\n\n// Update user's last login\nexport async function updateLastLogin(userId: number): Promise {\n try {\n await sqlite.execute(`\n UPDATE ${TABLES.USERS}\n SET last_login = datetime('now')\n WHERE id = ?\n `, [userId]);\n } catch (error) {\n console.error('Error updating last login:', error);\n }\n}\n\n// Create a session\nexport async function createSession(userId: number): Promise {\n try {\n const sessionId = crypto.randomUUID();\n const expiresAt = new Date(Date.now() + 7 * 24 * 60 * 60 * 1000); // 7 days\n\n await sqlite.execute(`\n INSERT INTO ${TABLES.SESSIONS} (id, user_id, expires_at)\n VALUES (?, ?, ?)\n `, [sessionId, userId, expiresAt.toISOString()]);\n\n return {\n id: sessionId,\n user_id: userId,\n expires_at: expiresAt.toISOString(),\n created_at: new Date().toISOString()\n };\n } catch (error) {\n console.error('Error creating session:', error);\n throw error;\n }\n}\n\n// Get session\nexport async function getSession(sessionId: string): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, user_id, expires_at, created_at\n FROM ${TABLES.SESSIONS}\n WHERE id = ? AND expires_at > datetime('now')\n `, [sessionId]);\n\n return result.rows.length > 0 ? result.rows[0] as Session : null;\n } catch (error) {\n console.error('Error getting session:', error);\n return null;\n }\n}\n\n// Delete session (logout)\nexport async function deleteSession(sessionId: string): Promise {\n try {\n await sqlite.execute(`\n DELETE FROM ${TABLES.SESSIONS}\n WHERE id = ?\n `, [sessionId]);\n } catch (error) {\n console.error('Error deleting session:', error);\n }\n}\n\n// Delete all sessions for a user\nexport async function deleteUserSessions(userId: number): Promise {\n try {\n await sqlite.execute(`\n DELETE FROM ${TABLES.SESSIONS}\n WHERE user_id = ?\n `, [userId]);\n } catch (error) {\n console.error('Error deleting user sessions:', error);\n }\n}","deleted","label",[168,169,150],"backend","database","permalink","https://www.val.town/x/loading/pixelart/code/backend/database/users.ts","extension","actionData","errors"]