public MetricsDeliveryManager(Guid serviceInstanceID, Dictionary <string, EdgeType> edgeTypes = null, MetricsDeliveryManagerOptions options = null)
: base(serviceInstanceID)
{
options = options ?? new MetricsDeliveryManagerOptions();
options.StagingConnectionString = options.StagingConnectionString ?? AppSettings.GetConnectionString(this, Consts.ConnectionStrings.Staging);
options.CommitConnectionString = options.CommitConnectionString ?? AppSettings.GetConnectionString(this, Consts.ConnectionStrings.DataWarehouse);
options.ObjectsConnectionString = options.CommitConnectionString ?? AppSettings.GetConnectionString(this, Consts.ConnectionStrings.Objects);
options.SqlTransformCommand = options.SqlTransformCommand ?? AppSettings.Get(this, Consts.AppSettings.SqlTransformCommand, throwException: false);
options.SqlStageCommand = options.SqlStageCommand ?? AppSettings.Get(this, Consts.AppSettings.SqlStageCommand, throwException: false);
options.SqlCommitCommand = options.SqlStageCommand ?? AppSettings.Get(this, Consts.AppSettings.SqlCommitCommand, throwException: false);
options.SqlRollbackCommand = options.SqlRollbackCommand ?? AppSettings.Get(this, Consts.AppSettings.SqlRollbackCommand, throwException: false);
Options = options;
// create connection and table managers
_deliverySqlConnection = OpenDbConnection(Consts.ConnectionStrings.Deliveries);
_objectsSqlConnection = OpenDbConnection(Consts.ConnectionStrings.Objects);
_edgeObjectsManager = new EdgeObjectsManager(_deliverySqlConnection, _objectsSqlConnection)
{
EdgeTypes = edgeTypes
};
_metricsTableManager = new MetricsTableManager(_deliverySqlConnection, _edgeObjectsManager)
{
EdgeTypes = edgeTypes
};
}
public MetricsTableManager(SqlConnection connection, EdgeObjectsManager edgeObjectsManager)
{
_deliverySqlConnection = connection;
_edgeObjectsManger = edgeObjectsManager;
_insertMetricsCommand = new SqlCommand {
Connection = _deliverySqlConnection
};
}