# encoding: utf-8
require 'simplecov'
# require deps
require 'tmpdir'
require 'fileutils'
require 'minitest/autorun'
require 'shoulda'
require 'timeout'
require 'logger'
require 'date'

# require gem files
require 'roo'
require "minitest/reporters"
Minitest::Reporters.use!([Minitest::Reporters::DefaultReporter.new,
                          Minitest::Reporters::SpecReporter.new]) unless defined? JRUBY_VERSION

TESTDIR = File.join(File.dirname(__FILE__), 'files')

# very simple diff implementation
# output is an empty string if the files are equal
# otherwise differences a printen (not compatible to
# the diff command)
def file_diff(fn1,fn2)
  result = ''
  File.open(fn1) do |f1|
    File.open(fn2) do |f2|
      while f1.eof? == false and f2.eof? == false
        line1 = f1.gets.chomp
        line2 = f2.gets.chomp
        result << "<#{line1}\n>#{line2}\n" if line1 != line2
      end
      if f1.eof? == false
        while f1.eof? == false
          line1 = f1.gets
          result << "<#{line1}\n"
        end
      end
      if f2.eof? == false
        while f2.eof? == false
          line2 = f2.gets
          result << ">#{line2}\n"
        end
      end
    end
  end
  result
end

class File
  def File.delete_if_exist(filename)
    if File.exist?(filename)
      File.delete(filename)
    end
  end
end

def local_server(port)
  raise ArgumentError unless port.to_i > 0
  "http://0.0.0.0:#{port}"
end

def start_local_server(filename, port = nil)
  require "rack"
  content_type = filename.split(".").last
  port ||= TEST_RACK_PORT

  web_server = Proc.new do |env|
    [
      "200",
      { "Content-Type" => content_type },
      [File.read("#{TESTDIR}/#{filename}")]
    ]
  end

  t = Thread.new { Rack::Handler::WEBrick.run web_server, Host: '0.0.0.0', Port: port , Logger: WEBrick::BasicLog.new(nil,1) }
  # give the app a chance to startup
  sleep(0.2)

  yield
ensure
  t.kill
end

ROO_FORMATS = [
  :excelx,
  :excelxm,
  :openoffice,
  :libreoffice
]

# call a block of code for each spreadsheet type
# and yield a reference to the roo object
def with_each_spreadsheet(options)
  if options[:format]
    formats = Array(options[:format])
    invalid_formats = formats - ROO_FORMATS
    unless invalid_formats.empty?
      raise "invalid spreadsheet types: #{invalid_formats.join(', ')}"
    end
  else
    formats = ROO_FORMATS
  end
  formats.each do |format|
    begin
      yield Roo::Spreadsheet.open(File.join(TESTDIR,
        fixture_filename(options[:name], format)))
    rescue => e
      raise e, "#{e.message} for #{format}", e.backtrace unless options[:ignore_errors]
    end
  end
end

def fixture_filename(name, format)
  case format
  when :excelx
    "#{name}.xlsx"
  when :excelxm
    "#{name}.xlsm"
  when :openoffice, :libreoffice
    "#{name}.ods"
  else
    raise ArgumentError, "unexpected format #{format}"
  end
end