summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-01-29 12:55:40 +0100
committerErich Eckner <git@eckner.net>2018-01-29 12:55:40 +0100
commit885ff8891a08146e02f3555a25739a535b9ccc23 (patch)
tree516b9c756cdb0943624c91abd0ec189c02fc41e7
parent7db1b9b1c1929e9cd6d178eed841e8f8c41b4925 (diff)
downloadbuilder-885ff8891a08146e02f3555a25739a535b9ccc23.tar.xz
bin/modify-package-state: update database, too
-rwxr-xr-xbin/modify-package-state85
1 files changed, 84 insertions, 1 deletions
diff --git a/bin/modify-package-state b/bin/modify-package-state
index 326a049..540b333 100755
--- a/bin/modify-package-state
+++ b/bin/modify-package-state
@@ -21,7 +21,7 @@ usage() {
[ -z "$1" ] && exit 1 || exit "$1"
}
-# TODO: update database accordingly!
+# TODO: binary packages should not be identified by revisions, but by versions
eval set -- "$(
getopt -o bfhntu \
@@ -156,6 +156,24 @@ fi
continue
fi
fi
+ repo=$(
+ printf '%s' "${package##*.}" | \
+ base64 -w0
+ )
+ pkgbase="${package%.*}"
+ mod_git_rev=$(
+ printf '%s' "${package##*.}" | \
+ base64 -w0
+ )
+ pkgbase="${pkgbase%.*}"
+ git_rev=$(
+ printf '%s' "${package##*.}" | \
+ base64 -w0
+ )
+ pkgbase=$(
+ printf '%s' "${package%.*}" | \
+ base64 -w0
+ )
if [ "${action}" = 'block' ] || \
[ "${action}" = 'unblock' ]; then
# these packages need to be on the build list
@@ -175,6 +193,22 @@ fi
else
echo "${reason}" > \
"${work_dir}/package-states/${package}.blocked"
+ # shellcheck disable=SC2016
+ {
+ printf 'UPDATE `build_assignments`'
+ printf ' JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id`'
+ printf ' JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`'
+ printf ' SET `build_assignments`.`is_blocked`=from_base64("%s")' \
+ "$(printf '%s' "${reason}" | base64 -w0)"
+ printf ' WHERE'
+ printf ' `package_sources`.`%s`=from_base64("%s") AND' \
+ 'pkgbase' "${pkgbase}" \
+ 'git_revision' "${git_rev}" \
+ 'mod_git_revision' "${mod_git_rev}"
+ printf ' `upstream_repositories`.`name`=from_base64("%s");\n' \
+ "${repo}"
+ } | \
+ ${mysql_command}
printf '%s %s\n' "${package}" "${reason}"
fi
;;
@@ -183,6 +217,23 @@ fi
mv \
"${work_dir}/package-states/${package}.tested" \
"${work_dir}/package-states/${package}.testing"
+ # shellcheck disable=SC2016
+ {
+ printf 'UPDATE `binary_packages`'
+ printf ' JOIN `%s` ON `%s`.`id`=`%s`.`%s`' \
+ 'build_assignments' 'build_assignments' 'binary_packages' 'build_assignment' \
+ 'package_sources' 'package_sources' 'build_assignments' 'package_source' \
+ 'upstream_repositories' 'upstream_repositories' 'package_sources' 'upstream_package_repository'
+ printf ' SET `binary_packages`.`has_issues`=1, `binary_packages`.`is_tested`=0'
+ printf ' WHERE'
+ printf ' `package_sources`.`%s`=from_base64("%s") AND' \
+ 'pkgbase' "${pkgbase}" \
+ 'git_revision' "${git_rev}" \
+ 'mod_git_revision' "${mod_git_rev}"
+ printf ' `upstream_repositories`.`name`=from_base64("%s");\n' \
+ "${repo}"
+ } | \
+ ${mysql_command}
printf '%s\n' "${package}"
fi
;;
@@ -192,12 +243,44 @@ fi
mv \
"${work_dir}/package-states/${package}.testing" \
"${work_dir}/package-states/${package}.tested"
+ # shellcheck disable=SC2016
+ {
+ printf 'UPDATE `binary_packages`'
+ printf ' JOIN `%s` ON `%s`.`id`=`%s`.`%s`' \
+ 'build_assignments' 'build_assignments' 'binary_packages' 'build_assignment' \
+ 'package_sources' 'package_sources' 'build_assignments' 'package_source' \
+ 'upstream_repositories' 'upstream_repositories' 'package_sources' 'upstream_package_repository'
+ printf ' SET `binary_packages`.`is_tested`=1'
+ printf ' WHERE'
+ printf ' `package_sources`.`%s`=from_base64("%s") AND' \
+ 'pkgbase' "${pkgbase}" \
+ 'git_revision' "${git_rev}" \
+ 'mod_git_revision' "${mod_git_rev}"
+ printf ' `upstream_repositories`.`name`=from_base64("%s");\n' \
+ "${repo}"
+ } | \
+ ${mysql_command}
printf '%s\n' "${package}"
fi
;;
'unblock')
if [ -f "${work_dir}/package-states/${package}.blocked" ]; then
rm "${work_dir}/package-states/${package}.blocked"
+ # shellcheck disable=SC2016
+ {
+ printf 'UPDATE `build_assignments`'
+ printf ' JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id`'
+ printf ' JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository`=`upstream_repositories`.`id`'
+ printf ' SET `build_assignments`.`is_blocked`=NULL'
+ printf ' WHERE'
+ printf ' `package_sources`.`%s`=from_base64("%s") AND' \
+ 'pkgbase' "${pkgbase}" \
+ 'git_revision' "${git_rev}" \
+ 'mod_git_revision' "${mod_git_rev}"
+ printf ' `upstream_repositories`.`name`=from_base64("%s");\n' \
+ "${repo}"
+ } | \
+ ${mysql_command}
printf '%s\n' "${package}"
fi
;;