diff options
Diffstat (limited to 'lib')
| -rwxr-xr-x | lib/mysql-functions | 39 |
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 |