Convert exception handling to Python3 syntax.

[dak.git] / dak / dakdb / update56.py

diff --git a/dak/dakdb/update56.py b/dak/dakdb/update56.py
index e33cec966fa283b873b8fb774b7b6676908fe3a0..58ecc9f211d9cb41fc8920dcba26e2fe2388cd4b 100755 (executable)
--- 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))