Traverse sbom_graph_path records bottom up

Rushik Subbarequested to merge
srushik/rewrite_sbom_path_finder into master

What does this MR do and why?

Traverse sbom_graph_path records bottom up.

DB Changes

Query added -

SELECT ancestor_id
FROM sbom_graph_paths
WHERE descendant_id = 1
  AND created_at =
    (SELECT max(created_at)
     FROM sbom_graph_paths
     WHERE project_id = 1);
  AND top_level_ancestor = TRUE

Execution plan

References

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Rushik Subba

Merge request reports