public XVerifyMailingAddressValidFileProcessor( IDatabaseCommanderFactory databaseCommandFactory, IDelimitedFileHandler delimitedFileHandler) { _databaseCommander = databaseCommandFactory.Create(DefaultConnection); _delimitedFileHandler = delimitedFileHandler; }
public DatabaseCommanderFactorySamples( IDatabaseCommanderFactory databaseCommanderFactory, IConfiguration config) : base(config) { _databaseCommanderFactory = databaseCommanderFactory; }
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(); }
public NullColumnDatabaseTableProcessor(IDatabaseCommanderFactory databaseCommanderFactory) { _databaseCommander = databaseCommanderFactory.Create(); }
public ReconcileCleanupProcessor(IDatabaseCommanderFactory commanderFactory) { _commander = commanderFactory.Create("AccountDatabase"); }