Skip to content

armgit / zulip

Public Imported from GitHub
0

Zulip server and web application. Open-source team chat that helps teams stay productive and focused.

94.8 KB
Raw Blame
from datetime import timedelta
from enum import Enum
from typing import Any

from django.contrib.auth.password_validation import validate_password
from django.utils.timezone import now as timezone_now

from analytics.models import StreamCount
from zerver.actions.bots import (
    do_change_bot_owner,
    do_change_default_all_public_streams,
    do_change_default_events_register_stream,
    do_change_default_sending_stream,
)
from zerver.actions.channel_folders import (
    check_add_channel_folder,
    do_archive_channel_folder,
    do_change_channel_folder_description,
    do_change_channel_folder_name,
    do_unarchive_channel_folder,
)
from zerver.actions.create_realm import do_create_realm
from zerver.actions.create_user import (
    do_activate_mirror_dummy_user,
    do_create_user,
    do_reactivate_user,
)
from zerver.actions.navigation_views import (
    do_add_navigation_view,
    do_remove_navigation_view,
    do_update_navigation_view,
)
from zerver.actions.realm_domains import (
    do_add_realm_domain,
    do_change_realm_domain,
    do_remove_realm_domain,
)
from zerver.actions.realm_emoji import check_add_realm_emoji, do_remove_realm_emoji
from zerver.actions.realm_icon import do_change_icon_source
from zerver.actions.realm_linkifiers import (
    do_add_linkifier,
    do_remove_linkifier,
    do_update_linkifier,
)
from zerver.actions.realm_playgrounds import check_add_realm_playground, do_remove_realm_playground
from zerver.actions.realm_settings import (
    do_change_realm_permission_group_setting,
    do_deactivate_realm,
    do_reactivate_realm,
    do_set_realm_authentication_methods,
    do_set_realm_moderation_request_channel,
    do_set_realm_new_stream_announcements_stream,
    do_set_realm_property,
    do_set_realm_signup_announcements_stream,
    do_set_realm_zulip_update_announcements_stream,
)
from zerver.actions.streams import (
    bulk_add_subscriptions,
    bulk_remove_subscriptions,
    do_change_stream_folder,
    do_change_subscription_property,
    do_deactivate_stream,
    do_rename_stream,
)
from zerver.actions.user_groups import (
    add_subgroups_to_user_group,
    bulk_add_members_to_user_groups,
    bulk_remove_members_from_user_groups,
    check_add_user_group,
    do_change_user_group_permission_setting,
    do_deactivate_user_group,
    do_reactivate_user_group,
    do_update_user_group_description,
    do_update_user_group_name,
    remove_subgroups_from_user_group,
)
from zerver.actions.user_settings import (
    do_change_avatar_fields,
    do_change_password,
    do_change_tos_version,
    do_change_user_date_joined,
    do_change_user_delivery_email,
    do_change_user_setting,
    do_regenerate_api_key,
)
from zerver.actions.users import do_change_is_imported_stub, do_change_user_role, do_deactivate_user
from zerver.lib.emoji import get_emoji_file_name
from zerver.lib.message import get_last_message_id
from zerver.lib.stream_traffic import get_streams_traffic
from zerver.lib.streams import create_stream_if_needed
from zerver.lib.test_classes import ZulipTestCase
from zerver.lib.test_helpers import get_test_image_file
from zerver.lib.types import LinkifierDict, RealmPlaygroundDict
from zerver.lib.upload import get_emoji_url
from zerver.lib.user_groups import get_group_setting_value_for_api, get_recursive_group_members
from zerver.lib.utils import assert_is_not_none
from zerver.models import (
    Message,
    NamedUserGroup,
    RealmAuditLog,
    RealmPlayground,
    Recipient,
    Subscription,
    UserProfile,
)
from zerver.models.groups import SystemGroups
from zerver.models.linkifiers import linkifiers_for_realm
from zerver.models.realm_audit_logs import AuditLogEventType
from zerver.models.realm_emoji import EmojiInfo
from zerver.models.realm_playgrounds import get_realm_playgrounds
from zerver.models.realms import RealmDomainDict, get_realm, get_realm_domains
from zerver.models.streams import get_stream
from zerver.models.users import ResolvedTopicNoticeAutoReadPolicyEnum


