require "esv"

RSpec.describe ESV, ".generate and .parse" do
  it "works" do
    data = ESV.generate do |esv|
      esv << [ "Dogs", "Cats" ]
      esv << [ 1, 2 ]
    end

    output = ESV.parse(data)

    expect(output).to eq [
      [ "Dogs", "Cats" ],
      [ 1, 2 ],
    ]
  end
end

RSpec.describe ESV, ".parse" do
  it "raises if there's more than one worksheet" do
    excel_file_with_two_worksheets = generate_excel_file do |sheet, book|
      book.create_worksheet
    end

    expect {
      ESV.parse(excel_file_with_two_worksheets)
    }.to raise_error(/Expected 1 worksheet, found 2/)
  end

  it "ignores formatting, always returning a plain array of data" do
    excel_file_with_formatting = generate_excel_file do |sheet|
      sheet.row(0).replace([ 1, 2 ])
      sheet.row(0).default_format = Spreadsheet::Format.new(color: :blue)
    end

    output = ESV.parse(excel_file_with_formatting)

    expect(output).to eq [
      [ 1, 2 ],
    ]

    expect(output[0].class).to eq Array
  end

  it "returns the last value of a formula cell" do
    excel_file_with_formula = generate_excel_file do |sheet|
      formula = Spreadsheet::Formula.new
      formula.value = "two"
      sheet.row(0).replace([ "one", formula ])
    end

    output = ESV.parse(excel_file_with_formula)

    expect(output).to eq [
      [ "one", "two" ],
    ]
    expect(output[0].class).to eq Array
  end


  it "returns the URL of a link cell" do
    excel_file_with_link = generate_excel_file do |sheet|
      link = Spreadsheet::Link.new("https://example.com", "desc", "foo")
      sheet.row(0).replace([ "one", link ])
    end
    output = ESV.parse(excel_file_with_link)
    expect(output).to eq [
      [ "one", "https://example.com#foo" ],
    ]

    expect(output[0][1].class).to eq String
  end

  private

  def generate_excel_file(&block)
    book = Spreadsheet::Workbook.new
    sheet = book.create_worksheet

    block.call(sheet, book)

    data = ""
    fake_file = StringIO.new(data)
    book.write(fake_file)
    data
  end
end

RSpec.describe ESV, ".generate_file and .parse_file" do
  before do
    @file = Tempfile.new("esv")
  end

  it "works" do
    path = @file.path

    ESV.generate_file(path) do |esv|
      esv << [ "Dogs", "Cats" ]
      esv << [ 1, 2 ]
    end

    output = ESV.parse_file(path)

    expect(output).to eq [
      [ "Dogs", "Cats" ],
      [ 1, 2 ],
    ]
  end

  after do
    @file.close
    @file.unlink
  end
end