aboutsummaryrefslogblamecommitdiffstats
path: root/activerecord/test/cases/arel/nodes/extract_test.rb
blob: 8fc1e04d670f61a1814b656c4d6b4a8b2c7ff0e2 (plain) (tree)
1
2
3
4
5
6
7
8
                             

                            
 
                                           

                                  
                                                            




                                            
                                    
                                    
                                                                        


                                                     
 
                                         
                                    
                                                 
                          
                       

                                  
     
 

                                     
                                    
                                                                        


                                     
                                             
                                    
                                                                        


                                     
   
# frozen_string_literal: true

require_relative "../helper"

class Arel::Nodes::ExtractTest < Arel::Spec
  it "should extract field" do
    table = Arel::Table.new :users
    table[:timestamp].extract("date").to_sql.must_be_like %{
      EXTRACT(DATE FROM "users"."timestamp")
    }
  end

  describe "as" do
    it "should alias the extract" do
      table = Arel::Table.new :users
      table[:timestamp].extract("date").as("foo").to_sql.must_be_like %{
        EXTRACT(DATE FROM "users"."timestamp") AS foo
      }
    end

    it "should not mutate the extract" do
      table = Arel::Table.new :users
      extract = table[:timestamp].extract("date")
      before = extract.dup
      extract.as("foo")
      assert_equal extract, before
    end
  end

  describe "equality" do
    it "is equal with equal ivars" do
      table = Arel::Table.new :users
      array = [table[:attr].extract("foo"), table[:attr].extract("foo")]
      assert_equal 1, array.uniq.size
    end

    it "is not equal with different ivars" do
      table = Arel::Table.new :users
      array = [table[:attr].extract("foo"), table[:attr].extract("bar")]
      assert_equal 2, array.uniq.size
    end
  end
end