From e1e63232851ec8b1c343acced4ab8ebf72b9f5af Mon Sep 17 00:00:00 2001 From: Torsten Werner Date: Wed, 12 Jan 2011 20:43:14 +0000 Subject: [PATCH] Rename 2 sequences in database upgrade #41. Signed-off-by: Torsten Werner --- dak/dakdb/update41.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/dak/dakdb/update41.py b/dak/dakdb/update41.py index de24a523..338648fa 100755 --- a/dak/dakdb/update41.py +++ b/dak/dakdb/update41.py @@ -3,7 +3,7 @@ """ Remove useless type casts from primary keys to support sqlalchemy's -reflection mechanism for all tables. +reflection mechanism for all tables. Rename 2 sequences. @contact: Debian FTP Master @copyright: 2011 Torsten Werner @@ -33,7 +33,7 @@ from socket import gethostname; ################################################################################ def do_update(self): """ - Remove useless type casts from primary keys. + Remove useless type casts from primary keys and fix 2 sequences. """ print __doc__ try: @@ -46,6 +46,9 @@ def do_update(self): c.execute("ALTER TABLE %s ALTER id SET DEFAULT nextval('%s_id_seq'::regclass)" % \ (table, table)) + c.execute("ALTER SEQUENCE known_changes_id_seq RENAME TO changes_id_seq") + c.execute("ALTER SEQUENCE queue_files_id_seq RENAME TO build_queue_files_id_seq") + c.execute("UPDATE config SET value = '41' WHERE name = 'db_revision'") self.db.commit() -- 2.39.2