diff options
| -rw-r--r-- | guix-data-service/builds.scm | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/guix-data-service/builds.scm b/guix-data-service/builds.scm index 35a0c61..4fbc105 100644 --- a/guix-data-service/builds.scm +++ b/guix-data-service/builds.scm @@ -484,6 +484,23 @@ WHERE NOT EXISTS ( (string-join (map quote-string revision-commits) ",") ")")) " + UNION ALL + SELECT derivations_by_output_details_set.derivation_output_details_set_id + FROM channel_instances + INNER JOIN derivations_by_output_details_set + ON channel_instances.derivation_id = + derivations_by_output_details_set.derivation_id + INNER JOIN guix_revisions + ON guix_revisions.id = channel_instances.guix_revision_id +" + (if (null? revision-commits) + "" + (string-append + " + WHERE guix_revisions.commit IN (" + (string-join (map quote-string revision-commits) ",") + ")")) + " ) ORDER BY derivation_output_details_sets.id, derivation_output_details.id LIMIT 15000")) |