Method get_scan_findings

db_manager.py:2206–2248

Get all findings for a specific scan. Args: scan_id: Scan ID to get findings for Returns: List of finding dicts

(self, scan_id: str)

                    json.dumps(tags) if tags else None,
                    matched_at, template_id,
                    raw_output[:10000] if raw_output else None,
                    json.dumps(details) if details else None
                ))

                conn.commit()
                return True
        except Exception as e:
            logger.error(f"Failed to save finding {finding_id}: {e}")
            return False

    def get_scan_findings(self, scan_id: str) -> List[Dict[str, Any]]:
        """
        Get all findings for a specific scan.

        Args:
            scan_id: Scan ID to get findings for

        Returns:
            List of finding dicts
        """
        try:
            with self.get_connection() as conn:
                cursor = conn.cursor()
                cursor.execute("""
                    SELECT * FROM scan_findings
                    WHERE scan_id = ?
                    ORDER BY
                        CASE severity
                            WHEN 'critical' THEN 1
                            WHEN 'high' THEN 2
                            WHEN 'medium' THEN 3
                            WHEN 'low' THEN 4
                            ELSE 5
                        END,
                        timestamp DESC
                """, (scan_id,))

                results = []
                for row in cursor.fetchall():
                    result = dict(row)
                    # Parse JSON fields
                    for field in ['cve_ids', 'cwe_ids', 'reference_urls', 'tags', 'details']:
                        if result.get(field):
                            try:
                                result[field] = json.loads(result[field])
                            except json.JSONDecodeError: