Package dak :: Package dakdb :: Module update126

[frames] | no frames]

Module update126

add per-suite ACL table

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

Copyright: 2023 Emilio Pozuelo Monfort <pochu@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

statements

Value:

["""
CREATE TABLE acl_per_suite (
    acl_id INTEGER NOT NULL REFERENCES acl(id) ON DELETE CASCADE,
    fingerprint_id INTEGER NOT NULL REFERENCES fingerprint(id) ON DELE
TE CASCADE,
    suite_id INTEGER NOT NULL REFERENCES suite(id) ON DELETE CASCADE,
    reason TEXT,
    created_by_id INTEGER REFERENCES fingerprint(id),
...