diff options
| -rwxr-xr-x | bin/reproducible_db_maintenance.py | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py index e8c6c609..c1ab6d20 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -251,6 +251,21 @@ schema_updates = { '''DROP TABLE stats_builds_per_day;''', '''ALTER TABLE stats_builds_per_day_tmp RENAME TO stats_builds_per_day;''', 'INSERT INTO rb_schema VALUES ("5", "' + now + '")'], + 6: [ # stats_builds_age needs (datum, suite) as primary key + '''CREATE TABLE stats_builds_age_tmp + (datum TEXT NOT NULL, + suite TEXT NOT NULL, + oldest_reproducible REAL, + oldest_unreproducible REAL, + oldest_FTBFS REAL, + PRIMARY KEY (datum, suite))''', + '''INSERT INTO stats_builds_age_tmp (datum, suite, + oldest_reproducible, oldest_unreproducible, oldest_FTBFS) + SELECT datum, suite, oldest_reproducible, oldest_unreproducible, + FTBFS FROM stats_builds_age;''', + '''DROP TABLE stats_builds_age;''', + '''ALTER TABLE stats_builds_age_tmp RENAME TO stats_builds_age;''', + 'INSERT INTO rb_schema VALUES ("6", "' + now + '")'], } |