Sha256: 40ed3553549ce447de7ab7b0d07388db6804902d8faf8a747a04798bd88d9c31
Contents?: true
Size: 1.79 KB
Versions: 26
Compression:
Stored size: 1.79 KB
Contents
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
end
Version data entries
26 entries across 26 versions & 2 rubygems