class TestRealmAuditLog(ZulipTestCase):
    def check_role_count_schema(self, role_counts: dict[str, Any]) -> None:
        for key in [
            UserProfile.ROLE_REALM_ADMINISTRATOR,
            UserProfile.ROLE_MEMBER,
            UserProfile.ROLE_GUEST,
            UserProfile.ROLE_REALM_OWNER,
        ]:
            # str(key) since json keys are always strings, and ujson.dumps will have converted
            # the UserProfile.role values into strings
            self.assertTrue(isinstance(role_counts[RealmAuditLog.ROLE_COUNT_HUMANS][str(key)], int))
        self.assertTrue(
            isinstance(role_counts[RealmAuditLog.ROLE_COUNT_HUMANS]["workplace_users"], int)
        )
        self.assertTrue(
            isinstance(role_counts[RealmAuditLog.ROLE_COUNT_HUMANS]["non_workplace_users"], int)
        )
        self.assertTrue(isinstance(role_counts[RealmAuditLog.ROLE_COUNT_BOTS], int))

    def test_user_activation(self) -> None:
        realm = get_realm("zulip")
        now = timezone_now()
        user = do_create_user("email", "password", realm, "full_name", acting_user=None)
        do_deactivate_user(user, acting_user=user)

        user.is_mirror_dummy = True
        user.save(update_fields=["is_mirror_dummy"])
        do_activate_mirror_dummy_user(user, acting_user=user)
        do_deactivate_user(user, acting_user=user)
        do_reactivate_user(user, acting_user=user)
        self.assertEqual(RealmAuditLog.objects.filter(event_time__gte=now).count(), 10)
        event_types = list(
            RealmAuditLog.objects.filter(
                realm=realm,
                acting_user=user,
                modified_user=user,
                modified_stream=None,
                event_time__gte=now,
                event_time__lte=now + timedelta(minutes=60),
            )
            .order_by("event_time", "event_type")
            .values_list("event_type", flat=True)
        )
        self.assertEqual(
            event_types,
            [
                AuditLogEventType.USER_CREATED,
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                AuditLogEventType.USER_DEACTIVATED,
                AuditLogEventType.USER_ACTIVATED,
                AuditLogEventType.USER_DEACTIVATED,
                AuditLogEventType.USER_REACTIVATED,
            ],
        )
        modified_user_group_names = []
        for event in RealmAuditLog.objects.filter(
            realm=realm,
            acting_user=user,
            modified_user=user,
            modified_stream=None,
            event_time__gte=now,
            event_time__lte=now + timedelta(minutes=60),
        ):
            if event.event_type == AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED:
                self.assertDictEqual(event.extra_data, {})
                modified_user_group_names.append(assert_is_not_none(event.modified_user_group).name)
                continue
            extra_data = event.extra_data
            self.check_role_count_schema(extra_data[RealmAuditLog.ROLE_COUNT])
            self.assertNotIn(RealmAuditLog.OLD_VALUE, extra_data)

        self.assertListEqual(
            modified_user_group_names,
            [
                SystemGroups.MEMBERS,
                SystemGroups.FULL_MEMBERS,
            ],
        )

    def test_change_role(self) -> None:
        realm = get_realm("zulip")
        now = timezone_now()
        user_profile = self.example_user("hamlet")
        acting_user = self.example_user("iago")
        do_change_user_role(
            user_profile,
            UserProfile.ROLE_REALM_ADMINISTRATOR,
            acting_user=acting_user,
            notify=False,
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_MEMBER, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_GUEST, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_MEMBER, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_REALM_OWNER, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_MEMBER, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_MODERATOR, acting_user=acting_user, notify=False
        )
        do_change_user_role(
            user_profile, UserProfile.ROLE_MEMBER, acting_user=acting_user, notify=False
        )
        old_values_seen = set()
        new_values_seen = set()
        for event in RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_ROLE_CHANGED,
            realm=realm,
            modified_user=user_profile,
            acting_user=acting_user,
            event_time__gte=now,
            event_time__lte=now + timedelta(minutes=60),
        ):
            extra_data = event.extra_data
            self.check_role_count_schema(extra_data[RealmAuditLog.ROLE_COUNT])
            self.assertIn(RealmAuditLog.OLD_VALUE, extra_data)
            self.assertIn(RealmAuditLog.NEW_VALUE, extra_data)
            old_values_seen.add(extra_data[RealmAuditLog.OLD_VALUE])
            new_values_seen.add(extra_data[RealmAuditLog.NEW_VALUE])
        self.assertEqual(
            old_values_seen,
            {
                UserProfile.ROLE_GUEST,
                UserProfile.ROLE_MEMBER,
                UserProfile.ROLE_REALM_ADMINISTRATOR,
                UserProfile.ROLE_REALM_OWNER,
                UserProfile.ROLE_MODERATOR,
            },
        )
        self.assertEqual(old_values_seen, new_values_seen)

        expected_system_user_group_names = [
            SystemGroups.ADMINISTRATORS,
            SystemGroups.MEMBERS,
            SystemGroups.FULL_MEMBERS,
            SystemGroups.EVERYONE,
            SystemGroups.MEMBERS,
            SystemGroups.FULL_MEMBERS,
            SystemGroups.OWNERS,
            SystemGroups.MEMBERS,
            SystemGroups.FULL_MEMBERS,
            SystemGroups.MODERATORS,
        ]
        user_group_modified_names = (
            RealmAuditLog.objects.filter(
                event_type=AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                realm=realm,
                modified_user=user_profile,
                acting_user=acting_user,
                event_time__gte=now,
                event_time__lte=now + timedelta(minutes=60),
            )
            .order_by("event_time")
            .values_list("modified_user_group__name", flat=True)
        )
        self.assertListEqual(
            list(user_group_modified_names),
            [
                *expected_system_user_group_names,
                SystemGroups.MEMBERS,
                SystemGroups.FULL_MEMBERS,
            ],
        )
        user_group_modified_names = (
            RealmAuditLog.objects.filter(
                event_type=AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
                realm=realm,
                modified_user=user_profile,
                acting_user=acting_user,
                event_time__gte=now,
                event_time__lte=now + timedelta(minutes=60),
            )
            .order_by("event_time")
            .values_list("modified_user_group__name", flat=True)
        )
        self.assertListEqual(
            list(user_group_modified_names),
            [
                SystemGroups.MEMBERS,
                SystemGroups.FULL_MEMBERS,
                *expected_system_user_group_names,
            ],
        )

    def test_change_password(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        password = "test1"
        do_change_password(user, password)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                event_type=AuditLogEventType.USER_PASSWORD_CHANGED, event_time__gte=now
            ).count(),
            1,
        )
        # No error should be raised here
        validate_password(password, user)

    def test_change_email(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        original_email = user.delivery_email
        new_email = "[email protected]"
        do_change_user_delivery_email(user, new_email, acting_user=user)
        self.assertEqual(new_email, user.delivery_email)

        audit_entry = RealmAuditLog.objects.get(
            event_type=AuditLogEventType.USER_EMAIL_CHANGED, event_time__gte=now
        )
        self.assertEqual(audit_entry.modified_user, user)
        self.assertEqual(
            audit_entry.extra_data,
            {RealmAuditLog.OLD_VALUE: original_email, RealmAuditLog.NEW_VALUE: new_email},
        )
        # Test the RealmAuditLog stringification
        self.assertTrue(
            repr(audit_entry).startswith(
                f"<RealmAuditLog: {AuditLogEventType.USER_EMAIL_CHANGED.name} "
            )
        )

    def test_change_avatar_source(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        avatar_source = "G"
        do_change_avatar_fields(user, avatar_source, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                event_type=AuditLogEventType.USER_AVATAR_SOURCE_CHANGED,
                modified_user=user,
                acting_user=user,
                event_time__gte=now,
            ).count(),
            1,
        )
        self.assertEqual(avatar_source, user.avatar_source)

    def test_change_full_name(self) -> None:
        start = timezone_now()
        new_name = "George Hamletovich"
        self.login("iago")
        req = dict(full_name=new_name)
        result = self.client_patch("/json/users/{}".format(self.example_user("hamlet").id), req)
        self.assertTrue(result.status_code == 200)
        query = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_FULL_NAME_CHANGED, event_time__gte=start
        )
        self.assertEqual(query.count(), 1)

    def test_change_tos_version(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        old_tos_version = user.tos_version
        tos_version = "android"
        do_change_tos_version(user, tos_version)
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_TERMS_OF_SERVICE_VERSION_CHANGED, event_time__gte=now
        )
        self.assertEqual(audit_log_entries.count(), 1)
        expected_extra_data = {
            RealmAuditLog.OLD_VALUE: old_tos_version,
            RealmAuditLog.NEW_VALUE: tos_version,
        }
        self.assertEqual(audit_log_entries[0].extra_data, expected_extra_data)
        self.assertEqual(tos_version, user.tos_version)

    def test_change_bot_owner(self) -> None:
        now = timezone_now()
        admin = self.example_user("iago")
        bot = self.notification_bot(admin.realm)
        # Check that original owner of the notification bot is the bot itself.
        self.assertEqual(bot.bot_owner, bot)
        bot_owner = self.example_user("hamlet")
        do_change_bot_owner(bot, bot_owner, admin)
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_BOT_OWNER_CHANGED, event_time__gte=now
        )
        self.assertEqual(audit_log_entries.count(), 1)
        expected_extra_data = {
            RealmAuditLog.OLD_VALUE: bot.id,
            RealmAuditLog.NEW_VALUE: bot_owner.id,
        }
        self.assertEqual(audit_log_entries[0].extra_data, expected_extra_data)
        self.assertEqual(bot_owner, bot.bot_owner)

    def test_regenerate_api_key(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        do_regenerate_api_key(user, user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                event_type=AuditLogEventType.USER_API_KEY_CHANGED, event_time__gte=now
            ).count(),
            1,
        )
        self.assertTrue(user.api_key)

    def test_get_streams_traffic(self) -> None:
        realm = get_realm("zulip")
        stream = self.make_stream("whatever", realm)
        stream_2 = self.make_stream("whatever_2", realm)

        result = get_streams_traffic(realm)
        self.assertEqual(result, {})

        StreamCount.objects.create(
            realm=realm,
            stream=stream,
            property="messages_in_stream:is_bot:day",
            end_time=timezone_now(),
            value=999,
        )
        StreamCount.objects.create(
            realm=realm,
            stream=stream_2,
            property="messages_in_stream:is_bot:day",
            end_time=timezone_now(),
            value=23,
        )

        result = get_streams_traffic(realm, {stream.id})
        self.assertEqual(result, {stream.id: 999})

        all_streams_traffic = get_streams_traffic(realm)
        self.assertEqual(all_streams_traffic, {stream.id: 999, stream_2.id: 23})

    def test_subscriptions(self) -> None:
        now = timezone_now()

        user = self.example_user("hamlet")
        realm = user.realm
        stream = self.make_stream("test_stream")
        acting_user = self.example_user("iago")
        bulk_add_subscriptions(user.realm, [stream], [user], acting_user=acting_user)
        subscription_creation_logs = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.SUBSCRIPTION_CREATED,
            event_time__gte=now,
            acting_user=acting_user,
            modified_user=user,
            modified_stream=stream,
        )
        modified_stream = subscription_creation_logs[0].modified_stream
        assert modified_stream is not None
        self.assertEqual(subscription_creation_logs.count(), 1)
        self.assertEqual(modified_stream.id, stream.id)
        self.assertEqual(subscription_creation_logs[0].modified_user, user)

        bulk_remove_subscriptions(realm, [user], [stream], acting_user=acting_user)
        subscription_deactivation_logs = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.SUBSCRIPTION_DEACTIVATED,
            event_time__gte=now,
            acting_user=acting_user,
            modified_user=user,
            modified_stream=stream,
        )
        modified_stream = subscription_deactivation_logs[0].modified_stream
        assert modified_stream is not None
        self.assertEqual(subscription_deactivation_logs.count(), 1)
        self.assertEqual(modified_stream.id, stream.id)
        self.assertEqual(subscription_deactivation_logs[0].modified_user, user)

    def test_realm_activation(self) -> None:
        realm = get_realm("zulip")
        user = self.example_user("desdemona")
        do_deactivate_realm(
            realm, acting_user=user, deactivation_reason="owner_request", email_owners=False
        )
        log_entry = RealmAuditLog.objects.get(
            realm=realm, event_type=AuditLogEventType.REALM_DEACTIVATED, acting_user=user
        )
        extra_data = log_entry.extra_data

        deactivation_reason = extra_data["deactivation_reason"]
        self.assertEqual(deactivation_reason, "owner_request")

        self.check_role_count_schema(extra_data[RealmAuditLog.ROLE_COUNT])

        do_reactivate_realm(realm)
        log_entry = RealmAuditLog.objects.get(
            realm=realm, event_type=AuditLogEventType.REALM_REACTIVATED
        )
        extra_data = log_entry.extra_data
        self.check_role_count_schema(extra_data[RealmAuditLog.ROLE_COUNT])

    def test_create_stream_if_needed(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        stream = create_stream_if_needed(
            realm,
            "test",
            invite_only=False,
            stream_description="Test description",
            acting_user=user,
        )[0]
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.CHANNEL_CREATED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
            ).count(),
            1,
        )

    def test_deactivate_stream(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        stream_name = "test"
        stream = self.make_stream(stream_name, realm)
        do_deactivate_stream(stream, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.CHANNEL_DEACTIVATED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
            ).count(),
            1,
        )
        self.assertEqual(stream.deactivated, True)

    def test_set_realm_authentication_methods(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        expected_old_value = realm.authentication_methods_dict()
        auth_method_dict = {
            "Google": False,
            "Email": False,
            "GitHub": False,
            "Apple": False,
            "Dev": True,
            "SAML": True,
            "GitLab": False,
            "OpenID Connect": False,
            "Discord": False,
        }

        do_set_realm_authentication_methods(realm, auth_method_dict, acting_user=user)
        realm_audit_logs = RealmAuditLog.objects.filter(
            realm=realm,
            event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
            event_time__gte=now,
            acting_user=user,
        )
        self.assertEqual(realm_audit_logs.count(), 1)
        extra_data = realm_audit_logs[0].extra_data
        expected_new_value = auth_method_dict
        self.assertEqual(extra_data[RealmAuditLog.OLD_VALUE], expected_old_value)
        self.assertEqual(extra_data[RealmAuditLog.NEW_VALUE], expected_new_value)

    def test_get_last_message_id(self) -> None:
        # get_last_message_id is a helper mainly used for RealmAuditLog
        self.assertEqual(
            get_last_message_id(),
            Message.objects.latest("id").id,
        )

        Message.objects.all().delete()

        self.assertEqual(get_last_message_id(), -1)

    def test_set_realm_message_editing(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        value_expected = {
            RealmAuditLog.OLD_VALUE: realm.message_content_edit_limit_seconds,
            RealmAuditLog.NEW_VALUE: 1000,
            "property": "message_content_edit_limit_seconds",
        }

        do_set_realm_property(realm, "message_content_edit_limit_seconds", 1000, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data=value_expected,
            ).count(),
            1,
        )

        administrators_system_group = NamedUserGroup.objects.get(
            name=SystemGroups.ADMINISTRATORS, realm_for_sharding=realm, is_system_group=True
        )
        everyone_system_group = NamedUserGroup.objects.get(
            name=SystemGroups.EVERYONE, realm_for_sharding=realm, is_system_group=True
        )

        value_expected = {
            RealmAuditLog.OLD_VALUE: everyone_system_group.id,
            RealmAuditLog.NEW_VALUE: administrators_system_group.id,
            "property": "can_move_messages_between_topics_group",
        }

        do_change_realm_permission_group_setting(
            realm,
            "can_move_messages_between_topics_group",
            administrators_system_group,
            acting_user=user,
        )
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data=value_expected,
            ).count(),
            1,
        )

    def test_set_realm_new_stream_announcements_stream(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        old_value = realm.new_stream_announcements_stream_id
        stream_name = "test"
        stream = self.make_stream(stream_name, realm)

        do_set_realm_new_stream_announcements_stream(realm, stream, stream.id, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_value,
                    RealmAuditLog.NEW_VALUE: stream.id,
                    "property": "new_stream_announcements_stream",
                },
            ).count(),
            1,
        )

    def test_set_realm_signup_announcements_stream(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        old_value = realm.signup_announcements_stream_id
        stream_name = "test"
        stream = self.make_stream(stream_name, realm)

        do_set_realm_signup_announcements_stream(realm, stream, stream.id, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_value,
                    RealmAuditLog.NEW_VALUE: stream.id,
                    "property": "signup_announcements_stream",
                },
            ).count(),
            1,
        )

    def test_set_realm_zulip_update_announcements_stream(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        old_value = realm.zulip_update_announcements_stream_id
        stream_name = "test"
        stream = self.make_stream(stream_name, realm)

        do_set_realm_zulip_update_announcements_stream(realm, stream, stream.id, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_value,
                    RealmAuditLog.NEW_VALUE: stream.id,
                    "property": "zulip_update_announcements_stream",
                },
            ).count(),
            1,
        )

    def test_set_realm_moderation_request_channel(self) -> None:
        now = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        old_value = realm.moderation_request_channel
        stream = self.make_stream("private_stream", invite_only=True)
        assert old_value is not None
        do_set_realm_moderation_request_channel(realm, stream, stream.id, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.REALM_PROPERTY_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    # `populate_db` configures `moderation_request_channel` for
                    # API testing purposes, so the `old_value` here is
                    # not `None`.
                    RealmAuditLog.OLD_VALUE: old_value.id,
                    RealmAuditLog.NEW_VALUE: stream.id,
                    "property": "moderation_request_channel",
                },
            ).count(),
            1,
        )

    def test_change_icon_source(self) -> None:
        test_start = timezone_now()
        realm = get_realm("zulip")
        user = self.example_user("hamlet")
        icon_source = "G"
        do_change_icon_source(realm, icon_source, acting_user=user)
        audit_entries = RealmAuditLog.objects.filter(
            realm=realm,
            event_type=AuditLogEventType.REALM_ICON_SOURCE_CHANGED,
            acting_user=user,
            event_time__gte=test_start,
        )
        audit_log = audit_entries.first()
        assert audit_log is not None
        self.assert_length(audit_entries, 1)
        self.assertEqual(icon_source, realm.icon_source)
        self.assertEqual(audit_log.extra_data, {"icon_source": "G", "icon_version": 2})

    def test_change_subscription_property(self) -> None:
        user = self.example_user("hamlet")
        # Fetch the Denmark stream for testing
        stream = get_stream("Denmark", user.realm)
        sub = Subscription.objects.get(
            user_profile=user, recipient__type=Recipient.STREAM, recipient__type_id=stream.id
        )
        properties = {
            "color": True,
            "is_muted": True,
            "desktop_notifications": False,
            "audible_notifications": False,
            "push_notifications": True,
            "email_notifications": True,
            "pin_to_top": True,
            "wildcard_mentions_notify": False,
        }

        for property, value in properties.items():
            now = timezone_now()

            old_value = getattr(sub, property)
            self.assertNotEqual(old_value, value)
            do_change_subscription_property(user, sub, stream, property, value, acting_user=user)
            expected_extra_data = {
                RealmAuditLog.OLD_VALUE: old_value,
                RealmAuditLog.NEW_VALUE: value,
                "property": property,
            }
            self.assertEqual(
                RealmAuditLog.objects.filter(
                    realm=user.realm,
                    event_type=AuditLogEventType.SUBSCRIPTION_PROPERTY_CHANGED,
                    event_time__gte=now,
                    acting_user=user,
                    modified_user=user,
                    extra_data=expected_extra_data,
                ).count(),
                1,
            )
            self.assertEqual(getattr(sub, property), value)

    def test_change_default_streams(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        stream = get_stream("Denmark", user.realm)

        old_value = user.default_sending_stream_id
        do_change_default_sending_stream(user, stream, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.USER_DEFAULT_SENDING_STREAM_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_value,
                    RealmAuditLog.NEW_VALUE: stream.id,
                },
            ).count(),
            1,
        )
        self.assertEqual(user.default_sending_stream, stream)

        old_value = user.default_events_register_stream_id
        do_change_default_events_register_stream(user, stream, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.USER_DEFAULT_REGISTER_STREAM_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_value,
                    RealmAuditLog.NEW_VALUE: stream.id,
                },
            ).count(),
            1,
        )
        self.assertEqual(user.default_events_register_stream, stream)

        old_value = user.default_all_public_streams
        do_change_default_all_public_streams(user, False, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.USER_DEFAULT_ALL_PUBLIC_STREAMS_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data={RealmAuditLog.OLD_VALUE: old_value, RealmAuditLog.NEW_VALUE: False},
            ).count(),
            1,
        )
        self.assertEqual(user.default_all_public_streams, False)

    def test_rename_stream(self) -> None:
        now = timezone_now()
        user = self.example_user("hamlet")
        stream = self.make_stream("test", user.realm)
        old_name = stream.name
        do_rename_stream(stream, "updated name", user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.CHANNEL_NAME_CHANGED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
                extra_data={
                    RealmAuditLog.OLD_VALUE: old_name,
                    RealmAuditLog.NEW_VALUE: "updated name",
                },
            ).count(),
            1,
        )
        self.assertEqual(stream.name, "updated name")

    def test_change_stream_folder(self) -> None:
        user = self.example_user("iago")
        stream = self.make_stream("test", user.realm)
        frontend_folder = check_add_channel_folder(user.realm, "Frontend", "", acting_user=user)
        backend_folder = check_add_channel_folder(user.realm, "Backend", "", acting_user=user)

        now = timezone_now()
        do_change_stream_folder(stream, frontend_folder, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.CHANNEL_FOLDER_CHANGED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
                extra_data={
                    RealmAuditLog.OLD_VALUE: None,
                    RealmAuditLog.NEW_VALUE: frontend_folder.id,
                },
            ).count(),
            1,
        )

        now = timezone_now()
        do_change_stream_folder(stream, backend_folder, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.CHANNEL_FOLDER_CHANGED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
                extra_data={
                    RealmAuditLog.OLD_VALUE: frontend_folder.id,
                    RealmAuditLog.NEW_VALUE: backend_folder.id,
                },
            ).count(),
            1,
        )

        now = timezone_now()
        do_change_stream_folder(stream, None, acting_user=user)
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.CHANNEL_FOLDER_CHANGED,
                event_time__gte=now,
                acting_user=user,
                modified_stream=stream,
                extra_data={
                    RealmAuditLog.OLD_VALUE: backend_folder.id,
                    RealmAuditLog.NEW_VALUE: None,
                },
            ).count(),
            1,
        )

    def test_change_user_settings(self) -> None:
        user = self.example_user("hamlet")
        value: bool | int | str | Enum
        test_values: dict[str, Any] = dict(
            default_language="de",
            web_animate_image_previews="on_hover",
            web_home_view="all_messages",
            emojiset="twitter",
            notification_sound="ding",
            resolved_topic_notice_auto_read_policy=ResolvedTopicNoticeAutoReadPolicyEnum.always,
        )

        for setting, setting_type in user.property_types.items():
            if setting in test_values:
                value = test_values[setting]
            elif setting_type is int:
                value = 3
            else:
                value = False
            now = timezone_now()

            old_value = getattr(user, setting)
            do_change_user_setting(user, setting, value, acting_user=user)
            if isinstance(value, Enum):
                new_value = value.value
            else:
                new_value = value
            expected_extra_data = {
                RealmAuditLog.OLD_VALUE: old_value,
                RealmAuditLog.NEW_VALUE: new_value,
                "property": setting,
            }
            self.assertEqual(
                RealmAuditLog.objects.filter(
                    realm=user.realm,
                    event_type=AuditLogEventType.USER_SETTING_CHANGED,
                    event_time__gte=now,
                    acting_user=user,
                    modified_user=user,
                    extra_data=expected_extra_data,
                ).count(),
                1,
            )
            self.assertEqual(getattr(user, setting), new_value)

    def test_realm_domain_entries(self) -> None:
        user = self.example_user("iago")
        initial_domains = get_realm_domains(user.realm)

        now = timezone_now()
        realm_domain = do_add_realm_domain(user.realm, "zulip.org", False, acting_user=user)
        added_domain = RealmDomainDict(
            domain="zulip.org",
            allow_subdomains=False,
        )
        expected_extra_data = {
            "realm_domains": [*initial_domains, added_domain],
            "added_domain": added_domain,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_DOMAIN_ADDED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        do_change_realm_domain(realm_domain, True, acting_user=user)
        changed_domain = RealmDomainDict(
            domain="zulip.org",
            allow_subdomains=True,
        )
        expected_extra_data = {
            "realm_domains": [*initial_domains, changed_domain],
            "changed_domain": changed_domain,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_DOMAIN_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        do_remove_realm_domain(realm_domain, acting_user=user)
        removed_domain = RealmDomainDict(
            domain="zulip.org",
            allow_subdomains=True,
        )
        expected_extra_data = {
            "realm_domains": initial_domains,
            "removed_domain": removed_domain,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_DOMAIN_REMOVED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

    def test_realm_playground_entries(self) -> None:
        user = self.example_user("iago")
        initial_playgrounds = get_realm_playgrounds(user.realm)
        now = timezone_now()
        playground_id = check_add_realm_playground(
            user.realm,
            acting_user=user,
            name="Python playground",
            pygments_language="Python",
            url_template="https://python.example.com{code}",
        )
        added_playground = RealmPlaygroundDict(
            id=playground_id,
            name="Python playground",
            pygments_language="Python",
            url_template="https://python.example.com{code}",
        )
        expected_extra_data = {
            "realm_playgrounds": [*initial_playgrounds, added_playground],
            "added_playground": added_playground,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_PLAYGROUND_ADDED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        realm_playground = RealmPlayground.objects.get(id=playground_id)
        do_remove_realm_playground(
            user.realm,
            realm_playground,
            acting_user=user,
        )
        removed_playground = {
            "name": "Python playground",
            "pygments_language": "Python",
            "url_template": "https://python.example.com{code}",
        }
        expected_extra_data = {
            "realm_playgrounds": initial_playgrounds,
            "removed_playground": removed_playground,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_PLAYGROUND_REMOVED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

    def test_realm_linkifier_entries(self) -> None:
        user = self.example_user("iago")
        initial_linkifiers = linkifiers_for_realm(user.realm.id)
        now = timezone_now()
        linkifier_id = do_add_linkifier(
            user.realm,
            pattern="#(?P<id>[123])",
            url_template="https://realm.com/my_realm_filter/{id}",
            example_input="#1",
            reverse_template="#{id}",
            alternative_url_templates=["https://realm.com/my_realm_filter/pull/{id}"],
            acting_user=user,
        )

        added_linkfier = LinkifierDict(
            pattern="#(?P<id>[123])",
            url_template="https://realm.com/my_realm_filter/{id}",
            id=linkifier_id,
            example_input="#1",
            reverse_template="#{id}",
            alternative_url_templates=["https://realm.com/my_realm_filter/pull/{id}"],
        )
        expected_extra_data = {
            "realm_linkifiers": [*initial_linkifiers, added_linkfier],
            "added_linkifier": added_linkfier,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_LINKIFIER_ADDED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        do_update_linkifier(
            user.realm,
            id=linkifier_id,
            pattern="#(?P<id>[0-9]+)",
            url_template="https://realm.com/my_realm_filter/issues/{id}",
            example_input="#15",
            reverse_template="#{id}",
            alternative_url_templates=[
                "https://realm.com/my_realm_filter/pull/{id}",
                "https://realm.com/my_realm_filter/discussions/{id}",
            ],
            acting_user=user,
        )
        changed_linkifier = LinkifierDict(
            pattern="#(?P<id>[0-9]+)",
            url_template="https://realm.com/my_realm_filter/issues/{id}",
            id=linkifier_id,
            example_input="#15",
            reverse_template="#{id}",
            alternative_url_templates=[
                "https://realm.com/my_realm_filter/pull/{id}",
                "https://realm.com/my_realm_filter/discussions/{id}",
            ],
        )
        expected_extra_data = {
            "realm_linkifiers": [*initial_linkifiers, changed_linkifier],
            "changed_linkifier": changed_linkifier,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_LINKIFIER_CHANGED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        do_remove_linkifier(
            user.realm,
            id=linkifier_id,
            acting_user=user,
        )
        removed_linkifier = {
            "pattern": "#(?P<id>[0-9]+)",
            "url_template": "https://realm.com/my_realm_filter/issues/{id}",
            "example_input": "#15",
            "reverse_template": "#{id}",
            "alternative_url_templates": [
                "https://realm.com/my_realm_filter/pull/{id}",
                "https://realm.com/my_realm_filter/discussions/{id}",
            ],
        }
        expected_extra_data = {
            "realm_linkifiers": initial_linkifiers,
            "removed_linkifier": removed_linkifier,
        }
        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_LINKIFIER_REMOVED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

    def test_realm_emoji_entries(self) -> None:
        user = self.example_user("iago")
        now = timezone_now()
        with get_test_image_file("img.png") as img_file:
            # Because we want to verify the IntegrityError handling
            # logic in check_add_realm_emoji rather than the primary
            # check in upload_emoji, we need to make this request via
            # that helper rather than via the API.
            realm_emoji = check_add_realm_emoji(
                realm=user.realm,
                name="test_emoji",
                author=user,
                image_file=img_file,
                content_type="image/png",
            )

        added_emoji = EmojiInfo(
            id=str(realm_emoji.id),
            name="test_emoji",
            source_url=get_emoji_url(
                get_emoji_file_name("image/png", realm_emoji.id), user.realm_id
            ),
            deactivated=False,
            author_id=user.id,
            still_url=None,
        )
        expected_extra_data = {
            "added_emoji": added_emoji,
        }

        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_EMOJI_ADDED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

        now = timezone_now()
        do_remove_realm_emoji(user.realm, "test_emoji", acting_user=user)

        deactivated_emoji = EmojiInfo(
            id=str(realm_emoji.id),
            name="test_emoji",
            source_url=get_emoji_url(
                get_emoji_file_name("image/png", realm_emoji.id), user.realm_id
            ),
            deactivated=True,
            author_id=user.id,
            still_url=None,
        )

        expected_extra_data = {
            "deactivated_emoji": deactivated_emoji,
        }

        self.assertEqual(
            RealmAuditLog.objects.filter(
                realm=user.realm,
                event_type=AuditLogEventType.REALM_EMOJI_REMOVED,
                event_time__gte=now,
                acting_user=user,
                extra_data=expected_extra_data,
            ).count(),
            1,
        )

    def test_system_user_groups_creation(self) -> None:
        now = timezone_now()
        realm = do_create_realm(string_id="test", name="foo")

        # The expected number of system user group is the total number of roles
        # from NamedUserGroup.SYSTEM_USER_GROUP_ROLE_MAP in addition to
        # full_members_system_group, everyone_on_internet_system_group and
        # nobody_system_group.
        expected_system_user_group_count = len(NamedUserGroup.SYSTEM_USER_GROUP_ROLE_MAP) + 3

        system_user_group_ids = sorted(
            NamedUserGroup.objects.filter(
                realm_for_sharding=realm,
                is_system_group=True,
            ).values_list("id", flat=True)
        )
        self.assert_length(system_user_group_ids, expected_system_user_group_count)

        logged_system_group_ids = sorted(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.USER_GROUP_CREATED,
                event_time__gte=now,
                acting_user=None,
            ).values_list("modified_user_group_id", flat=True)
        )
        self.assertListEqual(logged_system_group_ids, system_user_group_ids)

        logged_subgroup_entries = sorted(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
                event_time__gte=now,
                acting_user=None,
            ).values_list("modified_user_group_id", "extra_data")
        )
        logged_supergroup_entries = sorted(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.USER_GROUP_DIRECT_SUPERGROUP_MEMBERSHIP_ADDED,
                event_time__gte=now,
                acting_user=None,
            ).values_list("modified_user_group_id", "extra_data")
        )
        # Excluding nobody_system_group, the rest of the user groups should have
        # a chain of subgroup memberships in between.
        self.assert_length(logged_subgroup_entries, expected_system_user_group_count - 2)
        self.assert_length(logged_supergroup_entries, expected_system_user_group_count - 2)
        for i in range(len(logged_subgroup_entries)):
            # The offset of 1 is due to nobody_system_group being skipped as
            # the first user group in the list.
            # For supergroup, we add an additional 1 because of the order we
            # put the chain together.
            expected_subgroup_id = system_user_group_ids[i + 1]
            expected_supergroup_id = system_user_group_ids[i + 2]

            supergroup_id, subgroup_extra_data = logged_subgroup_entries[i]
            subgroup_id, supergroup_extra_data = logged_supergroup_entries[i]
            self.assertEqual(subgroup_extra_data["subgroup_ids"][0], expected_subgroup_id)
            self.assertEqual(supergroup_extra_data["supergroup_ids"][0], expected_supergroup_id)
            self.assertEqual(supergroup_id, expected_supergroup_id)
            self.assertEqual(subgroup_id, expected_subgroup_id)

    def test_user_group_creation(self) -> None:
        hamlet = self.example_user("hamlet")
        cordelia = self.example_user("cordelia")
        now = timezone_now()
        public_group = NamedUserGroup.objects.get(
            name=SystemGroups.EVERYONE_ON_INTERNET, realm_for_sharding=hamlet.realm
        )
        user_group = check_add_user_group(
            hamlet.realm,
            "empty",
            [hamlet, cordelia],
            acting_user=hamlet,
            description="lorem",
            group_settings_map={"can_mention_group": public_group},
        )

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_CREATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertEqual(audit_log_entries[0].modified_user_group, user_group)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )
        self.assert_length(audit_log_entries, 2)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[1].modified_user, cordelia)

    def test_change_user_group_memberships(self) -> None:
        hamlet = self.example_user("hamlet")
        cordelia = self.example_user("cordelia")
        now = timezone_now()
        user_group = check_add_user_group(hamlet.realm, "foo", [], acting_user=hamlet)

        bulk_add_members_to_user_groups([user_group], [hamlet.id, cordelia.id], acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            modified_user_group=user_group,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )
        self.assert_length(audit_log_entries, 2)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[1].modified_user, cordelia)

        bulk_remove_members_from_user_groups([user_group], [hamlet.id], acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            modified_user_group=user_group,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)

    def test_change_user_group_subgroups_memberships(self) -> None:
        hamlet = self.example_user("hamlet")
        user_group = check_add_user_group(hamlet.realm, "main", [], acting_user=hamlet)
        subgroups = [
            check_add_user_group(hamlet.realm, f"subgroup{num}", [], acting_user=hamlet)
            for num in range(3)
        ]

        now = timezone_now()
        add_subgroups_to_user_group(user_group, subgroups, acting_user=hamlet)
        # Only one audit log entry for the subgroup membership is expected.
        audit_log_entry = RealmAuditLog.objects.get(
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
        )
        self.assertEqual(audit_log_entry.modified_user_group, user_group)
        self.assertEqual(audit_log_entry.acting_user, hamlet)
        self.assertDictEqual(
            audit_log_entry.extra_data,
            {"subgroup_ids": [subgroup.id for subgroup in subgroups]},
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_SUPERGROUP_MEMBERSHIP_ADDED,
        ).order_by("id")
        self.assert_length(audit_log_entries, 3)
        for i in range(3):
            self.assertEqual(audit_log_entries[i].modified_user_group, subgroups[i])
            self.assertEqual(audit_log_entries[i].acting_user, hamlet)
            self.assertDictEqual(
                audit_log_entries[i].extra_data,
                {"supergroup_ids": [user_group.id]},
            )

        remove_subgroups_from_user_group(user_group, subgroups[:2], acting_user=hamlet)
        audit_log_entry = RealmAuditLog.objects.get(
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
        )
        self.assertEqual(audit_log_entry.modified_user_group, user_group)
        self.assertEqual(audit_log_entry.acting_user, hamlet)
        self.assertDictEqual(
            audit_log_entry.extra_data,
            {"subgroup_ids": [subgroup.id for subgroup in subgroups[:2]]},
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DIRECT_SUPERGROUP_MEMBERSHIP_REMOVED,
        ).order_by("id")
        self.assert_length(audit_log_entries, 2)
        for i in range(2):
            self.assertEqual(audit_log_entries[i].modified_user_group, subgroups[i])
            self.assertEqual(audit_log_entries[i].acting_user, hamlet)
            self.assertDictEqual(
                audit_log_entries[i].extra_data,
                {"supergroup_ids": [user_group.id]},
            )

    def test_user_group_property_change(self) -> None:
        hamlet = self.example_user("hamlet")
        user_group = check_add_user_group(
            hamlet.realm,
            "demo",
            [],
            description="No description",
            acting_user=hamlet,
        )
        now = timezone_now()

        do_update_user_group_name(user_group, "bar", acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            realm=hamlet.realm,
            event_type=AuditLogEventType.USER_GROUP_NAME_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: "demo",
                RealmAuditLog.NEW_VALUE: "bar",
            },
        )

        do_update_user_group_description(user_group, "Foo", acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            realm=hamlet.realm,
            event_type=AuditLogEventType.USER_GROUP_DESCRIPTION_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: "No description",
                RealmAuditLog.NEW_VALUE: "Foo",
            },
        )

        old_group = user_group.can_mention_group
        new_group = NamedUserGroup.objects.get(
            name=SystemGroups.EVERYONE_ON_INTERNET, realm_for_sharding=user_group.realm
        ).usergroup_ptr
        self.assertNotEqual(old_group.id, new_group.id)
        do_change_user_group_permission_setting(
            user_group,
            "can_mention_group",
            new_group,
            old_setting_api_value=old_group.id,
            acting_user=None,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_GROUP_GROUP_BASED_SETTING_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].acting_user)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: old_group.id,
                RealmAuditLog.NEW_VALUE: new_group.id,
                "property": "can_mention_group",
            },
        )

        moderators_group = NamedUserGroup.objects.get(
            name=SystemGroups.MODERATORS, realm_for_sharding=user_group.realm, is_system_group=True
        )
        old_group = user_group.can_mention_group
        new_group = self.create_or_update_anonymous_group_for_setting([hamlet], [moderators_group])

        now = timezone_now()
        do_change_user_group_permission_setting(
            user_group,
            "can_mention_group",
            new_group,
            old_setting_api_value=old_group.id,
            acting_user=None,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_GROUP_GROUP_BASED_SETTING_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].acting_user)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: old_group.id,
                RealmAuditLog.NEW_VALUE: {
                    "direct_members": [hamlet.id],
                    "direct_subgroups": [moderators_group.id],
                },
                "property": "can_mention_group",
            },
        )

        othello = self.example_user("othello")
        old_setting_api_value = get_group_setting_value_for_api(user_group.can_mention_group)
        # Since the old setting value was an anonymous group, we just update the
        # members and subgroups of the already existing UserGroup instead of creating
        # a new UserGroup object to keep this consistent with the actual code.
        new_group = self.create_or_update_anonymous_group_for_setting(
            [othello], [moderators_group], existing_setting_group=user_group.can_mention_group
        )

        now = timezone_now()
        do_change_user_group_permission_setting(
            user_group,
            "can_mention_group",
            new_group,
            old_setting_api_value=old_setting_api_value,
            acting_user=None,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_GROUP_GROUP_BASED_SETTING_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].acting_user)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: {
                    "direct_members": [hamlet.id],
                    "direct_subgroups": [moderators_group.id],
                },
                RealmAuditLog.NEW_VALUE: {
                    "direct_members": [othello.id],
                    "direct_subgroups": [moderators_group.id],
                },
                "property": "can_mention_group",
            },
        )

        old_setting_api_value = get_group_setting_value_for_api(user_group.can_mention_group)
        new_group = NamedUserGroup.objects.get(
            name=SystemGroups.EVERYONE, realm_for_sharding=user_group.realm, is_system_group=True
        )
        now = timezone_now()
        do_change_user_group_permission_setting(
            user_group,
            "can_mention_group",
            new_group,
            old_setting_api_value=old_setting_api_value,
            acting_user=None,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            event_type=AuditLogEventType.USER_GROUP_GROUP_BASED_SETTING_CHANGED,
            event_time__gte=now,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].acting_user)
        self.assertDictEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: {
                    "direct_members": [othello.id],
                    "direct_subgroups": [moderators_group.id],
                },
                RealmAuditLog.NEW_VALUE: new_group.id,
                "property": "can_mention_group",
            },
        )

    def test_user_group_deactivation_and_reactivation(self) -> None:
        hamlet = self.example_user("hamlet")
        cordelia = self.example_user("cordelia")
        user_group = check_add_user_group(
            hamlet.realm,
            "test",
            [hamlet, cordelia],
            acting_user=hamlet,
        )
        now = timezone_now()
        do_deactivate_user_group(user_group, acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_DEACTIVATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertEqual(audit_log_entries[0].modified_user_group, user_group)

        do_reactivate_user_group(user_group, acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_GROUP_REACTIVATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertEqual(audit_log_entries[0].modified_user_group, user_group)

    def test_channel_folders(self) -> None:
        iago = self.example_user("iago")
        now = timezone_now()
        channel_folder = check_add_channel_folder(
            iago.realm,
            "Frontend",
            "Channels for frontend discussions",
            acting_user=iago,
        )

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=iago.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.CHANNEL_FOLDER_CREATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertIsNone(audit_log_entries[0].modified_user_group)
        self.assertEqual(audit_log_entries[0].modified_channel_folder, channel_folder)

        do_change_channel_folder_name(
            channel_folder,
            "Web frontend",
            acting_user=iago,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=iago.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.CHANNEL_FOLDER_NAME_CHANGED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertIsNone(audit_log_entries[0].modified_user_group)
        self.assertEqual(audit_log_entries[0].modified_channel_folder, channel_folder)
        self.assertEqual(
            audit_log_entries[0].extra_data,
            {RealmAuditLog.OLD_VALUE: "Frontend", RealmAuditLog.NEW_VALUE: "Web frontend"},
        )

        do_change_channel_folder_description(
            channel_folder,
            "Channels for web frontend discussion",
            acting_user=iago,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=iago.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.CHANNEL_FOLDER_DESCRIPTION_CHANGED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertIsNone(audit_log_entries[0].modified_user_group)
        self.assertEqual(audit_log_entries[0].modified_channel_folder, channel_folder)
        self.assertEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: "Channels for frontend discussions",
                RealmAuditLog.NEW_VALUE: "Channels for web frontend discussion",
            },
        )

        do_archive_channel_folder(channel_folder, acting_user=iago)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=iago.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.CHANNEL_FOLDER_ARCHIVED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertIsNone(audit_log_entries[0].modified_user_group)
        self.assertEqual(audit_log_entries[0].modified_channel_folder, channel_folder)

        do_unarchive_channel_folder(channel_folder, acting_user=iago)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=iago.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.CHANNEL_FOLDER_UNARCHIVED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertIsNone(audit_log_entries[0].modified_user)
        self.assertIsNone(audit_log_entries[0].modified_user_group)
        self.assertEqual(audit_log_entries[0].modified_channel_folder, channel_folder)

    def test_navigation_view_entries(self) -> None:
        hamlet = self.example_user("hamlet")

        now = timezone_now()
        navigation_view = do_add_navigation_view(
            hamlet,
            "inbox",
            True,
            "Inbox",
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.NAVIGATION_VIEW_CREATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[0].extra_data, {"fragment": "inbox"})

        now = timezone_now()
        do_update_navigation_view(
            hamlet,
            navigation_view,
            False,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.NAVIGATION_VIEW_UPDATED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(
            audit_log_entries[0].extra_data,
            {
                "fragment": "inbox",
                RealmAuditLog.OLD_VALUE: True,
                RealmAuditLog.NEW_VALUE: False,
                "property": "is_pinned",
            },
        )

        now = timezone_now()
        do_update_navigation_view(hamlet, navigation_view, True, "Inbox view")
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.NAVIGATION_VIEW_UPDATED,
        )
        self.assert_length(audit_log_entries, 2)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[1].modified_user, hamlet)
        self.assertEqual(
            audit_log_entries[0].extra_data,
            {
                "fragment": "inbox",
                RealmAuditLog.OLD_VALUE: "Inbox",
                RealmAuditLog.NEW_VALUE: "Inbox view",
                "property": "name",
            },
        )
        self.assertEqual(
            audit_log_entries[1].extra_data,
            {
                "fragment": "inbox",
                RealmAuditLog.OLD_VALUE: False,
                RealmAuditLog.NEW_VALUE: True,
                "property": "is_pinned",
            },
        )

        now = timezone_now()
        do_remove_navigation_view(
            hamlet,
            navigation_view,
        )
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.NAVIGATION_VIEW_DELETED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[0].extra_data, {"fragment": "inbox"})

    def test_changing_is_imported_stub(self) -> None:
        hamlet = self.example_user("hamlet")
        hamlet.is_imported_stub = True
        hamlet.save()

        now = timezone_now()
        do_change_is_imported_stub(hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_IS_IMPORTED_STUB_CHANGED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(audit_log_entries[0].extra_data, {})

    def test_updating_date_joined(self) -> None:
        hamlet = self.example_user("hamlet")
        old_value = hamlet.date_joined

        now = timezone_now()

        do_change_user_date_joined(hamlet, now)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=hamlet.realm,
            event_time__gte=now,
            event_type=AuditLogEventType.USER_DATE_JOINED_CHANGED,
        )
        self.assert_length(audit_log_entries, 1)
        self.assertEqual(audit_log_entries[0].modified_user, hamlet)
        self.assertEqual(
            audit_log_entries[0].extra_data,
            {
                RealmAuditLog.OLD_VALUE: old_value.isoformat(),
                RealmAuditLog.NEW_VALUE: now.isoformat(),
            },
        )

    def test_updating_workplace_users_group(self) -> None:
        iago = self.example_user("iago")
        realm = iago.realm
        members_group = NamedUserGroup.objects.get(
            name=SystemGroups.MEMBERS, realm_for_sharding=realm
        )
        now = timezone_now()

        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", members_group, acting_user=iago
        )

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=iago,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.REALM_PROPERTY_CHANGED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)
        self.assertEqual(audit_log_entries[0].event_type, AuditLogEventType.REALM_PROPERTY_CHANGED)

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "setting_changed")

    def test_workplace_users_count_when_changing_role(self) -> None:
        """
        Verify that the USER_ROLE_CHANGED audit log entry records the
        correct workplace_users count in its ROLE_COUNT extra_data.
        """
        realm = get_realm("zulip")
        user_profile = self.example_user("hamlet")
        self.assertEqual(user_profile.role, UserProfile.ROLE_MEMBER)
        moderators_group = NamedUserGroup.objects.get(
            name=SystemGroups.MODERATORS, realm_for_sharding=realm, is_system_group=True
        )
        full_members_group = NamedUserGroup.objects.get(
            name=SystemGroups.FULL_MEMBERS, realm_for_sharding=realm, is_system_group=True
        )
        members_group = NamedUserGroup.objects.get(
            name=SystemGroups.MEMBERS, realm_for_sharding=realm, is_system_group=True
        )

        # Check when workplace_users_group is set to a system group
        # where just role counts are enough to compute workplace
        # users count.
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", moderators_group, acting_user=None
        )
        realm.refresh_from_db()
        now = timezone_now()
        do_change_user_role(
            user_profile, UserProfile.ROLE_REALM_ADMINISTRATOR, acting_user=None, notify=False
        )
        role_changed_entry = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_ROLE_CHANGED,
        ).latest("id")
        self.assertEqual(
            role_changed_entry.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )
        # We skip creating WORKPLACE_USERS_COUNT_CHAGNED entry since
        # USER_ROLE_CHANGED entry already has the correct user count.
        self.assertFalse(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
                event_time__gte=now,
            ).exists()
        )

        # Check when workplace_users_group is set to a system group
        # where just role counts are not enough and group membership
        # is used to compute workplace users count.
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", full_members_group, acting_user=None
        )
        realm.refresh_from_db()
        now = timezone_now()
        do_change_user_role(user_profile, UserProfile.ROLE_GUEST, acting_user=None, notify=False)
        role_changed_entry = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_ROLE_CHANGED,
        ).latest("id")
        self.assertEqual(
            role_changed_entry.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )
        self.assertFalse(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
                event_time__gte=now,
            ).exists()
        )

        # Check with workplace_users_group set to an anonymous group.
        do_change_realm_permission_group_setting(
            realm,
            "workplace_users_group",
            self.create_or_update_anonymous_group_for_setting([], [members_group]),
            acting_user=None,
        )
        realm.refresh_from_db()
        now = timezone_now()
        do_change_user_role(user_profile, UserProfile.ROLE_MEMBER, acting_user=None, notify=False)
        role_changed_entry = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_ROLE_CHANGED,
        ).latest("id")
        self.assertEqual(
            role_changed_entry.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )
        self.assertFalse(
            RealmAuditLog.objects.filter(
                realm=realm,
                event_type=AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
                event_time__gte=now,
            ).exists()
        )

    def test_workplace_users_count_when_creating_user(self) -> None:
        """
        Verify that the USER_CREATED audit log entry records the
        correct workplace_users count in its ROLE_COUNT extra_data.
        """
        realm = get_realm("zulip")
        full_members_group = NamedUserGroup.objects.get(
            name=SystemGroups.FULL_MEMBERS, realm_for_sharding=realm, is_system_group=True
        )
        members_group = NamedUserGroup.objects.get(
            name=SystemGroups.MEMBERS, realm_for_sharding=realm, is_system_group=True
        )
        moderators_group = NamedUserGroup.objects.get(
            name=SystemGroups.MODERATORS, realm_for_sharding=realm, is_system_group=True
        )

        # Check when workplace_users_group is set to a system group
        # where just role counts are enough to compute workplace
        # users count.
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", moderators_group, acting_user=None
        )
        realm.refresh_from_db()
        user_profile = do_create_user(
            "[email protected]", "password", realm, "Moderators case", acting_user=None
        )
        user_created_audit_log = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_CREATED,
        ).latest("id")
        self.assertEqual(
            user_created_audit_log.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )

        # Check when workplace_users_group is set to a system group
        # where just role counts are not enough and group membership
        # is used to compute workplace users count.
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", full_members_group, acting_user=None
        )
        realm.refresh_from_db()
        user_profile = do_create_user(
            "[email protected]", "password", realm, "Full members case", acting_user=None
        )
        user_created_audit_log = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_CREATED,
        ).latest("id")
        self.assertEqual(
            user_created_audit_log.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )

        # Check with workplace_users_group set to an anonymous group.
        do_change_realm_permission_group_setting(
            realm,
            "workplace_users_group",
            self.create_or_update_anonymous_group_for_setting([], [members_group]),
            acting_user=None,
        )
        realm.refresh_from_db()
        user_profile = do_create_user(
            "[email protected]", "password", realm, "Anonymous group case", acting_user=None
        )
        user_created_audit_log = RealmAuditLog.objects.filter(
            realm=realm,
            modified_user=user_profile,
            event_type=AuditLogEventType.USER_CREATED,
        ).latest("id")
        self.assertEqual(
            user_created_audit_log.extra_data[RealmAuditLog.ROLE_COUNT][
                RealmAuditLog.ROLE_COUNT_HUMANS
            ]["workplace_users"],
            get_recursive_group_members(realm.workplace_users_group_id)
            .filter(is_bot=False, is_active=True)
            .count(),
        )

    def test_workplace_users_group_changed_entries_on_updating_group_memberships(self) -> None:
        hamlet = self.example_user("hamlet")
        othello = self.example_user("othello")
        cordelia = self.example_user("cordelia")
        realm = hamlet.realm
        test_group = check_add_user_group(realm, "test_group", [hamlet], acting_user=hamlet)
        test_group_2 = check_add_user_group(realm, "test_group_2", [hamlet], acting_user=hamlet)

        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", test_group, acting_user=None
        )

        now = timezone_now()
        bulk_add_members_to_user_groups(
            [test_group, test_group_2], [othello.id], acting_user=hamlet
        )

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 3)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )
        self.assertEqual(
            audit_log_entries[1].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )

        self.assertEqual(
            audit_log_entries[2].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[2].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[2].extra_data)
        self.assertEqual(audit_log_entries[2].extra_data["trigger"], "user_membership_changed")

        add_subgroups_to_user_group(test_group, [test_group_2], acting_user=hamlet)

        now = timezone_now()
        bulk_add_members_to_user_groups([test_group_2], [cordelia.id], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "user_membership_changed")

        # Set workplace_users_group to an anonymous group containing the group
        # whose membership is being updated.
        anonymous_group = self.create_or_update_anonymous_group_for_setting(
            [self.example_user("iago")], [test_group]
        )
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", anonymous_group, acting_user=None
        )

        now = timezone_now()
        bulk_remove_members_from_user_groups([test_group], [othello.id], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "user_membership_changed")

        now = timezone_now()
        bulk_remove_members_from_user_groups([test_group_2], [cordelia.id], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "user_membership_changed")

        # Update membership for a group not being used for workplace_users_group.
        hamletcharacters_group = NamedUserGroup.objects.get(
            name="hamletcharacters", realm_for_sharding=realm
        )

        now = timezone_now()
        bulk_add_members_to_user_groups([hamletcharacters_group], [othello.id], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 1)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_ADDED,
        )

        now = timezone_now()
        bulk_remove_members_from_user_groups(
            [hamletcharacters_group], [othello.id], acting_user=hamlet
        )

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 1)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_USER_MEMBERSHIP_REMOVED,
        )

    def test_workplace_users_group_changed_entries_on_updating_group_subgroups(self) -> None:
        hamlet = self.example_user("hamlet")
        othello = self.example_user("othello")
        realm = hamlet.realm
        test_group = check_add_user_group(realm, "test_group", [hamlet], acting_user=hamlet)
        test_group_2 = check_add_user_group(realm, "test_group_2", [hamlet], acting_user=hamlet)
        test_group_3 = check_add_user_group(realm, "test_group_3", [othello], acting_user=hamlet)

        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", test_group, acting_user=None
        )

        now = timezone_now()
        add_subgroups_to_user_group(test_group, [test_group_2], acting_user=hamlet)
        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "subgroups_changed")

        now = timezone_now()
        add_subgroups_to_user_group(test_group_2, [test_group_3], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "subgroups_changed")

        # Set workplace_users_group to an anonymous group containing the group
        # whose subgroups are being updated.
        anonymous_group = self.create_or_update_anonymous_group_for_setting(
            [self.example_user("iago")], [test_group]
        )
        do_change_realm_permission_group_setting(
            realm, "workplace_users_group", anonymous_group, acting_user=None
        )

        now = timezone_now()
        remove_subgroups_from_user_group(test_group_2, [test_group_3], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "subgroups_changed")

        now = timezone_now()
        remove_subgroups_from_user_group(test_group, [test_group_2], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 2)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
        )

        self.assertEqual(
            audit_log_entries[1].event_type, AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED
        )
        self.check_role_count_schema(audit_log_entries[1].extra_data[RealmAuditLog.ROLE_COUNT])
        self.assertNotIn(RealmAuditLog.OLD_VALUE, audit_log_entries[1].extra_data)
        self.assertEqual(audit_log_entries[1].extra_data["trigger"], "subgroups_changed")

        # Update subgroups for a group not being used for workplace_users_group.
        # Here subgroup is being used in workplace_users_group, but adding it as
        # subgroup to another group does not change membership of workplace_users_group.
        hamletcharacters_group = NamedUserGroup.objects.get(
            name="hamletcharacters", realm_for_sharding=realm
        )

        now = timezone_now()

        add_subgroups_to_user_group(hamletcharacters_group, [test_group], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 1)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_ADDED,
        )

        now = timezone_now()
        remove_subgroups_from_user_group(hamletcharacters_group, [test_group], acting_user=hamlet)

        audit_log_entries = RealmAuditLog.objects.filter(
            acting_user=hamlet,
            realm=realm,
            event_time__gte=now,
            event_type__in=[
                AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
                AuditLogEventType.WORKPLACE_USERS_COUNT_CHANGED,
            ],
        )
        self.assert_length(audit_log_entries, 1)

        self.assertEqual(
            audit_log_entries[0].event_type,
            AuditLogEventType.USER_GROUP_DIRECT_SUBGROUP_MEMBERSHIP_REMOVED,
        )