diff options
author | Christopher Baines <mail@cbaines.net> | 2022-11-14 09:24:49 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2022-11-14 09:24:49 +0000 |
commit | ab7df4c6e55d3673f03bb0a266942d0c91662f93 (patch) | |
tree | 0d083beac4aa6bc1afd9c2a9b73aea64cfaf4731 | |
parent | 8294accffe948505f7da8e8b229ac11657197618 (diff) | |
download | data-service-ab7df4c6e55d3673f03bb0a266942d0c91662f93.tar data-service-ab7df4c6e55d3673f03bb0a266942d0c91662f93.tar.gz |
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.
-rw-r--r-- | guix-data-service/comparison.scm | 16 |
1 files 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 ) |