From 32c8c3c070a33c149c6297963c1159201d85e7fd Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 26 Feb 2020 15:48:05 +0100
Subject: bin/why-dont-you: consider package_blobs, too

---
 bin/why-dont-you | 41 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)

(limited to 'bin/why-dont-you')

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
@@ -283,6 +283,47 @@ case "${action}" in
       printf '`bpirs`.`id`'
       printf ' FROM `bpirs`;\n'
 
+      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`,'
-- 
cgit v1.2.3-70-g09d2