public XVerifyMailingAddressValidFileProcessor(
IDatabaseCommanderFactory databaseCommandFactory,
IDelimitedFileHandler delimitedFileHandler)
{
_databaseCommander = databaseCommandFactory.Create(DefaultConnection);
_delimitedFileHandler = delimitedFileHandler;
}
public LoadTestDataProcessor(
IDatabaseCommanderFactory databaseCommandFactory,
IDelimitedFileHandler delimitedFileHandler)
{
Settings = new SqlServerFileProcessorSettings
{
ConnectionStringName = Constants.Configuration.ConnectionString.UrjanetDatabase,
FilePath = @"C:\Users\scott\OneDrive\Guroo\Projects\2020-07-31 - Urjanet\URJ\Guroo_08_10_20_09_15.urj",
SchemaName = "dbo",
TableName = "UrjanetLoadStage"
};
_delimitedFileHandler = delimitedFileHandler;
DatabaseCommander = databaseCommandFactory.Create(Settings.ConnectionStringName);
}
public CsvToSqlServerFileProcessor(
IDatabaseCommanderFactory databaseCommandFactory,
IDelimitedFileHandler delimitedFileHandler)
{
Settings = new SqlServerFileProcessorSettings
{
ConnectionStringName = Constants.Configuration.ConnectionString.DefaultConnection,
FilePath = @"C:\Users\scott\Documents\ExcelDataSource\subscribed_members_export_a6ee01d8d2.csv",
SchemaName = "issue",
TableName = "EmailListBillCreditOriginal",
PrimaryKeyColumnName = "EmailListBillCreditID",
PrimaryKeyColumnType = typeof(Guid),
CreatedBy = "sferguson",
IsAppendAuditFields = true
};
_delimitedFileHandler = delimitedFileHandler;
DatabaseCommander = databaseCommandFactory.Create(Settings.ConnectionStringName);
DatabaseColumns = new Dictionary <string, string>();
Init();
}
