aboutsummaryrefslogblamecommitdiffstats
path: root/activerecord/test/cases/date_test.rb
blob: 9f412cdb63bb0304a207f1e03ded1277f056a400 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
13

                             

                      
 







                                                            
                                        



                                                              




                                                                  

                                                                                                                                      





                                                                                      



                                    
                                                                                                                                        

                                                                                        
                                                                                                                                                          
            
                                                                                                                                                  
           



         
# frozen_string_literal: true

require "cases/helper"
require "models/topic"

class DateTest < ActiveRecord::TestCase
  def test_date_with_time_value
    time_value = Time.new(2016, 05, 11, 19, 0, 0)
    topic = Topic.create(last_read: time_value)
    assert_equal topic, Topic.find_by(last_read: time_value)
  end

  def test_date_with_string_value
    string_value = "2016-05-11 19:00:00"
    topic = Topic.create(last_read: string_value)
    assert_equal topic, Topic.find_by(last_read: string_value)
  end

  def test_assign_valid_dates
    valid_dates = [[2007, 11, 30], [1993, 2, 28], [2008, 2, 29]]

    invalid_dates = [[2007, 11, 31], [1993, 2, 29], [2007, 2, 29]]

    valid_dates.each do |date_src|
      topic = Topic.new("last_read(1i)" => date_src[0].to_s, "last_read(2i)" => date_src[1].to_s, "last_read(3i)" => date_src[2].to_s)
      # Oracle DATE columns are datetime columns and Oracle adapter returns Time value
      if current_adapter?(:OracleAdapter)
        assert_equal(topic.last_read.to_date, Date.new(*date_src))
      else
        assert_equal(topic.last_read, Date.new(*date_src))
      end
    end

    invalid_dates.each do |date_src|
      assert_nothing_raised do
        topic = Topic.new("last_read(1i)" => date_src[0].to_s, "last_read(2i)" => date_src[1].to_s, "last_read(3i)" => date_src[2].to_s)
        # Oracle DATE columns are datetime columns and Oracle adapter returns Time value
        if current_adapter?(:OracleAdapter)
          assert_equal(topic.last_read.to_date, Time.local(*date_src).to_date, "The date should be modified according to the behavior of the Time object")
        else
          assert_equal(topic.last_read, Time.local(*date_src).to_date, "The date should be modified according to the behavior of the Time object")
        end
      end
    end
  end
end