From 95585e3dac27ffb9089fb5dafeb7b831d466743c Mon Sep 17 00:00:00 2001 From: Valerie R Young Date: Thu, 15 Sep 2016 11:36:29 -0400 Subject: reproducible Debian: add auto incrementing to postgres id columns This commit makes reproducible_db_maintence.py no longer compatible with a sqlite database. Sqlite primary key id fields automatically autoincrement. To copy this functionality to the new postgresql database, the table id columns must be altered using postgres specific commands. Signed-off-by: Holger Levsen --- bin/reproducible_db_maintenance.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'bin/reproducible_db_maintenance.py') diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py index aa53715d..bace9618 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -573,6 +573,24 @@ schema_updates = { '''DROP TABLE stats_meta_pkg_state;''', '''ALTER TABLE stats_meta_pkg_state_tmp RENAME TO stats_meta_pkg_state;''', "INSERT INTO rb_schema (version, date) VALUES (28, '" + now + "')"], + + # THE FOLLOWING UPDATE CAN ONLY BE PREFORMED ON POSTGRES DATABASE + + 29: [ # Add auto incrementing to the id columns of some tables + "CREATE SEQUENCE schedule_id_seq", + "ALTER TABLE schedule ALTER id SET DEFAULT NEXTVAL('schedule_id_seq')", + "CREATE SEQUENCE manual_scheduler_id_seq", + """ALTER TABLE manual_scheduler ALTER id SET DEFAULT + NEXTVAL('manual_scheduler_id_seq')""", + "CREATE SEQUENCE sources_id_seq", + "ALTER TABLE sources ALTER id SET DEFAULT NEXTVAL('sources_id_seq')", + "CREATE SEQUENCE stats_build_id_seq", + """ALTER TABLE stats_build ALTER id SET DEFAULT + NEXTVAL('stats_build_id_seq')""", + "CREATE SEQUENCE results_id_seq", + "ALTER TABLE results ALTER id SET DEFAULT NEXTVAL('results_id_seq')", + "INSERT INTO rb_schema (version, date) VALUES (29, '" + now + "')" + ], } -- cgit v1.2.3-54-g00ecf