Contents

module Torque
  module PostgreSQL
    module Relation
      module DistinctOn

        # :nodoc:
        def distinct_on_values; get_value(:distinct_on); end
        # :nodoc:
        def distinct_on_values=(value); set_value(:distinct_on, value); end

        # Specifies whether the records should be unique or not by a given set
        # of fields. For example:
        #
        #   User.distinct_on(:name)
        #   # Returns 1 record per distinct name
        #
        #   User.distinct_on(:name, :email)
        #   # Returns 1 record per distinct name and email
        #
        #   User.distinct_on(false)
        #   # You can also remove the uniqueness
        def distinct_on(*value)
          spawn.distinct_on!(*value)
        end

        # Like #distinct_on, but modifies relation in place.
        def distinct_on!(*value)
          self.distinct_on_values = value
          self
        end

        private

          # Hook arel build to add the distinct on clause
          def build_arel(*)
            arel = super
            value = self.distinct_on_values
            arel.distinct_on(resolve_column(value)) if value.present?
            arel
          end

      end
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
torque-postgresql-2.0.3	lib/torque/postgresql/relation/distinct_on.rb
torque-postgresql-2.0.2	lib/torque/postgresql/relation/distinct_on.rb
torque-postgresql-2.0.1	lib/torque/postgresql/relation/distinct_on.rb
torque-postgresql-2.0.0	lib/torque/postgresql/relation/distinct_on.rb