Module update92

remove per-fingerprint ACLs that are identical to keyring ACL

Contact: Debian FTP Master <ftpmaster@debian.org>

Copyright: 2012 Ansgar Burchardt <ansgar@debian.org>

License: GNU General Public License version 2 or later

Functions

do_update(self)

source code

Variables

statements = [...

Imports: psycopg2, DBUpdateError, Config

Variables Details

Value:

["""
UPDATE fingerprint f
   SET acl_id = NULL
  FROM keyrings k
 WHERE (f.keyring = k.id AND f.acl_id = k.acl_id)
    OR f.keyring IS NULL
""",]