From 156b7eea7e7d538e332d8cfcf482c5ebec0a25c0 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Tue, 10 Dec 2019 08:32:15 +0000 Subject: Improve the select-build-stats function Account for equivalent derivations, rather than counting them as unknown. --- guix-data-service/model/build.scm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'guix-data-service/model') diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm index ebdfd45..a5c535a 100644 --- a/guix-data-service/model/build.scm +++ b/guix-data-service/model/build.scm @@ -15,8 +15,10 @@ (define query " SELECT latest_build_status.status AS build_status, COUNT(*) -FROM derivations -LEFT JOIN builds ON builds.derivation_file_name = derivations.file_name +FROM derivation_output_details_sets +LEFT JOIN builds + ON builds.derivation_output_details_set_id = + derivation_output_details_sets.id LEFT JOIN ( SELECT DISTINCT ON (build_id) * -- cgit v1.2.3