aboutsummaryrefslogtreecommitdiffstats
path: root/spec/active_relation/primitives/expression_spec.rb
blob: fa854d89f9a4d11ae79a6e4b0768d1e4e29f4201 (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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
require File.join(File.dirname(__FILE__), '..', '..', 'spec_helper')

module ActiveRelation
  describe Expression do
    before do
      @relation = Table.new(:users)
      @attribute = @relation[:id]
    end
    
    describe Expression::Transformations do
      before do
        @expression = Expression.new(@attribute, "COUNT")
      end
      
      describe '#bind' do
        it "manufactures an attribute with a rebound relation and self as the ancestor" do
          derived_relation = @relation.select(@relation[:id] == 1)
          @expression.bind(derived_relation).should == Expression.new(@attribute.bind(derived_relation), "COUNT", nil, @expression)
        end
        
        it "returns self if the substituting to the same relation" do
          @expression.bind(@relation).should == @expression
        end
      end
      
      describe '#as' do
        it "manufactures an aliased expression" do
          @expression.as(:foo).should == Expression.new(@attribute, "COUNT", :foo, @expression)
        end
      end
      
      describe '#to_attribute' do
        it "manufactures an attribute with the expression as an ancestor" do
          @expression.to_attribute.should == Attribute.new(@expression.relation, @expression.alias, nil, @expression)
        end
      end
      
      describe '#qualify' do
        it "manufactures an expression aliased with that expression's qualified name" do
          @expression.qualify.should == Expression.new(@attribute, "COUNT", @expression.qualified_name, @expression)
        end
      end
    end
    
    describe '=~' do
      it "obtains if the expressions are identical" do
        Expression.new(@attribute, "COUNT").should =~ Expression.new(@attribute, "COUNT")
      end
      
      it "obtains if the expressions have an overlapping history" do
        Expression.new(@attribute, "COUNT", nil, Expression.new(@attribute, "COUNT")).should =~ Expression.new(@attribute, "COUNT")
        Expression.new(@attribute, "COUNT").should =~ Expression.new(@attribute, "COUNT", nil, Expression.new(@attribute, "COUNT"))  
      end
    end
    
    describe '#to_sql' do
      it "manufactures sql with the expression and alias" do
        Expression.new(@attribute, "COUNT", :alias).to_sql.should == "COUNT(`users`.`id`) AS `alias`"
      end
    end
  end
end