[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
branch master updated: Have branches-by-package-version look at latest p
From: |
Christopher Baines |
Subject: |
branch master updated: Have branches-by-package-version look at latest processed revision |
Date: |
Mon, 15 Mar 2021 06:34:11 -0400 |
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 f47d337 Have branches-by-package-version look at latest processed
revision
f47d337 is described below
commit f47d337a7206b2bb12cf50f74cf5d480bde71302
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Mon Mar 15 10:29:36 2021 +0000
Have branches-by-package-version look at latest processed revision
This means branches aren't omitted if the latest commit hasn't been
processed
yet.
---
guix-data-service/model/package.scm | 26 ++++++++++++++++++++------
1 file changed, 20 insertions(+), 6 deletions(-)
diff --git a/guix-data-service/model/package.scm
b/guix-data-service/model/package.scm
index 82d8ef3..9583d43 100644
--- a/guix-data-service/model/package.scm
+++ b/guix-data-service/model/package.scm
@@ -539,7 +539,7 @@ ORDER BY first_datetime DESC, package_version DESC")
(define query
"
WITH branches AS (
- SELECT DISTINCT ON (git_repository_id, name) git_repository_id, name, commit
+ SELECT DISTINCT ON (git_repository_id, name) git_repository_id, name
FROM git_branches
WHERE commit <> ''
ORDER BY git_repository_id, name, datetime DESC
@@ -552,17 +552,31 @@ SELECT packages.version,
)
)
FROM branches
-INNER JOIN guix_revisions
- ON branches.git_repository_id = guix_revisions.git_repository_id
- AND branches.commit = guix_revisions.commit
+CROSS JOIN LATERAL (
+ SELECT guix_revisions.id
+ FROM git_branches
+ INNER JOIN guix_revisions
+ ON git_branches.commit = guix_revisions.commit
+ INNER JOIN load_new_guix_revision_jobs
+ ON load_new_guix_revision_jobs.commit = guix_revisions.commit
+ INNER JOIN load_new_guix_revision_job_events
+ ON job_id = load_new_guix_revision_jobs.id
+ WHERE guix_revisions.git_repository_id = branches.git_repository_id
+ AND git_branches.git_repository_id = branches.git_repository_id
+ AND git_branches.name = branches.name
+ AND load_new_guix_revision_job_events.event = 'success'
+ ORDER BY datetime DESC
+ LIMIT 1
+) AS latest_processed_guix_revision
INNER JOIN guix_revision_package_derivations
- ON guix_revision_package_derivations.revision_id = guix_revisions.id
+ ON guix_revision_package_derivations.revision_id =
+ latest_processed_guix_revision.id
INNER JOIN package_derivations
ON package_derivations.id =
guix_revision_package_derivations.package_derivation_id
AND package_derivations.system = $2
AND package_derivations.target = $3
INNER JOIN packages
- ON package_derivations.package_id = packages.id
+ ON package_derivations.package_id = packages.id
WHERE packages.name = $1
GROUP BY packages.version
ORDER BY packages.version DESC")
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- branch master updated: Have branches-by-package-version look at latest processed revision,
Christopher Baines <=