public void TestConnect() { //arrange bool expect = true; bool actual = true; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); //act target.OpenConnection(); target.CloseConnection(); //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); }