| 1 | -- SQL invoked from regtest/aports-html.sh
|
| 2 |
|
| 3 | -- Attach the source databases
|
| 4 | attach database 'baseline/tables.db' as baseline;
|
| 5 | attach database 'osh-as-sh/tables.db' as osh_as_sh;
|
| 6 |
|
| 7 | -- TODO: rename diff_baseline -> failures
|
| 8 | create table diff_baseline as
|
| 9 | select
|
| 10 | b.pkg,
|
| 11 | cast(b.status as integer) as status1,
|
| 12 | b.elapsed_secs as baseline,
|
| 13 | cast('baseline/' || b.pkg_HREF as text) as baseline_HREF,
|
| 14 | cast(o.status as integer) as status2,
|
| 15 | o.elapsed_secs as osh_as_sh,
|
| 16 | cast('osh-as-sh/' || o.pkg_HREF as text) as osh_as_sh_HREF,
|
| 17 | cast('error' as text) as error_grep,
|
| 18 | cast(printf('error/%s.txt', b.pkg) as text) as error_grep_HREF,
|
| 19 | (b.status != o.status) as disagree,
|
| 20 | -- TODO: deprecate this field? It's nicer to compute this separately
|
| 21 | (b.status in (124, 143) or o.status in (124, 143)) as timeout
|
| 22 | from
|
| 23 | baseline.packages as b
|
| 24 | join osh_as_sh.packages as o on b.pkg = o.pkg
|
| 25 | where b.status != 0 or o.status != 0
|
| 26 | order by b.pkg;
|
| 27 |
|
| 28 | -- Create a table of the right shape
|
| 29 | -- 1 row for baseline, 1 row for osh-as-sh
|
| 30 | create table metrics as
|
| 31 | select
|
| 32 | cast('baseline' as text) as config,
|
| 33 | *
|
| 34 | from baseline.metrics;
|
| 35 |
|
| 36 | insert into metrics
|
| 37 | select
|
| 38 | cast('osh-as-sh' as text) as config,
|
| 39 | *
|
| 40 | from osh_as_sh.metrics;
|
| 41 |
|
| 42 | -- Detach databases
|
| 43 | detach database baseline;
|
| 44 | detach database osh_as_sh;
|