# frozen_string_literal: true

require 'test_helper'

class QueryTest < Minitest::Test
  extend Minitest::Spec::DSL
  before { VCR.insert_cassette name }
  after { VCR.eject_cassette }

  let(:username) { 'wland' }
  let(:password) { 'Piperita2018' }
  let(:company) { 'L' }
  let(:company_password) { '' }
  let(:user_id) do
    Syspro::Logon.logon(username, password, company, company_password)
  end

  def test_query_browse # rubocop:disable Metrics/MethodLength
    skip 'A new VCR cassette needs recorded for this test to pass'
    combrw = Syspro::BusinessObjects::ComBrw.new
    combrw.browse_name = 'InvMaster'
    combrw.start_condition = ''
    combrw.return_rows = 5
    combrw.filters = []
    combrw.table_name = 'InvMaster'
    combrw.title = 'StockCodes'
    combrw.columns = [
      { name: 'StockCode' }
    ]

    browse_result = combrw.call(user_id.guid)

    refute_nil browse_result
  end

  def test_query_query # rubocop:disable Metrics/MethodLength
    comfnd = Syspro::BusinessObjects::ComFnd.new
    comfnd.table_name = 'InvMaster'
    comfnd.return_rows = 5
    comfnd.columns = [
      {
        name: 'StockCode'
      }
    ]
    comfnd.expressions = [
      {
        andor: 'And',
        column: 'StockCode',
        condition: 'EQ',
        value: '02'
      }
    ]
    comfnd.order_by = 'StockCode'

    query_result = comfnd.call(user_id.guid)

    refute_nil query_result
  end

  def test_query_fetch
    comfch = Syspro::BusinessObjects::ComFch.new
    comfch.table_name = 'InvMaster'
    comfch.key = '02'
    comfch.optional_keys = []
    comfch.full_key_provided = false
    comfch.default_type = ''
    comfch.espresso_fetch = true

    fetch_result = comfch.call(user_id.guid)

    refute_nil fetch_result
  end
end