Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin/modify-package-state
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-02-16 11:14:03 +0100
committerErich Eckner <git@eckner.net>2018-02-16 11:14:03 +0100
commitd2e0ef2a558e27e07150f239d91e4c29ce822426 (patch)
treef11a28ba418ecd8fae69fa7fcd3bd6a2623a8dfd /bin/modify-package-state
parentd7a7e5cebf55c13ab3522e6ec17e11cba878da73 (diff)
bin/mysql-functions: mysql_join_*_* new
Diffstat (limited to 'bin/modify-package-state')
-rwxr-xr-xbin/modify-package-state21
1 files changed, 9 insertions, 12 deletions
diff --git a/bin/modify-package-state b/bin/modify-package-state
index b2d3133..b0ba53e 100755
--- a/bin/modify-package-state
+++ b/bin/modify-package-state
@@ -136,10 +136,9 @@ while read -r package reason; do
# shellcheck disable=SC2016
combiner=$(
printf '`binary_packages`'
- printf ' JOIN `%s` ON `%s`.`id`=`%s`.`%s`' \
- 'repositories' 'repositories' 'binary_packages' 'repository' \
- 'repository_stabilities' 'repository_stabilities' 'repositories' 'stability' \
- 'architectures' 'architectures' 'binary_packages' 'architecture'
+ mysql_join_binary_packages_repositories
+ mysql_join_repositories_repository_stabilities
+ mysql_join_binary_packages_architectures
)
# shellcheck disable=SC2016,SC2031
selector=$(
@@ -161,12 +160,11 @@ while read -r package reason; do
# shellcheck disable=SC2016
combiner=$(
printf '`build_assignments`'
- printf ' JOIN `%s` ON `%s`.`id`=`%s`.`%s`' \
- 'package_sources' 'package_sources' 'build_assignments' 'package_source' \
- 'upstream_repositories' 'upstream_repositories' 'package_sources' 'upstream_package_repository' \
- 'binary_packages' 'build_assignments' 'binary_packages' 'build_assignment' \
- 'repositories' 'repositories' 'binary_packages' 'repository' \
- 'repository_stabilities' 'repository_stabilities' 'repositories' 'stability'
+ mysql_join_build_assignments_package_sources
+ mysql_join_package_sources_upstream_repositories
+ mysql_join_build_assignments_binary_packages
+ mysql_join_binary_packages_repositories
+ mysql_join_repositories_repository_stabilities
)
# shellcheck disable=SC2016
selector=$(
@@ -238,8 +236,7 @@ while read -r package reason; do
printf 'UPDATE `binary_packages` AS `a`'
printf ' JOIN `binary_packages` AS `b`'
printf ' ON `a`.`build_assignment`=`b`.`build_assignment`'
- printf ' JOIN `repositories`'
- printf ' ON `b`.`repository`=`repositories`.`id`'
+ mysql_join_binary_packages_repositories 'b'
printf ' SET `b`.`is_tested`=1'
printf ' WHERE `a`.`is_tested`'
printf ' AND NOT `b`.`is_tested`'