Function InternStringNullable

internal/dbinterface/string_pool.go:120–170

InternStringNullable interns one or more optional string values and returns their IDs as sql.NullInt64. Returns sql.NullInt64{Valid: false} for any value pointer that is nil or points to an empty string. This is designed for use within transactions. Performance: For a single string, uses a fast-pat

(ctx context.Context, tx TxQuerier, values ...*string)

// Performance: For a single string, uses a fast-path. For multiple strings, collects non-empty values
// and delegates to InternStrings for efficient batch processing.
func InternStringNullable(ctx context.Context, tx TxQuerier, values ...*string) ([]sql.NullInt64, error) {
	if len(values) == 0 {
		return []sql.NullInt64{}, nil
	}

	// Fast path for single string
	if len(values) == 1 {
		if values[0] == nil || *values[0] == "" {
			return []sql.NullInt64{{Valid: false}}, nil
		}

		ids, err := InternStrings(ctx, tx, *values[0])
		if err != nil {
			return nil, err
		}

		return []sql.NullInt64{{Int64: ids[0], Valid: true}}, nil
	}

	// Batch path: collect non-empty values and track their positions
	results := make([]sql.NullInt64, len(values))
	var nonEmptyValues []string
	var positions []int

	for i, v := range values {
		if v == nil || *v == "" {
			results[i] = sql.NullInt64{Valid: false}
			continue
		}
		nonEmptyValues = append(nonEmptyValues, *v)
		positions = append(positions, i)
	}

	// If no non-empty values, return early
	if len(nonEmptyValues) == 0 {
		return results, nil
	}

	// Intern all non-empty values (InternStrings handles deduplication internally)
	ids, err := InternStrings(ctx, tx, nonEmptyValues...)
	if err != nil {
		return nil, err
	}

	// Map IDs back to original positions
	for i, pos := range positions {
		results[pos] = sql.NullInt64{Int64: ids[i], Valid: true}
	}

	return results, nil
}

// InternEmptyString ensures the empty string exists in string_pool and returns its ID.
// This is needed for special cases like localhost bypass auth where an empty username