diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-12-15 08:51:31 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-12-15 08:51:31 +0000 |
| commit | b693d3e57dbf3fe0b533b5d23ad97fa8209d2d5f (patch) | |
| tree | a65e0092a7835f44844c5b3d784238139ce63662 | |
| parent | 6a0332bed20b7d5b990d9c127198b4da9b8c011d (diff) | |
| download | data-service-b693d3e57dbf3fe0b533b5d23ad97fa8209d2d5f.tar data-service-b693d3e57dbf3fe0b533b5d23ad97fa8209d2d5f.tar.gz | |
Improve select-builds-with-context-by-derivation-file-name
To find builds for equivalent derivations.
| -rw-r--r-- | guix-data-service/model/build.scm | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm index d1228b2..299cacd 100644 --- a/guix-data-service/model/build.scm +++ b/guix-data-service/model/build.scm @@ -140,7 +140,12 @@ INNER JOIN ORDER BY build_id, timestamp DESC ) AS latest_build_status ON latest_build_status.build_id = builds.id -WHERE builds.derivation_file_name = $1 +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 latest_build_status.timestamp DESC") (exec-query conn query (list derivation-file-name))) |