Function finding_occurrence_rows

plugins/codex-security/scripts/workbench_db.py:3158–3180

(
    connection: sqlite3.Connection, scan_id: str, *, offset: int, limit: int
)

def finding_occurrence_rows(
    connection: sqlite3.Connection, scan_id: str, *, offset: int, limit: int
) -> list[sqlite3.Row]:
    return connection.execute(
        """
        SELECT id, finding_id, title, summary, severity, confidence, remediation, details_json, created_at
        FROM finding_occurrences
        WHERE scan_id = ?
        ORDER BY
            CASE severity
                WHEN 'critical' THEN 0
                WHEN 'high' THEN 1
                WHEN 'medium' THEN 2
                WHEN 'low' THEN 3
                WHEN 'informational' THEN 4
                ELSE 5
            END,
            created_at,
            id
        LIMIT ? OFFSET ?
        """,
        (scan_id, limit, offset),
    ).fetchall()


def backfill_legacy_finding_details(connection: sqlite3.Connection, scan: sqlite3.Row) -> None: