From bec9b3588a9cbe69c85646a6f708d61b8dbbe78f Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 30 May 2018 13:50:00 +0200
Subject: lib/mysql-functions: removed obsolete functions

---
 lib/mysql-functions | 39 ---------------------------------------
 1 file changed, 39 deletions(-)

(limited to 'lib/mysql-functions')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index e8c1cf0..8e295aa 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -916,25 +916,6 @@ mysql_package_name_query() {
   printf ')'
 }
 
-# TODO: delete mysql_repair_binary_packages_in_repositories when obsolete
-
-# mysql_repair_binary_packages_in_repositories
-# temporary function to keep binary_packages_in_repositories up-to-date
-mysql_repair_binary_packages_in_repositories() {
-  {
-    printf 'DELETE `binary_packages_in_repositories`'
-    printf ' FROM `binary_packages_in_repositories`'
-    printf ' LEFT JOIN `binary_packages`'
-    printf ' ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`'
-    printf ' WHERE `binary_packages`.`repository` != `binary_packages_in_repositories`.`repository`;\n'
-    printf 'COMMIT;\n'
-    printf 'INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`)'
-    printf ' SELECT `binary_packages`.`id`,`binary_packages`.`repository`'
-    printf ' FROM `binary_packages`;\n'
-  } | \
-    mysql_run_query
-}
-
 # mysql_join_*_*
 # print 'JOIN' part of mysql query to connect the respective tables
 # these functions take 2 optional arguments, acting as aliases for
@@ -1033,26 +1014,6 @@ for link in \
   mysql_join__generic "${table_b}" "${column_b}" "${table_a}" "${column_a}"
 done
 
-# mysql_show_binary_packages_in_repositories_issues
-# show issues of binary_packages_in_repositories
-mysql_show_binary_packages_in_repositories_issues() {
-  {
-    printf 'SELECT * FROM `binary_packages`'
-    printf ' WHERE NOT EXISTS ('
-      printf 'SELECT 1 FROM `binary_packages_in_repositories`'
-      printf ' WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`'
-      printf ' AND `binary_packages_in_repositories`.`repository`=`binary_packages`.`repository`'
-    printf ');\n'
-    printf 'SELECT * FROM `binary_packages_in_repositories`'
-    printf ' WHERE NOT EXISTS ('
-      printf 'SELECT 1 FROM `binary_packages`'
-      printf ' WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`'
-      printf ' AND `binary_packages_in_repositories`.`repository`=`binary_packages`.`repository`'
-    printf ');\n'
-  } | \
-    mysql_run_query
-}
-
 # mysql_retrieve_static_information
 # retrieve some static information from the database:
 # - ids of all known repositories -> $repository_ids__$arch_$repo
-- 
cgit v1.2.3-54-g00ecf