public void GetOraConnectionTest() { var target = new OracleAccess(); OracleConnection expected ; using (expected = new OracleConnection(_oradb)) { expected.Open(); } OracleConnection actual; actual = target.GetOraConnection(); Assert.AreEqual(expected.InstanceName, actual.InstanceName); //Assert.Inconclusive("Verify the correctness of this test method."); }
public void Datasettest() { var target = new OracleAccess(); var themaNew = new BeheerContextEntity { DataKeyValue = "aaaDwight" + DateTime.Now, Tablename = "thema", DataKeyName = "themanaam" }; string qry = @"select id, {0} from {1} where {0} = '{2}'"; qry = string.Format(CultureInfo.InvariantCulture, qry, themaNew.DataKeyName, themaNew.Tablename, themaNew.DataKeyValue); int rowsAffected = target.Insert(themaNew); var ds = target.GetDaBusinessObject(qry,themaNew); }
public void DeleteThemasTest() { var target = new OracleAccess(); var thema = new BeheerContextEntity { DataKeyValue = "aaaDwight" + DateTime.Now, Tablename = "thema", DataKeyName = "themanaam" }; Assert.IsTrue(target.Insert(thema) > 0); int rowsAffected = target.Delete(thema); Assert.IsTrue(rowsAffected == 1); var expected = target.GetBusinessObject(thema.Tablename, thema.DataKeyName, thema.DataKeyValue) as BeheerContextEntity; Assert.AreEqual(expected, null); }
public void UpdateThemasTest() { var target = new OracleAccess(); string nu = DateTime.Now.ToString(); var themaOld = new BeheerContextEntity { DataKeyValue = "aaP" + nu, Tablename = "thema", DataKeyName = "themanaam" }; target.Insert(themaOld); var themaNew= new BeheerContextEntity { DataKeyValue = "aapje" + nu, Tablename = "thema", DataKeyName = "themanaam" }; int rowsAffected = target.Update(themaOld,themaNew); Assert.AreEqual(1,rowsAffected ); var expected = target.GetBusinessObject(themaNew.Tablename, themaNew.DataKeyName, themaNew.DataKeyValue) as BeheerContextEntity; // ReSharper disable PossibleNullReferenceException Assert.AreEqual(expected.DataKeyValue, themaNew.DataKeyValue); // ReSharper restore PossibleNullReferenceException Assert.AreEqual(expected.Tablename, themaNew.Tablename); Assert.AreEqual(expected.DataKeyName, themaNew.DataKeyName); }
public void InsertThemasTest() { var target = new OracleAccess(); var themaNew = new BeheerContextEntity { DataKeyValue = "aaaDwight" + DateTime.Now, Tablename = "thema", DataKeyName = "themanaam" }; int rowsAffected = target.Insert(themaNew); var expected = target.GetBusinessObject(themaNew.Tablename, themaNew.DataKeyName, themaNew.DataKeyValue) as BeheerContextEntity; Assert.IsTrue(rowsAffected == 1); // ReSharper disable PossibleNullReferenceException Assert.AreEqual(expected.DataKeyValue, themaNew.DataKeyValue); // ReSharper restore PossibleNullReferenceException Assert.AreEqual(expected.Tablename, themaNew.Tablename); Assert.AreEqual(expected.DataKeyName, themaNew.DataKeyName); }
public void GetThemasTest() { var target = new OracleAccess(); bool actual; actual = target.SetOraConnection(); Assert.AreEqual(true, actual); IList<BeheerContextEntity> list = target.GetBusinessObjects("thema", "themanaam"); Assert.IsTrue(list.Count>0); }