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);
}
