Sha256: 6d3833d404a4473b59fe9f6f7a5ae5f046c7907a754199de7592a82fada7f324
Contents?: true
Size: 1.84 KB
Versions: 27
Compression:
Stored size: 1.84 KB
Contents
# frozen_string_literal: true
require "cases/helper_sqlserver"
require "models/reply"
require "models/topic"
class ConnectionTestSQLServer < ActiveRecord::TestCase
self.use_transactional_tests = false
fixtures :topics, :accounts
before do
connection.reconnect!
assert connection.active?
end
it "affect rows" do
topic_data = { 1 => { "content" => "1 updated" }, 2 => { "content" => "2 updated" } }
updated = Topic.update(topic_data.keys, topic_data.values)
assert_equal 2, updated.size
assert_equal "1 updated", Topic.find(1).content
assert_equal "2 updated", Topic.find(2).content
assert_equal 2, Topic.delete([1, 2])
end
it "allow usage of :database connection option to remove setting from dsn" do
assert_equal "activerecord_unittest", connection.current_database
begin
connection.use_database("activerecord_unittest2")
assert_equal "activerecord_unittest2", connection.current_database
ensure
connection.use_database
assert_equal "activerecord_unittest", connection.current_database, "Would default back to connection options"
end
end unless connection_sqlserver_azure?
describe "Connection management" do
it "set spid on connect" do
_(["Fixnum", "Integer"]).must_include connection.spid.class.name
end
it "reset spid on disconnect!" do
connection.disconnect!
assert connection.spid.nil?
end
it "reset raw connection on disconnect!" do
connection.disconnect!
_(connection.instance_variable_get(:@raw_connection)).must_be_nil
end
it "be able to disconnect and reconnect at will" do
disconnect_raw_connection!
assert !connection.active?
connection.reconnect!
assert connection.active?
end
end
private
def disconnect_raw_connection!
connection.raw_connection.close rescue nil
end
end
Version data entries
27 entries across 27 versions & 1 rubygems