public void Build()
{
LoadTestDatabase db = new LoadTestDatabase(this.enviroment.ConnectionString);
//SQLDB db = new SQLDB(this.enviroment.SQLConfig.Server, this.enviroment.SQLConfig.Database, this.enviroment.SQLConfig.Username, this.enviroment.SQLConfig.Password);
//db.openDB();
//tempDir = new DirectoryInfo(Path.Combine(Path.GetTempPath(), Path.GetRandomFileName()));
tempDir = reportDir;
if (tempDir.Exists)
{
tempDir.Create();
}
ZIPUtil.DecompressData(FileResources.ReportZIPData(), tempDir);
String errorFile = Path.Combine(tempDir.FullName, "error.log");
Int64 VU = 0;
Int64 connections = 0;
Int64 throughput = 0;
Int64 bytesReceived = 0;
Int64 requests = 0;
Int64 rps = 0;
StringBuilder js = new StringBuilder();
js.AppendLine("jQuery(document).ready(function ($) {");
String html = "";
List <String> labels = new List <String>();
List <String> values = new List <String>();
List <String> values2 = new List <String>();
DateTime date = enviroment.dStart;
Int64 value = 0;
DataTable dtTmp = db.selectGeneral(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
if (dtTmp.Rows.Count > 0)
{
VU = (Int64)dtTmp.Rows[0]["vu"];
connections = (Int64)dtTmp.Rows[0]["connections"];
throughput = (Int64)dtTmp.Rows[0]["throughput"];
bytesReceived = (Int64)dtTmp.Rows[0]["bytesReceived"];
requests = (Int64)dtTmp.Rows[0]["requests"];
rps = (Int64)dtTmp.Rows[0]["rps"];
}
//Graficos de monitoramento Zabbix
StringBuilder extra = new StringBuilder();
DataTable dtZabbix = db.selectMonitoredZabbix(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
Dictionary <String, String> zbxHosts = new Dictionary <string, string>();
if (dtZabbix != null)
{
foreach (DataRow dr in dtZabbix.Rows)
{
String name = dr["host"].ToString();
try
{
foreach (SafeTrend.Data.ZabbixConfig cfg in enviroment.ZabbixMonitors)
{
if (cfg.Host == name)
{
name = cfg.Name;
}
}
}
catch { }
zbxHosts.Add(dr["host"].ToString(), name);
}
}
//Ordena pelo nome do host
zbxHosts = zbxHosts.OrderBy(x => x.Value).ToDictionary(x => x.Key, x => x.Value);
foreach (String host in zbxHosts.Keys)
{
try
{
String key = Guid.NewGuid().ToString().Trim(" {}".ToCharArray()).Replace("-", "");
String name = zbxHosts[host].ToString();
extra.AppendLine("<div class=\"full-line topspace\">");
extra.AppendLine("<h2>" + name + " - CPU (%)</h2>");
extra.AppendLine("</div>");
extra.AppendLine("<div class=\"data1 data2 full-line\">");
extra.AppendLine("<div class=\"chartcontent\"><canvas id=\"" + key + "_cpu\" width=\"921\" height=\"150\"></canvas></div>");
extra.AppendLine("<div class=\"clearfix\"></div>");
extra.AppendLine("</div>");
extra.AppendLine("");
extra.AppendLine("<div class=\"full-line topspace\">");
extra.AppendLine("<h2>" + name + " - CPU (Load Average - 1 min)</h2>");
extra.AppendLine("</div>");
extra.AppendLine("<div class=\"data1 data2 full-line\">");
extra.AppendLine("<div class=\"chartcontent\"><canvas id=\"" + key + "_cpuload\" width=\"921\" height=\"150\"></canvas></div>");
extra.AppendLine("<div class=\"clearfix\"></div>");
extra.AppendLine("</div>");
extra.AppendLine("");
extra.AppendLine("<div class=\"full-line topspace\">");
extra.AppendLine("<h2>" + name + " - Memoria (Gb)</h2>");
extra.AppendLine("</div>");
extra.AppendLine("<div class=\"data1 data2 full-line\">");
extra.AppendLine("<div class=\"chartcontent\"><canvas id=\"" + key + "_memory\" width=\"921\" height=\"150\"></canvas></div>");
extra.AppendLine("<div class=\"clearfix\"></div>");
extra.AppendLine("</div>");
extra.AppendLine("");
dtTmp = db.selectZabbixNetIfs(enviroment.TestName, host, enviroment.dStart, enviroment.dEnd);
foreach (DataRow drNN in dtTmp.Rows)
{
String kName = GetMd5Hash(key + drNN["name"].ToString().Replace(" ", ""));
extra.AppendLine("<div class=\"full-line topspace\">");
extra.AppendLine("<h2>" + name + " - " + drNN["name"] + " (mbps)</h2>");
extra.AppendLine("</div>");
extra.AppendLine("<div class=\"data1 data2 full-line\">");
extra.AppendLine("<div class=\"chartcontent\"><canvas id=\"" + kName + "_if\" width=\"921\" height=\"150\"></canvas></div>");
extra.AppendLine("<div class=\"clearfix\"></div>");
extra.AppendLine("</div>");
extra.AppendLine("");
labels.Clear();
values.Clear();
values2.Clear();
labels.Add("Início");
values.Add("0");
values2.Add("0");
date = enviroment.dStart;
value = 0;
dtTmp = db.selectZabbixNetworkTraffic(enviroment.TestName, host, drNN["name"].ToString(), enviroment.dStart, enviroment.dEnd);
foreach (DataRow drN in dtTmp.Rows)
{
date = DateTime.Parse(drN["dateg"].ToString());
labels.Add(date.ToString("HH:mm"));
value = (Int64)drN["in_value"];
values.Add(((value * 8) / 1024 / 1024).ToString());
value = (Int64)drN["out_value"];
values2.Add(((value * 8) / 1024 / 1024).ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
values2.Add("0");
js.AppendLine("var data1 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" label: \"Input\",");
js.AppendLine(" fillColor: \"rgba(220,220,220,0.2)\",");
js.AppendLine(" strokeColor: \"rgba(220,220,220,1)\",");
js.AppendLine(" pointColor: \"rgba(220,220,220,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" pointHighlightFill: \"#fff\",");
js.AppendLine(" pointHighlightStroke: \"rgba(220,220,220,1)\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" },");
js.AppendLine(" {");
js.AppendLine(" label: \"Output\",");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values2) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#" + kName + "_if').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data1, null);");
}
labels.Clear();
values.Clear();
values2.Clear();
labels.Add("Início");
values.Add("0");
values2.Add("0");
date = enviroment.dStart;
value = 0;
dtTmp = db.selectZabbixCPU(enviroment.TestName, host, enviroment.dStart, enviroment.dEnd);
foreach (DataRow drH in dtTmp.Rows)
{
date = DateTime.Parse(drH["dateg"].ToString());
value = (Int64)drH["cpu"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data1 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#" + key + "_cpu').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data1, null);");
//Load AVG
labels.Clear();
values.Clear();
labels.Add("Início");
values.Add("0");
values2.Add("0");
date = enviroment.dStart;
value = 0;
dtTmp = db.selectZabbixCPULoad(enviroment.TestName, host, enviroment.dStart, enviroment.dEnd);
foreach (DataRow drH in dtTmp.Rows)
{
date = DateTime.Parse(drH["dateg"].ToString());
value = (Int64)drH["load"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data1 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#" + key + "_cpuload').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data1, null);");
//Memoria
labels.Clear();
values.Clear();
values2.Clear();
labels.Add("Início");
values.Add("0");
values2.Add("0");
date = enviroment.dStart;
value = 0;
dtTmp = db.selectZabbixMemory(enviroment.TestName, host, enviroment.dStart, enviroment.dEnd);
foreach (DataRow drH in dtTmp.Rows)
{
date = DateTime.Parse(drH["dateg"].ToString());
labels.Add(date.ToString("HH:mm"));
values.Add((((Int64)drH["total_memory"]) / 1024 / 1024 / 1024).ToString());
values2.Add((((Int64)drH["memory"]) / 1024 / 1024 / 1024).ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
values2.Add("0");
js.AppendLine("var data1 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" label: \"Total\",");
js.AppendLine(" fillColor: \"rgba(220,220,220,0.2)\",");
js.AppendLine(" strokeColor: \"rgba(220,220,220,1)\",");
js.AppendLine(" pointColor: \"rgba(220,220,220,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" pointHighlightFill: \"#fff\",");
js.AppendLine(" pointHighlightStroke: \"rgba(220,220,220,1)\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" },");
js.AppendLine(" {");
js.AppendLine(" label: \"Usada\",");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values2) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#" + key + "_memory').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data1, null);");
}
catch (Exception ex)
{
File.WriteAllBytes(errorFile, Encoding.UTF8.GetBytes(ex.Message + ex.StackTrace));
}
}
File.WriteAllBytes(Path.Combine(tempDir.FullName, "index.html"), Encoding.UTF8.GetBytes(FileResources.GetIndexText(this.enviroment.TestName, this.enviroment, VU, connections, throughput, bytesReceived, requests, rps, extra.ToString())));
DirectoryInfo jsDir = new DirectoryInfo(Path.Combine(tempDir.FullName, "js"));
try
{
jsDir.Create();
}
catch { }
//Mensagens
//
dtTmp = db.selectMessages(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
if ((dtTmp == null) || (dtTmp.Rows.Count == 0))
{
js.AppendLine("$('#message thead th').html('Nenhuma mensagem gerada pelo sistema');");
}
else
{
foreach (DataRow dr in dtTmp.Rows)
{
html += "<div class=\"title\">" + dr["title"] + "</div><div class=\"message\">" + dr["text"].ToString().Replace("\r\n", "<br />") + "</div>";
}
js.AppendLine("$('#message thead th').html('" + html + "');");
}
//Tabela de otimização
dtTmp = db.selectOptimization(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
if (dtTmp.Rows.Count > 0)
{
html = "";
Int64 tOriginalLength = 0;
Int64 tOptimizedLength = 0;
foreach (DataRow dr in dtTmp.Rows)
{
Int64 originalLength = (Int64)dr["originalLength"];
Int64 optimizedLength = (Int64)dr["optimizedLength"];
tOriginalLength += originalLength;
tOptimizedLength += optimizedLength;
double percent = 100F - (((double)optimizedLength / (double)originalLength) * 100F);
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + FileResources.formatData(originalLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(optimizedLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent, ChartDataType.Percent) + "</td></tr>";
}
if (html != "")
{
double percent2 = 100F - (((double)tOptimizedLength / (double)tOriginalLength) * 100F);
html += "<tr><td>Total de otimização a se realizar</td><td>" + FileResources.formatData(tOriginalLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(tOptimizedLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent2, ChartDataType.Percent) + "</td></tr>";
js.AppendLine("$('#optimization-table tbody').html('" + html + "');");
}
else
{
js.AppendLine("$('#optimization-table').remove();");
}
}
else
{
js.AppendLine("$('#optimization-table').remove();");
}
//Tabela de Não Otimização (Ou seja os objetos que ja estão otimizados)
dtTmp = db.selectNonOptimization(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
if (dtTmp.Rows.Count > 0)
{
html = "";
Int64 tOriginalLength = 0;
Int64 tNonOptimizedLength = 0;
foreach (DataRow dr in dtTmp.Rows)
{
Int64 originalLength = (Int64)dr["originalLength"];
Int64 nonOptimizedLength = (Int64)dr["nonOptimizedLength"];
tOriginalLength += originalLength;
tNonOptimizedLength += nonOptimizedLength;
double percent = 100F - (((double)originalLength / (double)nonOptimizedLength) * 100F);
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + FileResources.formatData(originalLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(nonOptimizedLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent, ChartDataType.Percent) + "</td></tr>";
}
if (html != "")
{
double percent2 = 100F - (((double)tOriginalLength / (double)tNonOptimizedLength) * 100F);
html += "<tr><td>Total de otimização existente</td><td>" + FileResources.formatData(tOriginalLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(tNonOptimizedLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent2, ChartDataType.Percent) + "</td></tr>";
js.AppendLine("$('#nonoptimization-table tbody').html('" + html + "');");
}
else
{
js.AppendLine("$('#nonoptimization-table').remove();");
}
}
else
{
js.AppendLine("$('#nonoptimization-table').remove();");
}
//Tabela de otimização GZIP/Deflate
dtTmp = db.selecGzipOptimization(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
if (dtTmp.Rows.Count > 0)
{
html = "";
Int64 tGzipLength = 0;
Int64 tContentLength = 0;
foreach (DataRow dr in dtTmp.Rows)
{
Int64 gzipLength = (Int64)dr["gzipLength"];
Int64 contentLength = (Int64)dr["contentLength"];
tGzipLength += gzipLength;
tContentLength += contentLength;
double percent = 100F - (((double)gzipLength / (double)contentLength) * 100F);
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + FileResources.formatData(contentLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(gzipLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent, ChartDataType.Percent) + "</td></tr>";
}
if (html != "")
{
double percent2 = 100F - (((double)tGzipLength / (double)tContentLength) * 100F);
html += "<tr><td>Total de compactação utilizada</td><td>" + FileResources.formatData(tContentLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(tGzipLength, ChartDataType.Bytes) + "</td><td>" + FileResources.formatData(percent2, ChartDataType.Percent) + "</td></tr>";
js.AppendLine("$('#gzip-table tbody').html('" + html + "');");
}
else
{
js.AppendLine("$('#gzip-table').remove();");
}
}
else
{
js.AppendLine("$('#gzip-table').remove();");
}
//
//Chart 1 (Usuários virtuais (VU) ativos)
labels.Clear();
values.Clear();
dtTmp = db.selectVUAndConnections(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
labels.Add("Início");
values.Add("0");
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["virtualusers"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data1 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#c1').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data1, null);");
//Chart 2 (Conexões TCP ativas)
labels.Clear();
values.Clear();
labels.Add("Início");
values.Add("0");
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["connections"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data2 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#c2').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data2, null);");
//Chart 3 (Requisições)
labels.Clear();
values.Clear();
dtTmp = db.selectRequests(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
labels.Add("Início");
values.Add("0");
Dictionary <String, Int64> dicErrors = new Dictionary <string, long>();
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["rps"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
//Preenche o dicionario de erros para ficar alinhado com o de requisicoes
if (!dicErrors.ContainsKey(date.ToString("HH:mm")))
{
dicErrors.Add(date.ToString("HH:mm"), 0);
}
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data3 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#c3').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data3, null);");
//Chart 4 (Errors)
labels.Clear();
values.Clear();
dtTmp = db.selectErrors(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
labels.Add("Início");
values.Add("0");
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["errors"];
if (dicErrors.ContainsKey(date.ToString("HH:mm")))
{
dicErrors[date.ToString("HH:mm")] = value;
}
else
{
dicErrors.Add(date.ToString("HH:mm"), 0);
}
}
foreach (String k in dicErrors.Keys)
{
labels.Add(k);
values.Add(dicErrors[k].ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data4 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#c4').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data4, null);");
//Chart 5 (Bandwidth (Mbps))
labels.Clear();
values.Clear();
dtTmp = db.selectThroughput(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
labels.Add("Início");
values.Add("0");
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["mbps"];
labels.Add(date.ToString("HH:mm"));
values.Add((value / 1024 / 1024).ToString());
//values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data5 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#c5').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data5, null);");
//Chart 6 (Tempo de resposta geral)
labels.Clear();
values.Clear();
dtTmp = db.selectResponseTime(enviroment.TestName, enviroment.dStart, enviroment.dEnd, null);
labels.Add("Início");
values.Add("0");
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["time"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data6 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#rp1').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data6, null);");
//Chart 7 (Tempo de resposta geral)
labels.Clear();
values.Clear();
dtTmp = db.selectResponseTime(enviroment.TestName, enviroment.dStart, enviroment.dEnd, enviroment.BaseUri);
labels.Add("Início");
values.Add("0");
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
date = DateTime.Parse(dr["dateg"].ToString());
value = (Int64)dr["time"];
labels.Add(date.ToString("HH:mm"));
values.Add(value.ToString());
}
date.AddMinutes(1);
labels.Add("Final");
values.Add("0");
js.AppendLine("var data7 = {");
js.AppendLine(" labels: ['" + String.Join("','", labels) + "'],");
js.AppendLine(" datasets: [");
js.AppendLine(" {");
js.AppendLine(" fillColor: \"rgba(151,187,205,0.5)\",");
js.AppendLine(" strokeColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointColor: \"rgba(151,187,205,1)\",");
js.AppendLine(" pointStrokeColor: \"#fff\",");
js.AppendLine(" data: [" + String.Join(",", values) + "]");
js.AppendLine(" }");
js.AppendLine(" ]");
js.AppendLine("}");
js.AppendLine("var theCanvas = $('#rp2').get(0);");
js.AppendLine("var ctx = theCanvas.getContext(\"2d\");");
js.AppendLine("var myNewChart = new Chart(ctx).Line(data7, null);");
//Chart 8 (Tempo de carga por conteúdo)
labels.Clear();
values.Clear();
dtTmp = db.selectContentTypeDistribution(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
value = (Int64)dr["qty"];
Int64 total = (Int64)dr["total"];
labels.Add(dr["contentType"].ToString() + ": " + value + " (" + ((Int64)(((double)value / (double)total) * 100)) + "%)");
values.Add(value.ToString());
}
js.AppendLine("var radar = new RGraph.Radar('ctd',[" + String.Join(",", values) + "])");
js.AppendLine(" .Set('strokestyle', 'black')");
js.AppendLine(" .Set('colors.alpha', 0.3)");
js.AppendLine(" .Set('colors', ['rgba(151,187,205,0.5)'])");
js.AppendLine(" .Set('labels', ['" + String.Join("','", labels) + "'])");
js.AppendLine(" .Set('labels.axes', '')");
js.AppendLine(" .Set('gutter.top', 35)");
js.AppendLine(" .Set('accumulative', true)");
js.AppendLine(" .Set('axes.color', 'rgba(0,0,0,0)')");
js.AppendLine(" .Set('background.circles.poly', true)");
js.AppendLine(" .Set('background.circles.spacing', 25)");
js.AppendLine(" .Draw();");
//Chart 9 (Tempo de carga por conteúdo)
labels.Clear();
values.Clear();
dtTmp = db.selectContentTypeTimeDistribution(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
value = (Int64)dr["time"];
Int64 total = (Int64)dr["total"];
labels.Add(dr["contentType"].ToString() + ": " + value + "ms (" + ((Int64)(((double)value / (double)total) * 100)) + "%)");
values.Add(value.ToString());
}
js.AppendLine("var radar = new RGraph.Radar('ctt',[" + String.Join(",", values) + "])");
js.AppendLine(" .Set('strokestyle', 'black')");
js.AppendLine(" .Set('colors.alpha', 0.3)");
js.AppendLine(" .Set('colors', ['rgba(151,187,205,0.5)'])");
js.AppendLine(" .Set('labels', ['" + String.Join("','", labels) + "'])");
js.AppendLine(" .Set('labels.axes', '')");
js.AppendLine(" .Set('gutter.top', 35)");
js.AppendLine(" .Set('accumulative', true)");
js.AppendLine(" .Set('axes.color', 'rgba(0,0,0,0)')");
js.AppendLine(" .Set('background.circles.poly', true)");
js.AppendLine(" .Set('background.circles.spacing', 25)");
js.AppendLine(" .Draw();");
//content-trafic
labels.Clear();
values.Clear();
dtTmp = db.selectContentTypeBytes(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
date = enviroment.dStart;
value = 0;
foreach (DataRow dr in dtTmp.Rows)
{
value = (Int64)dr["bytesReceived"];
Int64 total = (Int64)dr["total"];
labels.Add(dr["contentType"].ToString() + ": " + FileResources.formatData(value, ChartDataType.Bytes) + " (" + ((Int64)(((double)value / (double)total) * 100)) + "%)");
values.Add(value.ToString());
}
js.AppendLine("var radar = new RGraph.Radar('content-bytes',[" + String.Join(",", values) + "])");
js.AppendLine(" .Set('strokestyle', 'black')");
js.AppendLine(" .Set('colors.alpha', 0.3)");
js.AppendLine(" .Set('colors', ['rgba(151,187,205,0.5)'])");
js.AppendLine(" .Set('labels', ['" + String.Join("','", labels) + "'])");
js.AppendLine(" .Set('labels.axes', '')");
js.AppendLine(" .Set('gutter.top', 35)");
js.AppendLine(" .Set('accumulative', true)");
js.AppendLine(" .Set('axes.color', 'rgba(0,0,0,0)')");
js.AppendLine(" .Set('background.circles.poly', true)");
js.AppendLine(" .Set('background.circles.spacing', 25)");
js.AppendLine(" .Draw();");
//Table 1
dtTmp = db.selectTopHit(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
html = "";
foreach (DataRow dr in dtTmp.Rows)
{
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + dr["success"].ToString() + "</td><td>" + dr["error"].ToString() + "</td></tr>";
}
js.AppendLine("$('#dist-uri tbody').html('" + html + "');");
//Table 2
dtTmp = db.selectTopTime(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
html = "";
foreach (DataRow dr in dtTmp.Rows)
{
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + dr["contentType"].ToString() + "</td><td>" + dr["time"].ToString() + "</td></tr>";
}
js.AppendLine("$('#time-uri tbody').html('" + html + "');");
//Table 3
dtTmp = db.selectTopBytes(enviroment.TestName, enviroment.dStart, enviroment.dEnd);
html = "";
foreach (DataRow dr in dtTmp.Rows)
{
html += "<tr><td>" + dr["uri"].ToString() + "</td><td>" + dr["qty"].ToString() + "</td><td>" + FileResources.formatData((Int64)(dr["bytesReceived"]), ChartDataType.Bytes) + "</td></tr>";
}
js.AppendLine("$('#bytes-uri tbody').html('" + html + "');");
js.AppendLine("});");
File.WriteAllBytes(Path.Combine(jsDir.FullName, "loadtest.report.js"), Encoding.UTF8.GetBytes(js.ToString()));
db.Dispose();
//Espera para liberar o arquivo
//System.Threading.Thread.Sleep(5000);
//Gera o final
/*
* try
* {
* ZIPUtil.CompressToFile(tempDir, Path.Combine(reportDir.FullName, DateTime.Now.ToString("yyyyMMddHHmm") + ".zip"));
* }
* catch (Exception ex)
* {
* Console.WriteLine("Falha ao gerar o ZIP " + ex.Message);
*
* foreach (FileInfo f in tempDir.GetFiles())
* {
* try
* {
* f.CopyTo(Path.Combine(reportDir.FullName, f.Name), true);
* }
* catch (Exception ex1)
* {
* Console.WriteLine("Falha ao copiar o arquivo " + f.Name + ex1.Message);
* }
* }
*
* foreach (DirectoryInfo d in tempDir.GetDirectories())
* CopyTo(tempDir, d, reportDir);
* }*/
}