diff options
author | Christopher Baines <mail@cbaines.net> | 2020-10-13 19:32:42 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-10-13 19:35:40 +0100 |
commit | e273e220420f7f0351824fefb32d0c6c423e5dc3 (patch) | |
tree | ebb597a4f72383ba6c21a778543a96510cbc7540 /guix-data-service/model/package.scm | |
parent | 83884ed2ea4369d88b5a323333a6c78dbc471d24 (diff) | |
download | data-service-e273e220420f7f0351824fefb32d0c6c423e5dc3.tar data-service-e273e220420f7f0351824fefb32d0c6c423e5dc3.tar.gz |
Switch queries across to use latest_build_status
Diffstat (limited to 'guix-data-service/model/package.scm')
-rw-r--r-- | guix-data-service/model/package.scm | 12 |
1 files changed, 2 insertions, 10 deletions
diff --git a/guix-data-service/model/package.scm b/guix-data-service/model/package.scm index ef20253..113bd72 100644 --- a/guix-data-service/model/package.scm +++ b/guix-data-service/model/package.scm @@ -361,11 +361,7 @@ INNER JOIN derivations_by_output_details_set LEFT OUTER JOIN builds ON derivations_by_output_details_set.derivation_output_details_set_id = builds.derivation_output_details_set_id -LEFT OUTER JOIN ( - SELECT DISTINCT ON (build_id) * - FROM build_status - ORDER BY build_id, id DESC -) AS latest_build_status +LEFT OUTER JOIN latest_build_status ON builds.id = latest_build_status.build_id INNER JOIN guix_revisions AS first_guix_revisions ON first_guix_revision_id = first_guix_revisions.id @@ -493,11 +489,7 @@ FROM ( LEFT OUTER JOIN builds ON data2.derivation_output_details_set_id = builds.derivation_output_details_set_id -LEFT OUTER JOIN ( - SELECT DISTINCT ON (build_id) * - FROM build_status - ORDER BY build_id, id DESC -) AS latest_build_status +LEFT OUTER JOIN latest_build_status ON builds.id = latest_build_status.build_id GROUP BY 1, 2, 3, 4, 5, 6 ORDER BY first_datetime DESC, package_version DESC") |