From f271fb00686fdf51307bc038247ef155f90f7f3c Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 29 Mar 2018 15:59:25 +0200
Subject: conf/default.conf: put number of partitions into variable

---
 conf/default.conf   |  2 ++
 lib/mysql-functions | 11 ++++-------
 2 files changed, 6 insertions(+), 7 deletions(-)

diff --git a/conf/default.conf b/conf/default.conf
index efbb5b4..ec57a7c 100755
--- a/conf/default.conf
+++ b/conf/default.conf
@@ -34,6 +34,8 @@ master_build_server_identity="${work_dir}/.ssh/id_rsa"
 repo_key='0xdeadbeef'
 package_key='0x15eebadc0de'
 
+mysql_files_table_partitions=16
+
 # what can be done via the email interface
 possible_email_actions='stabilize block unblock schedule copy-to-build-support'
 
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 103dfe0..0625616 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -872,7 +872,7 @@ mysql_cleanup() {
     fi
     printf ' WHERE `build_slaves`.`currently_building` IS NULL'
     printf ' AND `build_slaves`.`logged_lines` IS NOT NULL;\n'
-    for partition in $(seq 0 15); do
+    for partition in $(seq 0 $((mysql_files_table_partitions-1))); do
       # remove obsolete file_providers
       printf '%s FROM `file_providers` PARTITION (p%s)' \
         "${operator}" "${partition}"
@@ -1160,9 +1160,6 @@ done
 mysql_insert_package_files_query() {
 
   local partition
-  local partitions_count
-
-  partitions_count=16
 
   if [ ! -r "$1" ]; then
     >&2 printf 'mysql_insert_package_files: File "%s" is not readable.\n' \
@@ -1189,7 +1186,7 @@ mysql_insert_package_files_query() {
   printf 'UPDATE `pkg_files` SET'
   printf ' `pkg_files`.`name_hash`=CAST(CONV(SUBSTR(SHA2(`pkg_files`.`name`,224),1,2),16,10) AS INT),'
   printf ' `pkg_files`.`absolute_name_hash`=SHA2(CONCAT(`pkg_files`.`path`,`pkg_files`.`name`),224);\n'
-  for partition in $(seq 0 $((partitions_count-1))); do
+  for partition in $(seq 0 $((mysql_files_table_partitions-1))); do
     printf 'INSERT IGNORE INTO `files` PARTITION (p%s) (`path`,`name`,`name_hash`,`absolute_name_hash`)' \
       "${partition}"
     printf ' SELECT '
@@ -1198,7 +1195,7 @@ mysql_insert_package_files_query() {
       sed 's/,$//'
     printf ' FROM `pkg_files`'
     printf ' WHERE `pkg_files`.`name_hash` MOD %s = %s;\n' \
-      "${partitions_count}" "${partition}"
+      "${mysql_files_table_partitions}" "${partition}"
     printf 'INSERT IGNORE INTO `file_providers` PARTITION (p%s) (`package`,`file`,`file_name_hash`)' \
       "${partition}"
     printf ' SELECT `binary_packages`.`id`,`files`.`id`,`files`.`name_hash` FROM `pkg_files`'
@@ -1231,7 +1228,7 @@ mysql_insert_package_files_query() {
     printf ' ON `files`.`name_hash`=`pkg_files`.`name_hash`'
     printf ' AND `files`.`absolute_name_hash`=`pkg_files`.`absolute_name_hash`'
     printf ' WHERE `pkg_files`.`name_hash` MOD %s = %s;\n' \
-      "${partitions_count}" "${partition}"
+      "${mysql_files_table_partitions}" "${partition}"
   done
 
 }
-- 
cgit v1.2.3