public async Task DeleteTable(string target, string table)
{
ConnectParameters targetConnector = await Common.GetConnectParameters(_azureConnectionString, target);
DatabaseLoader dl = new DatabaseLoader();
dl.DeleteTable(targetConnector.ConnectionString, table);
}
public async Task CopyFiles(TransferParameters parms)
{
try
{
ConnectParameters sourceConnector = await Common.GetConnectParameters(_azureConnectionString, parms.SourceName);
ConnectParameters targetConnector = await Common.GetConnectParameters(_azureConnectionString, parms.TargetName);
string dataAccessDefinition = await _fileStorage.ReadFile("connectdefinition", "PPDMDataAccess.json");
string referenceJson = await _fileStorage.ReadFile("connectdefinition", "PPDMReferenceTables.json");
targetConnector.DataAccessDefinition = dataAccessDefinition;
if (sourceConnector.SourceType == "DataBase")
{
DatabaseLoader dl = new DatabaseLoader();
dl.CopyTable(parms, sourceConnector.ConnectionString, targetConnector, referenceJson);
}
else if (sourceConnector.SourceType == "File")
{
if (sourceConnector.DataType == "Logs")
{
LASLoader ls = new LASLoader(_fileStorage);
await ls.LoadLASFile(sourceConnector, targetConnector, parms.Table, referenceJson);
}
else
{
CSVLoader cl = new CSVLoader(_fileStorage);
await cl.LoadCSVFile(sourceConnector, targetConnector, parms.Table);
}
}
else
{
Exception error = new Exception($"DataTransfer: Not a valid source type for {sourceConnector.SourceName}");
throw error;
}
}
catch (Exception ex)
{
Exception error = new Exception($"DataTransfer: Problems transfer files/tables, {ex}");
throw error;
}
}
