public ServiceManager(IDataHarmonizationLogManager logManager, IDataHarmonizationQueueService dataHarmonizationQueueService, IDataProcessorService dataProcessorService, IDataHarmonizationManager dataHarmonizationManager, IDataHarmonizationQueueRepository dataHarmonizationQueueRepository, ISqlConnectionManager sqlConnectionManager)
{
_sqlConnectionManager = sqlConnectionManager;
_dataHarmonizationQueueRepository = dataHarmonizationQueueRepository;
_dataHarmonizationManager = dataHarmonizationManager;
_logManager = logManager;
_dataProcessorService = dataProcessorService;
_dataHarmonizationService = dataHarmonizationQueueService;
}
public SqlServerDeployer(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager, ILoggerSync logger)
: base(config, project)
{
if (project == null)
throw new ArgumentNullException("project");
if (connectionManager == null)
throw new ArgumentNullException("connectionManager");
_connectionManager = connectionManager;
_logger = logger ?? new NullLogger();
_patternLookup = new CatalogPatternLookup();
}
private RunnerResolution ResolveTransaction(bool commit, ISqlConnectionManager connectionManager)
{
_logger.PostEntryNoTimestamp(string.Empty);
if (commit)
{
_logger.PostEntry(Verbosity.Vital, "~~~~~~~~~~ COMMITTING ~~~~~~~~~~{0}", Environment.NewLine);
connectionManager.CommitTransaction();
return(RunnerResolution.Committed);
}
_logger.PostEntry(Verbosity.Vital, "~~~~~~~~~~ ROLLING BACK ~~~~~~~~~~{0}", Environment.NewLine);
connectionManager.RollbackTransaction();
return(RunnerResolution.RolledBack);
}
private void DeployScripts(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager)
{
using (var deployer = new SqlServerDeployer(config, project, connectionManager, _logger))
{
if (deployer.CanProceed() == false)
{
throw new RunnerException("Cannot proceed! A more recent version has already been deployed.", RunnerResolution.StaleDeployment);
}
if (deployer.DeployScripts() == Returned.Failure)
{
throw new RunnerException("Deploy scripts failed.");
}
}
}
public SqlServerDeployer(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager, ILoggerSync logger)
: base(config, project)
{
if (project == null)
{
throw new ArgumentNullException("project");
}
if (connectionManager == null)
{
throw new ArgumentNullException("connectionManager");
}
_connectionManager = connectionManager;
_logger = logger ?? new NullLogger();
_patternLookup = new CatalogPatternLookup();
}
public static SqlCommand ToSqlCommand(this SqlDataCommand sqlDataCommand, ISqlConnectionManager connectionManager)
{
var sqlCommand = new SqlCommand(sqlDataCommand.CommandText);
if (sqlDataCommand.Parameters != null && sqlDataCommand.Parameters.Count > 0)
{
sqlCommand.Parameters.AddRange(sqlDataCommand.Parameters.Select(p => new SqlParameter(p.Key, p.Value)).ToArray());
}
if (!string.IsNullOrEmpty(sqlDataCommand.ConnectionName))
{
sqlCommand.Connection = connectionManager.GetConnection(sqlDataCommand.ConnectionName);
}
return(sqlCommand);
}
public ScriptFileDeployer(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager, ILogger logger)
: base(config, project)
{
if (project == null)
throw new ArgumentNullException("project");
_connectionManager = connectionManager;
_logger = logger ?? new NullLogger();
_patternLookup = new CatalogPatternLookup();
var fileName = string.Format("{0}_{1}_v{2}.sql", connectionManager.Server, project.Configuration.Project, project.Configuration.Version.Replace('.', '-'));
var path = Path.Combine("G:\\", fileName);
_writer = new StreamWriter(File.Create(path, 16384, FileOptions.Asynchronous));
_writer.WriteLine("-- Generated {0} on {1} by {2}", DateTime.Now, Environment.MachineName, Environment.UserName);
}
public HostedService(
ILogger <HostedService> logger,
IHostApplicationLifetime appLifetime,
ISqlConnectionManager sqlConnectionManager,
IDatabaseContext dbContext,
IMediatorFactory mediatorFactory
)
{
_logger = logger;
_mediatorFactory = mediatorFactory;
_sqlConnectionManager = sqlConnectionManager;
_dbContext = dbContext;
appLifetime.ApplicationStarted.Register(OnStarted);
appLifetime.ApplicationStopping.Register(OnStopping);
appLifetime.ApplicationStopped.Register(OnStopped);
}
public ScriptFileDeployer(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager, ILogger logger)
: base(config, project)
{
if (project == null)
{
throw new ArgumentNullException("project");
}
_connectionManager = connectionManager;
_logger = logger ?? new NullLogger();
_patternLookup = new CatalogPatternLookup();
var fileName = string.Format("{0}_{1}_v{2}.sql", connectionManager.Server, project.Configuration.Project, project.Configuration.Version.Replace('.', '-'));
var path = Path.Combine("G:\\", fileName);
_writer = new StreamWriter(File.Create(path, 16384, FileOptions.Asynchronous));
_writer.WriteLine("-- Generated {0} on {1} by {2}", DateTime.Now, Environment.MachineName, Environment.UserName);
}
/// <summary>
/// Initializes a new instance of the <see cref="LinqToSqlRepository"/> class.
/// </summary>
/// <param name="connectionManager">
/// The sql connection manager.
/// </param>
/// <param name="mappingSourceManager">
/// The mapping source manager.
/// </param>
public LinqToSqlRepository(ISqlConnectionManager connectionManager, IMappingSourceManager mappingSourceManager)
{
this.ConnectionManager = connectionManager;
this.MappingSourceManager = mappingSourceManager;
this.CreatedDataContexts = new List <WeakReference>();
}
public TableDefinitionRepository(ISqlConnectionManager connectionManager) : base(connectionManager)
{
}
private RunnerResolution ResolveTransaction(bool commit, ISqlConnectionManager connectionManager)
{
_logger.PostEntryNoTimestamp(string.Empty);
if (commit)
{
_logger.PostEntry(Verbosity.Vital, "~~~~~~~~~~ COMMITTING ~~~~~~~~~~{0}", Environment.NewLine);
connectionManager.CommitTransaction();
return RunnerResolution.Committed;
}
_logger.PostEntry(Verbosity.Vital, "~~~~~~~~~~ ROLLING BACK ~~~~~~~~~~{0}", Environment.NewLine);
connectionManager.RollbackTransaction();
return RunnerResolution.RolledBack;
}
private void DeployScripts(IScriptDeployerConfig config, IProject project, ISqlConnectionManager connectionManager)
{
using(var deployer = new SqlServerDeployer(config, project, connectionManager, _logger))
{
if (deployer.CanProceed() == false)
throw new RunnerException("Cannot proceed! A more recent version has already been deployed.", RunnerResolution.StaleDeployment);
if (deployer.DeployScripts() == Returned.Failure)
throw new RunnerException("Deploy scripts failed.");
}
}
public ColumnDefinitionRepository(ISqlConnectionManager connectionManager) : base(connectionManager)
{
}
public RealDbContext(ISqlConnectionManager connectionManager)
{
_sqlConnectionFactory = connectionManager;
}
protected AdoRepository(ISqlConnectionManager connectionManager)
{
this.connectionManager = connectionManager;
}
