X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fupdate_db.py;h=d4aefe24c93b64b8404835f77e98a9cdf0c5dd85;hb=af486e867c2809515c09ae4f854a95355112010e;hp=7d89e6bfeb8871bd7eb1423b21f52506085dd126;hpb=6d236cc36e6de541586a94fc4e2276bd0e8d1453;p=dak.git diff --git a/dak/update_db.py b/dak/update_db.py index 7d89e6bf..d4aefe24 100755 --- a/dak/update_db.py +++ b/dak/update_db.py @@ -29,6 +29,7 @@ import psycopg2, sys, fcntl, os import apt_pkg import time +import errno from daklib import database from daklib import utils @@ -36,7 +37,7 @@ from daklib import utils Cnf = None projectB = None -required_database_schema = 2 +required_database_schema = 3 ################################################################################ @@ -63,7 +64,7 @@ Updates dak's database schema to the lastest version. You should disable crontab name TEXT UNIQUE NOT NULL, value TEXT );""") - c.execute("INSERT INTO config VALUES ( nextval('config_id_seq'), 'db_revision', '0')"); + c.execute("INSERT INTO config VALUES ( nextval('config_id_seq'), 'db_revision', '0')") self.db.commit() except psycopg2.ProgrammingError: @@ -84,7 +85,7 @@ Updates dak's database schema to the lastest version. You should disable crontab try: c = self.db.cursor() - q = c.execute("SELECT value FROM config WHERE name = 'db_revision';"); + q = c.execute("SELECT value FROM config WHERE name = 'db_revision';") return c.fetchone()[0] except psycopg2.ProgrammingError: