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