sqlc

Documentation

Index

• type CreateUserParams
• type DBTX
• type ListUsersParams
• type NullUserStatus
  • func (ns *NullUserStatus) Scan(value interface{}) error
  • func (ns NullUserStatus) Value() (driver.Value, error)
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CountUsers(ctx context.Context, nameSearch pgtype.Text) (int64, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error
  • func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetUser(ctx context.Context, id uuid.UUID) (User, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserByEmailVerificationToken(ctx context.Context, emailVerificationToken pgtype.Text) (User, error)
  • func (q *Queries) GetUserByPasswordResetToken(ctx context.Context, passwordResetToken pgtype.Text) (User, error)
  • func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)
  • func (q *Queries) SetEmailVerificationToken(ctx context.Context, arg SetEmailVerificationTokenParams) error
  • func (q *Queries) SetPasswordResetToken(ctx context.Context, arg SetPasswordResetTokenParams) error
  • func (q *Queries) UpdateLastLogin(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error
  • func (q *Queries) UpdateUserEmail(ctx context.Context, arg UpdateUserEmailParams) error
  • func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error
  • func (q *Queries) VerifyUserEmail(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type SetEmailVerificationTokenParams
• type SetPasswordResetTokenParams
• type UpdateUserEmailParams
• type UpdateUserParams
• type UpdateUserPasswordParams
• type User
• type UserStatus
  • func (e *UserStatus) Scan(src interface{}) error

Types

type CreateUserParams

type CreateUserParams struct {
	Name         string
	Email        string
	PasswordHash string
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type ListUsersParams

type ListUsersParams struct {
	NameSearch pgtype.Text
	Status     NullUserStatus
	OrderDesc  bool
	Offset     int32
	Limit      int32
}

type NullUserStatus

type NullUserStatus struct {
	UserStatus UserStatus
	Valid      bool // Valid is true if UserStatus is not NULL
}

func (*NullUserStatus) Scan

func (ns *NullUserStatus) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullUserStatus) Value

func (ns NullUserStatus) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountUsers

func (q *Queries) CountUsers(ctx context.Context, nameSearch pgtype.Text) (int64, error)

func (*Queries) CreateUser

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

func (*Queries) DeleteUser

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

func (*Queries) GetUser

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

func (*Queries) GetUserByEmail

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

func (*Queries) GetUserByEmailVerificationToken

func (q *Queries) GetUserByEmailVerificationToken(ctx context.Context, emailVerificationToken pgtype.Text) (User, error)

func (*Queries) GetUserByPasswordResetToken

func (q *Queries) GetUserByPasswordResetToken(ctx context.Context, passwordResetToken pgtype.Text) (User, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)

func (*Queries) SetEmailVerificationToken

func (q *Queries) SetEmailVerificationToken(ctx context.Context, arg SetEmailVerificationTokenParams) error

func (*Queries) SetPasswordResetToken

func (q *Queries) SetPasswordResetToken(ctx context.Context, arg SetPasswordResetTokenParams) error

func (*Queries) UpdateLastLogin

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

func (*Queries) UpdateUser

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

func (*Queries) UpdateUserEmail

func (q *Queries) UpdateUserEmail(ctx context.Context, arg UpdateUserEmailParams) error

func (*Queries) UpdateUserPassword

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

func (*Queries) VerifyUserEmail

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

func (*Queries) WithTx

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

type SetEmailVerificationTokenParams

type SetEmailVerificationTokenParams struct {
	ID                       uuid.UUID
	EmailVerificationToken   pgtype.Text
	EmailVerificationExpires pgtype.Timestamptz
}

type SetPasswordResetTokenParams

type SetPasswordResetTokenParams struct {
	ID                   uuid.UUID
	PasswordResetToken   pgtype.Text
	PasswordResetExpires pgtype.Timestamptz
}

type UpdateUserEmailParams

type UpdateUserEmailParams struct {
	ID    uuid.UUID
	Email string
}

type UpdateUserParams

type UpdateUserParams struct {
	ID   uuid.UUID
	Name string
}

type UpdateUserPasswordParams

type UpdateUserPasswordParams struct {
	ID           uuid.UUID
	PasswordHash string
}

type User

type User struct {
	ID                       uuid.UUID
	CreatedAt                pgtype.Timestamptz
	UpdatedAt                pgtype.Timestamptz
	Name                     string
	Status                   UserStatus
	Email                    string
	EmailVerified            bool
	EmailVerificationToken   pgtype.Text
	EmailVerificationExpires pgtype.Timestamptz
	PasswordHash             string
	PasswordResetToken       pgtype.Text
	PasswordResetExpires     pgtype.Timestamptz
	LastLogin                pgtype.Timestamptz
	LastPasswordChange       pgtype.Timestamptz
}

type UserStatus

type UserStatus string

const (
	UserStatusACTIVE      UserStatus = "ACTIVE"
	UserStatusDEACTIVATED UserStatus = "DEACTIVATED"
	UserStatusSUSPENDED   UserStatus = "SUSPENDED"
)

func (*UserStatus) Scan

func (e *UserStatus) Scan(src interface{}) error