Class UserDAO

Hierarchy (View Summary)

BaseDAO
- UserDAO

Implements

IUserDAO

Constructors

constructor

new UserDAO(dbClient: IDbClient): UserDAO
Protected constructor to enforce singleton usage via getInstance.
Parameters
- dbClient: IDbClient
Returns UserDAO
Overrides BaseDAO.constructor
- Defined in src/dao/db/UserDAO.ts:19

Properties

`Protected` `Readonly`db

Methods

banUser

banUser(user_id: number, reason?: string | null): Promise<User | null>
Ban a user globally with an optional reason.
Parameters
- user_id: number
  ID of the user to ban
- reason: string | null = null
  Optional ban reason
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.banUser
- Defined in src/dao/db/UserDAO.ts:68

createUser

createUser(
    username: string,
    email: string,
    password: string,
): Promise<User | null>
Create a new user with username, email and password.
Parameters
- username: string
  Desired username
- email: string
  User email
- password: string
  Password (should be pre-hashed)
Returns Promise<User | null>
Newly created User record or null
Implementation of IUserDAO.createUser
- Defined in src/dao/db/UserDAO.ts:174

`Protected`executeQuery

executeQuery<T>(query: string, params?: any[]): Promise<T | null>
Type Parameters
- T
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T | null>
Inherited from BaseDAO.executeQuery
- Defined in src/dao/db/BaseDao.ts:83

`Protected`executeQueryMultiple

executeQueryMultiple<T>(query: string, params?: any[]): Promise<T[]>
Type Parameters
- T
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T[]>
Inherited from BaseDAO.executeQueryMultiple
- Defined in src/dao/db/BaseDao.ts:97

findByEmail

findByEmail(email: string): Promise<User | null>
Find user by email address.
Parameters
- email: string
  Email to look up
Returns Promise<User | null>
The User record or null when not found
Implementation of IUserDAO.findByEmail
- Defined in src/dao/db/UserDAO.ts:41

findById

findById(id: number): Promise<User | null>
Find user by numeric id.
Parameters
- id: number
  User id to look up
Returns Promise<User | null>
The User record or null when not found
Implementation of IUserDAO.findById
- Defined in src/dao/db/UserDAO.ts:29

`Protected`mapCacheError

mapCacheError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapCacheError
- Defined in src/dao/db/BaseDao.ts:47

`Protected`mapError

mapError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapError
- Defined in src/dao/db/BaseDao.ts:60

`Protected`mapPostgresError

mapPostgresError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapPostgresError
- Defined in src/dao/db/BaseDao.ts:16

`Protected`scalar

scalar<T = any>(query: string, params?: any[]): Promise<T>
Type Parameters
- T = any
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T>
Inherited from BaseDAO.scalar
- Defined in src/dao/db/BaseDao.ts:109

unbanUser

unbanUser(user_id: number): Promise<User | null>
Unban a user globally.
Parameters
- user_id: number
  ID of the user to unban
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.unbanUser
- Defined in src/dao/db/UserDAO.ts:54

updateBio

updateBio(user_id: number, description: string): Promise<User | null>
Update user's bio/description.
Parameters
- user_id: number
  ID of the user
- description: string
  New user description
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updateBio
- Defined in src/dao/db/UserDAO.ts:117

updateEmail

updateEmail(user_id: number, email: string): Promise<User | null>
Update user's email address.
Parameters
- user_id: number
  ID of the user
- email: string
  New email address
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updateEmail
- Defined in src/dao/db/UserDAO.ts:145

updatePassword

updatePassword(user_id: number, password: string): Promise<User | null>
Update user's password (hashed).
Parameters
- user_id: number
  ID of the user
- password: string
  New password (should be pre-hashed)
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updatePassword
- Defined in src/dao/db/UserDAO.ts:159

updateProfileBanner

updateProfileBanner(
user_id: number,
profile_banner: string,
): Promise<User | null>
Update user's profile banner.
Parameters
- user_id: number
  ID of the user
- profile_banner: string
  New banner URL or identifier
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updateProfileBanner
- Defined in src/dao/db/UserDAO.ts:103

updateProfilePicture

updateProfilePicture(
user_id: number,
profile_picture: string,
): Promise<User | null>
Update user's profile picture (avatar).
Parameters
- user_id: number
  ID of the user
- profile_picture: string
  New avatar URL or identifier
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updateProfilePicture
- Defined in src/dao/db/UserDAO.ts:89

updateStreamToken

updateStreamToken(user_id: number): Promise<User | null>
Parameters
- user_id: number
Returns Promise<User | null>
Implementation of IUserDAO.updateStreamToken
- Defined in src/dao/db/UserDAO.ts:181

updateUsername

updateUsername(user_id: number, username: string): Promise<User | null>
Update user's username.
Parameters
- user_id: number
  ID of the user
- username: string
  New username
Returns Promise<User | null>
Updated User record or null
Implementation of IUserDAO.updateUsername
- Defined in src/dao/db/UserDAO.ts:131