branch master updated: database: Exclude failed dependency builds from percentage.

[Mathieu Othacehe]

This is an automated email from the git hooks/post-receive script.

mothacehe pushed a commit to branch master
in repository guix-cuirass.

The following commit(s) were added to refs/heads/master by this push:
     new 258eb45  database: Exclude failed dependency builds from percentage.
258eb45 is described below

commit 258eb45e755ff7dea1c187b9767ee8077f3b471c
Author: Mathieu Othacehe <othacehe@gnu.org>
AuthorDate: Thu Jun 3 19:30:26 2021 +0200

    database: Exclude failed dependency builds from percentage.
    
    * src/cuirass/database.scm (db-get-build-percentages): Do not consider
    failed-dependency builds that have zero build durations.
---
 src/cuirass/database.scm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/cuirass/database.scm b/src/cuirass/database.scm
index fc4f106..6b51165 100644
--- a/src/cuirass/database.scm
+++ b/src/cuirass/database.scm
@@ -677,7 +677,7 @@ FROM (SELECT  DISTINCT ON (b1.id) b1.id AS id,
 COALESCE((b2.stoptime - b2.starttime), 0) AS last_duration,
 (extract(epoch from now())::int - b1.starttime) AS duration FROM builds AS b1
 LEFT JOIN builds AS b2 ON b1.job_name = b2.job_name
-AND b2.status >= 0 WHERE b1.id IN
+AND b2.status = 0 OR b2.status = 1 WHERE b1.id IN
 (SELECT id FROM builds WHERE id = ANY(" build-ids "))
 ORDER BY b1.id,  b2.id DESC) d;"))
                (percentages '()))