aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20250703_01_aDVwP-add-role-management-privileges-to-group-leader-role.py
blob: 6335152b1cd7f69d023d8fb611ad6078f2a4c117 (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
"""
Add role management privileges to group-leader role
"""

from yoyo import step

__depends__ = {'20250609_01_LB60X-add-batch-edit-privileges', '20250609_02_9UBPl-assign-group-data-link-to-group-privilege-to-group-leader'}

steps = [
    step(
        """
        INSERT INTO role_privileges(role_id, privilege_id)
        VALUES
          ('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:create-role'),
          ('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:delete-role'),
          ('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:edit-role')
        """,
        """
        DELETE FROM role_privileges
        WHERE role_id='a0e67630-d502-4b9f-b23f-6805d0f30e30'
        AND privilege_id IN (
          'resource:role:create-role',
          'resource:role:delete-role',
          'resource:role:edit-role'
        )
        """)
]