Exemple #1
0
    def all(self, user, filters_list=None, addrs=None, act=3):
        "message totals"
        from django.db import connection
        from baruwa.utils.misc import raw_user_filter
        from baruwa.reports.utils import gen_dynamic_raw_query
        conn = connection.cursor()
        query = """
            SELECT date, count(*) AS mail_total,
            SUM(CASE WHEN virusinfected>0 THEN 1 ELSE 0 END)
            AS virus_total, SUM(CASE WHEN (virusinfected=0)
            AND spam>0 THEN 1 ELSE 0 END) AS spam_total,
            SUM(size) AS size_total FROM messages
            """
        if filters_list:
            sub = gen_dynamic_raw_query(filters_list)
            if user.is_superuser:
                conn.execute(query + " WHERE " + sub[0] +
                " GROUP BY date ORDER BY date DESC", sub[1])
            else:
                sql = raw_user_filter(user, addrs, act)
                conn.execute(query + " WHERE " + sql + " AND " + sub[0] +
                " GROUP BY date ORDER BY date DESC", sub[1])
        else:
            if user.is_superuser:
                query = "%s GROUP BY date ORDER BY date DESC" % query
                conn.execute(query)
            else:
                sql = raw_user_filter(user, addrs, act)
                query = """%s WHERE %s GROUP BY date ORDER BY date
                DESC""" % (query, sql)
                conn.execute(query)

        result_list = map(self.makevals, enumerate(conn.fetchall()))
        return result_list
Exemple #2
0
    def all(self, user, filters_list=None, addrs=None, act=3):
        "message totals"
        from django.db import connection
        from baruwa.utils.misc import raw_user_filter
        from baruwa.reports.utils import gen_dynamic_raw_query

        conn = connection.cursor()
        query = """
            SELECT date, count(*) AS mail_total,
            SUM(CASE WHEN virusinfected>0 THEN 1 ELSE 0 END)
            AS virus_total, SUM(CASE WHEN (virusinfected=0)
            AND spam>0 THEN 1 ELSE 0 END) AS spam_total,
            SUM(size) AS size_total FROM messages
            """
        if filters_list:
            sub = gen_dynamic_raw_query(filters_list)
            if user.is_superuser:
                conn.execute(query + " WHERE " + sub[0] +
                " GROUP BY date ORDER BY date DESC",sub[1])
            else:
                sql = raw_user_filter(user, addrs, act)
                conn.execute(query + " WHERE " + sql +" AND "+ sub[0] +
                " GROUP BY date ORDER BY date DESC", sub[1])
        else:
            if user.is_superuser:
                query = "%s GROUP BY date ORDER BY date DESC" % query
                conn.execute(query)
            else:
                sql = raw_user_filter(user, addrs, act)
                query = """%s WHERE %s GROUP BY date ORDER BY date
                DESC""" % (query, sql)
                conn.execute(query)
        result_list = []
        for i, row in enumerate(conn.fetchall()):
            index = i
            index += 1
            vpct = "%.1f" % ((1.0 * int(row[2])/int(row[1]))*100)
            spct = "%.1f" % ((1.0 * int(row[3])/int(row[1]))*100)
            obj = self.model(id=index, date=str(row[0]),
                mail_total=int(row[1]), virus_total=int(row[2]),
                virus_percent=vpct, spam_total=int(row[3]),
                spam_percent=spct, size_total=int(row[4]))
            obj.total = row[1]
            result_list.append(obj)
        return result_list
