public void TestUploadMethod()
{
// Source Adapter
XMLSourceAdapter sourceAdapter = new XMLSourceAdapter();
sourceAdapter.ID = new Guid();
sourceAdapter.AdapterName = "XMLCustomersAdapter";
sourceAdapter.FilePath = @"D:\sample.xml";
sourceAdapter.Fileds = new List <IColumn>()
{
new XmlColumn()
{
InternalName = "FirstName", ColumnType = ColumnTypes.String, ReadOnly = false
},
new XmlColumn()
{
InternalName = "LastName", ColumnType = ColumnTypes.String, ReadOnly = false
},
};
// Destination Adapter
SQLDestinationAdapter destinationAdapter = new SQLDestinationAdapter();
destinationAdapter.ID = new Guid();
destinationAdapter.AdapterName = "SQLCustomersAdapter";
destinationAdapter.ConnectionString = "Server=192.168.85.198;Database=DoctorlyDB;User Id=sa;Password=sa@123;";
destinationAdapter.Fileds = new List <IColumn>()
{
new SQLColumn()
{
InternalName = "Col_FirstName", ColumnType = ColumnTypes.String, ReadOnly = false
},
new SQLColumn()
{
InternalName = "Col_LastName", ColumnType = ColumnTypes.String, ReadOnly = false
},
};
destinationAdapter.TableName = "Customers";
// Pipeline
PipelineAddOprator1 p1 = new PipelineAddOprator1();
PipelineAddOprator2 p2 = new PipelineAddOprator2();
p1.Successor = p2;
destinationAdapter.Fileds[0].WriteDataPipeline = p1;
//Maping
//Mapping mapping = new Mapping(jsonSourceAdapter, sQLDestinationAdapter);
List <ColumnAssignment> columnAssignments = ColumnAssignment.CreateMapingWithPrefix(sourceAdapter, "Col_");
//ETL Config
ETLConfig eTLConfig = new ETLConfig()
.SetSourceAdapter(sourceAdapter)
.SetDestinationAdapter(destinationAdapter)
.SetColumnAssignments(columnAssignments)
.SetConflictStrategyType(ConflictStrategyType.Ignore);
bool result = eTLConfig.UploadData(new WinAppContext()
{
loger = new FileLoger()
});
Assert.AreEqual(true, result);
}
private void btnPreview_Click(object sender, EventArgs e)
{
// Source Adapter
XMLSourceAdapter sourceAdapter = (XMLSourceAdapter) new SourceAdapterFactory().CreateAdapter(drpSourceType.SelectedValue.ToString());
sourceAdapter.ID = new Guid();
sourceAdapter.AdapterName = "XMLCustomersAdapter";
sourceAdapter.FilePath = @"D:\sample.xml";
sourceAdapter.Fileds = new List <IColumn>()
{
new XmlColumn()
{
InternalName = "FirstName", ColumnType = ColumnTypes.String, ReadOnly = false
},
new XmlColumn()
{
InternalName = "LastName", ColumnType = ColumnTypes.String, ReadOnly = false
},
};
// Destination Adapter
SQLDestinationAdapter destinationAdapter = new SQLDestinationAdapter();
destinationAdapter.ID = new Guid();
destinationAdapter.AdapterName = "SQLCustomersAdapter";
destinationAdapter.ConnectionString = "Server=192.168.85.198;Database=DoctorlyDB;User Id=sa;Password=sa@123;";
destinationAdapter.Fileds = new List <IColumn>()
{
new SQLColumn()
{
InternalName = "Col_FirstName", ColumnType = ColumnTypes.String, ReadOnly = false
},
new SQLColumn()
{
InternalName = "Col_LastName", ColumnType = ColumnTypes.String, ReadOnly = false
},
};
destinationAdapter.TableName = "Customers";
// Pipeline
PipelineAddOprator1 p1 = new PipelineAddOprator1();
PipelineAddOprator2 p2 = new PipelineAddOprator2();
p1.Successor = p2;
destinationAdapter.Fileds[0].WriteDataPipeline = p1;
//Maping
//Mapping mapping = new Mapping(jsonSourceAdapter, sQLDestinationAdapter);
List <ColumnAssignment> columnAssignments = ColumnAssignment.CreateMapingWithPrefix(sourceAdapter, "Col_");
//ETL Config
ETLConfig eTLConfig = new ETLConfig()
.SetSourceAdapter(sourceAdapter)
.SetDestinationAdapter(destinationAdapter)
.SetColumnAssignments(columnAssignments);
DataTable dt = eTLConfig.PreviewData(new WinAppContext()
{
loger = new FileLoger()
});
grdPreview.DataSource = dt;
}
