X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate18.py;h=eb8efa4a4cbc943401e1fad9afd2b3bc4edb3170;hb=27e00376e81d1c37ff327ee0d39670b266418869;hp=c462b16af0e68fe53aec89d76824acb9daffd8dc;hpb=1036e6d3a5b27226057f61d1cf58c71f80532e0f;p=dak.git diff --git a/dak/dakdb/update18.py b/dak/dakdb/update18.py index c462b16a..eb8efa4a 100755 --- a/dak/dakdb/update18.py +++ b/dak/dakdb/update18.py @@ -42,7 +42,6 @@ from daklib.utils import parse_changes, warn, gpgv_get_status_output, process_gp def check_signature (sig_filename, data_filename=""): keyrings = [ "/home/joerg/keyring/keyrings/debian-keyring.gpg", - "/home/joerg/keyring/keyrings/debian-keyring.pgp", "/home/joerg/keyring/keyrings/debian-maintainers.gpg", "/home/joerg/keyring/keyrings/debian-role-keys.gpg", "/home/joerg/keyring/keyrings/emeritus-keyring.pgp", @@ -118,6 +117,12 @@ def do_update(self): c.execute("CREATE INDEX changesdistribution_ind ON known_changes(distribution)") c.execute("CREATE INDEX changesurgency_ind ON known_changes(urgency)") + c.execute("GRANT ALL ON known_changes TO ftpmaster;") + c.execute("GRANT SELECT ON known_changes TO public;") + + c.execute("UPDATE config SET value = '18' WHERE name = 'db_revision'") + self.db.commit() + print "Done. Now looking for old changes files" count = 0 failure = 0 @@ -139,20 +144,13 @@ def do_update(self): changes.changes = parse_changes(changesfile, signing_rules=-1) changes.changes["fingerprint"] = check_signature(changesfile) changes.add_known_changes(directory) - except InvalidDscError, line: + except InvalidDscError as line: warn("syntax error in .dsc file '%s', line %s." % (f, line)) failure += 1 except ChangesUnicodeError: warn("found invalid changes file, not properly utf-8 encoded") failure += 1 - - c.execute("GRANT ALL ON known_changes TO ftpmaster;") - c.execute("GRANT SELECT ON known_changes TO public;") - - c.execute("UPDATE config SET value = '18' WHERE name = 'db_revision'") - self.db.commit() - - except psycopg2.ProgrammingError, msg: + except psycopg2.ProgrammingError as msg: self.db.rollback() raise DBUpdateError, "Unable to apply knownchanges update 18, rollback issued. Error message : %s" % (str(msg))