Method CountOIDCLinkedIDsByIssuer

coderd/database/querier.go:109–109

Groups OIDC user links by their issuer prefix (the part before "||" in linked_id) and returns a count for each. Empty linked_ids are reported with an empty issuer_prefix. Used for analysis before resetting mismatched links.

(ctx context.Context)

	// with an empty issuer_prefix. Used for analysis before resetting
	// mismatched links.
	CountOIDCLinkedIDsByIssuer(ctx context.Context) ([]CountOIDCLinkedIDsByIssuerRow, error)
	// CountPendingNonActivePrebuilds returns the number of pending prebuilds for non-active template versions
	CountPendingNonActivePrebuilds(ctx context.Context) ([]CountPendingNonActivePrebuildsRow, error)
	CountUnreadInboxNotificationsByUserID(ctx context.Context, userID uuid.UUID) (int64, error)