Sha256: 1fc70e8a4d1bed20e7a87adb5d0dc15aee425e47c99f9fe73d5d109289fb89dd
Contents?: true
Size: 1.16 KB
Versions: 12
Compression:
Stored size: 1.16 KB
Contents
require 'cases/sqlserver_helper'
class ExecuteProcedureTestSqlserver < ActiveRecord::TestCase
def setup
@klass = ActiveRecord::Base
end
should 'execute a simple procedure' do
tables = @klass.execute_procedure :sp_tables
assert_instance_of Array, tables
assert tables.first.respond_to?(:keys)
end
should 'take parameter arguments' do
tables = @klass.execute_procedure :sp_tables, 'sql_server_chronics'
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
should 'allow multiple result sets to be returned' do
results1, results2 = @klass.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
end
Version data entries
12 entries across 12 versions & 1 rubygems