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