| 1 | select '<ul>';
|
| 2 | select printf('<li>Tasks: %d</li>', sum(num_tasks)) from metrics;
|
| 3 | select printf('<li><b>Elapsed Hours: %.1f</b></li>', sum(elapsed_minutes) / 60)
|
| 4 | from metrics;
|
| 5 | select '</ul>';
|
| 6 |
|
| 7 | create temporary view summary as
|
| 8 | select
|
| 9 | sum(
|
| 10 | case
|
| 11 | when config = 'baseline' then num_tasks
|
| 12 | else 0
|
| 13 | end
|
| 14 | ) as baseline_tasks,
|
| 15 | sum(
|
| 16 | case
|
| 17 | when config = 'baseline' then num_failures
|
| 18 | else 0
|
| 19 | end
|
| 20 | ) as baseline_failures,
|
| 21 | sum(
|
| 22 | case
|
| 23 | when config = 'osh-as-sh' then num_failures
|
| 24 | else 0
|
| 25 | end
|
| 26 | ) as osh_failures,
|
| 27 | sum(
|
| 28 | case
|
| 29 | when config = 'baseline' then num_apk
|
| 30 | else 0
|
| 31 | end
|
| 32 | ) as baseline_apk,
|
| 33 | sum(
|
| 34 | case
|
| 35 | when config = 'osh-as-sh' then num_apk
|
| 36 | else 0
|
| 37 | end
|
| 38 | ) as osh_apk
|
| 39 | from metrics;
|
| 40 |
|
| 41 | -- Task failures and packages produced
|
| 42 |
|
| 43 | select '<ul>';
|
| 44 |
|
| 45 | select printf('<li><code>APKBUILD</code> files: %d</li>', baseline_tasks)
|
| 46 | from summary;
|
| 47 |
|
| 48 | select
|
| 49 | printf(
|
| 50 | '<li>Baseline failures: %d (%.1f%%)</li>',
|
| 51 | baseline_failures,
|
| 52 | baseline_failures * 100.0 / baseline_tasks
|
| 53 | )
|
| 54 | from summary;
|
| 55 |
|
| 56 | select
|
| 57 | printf(
|
| 58 | '<li>osh-as-sh failures: %d (%.1f%%)</li>',
|
| 59 | osh_failures,
|
| 60 | osh_failures * 100.0 / baseline_tasks
|
| 61 | )
|
| 62 | from summary;
|
| 63 |
|
| 64 | select printf('<li>Baseline <code>.apk</code> built: %d</li>', baseline_apk)
|
| 65 | from summary;
|
| 66 | select printf('<li>osh-as-sh <code>.apk</code> built: %d</li>', osh_apk)
|
| 67 | from summary;
|
| 68 |
|
| 69 | select '</ul>';
|
| 70 |
|
| 71 | -- Disagreements
|
| 72 |
|
| 73 | select '<ul>';
|
| 74 | select printf('<li><b>Notable Disagreements: %d</b></li>', count(*))
|
| 75 | from notable_disagree;
|
| 76 |
|
| 77 | select printf('<li>Unique causes: %d</li>', count(distinct cause))
|
| 78 | from notable_disagree
|
| 79 | where cause != 'unknown';
|
| 80 |
|
| 81 | select
|
| 82 | printf('<li>Packages without a cause assigned (unknown): %s</li>', count(*))
|
| 83 | from notable_disagree
|
| 84 | where cause = 'unknown';
|
| 85 | select '</ul>';
|
| 86 |
|
| 87 | -- Other
|
| 88 |
|
| 89 | select '<ul>';
|
| 90 | select printf('<li>Other Failures: %d</li>', count(*)) from other_fail;
|
| 91 | select
|
| 92 | printf(
|
| 93 | '<li>Inconclusive result because of timeout (-124, -143): %d</li>',
|
| 94 | count(*)
|
| 95 | )
|
| 96 | from timeout
|
| 97 | where cause like 'signal-%';
|
| 98 | select '</ul>';
|