Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | In dashboard output, group outcomes by platform. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
76662698a8f10512ae18956d55ee02ff |
| User & Date: | drh 2019-08-14 17:19:22 |
Context
|
2019-08-15
| ||
| 16:12 | Update the change log and the SQLITE_ENABLE_STAT3 documentation. (check-in: 4c942f942c user: drh tags: trunk) | |
|
2019-08-14
| ||
| 17:19 | In dashboard output, group outcomes by platform. (check-in: 76662698a8 user: drh tags: trunk) | |
| 16:54 | Merge the test dashboard development line into trunk. (check-in: ed6e0d08a7 user: drh tags: trunk) | |
Changes
Changes to misc/dashboard.tcl.
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 |
common-header "Test Outcomes" olist
set now [db one {SELECT datetime('now')}]
wapp-trim {
<p>Test Outcomes As Of %html($now)</p>
}
wapp-subst {<ul>\n}
set last_srchash {}
set inner_close {}
db eval {SELECT status, testName, platform.name AS pname, srchash, srcdate,
datetime(srcdate) AS sdate,
datetime(max(outcome.mtime),'unixepoch') AS odate, report
FROM outcome, platform
WHERE outcome.mtime>CAST(strftime('%s','now','-1 month') AS INT)
AND platform.platformId=outcome.platformId
GROUP BY testName, srchash, outcome.platformId
ORDER BY srcdate DESC, outcome.mtime DESC, status DESC} {
if {$srchash!=$last_srchash} {
wapp-trim {
%unsafe($inner_close)
<li><a href='https://sqlite.org/src/timeline?c=%html($srchash)'>
%html%($sdate)% %html%([string range $srchash 0 16])%</a>
<ol>
}
set inner_close </ol></li>
set last_srchash $srchash
}
set clr black
switch $status {
fail {set clr red}
running {set clr gray}
ok -
pass {set clr green}
}
wapp-trim {
<li><span style='color:%html($clr);'>
<b>%html($status)</b> - %html($testName at $pname)
<small>(%html($odate))
}
if {[string length $report]} {
wapp-trim {- %html($report)}
}
wapp-trim {</small></span></li>}
}
wapp-trim {
%unsafe($inner_close)
</ul>
}
wapp-trim {
<script nonce='%html([wapp-param FOSSIL_NONCE])'>
setTimeout(function(){location.reload();},1000*60);
</script>
}
|
> | > > > | | > | > | > > > > > > > > > > > | | > |
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 |
common-header "Test Outcomes" olist
set now [db one {SELECT datetime('now')}]
wapp-trim {
<p>Test Outcomes As Of %html($now)</p>
}
wapp-subst {<ul>\n}
set last_srchash {}
set last_platform {}
set case_close {}
set platform_close {}
db eval {SELECT status, testName, platform.name AS pname, srchash, srcdate,
datetime(srcdate) AS sdate,
datetime(max(outcome.mtime),'unixepoch') AS odate, report
FROM outcome, platform
WHERE outcome.mtime>CAST(strftime('%s','now','-1 month') AS INT)
AND platform.platformId=outcome.platformId
AND (status<>'running' OR
outcome.mtime>CAST(strftime('%s','now','-4 hours') AS INT))
GROUP BY testName, srchash, outcome.platformId
ORDER BY srcdate DESC, pname, outcome.mtime DESC, status DESC} {
if {$srchash!=$last_srchash} {
wapp-trim {
%unsafe($case_close)
%unsafe($platform_close)
<li><a href='https://sqlite.org/src/timeline?c=%html($srchash)'>
%html%($sdate)% %html%([string range $srchash 0 16])%</a>
<ol type='A'>
}
set case_close {}
set platform_close </ol></li>
set last_srchash $srchash
set last_platform {}
}
if {$pname!=$last_platform} {
wapp-trim {
%unsafe($case_close)
<li>%html($pname)
<ol type='1'>
}
set case_close </ol></li>
set platform_close </ol></li>
set last_platform $pname
}
set clr black
switch $status {
fail {set clr red}
running {set clr gray}
ok -
pass {set clr green}
}
wapp-trim {
<li><span style='color:%html($clr);'>
<b>%html($status)</b> - %html($testName)
<small>(%html($odate))
}
if {[string length $report]} {
wapp-trim {- %html($report)}
}
wapp-trim {</small></span></li>}
}
wapp-trim {
%unsafe($case_close)
%unsafe($platform_close)
</ul>
}
wapp-trim {
<script nonce='%html([wapp-param FOSSIL_NONCE])'>
setTimeout(function(){location.reload();},1000*60);
</script>
}
|