test/nodes/test_count.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

# frozen_string_literal: true
require 'helper'

describe Arel::Nodes::Count do
  describe "as" do
    it 'should alias the count' do
      table = Arel::Table.new :users
      table[:id].count.as('foo').to_sql.must_be_like %{
        COUNT("users"."id") AS foo
      }
    end
  end

  describe "eq" do
    it "should compare the count" do
      table = Arel::Table.new :users
      table[:id].count.eq(2).to_sql.must_be_like %{
        COUNT("users"."id") = 2
      }
    end
  end

  describe 'equality' do
    it 'is equal with equal ivars' do
      array = [Arel::Nodes::Count.new('foo'), Arel::Nodes::Count.new('foo')]
      assert_equal 1, array.uniq.size
    end

    it 'is not equal with different ivars' do
      array = [Arel::Nodes::Count.new('foo'), Arel::Nodes::Count.new('foo!')]
      assert_equal 2, array.uniq.size
    end
  end
end