require 'spec_helper'

describe GoogleCells::CellSelector::RowSelector do

  let(:subject) do 
    w = nil
    VCR.use_cassette('google_cells/spreadsheet/cell_selector/worksheet') do
      s = GoogleCells::Spreadsheet.list.first
      w = s.worksheets.first
    end
    GoogleCells::CellSelector::RowSelector.new(w)
  end

  describe "#find_each" do
    
    it "iterates over all the rows" do
      count = 0

      VCR.use_cassette('google_cells/cell_selector/find_each') do
        subject.find_each do |r|
          count += 1
          r.class.should eq GoogleCells::Row
        end
      end
      count.should eq 100
    end

    it "iterates over rows specified in cell selector" do
      count = 0

      VCR.use_cassette('google_cells/cell_selector/find_each/selection') do
        s = GoogleCells::Spreadsheet.list.first
        w = s.worksheets.first
        rs = subject.from(5).to(10)
        rs.find_each do |r|
          count += 1
          r.class.should eq GoogleCells::Row
        end
      end
      count.should eq 6
    end

    context "optional batch sizes" do
      it "fetches in batches 10" do
        batch = 10
        subject.should_receive(:get_cells).exactly(10).times.and_return((1..batch).to_a)
        subject.find_each(batch_size:batch){|r| r}
      end
      it "fetches in batches 3" do
        batch = 3
        subject.should_receive(:get_cells).exactly(34).times.and_return((1..batch).to_a)
        subject.find_each(batch_size:batch){|r| r}
      end
    end
  end

  describe "#each" do

    it "iterates over rows specified in cell selector" do
      count = 0

      VCR.use_cassette('google_cells/cell_selector/each') do
        subject.each do |r|
          count += 1
          r.class.should eq GoogleCells::Row
        end
      end
      count.should eq 100
    end

    it "fetches in a single request" do
      subject.should_receive(:get_cells).and_return((1..subject.worksheet.
        row_count).to_a)
      subject.each{|r| r}
    end
  end

  describe "#from" do
    it "sets its min row" do
      subject.from(5)
      subject.min_row.should eq 5
      subject.from(10)
      subject.min_row.should eq 10
    end

    it "returns itself" do
      subject.from(subject.min_row).should eq subject
    end
  end

  describe "#to" do
    it "sets its max row" do
      subject.to(5)
      subject.max_row.should eq 5
      subject.to(10)
      subject.max_row.should eq 10
    end

    it "returns itself" do
      subject.from(subject.max_row).should eq subject
    end
  end
end