private List <string> EmitDynamicToDataTableToListOfStringsVanillaTest(DataTable dataTable) { List <string> dataoutput = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable(dataTable, null, null, null, null)) { dataoutput.Add(String.Format("Name = '{0}', Address = '{1}', City = '{2}'", output.Name, output.Address, output.City)); } return(dataoutput); }
public void TestingHelper(DataTable dataTable) { // Tests the Row Index Inclusion filtering List <string> TestOutputForInclusionByIndex = new List <string>(); TestLog.WriteLine("Including rows with index 2 and 3:\n"); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable(dataTable, new int[] { 2, 3 }, null, null, null)) { TestOutputForInclusionByIndex.Add(output.Name); } Assert.AreElementsEqual(new[] { "John Smith", "Patricia Doe" }, TestOutputForInclusionByIndex); // Tests the Row Index Exclusion filtering List <string> TestOutputForExclusionByIndex = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable(dataTable, null, new int[] { 2, 3 }, null, null)) { TestOutputForExclusionByIndex.Add(output.Name); } Assert.AreElementsEqual(new[] { "Allen Watts" }, TestOutputForExclusionByIndex); // Tests the Inclusion By Value filtering List <string> TestOutputForInclusionByValue = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable( dataTable, null, null, new string[] { "John Smith", "Allen Watts" }, null)) { TestOutputForInclusionByValue.Add(output.Name); } Assert.AreElementsEqual(new[] { "John Smith", "Patricia Doe" }, TestOutputForInclusionByIndex); // Tests the Exclusion By Value filtering List <string> TestOutputForExclusionByValue = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable( dataTable, null, null, null, new string[] { "John Smith", "Allen Watts" })) { TestOutputForExclusionByValue.Add(output.Name); } Assert.AreElementsEqual(new[] { "Patricia Doe" }, TestOutputForExclusionByValue); }
public void LoadCsvFileWithQuotes() { DataTable dataTable = FlatFileToDataTableBuilder.BuildFromCsvFile(@"..\Framework\Data\DataObjects\TestFileWithQuotes.csv"); List <string> dataoutput = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable(dataTable, null, null, null, null)) { dataoutput.Add(String.Format("UserName = '******', Column_With_Quotes_1 = '{1}'", output.UserName, output.Column_With_Quotes_1)); } Assert.AreElementsEqual(new [] { "UserName = '******', Column_With_Quotes_1 = '\"This is some test data's stuff\"'", "UserName = '******', Column_With_Quotes_1 = '\"The stuff\"'", "UserName = '******', Column_With_Quotes_1 = 'More test data \" \" \" ' ' ' \"'" }, dataoutput); }
public void LoadCsvFileWithCommas() { DataTable dataTable = FlatFileToDataTableBuilder.BuildFromCsvFile(@"..\Framework\Data\DataObjects\TestFileWithCommas.csv"); List <string> dataoutput = new List <string>(); foreach (dynamic output in TabularDataObjectFactory.EmitDynamicObjectFromDataTable(dataTable, null, null, null, null)) { dataoutput.Add(String.Format("Plenty_of_Commas_Just_For_You = '{0}', UserName = '******'", output.Plenty_of_Commas_Just_For_You, output.UserName)); } Assert.AreElementsEqual(new[] { "Plenty_of_Commas_Just_For_You = 'This,is,too,many,commas,man!', UserName = '******'", "Plenty_of_Commas_Just_For_You = 'This,is,too,many,commas,man!', UserName = '******'", "Plenty_of_Commas_Just_For_You = 'More commas,,,,,,,,,,,,,,,,,,,,,,,', UserName = '******'" }, dataoutput); }