Package dak :: Package dakdb :: Module update84
[hide private]
[frames] | no frames]

Module update84

source code

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 [hide private]
 
do_update(self) source code
Variables [hide private]
  statements = [...

Imports: psycopg2, DBUpdateError, Config


Variables Details [hide private]

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 \
...