From 6a9286eedc3bb7034c4174d418a0bdd8cff69f69 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 27 Mar 2018 09:32:44 +0200
Subject: lib/mysql-functions: mysql_cleanup: remove obsolete file_providers
 and files, too

---
 lib/mysql-functions | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 129a20f..8e8217b 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -875,6 +875,23 @@ mysql_cleanup() {
     fi
     printf ' WHERE `build_slaves`.`currently_building` IS NOT NULL'
     printf ' AND TIMEDIFF(NOW(),`build_slaves`.`last_connection`) > "1:00:00";\n'
+    # remove obsolete file_providers
+    printf '%s FROM `file_providers`' \
+      "${operator}"
+    printf ' WHERE NOT EXISTS ('
+      printf 'SELECT * FROM `binary_packages`'
+      printf ' WHERE `binary_packages`.`id`=`file_providers`.`package`'
+    printf ') OR NOT EXISTS ('
+      printf 'SELECT * FROM `files`'
+      printf ' WHERE `files`.`id`=`file_providers`.`file`'
+    printf ');\n'
+    # remove obsolete files
+    printf '%s FROM `files`' \
+      "${operator}"
+    printf ' WHERE NOT EXISTS ('
+      printf 'SELECT * FROM `file_providers`'
+      printf ' WHERE `files`.`id`=`file_providers`.`file`'
+    printf ');\n'
   } | \
     mysql_run_query
 }
-- 
cgit v1.2.3