require "spec_helper" 


describe Datagrid::Filters::DynamicFilter do
  let(:report) do
    test_report do
      scope  {Entry}
      filter(:condition, :dynamic)
    end
  end

  it "should support = operation" do
    report.condition = [:name, "=", "hello"]
    report.assets.should include(Entry.create!(:name => 'hello'))
    report.assets.should_not include(Entry.create!(:name => 'bye'))
  end

  it "should support >= operation" do
    report.condition = [:name, ">=", "d"]
    report.assets.should include(Entry.create!(:name => 'x'))
    report.assets.should include(Entry.create!(:name => 'd'))
    report.assets.should_not include(Entry.create!(:name => 'a'))
  end

  it "should blank value" do
    report.condition = [:name, "=", ""]
    report.assets.should include(Entry.create!(:name => 'hello'))
  end

  it "should support =~ operation on strings" do
    report.condition = [:name, "=~", "ell"]
    report.assets.should include(Entry.create!(:name => 'hello'))
    report.assets.should_not include(Entry.create!(:name => 'bye'))
  end

  it "should support =~ operation integers" do
    report.condition = [:group_id, "=~", 2]
    report.assets.should include(Entry.create!(:group_id => 2))
    report.assets.should_not include(Entry.create!(:group_id => 1))
    report.assets.should_not include(Entry.create!(:group_id => 3))
  end

  it "should support >= operation on integer" do
    report.condition = [:group_id, ">=", 2]
    report.assets.should include(Entry.create!(:group_id => 3))
    report.assets.should_not include(Entry.create!(:group_id => 1))
  end

  it "should support <= operation on integer" do
    report.condition = [:group_id, "<=", 2]
    report.assets.should include(Entry.create!(:group_id => 1))
    report.assets.should_not include(Entry.create!(:group_id => 3))
  end

  it "should support <= operation on integer with string value" do
    report.condition = [:group_id, "<=", '2']
    report.assets.should include(Entry.create!(:group_id => 1))
    report.assets.should include(Entry.create!(:group_id => 2))
    report.assets.should_not include(Entry.create!(:group_id => 3))
  end

  it "should nullify incorrect value for integer" do
    report.condition = [:group_id, "<=", 'aa']
    report.condition.should == [:group_id, "<=", nil]
  end

  it "should nullify incorrect value for date" do
    report.condition = [:shipping_date, "<=", 'aa']
    report.condition.should == [:shipping_date, "<=", nil]
  end

  it "should nullify incorrect value for datetime" do
    report.condition = [:created_at, "<=", 'aa']
    report.condition.should == [:created_at, "<=", nil]
  end

  it "should support date comparation operation by timestamp column" do
    report.condition = [:created_at, "<=", '1986-08-05']
    report.condition.should == [:created_at, "<=", Date.parse('1986-08-05')]
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-04 01:01:01')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 23:59:59')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 00:00:00')))
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-06 00:00:00')))
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-06 23:59:59')))
  end

  it "should support date = operation by timestamp column" do
    report.condition = [:created_at, "=", '1986-08-05']
    report.condition.should == [:created_at, "=", Date.parse('1986-08-05')]
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-04 23:59:59')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 23:59:59')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 00:00:01')))
    #TODO: investigate SQLite issue and uncomment this line
    #report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 00:00:00')))
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-06 23:59:59')))
  end

  it "should support date =~ operation by timestamp column" do
    report.condition = [:created_at, "=~", '1986-08-05']
    report.condition.should == [:created_at, "=~", Date.parse('1986-08-05')]
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-04 23:59:59')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 23:59:59')))
    report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 00:00:01')))
    #TODO: investigate SQLite issue and uncomment this line
    #report.assets.should include(Entry.create!(:created_at => DateTime.parse('1986-08-05 00:00:00')))
    report.assets.should_not include(Entry.create!(:created_at => DateTime.parse('1986-08-06 23:59:59')))
  end

  it "should support operations for invalid date" do
    report.condition = [:shipping_date, "<=", '1986-08-05']
    report.assets.should include(Entry.create!(:shipping_date => '1986-08-04'))
    report.assets.should include(Entry.create!(:shipping_date => '1986-08-05'))
    report.assets.should_not include(Entry.create!(:shipping_date => '1986-08-06'))
  end
  it "should support operations for invalid date" do
    report.condition = [:shipping_date, "<=", Date.parse('1986-08-05')]
    report.assets.should include(Entry.create!(:shipping_date => '1986-08-04'))
    report.assets.should include(Entry.create!(:shipping_date => '1986-08-05'))
    report.assets.should_not include(Entry.create!(:shipping_date => '1986-08-06'))
  end

end