Exemple #3
0
    def all(self, user, filters_list=None, addrs=None, act=3):
        "spam scores"
        from django.db import connection
        from baruwa.utils.misc import raw_user_filter
        from baruwa.reports.utils import gen_dynamic_raw_query

        conn = connection.cursor()
        query = """
        SELECT round(sascore) AS score, count(*) AS count FROM messages
        """

        if filters_list:
            sub = gen_dynamic_raw_query(filters_list)
            if user.is_superuser:
                conn.execute(query + " WHERE " +  sub[0] +
                " AND whitelisted=0 AND scaned = 1 GROUP" +
                " BY score ORDER BY score", sub[1])
            else:
                sql = raw_user_filter(user, addrs, act)
                conn.execute(query + " WHERE " + sql + " AND "+ sub[0] +
                " AND whitelisted=0 AND scaned = 1 GROUP BY" +
                " score ORDER BY score", sub[1])
        else:
            if user.is_superuser:
                query = """%s WHERE whitelisted=0 AND scaned = 1 GROUP BY
                        score ORDER BY score""" % query
                conn.execute(query)
            else:
                sql = raw_user_filter(user, addrs, act)
                gql = """WHERE %s AND whitelisted=0 AND scaned = 1 GROUP
                    BY score ORDER BY score""" % sql
                query = "%s %s" % (query, gql)
                conn.execute(query)
        #rows = c.fetchall()
        result_list = []
        for i, row in enumerate(conn.fetchall()):
            index = i
            index += 1
            obj = self.model(id=index, score=row[0], count=int(row[1]))
            result_list.append(obj)

        return result_list
Exemple #4
0
    def all(self, user, filters_list=None, addrs=None, act=3):
        "spam scores"
        from django.db import connection
        from baruwa.utils.misc import raw_user_filter
        from baruwa.reports.utils import gen_dynamic_raw_query

        conn = connection.cursor()
        query = """
        SELECT round(sascore) AS score, count(*) AS count FROM messages
        """

        if filters_list:
            sub = gen_dynamic_raw_query(filters_list)
            if user.is_superuser:
                conn.execute(
                    query + " WHERE " + sub[0] +
                    " AND whitelisted=0 AND scaned = 1 GROUP" +
                    " BY score ORDER BY score", sub[1])
            else:
                sql = raw_user_filter(user, addrs, act)
                conn.execute(
                    query + " WHERE " + sql + " AND " + sub[0] +
                    " AND whitelisted=0 AND scaned = 1 GROUP BY" +
                    " score ORDER BY score", sub[1])
        else:
            if user.is_superuser:
                query = """%s WHERE whitelisted=0 AND scaned = 1 GROUP BY
                        score ORDER BY score""" % query
                conn.execute(query)
            else:
                sql = raw_user_filter(user, addrs, act)
                gql = """WHERE %s AND whitelisted=0 AND scaned = 1 GROUP
                    BY score ORDER BY score""" % sql
                query = "%s %s" % (query, gql)
                conn.execute(query)
        result_list = [
            self.model(id=i + 1, score=row[0], count=int(row[1]))
            for i, row in enumerate(conn.fetchall())
        ]
        return result_list
Exemple #5
0
    def all(self, user, filters_list=None, addrs=None, act=3):
        "message totals"
        from django.db import connection
        from baruwa.utils.misc import raw_user_filter
        from baruwa.reports.utils import gen_dynamic_raw_query
        conn = connection.cursor()
        query = """
            SELECT date, count(*) AS mail_total,
            SUM(CASE WHEN virusinfected>0 THEN 1 ELSE 0 END)
            AS virus_total, SUM(CASE WHEN (virusinfected=0)
            AND spam>0 THEN 1 ELSE 0 END) AS spam_total,
            SUM(size) AS size_total FROM messages
            """
        if filters_list:
            sub = gen_dynamic_raw_query(filters_list)
            if user.is_superuser:
                conn.execute(
                    query + " WHERE " + sub[0] +
                    " GROUP BY date ORDER BY date DESC", sub[1])
            else:
                sql = raw_user_filter(user, addrs, act)
                conn.execute(
                    query + " WHERE " + sql + " AND " + sub[0] +
                    " GROUP BY date ORDER BY date DESC", sub[1])
        else:
            if user.is_superuser:
                query = "%s GROUP BY date ORDER BY date DESC" % query
                conn.execute(query)
            else:
                sql = raw_user_filter(user, addrs, act)
                query = """%s WHERE %s GROUP BY date ORDER BY date
                DESC""" % (query, sql)
                conn.execute(query)

        result_list = map(self.makevals, enumerate(conn.fetchall()))
        return result_list