public void Test_IsolationLevel_MySQL()
{
//---------------Execute Test ----------------------
DatabaseConnection conn =
new DatabaseConnectionMySql("MySql.Data", "MySql.Data.MySqlClient.MySqlConnection");
//---------------Test Result -----------------------
Assert.AreEqual(IsolationLevel.RepeatableRead, conn.IsolationLevel);
}
public void Test_CreateDatabaseConnection_MySQL()
{
DatabaseConnection conn = new DatabaseConnectionMySql
("MySql.Data", "MySql.Data.MySqlClient.MySqlConnection");
conn.ConnectionString =
new DatabaseConfig(DatabaseConfig.MySql, "test", "test", "test", "test", "1000").GetConnectionString();
Assert.AreEqual
("MySql.Data.MySqlClient", conn.TestConnection.GetType().Namespace,
"Namespace of mysqlconnection is wrong.");
}
public void TestCreateParameterNameGenerator()
{
//---------------Set up test pack-------------------
IDatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "");
//---------------Assert PreConditions---------------
//---------------Execute Test ----------------------
IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator();
//---------------Test Result -----------------------
Assert.AreEqual("?", generator.PrefixCharacter);
//---------------Tear Down -------------------------
}
public void TestCreateParameterNameGenerator()
{
//---------------Set up test pack-------------------
IDatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "");
//---------------Assert PreConditions---------------
//---------------Execute Test ----------------------
IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator();
//---------------Test Result -----------------------
Assert.IsNotNull(generator);
Assert.AreEqual("?Param0", generator.GetNextParameterName());
//---------------Tear Down -------------------------
}
public void Test_CreateCustomConnectionString()
{
//---------------Set up test pack-------------------
string connectString = "";
DatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "", connectString);
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
string setConnectionString = databaseConnection.ConnectionString;
//---------------Test Result -----------------------
Assert.AreEqual(setConnectionString, connectString);
}
public void TestSqlFormatter()
{
//---------------Set up test pack-------------------
DatabaseConnection databaseConnection = new DatabaseConnectionMySql("", "");
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
ISqlFormatter defaultSqlFormatter = databaseConnection.SqlFormatter;
//---------------Test Result -----------------------
Assert.IsInstanceOf(typeof(SqlFormatter), defaultSqlFormatter);
SqlFormatter formatter = (SqlFormatter)defaultSqlFormatter;
Assert.AreEqual("`", formatter.LeftFieldDelimiter);
Assert.AreEqual("`", formatter.RightFieldDelimiter);
Assert.AreEqual("", formatter.LimitClauseAtBeginning);
Assert.AreEqual("LIMIT", formatter.LimitClauseAtEnd);
}