private static bool ReplicateTransforms()
{
Helpers.WriteLine(Environment.NewLine, 1);
Helpers.WriteLine($"[{DateTime.Now:dd/mm/yyyy HH:mm}] Step 3 of 7: Replicate transforms", 1);
TransformManager transformManager = new TransformManager();
transformManager.Initialize(_sourceClient.Transforms, _destinationClient.Transforms, _appSettings.Source, _appSettings.Destination, _appSettings.Miscellaneous);
return(transformManager.Replicate());
}
private void Test(Dictionary <string, string> colMapping, string idColName)
{
var sut = new TransformManager();
sut.Initialize(colMapping, idColName);
var dtSource = GetTestDataTable();
var dt = sut.Transform(dtSource);
dt.Rows.Count.Should().Be(2);
dt.Columns.Count.Should().Be(3);
dt.Rows[0]["D1"].Should().Be("Row1-S4");
dt.Rows[0]["D2"].Should().Be("Row1-S3");
dt.Rows[0]["D3"].Should().Be("Row1-S1");
dt.Rows[1]["D1"].Should().Be("Row2-S4");
dt.Rows[1]["D2"].Should().Be("Row2-S3");
dt.Rows[1]["D3"].Should().Be("Row2-S1");
}
private TransformManager GetTransformManager(bool validate)
{
TransformManager manager;
if (!validate)
{
manager = new TransformManager();
manager.Initialize(_colMappings, _colMappings.IdColumn);
}
else
{
var dsh = new DbSchemaHelper();
var schema = dsh.GetSchema(_destinationConn, _destinationTable);
var trans = new ValidatingTransformManager();
trans.Initialize(_colMappings, _colMappings.IdColumn, schema);
trans.DataValidationError += new EventHandler <DataValidationErrorEventArgs>(delegate(object sender, DataValidationErrorEventArgs e) { OnDataValidationError(e); });
manager = trans;
}
return(manager);
}
