Contents

RSpec.describe ROM::Relation, '#group' do
  subject(:relation) { relations[:users] }

  let(:tasks) { relations[:tasks] }

  include_context 'users and tasks'

  with_adapters do
    it 'groups by provided attribute name' do |example|
      # Oracle doesn't support concise GROUP BY
      group_by = oracle?(example) ? %i(id name) : %i(id)
      grouped = relation.
                  qualified.
                  left_join(:tasks, tasks[:user_id].qualified => relation[:id].qualified).
                  group(*group_by)

      expect(grouped.to_a).to eql([{ id: 1, name: 'Jane' }, { id: 2, name: 'Joe'}])
    end

    it 'groups by provided attribute name in a block' do
      grouped = relation.
                  qualified.
                  left_join(:tasks, tasks[:user_id].qualified => relation[:id].qualified).
                  group { [id.qualified, name.qualified] }

      expect(grouped.to_a).to eql([{ id: 1, name: 'Jane' }, { id: 2, name: 'Joe'}])
    end

    it 'groups by aliased attributes' do
      grouped = relation.
                  select { id.as(:user_id) }.
                  group(:id)

      expect(grouped.to_a).to eql([{ user_id: 1 }, { user_id: 2 }])
    end
  end

  with_adapters :postgres do
    it 'groups by provided attribute name in and attributes from a block' do
      grouped = relation.
                  qualified.
                  left_join(:tasks, tasks[:user_id].qualified => relation[:id].qualified).
                  group(tasks[:title]) { id.qualified }

      expect(grouped.to_a).to eql([{ id: 1, name: 'Jane' }, { id: 2, name: 'Joe'}])
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
rom-sql-1.1.1	spec/unit/relation/group_spec.rb
rom-sql-1.1.0	spec/unit/relation/group_spec.rb
rom-sql-1.0.3	spec/unit/relation/group_spec.rb
rom-sql-1.0.2	spec/unit/relation/group_spec.rb