dev-npgsql/npgsql: Npgsql is the .NET data provider for PostgreSQL.

test/Npgsql.Tests/ConnectionStringBuilderTests.cs
112 строк4 KB
Shay Rojansky
Clean up connection builder tests
05 дек 2019, 00:31
05 дек 2019, 00:31cca15ab
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 FromString()
        {
            var builder = new NpgsqlConnectionStringBuilder();
            builder.ConnectionString = "Host=myhost;EF Template Database=foo";
            Assert.That(builder.Host, Is.EqualTo("myhost"));
            Assert.That(builder.EntityTemplateDatabase, Is.EqualTo("foo"));
        }

        [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.Prefer;
            Assert.That(builder["SSL Mode"], Is.EqualTo(SslMode.Prefer));
            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 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 Enum()
        {
            var builder = new NpgsqlConnectionStringBuilder();
            builder.ConnectionString = "SslMode=Prefer";
            Assert.That(builder.SslMode, Is.EqualTo(SslMode.Prefer));
            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 ConversionError()
        {
            var builder = new NpgsqlConnectionStringBuilder();
            Assert.That(() => builder["Port"] = "hello",
                Throws.Exception.TypeOf<ArgumentException>().With.Message.Contains("Port"));
        }

        [Test]
        public void InvalidConnectionString()
        {
            var builder = new NpgsqlConnectionStringBuilder();
            Assert.That(() => builder.ConnectionString = "Server=127.0.0.1;User Id=npgsql_tests;Pooling:false",
                Throws.Exception.TypeOf<ArgumentException>());
        }
    }
}