branch master updated: Fix status in select-builds-with-context-by-derivation-file-name

[Christopher Baines]

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

cbaines pushed a commit to branch master
in repository data-service.

The following commit(s) were added to refs/heads/master by this push:
     new 89a3843  Fix status in 
select-builds-with-context-by-derivation-file-name
89a3843 is described below

commit 89a3843fa547de4589d8a5221d14dbe31976087c
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Mon Dec 21 17:38:18 2020 +0000

    Fix status in select-builds-with-context-by-derivation-file-name
    
    The latest_build_status table should be used, not build_status.
---
 guix-data-service/model/build.scm | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/guix-data-service/model/build.scm 
b/guix-data-service/model/build.scm
index a248f44..3041b67 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -201,19 +201,19 @@ SELECT DISTINCT ON (builds.id)
        build_servers.url,
        builds.build_server_build_id,
        builds.derivation_file_name,
-       build_status.timestamp,
-       build_status.status
+       latest_build_status.timestamp,
+       latest_build_status.status
 FROM builds
 INNER JOIN build_servers ON build_servers.id = builds.build_server_id
-INNER JOIN build_status
-  ON build_status.build_id = builds.id
+INNER JOIN latest_build_status
+  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
 INNER JOIN derivations
   ON derivations.id = derivations_by_output_details_set.derivation_id
 WHERE derivations.file_name = $1
-ORDER BY builds.id, build_status.timestamp DESC")
+ORDER BY builds.id, latest_build_status.timestamp DESC")
 
   (exec-query conn query (list derivation-file-name)))