[{"_1":2,"_175":-5,"_176":-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,"_150":151,"_172":173,"_174":-5},"handle","amadesclaire","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":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_149":20},"id","c25fbd18-57d7-11f0-b099-f69ea79377d9","createdAt",["D",1751524463884],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","9de21530-57d7-11f0-a88c-15a8b5d902c9","pinnedFileId","pinPreview","screenshotVersion","likeCount","32a2552d-7252-46a5-932b-c334da944006","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yekx4dUMxM2pHSERUaUlhZW5jRk5QZ0R6d1MifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":146,"_147":96,"_148":94},"version",1,"c2633af6-57d7-11f0-b099-f69ea79377d9","projectId","forkedBranchId","15ace734-429d-11f0-a0da-76b3cceeab13","forkedBranchVersion",252,"forkedProjectPrivacy","forkedProjectId","15ac9522-429d-11f0-a0da-76b3cceeab13","forkedProjectOrgId","9ee5b56c-6e87-47cb-98e4-c31219468b31","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":136,"_159":135,"_160":161,"_103":162,"_134":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_97":169},"c26b2446-57d7-11f0-b099-f69ea79377d9","users.ts","fileId","ceed07dd-a361-4ac9-8ec8-a24a6f144557","parentId","b92d3d7d-ee7e-4f6b-9420-3e4996142c55","branchId","branchVersion","latest",true,["D",1751524463884],"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",[170,171,153],"backend","database","permalink","https://www.val.town/x/amadesclaire/pixelart/code/backend/database/users.ts","extension","actionData","errors"]