# frozen_string_literal: true

require "cases/helper_sqlserver"

class ExecuteProcedureTestSQLServer < ActiveRecord::TestCase
  it "execute a simple procedure" do
    tables = ActiveRecord::Base.execute_procedure :sp_tables
    assert_instance_of Array, tables
    assert tables.first.respond_to?(:keys)
  end

  it "take parameter arguments" do
    tables = ActiveRecord::Base.execute_procedure :sp_tables, "sst_datatypes"
    table_info = tables.first
    assert_equal 1, tables.size
    assert_equal (ENV["ARUNIT_DB_NAME"] || "activerecord_unittest"), table_info["TABLE_QUALIFIER"], "Table Info: #{table_info.inspect}"
    assert_equal "TABLE", table_info["TABLE_TYPE"], "Table Info: #{table_info.inspect}"
  end

  it "allow multiple result sets to be returned" do
    results1, results2 = ActiveRecord::Base.execute_procedure("sp_helpconstraint", "accounts")
    assert_instance_of Array, results1
    assert results1.first.respond_to?(:keys)
    assert results1.first["Object Name"]
    assert_instance_of Array, results2
    assert results2.first.respond_to?(:keys)
    assert results2.first["constraint_name"]
    assert results2.first["constraint_type"]
  end

  it "take named parameter arguments" do
    tables = ActiveRecord::Base.execute_procedure :sp_tables, table_name: "tables", table_owner: "sys"
    table_info = tables.first
    assert_equal 1, tables.size
    assert_equal (ENV["ARUNIT_DB_NAME"] || "activerecord_unittest"), table_info["TABLE_QUALIFIER"], "Table Info: #{table_info.inspect}"
    assert_equal "VIEW", table_info["TABLE_TYPE"], "Table Info: #{table_info.inspect}"
  end

  it "uses the proper timezone" do
    date_proc = connection.execute_procedure("my_getutcdate").first["utcdate"]
    date_base = connection.select_value("select GETUTCDATE()")
    assert_equal date_base.change(usec: 0), date_proc.change(usec: 0)
  end

  def transaction_with_procedure_and_return
    ActiveRecord::Base.transaction do
      connection.execute_procedure("my_getutcdate")
      return
    end
  end

  it 'test deprecation with transaction return when executing procedure' do
    assert_not_deprecated(ActiveRecord.deprecator) do
      transaction_with_procedure_and_return
    end
  end
end