[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
01/03: Show finished builds on the fixed output package derivations page
From: |
Christopher Baines |
Subject: |
01/03: Show finished builds on the fixed output package derivations page |
Date: |
Tue, 2 Feb 2021 18:39:34 -0500 (EST) |
cbaines pushed a commit to branch master
in repository data-service.
commit f868591d1c742886cb65e01c919db3b4a0900577
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Feb 2 19:37:35 2021 +0000
Show finished builds on the fixed output package derivations page
Rather than scheduled builds as well, as that's not useful information.
---
guix-data-service/model/derivation.scm | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/guix-data-service/model/derivation.scm
b/guix-data-service/model/derivation.scm
index f41f55c..12a752c 100644
--- a/guix-data-service/model/derivation.scm
+++ b/guix-data-service/model/derivation.scm
@@ -604,7 +604,7 @@ SELECT DISTINCT ON (derivations.file_name)
derivations.file_name,
(
CASE
- WHEN builds.id IS NULL THEN NULL
+ WHEN latest_build_status.status IS NULL THEN NULL
ELSE
json_build_object(
'build_server_id', builds.build_server_id,
@@ -627,6 +627,8 @@ LEFT JOIN builds
ON derivations.file_name = builds.derivation_file_name
LEFT JOIN latest_build_status
ON builds.id = latest_build_status.build_id
+ -- These are the two interesting states, so ignore builds in any other states
+ AND latest_build_status.status IN ('succeeded', 'failed')
WHERE derivation_output_details.hash IS NOT NULL"
(if after-derivation-file-name
"