branch master updated: Include blocked_builds information in comparison responses

[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 ab7df4c  Include blocked_builds information in comparison responses
ab7df4c is described below

commit ab7df4c6e55d3673f03bb0a266942d0c91662f93
Author: Christopher Baines <m...@cbaines.net>
AuthorDate: Mon Nov 14 09:24:49 2022 +0000

    Include blocked_builds information in comparison responses
    
    This will make it easier to tell when a scheduled build is yet to start, and
    can't start due to a missing dependency.
---
 guix-data-service/comparison.scm | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

diff --git a/guix-data-service/comparison.scm b/guix-data-service/comparison.scm
index 3eee5f7..4907357 100644
--- a/guix-data-service/comparison.scm
+++ b/guix-data-service/comparison.scm
@@ -340,7 +340,13 @@ SELECT base_packages.name, base_packages.version,
                'status',  latest_build_status.status,
                'timestamp',  latest_build_status.timestamp,
                'build_for_equivalent_derivation',
-               builds.derivation_file_name != base_packages.file_name
+               builds.derivation_file_name != base_packages.file_name,
+               'potentially_blocked', EXISTS (
+                  SELECT 1
+                  FROM blocked_builds
+                  WHERE blocked_derivation_output_details_set_id
+                         = builds.derivation_output_details_set_id
+               )
              )
              ORDER BY latest_build_status.timestamp
            )
@@ -365,7 +371,13 @@ SELECT base_packages.name, base_packages.version,
                'status',  latest_build_status.status,
                'timestamp',  latest_build_status.timestamp,
                'build_for_equivalent_derivation',
-               builds.derivation_file_name != target_packages.file_name
+               builds.derivation_file_name != target_packages.file_name,
+               'potentially_blocked', EXISTS (
+                  SELECT 1
+                  FROM blocked_builds
+                  WHERE blocked_derivation_output_details_set_id
+                         = builds.derivation_output_details_set_id
+               )
              )
              ORDER BY latest_build_status.timestamp
            )