public void AutoCommit_SetAfterOpen_Test()
{
int tablesCount;
Log("Test SetAutoCommit, GetAutoCommit, AutoCommit");
LogTestStep("Set AutoCommit as false");
using (CUBRIDConnection conn = new CUBRIDConnection())
{
conn.ConnectionString = DBHelper.connString;
conn.Open();
conn.SetAutoCommit(false);
tablesCount = (int)DBHelper.GetSingleValue("select count(*) from db_class", conn);
//Create table
DBHelper.ExecuteSQL("create table xyz(id int)", conn);
//Verify the current AutoCimmit value
Assert.AreEqual(false, conn.GetAutoCommit());
}
using (CUBRIDConnection conn2 = new CUBRIDConnection())
{
conn2.ConnectionString = DBHelper.connString;
conn2.Open();
//Verify table was not created
Assert.AreEqual(tablesCount, (int)DBHelper.GetSingleValue("select count(*) from db_class", conn2));
LogStepPass();
LogTestStep("Set AutoCommit as true");
conn2.SetAutoCommit(true);
//Create table
DBHelper.ExecuteSQL("create table xyz(id int)", conn2);
//Verify the current AutoCimmit value
Assert.AreEqual(true, conn2.GetAutoCommit());
}
using (CUBRIDConnection conn3 = new CUBRIDConnection())
{
conn3.ConnectionString = DBHelper.connString;
conn3.Open();
//Verify table was created
Assert.AreEqual(tablesCount + 1, (int)DBHelper.GetSingleValue("select count(*) from db_class", conn3));
LogStepPass();
LogTestStep("Set AutoCommit as default");
//Leave the AutoCommit as default
DBHelper.ExecuteSQL("drop table if exists xyz", conn3);
Assert.AreEqual(true, conn3.GetAutoCommit());
}
using (CUBRIDConnection conn4 = new CUBRIDConnection())
{
conn4.ConnectionString = DBHelper.connString;
conn4.Open();
//Verify table was deleted
Assert.AreEqual(tablesCount, (int)DBHelper.GetSingleValue("select count(*) from db_class", conn4));
LogStepPass();
}
LogTestResult();
}
private static void Test_GetAutoCommit()
{
try
{
CUBRIDConnection conn = new CUBRIDConnection();
conn.GetAutoCommit();
}
catch (Exception e)
{
Debug.Assert(e.Message == "The connection is not open!");
}
try
{
CUBRIDConnection conn = new CUBRIDConnection();
conn.ConnectionString = connString;
conn.Open();
conn.GetAutoCommit();
conn.Close();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
