summaryrefslogtreecommitdiff
path: root/bin/db-update
diff options
context:
space:
mode:
authorAndreas Baumann <mail@andreasbaumann.cc>2018-05-03 17:41:40 +0000
committerAndreas Baumann <mail@andreasbaumann.cc>2018-05-03 17:41:40 +0000
commit8430ab734e78aa2ef93a9849ca85459250e774bf (patch)
tree794ff707459f88f915dcbe31827c4e009f230331 /bin/db-update
parent942531d3630ba90125b38142bdf2ae8d708e5017 (diff)
parent0bc88d347f7d5f3b4fc51e277c3e0489d34dfe04 (diff)
downloadbuilder-8430ab734e78aa2ef93a9849ca85459250e774bf.tar.xz
Merge branch 'master' into fixes
Diffstat (limited to 'bin/db-update')
-rwxr-xr-xbin/db-update6
1 files changed, 5 insertions, 1 deletions
diff --git a/bin/db-update b/bin/db-update
index 54d2f87..28e9861 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -12,6 +12,8 @@
# TODO: we should delete more packages than just the ones in repositories
# where we move to (think of [extra] -> [community])
+# TODO: enable separate repositories for each architecture
+
# shellcheck disable=SC2039
# shellcheck source=../conf/default.conf
. "${0%/*}/../conf/default.conf"
@@ -392,7 +394,9 @@ for source_stability in 'testing' 'staging'; do
printf ' JOIN `replaced_binary_packages` ON `binary_packages`.`id`=`replaced_binary_packages`.`id`;\n'
printf 'UPDATE `binary_packages`'
printf ' JOIN `moved_binary_packages` ON `binary_packages`.`id`=`moved_binary_packages`.`id`'
- printf ' SET `binary_packages`.`repository`=`moved_binary_packages`.`new_repository`;\n'
+ printf ' SET `binary_packages`.`repository`=`moved_binary_packages`.`new_repository`,'
+ printf ' `binary_packages`.`last_moved`=NOW()'
+ printf ' WHERE `binary_packages`.`repository`!=`moved_binary_packages`.`new_repository`;\n'
} | \
mysql_run_query
done