Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-01-25 14:17:46 +0100
committerErich Eckner <git@eckner.net>2018-01-25 14:17:46 +0100
commit465e8e28815e405832a8e76435d314e054f4c73d (patch)
treefce50428117be0093b1e6e57ae69bf915278fae8 /bin/mysql-functions
parent3658074d4134c1ab5204704a0c2900c272bea7f9 (diff)
bin/mysql-functions: mysql_cleanup new
Diffstat (limited to 'bin/mysql-functions')
-rwxr-xr-xbin/mysql-functions34
1 files changed, 26 insertions, 8 deletions
diff --git a/bin/mysql-functions b/bin/mysql-functions
index a1b0527..0b6a5a1 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -2,7 +2,7 @@
# contains functions used to access mysql db
-# shellcheck disable=SC2039
+# shellcheck disable=SC2016,SC2039
if [ -z "${base_dir}" ]; then
# just to make shellcheck happy
@@ -24,7 +24,7 @@ base64_encode_each() {
# mysql_add_package_source $pkgbase $git_revision $mod_git_revision $upstream_package_repository
-# shellcheck disable=SC2016,SC2086
+# shellcheck disable=SC2086
mysql_add_package_source() {
local names='pkgbase git_revision mod_git_revision upstream_package_repository'
local values;
@@ -54,7 +54,7 @@ mysql_add_package_source() {
# mysql_add_binary_package $pkgbase $git_revision $mod_git_revision $upstream_package_repository $pkgname $sub_pkgrel $architecture $repository
-# shellcheck disable=SC2016,SC2031,SC2086,SC2154
+# 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
@@ -97,7 +97,7 @@ mysql_add_binary_package() {
# mysql_show_binary_package $pkgname $pkgver $pkgrel $sub_pkgrel
-# shellcheck disable=SC2016,SC2031,SC2086,SC2154
+# shellcheck disable=SC2031,SC2086,SC2154
mysql_show_binary_package() {
local names='pkgname pkgver pkgrel sub_pkgrel'
local name
@@ -153,7 +153,7 @@ mysql_show_binary_package() {
# mysql_add_install_target $install_target
-# shellcheck disable=SC2016,2086
+# shellcheck disable=2086
mysql_add_install_target() {
local install_target
install_target=$(
@@ -180,7 +180,6 @@ mysql_add_install_target() {
# if $sub_pkgrel should be forced and the package is currently in $current_repository
# generate the meta data of a package (dependencies, built packages, ...) in the database
-# shellcheck disable=SC2016
mysql_generate_package_metadata() {
( # new shell is intentional
@@ -619,7 +618,6 @@ mysql_sanity_check() {
sort > \
"${temp_dir}/master-mirror-listing"
- # shellcheck disable=SC2016
{
printf 'SELECT `repositories`.`name`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architectures`.`name`'
printf ' FROM `binary_packages`'
@@ -646,7 +644,6 @@ mysql_sanity_check() {
)
}
-# shellcheck disable=SC2016
mysql_find_build_assignment_loops() {
new_loops=$(
{
@@ -688,3 +685,24 @@ mysql_find_build_assignment_loops() {
} | \
${mysql_command}
}
+
+# mysql_cleanup
+# clean up left overs from mysql database
+mysql_cleanup() {
+ {
+ # remove failed_builds with unbroken build_assignments
+ printf 'DELETE `failed_builds` '
+ printf 'FROM `failed_builds` '
+ printf 'JOIN `build_assignments` '
+ printf 'ON `failed_builds`.`build_assignment`=`build_assignments`.`id` '
+ printf 'WHERE NOT `build_assignment`.`is_broken`;\n'
+ # remove failed_builds w/o build_assignment
+ printf 'DELETE FROM `failed_builds` '
+ printf 'WHERE NOT EXISTS '
+ printf '('
+ printf 'SELECT * FROM `build_assignments` '
+ printf 'WHERE `build_assignments`.`id`=`failed_builds`.`build_assignment`'
+ printf ');\n'
+ } | \
+ ${mysql_command}
+}