Megatest

Check-in [f31ee1bcb7]
Login
Overview
Comment:Added reporting script. Made systems during config file loading switchable
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | rollup-runs
Files: files | file ages | folders
SHA1: f31ee1bcb75899273451b6ae372eddbb2deb8c76
User & Date: mrwellan on 2011-08-11 18:42:31
Other Links: branch diff | manifest | tags
Context
2011-08-23
12:53
Fixes to support full rollup of values check-in: d940f56993 user: mrwellan tags: rollup-runs
2011-08-11
18:42
Added reporting script. Made systems during config file loading switchable check-in: f31ee1bcb7 user: mrwellan tags: rollup-runs
17:06
Added ability to update the test meta data from the command line check-in: 8d90044094 user: mrwellan tags: rollup-runs
Changes

Added mkcsv.sh version [6c39fb52a9].











































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
#!/bin/sh

sqlite3 megatest.db <<EOF
create view all_tests as select 
    runname,RELEASE,DOTPROC,TECH,t.testname,description,
    item_path,t.state,t.status,
    attemptnum,final_logf,logdat,run_duration,r.comment,
    t.event_time,expected_value,value,tol,tol_perc,
    first_err,first_warn,tm.tags,
    r.owner,t.comment,
    author,tm.owner,reviewed,iterated,avg_runtime,
    diskfree,uname,rundir,avg_disk,t.tags,run_id,
    host,cpuload
 from tests as t inner join runs as r on t.run_id=r.id inner join test_meta as tm on tm.testname=t.testname;
.head on
.mode csv
.output "all-data.csv"
select * from all_tests;
drop view all_tests;
.q
EOF