summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_db_maintenance.py
diff options
context:
space:
mode:
authorHolger Levsen <holger@layer-acht.org>2015-03-14 19:45:07 +0100
committerHolger Levsen <holger@layer-acht.org>2015-03-14 19:45:07 +0100
commita8d1d541d1f5592f334294da14198c843446c111 (patch)
tree578fb4f028d459ec407bfd688720cd395bc63bc0 /bin/reproducible_db_maintenance.py
parent3ac2150e552a1f58caec4ce5efd184855d79114a (diff)
downloadjenkins.debian.net-a8d1d541d1f5592f334294da14198c843446c111.tar.xz
reproducible: rename 'sid' to 'unstable'
Diffstat (limited to 'bin/reproducible_db_maintenance.py')
-rwxr-xr-xbin/reproducible_db_maintenance.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 6014c449..7c41d516 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -330,6 +330,14 @@ schema_updates = {
'DROP TABLE stats_bugs',
'ALTER TABLE stats_bugs_tmp RENAME TO stats_bugs',
'INSERT INTO rb_schema VALUES ("8", "' + now + '")'],
+ 9: [ # rename "sid" to "unstable"
+ 'UPDATE sources SET suite = "unstable" WHERE suite = "sid"',
+ 'UPDATE stats_build SET suite = "unstable" WHERE suite = "sid"',
+ 'UPDATE stats_pkg_state SET suite = "unstable" WHERE suite = "sid"',
+ 'UPDATE stats_builds_per_day SET suite = "unstable" WHERE suite = "sid"',
+ 'UPDATE stats_builds_age SET suite = "unstable" WHERE suite = "sid"',
+ 'UPDATE stats_meta_pkg_state SET suite = "unstable" WHERE suite = "sid"',
+ 'INSERT INTO rb_schema VALUES ("9", "' + now + '")'],
}