protected override void OnLoad (EventArgs e)
{
DBHost dbhost;
DBLane dblane;
base.OnLoad (e);
int page = 0;
int page_size = 0;
bool horizontal;
string action;
if (Authentication.IsInCookieRole (Request, MonkeyWrench.DataClasses.Logic.Roles.Administrator)) {
action = Request ["action"];
if (!string.IsNullOrEmpty (action)) {
switch (action) {
case "clearrevisions":
string revisions = Request ["revisions"];
int lane_id;
int host_id;
int revision_id;
try {
if (!int.TryParse (Request ["lane_id"], out lane_id))
throw new ValidationException ("Invalid lane_id");
if (!int.TryParse (Request ["host_id"], out host_id))
throw new ValidationException ("Invalid host_id");
foreach (string revision in revisions.Split (new char [] {';'}, StringSplitOptions.RemoveEmptyEntries)) {
if (!int.TryParse (revision.Replace ("revision_id_", ""), out revision_id))
throw new ValidationException ("Invalid revision_id: " + revision.ToString () + "(revisions: '" + revisions + "')");
Utils.LocalWebService.ClearRevision (Master.WebServiceLogin, lane_id, host_id, revision_id);
}
} catch (ValidationException ex) {
lblMessage.Text = ex.Message;
return;
}
Response.Redirect (string.Format ("ViewTable.aspx?lane_id={0}&host_id={1}", lane_id, host_id), false);
return;
}
}
}
int.TryParse (Request ["page"], out page);
int.TryParse (Request ["page_size"], out page_size);
if (page_size <= 0)
page_size = 20;
if (page < 0)
page = 0;
if (!bool.TryParse (Request ["horizontal"], out horizontal)) {
// Not specified. See if it's a cookie
if (Request.Cookies ["horizontal"] != null)
bool.TryParse (Request.Cookies ["horizontal"].Value, out horizontal);
}
Response.Cookies.Add (new HttpCookie ("horizontal", horizontal.ToString ()));
response = Utils.LocalWebService.GetViewTableData (Master.WebServiceLogin,
Utils.TryParseInt32 (Request ["lane_id"]), Request ["lane"],
Utils.TryParseInt32 (Request ["host_id"]), Request ["host"],
page, page_size);
if (response.Exception != null) {
if (response.Exception.HttpCode == 403) {
Master.RequestLogin ();
return;
}
lblMessage.Text = response.Exception.Message;
return;
}
dblane = response.Lane;
dbhost = response.Host;
this.header.InnerHtml = GenerateHeader (response, dblane, dbhost , horizontal);
this.buildtable.InnerHtml = GenerateLaneTable (response, dblane, dbhost, horizontal, page, page_size);
this.pager.InnerHtml = GeneratePager (response, dblane, dbhost, page, page_size);
}
public string GenerateLaneTable (GetViewTableDataResponse response, DBLane lane, DBHost host, bool horizontal, int page, int limit)
{
StringBuilder matrix = new StringBuilder ();
StringBuilder tooltip = new StringBuilder ();
bool new_revision = true;
int revision_id = 0;
List<DBRevisionWorkView> views = response.RevisionWorkViews;
List<List<TableNode>> table = new List<List<TableNode>> ();
List<TableNode> row = new List<TableNode> ();
List<TableNode> header = new List<TableNode> ();
for (int i = 0; i < views.Count; i++) {
while (header.Count <= views [i].sequence) {
header.Add (null);
}
if (header [views [i].sequence] != null)
continue;
var node = new TableNode (string.Format ("<a href='ViewWorkTable.aspx?lane_id={0}&host_id={1}&command_id={2}'>{3}</a>", lane.id, host.id, views [i].command_id, views [i].command));
node.command_id = views [i].command_id;
header [views [i].sequence] = node;
}
header.RemoveAll (delegate (TableNode match) { return match == null; });
header.Insert (0, new TableNode ("Revision", true));
header.Insert (1, new TableNode ("Diff", true));
header.Insert (2, new TableNode ("Author", true));
//if (Authentication.IsInRole (response, MonkeyWrench.DataClasses.Logic.Roles.Administrator)) {
// header.Insert (3, new TableNode ("Select", true));
//}
header.Add (new TableNode ("Host", true));
header.Add (new TableNode ("Duration", true));
table.Add (header);
bool failed = false;
double duration = 0;
for (int i = 0; i < views.Count; i++) {
DBRevisionWorkView view = views [i];
DBState revisionwork_state = (DBState) view.revisionwork_state;
DBState state = (DBState) view.state;
new_revision = revision_id != view.revision_id;
revision_id = view.revision_id;
if (new_revision) {
if (i > 0) {
table.Add (row);
row [row.Count - 1] = new TableNode (TimeSpan.FromSeconds (duration).ToString (), row [0].@class);
}
string revision = view.revision;
long dummy;
if (revision.Length > 16 && !long.TryParse (revision, out dummy))
revision = revision.Substring (0, 8);
string clazz = revisionwork_state.ToString ().ToLower ();
clazz = clazz + " " + DarkenColor (clazz, table.Count);
row = new List<TableNode> ();
tooltip.Length = 0;
tooltip.AppendFormat ("Author: {0}.", view.author);
if (view.starttime.Date.Year > 2000)
tooltip.AppendFormat (" Build start date: {0}.", view.starttime.ToUniversalTime ().ToString ("yyyy/MM/dd HH:mm:ss UTC"));
row.Add (new TableNode (string.Format ("<a href='ViewLane.aspx?lane_id={0}&host_id={1}&revision_id={2}' title='{4}'>{3}</a>", lane.id, host.id, view.revision_id, revision, tooltip.ToString ()), clazz));
row.Add (new TableNode (string.Format ("<a href='GetRevisionLog.aspx?id={0}'>diff</a>", view.revision_id)));
row.Add (new TableNode (view.author));
//if (Authentication.IsInRole (response, MonkeyWrench.DataClasses.Logic.Roles.Administrator))
// row.Add (new TableNode (string.Format ("<input type=checkbox id='id_revision_chk_{1}' name='revision_id_{0}' />", view.revision_id, i)));
while (row.Count < header.Count - 2)
row.Add (new TableNode ("-"));
row.Add (new TableNode (view.workhost ?? ""));
row.Add (new TableNode (""));
failed = false;
duration = 0;
}
if (view.endtime > view.starttime)
duration += (view.endtime - view.starttime).TotalSeconds;
if (state == DBState.Failed && !view.nonfatal)
failed = true;
else if (revisionwork_state == DBState.Failed)
failed = true;
// result
string result;
bool completed = true;
switch (state) {
case DBState.NotDone:
completed = false;
result = failed ? "skipped" : "queued"; break;
case DBState.Executing:
completed = false;
result = "running"; break;
case DBState.Failed:
result = view.nonfatal ? "issues" : "failure"; break;
case DBState.Success:
result = "success"; break;
case DBState.Aborted:
result = "aborted"; break;
case DBState.Timeout:
result = "timeout"; break;
case DBState.Paused:
completed = false;
result = "paused"; break;
case DBState.Ignore:
completed = false;
result = "ignore"; break;
default:
completed = true;
result = "unknown"; break;
}
for (int j = 2; j < header.Count; j++) {
if (header [j].command_id == view.command_id) {
if (completed) {
row [j] = new TableNode (string.Format ("<a href='{0}'>{1}</a>", Utilities.CreateWebServiceDownloadUrl (Request, view.id, view.command + ".log", true), result));
} else {
row [j] = new TableNode (result);
}
row [j].@class = result + " " + DarkenColor (result, table.Count);
break;
}
}
}
table.Add (row);
row [row.Count - 1] = new TableNode (TimeSpan.FromSeconds (duration).ToString (), row [0].@class);
matrix.AppendLine ("<table class='buildstatus'>");
if (horizontal) {
for (int i = 0; i < header.Count; i++) {
matrix.Append ("<tr>");
for (int j = 0; j < table.Count; j++) {
TableNode node = table [j] [i];
string td = node.is_header ? "th" : "td";
matrix.Append ('<');
matrix.Append (td);
if (node.@class != null) {
matrix.Append (" class='");
matrix.Append (node.@class);
matrix.Append ("'");
}
/*
if (node.style != null) {
matrix.Append (" style='");
matrix.Append (node.style);
matrix.Append ("'");
}*/
matrix.Append (">");
matrix.Append (node.text);
matrix.Append ("</");
matrix.Append (td);
matrix.Append (">");
}
matrix.AppendLine ("</tr>");
}
} else {
for (int i = 0; i < table.Count; i++) {
matrix.Append ("<tr>");
for (int j = 0; j < row.Count; j++) {
TableNode node = table [i] [j];
string td = node.is_header ? "th" : "td";
matrix.Append ('<');
matrix.Append (td);
if (node.@class != null) {
matrix.Append (" class='");
matrix.Append (node.@class);
matrix.Append ("'");
}
/*
if (node.style != null) {
matrix.Append (" style='");
matrix.Append (node.style);
matrix.Append ("'");
}*/
matrix.Append (">");
matrix.Append (node.text);
matrix.Append ("</");
matrix.Append (td);
matrix.Append (">");
}
matrix.AppendLine ("</tr>");
}
}
matrix.AppendLine ("</table>");
return matrix.ToString ();
}
public string GenerateHeader (GetViewTableDataResponse response, DBLane lane, DBHost host, bool horizontal)
{
string result;
string format;
string disabled_msg = string.Empty;
if (!response.Enabled)
disabled_msg = " (Disabled)";
if (Authentication.IsInRole (response, MonkeyWrench.DataClasses.Logic.Roles.Administrator)) {
format = @"<h2>Build Matrix for <a href='EditLane.aspx?lane_id={0}'>'{2}'</a> on <a href='EditHost.aspx?host_id={5}'>'{4}'</a>{6}</h2><br/>";
} else {
format = @"<h2>Build Matrix for '{2}' on '{4}'{6}</h2><br/>";
}
format += @"<a href='ViewTable.aspx?lane_id={0}&host_id={1}&horizontal={3}'>Reverse x/y axis</a><br/>";
if (Authentication.IsInRole (response, MonkeyWrench.DataClasses.Logic.Roles.Administrator))
format += string.Format (@"<a href='javascript:clearRevisions ({0}, {1})'>Clear selected revisions</a><br/>", lane.id, host.id);
format += "<br/>";
result = string.Format (format, lane.id, host.id, lane.lane, horizontal ? "false" : "true", host.host, host.id, disabled_msg);
return result;
}
public string GeneratePager (GetViewTableDataResponse response, DBLane lane, DBHost host, int page, int limit)
{
StringBuilder pager = new StringBuilder ();
int total = response.Count;
int pages = total / limit;
if (total % limit != 0)
pages++;
Console.WriteLine ("Pages: {0} total: {1}", pages, total);
if (page > pages - 1)
page = pages - 1;
int range = 5;
pager.AppendFormat ("<p> Page ");
if (pages < (range * 2)) {
for (int i = 0; i < pages; i++) {
pager.Append (GeneratePageLink (host.id, lane.id, i + 1, limit));
}
} else {
if (page <= (range + 1)) {
for (int i = 0; i < (page + range); i++) {
if (page == i)
pager.Append (string.Format ("<b>{0}</b>", i + 1));
else
pager.Append (GeneratePageLink (host.id, lane.id, i + 1, limit));
}
pager.AppendFormat ("...");
pager.Append (GeneratePageLink (host.id, lane.id, pages - 2, limit));
pager.Append (GeneratePageLink (host.id, lane.id, pages - 1, limit));
} else if (page > (pages - range - 4)) {
pager.Append (GeneratePageLink (host.id, lane.id, 1, limit));
pager.Append (GeneratePageLink (host.id, lane.id, 2, limit));
pager.AppendFormat ("...");
for (int i = page - range; i < pages; i++) {
if (page == i)
pager.Append (string.Format ("<b>{0}</b>", i + 1));
else
pager.Append (GeneratePageLink (host.id, lane.id, i + 1, limit));
}
} else {
pager.Append (GeneratePageLink (host.id, lane.id, 1, limit));
pager.Append (GeneratePageLink (host.id, lane.id, 2, limit));
pager.AppendFormat ("...");
for (int i = page - range; i < page + range; i++) {
if (page == i)
pager.Append (string.Format ("<b>{0}</b>", i + 1));
else
pager.Append (GeneratePageLink (host.id, lane.id, i + 1, limit));
}
pager.AppendFormat ("...");
pager.Append (GeneratePageLink (host.id, lane.id, pages - 2, limit));
pager.Append (GeneratePageLink (host.id, lane.id, pages - 1, limit));
}
}
pager.AppendFormat ("</p>");
return pager.ToString ();
}
public GetViewTableDataResponse GetViewTableData (WebServiceLogin login, int? lane_id, string lane, int? host_id, string host, int page, int page_size)
{
GetViewTableDataResponse response = new GetViewTableDataResponse ();
using (DB db = new DB ()) {
Authenticate (db, login, response);
response.Lane = FindLane (db, lane_id, lane);
response.Host = FindHost (db, host_id, host);
response.Count = DBRevisionWork_Extensions.GetCount (db, response.Lane.id, response.Host.id);
response.Page = page;
response.PageSize = page_size;
response.RevisionWorkViews = DBRevisionWorkView_Extensions.Query (db, response.Lane, response.Host, response.PageSize, response.Page);
var hl = db.GetHostLane (response.Host.id, response.Lane.id);
if (hl != null)
response.Enabled = hl.enabled;
}
return response;
}
public string GenerateLaneTable (GetViewTableDataResponse response, DBLane lane, DBHost host, bool horizontal, int page, int limit)
{
StringBuilder matrix = new StringBuilder ();
DateTime beginning = new DateTime (2001, 1, 1, 0, 0, 0);
bool new_revision = true;
int revision_id = 0;
int result_index;
List<DBRevisionWorkView> views = response.RevisionWorkViews;
List<List<string>> table = new List<List<string>> ();
List<string> row = new List<string> ();
List<string> header = new List<string> ();
List<string> header_classes = new List<string> ();
try {
for (int i = 0; i < views.Count; i++) {
while (header.Count <= views [i].sequence) {
header.Add (null);
}
if (header [views [i].sequence] != null)
continue;
header [views [i].sequence] = string.Format ("<a href='ViewWorkTable.aspx?lane_id={0}&host_id={1}&command_id={2}'>{3}</a>", lane.id, host.id, views [i].command_id, views [i].command);
}
header.RemoveAll (delegate (string match) { return match == null; });
header.Insert (0, "Revision");
header.Insert (1, "Author");
if (Utils.IsInRole (MonkeyWrench.DataClasses.Logic.Roles.Administrator))
header.Insert (2, "Select");
header.Add ("Host");
header.Add ("Duration");
result_index = Utils.IsInRole (MonkeyWrench.DataClasses.Logic.Roles.Administrator) ? 3 : 2;
table.Add (header);
bool failed = false;
double duration = 0;
for (int i = 0; i < views.Count; i++) {
DBRevisionWorkView view = views [i];
DBState revisionwork_state = (DBState) view.revisionwork_state;
DBState state = (DBState) view.state;
new_revision = revision_id != view.revision_id;
revision_id = view.revision_id;
if (new_revision) {
if (i > 0) {
// matrix.AppendLine ("</tr>");
table.Add (row);
row [row.Count - 1] = TimeSpan.FromSeconds (duration).ToString ();
}
string revision = view.revision;
long dummy;
if (revision.Length > 16 && !long.TryParse (revision, out dummy))
revision = revision.Substring (0, 8);
row = new List<string> ();
row.Add (string.Format ("<a href='ViewLane.aspx?lane_id={0}&host_id={1}&revision_id={2}' title='{4}'>{3}</a></td>", lane.id, host.id, view.revision_id, revision, string.Format ("Author: {1} Build start date: {0}", view.starttime.ToUniversalTime ().ToString ("yyyy/MM/dd HH:mm:ss UTC"), view.author)));
row.Add (string.Format ("<a href='GetRevisionLog.aspx?id={0}'>{1}</a></td>", view.revision_id, view.author));
if (Utils.IsInRole (MonkeyWrench.DataClasses.Logic.Roles.Administrator))
row.Add (string.Format ("<input type=checkbox id='id_revision_chk_{1}' name='revision_id_{0}' />", view.revision_id, i));
while (row.Count < header.Count - 2)
row.Add ("-");
row.Add (view.workhost ?? "");
row.Add ("");
header_classes.Add (revisionwork_state.ToString ().ToLower ());
failed = false;
duration = 0;
}
if (view.endtime > view.starttime)
duration += (view.endtime - view.starttime).TotalSeconds;
if (state == DBState.Failed && !view.nonfatal)
failed = true;
// result
string result;
switch (state) {
case DBState.NotDone:
result = failed ? "skipped" : "queued"; break;
case DBState.Executing:
result = "running"; break;
case DBState.Failed:
result = view.nonfatal ? "issues" : "failure"; break;
case DBState.Success:
result = "success"; break;
case DBState.Aborted:
result = "aborted"; break;
case DBState.Timeout:
result = "timeout"; break;
case DBState.Paused:
result = "paused"; break;
default:
result = "unknown"; break;
}
for (int j = 2; j < header.Count; j++) {
if (header [j].Contains (view.command)) {
row [j] = result;
break;
}
}
}
table.Add (row);
row [row.Count - 1] = TimeSpan.FromSeconds (duration).ToString ();
matrix.AppendLine ("<table class='buildstatus'>");
if (horizontal) {
for (int i = 0; i < header.Count; i++) {
matrix.Append ("<tr>");
for (int j = 0; j < table.Count; j++) {
string td = j == 0 ? "th" : "td";
if ((i == 0 || i == row.Count - 1) && j > 0) {
if (i == row.Count - 1) {
matrix.AppendFormat ("<{0} class='{1}' style='white-space: nowrap;'>", td, header_classes [j - 1]);
} else {
matrix.AppendFormat ("<{0} class='{1}'>", td, header_classes [j - 1]);
}
} else if (i >= result_index && j > 1) {
matrix.AppendFormat ("<{0} class='{1}'>", td, table [j] [i]);
} else {
matrix.AppendFormat ("<{0}>", td);
}
matrix.AppendFormat (table [j] [i]);
matrix.AppendFormat ("</{0}>", td);
}
matrix.AppendLine ("</tr>");
}
} else {
for (int i = 0; i < table.Count; i++) {
row = table [i];
matrix.Append ("<tr>\n");
for (int j = 0; j < row.Count; j++) {
string td = j == 0 ? "th" : "td";
if ((j == 0 || j == row.Count - 1) & i > 0) {
if (j == row.Count - 1) {
matrix.AppendFormat ("\t<{0} class='{1}' style='white-space: nowrap;'>", td, header_classes [i - 1]);
} else {
matrix.AppendFormat ("\t<{0} class='{1}'>", td, header_classes [i - 1]);
}
} else if (j >= result_index && row [j] != "-" && i > 0) {
matrix.AppendFormat ("\t<{0} class='{1}'>", td, row [j]);
} else {
matrix.AppendFormat ("\t<{0}>", td);
}
matrix.AppendFormat (row [j]);
matrix.AppendFormat ("</{0}>\n", td);
}
matrix.AppendLine ("</tr>");
}
}
matrix.AppendLine ("</table>");
} catch (Exception ex) {
matrix.Append (ex.ToString ().Replace ("\n", "</br>"));
}
return matrix.ToString ();
}