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 TestQueryDataTableWithParameter()
{
//arrange
bool expect = true;
bool actual = true;
IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString);
DataTable result;
DataAccessCommand command = new DataAccessCommand();
//act
command.SqlCommand = @"
SELECT *
FROM TABLE
WHERE ID=:ROOM_ID";
command.AddParameter("ROOM_ID", 150376);
result = target.QueryWithDataTable(command);
actual = (result != null);
//assert
Assert.AreEqual(expect, actual);
}
public void TestQueryDataTableException()
{
//arrange
bool expect = true;
bool actual = true;
IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString);
DataTable result;
DataAccessCommand command = new DataAccessCommand();
string errMessage = "";
//act
command.SqlCommand =
@"SELECT *
FROM TABLE
WHERE COLUMNNAME=:ROOM_ID";
command.AddParameter("ggdg", "fdsfsd");
command.AddParameter("efe", "434");
command.AddParameter("fe23", "fdr3sfsd");
try
{
result = target.QueryWithDataTable(command);
}
catch (CommandExecutionExeception ex)
{
errMessage = ex.DetailErrorMessage;
actual = (errMessage != "");
}
//assert
Assert.AreEqual(expect, actual);
}
public void TestQueryDataReaderWithParameter()
{
//arrange
bool expect = true;
bool actual = true;
IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString);
IDataReader result;
DataAccessCommand command = new DataAccessCommand();
List<Chatroom> roomCollection;
//act
command.SqlCommand = @"
SELECT *
FROM TABLE
WHERE COLUMNNAME=:ID";
command.AddParameter("ID", 150376);
try
{
result = target.QueryWithDataReader(command);
roomCollection = new List<Chatroom>();
while (result.Read())
{
roomCollection.Add(
new Chatroom(
result.GetInt32(result.GetOrdinal("ID")),
result.GetDateTime(result.GetOrdinal("ACTDATE")),
result.GetString(result.GetOrdinal("FLICODE")),
result.GetString(result.GetOrdinal("DPORT")))
);
}
actual = (roomCollection.Count > 0);
}
catch (Exception)
{
throw;
}
finally
{
target.CloseConnection();
}
//assert
Assert.AreEqual(expect, actual);
}
public void TestQueryDatareaderException()
{
bool expect = true;
bool actual = true;
IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString);
IDataReader result;
DataAccessCommand command = new DataAccessCommand();
List<Chatroom> roomCollection;
string errMessage = "";
//act
command.SqlCommand = @"
SELECT *
FROM TABLE
WHERE ID=:ROOM_ID";
command.AddParameter("ROOM_ID", 150376);
try
{
result = target.QueryWithDataReader(command);
roomCollection = new List<Chatroom>();
while (result.Read())
{
roomCollection.Add(
new Chatroom(
result.GetInt32(result.GetOrdinal("ROOM_ID")),
result.GetDateTime(result.GetOrdinal("ACTDATE")),
result.GetString(result.GetOrdinal("FLICODE")),
result.GetString(result.GetOrdinal("DPORT")))
);
}
}
catch (CommandExecutionExeception ex)
{
errMessage = ex.DetailErrorMessage;
actual = (errMessage != "");
}
finally
{
target.CloseConnection();
}
//assert
Assert.AreEqual(expect, actual);
}
public void TestExecuteTransactionException()
{
//arrange
bool expect = true;
bool actual = false;
IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString);
List<DataAccessCommand> commandCollection = new List<DataAccessCommand>();
DataAccessCommand command;
int dataExecutedCount = 0;
string errMessage = "";
//act
command = new DataAccessCommand();
command.SqlCommand =
@"UPDATE TABLENAME
SET TIME=SYSDATE
WHERE ID TWEEN :BEGIN_ID AND :END_ID";
command.AddParameter("BEGIN_ID", 1668);
command.AddParameter("END_ID", 1670);
commandCollection.Add(command);
command = new DataAccessCommand();
command.SqlCommand =
@"UPDATE TABLENAME
SET TIME=SYSDATE
WHERE ID TWEEN :BEGIN_ID AND :END_ID";
command.AddParameter("BEGIN_ID", 1660);
command.AddParameter("END_ID", 1665);
commandCollection.Add(command);
try
{
dataExecutedCount = target.ExecuteTransaction(commandCollection);
}
catch (CommandExecutionExeception ex)
{
errMessage = ex.DetailErrorMessage;
actual = (errMessage != "");
}
//assert
Assert.AreEqual(expect, actual);
}