Contents

module ActiveReporter
  module Dimension
    class Bin
      class Table < Array
        def initialize(values)
          super(values.compact)
        end

        def filter(relation, expr)
          relation.where(any_contain(expr))
        end

        def group(relation, expr, value_name)
          name = "#{value_name}_bin_table"

          bin_join = <<~SQL
            INNER JOIN (
              #{rows.join(" UNION\n  ")}
            ) AS #{name} ON (
              CASE
              WHEN #{name}.min IS NULL AND #{name}.max IS NULL THEN (#{expr} IS NULL)
              WHEN #{name}.min IS NULL THEN (#{expr} < #{name}.max)
              WHEN #{name}.max IS NULL THEN (#{expr} >= #{name}.min)
              ELSE ((#{expr} >= #{name}.min) AND (#{expr} < #{name}.max))
              END
            )
          SQL

          selection = "#{name}.bin_text AS #{value_name}"
          relation.joins(bin_join).select(selection).group(value_name)
        end

        def rows
          map(&:row_sql)
        end

        def any_contain(expr)
          map { |bin| bin.contains_sql(expr) }.join(" OR ")
        end
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
active_reporter-0.7.1	lib/active_reporter/dimension/bin/table.rb
active_reporter-0.6.5	lib/active_reporter/dimension/bin/table.rb
active_reporter-0.6.4	lib/active_reporter/dimension/bin/table.rb