Method get_findings_summary

db_manager.py:2313–2360

Get summary statistics for all findings. Returns: Dict with summary stats (counts by severity, scanner, etc.)

(self)

                        if result.get(field):
                            try:
                                result[field] = json.loads(result[field])
                            except json.JSONDecodeError:
                                result[field] = []
                    results.append(result)

                return results
        except Exception as e:
            logger.error(f"Failed to get all findings: {e}")
            return []

    def get_findings_summary(self) -> Dict[str, Any]:
        """
        Get summary statistics for all findings.

        Returns:
            Dict with summary stats (counts by severity, scanner, etc.)
        """
        try:
            with self.get_connection() as conn:
                cursor = conn.cursor()

                summary = {
                    'total': 0,
                    'by_severity': {},
                    'by_scanner': {},
                    'unique_hosts': 0
                }

                # Total count
                cursor.execute("SELECT COUNT(*) FROM scan_findings")
                summary['total'] = cursor.fetchone()[0]

                # By severity
                cursor.execute("""
                    SELECT severity, COUNT(*) as count
                    FROM scan_findings
                    GROUP BY severity
                """)
                for row in cursor.fetchall():
                    summary['by_severity'][row['severity']] = row['count']

                # By scanner
                cursor.execute("""
                    SELECT scanner, COUNT(*) as count
                    FROM scan_findings
                    GROUP BY scanner
                """)
                for row in cursor.fetchall():
                    summary['by_scanner'][row['scanner']] = row['count']

                # Unique hosts