aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20230210_02_lDK14-create-system-admin-role.py
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/auth/20230210_02_lDK14-create-system-admin-role.py')
-rw-r--r--migrations/auth/20230210_02_lDK14-create-system-admin-role.py38
1 files changed, 0 insertions, 38 deletions
diff --git a/migrations/auth/20230210_02_lDK14-create-system-admin-role.py b/migrations/auth/20230210_02_lDK14-create-system-admin-role.py
deleted file mode 100644
index 9b3fc2b..0000000
--- a/migrations/auth/20230210_02_lDK14-create-system-admin-role.py
+++ /dev/null
@@ -1,38 +0,0 @@
-"""
-Create system-admin role
-"""
-import uuid
-from contextlib import closing
-
-from yoyo import step
-
-__depends__ = {'20230210_01_8xMa1-system-admin-privileges-for-data-distribution'}
-
-def create_sys_admin_role(conn):
- with closing(conn.cursor()) as cursor:
- role_id = uuid.uuid4()
- cursor.execute(
- "INSERT INTO roles VALUES (?, 'system-administrator', '0')",
- (str(role_id),))
-
- cursor.executemany(
- "INSERT INTO role_privileges VALUES (:role_id, :privilege_id)",
- ({"role_id": f"{role_id}", "privilege_id": priv}
- for priv in (
- "system:data:link-to-group",
- "system:group:create-group",
- "system:group:delete-group",
- "system:group:edit-group",
- "system:group:transfer-group-leader",
- "system:group:view-group",
- "system:user:assign-group-leader",
- "system:user:delete-user",
- "system:user:masquerade",
- "system:user:reset-password")))
-
-def drop_sys_admin_role(conn):
- pass
-
-steps = [
- step(create_sys_admin_role, drop_sys_admin_role)
-]