summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-14 16:19:31 +0200
committerErich Eckner <git@eckner.net>2018-05-14 16:19:31 +0200
commit6ab57ae83ccc30eade1c1ad069b18856571c339c (patch)
tree42a8f7887d82e4c903ee016c2327bde71320344b
parent2b57fa56eb328ca9e14718426be8029c0738ed63 (diff)
downloadbuilder-6ab57ae83ccc30eade1c1ad069b18856571c339c.tar.xz
bin/get-package-updates: set binary_packages_in_repositories.repository correctly at the end
-rwxr-xr-xbin/get-package-updates9
1 files changed, 8 insertions, 1 deletions
diff --git a/bin/get-package-updates b/bin/get-package-updates
index f20ee27..eb45ffd 100755
--- a/bin/get-package-updates
+++ b/bin/get-package-updates
@@ -592,7 +592,14 @@ echo 'Done - mark decisions as final.'
# move binary_packages from "to-be-decided" to "build-list"
printf 'UPDATE `binary_packages`'
mysql_join_binary_packages_repositories '' 'from_repo'
- printf ' SET `repository`=('
+ printf ' LEFT'
+ mysql_join_binary_packages_binary_packages_in_repositories
+ printf ' SET `binary_packages`.`repository`=('
+ printf 'SELECT `to_repo`.`id`'
+ printf ' FROM `repositories` AS `to_repo`'
+ printf ' WHERE `to_repo`.`name`="build-list"'
+ printf '),'
+ printf ' `binary_packages_in_repositories`.`repository`=('
printf 'SELECT `to_repo`.`id`'
printf ' FROM `repositories` AS `to_repo`'
printf ' WHERE `to_repo`.`name`="build-list"'