blob: 3107659e77ab0855316df6f024d99b0fdfaab5ad (
plain) (
blame)
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
35
36
37
38
39
40
41
42
43
44
|
# frozen_string_literal: true
require_relative "../helper"
class Arel::Nodes::CountTest < Arel::Spec
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
describe "math" do
it "allows mathematical functions" do
table = Arel::Table.new :users
(table[:id].count + 1).to_sql.must_be_like %{
(COUNT("users"."id") + 1)
}
end
end
end
|
