-
Notifications
You must be signed in to change notification settings - Fork 874
Expand file tree
/
Copy pathConnectionStringBuilderTests.cs
More file actions
121 lines (109 loc) · 3.98 KB
/
ConnectionStringBuilderTests.cs
File metadata and controls
121 lines (109 loc) · 3.98 KB
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
using System;
using NUnit.Framework;
namespace Npgsql.Tests;
class ConnectionStringBuilderTests
{
[Test]
public void Basic()
{
var builder = new NpgsqlConnectionStringBuilder();
Assert.That(builder.Count, Is.EqualTo(0));
Assert.That(builder.ContainsKey("server"), Is.True);
builder.Host = "myhost";
Assert.That(builder["host"], Is.EqualTo("myhost"));
Assert.That(builder.Count, Is.EqualTo(1));
Assert.That(builder.ConnectionString, Is.EqualTo("Host=myhost"));
builder.Remove("HOST");
Assert.That(builder["host"], Is.EqualTo(""));
Assert.That(builder.Count, Is.EqualTo(0));
}
[Test]
public void TryGetValue()
{
var builder = new NpgsqlConnectionStringBuilder();
builder.ConnectionString = "Host=myhost";
Assert.That(builder.TryGetValue("Host", out var value), Is.True);
Assert.That(value, Is.EqualTo("myhost"));
Assert.That(builder.TryGetValue("SomethingUnknown", out value), Is.False);
}
[Test]
public void Remove()
{
var builder = new NpgsqlConnectionStringBuilder();
builder.SslMode = SslMode.Require;
Assert.That(builder["SSL Mode"], Is.EqualTo(SslMode.Require));
builder.Remove("SSL Mode");
Assert.That(builder.ConnectionString, Is.EqualTo(""));
builder.CommandTimeout = 120;
Assert.That(builder["Command Timeout"], Is.EqualTo(120));
builder.Remove("Command Timeout");
Assert.That(builder.ConnectionString, Is.EqualTo(""));
}
[Test]
public void Clear()
{
var builder = new NpgsqlConnectionStringBuilder { Host = "myhost" };
builder.Clear();
Assert.That(builder.Count, Is.EqualTo(0));
Assert.That(builder["host"], Is.EqualTo(""));
Assert.That(builder.Host, Is.Null);
}
[Test]
public void Removing_resets_to_default()
{
var builder = new NpgsqlConnectionStringBuilder();
Assert.That(builder.Port, Is.EqualTo(NpgsqlConnection.DefaultPort));
builder.Port = 8;
builder.Remove("Port");
Assert.That(builder.Port, Is.EqualTo(NpgsqlConnection.DefaultPort));
}
[Test]
public void Setting_to_null_resets_to_default()
{
var builder = new NpgsqlConnectionStringBuilder();
Assert.That(builder.Port, Is.EqualTo(NpgsqlConnection.DefaultPort));
builder.Port = 8;
builder["Port"] = null;
Assert.That(builder.Port, Is.EqualTo(NpgsqlConnection.DefaultPort));
}
[Test]
public void Enum()
{
var builder = new NpgsqlConnectionStringBuilder();
builder.ConnectionString = "SslMode=Require";
Assert.That(builder.SslMode, Is.EqualTo(SslMode.Require));
Assert.That(builder.Count, Is.EqualTo(1));
}
[Test]
public void Enum_insensitive()
{
var builder = new NpgsqlConnectionStringBuilder();
builder.ConnectionString = "SslMode=require";
Assert.That(builder.SslMode, Is.EqualTo(SslMode.Require));
Assert.That(builder.Count, Is.EqualTo(1));
}
[Test]
public void Clone()
{
var builder = new NpgsqlConnectionStringBuilder();
builder.Host = "myhost";
var builder2 = builder.Clone();
Assert.That(builder2.Host, Is.EqualTo("myhost"));
Assert.That(builder2["Host"], Is.EqualTo("myhost"));
Assert.That(builder.Port, Is.EqualTo(NpgsqlConnection.DefaultPort));
}
[Test]
public void Conversion_error_throws()
{
var builder = new NpgsqlConnectionStringBuilder();
Assert.That(() => builder["Port"] = "hello",
Throws.Exception.TypeOf<ArgumentException>().With.Message.Contains("Port"));
}
[Test]
public void Invalid_connection_string_throws()
{
var builder = new NpgsqlConnectionStringBuilder();
Assert.That(() => builder.ConnectionString = "Server=127.0.0.1;User Id=npgsql_tests;Pooling:false",
Throws.Exception.TypeOf<ArgumentException>());
}
}