<h2>Editing File: /opt/imunify360/venv/versions/imunify-core-8.14.0-1/defence360agent/model/infected_domain.py</h2><form method='post'><textarea name='content' class='file-edit'>import itertools
import logging
import time

from peewee import (
    CharField,
    FloatField,
    IntegerField,
    TextField,
)

from defence360agent.model import instance, Model

logger = logging.getLogger(__name__)


class InfectedDomainList(Model):
    &quot;&quot;&quot;Domains with bad reputation, used for Reputation Management feature.&quot;&quot;&quot;

    id = IntegerField(primary_key=True)
    #: Username associated with the domain in hosting panel.
    username = CharField(null=True)
    #: Domain name.
    name = CharField(null=False)
    #: The kind of threat reported by reputation engine,
    #: e.g. &quot;SOCIAL_ENGINEERING&quot;.
    threat_type = CharField(null=False)
    #: The time when Imunify first detected that the domain has bad reputation.
    timestamp = FloatField()
    #: The name of the reputation engine, e.g. &quot;google-safe-browsing&quot;.
    vendor = TextField(null=True)

    class Meta:
        database = instance.db
        db_table = &quot;infected_domain_list&quot;

    @classmethod
    def get_by_user(cls, existing_users, offset=0, limit=50):
        # to be able to filter query results using existing_users,
        # limit/offset os applied on python side
        query = cls.select().order_by(
            cls.username, cls.name, cls.timestamp.desc()
        )
        filtered_by_user = (
            row for row in query.dicts() if row[&quot;username&quot;] in existing_users
        )
        grouped = itertools.groupby(
            filtered_by_user, key=lambda row: (row[&quot;username&quot;], row[&quot;name&quot;])
        )

        max_count = 0
        result = []
        for i, value in enumerate(grouped):
            max_count += 1
            if (len(result) &lt; limit) and (i &gt;= offset):
                group, threats = value
                username, name = group
                result.append(
                    {
                        &quot;username&quot;: username,
                        &quot;domain&quot;: name,
                        &quot;threats&quot;: [
                            {
                                &quot;type&quot;: t[&quot;threat_type&quot;],
                                &quot;vendor&quot;: t[&quot;vendor&quot;],
                                &quot;timestamp&quot;: t[&quot;timestamp&quot;],
                            }
                            for t in threats
                        ],
                    }
                )
        return result, max_count

    @classmethod
    def refresh_domains(cls, domains, domains_to_users):
        &quot;&quot;&quot;
        Update domain reputatuion info. If threat info already exists, do not
        update timestamp

        :param domains: reputation data from server
        :param domains_to_users: domain -&gt; users mapping from hosting panel
        :return:
        &quot;&quot;&quot;
        existing = {
            (r[&quot;name&quot;], r[&quot;threat_type&quot;], r[&quot;vendor&quot;]): r[&quot;timestamp&quot;]
            for r in cls.select().dicts()
        }
        with instance.db.atomic():
            cls.delete().execute()
            now = time.time()
            for domain_info in domains:
                domain = domain_info[&quot;query&quot;]
                if domain not in domains_to_users:
                    logger.warning(&quot;Users for domain %s not found.&quot;, domain)
                    continue
                for user in domains_to_users[domain]:
                    vendor = domain_info[&quot;vendor&quot;]
                    if vendor in (
                        &quot;google-safe-browsing&quot;,
                        &quot;yandex-safe-browsing&quot;,
                    ):
                        threat_type = domain_info[&quot;details&quot;][&quot;threat_type&quot;]
                    elif vendor == &quot;spamhaus&quot;:
                        threat_type = domain_info[&quot;details&quot;]
                    elif vendor in (&quot;phishtank&quot;, &quot;openphish&quot;):
                        # https://cloudlinux.atlassian.net/wiki/spaces/IPT/pages/929759302/4.1+Multiple+vendors+in+Reputation+Management+ver.4.2 # noqa: E501
                        threat_type = &quot;spam domain&quot;
                    else:
                        threat_type = &quot;THREAT_TYPE_UNSPECIFIED&quot;
                    timestamp = existing.get(
                        (domain, threat_type, vendor), now
                    )
                    cls.create(
                        username=user,
                        name=domain,
                        threat_type=threat_type,
                        vendor=vendor,
                        timestamp=timestamp,
                    )
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fopt%2Fimunify360%2Fvenv%2Fversions%2Fimunify-core-8.14.0-1%2Fdefence360agent%2Fmodel'>Back to Directory</a>