X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate20.py;h=c1424ab2da502aa8c236dcfb4dc2d0f8ba1ad912;hb=6cfc82886d71c7436a97ddfe7a5a1dde297886d2;hp=27df549b84911740112cc41cae8a7e6d0287ae91;hpb=6021a91078574c97968d076c0320182a20c33649;p=dak.git diff --git a/dak/dakdb/update20.py b/dak/dakdb/update20.py index 27df549b..c1424ab2 100755 --- a/dak/dakdb/update20.py +++ b/dak/dakdb/update20.py @@ -84,17 +84,17 @@ def do_update(self): c.execute("ALTER TABLE suite ADD COLUMN policy_queue_id INT4 REFERENCES queue(id) DEFAULT NULL") # Handle some of our common cases automatically if seenqueues.has_key('proposedupdates'): - c.execute("""UPDATE suite SET policy_queue = (SELECT id FROM queue WHERE queue_name = 'proposedupdates') + c.execute("""UPDATE suite SET policy_queue_id = (SELECT id FROM queue WHERE queue_name = 'proposedupdates') WHERE suite_name = 'proposed-updates'""") if seenqueues.has_key('oldproposedupdates'): - c.execute("""UPDATE suite SET policy_queue = (SELECT id FROM queue WHERE queue_name = 'oldproposedupdates') + c.execute("""UPDATE suite SET policy_queue_id = (SELECT id FROM queue WHERE queue_name = 'oldproposedupdates') WHERE suite_name = 'oldstable-proposed-updates'""") print "Committing" c.execute("UPDATE config SET value = '20' WHERE name = 'db_revision'") self.db.commit() - except psycopg2.InternalError, msg: + except psycopg2.InternalError as msg: self.db.rollback() - raise DBUpdateError, "Unable to apply debversion update 20, rollback issued. Error message : %s" % (str(msg)) + raise DBUpdateError("Unable to apply debversion update 20, rollback issued. Error message : %s" % (str(msg)))