Contents

module Repor
  module Dimensions
    class CategoryDimension < BaseDimension
      def filter(relation)
        values = filter_values
        query = "#{expression} IN (?)"
        query = "#{expression} IS NULL OR #{query}" if values.include?(nil)
        relation.where(query, values.compact)
      end

      def group(relation)
        order relation.select("#{expression} AS #{sql_value_name}").group(sql_value_name)
      end

      def group_values
        if filtering?
          filter_values
        else
          i = report.groupers.index(self)
          report.raw_data.map { |x, _y| x[i] }.uniq
        end
      end

      def all_values
        relate(report.base_relation).
          pluck("DISTINCT #{expression}").
          map(&method(:sanitize_sql_value))
      end
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
repor-0.1.0	lib/repor/dimensions/category_dimension.rb