Package dak :: Package dakdb :: Module update84

[frames] | no frames]

Module update84

add per-suite database permissions

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

statements

Value:

["""
CREATE TABLE suite_permission (
  suite_id INT NOT NULL REFERENCES suite(id) ON DELETE CASCADE,
  role TEXT NOT NULL,
  PRIMARY KEY (suite_id, role)
)
""", """
CREATE OR REPLACE FUNCTION has_suite_permission(action TEXT, suite_id 
...