public void Metric_AddNewMetric()
{
string GUID = "{aaaa0011-622a-4656-85df-39edc26be080}";
string METRIC_CATEGORY = "My Metric Category";
string METRIC_NAME = "My Metric Name";
string METRIC_DESCRIPTION = "My very long description of the metric blah blah blah...";
string METRIC_FISCALYEAR_GUID = "c6a45416-81a2-4034-adac-c7eab5225ece"; // 2018
int YEAR = 2018;
ArdaTestMgr.Validate(this, $"Metric.AddNewMetric({GUID},{METRIC_CATEGORY},{METRIC_NAME},LongDescription, (Year:{YEAR}) {METRIC_FISCALYEAR_GUID})",
(list, ctx) =>
{
MetricRepository metric = new MetricRepository(ctx);
var row = new MetricViewModel()
{
MetricID = Guid.Parse(GUID),
MetricCategory = METRIC_CATEGORY,
MetricName = METRIC_NAME,
Description = METRIC_DESCRIPTION,
FiscalYearID = Guid.Parse(METRIC_FISCALYEAR_GUID),
// Ignored data
FullNumericFiscalYear = 0,
TextualFiscalYear = "IGNORED"
};
metric.AddNewMetric(row);
return(metric.GetAllMetrics());
});
}
public void Metric_EditMetricByID()
{
string METRIC_GUID = "{45979112-aff6-4bfa-878b-02baa8fd1074}"; // Education : Azure Training
string METRIC_CATEGORY = "Updated Metric Category";
string METRIC_NAME = "Updated Metric Name";
string METRIC_DESCRIPTION = "Updated description blah blah blah...";
string METRIC_FISCALYEAR_GUID = "c6a45416-81a2-4034-adac-c7eab5225ece"; // 2018
int YEAR = 2018;
ArdaTestMgr.Validate(this, $"Metric.EditMetricByID({METRIC_GUID},{METRIC_CATEGORY},{METRIC_NAME},LongDescription, (Year:{YEAR}) {METRIC_FISCALYEAR_GUID})",
(list, ctx) =>
{
MetricRepository metric = new MetricRepository(ctx);
var row = new MetricViewModel()
{
MetricID = Guid.Parse(METRIC_GUID),
MetricCategory = METRIC_CATEGORY,
MetricName = METRIC_NAME,
Description = METRIC_DESCRIPTION,
FiscalYearID = Guid.Parse(METRIC_FISCALYEAR_GUID),
// Ignored data
FullNumericFiscalYear = 0,
TextualFiscalYear = "IGNORED"
};
metric.EditMetricByID(row);
return(metric.GetAllMetrics());
});
}
public async Task SetUp()
{
connectionFactory = TestUtilities.GetIntegrationConnectionFactory();
var hourRepo = new HourRepository(connectionFactory);
var metricRepo = new MetricRepository(connectionFactory);
var hour = await hourRepo.CreateAsync(new Hour { HourTimeStamp = DateTime.Now });
var metric = await metricRepo.CreateAsync(new Metric { HourId = hour.Id, MetricType = MetricType.WebUptime });
var metricDataRepo = new MetricDataRepository(connectionFactory);
metricData = await metricDataRepo.CreateAsync(new MetricData { MetricId = metric.Id, Score = 100.0m });
var repo = new AuditAnalysisRepository(connectionFactory);
await repo.CreateAsync(Enumerable.Range(0, 4).Select(i =>
new AuditAnalysis
{
MetricDataId = metricData.Id,
TotalQueries = 123,
TotalLongRunningQueries = 234,
TotalComplexQueries = 345,
UserId = 456
}).ToList());
auditAnalyses = await repo.ReadByMetricData(metricData);
}
public void Metric_GetMetricByID()
{
string METRIC_GUID = "{819193e6-ea01-4c4e-a948-fc44453b2604}"; // Education GUID
ArdaTestMgr.Validate(this, $"Metric.GetMetricByID({METRIC_GUID})",
(list, ctx) =>
{
MetricRepository metric = new MetricRepository(ctx);
var row = metric.GetMetricByID(Guid.Parse(METRIC_GUID));
return(row);
});
}
public void Metric_GetAllMetrics_ByYear()
{
int YEAR = 2017;
ArdaTestMgr.Validate(this, $"Metric.GetAllMetrics({YEAR})",
(list, ctx) =>
{
MetricRepository metric = new MetricRepository(ctx);
var row = metric.GetAllMetrics(YEAR);
return(row);
});
}
public void Metric_DeleteMetricByID()
{
string METRIC_GUID = "{45979112-aff6-4bfa-878b-02baa8fd1074}"; // Education : Azure Training
ArdaTestMgr.Validate(this, $"Metric.DeleteMetricByID({METRIC_GUID})",
(list, ctx) =>
{
MetricRepository metric = new MetricRepository(ctx);
metric.DeleteMetricByID(Guid.Parse(METRIC_GUID));
return(metric.GetAllMetrics());
});
}
public async Task OneTimeSetup()
{
var hourRepo = new HourRepository(ConnectionFactorySetup.ConnectionFactory);
hour = await hourRepo.CreateAsync(new Hour { HourTimeStamp = DateTime.Now });
metricRepository = new MetricRepository(ConnectionFactorySetup.ConnectionFactory);
metric = await metricRepository.CreateAsync(new Metric { HourId = hour.Id, MetricType = MetricType.AgentUptime });
metric = await metricRepository.ReadAsync(metric.Id);
metric.MetricType = MetricType.WebUptime;
await metricRepository.UpdateAsync(metric);
}
public CachedMetricRepository(MetricRepository metricRepository, IMemoryCache cache)
{
this.metricRepository = metricRepository;
this.cache = cache;
}
public HttpResponseMessage Data([FromBody] Request input)
{
_lines = File.ReadAllLines("RandomWords.txt");
_dimensionRepository = new DimensionRepository();
_metricRepository = new MetricRepository();
try
{
var response = new EinsteinDTO
{
ComponentValues = new List <IDimensionMetricPair>()
};
var fromDate = input.Filters.DateFilter.From;
var endDate = input.Dimensions.Count == 0 ? input.Filters.DateFilter.From : input.Filters.DateFilter.To;
IEnumerable <DateTime> iterator = null;
var dateMnemonic = "d_Date";
foreach (var dimension in input.Dimensions)
{
if (_dimensionRepository.Exists(dimension))
{
switch (dimension)
{
case "d_Day":
iterator = EachDay(fromDate, endDate);
dateMnemonic = "d_Date";
break;
case "d_Month":
iterator = EachMonth(fromDate, endDate);
dateMnemonic = "d_Month";
break;
case "d_Year":
iterator = EachYear(fromDate, endDate);
dateMnemonic = "d_Year";
break;
}
if (iterator != null)
{
foreach (DateTime day in iterator)
{
response.ComponentValues.Add(SetData(input, dateMnemonic, day.ToShortDateString()));
}
break;
}
}
}
if (iterator == null)
{
if (input.Dimensions.Count == 0)
{
response.ComponentValues.Add(SetData(input, "d_Date", GetRandomWord()));
}
else
{
var rand = (new Random().Next(25)) + 1;
for (int i = 0; i < rand; i++)
{
response.ComponentValues.Add(SetData(input, input.Dimensions[0], GetRandomWord()));
}
}
}
var ret = Request.CreateResponse(HttpStatusCode.OK, response);
// ret.Headers.Add("Access-Control-Allow-Origin", "*");
return(ret);
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(null);
}
public IEnumerable <MetricViewModel> GetSnapshot(TransactionalKanbanContext context)
{
MetricRepository metrics = new MetricRepository(context);
return(metrics.GetAllMetrics());
}
static Global()
{
Metrics = new MetricRepository();
}
