public void ConvertTableTwoToOneMapping() { var configuration = DataStoreConfiguration.FromColumns("First Name", "Last Name", "Age"); var source = new MemoryDataStore(configuration); source.Write("John", "Doe", "23"); source.Write("Jane", "Doe", "23"); var mappings = new List<Mapping> { new Mapping { DestinationHeader = "Name", SourceHeaders = new List<string> { "First Name", "Last Name" }, Type = "System.String" } }; configuration = DataStoreConfiguration.FromColumns("Name"); var expected = new MemoryDataStore(configuration); expected.Write("JohnDoe"); expected.Write("JaneDoe"); var actual = new MemoryDataStore(configuration); Converter.Convert(source, mappings, actual); TestHelper.AreEqual(expected, actual); }
public void ConvertTableTwoToOneMappingWithFilterPreProcessAndSumCombiner() { var configuration = DataStoreConfiguration.FromColumns("First Name", "Last Name", "Height Inches", "Height Feet"); var source = new MemoryDataStore(configuration); source.Write("John", "Doe", "11", "5"); source.Write("Jane", "Doe", "6", "5"); var mappings = new List<Mapping> { new Mapping { DestinationHeader = "Height In Inches", SourceHeaders = new List<string> { "Height Inches", "Height Feet" }, CombineMethod = CombineMethod.Sum, Type = "System.Int32", PreProcesses = new List<ProcessSettings> { new ProcessSettings { Method = ProcessMethod.Multiply, Value = "12", Filter = "Height Feet" } } } }; configuration = DataStoreConfiguration.FromColumns("Name"); var expected = new MemoryDataStore(configuration); expected.Write("71"); expected.Write("66"); var actual = new MemoryDataStore(configuration); Converter.Convert(source, mappings, actual); TestHelper.AreEqual(expected, actual); }
public void WriteToTable() { var configuration = new DataStoreConfiguration(); configuration.ConnectionString = _connectionString; configuration.Columns = new List<DataStoreColumn> { new DataStoreColumn { Name = "First Name", Source = "People" }, new DataStoreColumn { Name = "Last Name", Source = "People" }, new DataStoreColumn { Name = "Age", Source = "People" } }; var store = new SqlDataStore(configuration); store.Write("John", "Doe", "23"); store.Write("Jane", "Doe", "21"); var memoryStore = new MemoryDataStore(configuration); memoryStore.Write("John", "Doe", "23"); memoryStore.Write("Jane", "Doe", "21"); var actual = store.Read().ToList(); var expected = memoryStore.Read().ToList(); TestHelper.AreEqual(expected, actual); }
public void ReadFromTable() { var configuration = new DataStoreConfiguration(); configuration.ConnectionString = _connectionString; configuration.Columns = new List<DataStoreColumn> { new DataStoreColumn { Name = "First Name", Source = "People" }, new DataStoreColumn { Name = "Last Name", Source = "People" }, new DataStoreColumn { Name = "Age", Source = "People" } }; RunSql("INSERT INTO [dbo].[People] ([First Name],[Last Name],[Age]) VALUES ('John', 'Doe', 23)"); RunSql("INSERT INTO [dbo].[People] ([First Name],[Last Name],[Age]) VALUES ('Jane', 'Doe', 21)"); var store = new SqlDataStore(configuration); var actual = store.Read().ToList(); var memoryStore = new MemoryDataStore(configuration); memoryStore.Write("John", "Doe", "23"); memoryStore.Write("Jane", "Doe", "21"); var expected = memoryStore.Read().ToList(); TestHelper.AreEqual(expected, actual); }
public void ConvertTableTwoToOneMappingWithJoinCombinerAndPreProcessTrimming() { var configuration = DataStoreConfiguration.FromColumns("First Name", "Last Name", "Midddle Name", "Age"); var source = new MemoryDataStore(configuration); source.Write("John ", " Doe", "James ", "23"); source.Write(" Jane", " Doe", "Jill ", "21"); var mappings = new List<Mapping> { new Mapping { DestinationHeader = "Name", SourceHeaders = new List<string> { "First Name", "Last Name" }, Type = "System.String", CombineMethod = CombineMethod.Join, CombineValue = " ", PreProcesses = new List<ProcessSettings> { new ProcessSettings { Method = ProcessMethod.Trim, Filter = "First" }, new ProcessSettings { Method = ProcessMethod.TrimLeft, Filter = "Last" }, new ProcessSettings { Method = ProcessMethod.TrimRight, Filter = "Middle" } } } }; configuration = DataStoreConfiguration.FromColumns("Name"); var expected = new MemoryDataStore(configuration); expected.Write("John Doe"); expected.Write("Jane Doe"); var actual = new MemoryDataStore(configuration); Converter.Convert(source, mappings, actual); TestHelper.AreEqual(expected, actual); }