| 1 | -- Disagreements
|
| 2 |
|
| 3 | select '<table id="summary-table">';
|
| 4 |
|
| 5 | select
|
| 6 | printf(
|
| 7 | '<tr> <td><b>Elapsed Hours</b></td> <td class="num"><b>%.1f</b></td> </tr>',
|
| 8 | sum(elapsed_minutes) / 60
|
| 9 | )
|
| 10 | from metrics;
|
| 11 | select
|
| 12 | printf(
|
| 13 | '<tr> <td><b>Notable Disagreements</b></td> <td class="num"><b>%d</b></td> </tr>',
|
| 14 | count(*)
|
| 15 | )
|
| 16 | from notable_disagree;
|
| 17 | -- Tasks are redundant with APKBUILD files
|
| 18 | -- select printf('<tr>Tasks: %d</tr>', sum(num_tasks)) from metrics;
|
| 19 | select
|
| 20 | printf(
|
| 21 | '<tr> <td>Unique causes</td> <td class="num">%d</td> </tr>',
|
| 22 | count(distinct cause)
|
| 23 | )
|
| 24 | from notable_disagree
|
| 25 | where cause != 'unknown';
|
| 26 | select
|
| 27 | printf(
|
| 28 | '<tr> <td>Packages without a cause assigned (unknown)</td> <td class="num">%s</td> </tr>',
|
| 29 | count(*)
|
| 30 | )
|
| 31 | from notable_disagree
|
| 32 | where cause = 'unknown';
|
| 33 | select '</table>';
|
| 34 |
|
| 35 | select '<hr/>';
|
| 36 |
|
| 37 | -- Other
|
| 38 |
|
| 39 | -- select '<ul>';
|
| 40 | -- select printf('<li>Other Failures: %d</li>', count(*)) from other_fail;
|
| 41 | -- select
|
| 42 | -- printf(
|
| 43 | -- '<li>Inconclusive result because of timeout (-124, -143): %d</li>',
|
| 44 | -- count(*)
|
| 45 | -- )
|
| 46 | -- from timeout
|
| 47 | -- where cause like 'signal-%';
|
| 48 | -- select '</ul>';
|
| 49 |
|
| 50 | -- - Side by-side table
|
| 51 |
|
| 52 | create temporary view summary as
|
| 53 | select
|
| 54 | sum(
|
| 55 | case
|
| 56 | when config = 'baseline' then num_tasks
|
| 57 | else 0
|
| 58 | end
|
| 59 | ) as num_apkbuild,
|
| 60 | sum(
|
| 61 | case
|
| 62 | when config = 'baseline' then num_failures
|
| 63 | else 0
|
| 64 | end
|
| 65 | ) as baseline_failures,
|
| 66 | sum(
|
| 67 | case
|
| 68 | when config = 'osh-as-sh' then num_failures
|
| 69 | else 0
|
| 70 | end
|
| 71 | ) as osh_failures,
|
| 72 | sum(
|
| 73 | case
|
| 74 | when config = 'baseline' then num_timeouts
|
| 75 | else 0
|
| 76 | end
|
| 77 | ) as baseline_timeouts,
|
| 78 | sum(
|
| 79 | case
|
| 80 | when config = 'osh-as-sh' then num_timeouts
|
| 81 | else 0
|
| 82 | end
|
| 83 | ) as osh_timeouts,
|
| 84 | sum(
|
| 85 | case
|
| 86 | when config = 'baseline' then num_apk
|
| 87 | else 0
|
| 88 | end
|
| 89 | ) as baseline_apk,
|
| 90 | sum(
|
| 91 | case
|
| 92 | when config = 'osh-as-sh' then num_apk
|
| 93 | else 0
|
| 94 | end
|
| 95 | ) as osh_apk
|
| 96 | from metrics;
|
| 97 |
|
| 98 | -- Task failures and packages produced
|
| 99 |
|
| 100 | select '<table id="config-summary-table">';
|
| 101 | select '<thead>';
|
| 102 | select '<tr> <td></td> <td>baseline</td> <td>osh as sh</td> </tr>';
|
| 103 | select '</thead>';
|
| 104 |
|
| 105 | -- both sides work from the same APKBUILD
|
| 106 | select '<tr> <td> <code>APKBUILD</code> files</td>';
|
| 107 | select printf('<td class="num">%d</td>', num_apkbuild) from summary;
|
| 108 | select printf('<td class="num">%d</td>', num_apkbuild) from summary;
|
| 109 | select '</tr>';
|
| 110 |
|
| 111 | select '<tr> <td> <code>.apk</code> built </td>';
|
| 112 | select printf('<td class="num">%d</td>', baseline_apk)
|
| 113 | from summary;
|
| 114 | select printf('<td class="num">%d</td>', osh_apk)
|
| 115 | from summary;
|
| 116 | select '</tr>';
|
| 117 |
|
| 118 | select '<tr> <td>Failures</td>';
|
| 119 | select
|
| 120 | printf('<td class="num">%d</td>', baseline_failures)
|
| 121 | from summary;
|
| 122 | select
|
| 123 | printf('<td class="num">%d</td>', osh_failures)
|
| 124 | from summary;
|
| 125 | select '</tr>';
|
| 126 |
|
| 127 | select '<tr> <td></td>';
|
| 128 | select
|
| 129 | printf(
|
| 130 | '<td class="num">(%.1f%%)</td>',
|
| 131 | baseline_failures * 100.0 / num_apkbuild
|
| 132 | )
|
| 133 | from summary;
|
| 134 |
|
| 135 | select
|
| 136 | printf('<td class="num">(%.1f%%)</td>', osh_failures * 100.0 / num_apkbuild)
|
| 137 | from summary;
|
| 138 | select '</tr>';
|
| 139 |
|
| 140 | select '<tr> <td>Timeouts</td>';
|
| 141 | select
|
| 142 | printf('<td class="num">%d</td>', baseline_timeouts)
|
| 143 | from summary;
|
| 144 | select
|
| 145 | printf('<td class="num">%d</td>', osh_timeouts)
|
| 146 | from summary;
|
| 147 | select '</tr>';
|
| 148 |
|
| 149 | select '<tr> <td></td>';
|
| 150 | select
|
| 151 | printf(
|
| 152 | '<td class="num">(%.1f%%)</td>',
|
| 153 | baseline_timeouts * 100.0 / num_apkbuild
|
| 154 | )
|
| 155 | from summary;
|
| 156 |
|
| 157 | select
|
| 158 | printf('<td class="num">(%.1f%%)</td>', osh_timeouts * 100.0 / num_apkbuild)
|
| 159 | from summary;
|
| 160 | select '</tr>';
|
| 161 |
|
| 162 | select '</table>';
|