Overview
| Comment: | Minor tweak to rolled up status when INCOMPLETE |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | v1.60 |
| Files: | files | file ages | folders |
| SHA1: |
ed5669844faebbd8917f53e57c07dc4d |
| User & Date: | matt on 2015-09-01 23:56:53 |
| Other Links: | branch diff | manifest | tags |
Context
|
2015-09-02
| ||
| 18:40 | Fixed typo in sql stmt check-in: d975509ef3 user: mrwellan tags: v1.60 | |
|
2015-09-01
| ||
| 23:56 | Minor tweak to rolled up status when INCOMPLETE check-in: ed5669844f user: matt tags: v1.60 | |
| 21:59 | Added csv import back check-in: 9152525c34 user: matt tags: v1.60 | |
Changes
Modified db.scm from [1ddb64099f] to [43743ba72e].
| ︙ | ︙ | |||
2943 2944 2945 2946 2947 2948 2949 |
;; select state,status,count(state) from tests where run_id=59 AND testname='runfirst' group by state,status;
;;
'(top-test-set-per-pf-counts "UPDATE tests
SET state=CASE
WHEN (SELECT count(id) FROM tests
WHERE testname=?
AND item_path != ''
| | | | | 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 |
;; select state,status,count(state) from tests where run_id=59 AND testname='runfirst' group by state,status;
;;
'(top-test-set-per-pf-counts "UPDATE tests
SET state=CASE
WHEN (SELECT count(id) FROM tests
WHERE testname=?
AND item_path != ''
AND status NOT IN ('n/a')
AND state in ('NOT_STARTED')) > 0 THEN 'UNKNOWN'
WHEN (SELECT count(id) FROM tests
WHERE testname=?
AND item_path != ''
AND (status NOT IN ('TEN_STRIKES','BLOCKED') OR status IN ('INCOMPLETE'))
AND state in ('RUNNING','NOT_STARTED','LAUNCHED','REMOTEHOSTSTART')) > 0 THEN 'RUNNING'
WHEN (SELECT count(id) FROM tests
WHERE testname=?
AND item_path != ''
AND state != 'COMPLETED') = 0 THEN 'COMPLETED'
WHEN (SELECT count(id) FROM tests
WHERE testname=?
|
| ︙ | ︙ |