Class CreateRole

misc/python/materialize/checks/all_checks/roles.py:15–45

class CreateRole(Check):
    def initialize(self) -> Testdrive:
        return Testdrive(TESTDRIVE_NOP)

    def manipulate(self) -> list[Testdrive]:
        return [
            Testdrive(dedent(s))
            for s in [
                """
                > CREATE ROLE create_role1;
                > GRANT create_role1 TO materialize;
                """,
                """
                > CREATE ROLE create_role2;
                > GRANT create_role2 TO materialize;
                """,
            ]
        ]

    def validate(self) -> Testdrive:
        return Testdrive(dedent("""
                > SELECT name FROM mz_roles WHERE name LIKE 'create_role%';
                create_role1
                create_role2
                # TODO(def-) Grantor information is currently not stable during
                # upgrades due to https://github.com/MaterializeInc/materialize/pull/18780
                # Reenable on next release
                > SELECT role.name, member.name from mz_role_members JOIN mz_roles role ON mz_role_members.role_id = role.id JOIN mz_roles member ON mz_role_members.member = member.id JOIN mz_roles grantor ON mz_role_members.grantor = grantor.id WHERE role.name LIKE 'create_role%';
                create_role1 materialize
                create_role2 materialize
                """))


class DropRole(CreateRole):