1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
# frozen_string_literal: true
require "cases/helper"
module ActiveRecord
module ConnectionAdapters
class PoolConfig
class ResolverTest < ActiveRecord::TestCase
def resolve_db_config(pool_config, config = {})
configs = ActiveRecord::DatabaseConfigurations.new(config)
configs.resolve(pool_config)
end
def test_url_invalid_adapter
error = assert_raises(AdapterNotFound) do
Base.connection_handler.establish_connection "ridiculous://foo?encoding=utf8"
end
assert_match "Database configuration specifies nonexistent 'ridiculous' adapter. Available adapters are: abstract, fake, mysql2, postgresql, sqlite3, trilogy. Ensure that the adapter is spelled correctly in config/database.yml and that you've added the necessary adapter gem to your Gemfile if it's not in the list of available adapters.", error.message
end
# The abstract adapter is used simply to bypass the bit of code that
# checks that the adapter file can be required in.
def test_url_from_environment
pool_config = resolve_db_config :production, "production" => "abstract://foo?encoding=utf8"
assert_equal({
adapter: "abstract",
host: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_url_sub_key
pool_config = resolve_db_config :production, "production" => { "url" => "abstract://foo?encoding=utf8" }
assert_equal({
adapter: "abstract",
host: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_url_sub_key_merges_correctly
hash = { "url" => "abstract://foo?encoding=utf8&", "adapter" => "sqlite3", "host" => "bar", "pool" => "3" }
pool_config = resolve_db_config :production, "production" => hash
assert_equal({
adapter: "abstract",
host: "foo",
encoding: "utf8",
pool: "3"
}, pool_config.configuration_hash)
end
def test_url_sub_key_merges_correctly_when_query_param
hash = { "url" => "abstract:///?user=user&password=passwd&dbname=app" }
pool_config = resolve_db_config :production, "production" => hash
assert_equal({
adapter: "abstract",
user: "user",
password: "passwd",
dbname: "app"
}, pool_config.configuration_hash)
end
def test_url_host_no_db
pool_config = resolve_db_config "abstract://foo?encoding=utf8"
assert_equal({
adapter: "abstract",
host: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_url_missing_scheme
assert_raises ActiveRecord::DatabaseConfigurations::InvalidConfigurationError do
resolve_db_config "foo"
end
end
def test_url_host_db
pool_config = resolve_db_config "abstract://foo/bar?encoding=utf8"
assert_equal({
adapter: "abstract",
database: "bar",
host: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_url_port
pool_config = resolve_db_config "abstract://foo:123?encoding=utf8"
assert_equal({
adapter: "abstract",
port: 123,
host: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_encoded_password
password = "am@z1ng_p@ssw0rd#!"
encoded_password = URI.encode_www_form_component(password)
pool_config = resolve_db_config "abstract://foo:#{encoded_password}@localhost/bar"
assert_equal password, pool_config.configuration_hash[:password]
end
def test_url_with_authority_for_sqlite3
pool_config = resolve_db_config "sqlite3:///foo_test"
assert_equal("/foo_test", pool_config.database)
end
def test_url_absolute_path_for_sqlite3
pool_config = resolve_db_config "sqlite3:/foo_test"
assert_equal("/foo_test", pool_config.database)
end
def test_url_relative_path_for_sqlite3
pool_config = resolve_db_config "sqlite3:foo_test"
assert_equal("foo_test", pool_config.database)
end
def test_url_memory_db_for_sqlite3
pool_config = resolve_db_config "sqlite3::memory:"
assert_equal(":memory:", pool_config.database)
end
def test_url_sub_key_for_sqlite3
pool_config = resolve_db_config :production, "production" => { "url" => "sqlite3:foo?encoding=utf8" }
assert_equal({
adapter: "sqlite3",
database: "foo",
encoding: "utf8"
}, pool_config.configuration_hash)
end
def test_pool_config_with_invalid_type
assert_raises TypeError do
Base.connection_handler.establish_connection(Object.new)
end
end
end
end
end
end
|
