sqlc

package
v0.0.0-...-d9c52e5 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Aug 7, 2024 License: GPL-3.0 Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func CreateDbPool 

func CreateDbPool(config utils.Config) (*sql.DB, error)

func CreatePgxPool 

func CreatePgxPool(config utils.Config) (*pgxpool.Pool, error)

Types

type AccountRecoveryRequest 

type AccountRecoveryRequest struct {
	ID            int32        `json:"id"`
	UserID        uuid.UUID    `json:"user_id"`
	Email         string       `json:"email"`
	Used          sql.NullBool `json:"used"`
	RecoveryToken string       `json:"recovery_token"`
	RequestedAt   sql.NullTime `json:"requested_at"`
	ExpiresAt     time.Time    `json:"expires_at"`
	CompletedAt   sql.NullTime `json:"completed_at"`
}

type Authentication 

type Authentication struct {
	ID                  uuid.UUID      `json:"id"`
	Email               string         `json:"email"`
	Phone               sql.NullString `json:"phone"`
	Username            sql.NullString `json:"username"`
	PasswordHash        string         `json:"password_hash"`
	CreatedAt           sql.NullTime   `json:"created_at"`
	UpdatedAt           sql.NullTime   `json:"updated_at"`
	IsSuspended         sql.NullBool   `json:"is_suspended"`
	IsDeleted           sql.NullBool   `json:"is_deleted"`
	IsVerified          sql.NullBool   `json:"is_verified"`
	IsEmailVerified     sql.NullBool   `json:"is_email_verified"`
	DeletedAt           sql.NullTime   `json:"deleted_at"`
	VerifiedAt          sql.NullTime   `json:"verified_at"`
	SuspendedAt         sql.NullTime   `json:"suspended_at"`
	LoginAttempts       sql.NullInt32  `json:"login_attempts"`
	PasswordLastChanged sql.NullTime   `json:"password_last_changed"`
	LockoutDuration     sql.NullInt32  `json:"lockout_duration"`
	LockoutUntil        sql.NullTime   `json:"lockout_until"`
	IsMfaEnabled        sql.NullBool   `json:"is_mfa_enabled"`
	IsOauthUser         sql.NullBool   `json:"is_oauth_user"`
}

type CreateEmailVerificationRequestParams 

type CreateEmailVerificationRequestParams struct {
	UserID    uuid.UUID `json:"user_id"`
	Email     string    `json:"email"`
	Token     string    `json:"token"`
	ExpiresAt time.Time `json:"expires_at"`
}

type CreatePasswordResetRequestParams 

type CreatePasswordResetRequestParams struct {
	Email     string    `json:"email"`
	UserID    uuid.UUID `json:"user_id"`
	Token     string    `json:"token"`
	ExpiresAt time.Time `json:"expires_at"`
}

type CreateSessionParams 

type CreateSessionParams struct {
	ID              uuid.UUID      `json:"id"`
	UserID          uuid.UUID      `json:"user_id"`
	RefreshToken    string         `json:"refresh_token"`
	RefreshTokenExp time.Time      `json:"refresh_token_exp"`
	UserAgent       string         `json:"user_agent"`
	UpdatedAt       sql.NullTime   `json:"updated_at"`
	IpAddress       pqtype.Inet    `json:"ip_address"`
	BlockedAt       sql.NullTime   `json:"blocked_at"`
	InvalidatedAt   sql.NullTime   `json:"invalidated_at"`
	LastActiveAt    sql.NullTime   `json:"last_active_at"`
	FcmToken        sql.NullString `json:"fcm_token"`
}

type CreateUserDeleteRequestParams 

type CreateUserDeleteRequestParams struct {
	UserID        uuid.UUID    `json:"user_id"`
	Email         string       `json:"email"`
	RecoveryToken string       `json:"recovery_token"`
	ExpiresAt     time.Time    `json:"expires_at"`
	CompletedAt   sql.NullTime `json:"completed_at"`
}

type CreateUserLoginParams 

type CreateUserLoginParams struct {
	UserID    uuid.UUID      `json:"user_id"`
	IpAddress pqtype.Inet    `json:"ip_address"`
	UserAgent sql.NullString `json:"user_agent"`
}

type CreateUserParams 

