public void PqsqlConnectionStringBuilderTest1() { PqsqlConnectionStringBuilder builder = new PqsqlConnectionStringBuilder(connectionString); builder[PqsqlConnectionStringBuilder.keepalives] = "1"; builder[PqsqlConnectionStringBuilder.keepalives_idle] = "23"; builder[PqsqlConnectionStringBuilder.keepalives_count] = "3"; builder[PqsqlConnectionStringBuilder.keepalives_interval] = "3"; string dataSource; using (PqsqlConnection connection = new PqsqlConnection(builder)) { // closed connection with service file should give us empty data source Assert.IsTrue(string.IsNullOrEmpty(connection.DataSource)); using (PqsqlCommand cmd = new PqsqlCommand("show all", connection)) using (PqsqlDataReader r = cmd.ExecuteReader()) { object value; if (builder.TryGetValue(PqsqlConnectionStringBuilder.host, out value)) { Assert.AreEqual(connection.DataSource, value); dataSource = value.ToString(); } else // no datasource specified { dataSource = connection.DataSource; } cmd.Cancel(); } } builder[PqsqlConnectionStringBuilder.host] = dataSource; using (PqsqlConnection connection = new PqsqlConnection(builder)) using (PqsqlCommand cmd = new PqsqlCommand("show all", connection)) using (PqsqlDataReader r = cmd.ExecuteReader()) { object value; if (builder.TryGetValue(PqsqlConnectionStringBuilder.host, out value)) { Assert.AreEqual(connection.DataSource, value); } else { Assert.Fail("host part is not available"); } cmd.Cancel(); } }
public void PqsqlConnectionStringBuilderTest3() { PqsqlConnectionStringBuilder builder = new PqsqlConnectionStringBuilder(string.Empty); Assert.AreEqual(string.Empty, builder.ConnectionString); Assert.AreEqual(0, builder.Count); using (PqsqlConnection connection = new PqsqlConnection(builder)) { try { connection.Open(); } catch (PqsqlException) { // ignored, depends on server config whether empty connection string is valid } connection.Close(); } }
public void PqsqlConnectionStringBuilderTest2() { PqsqlConnectionStringBuilder builder = new PqsqlConnectionStringBuilder(null); Assert.Fail(); }