bin/mysql-functions: mysql_join_*_* new

1 files changed, 3 insertions, 4 deletions

diff --git a/bin/prioritize-build-list b/bin/prioritize-build-list
index d611e79..e8dcf0a 100755
--- a/bin/prioritize-build-list
+++ b/bin/prioritize-build-list
@@ -32,10 +32,9 @@ fi
 # shellcheck disable=SC2016
 {
   printf 'UPDATE `build_assignments`'
-  printf ' JOIN `%s` ON `%s`.`%s`=`%s`.`id`' \
-    'package_sources' 'build_assignments' 'package_source'   'package_sources' \
-    'binary_packages' 'binary_packages'   'build_assignment' 'build_assignments' \
-    'repositories'    'binary_packages'   'repository'       'repositories'
+  mysql_join_build_assignments_package_sources
+  mysql_join_build_assignments_binary_packages
+  mysql_join_binary_packages_repositories
   printf ' SET `build_assignments`.`priority`=('
     printf 'SELECT COALESCE(MAX(`all_priorities`.`priority`),0)+1'
     printf ' FROM ('