X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate56.py;h=647f8c799ade92962a561f0f58d2fae2d2dbd263;hb=55513d80673e99884067b8820ca1a0b3e9aeeeef;hp=e33cec966fa283b873b8fb774b7b6676908fe3a0;hpb=3fe6999ba255bd164e2c84c2c07ae5300ff5e8f7;p=dak.git diff --git a/dak/dakdb/update56.py b/dak/dakdb/update56.py old mode 100755 new mode 100644 index e33cec96..647f8c79 --- a/dak/dakdb/update56.py +++ b/dak/dakdb/update56.py @@ -37,7 +37,7 @@ def do_update(self): try: c = self.db.cursor() - c.execute("ALTER TABLE metadata_keys ADD COLUMN order INTEGER NOT NULL DEFAULT 0") + c.execute("ALTER TABLE metadata_keys ADD COLUMN ordering INTEGER NOT NULL DEFAULT 0") initial_order = { 'Package': -2600, @@ -80,11 +80,11 @@ def do_update(self): } for key, order in initial_order.items(): - c.execute("""UPDATE metadata_keys SET "order" = '%s' WHERE key ILIKE '%s'""" % (order, key)) + c.execute("""UPDATE metadata_keys SET ordering = '%s' WHERE key ILIKE '%s'""" % (order, key)) c.execute("UPDATE config SET value = '56' WHERE name = 'db_revision'") self.db.commit() - except psycopg2.ProgrammingError, msg: + except psycopg2.ProgrammingError as msg: self.db.rollback() - raise DBUpdateError, 'Unable to apply sick update 56, rollback issued. Error message : %s' % (str(msg)) + raise DBUpdateError('Unable to apply sick update 56, rollback issued. Error message : %s' % (str(msg)))