describe '#where' do
  before do
    class WhereDocument
      include Yapper::Document

      field :field1, :type => String
      field :field2, :type => Integer
      field :field3, :type => Time

      index :field1, :field2, :field3
    end
    class AnotherWhereDocument
      include Yapper::Document

      field :field1, :type => String
      field :field2

      index :field1
    end
  end
  before { Yapper::DB.instance.purge }
  after { Object.send(:remove_const, 'WhereDocument') }
  after { Object.send(:remove_const, 'AnotherWhereDocument') }

  describe 'with no documents created' do
    it 'returns []' do
      WhereDocument.where(:field1 => 'xxx').should == []
    end
  end

  describe 'when searching with a non indexed field' do
    it 'raises' do
      lambda {
        AnotherWhereDocument.where(:field2 => 'xxx')
      }.should.raise
    end
  end

  describe 'with documents created' do
    before do
      @now = Time.now
      WhereDocument.create(:field1 => 'field1_value', :field2 => 2)
      WhereDocument.create(:field1 => 'field1_value', :field2 => 3)
      WhereDocument.create(:field1 => 'field1_value', :field2 => 4)
      WhereDocument.create(:field1 => 'field1_other_value', :field2 => 2, :field3 => @now)
      AnotherWhereDocument.create(:field1 => 'field1_value', :field2 => 2)
    end

    it 'can search by string' do
      WhereDocument.where(:field1 => 'field1_value').count.should == 3
    end

    it 'can search by integer' do
      WhereDocument.where(:field2 => 2).count.should == 2
    end

    it 'can search by time' do
      WhereDocument.where(:field3 => @now).count.should == 1
    end

    it 'returns [] when looking up a non-existant doc' do
      WhereDocument.where(:field1 => 'xxx').should == []
    end

    it 'can select docments matching on multiple fields' do
      WhereDocument.where(:field1 => 'field1_value', :field2 => 2).count.should == 1
    end

    describe 'when documents are updated' do
      before do
        WhereDocument.where(:field1 => 'field1_value').each { |doc| doc.update_attributes(:field1 => 'field1_value_updated', :field2 => 10) }
      end

      it 'searches by the updated values' do
        WhereDocument.where(:field1 => 'field1_value').count.should == 0
        WhereDocument.where(:field1 => 'field1_value_updated', :field2 => 10).count.should == 3
      end
    end
  end

  describe 'when a document is created without all fields being set' do
    before do
      WhereDocument.create(:field1 => 'field1_value')
    end

    it 'searches by the field' do
      WhereDocument.where(:field1 => 'field1_value').count.should == 1
    end

    describe 'when the document is updated to set a field that was not set before' do
      before do
        WhereDocument.where(:field1 => 'field1_value').first.update_attributes(:field2 => 10)
      end

      it 'searches by the updated field' do
        WhereDocument.where(:field2 => 10).count.should == 1
      end
    end
  end

  describe 'when sorting' do
    describe 'with text field' do
      before do
        WhereDocument.create(:field1 => 'apple')
        WhereDocument.create(:field1 => 'squash')
        WhereDocument.create(:field1 => 'carrot')
      end
      it 'can sort documents ascending' do
        WhereDocument.where({}, :order => { :field1 => :asc }).collect(&:field1).should == ['apple', 'carrot', 'squash']
      end

      it 'can sort documents descending' do
        WhereDocument.where({}, :order => { :field1 => :desc }).collect(&:field1).should == ['squash', 'carrot', 'apple']
      end
    end

    describe 'with date field' do
      before do
        WhereDocument.create(:field3 => Time.utc(2013,1,1,10,00))
        WhereDocument.create(:field3 => Time.utc(2013,1,1,9,00))
        WhereDocument.create(:field3 => Time.utc(2013,1,1,14,00))
      end
      it 'can sort documents ascending' do
        WhereDocument.where({}, :order => { :field3 => :asc }).collect(&:field3).should == [Time.utc(2013,1,1,9,00), Time.utc(2013,1,1,10,00), Time.utc(2013,1,1,14,00)]
      end

      it 'can sort documents descending' do
        WhereDocument.where({}, :order => { :field3 => :desc }).collect(&:field3).should == [Time.utc(2013,1,1,14,00), Time.utc(2013,1,1,10,00), Time.utc(2013,1,1,9,00)]
      end
    end
  end
end