01/05: Remove a now redundant part of the maybe-delete-derivation query

[Christopher Baines]

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)))