aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20250609_02_9UBPl-assign-group-data-link-to-group-privilege-to-group-leader.py
blob: 5d9c3066e9b1344d40439e9780d3b46e2675e232 (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
"""
Assign 'group:data:link-to-group' privilege to group leader.
"""

from yoyo import step

__depends__ = {'20250609_01_bj9Pl-add-new-group-data-link-to-group-privilege'}

steps = [
    step(
        """
        INSERT INTO role_privileges(role_id, privilege_id)
        VALUES(
          'a0e67630-d502-4b9f-b23f-6805d0f30e30',
          'group:data:link-to-group'
        )
        """,
        """
        DELETE FROM role_privileges
        WHERE role_id='a0e67630-d502-4b9f-b23f-6805d0f30e30'
        AND privilege_id='group:data:link-to-group'
        """)
]