summaryrefslogtreecommitdiff
path: root/bin/why-dont-you
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2020-02-26 15:48:05 +0100
committerErich Eckner <git@eckner.net>2020-02-26 15:48:05 +0100
commit32c8c3c070a33c149c6297963c1159201d85e7fd (patch)
tree46c9982e510f1f65137a49e842800581ccc26be1 /bin/why-dont-you
parent12063e276f9d19e52a0f9fa5f7bafbd74a1b9ada (diff)
downloadbuilder-32c8c3c070a33c149c6297963c1159201d85e7fd.tar.xz
bin/why-dont-you: consider package_blobs, too
Diffstat (limited to 'bin/why-dont-you')
-rwxr-xr-xbin/why-dont-you41
1 files changed, 41 insertions, 0 deletions
diff --git a/bin/why-dont-you b/bin/why-dont-you
index e6a0deb..abe5c59 100755
--- a/bin/why-dont-you
+++ b/bin/why-dont-you
@@ -286,6 +286,47 @@ case "${action}" in
printf 'SELECT CONCAT('
printf '"\\"",'
printf '`sub_q`.`label`,'
+ printf '"\\" is glued to ",'
+ printf 'GROUP_CONCAT('
+ printf 'CONCAT('
+ printf '"\\"",'
+ printf '`sub_q`.`name`,'
+ printf '"\\""'
+ printf ')'
+ printf '),'
+ printf '" which must be moved simultanously"'
+ printf ') FROM ('
+ printf 'SELECT DISTINCT '
+ printf 'CONCAT(`architectures`.`name`,"/",`b_bp`.`pkgname`) AS `name`,'
+ printf '`bpirs`.`id`,'
+ printf 'CONCAT(`architectures`.`name`,"/",`binary_packages`.`pkgname`) AS `label`'
+ printf ' FROM `bpirs`'
+ printf ' JOIN `binary_packages_in_repositories`'
+ printf ' ON `binary_packages_in_repositories`.`id`=`bpirs`.`id`'
+ mysql_join_binary_packages_in_repositories_repositories
+ mysql_join_repositories_architectures
+ mysql_join_binary_packages_in_repositories_binary_packages
+ mysql_join_binary_packages_build_assignments
+ mysql_join_build_assignments_package_sources
+ printf ' JOIN `package_sources` AS `b_ps`'
+ printf ' ON UNIX_TIMESTAMP(`package_sources`.`commit_time`) - UNIX_TIMESTAMP(`b_ps`.`commit_time`) BETWEEN -10 AND 10'
+ printf ' AND `package_sources`.`commit_time`!="0000-00-00 00:00:00"'
+ printf ' AND `b_ps`.`commit_time`!="0000-00-00 00:00:00"'
+ mysql_join_package_sources_build_assignments 'b_ps' 'b_ba'
+ mysql_join_build_assignments_binary_packages 'b_ba' 'b_bp'
+ mysql_join_binary_packages_binary_packages_in_repositories 'b_bp' 'b_bpir'
+ mysql_join_binary_packages_in_repositories_repositories 'b_bpir' 'b_r'
+ printf ' AND `b_r`.`architecture`=`repositories`.`architecture`'
+ printf ' AND `repositories`.`stability`=`b_r`.`stability`'
+ printf ' LEFT JOIN `bpirs_2`'
+ printf ' ON `bpirs_2`.`id`=`b_bpir`.`id`'
+ printf ' WHERE `bpirs_2`.`id` IS NULL'
+ printf ') AS `sub_q`'
+ printf ' GROUP BY `sub_q`.`id`;\n'
+
+ printf 'SELECT CONCAT('
+ printf '"\\"",'
+ printf '`sub_q`.`label`,'
printf '"\\" depends on ",'
printf 'GROUP_CONCAT('
printf 'CONCAT('