aboutsummaryrefslogtreecommitdiff
path: root/guix-data-service/model
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2019-12-15 10:36:42 +0000
committerChristopher Baines <mail@cbaines.net>2019-12-16 15:19:02 +0000
commit771b01ef805b21f9aae0efb21fe3515e81e2f4d5 (patch)
treeed27437e44b7d330ec034fd08e0f55a826ddcb1d /guix-data-service/model
parent308d1d710289fc954e8ac80ee1d2a8e47c5ae450 (diff)
downloaddata-service-771b01ef805b21f9aae0efb21fe3515e81e2f4d5.tar
data-service-771b01ef805b21f9aae0efb21fe3515e81e2f4d5.tar.gz
Link to the build pages from the derivation page
Diffstat (limited to 'guix-data-service/model')
-rw-r--r--guix-data-service/model/build.scm5
1 files changed, 3 insertions, 2 deletions
diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm
index 44fdc94..cf91acd 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -129,7 +129,8 @@ LIMIT 100"))
conn derivation-file-name)
(define query
"
-SELECT build_servers.url,
+SELECT build_servers.id,
+ build_servers.url,
latest_build_status.timestamp,
latest_build_status.status
FROM builds
@@ -140,7 +141,7 @@ INNER JOIN
FROM build_status
ORDER BY build_id, timestamp DESC
) AS latest_build_status
-ON latest_build_status.build_id = builds.id
+ ON latest_build_status.build_id = builds.id
INNER JOIN derivations_by_output_details_set
ON builds.derivation_output_details_set_id =
derivations_by_output_details_set.derivation_output_details_set_id