require File.dirname(__FILE__) + '/../../spec_helper.rb'

if ActiveRecord::Base.instance_methods.include?('changed?')

  describe "OracleEnhancedAdapter dirty object tracking" do

    before(:all) do
      ActiveRecord::Base.establish_connection(CONNECTION_PARAMS)
      @conn = ActiveRecord::Base.connection
      @conn.execute <<-SQL
        CREATE TABLE test_employees (
          id            NUMBER,
          first_name    VARCHAR2(20),
          last_name     VARCHAR2(25),
          job_id        NUMBER(6,0) NULL,
          salary        NUMBER(8,2),
          comments      CLOB,
          hire_date     DATE
        )
      SQL
      @conn.execute <<-SQL
        CREATE SEQUENCE test_employees_seq  MINVALUE 1
          INCREMENT BY 1 CACHE 20 NOORDER NOCYCLE
      SQL
      class TestEmployee < ActiveRecord::Base
      end
    end
  
    after(:all) do
      Object.send(:remove_const, "TestEmployee")
      @conn.execute "DROP TABLE test_employees"
      @conn.execute "DROP SEQUENCE test_employees_seq"
    end  

    it "should not mark empty string (stored as NULL) as changed when reassigning it" do
      @employee = TestEmployee.create!(:first_name => '')
      @employee.first_name = ''
      @employee.should_not be_changed
      @employee.reload
      @employee.first_name = ''
      @employee.should_not be_changed
    end

    it "should not mark empty integer (stored as NULL) as changed when reassigning it" do
      @employee = TestEmployee.create!(:job_id => '')
      @employee.job_id = ''
      @employee.should_not be_changed
      @employee.reload
      @employee.job_id = ''
      @employee.should_not be_changed
    end

    it "should not mark empty decimal (stored as NULL) as changed when reassigning it" do
      @employee = TestEmployee.create!(:salary => '')
      @employee.salary = ''
      @employee.should_not be_changed
      @employee.reload
      @employee.salary = ''
      @employee.should_not be_changed
    end

    it "should not mark empty text (stored as NULL) as changed when reassigning it" do
      @employee = TestEmployee.create!(:comments => '')
      @employee.comments = ''
      @employee.should_not be_changed
      @employee.reload
      @employee.comments = ''
      @employee.should_not be_changed
    end

    it "should not mark empty date (stored as NULL) as changed when reassigning it" do
      @employee = TestEmployee.create!(:hire_date => '')
      @employee.hire_date = ''
      @employee.should_not be_changed
      @employee.reload
      @employee.hire_date = ''
      @employee.should_not be_changed
    end

    it "should not mark integer as changed when reassigning it" do
      @employee = TestEmployee.new
      @employee.job_id = 0
      @employee.save!.should be_true
      
      @employee.should_not be_changed

      @employee.job_id = '0'
      @employee.should_not be_changed
    end

  end

end