db

package
v0.12.0 Latest Latest
Warning

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

Go to latest
Published: Oct 11, 2026 License: Apache-2.0 Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActivateUserParams added in v0.9.0

type ActivateUserParams struct {
	ID           uuid.UUID
	PasswordHash string
}

type AuthSession

type AuthSession struct {
	TokenHash []byte
	UserID    uuid.UUID
	CreatedAt time.Time
	ExpiresAt time.Time
}

type AuthToken added in v0.9.0

type AuthToken struct {
	TokenHash []byte
	UserID    uuid.UUID
	Purpose   string
	CreatedAt time.Time
	ExpiresAt time.Time
}

type AuthUser

type AuthUser struct {
	ID           uuid.UUID
	Email        string
	Name         string
	PasswordHash string
	Disabled     bool
	CreatedAt    time.Time
	Role         string
	Confirmed    bool
}

type CountLiveTokensParams added in v0.10.0

type CountLiveTokensParams struct {
	UserID    uuid.UUID
	Purpose   string
	ExpiresAt time.Time
}

type CreateSessionParams

type CreateSessionParams struct {
	TokenHash []byte
	UserID    uuid.UUID
	CreatedAt time.Time
	ExpiresAt time.Time
}

type CreateTokenParams added in v0.9.0

type CreateTokenParams struct {
	TokenHash []byte
	UserID    uuid.UUID
	Purpose   string
	CreatedAt time.Time
	ExpiresAt time.Time
}

type CreateUserParams

type CreateUserParams struct {
	ID           uuid.UUID
	Email        string
	Name         string
	PasswordHash string
	Disabled     bool
	CreatedAt    time.Time
	Role         string
	Confirmed    bool
}

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 DeleteUnconfirmedAccountsParams added in v0.9.0

type DeleteUnconfirmedAccountsParams struct {
	Column1   []uuid.UUID
	Purpose   string
	ExpiresAt time.Time
}

type DeleteUserTokensForPurposeParams added in v0.9.0

type DeleteUserTokensForPurposeParams struct {
	UserID  uuid.UUID
	Purpose string
}

type ExpiredTokensRow added in v0.9.0

type ExpiredTokensRow struct {
	UserID  uuid.UUID
	Purpose string
}

type FindLiveTokenParams added in v0.9.0

type FindLiveTokenParams struct {
	TokenHash []byte
	Purpose   string
	ExpiresAt time.Time
}

type GetUserBySessionParams

type GetUserBySessionParams struct {
	TokenHash []byte
	ExpiresAt time.Time
}

type ListUsersRow

type ListUsersRow struct {
	ID        uuid.UUID
	Email     string
	Name      string
	Disabled  bool
	Confirmed bool
	CreatedAt time.Time
	Role      string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ActivateUser added in v0.9.0

func (q *Queries) ActivateUser(ctx context.Context, arg ActivateUserParams) (int64, error)

func (*Queries) CountLiveTokens added in v0.10.0

func (q *Queries) CountLiveTokens(ctx context.Context, arg CountLiveTokensParams) (int64, error)

func (*Queries) CreateSession

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

func (*Queries) CreateToken added in v0.9.0

func (q *Queries) CreateToken(ctx context.Context, arg CreateTokenParams) error

func (*Queries) CreateUser

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

SPDX-License-Identifier: Apache-2.0

func (*Queries) DeleteExpiredSessions

func (q *Queries) DeleteExpiredSessions(ctx context.Context, expiresAt time.Time) (int64, error)

func (*Queries) DeleteExpiredTokens added in v0.9.0

func (q *Queries) DeleteExpiredTokens(ctx context.Context, expiresAt time.Time) (int64, error)

func (*Queries) DeleteSession

func (q *Queries) DeleteSession(ctx context.Context, tokenHash []byte) error

func (*Queries) DeleteToken added in v0.9.0

func (q *Queries) DeleteToken(ctx context.Context, tokenHash []byte) (int64, error)

func (*Queries) DeleteUnconfirmedAccounts added in v0.9.0

func (q *Queries) DeleteUnconfirmedAccounts(ctx context.Context, arg DeleteUnconfirmedAccountsParams) error

func (*Queries) DeleteUserSessions

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

func (*Queries) DeleteUserTokens added in v0.9.0

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

func (*Queries) DeleteUserTokensForPurpose added in v0.9.0

func (q *Queries) DeleteUserTokensForPurpose(ctx context.Context, arg DeleteUserTokensForPurposeParams) error

func (*Queries) ExpiredTokens added in v0.9.0

func (q *Queries) ExpiredTokens(ctx context.Context, expiresAt time.Time) ([]ExpiredTokensRow, error)

func (*Queries) FindLiveToken added in v0.9.0

func (q *Queries) FindLiveToken(ctx context.Context, arg FindLiveTokenParams) (uuid.UUID, error)

func (*Queries) GetUserByEmail

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

func (*Queries) GetUserByID added in v0.3.0

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

func (*Queries) GetUserBySession

func (q *Queries) GetUserBySession(ctx context.Context, arg GetUserBySessionParams) (AuthUser, error)

func (*Queries) GrantRoleToRoleless added in v0.7.0

func (q *Queries) GrantRoleToRoleless(ctx context.Context, role string) (int64, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context) ([]ListUsersRow, error)

func (*Queries) LockEnabledUser added in v0.9.0

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

func (*Queries) LockUnactivatedUser added in v0.9.0

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

func (*Queries) LockUnconfirmedAccounts added in v0.9.0

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

func (*Queries) SetUserDisabled

func (q *Queries) SetUserDisabled(ctx context.Context, arg SetUserDisabledParams) (int64, error)

func (*Queries) SetUserPassword added in v0.9.0

func (q *Queries) SetUserPassword(ctx context.Context, arg SetUserPasswordParams) (int64, error)

func (*Queries) SetUserRole added in v0.7.0

func (q *Queries) SetUserRole(ctx context.Context, arg SetUserRoleParams) (int64, error)

func (*Queries) WithTx

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

type SetUserDisabledParams

type SetUserDisabledParams struct {
	ID       uuid.UUID
	Disabled bool
}

type SetUserPasswordParams added in v0.9.0

type SetUserPasswordParams struct {
	ID           uuid.UUID
	PasswordHash string
}

type SetUserRoleParams added in v0.7.0

type SetUserRoleParams struct {
	ID   uuid.UUID
	Role string
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL