public bool CreateDestinationDataTable()
{
Global.progressForm.UpdateForm(ProgressForm.LABEL_ACTION, "Creating destination table...");
Global.ProgressForm.UpdateForm(ProgressForm.PROGRESSBAR_VALUE, "0");
//Source database & table setup
Database sourceDb = this.srcDb;
TableOrQuery sourceTableOrQuery = this.sourceTable;
sourceTableOrQuery = sourceDb.GetTableOrQueryByName(sourceTableOrQuery.GetName());
sourceTableOrQuery.dataTable.TableName = sourceTableOrQuery.GetName();
//Destination database & table setup
Database destinationDb = this.destDb;
DataTable destinationDt;
if (!this.isDspaceDestination)
{
Table destinationTable = destinationDb.GetTable(this.destTable.GetName());
destinationTable.dataTable.TableName = destinationTable.GetName();
destinationDt = destinationTable.dataTable;
}
else
{
destinationDt = ((DSpaceDatabase)destinationDb).dspaceData;
}
bool createDestinationDatatableSucess = Expression.AddValuesToDatatableDestination(sourceTableOrQuery.dataTable, destinationDt, this.expressionDt, Global.mapDt);
return(createDestinationDatatableSucess);
}
public SingleETL(string name, Database srcDb, Database destDb, TableOrQuery sourceTable, Table destTable, DataTable expressionDt)
{
this.name = name;
this.srcDb = srcDb;
this.destDb = destDb;
this.sourceTable = sourceTable;
this.destTable = destTable;
this.expressionDt = expressionDt;
this.isDspaceDestination = false;
}
public bool FetchSourceData()
{
Global.progressForm.UpdateForm(ProgressForm.LABEL_ACTION, "Fetching source data...");
Database sourceDb = this.srcDb;
TableOrQuery sourceTableOrQuery = this.sourceTable;
sourceDb.Close();
sourceDb.Connect();
int count = sourceDb.SelectRowCount(sourceTableOrQuery.GetName(), sourceTableOrQuery.type);
Global.ProgressForm.UpdateForm(ProgressForm.PROGRESSBAR_VALUE, "0");
Global.ProgressForm.UpdateForm(ProgressForm.PROGRESSBAR_MAXIMUM, count.ToString());
bool selectDataSuccess = sourceDb.Select(sourceTableOrQuery.GetName(), sourceTableOrQuery.type);
sourceDb.Close();
return(selectDataSuccess);
}
