branch master updated: Fix DELETE query in delete-revisions-from-branch

[Christopher Baines]

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 754f647  Fix DELETE query in delete-revisions-from-branch
754f647 is described below

commit 754f64718f23a73ca5878eae81f541e72b42027d
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Thu Jun 16 12:38:51 2022 +0100

    Fix DELETE query in delete-revisions-from-branch
---
 guix-data-service/data-deletion.scm | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/guix-data-service/data-deletion.scm 
b/guix-data-service/data-deletion.scm
index 5ade50f..7e319c7 100644
--- a/guix-data-service/data-deletion.scm
+++ b/guix-data-service/data-deletion.scm
@@ -212,8 +212,12 @@ WHERE id IN (
       conn
       "
 DELETE FROM package_derivations_by_guix_revision_range
-WHERE git_repository_id = $1 AND
-      branch_name = $2"
+WHERE git_branch_id IN (
+  SELECT id
+  FROM git_branches
+  WHERE git_repository_id = $1 AND
+        name = $2
+)"
       (list (number->string git-repository-id)
             branch-name))