/// <summary>
///A test for GetConnectionString
///</summary>
public static void Test_GetConnectionString()
{
string server = "test-db-server";
int port = 33690;
string database = "demodb";
string user = "******";
string password = "";
string encoding = "utf-8";
CUBRIDConnectionStringBuilder target = new CUBRIDConnectionStringBuilder(server, port, database, user, password,
encoding, true);
string expected =
"server=test-db-server;port=33690;database=demodb;user=public;password=;charset=utf-8;autocommit=1";
string actual = string.Empty;
actual = target.GetConnectionString();
Debug.Assert(expected == actual);
Debug.Assert(target.Database == "demodb");
Debug.Assert(target.Encoding == "utf-8");
Debug.Assert(target.Password == "");
Debug.Assert(target.Port == "33690");
Debug.Assert(target.Server == "test-db-server");
Debug.Assert(target.User == "public");
Debug.Assert(target.AutoCommit == "1");
target.Server = "test-db-server";
Debug.Assert(target.Server == "test-db-server");
}
private static void Test_ConnectionInit()
{
CUBRIDConnectionStringBuilder cs =
new CUBRIDConnectionStringBuilder("test-db-server", "demodb", "admin", "123456",
"utf-8", false);
Debug.Assert(cs.Database == "demodb");
Debug.Assert(cs.Port == "33000");
Debug.Assert(cs.AutoCommit == "0"); // wrong!
Debug.Assert(cs.Password == "123456");
Debug.Assert(cs.User == "admin");
Debug.Assert(cs.Server == "test-db-server");
Debug.Assert(cs.Encoding == "utf-8");
}
/// <summary>
///Test CUBRIDConnectionStringBuilder Constructor
///</summary>
public static void Test_CUBRIDConnectionStringBuilderConstructor()
{
string connString = "server=test-db-server;database=demodb;port=33690;user=public;password="******"No connection could be made because the target machine actively refused it 127.0.0.1:33690");
}
}
}
/// <summary>
/// Test ConnectionStringBuilder class
/// </summary>
private static void Test_ConnectionStringBuilder()
{
CUBRIDConnectionStringBuilder sb = new CUBRIDConnectionStringBuilder(ip, 33000, "demodb", "public", "",
"utf-8", false);
//Note: Do not use sb.ConnectionString with empty password
using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))
{
conn.Open();
}
sb = new CUBRIDConnectionStringBuilder(ip, 33000, "demodb", "public", "wrong password", "utf-8", false);
using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))
{
try
{
conn.Open();
}
catch (Exception ex)
{
string r = "Incorrect or missing password.";
Debug.Assert(ex.Message.Substring(0, r.Length) == r);
}
}
sb = new CUBRIDConnectionStringBuilder(TestCases.connString);
using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))
{
conn.Open();
}
sb = new CUBRIDConnectionStringBuilder();
sb.User = "******";
sb.Database = "demodb";
sb.Port = "33000";
sb.Server = ip;
using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))
{
conn.Open();
}
}
