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