query

Documentation

Index

• type CreateUserParams
• type CreateUserPasswordCredentialParams
• type CreateUserSessionParams
• type DBTX
• type FindUserWithPasswordCredentialByEmailRow
• type PasswordResetToken
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error
  • func (q *Queries) CreateUserPasswordCredential(ctx context.Context, arg CreateUserPasswordCredentialParams) error
  • func (q *Queries) CreateUserSession(ctx context.Context, arg CreateUserSessionParams) (uuid.UUID, error)
  • func (q *Queries) DeleteExpiredPasswordResetTokens(ctx context.Context) error
  • func (q *Queries) ExpireAllSessionsByUserID(ctx context.Context, userID uuid.UUID) ([]uuid.UUID, error)
  • func (q *Queries) ExpireSessionByID(ctx context.Context, id uuid.UUID) (uuid.UUID, error)
  • func (q *Queries) FindPasswordResetToken(ctx context.Context, token string) (PasswordResetToken, error)
  • func (q *Queries) FindUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) FindUserByID(ctx context.Context, id uuid.UUID) (User, error)
  • func (q *Queries) FindUserSessionByID(ctx context.Context, id uuid.UUID) (UserSession, error)
  • func (q *Queries) FindUserWithPasswordCredentialByEmail(ctx context.Context, email string) (FindUserWithPasswordCredentialByEmailRow, error)
  • func (q *Queries) MarkPasswordResetTokenAsUsed(ctx context.Context, token string) error
  • func (q *Queries) MarkUserEmailVerificationTokenAsUsed(ctx context.Context, token string) error
  • func (q *Queries) SetUserEmailByID(ctx context.Context, arg SetUserEmailByIDParams) error
  • func (q *Queries) UpsertEmailVerificationToken(ctx context.Context, arg UpsertEmailVerificationTokenParams) (UpsertEmailVerificationTokenRow, error)
  • func (q *Queries) UpsertPasswordCredentialByUserID(ctx context.Context, arg UpsertPasswordCredentialByUserIDParams) error
  • func (q *Queries) UpsertPasswordResetToken(ctx context.Context, arg UpsertPasswordResetTokenParams) (UpsertPasswordResetTokenRow, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type SetUserEmailByIDParams
• type UpsertEmailVerificationTokenParams
• type UpsertEmailVerificationTokenRow
• type UpsertPasswordCredentialByUserIDParams
• type UpsertPasswordResetTokenParams
• type UpsertPasswordResetTokenRow
• type User
• type UserCredential
• type UserEmailVerificationToken
• type UserSession

Types

type CreateUserParams

type CreateUserParams struct {
	ID    uuid.UUID
	Email string
}

type CreateUserPasswordCredentialParams

type CreateUserPasswordCredentialParams struct {
	ID                   uuid.UUID
	Name                 string
	UserID               uuid.UUID
	UserCredentialKey    string
	UserCredentialSecret string
}

type CreateUserSessionParams

type CreateUserSessionParams struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	ExpiresAt pgtype.Timestamp
}

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 FindUserWithPasswordCredentialByEmailRow

type FindUserWithPasswordCredentialByEmailRow struct {
	ID              uuid.UUID
	CreatedAt       pgtype.Timestamp
	UpdatedAt       pgtype.Timestamp
	Email           string
	IsEmailVerified bool
	FirstName       *string
	LastName        *string
	PasswordHash    string
}

type PasswordResetToken

type PasswordResetToken struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	IsUsed    bool
	Token     string
	ExpiresAt pgtype.Timestamp
	UserID    uuid.UUID
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateUser

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

func (*Queries) CreateUserPasswordCredential

func (q *Queries) CreateUserPasswordCredential(ctx context.Context, arg CreateUserPasswordCredentialParams) error

func (*Queries) CreateUserSession

func (q *Queries) CreateUserSession(ctx context.Context, arg CreateUserSessionParams) (uuid.UUID, error)

func (*Queries) DeleteExpiredPasswordResetTokens

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

func (*Queries) ExpireAllSessionsByUserID

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

func (*Queries) ExpireSessionByID

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

func (*Queries) FindPasswordResetToken

func (q *Queries) FindPasswordResetToken(ctx context.Context, token string) (PasswordResetToken, error)

func (*Queries) FindUserByEmail

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

func (*Queries) FindUserByID

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

func (*Queries) FindUserSessionByID

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

func (*Queries) FindUserWithPasswordCredentialByEmail

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

func (*Queries) MarkPasswordResetTokenAsUsed

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

func (*Queries) MarkUserEmailVerificationTokenAsUsed

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

func (*Queries) SetUserEmailByID

func (q *Queries) SetUserEmailByID(ctx context.Context, arg SetUserEmailByIDParams) error

func (*Queries) UpsertEmailVerificationToken

func (q *Queries) UpsertEmailVerificationToken(ctx context.Context, arg UpsertEmailVerificationTokenParams) (UpsertEmailVerificationTokenRow, error)

func (*Queries) UpsertPasswordCredentialByUserID

func (q *Queries) UpsertPasswordCredentialByUserID(ctx context.Context, arg UpsertPasswordCredentialByUserIDParams) error

func (*Queries) UpsertPasswordResetToken

func (q *Queries) UpsertPasswordResetToken(ctx context.Context, arg UpsertPasswordResetTokenParams) (UpsertPasswordResetTokenRow, error)

func (*Queries) WithTx

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

type SetUserEmailByIDParams

type SetUserEmailByIDParams struct {
	Email string
	ID    uuid.UUID
}

type UpsertEmailVerificationTokenParams

type UpsertEmailVerificationTokenParams struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	Token     string
	ExpiresAt bool
}

type UpsertEmailVerificationTokenRow

type UpsertEmailVerificationTokenRow struct {
	Token string
	ID    uuid.UUID
}

type UpsertPasswordCredentialByUserIDParams

type UpsertPasswordCredentialByUserIDParams struct {
	ID                   uuid.UUID
	UserID               uuid.UUID
	UserCredentialKey    string
	UserCredentialSecret string
}

type UpsertPasswordResetTokenParams

type UpsertPasswordResetTokenParams struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	Token     string
	ExpiresAt pgtype.Timestamp
}

type UpsertPasswordResetTokenRow

type UpsertPasswordResetTokenRow struct {
	Token     string
	ID        uuid.UUID
	ExpiresAt pgtype.Timestamp
}

type User

type User struct {
	ID              uuid.UUID
	CreatedAt       pgtype.Timestamp
	UpdatedAt       pgtype.Timestamp
	Email           string
	IsEmailVerified bool
	FirstName       *string
	LastName        *string
}

type UserCredential

type UserCredential struct {
	ID                   uuid.UUID
	CreatedAt            pgtype.Timestamp
	UpdatedAt            pgtype.Timestamp
	Name                 string
	UserID               uuid.UUID
	UserCredentialKey    string
	UserCredentialSecret string
}

type UserEmailVerificationToken

type UserEmailVerificationToken struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	IsUsed    bool
	Token     string
	Email     string
	UserID    uuid.UUID
}

type UserSession

type UserSession struct {
	ID        uuid.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	ExpiresAt pgtype.Timestamp
	UserID    uuid.UUID
	EvictedBy uuid.UUID
}