public void Test_DW_Delete() { InitSamples(); var before = GetCountOfSamples(); Assert.AreNotEqual(0, before); var dw = GetDataWorker(); var testobject = new SampleClass { ID = 1 }; Assert.AreNotEqual(0, testobject.ID); var result = dw.Delete <SampleClass>(testobject); var after = GetCountOfSamples(); var expectedAfter = before - 1; Assert.IsTrue(result); Assert.AreEqual(expectedAfter, after); Assert.AreNotEqual(0, testobject.ID); }
public void Test_DW_Insert() { InitSamples(); var before = GetCountOfSamples(); Assert.AreNotEqual(0, before); var dw = GetDataWorker(); var testobject = new SampleClass { Name = "Test Object" }; Assert.AreEqual(0, testobject.ID); var result = dw.Insert <SampleClass>(testobject); var after = GetCountOfSamples(); var expectedAfter = before + 1; Assert.IsTrue(result); Assert.AreEqual(expectedAfter, after); Assert.AreNotEqual(0, testobject.ID); }
public void TestSelectFilteredFromDataObject() { var dw = GetDataWorker(); var dwt = new DataWorkerTask(); dwt.CommandText = "select * from samples where id <= @ID"; dwt.CommandType = CommandType.Text; dwt.ReadResults = true; dwt.Mode = DataWorkerMode.DataFields; var dataObject = new SampleClass { ID = 2 }; var result = dw.DoWorkDirect <SampleClass>(dwt, dataObject); Assert.AreNotEqual(0, result.Count); foreach (var item in result) { Assert.IsTrue(item.ID <= 2); } }
public void TestOptionalParamsPopulated() { var dw = GetDataWorker(); var dwt = new DataWorkerTask(); dwt.CommandText = "TestMissingAndNullInput"; dwt.ReadResults = true; dwt.Mode = DataWorkerMode.AllProperties; var obj = new SampleClass { RequiredParam = 42, // required OptionalParam1 = 43, OptionalParam2 = null, }; var result = dw.DoWorkDirect <SampleClass>(dwt, obj); Assert.IsNotNull(result); Assert.AreEqual(1, result.Count); Assert.AreEqual(obj.RequiredParam, result[0].RequiredParamOut); Assert.AreEqual(obj.OptionalParam1, result[0].OptionalParam1Out); Assert.AreEqual(obj.OptionalParam2, result[0].OptionalParam2Out); }
public void Test_DW_Fetch_NoResult() { InitSamples(); var before = GetCountOfSamples(); Assert.AreNotEqual(0, before); var dw = GetDataWorker(); int loadID = -1; var testobject = new SampleClass { ID = loadID }; Assert.AreNotEqual(0, testobject.ID); Assert.IsNullOrEmpty(testobject.Name); var result = dw.Fetch <SampleClass>(testobject); var after = GetCountOfSamples(); var expectedAfter = before; Assert.IsNull(result); Assert.AreEqual(expectedAfter, after); Assert.AreEqual(loadID, testobject.ID); }
public void TestSelectColumnNameRemapping() { var dw = GetDataWorker(); var dwt = new DataWorkerTask(); dwt.CommandText = "ListNotSimple"; dwt.CommandType = CommandType.StoredProcedure; dwt.ReadResults = true; dwt.Mode = DataWorkerMode.DataFields; var msg = "any message"; var dataobject = new SampleClass { SimpleColumnIn = msg }; var result = dw.DoWorkDirect <SampleClass>(dwt, dataobject); Assert.AreNotEqual(0, result.Count); foreach (var item in result) { Assert.IsTrue(item.ID != 0); Assert.IsNotNullOrEmpty(item.Name); Assert.AreEqual(msg, item.SimpleColumnOut); } }
public void Test_DW_Fetch_InferredType() { InitSamples(); var before = GetCountOfSamples(); Assert.AreNotEqual(0, before); var dw = GetDataWorker(); int loadID = 3; var testobject = new SampleClass { ID = loadID }; Assert.AreNotEqual(0, testobject.ID); Assert.IsNullOrEmpty(testobject.Name); var result = dw.Fetch(testobject); var after = GetCountOfSamples(); var expectedAfter = before; var expectedName = "three"; Assert.IsNotNull(result); Assert.AreEqual(expectedAfter, after); Assert.AreEqual(expectedName, result.Name); Assert.AreEqual(loadID, result.ID); }