Method ListIdentityProviders

backend/store/idp.go:154–218

ListIdentityProviders lists identity providers.

(ctx context.Context, find *FindIdentityProviderMessage)

// ListIdentityProviders lists identity providers.
func (s *Store) ListIdentityProviders(ctx context.Context, find *FindIdentityProviderMessage) ([]*IdentityProviderMessage, error) {
	q := qb.Q().Space(`
		SELECT
			resource_id,
			workspace,
			name,
			domain,
			type,
			config
		FROM idp
		WHERE TRUE
	`)

	if v := find.Workspace; v != nil {
		q.And("workspace = ?", *v)
	} else {
		q.And("workspace IS NULL")
	}

	if v := find.ResourceID; v != nil {
		q.And("resource_id = ?", *v)
	}

	q.Space("ORDER BY resource_id ASC")

	query, args, err := q.ToSQL()
	if err != nil {
		return nil, errors.Wrapf(err, "failed to build sql")
	}

	rows, err := s.GetDB().QueryContext(ctx, query, args...)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var identityProviderMessages []*IdentityProviderMessage
	for rows.Next() {
		var identityProviderMessage IdentityProviderMessage
		var workspace sql.NullString
		var identityProviderType string
		var identityProviderConfig string
		if err := rows.Scan(
			&identityProviderMessage.ResourceID,
			&workspace,
			&identityProviderMessage.Title,
			&identityProviderMessage.Domain,
			&identityProviderType,
			&identityProviderConfig,
		); err != nil {
			return nil, err
		}
		if workspace.Valid {
			identityProviderMessage.Workspace = workspace.String
		}
		identityProviderMessage.Type = convertIdentityProviderType(identityProviderType)
		identityProviderMessage.Config = convertIdentityProviderConfigString(identityProviderMessage.Type, identityProviderConfig)
		identityProviderMessages = append(identityProviderMessages, &identityProviderMessage)