type CreateUserParams struct {
	ID              uuid.UUID      `json:"id"`
	Email           string         `json:"email"`
	Username        sql.NullString `json:"username"`
	PasswordHash    string         `json:"password_hash"`
	IsEmailVerified sql.NullBool   `json:"is_email_verified"`
	IsOauthUser     sql.NullBool   `json:"is_oauth_user"`
}

type CreateUserProfileParams 

type CreateUserProfileParams struct {
	UserID    uuid.UUID      `json:"user_id"`
	ImageUrl  sql.NullString `json:"image_url"`
	FirstName sql.NullString `json:"first_name"`
	LastName  sql.NullString `json:"last_name"`
}

type CreateUserRoleParams 

type CreateUserRoleParams struct {
	UserID uuid.UUID `json:"user_id"`
	RoleID int32     `json:"role_id"`
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type EmailVerificationRequest 

type EmailVerificationRequest struct {
	ID         int64        `json:"id"`
	UserID     uuid.UUID    `json:"user_id"`
	Email      string       `json:"email"`
	Token      string       `json:"token"`
	IsVerified sql.NullBool `json:"is_verified"`
	CreatedAt  sql.NullTime `json:"created_at"`
	ExpiresAt  time.Time    `json:"expires_at"`
}

type GetSessionAndUserByRefreshTokenRow 

type GetSessionAndUserByRefreshTokenRow struct {
	ID              uuid.UUID      `json:"id"`
	UserID          uuid.UUID      `json:"user_id"`
	RefreshToken    string         `json:"refresh_token"`
	RefreshTokenExp time.Time      `json:"refresh_token_exp"`
	CreatedAt       sql.NullTime   `json:"created_at"`
	UpdatedAt       sql.NullTime   `json:"updated_at"`
	InvalidatedAt   sql.NullTime   `json:"invalidated_at"`
	LastActiveAt    sql.NullTime   `json:"last_active_at"`
	BlockedAt       sql.NullTime   `json:"blocked_at"`
	UserAgent       string         `json:"user_agent"`
	IpAddress       pqtype.Inet    `json:"ip_address"`
	FcmToken        sql.NullString `json:"fcm_token"`
	Username        sql.NullString `json:"username"`
	Email           string         `json:"email"`
	Phone           sql.NullString `json:"phone"`
	IsEmailVerified sql.NullBool   `json:"is_email_verified"`
	RoleID          sql.NullInt32  `json:"role_id"`
}

type GetUserAndRoleByIdentifierRow 

type GetUserAndRoleByIdentifierRow struct {
	ID                  uuid.UUID      `json:"id"`
	Email               string         `json:"email"`
	Phone               sql.NullString `json:"phone"`
	Username            sql.NullString `json:"username"`
	PasswordHash        string         `json:"password_hash"`
	CreatedAt           sql.NullTime   `json:"created_at"`
	UpdatedAt           sql.NullTime   `json:"updated_at"`
	IsSuspended         sql.NullBool   `json:"is_suspended"`
	IsDeleted           sql.NullBool   `json:"is_deleted"`
	IsVerified          sql.NullBool   `json:"is_verified"`
	IsEmailVerified     sql.NullBool   `json:"is_email_verified"`
	DeletedAt           sql.NullTime   `json:"deleted_at"`
	VerifiedAt          sql.NullTime   `json:"verified_at"`
	SuspendedAt         sql.NullTime   `json:"suspended_at"`
	LoginAttempts       sql.NullInt32  `json:"login_attempts"`
	PasswordLastChanged sql.NullTime   `json:"password_last_changed"`
	LockoutDuration     sql.NullInt32  `json:"lockout_duration"`
	LockoutUntil        sql.NullTime   `json:"lockout_until"`
	IsMfaEnabled        sql.NullBool   `json:"is_mfa_enabled"`
	IsOauthUser         sql.NullBool   `json:"is_oauth_user"`
	RoleID              int32          `json:"role_id"`
	ID_2                sql.NullInt32  `json:"id_2"`
	UserID              uuid.NullUUID  `json:"user_id"`
	FirstName           sql.NullString `json:"first_name"`
	LastName            sql.NullString `json:"last_name"`
	ImageUrl            sql.NullString `json:"image_url"`
}

type GetUserProfileRow 

type GetUserProfileRow struct {
	ID         uuid.UUID      `json:"id"`
	Username   sql.NullString `json:"username"`
	Email      string         `json:"email"`
	Phone      sql.NullString `json:"phone"`
	CreatedAt  sql.NullTime   `json:"created_at"`
	IsVerified sql.NullBool   `json:"is_verified"`
	FirstName  sql.NullString `json:"first_name"`
	LastName   sql.NullString `json:"last_name"`
	ImageUrl   sql.NullString `json:"image_url"`
}

type PasswordResetRequest 

type PasswordResetRequest struct {
	ID        int32        `json:"id"`
	UserID    uuid.UUID    `json:"user_id"`
	Email     string       `json:"email"`
	Token     string       `json:"token"`
	Used      sql.NullBool `json:"used"`
	CreatedAt sql.NullTime `json:"created_at"`
	ExpiresAt time.Time    `json:"expires_at"`
}

type Querier 

type Querier interface {
	BlockAllUserSession(ctx context.Context, userID uuid.UUID) error
	BlockUser(ctx context.Context, id uuid.UUID) error
	CheckUsername(ctx context.Context, lower string) (int64, error)
	CleanupVerifiedAndExpiredRequests(ctx context.Context) error
	CreateEmailVerificationRequest(ctx context.Context, arg CreateEmailVerificationRequestParams) error
	CreatePasswordResetRequest(ctx context.Context, arg CreatePasswordResetRequestParams) error
	// Create a new session
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (Authentication, error)
	CreateUserDeleteRequest(ctx context.Context, arg CreateUserDeleteRequestParams) error
	// Create a new user login
	CreateUserLogin(ctx context.Context, arg CreateUserLoginParams) (UserLogin, error)
	CreateUserProfile(ctx context.Context, arg CreateUserProfileParams) error
	CreateUserRole(ctx context.Context, arg CreateUserRoleParams) (UserRole, error)
	DeletePasswordResetRequestByID(ctx context.Context, id int32) error
	DeletePasswordResetRequestsByEmail(ctx context.Context, email string) error
	DeleteSession(ctx context.Context, id uuid.UUID) error
	DeleteUserByID(ctx context.Context, id uuid.UUID) error
	// Delete a user login
	DeleteUserLogin(ctx context.Context, id int32) error
	DeleteUserProfileByID(ctx context.Context, userID uuid.UUID) error
	GetEmailVerificationRequestByToken(ctx context.Context, token string) (EmailVerificationRequest, error)
	GetPasswordResetRequestByID(ctx context.Context, id int32) (PasswordResetRequest, error)
	GetPasswordResetRequestByToken(ctx context.Context, token string) (PasswordResetRequest, error)
	GetSessionAndUserByRefreshToken(ctx context.Context, refreshToken string) (GetSessionAndUserByRefreshTokenRow, error)
	GetSessionsByID(ctx context.Context, id uuid.UUID) (Session, error)
	GetSessionsByRefreshToken(ctx context.Context, refreshToken string) (Session, error)
	GetSessionsByUserID(ctx context.Context, userID uuid.UUID) ([]Session, error)
	GetUidsFromUsername(ctx context.Context, dollar_1 []string) ([]uuid.UUID, error)
	GetUserAndRoleByIdentifier(ctx context.Context, username sql.NullString) (GetUserAndRoleByIdentifierRow, error)
	GetUserByID(ctx context.Context, id uuid.UUID) (Authentication, error)
	GetUserByIdentifier(ctx context.Context, email string) (Authentication, error)
	GetUserByUsername(ctx context.Context, username sql.NullString) (uuid.UUID, error)
	GetUserFromDeleteReqByToken(ctx context.Context, recoveryToken string) (AccountRecoveryRequest, error)
	GetUserIDsFromUsernames(ctx context.Context, username sql.NullString) ([]uuid.UUID, error)
	// Get user logins by user ID
	GetUserLoginsByUserID(ctx context.Context, userID uuid.UUID) ([]UserLogin, error)
	GetUserProfile(ctx context.Context, username sql.NullString) (GetUserProfileRow, error)
	MarkDeleteAsUsedByToken(ctx context.Context, recoveryToken string) error
	RevokeSessionById(ctx context.Context, id uuid.UUID) error
	RotateSessionTokens(ctx context.Context, arg RotateSessionTokensParams) error
	UpdateEmailVerificationRequest(ctx context.Context, arg UpdateEmailVerificationRequestParams) (EmailVerificationRequest, error)
	UpdateImgUserProfile(ctx context.Context, arg UpdateImgUserProfileParams) error
	UpdatePasswordResetRequest(ctx context.Context, arg UpdatePasswordResetRequestParams) error
	UpdatePasswordResetRequestByToken(ctx context.Context, arg UpdatePasswordResetRequestByTokenParams) error
	UpdateUser(ctx context.Context, arg UpdateUserParams) (Authentication, error)
	// Update a user login
	UpdateUserLogin(ctx context.Context, arg UpdateUserLoginParams) (UserLogin, error)
	UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error
	UpdateUserPasswordByEmail(ctx context.Context, arg UpdateUserPasswordByEmailParams) error
}

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

func New 

func New(db DBTX) *Queries

func (*Queries) BlockAllUserSession 

func (q *Queries) BlockAllUserSession(ctx context.Context, userID uuid.UUID) error

func (*Queries) BlockUser 

func (q *Queries) BlockUser(ctx context.Context, id uuid.UUID) error

func (*Queries) CheckUsername 

func (q *Queries) CheckUsername(ctx context.Context, lower string) (int64, error)

func (*Queries) CleanupVerifiedAndExpiredRequests 

func (q *Queries) CleanupVerifiedAndExpiredRequests(ctx context.Context) error

func (*Queries) CreateEmailVerificationRequest 

func (q *Queries) CreateEmailVerificationRequest(ctx context.Context, arg CreateEmailVerificationRequestParams) error

func (*Queries) CreatePasswordResetRequest 

func (q *Queries) CreatePasswordResetRequest(ctx context.Context, arg CreatePasswordResetRequestParams) error

func (*Queries) CreateSession 

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

Create a new session

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (Authentication, error)

func (*Queries) CreateUserDeleteRequest 

func (q *Queries) CreateUserDeleteRequest(ctx context.Context, arg CreateUserDeleteRequestParams) error

func (*Queries) CreateUserLogin 

func (q *Queries) CreateUserLogin(ctx context.Context, arg CreateUserLoginParams) (UserLogin, error)

Create a new user login

func (*Queries) CreateUserProfile 

func (q *Queries) CreateUserProfile(ctx context.Context, arg CreateUserProfileParams) error

func (*Queries) CreateUserRole 

func (q *Queries) CreateUserRole(ctx context.Context, arg CreateUserRoleParams) (UserRole, error)

func (*Queries) DeletePasswordResetRequestByID 

func (q *Queries) DeletePasswordResetRequestByID(ctx context.Context, id int32) error

func (*Queries) DeletePasswordResetRequestsByEmail 

func (q *Queries) DeletePasswordResetRequestsByEmail(ctx context.Context, email string) error

func (*Queries) DeleteSession 

func (q *Queries) DeleteSession(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteUserByID 

func (q *Queries) DeleteUserByID(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteUserLogin 

func (q *Queries) DeleteUserLogin(ctx context.Context, id int32) error

Delete a user login

func (*Queries) DeleteUserProfileByID 

func (q *Queries) DeleteUserProfileByID(ctx context.Context, userID uuid.UUID) error

func (*Queries) GetEmailVerificationRequestByToken 

func (q *Queries) GetEmailVerificationRequestByToken(ctx context.Context, token string) (EmailVerificationRequest, error)

func (*Queries) GetPasswordResetRequestByID 

func (q *Queries) GetPasswordResetRequestByID(ctx context.Context, id int32) (PasswordResetRequest, error)

func (*Queries) GetPasswordResetRequestByToken 

func (q *Queries) GetPasswordResetRequestByToken(ctx context.Context, token string) (PasswordResetRequest, error)

func (*Queries) GetSessionAndUserByRefreshToken 

func (q *Queries) GetSessionAndUserByRefreshToken(ctx context.Context, refreshToken string) (GetSessionAndUserByRefreshTokenRow, error)

func (*Queries) GetSessionsByID 

func (q *Queries) GetSessionsByID(ctx context.Context, id uuid.UUID) (Session, error)

func (*Queries) GetSessionsByRefreshToken 

func (q *Queries) GetSessionsByRefreshToken(ctx context.Context, refreshToken string) (Session, error)

func (*Queries) GetSessionsByUserID 

func (q *Queries) GetSessionsByUserID(ctx context.Context, userID uuid.UUID) ([]Session, error)

func (*Queries) GetUidsFromUsername 

func (q *Queries) GetUidsFromUsername(ctx context.Context, dollar_1 []string) ([]uuid.UUID, error)

func (*Queries) GetUserAndRoleByIdentifier 

func (q *Queries) GetUserAndRoleByIdentifier(ctx context.Context, username sql.NullString) (GetUserAndRoleByIdentifierRow, error)

func (*Queries) GetUserByID 

func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (Authentication, error)

func (*Queries) GetUserByIdentifier 

func (q *Queries) GetUserByIdentifier(ctx context.Context, email string) (Authentication, error)

func (*Queries) GetUserByUsername 

func (q *Queries) GetUserByUsername(ctx context.Context, username sql.NullString) (uuid.UUID, error)

func (*Queries) GetUserFromDeleteReqByToken 

func (q *Queries) GetUserFromDeleteReqByToken(ctx context.Context, recoveryToken string) (AccountRecoveryRequest, error)

func (*Queries) GetUserIDsFromUsernames 

func (q *Queries) GetUserIDsFromUsernames(ctx context.Context, username sql.NullString) ([]uuid.UUID, error)

func (*Queries) GetUserLoginsByUserID 

func (q *Queries) GetUserLoginsByUserID(ctx context.Context, userID uuid.UUID) ([]UserLogin, error)

Get user logins by user ID

func (*Queries) GetUserProfile 

func (q *Queries) GetUserProfile(ctx context.Context, username sql.NullString) (GetUserProfileRow, error)

func (*Queries) MarkDeleteAsUsedByToken 

func (q *Queries) MarkDeleteAsUsedByToken(ctx context.Context, recoveryToken string) error

func (*Queries) RevokeSessionById 

func (q *Queries) RevokeSessionById(ctx context.Context, id uuid.UUID) error

func (*Queries) RotateSessionTokens 

func (q *Queries) RotateSessionTokens(ctx context.Context, arg RotateSessionTokensParams) error

func (*Queries) UpdateEmailVerificationRequest 

func (q *Queries) UpdateEmailVerificationRequest(ctx context.Context, arg UpdateEmailVerificationRequestParams) (EmailVerificationRequest, error)

func (*Queries) UpdateImgUserProfile 

func (q *Queries) UpdateImgUserProfile(ctx context.Context, arg UpdateImgUserProfileParams) error

func (*Queries) UpdatePasswordResetRequest 

func (q *Queries) UpdatePasswordResetRequest(ctx context.Context, arg UpdatePasswordResetRequestParams) error

func (*Queries) UpdatePasswordResetRequestByToken 

func (q *Queries) UpdatePasswordResetRequestByToken(ctx context.Context, arg UpdatePasswordResetRequestByTokenParams) error

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (Authentication, error)

func (*Queries) UpdateUserLogin 

func (q *Queries) UpdateUserLogin(ctx context.Context, arg UpdateUserLoginParams) (UserLogin, error)

Update a user login

func (*Queries) UpdateUserPassword 

func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error

func (*Queries) UpdateUserPasswordByEmail 

func (q *Queries) UpdateUserPasswordByEmail(ctx context.Context, arg UpdateUserPasswordByEmailParams) error

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Role 

type Role struct {
	ID   int32  `json:"id"`
	Name string `json:"name"`
}

type RotateSessionTokensParams 

type RotateSessionTokensParams struct {
	ID              uuid.UUID `json:"id"`
	RefreshToken    string    `json:"refresh_token"`
	RefreshTokenExp time.Time `json:"refresh_token_exp"`
}

type SQLStore 

type SQLStore struct {
	*Queries
	// contains filtered or unexported fields
}

type Session 

type Session struct {
	ID              uuid.UUID      `json:"id"`
	UserID          uuid.UUID      `json:"user_id"`
	RefreshToken    string         `json:"refresh_token"`
	RefreshTokenExp time.Time      `json:"refresh_token_exp"`
	CreatedAt       sql.NullTime   `json:"created_at"`
	UpdatedAt       sql.NullTime   `json:"updated_at"`
	InvalidatedAt   sql.NullTime   `json:"invalidated_at"`
	LastActiveAt    sql.NullTime   `json:"last_active_at"`
	BlockedAt       sql.NullTime   `json:"blocked_at"`
	UserAgent       string         `json:"user_agent"`
	IpAddress       pqtype.Inet    `json:"ip_address"`
	FcmToken        sql.NullString `json:"fcm_token"`
}

type Store 

type Store interface {
	Querier
}

func NewStore 

func NewStore(db *sql.DB) Store

type TwoFactorBackupCode 

type TwoFactorBackupCode struct {
	ID     int32        `json:"id"`
	UserID uuid.UUID    `json:"user_id"`
	Code   string       `json:"code"`
	Used   sql.NullBool `json:"used"`
}

type TwoFactorRevocation 

type TwoFactorRevocation struct {
	ID               int32          `json:"id"`
	UserID           uuid.UUID      `json:"user_id"`
	RevokedAt        sql.NullTime   `json:"revoked_at"`
	RevocationReason sql.NullString `json:"revocation_reason"`
}

type TwoFactorSecret 

type TwoFactorSecret struct {
	ID        int32        `json:"id"`
	UserID    uuid.UUID    `json:"user_id"`
	SecretKey string       `json:"secret_key"`
	IsActive  sql.NullBool `json:"is_active"`
}

type UpdateEmailVerificationRequestParams 

type UpdateEmailVerificationRequestParams struct {
	IsVerified sql.NullBool `json:"is_verified"`
	Token      string       `json:"token"`
}

type UpdateImgUserProfileParams 

type UpdateImgUserProfileParams struct {
	UserID   uuid.UUID      `json:"user_id"`
	ImageUrl sql.NullString `json:"image_url"`
}

type UpdatePasswordResetRequestByTokenParams 

type UpdatePasswordResetRequestByTokenParams struct {
	Used  sql.NullBool `json:"used"`
	Token string       `json:"token"`
}

type UpdatePasswordResetRequestParams 

type UpdatePasswordResetRequestParams struct {
	Used sql.NullBool `json:"used"`
	ID   int32        `json:"id"`
}

type UpdateUserLoginParams 

type UpdateUserLoginParams struct {
	LoginAt   sql.NullTime   `json:"login_at"`
	IpAddress pqtype.Inet    `json:"ip_address"`
	UserAgent sql.NullString `json:"user_agent"`
	ID        int32          `json:"id"`
}

type UpdateUserParams 

type UpdateUserParams struct {
	Username            sql.NullString `json:"username"`
	Email               sql.NullString `json:"email"`
	Phone               sql.NullString `json:"phone"`
	PasswordHash        sql.NullString `json:"password_hash"`
	IsEmailVerified     sql.NullBool   `json:"is_email_verified"`
	IsSuspended         sql.NullBool   `json:"is_suspended"`
	IsDeleted           sql.NullBool   `json:"is_deleted"`
	UpdatedAt           sql.NullTime   `json:"updated_at"`
	DeletedAt           sql.NullTime   `json:"deleted_at"`
	VerifiedAt          sql.NullTime   `json:"verified_at"`
	SuspendedAt         sql.NullTime   `json:"suspended_at"`
	LoginAttempts       sql.NullInt32  `json:"login_attempts"`
	LockoutDuration     sql.NullInt32  `json:"lockout_duration"`
	LockoutUntil        sql.NullTime   `json:"lockout_until"`
	PasswordLastChanged sql.NullTime   `json:"password_last_changed"`
	IsVerified          sql.NullBool   `json:"is_verified"`
	IsMfaEnabled        sql.NullBool   `json:"is_mfa_enabled"`
	ID                  uuid.UUID      `json:"id"`
}

type UpdateUserPasswordByEmailParams 

type UpdateUserPasswordByEmailParams struct {
	Email        string `json:"email"`
	PasswordHash string `json:"password_hash"`
}

type UpdateUserPasswordParams 

type UpdateUserPasswordParams struct {
	ID           uuid.UUID `json:"id"`
	PasswordHash string    `json:"password_hash"`
}

type User 

type User struct {
	ID        int32          `json:"id"`
	UserID    uuid.UUID      `json:"user_id"`
	FirstName sql.NullString `json:"first_name"`
	LastName  sql.NullString `json:"last_name"`
	ImageUrl  sql.NullString `json:"image_url"`
}

type UserLogin 

type UserLogin struct {
	ID        int32          `json:"id"`
	UserID    uuid.UUID      `json:"user_id"`
	LoginAt   sql.NullTime   `json:"login_at"`
	IpAddress pqtype.Inet    `json:"ip_address"`
	UserAgent sql.NullString `json:"user_agent"`
}

type UserRole 

type UserRole struct {
	ID     int32     `json:"id"`
	UserID uuid.UUID `json:"user_id"`
	RoleID int32     `json:"role_id"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.