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()); } }