Convert exception handling to Python3 syntax.

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

diff --git a/dak/dakdb/update33.py b/dak/dakdb/update33.py
index 5c0b3f41202872274b1356d36413bbbac998bcb6..d3867af32471151dfc876c9d1f687d278a16c577 100644 (file)
--- a/dak/dakdb/update33.py
+++ b/dak/dakdb/update33.py
@@ -43,13 +43,13 @@ def do_update(self):
         c.execute('CREATE TABLE changelogs_text (id serial PRIMARY KEY NOT NULL, changelog text)')
         c.execute("GRANT SELECT ON changelogs_text TO public")
         c.execute("GRANT ALL ON changelogs_text TO ftpmaster")
-        c.execute('CREATE VIEW changelogs AS SELECT cl.id, source, version, architecture, changelog \
+        c.execute('CREATE VIEW changelogs AS SELECT cl.id, source, CAST(version AS debversion), architecture, changelog \
                    FROM changes c JOIN changelogs_text cl ON cl.id = c.changelog_id')
         c.execute("GRANT SELECT ON changelogs TO public")
         c.execute("GRANT ALL ON changelogs TO ftpmaster")
         c.execute("UPDATE config SET value = '33' WHERE name = 'db_revision'")
         self.db.commit()
 
-    except psycopg2.ProgrammingError, msg:
+    except psycopg2.ProgrammingError as msg:
         self.db.rollback()
         raise DBUpdateError, 'Unable to apply build_queue update 33, rollback issued. Error message : %s' % (str(msg))