From 6bcf73307e3bad6488a2e36dbaeaea594df475c0 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Mon, 12 Mar 2018 08:57:23 +0100
Subject: lib/mysql-functions: remove unnecessary functions

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

(limited to 'lib')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index d87b79e..7a377d5 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -142,50 +142,6 @@ mysql_add_package_source() {
     mysql_run_query
 }
 
-# mysql_add_binary_package $pkgbase $git_revision $mod_git_revision $upstream_package_repository $pkgname $sub_pkgrel $architecture $repository
-
-# shellcheck disable=SC2031,SC2086,SC2154
-mysql_add_binary_package() {
-  local names='pkgbase git_revision mod_git_revision upstream_package_repository pkgname sub_pkgrel architecture repository'
-  local name
-  for name in ${names}; do
-    eval 'local '"${name}"
-    eval "${name}"'=$(
-      printf "%s" "$1" |
-        base64 -w0
-    )'
-    shift
-  done
-
-  {
-    printf 'INSERT IGNORE INTO binary_packages'
-    printf ' ('
-    printf '`%s`, ' 'sub_pkgrel' 'pkgname' 'package_source' 'repository' 'architecture' 'has_issues' 'is_tested' 'is_to_be_deleted'
-    printf ') SELECT'
-    printf ' from_base64("%s"), ' "${sub_pkgrel}" "${pkgname}"
-    printf ' `%s`.`id`,' 'package_sources' 'repositories' 'architectures'
-    printf ' 0, 0, 0'
-    printf ' FROM'
-    printf ' `%s` JOIN' 'package_sources' 'repositories' 'architectures'
-    printf ' `upstream_repositories` ON `package_sources`.`upstream_package_repository` = `upstream_repositories`.`id`'
-    printf ' WHERE'
-    printf ' `%s`.`name` = from_base64("%s") AND' \
-      'repositories' "${repository}" \
-      'architectures' "${architecture}"
-    printf ' `package_sources`.`%s` = from_base64("%s") AND' \
-      'pkgbase' "${pkgbase}" \
-      'git_revision' "${git_revision}" \
-      'mod_git_revision' "${mod_git_revision}"
-    printf ' `upstream_repositories`.`name` = from_base64("%s")' \
-      "${upstream_package_repository}"
-  } | \
-    sed '
-      s|, )|)|g
-      s|, FROM| FROM|g
-    ' | \
-    mysql_run_query
-}
-
 # mysql_show_binary_package $pkgname $pkgver $pkgrel $sub_pkgrel
 
 # shellcheck disable=SC2031,SC2086,SC2154
@@ -235,24 +191,6 @@ mysql_show_binary_package() {
     mysql_run_query --html --column-names
 }
 
-# mysql_add_install_target $install_target
-
-# shellcheck disable=2086
-mysql_add_install_target() {
-  local install_target
-  install_target=$(
-    printf "%s" "$1" | \
-      base64 -w0
-  )
-
-  {
-    printf 'INSERT IGNORE INTO `install_targets` (`name`)'
-    printf ' VALUES (from_base64("%s"))' \
-      "${install_target}"
-  } | \
-    mysql_run_query
-}
-
 # mysql_generate_package_metadata $current_repository $package $git_revision $mod_git_revision $repository
 # or
 # mysql_generate_package_metadata $current_repository $package.$git_revision.$mod_git_revision.$repository
-- 
cgit v1.2.3