diff options
author | Erich Eckner <git@eckner.net> | 2020-02-26 15:48:05 +0100 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2020-02-26 15:48:05 +0100 |
commit | 32c8c3c070a33c149c6297963c1159201d85e7fd (patch) | |
tree | 46c9982e510f1f65137a49e842800581ccc26be1 /bin/why-dont-you | |
parent | 12063e276f9d19e52a0f9fa5f7bafbd74a1b9ada (diff) | |
download | builder-32c8c3c070a33c149c6297963c1159201d85e7fd.tar.xz |
bin/why-dont-you: consider package_blobs, too
Diffstat (limited to 'bin/why-dont-you')
-rwxr-xr-x | bin/why-dont-you | 41 |
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(' |