summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
Diffstat (limited to 'lib')
-rwxr-xr-xlib/mysql-functions39
1 files changed, 0 insertions, 39 deletions
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