public void TestExecuteCommand() { //arrange bool expect = true; bool actual = false; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); DataAccessCommand command = new DataAccessCommand(); int dataExecutedCount = 0; //act command.SqlCommand = @"UPDATE TABLE SET TIME=SYSDATE WHERE ID BETWEEN :BEGIN_ID AND :END_ID"; command.AddParameter("BEGIN_ID", 1668); command.AddParameter("END_ID", 1670); try { dataExecutedCount = target.ExecuteCommand(command); actual = (dataExecutedCount > 0); } catch (Exception) { throw; } //assert Assert.AreEqual(expect, actual); }
public void TestExecuteCommandException() { //arrange bool expect = true; bool actual = false; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); DataAccessCommand command = new DataAccessCommand(); string errMessage = ""; //act command.SqlCommand = @"UPDATE TABLE SET TIME=SYSDATE WHERE ID BETWEEN :BEGIN_ID AND :END_ID"; command.AddParameter("BEGIN_ID", 1668); try { target.ExecuteCommand(command); } catch (CommandExecutionExeception ex) { errMessage = ex.DetailErrorMessage; actual = (errMessage != ""); } //assert Assert.AreEqual(expect, actual); }