public ExcelToSqlServerFileProcessor(
IDatabaseCommanderFactory databaseCommandFactory,
IExcelFileHandler excelFileHandler)
{
Settings = new SqlServerFileProcessorSettings
{
ConnectionStringName = Constants.Configuration.ConnectionString.DefaultConnection,
FilePath = @"C:\Users\scott\Documents\ExcelDataSource\do-not-email.xlsx",
SchemaName = "issue",
TableName = "EmailListBillCreditOriginal",
PrimaryKeyColumnName = "EmailListBillCreditID",
PrimaryKeyColumnType = typeof(Guid),
CreatedBy = "sferguson",
IsAppendAuditFields = true
};
_excelFileHandler = excelFileHandler;
DatabaseCommander = databaseCommandFactory.Create(Settings.ConnectionStringName);
DatabaseColumns = new Dictionary <string, string>();
Init();
// Use this to setup column names and data types where the auto-generation doesn't do what you need
//_databaseColumns.Add("EnrollmentRequestRewardID", "UNIQUEIDENTIFIER NULL");
}
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 AccessToSqlServerProcessor(
IDatabaseCommanderFactory databaseCommanderFactory,
IConnectionStringProvider connectionStringProvider)
{
_databaseCommander = databaseCommanderFactory.Create(_settings.ConnectionStringName);
_settings = new SqlServerFileProcessorSettings
{
ConnectionStringName = Constants.Configuration.ConnectionString.DefaultConnection,
FilePath = connectionStringProvider.Get("AccessConnection"),
SchemaName = "issue",
TableName = "ESGBeforeOpSolve",
PrimaryKeyColumnName = "ESGBeforeOpSolveID",
CreatedBy = "sferguson",
IsAppendAuditFields = true
};
_databaseColumns = new Dictionary <string, string>();
Init();
}
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();
}
