[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
01/05: Remove a now redundant part of the maybe-delete-derivation query
From: |
Christopher Baines |
Subject: |
01/05: Remove a now redundant part of the maybe-delete-derivation query |
Date: |
Thu, 1 Oct 2020 14:16:44 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 3330f034a486a05ab1037c5ecc6814a0939ef441
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Wed Sep 30 20:34:33 2020 +0100
Remove a now redundant part of the maybe-delete-derivation query
As this is covered by the big query selecting the derivation ids.
---
guix-data-service/data-deletion.scm | 10 ----------
1 file changed, 10 deletions(-)
diff --git a/guix-data-service/data-deletion.scm
b/guix-data-service/data-deletion.scm
index 40a5bab..6c2ab78 100644
--- a/guix-data-service/data-deletion.scm
+++ b/guix-data-service/data-deletion.scm
@@ -313,16 +313,6 @@ AND NOT EXISTS (
FROM derivation_outputs
WHERE derivation_id = $1
)
-) AND NOT EXISTS (
- SELECT 1
- FROM package_derivations
- WHERE package_derivations.derivation_id = derivation_outputs.derivation_id
-) AND NOT EXISTS (
- SELECT 1 FROM channel_instances
- WHERE derivation_id = $1
-) AND NOT EXISTS (
- SELECT 1 FROM guix_revision_system_test_derivations
- WHERE derivation_id = $1
)
RETURNING derivation_outputs.derivation_output_details_id"
(list id)))