require File.join(File.dirname(__FILE__), 'spec_helper')

describe 'RecordFilter restrictions' do
  before do
    TestModel.extended_models.each { |model| model.last_find = {} }
  end

  it 'should filter for equality' do
    Post.filter do
      with :permalink, 'blog-post'
    end.inspect
    Post.last_find.should == { :conditions => [%q{"posts".permalink = ?}, 'blog-post'] }
  end

  it 'should filter for equality with multiple conditions' do
    Post.filter do
      with :permalink, 'blog-post'
      with :blog_id, 3
    end.inspect
    Post.last_find.should == { :conditions => [%q{("posts".permalink = ?) AND ("posts".blog_id = ?)}, 'blog-post', 3] }
  end

  it 'should filter by comparison operators' do
    [[:greater_than, :gt, '>'], [:less_than, :lt, '<'], 
     [:less_than_or_equal_to, :lte, '<='], [:greater_than_or_equal_to, :gte, '>=']].each do |set|
       Post.filter do
         with(:created_at).send(set[0], Time.parse('2009-01-03 23:02:00'))
       end.inspect
       Post.last_find.should == { :conditions => ["\"posts\".created_at #{set[2]} ?", Time.parse('2009-01-03 23:02:00')] }

       Post.filter do
         with(:created_at).send(set[1], Time.parse('2009-01-03 23:02:00'))
       end.inspect
       Post.last_find.should == { :conditions => ["\"posts\".created_at #{set[2]} ?", Time.parse('2009-01-03 23:02:00')] }
     end
  end

  it 'should filter for in' do
    Post.filter do
      with(:blog_id).in [1, 3, 5]
    end.inspect
    Post.last_find.should == { :conditions => [%q{"posts".blog_id IN (?)}, [1, 3, 5]] }
  end

  it 'should filter for between' do
    time1 = Time.parse('2008-01-03 23:23:00')
    time2 = Time.parse('2008-01-03 23:36:00')
    Post.filter do
      with(:created_at).between time1..time2
    end.inspect
    Post.last_find.should == { :conditions => [%q{"posts".created_at BETWEEN ? AND ?}, time1, time2] }
  end

  it 'should filter for between with two arguments passed' do
    Post.filter do
      with(:id).between(1, 5)
    end.inspect
    Post.last_find.should == { :conditions => [%q("posts".id BETWEEN ? AND ?), 1, 5] }
  end

  it 'should filter for between with an array passed' do
    Post.filter do
      with(:id).between([2, 6])
    end.inspect
    Post.last_find.should == { :conditions => [%q("posts".id BETWEEN ? AND ?), 2, 6] }
  end

  it 'should filter by none_of' do
    Post.filter do
      none_of do
        with(:blog_id, 1)
        with(:permalink, 'eek')
      end
    end.inspect
    Post.last_find.should == { :conditions => [%q{!(("posts".blog_id = ?) OR ("posts".permalink = ?))}, 1, 'eek'] }
  end

  it 'should filter by not_all_of' do
    Post.filter do
      not_all_of do
        with(:blog_id, 1)
        with(:permalink, 'eek')
      end
    end.inspect
    Post.last_find.should == { :conditions => [%q{!(("posts".blog_id = ?) AND ("posts".permalink = ?))}, 1, 'eek'] }
  end

  it 'should filter by disjunction' do
    Post.filter do
      any_of do
        with(:blog_id).equal_to 1
        with(:permalink).equal_to 'my-post'
      end
    end.inspect
    Post.last_find.should == { :conditions => [%q{("posts".blog_id = ?) OR ("posts".permalink = ?)}, 1, 'my-post'] }
  end

  it 'should filter by disjunction composed of conjunction' do
    Post.filter do
      any_of do
        all_of do
          with(:blog_id).equal_to 1
          with(:permalink).equal_to 'my-post'
        end
        with(:permalink).equal_to 'another-post'
      end
    end.inspect

    Post.last_find.should == { :conditions => [%q{(("posts".blog_id = ?) AND ("posts".permalink = ?)) OR ("posts".permalink = ?)},
                                               1, 'my-post', 'another-post'] }
  end

  it 'should filter for nil' do
    [:is_null, :null, :nil].each do |method|
      Post.filter do
        with(:permalink).send(method)
      end.inspect
      Post.last_find.should == { :conditions => [%q("posts".permalink IS NULL)] }
    end
  end

  it 'should support like' do
    Post.filter do
      with(:permalink).like('%piglets%')
    end.inspect
    Post.last_find.should == { :conditions => [%q("posts".permalink LIKE ?), '%piglets%'] }
  end

  it 'should support NOT LIKE' do
    Post.filter do
      with(:permalink).not.like('%ostriches%')
    end.inspect
    Post.last_find.should == { :conditions => [%q("posts".permalink NOT LIKE ?), '%ostriches%'] }
  end

  it 'should provide access to the filter class in the filter' do
    Post.filter do
      with(:permalink).not.equal_to(filter_class.name)
    end.inspect
    Post.last_find.should == { :conditions => [%q("posts".permalink != ?), 'Post'] }
  end
end