usersql

Documentation

Index

• type DBTX
• type ListMembershipsParams
• type ListMembershipsRow
• type ListParams
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) Count(ctx context.Context) (int64, error)
  • func (q *Queries) CountMemberships(ctx context.Context, userID uuid.UUID) (int64, error)
  • func (q *Queries) Delete(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) Get(ctx context.Context, id uuid.UUID) (*User, error)
  • func (q *Queries) GetByEmail(ctx context.Context, email string) (*User, error)
  • func (q *Queries) GetByExternalID(ctx context.Context, externalID string) (*User, error)
  • func (q *Queries) GetByIDs(ctx context.Context, ids []uuid.UUID) ([]*User, error)
  • func (q *Queries) List(ctx context.Context, arg ListParams) ([]*User, error)
  • func (q *Queries) ListGCPGroupsForUser(ctx context.Context, userID uuid.UUID) ([]string, error)
  • func (q *Queries) ListMemberships(ctx context.Context, arg ListMembershipsParams) ([]*ListMembershipsRow, error)
  • func (q *Queries) Update(ctx context.Context, arg UpdateParams) (*User, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Team
• type UpdateParams
• type User

Types

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 ListMembershipsParams

type ListMembershipsParams struct {
	UserID uuid.UUID
	Offset int32
	Limit  int32
}

type ListMembershipsRow

type ListMembershipsRow struct {
	Team     Team
	RoleName string
}

type ListParams

type ListParams struct {
	OrderBy string
	Offset  int32
	Limit   int32
}

type Querier

type Querier interface {
	Count(ctx context.Context) (int64, error)
	CountMemberships(ctx context.Context, userID uuid.UUID) (int64, error)
	Delete(ctx context.Context, id uuid.UUID) error
	Get(ctx context.Context, id uuid.UUID) (*User, error)
	GetByEmail(ctx context.Context, email string) (*User, error)
	GetByExternalID(ctx context.Context, externalID string) (*User, error)
	GetByIDs(ctx context.Context, ids []uuid.UUID) ([]*User, error)
	List(ctx context.Context, arg ListParams) ([]*User, error)
	ListGCPGroupsForUser(ctx context.Context, userID uuid.UUID) ([]string, error)
	ListMemberships(ctx context.Context, arg ListMembershipsParams) ([]*ListMembershipsRow, error)
	Update(ctx context.Context, arg UpdateParams) (*User, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) Count

func (q *Queries) Count(ctx context.Context) (int64, error)

func (*Queries) CountMemberships

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

func (*Queries) Delete

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

func (*Queries) Get

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

func (*Queries) GetByEmail

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

func (*Queries) GetByExternalID

func (q *Queries) GetByExternalID(ctx context.Context, externalID string) (*User, error)

func (*Queries) GetByIDs

func (q *Queries) GetByIDs(ctx context.Context, ids []uuid.UUID) ([]*User, error)

func (*Queries) List

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

func (*Queries) ListGCPGroupsForUser

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

func (*Queries) ListMemberships

func (q *Queries) ListMemberships(ctx context.Context, arg ListMembershipsParams) ([]*ListMembershipsRow, error)

func (*Queries) Update

func (q *Queries) Update(ctx context.Context, arg UpdateParams) (*User, error)

func (*Queries) WithTx

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

type Team

type Team struct {
	Slug                 slug.Slug
	Purpose              string
	LastSuccessfulSync   pgtype.Timestamp
	SlackChannel         string
	GoogleGroupEmail     *string
	EntraIDGroupID       *uuid.UUID
	GithubTeamSlug       *string
	GarRepository        *string
	CdnBucket            *string
	DeleteKeyConfirmedAt pgtype.Timestamptz
}

type UpdateParams

type UpdateParams struct {
	Name       string
	Email      string
	ExternalID string
	ID         uuid.UUID
}

type User

type User struct {
	ID         uuid.UUID
	Email      string
	Name       string
	ExternalID string
	Admin      bool
}