Skip to content

Backfill sbom_occurrences traversal_ids and archived columns

Brian Williams requested to merge bwill/backfill-sbom-occurrences-traversal-ids-and-archived into master

What does this MR do and why?

Backfills sbom_occurrences.traversal_ids and sbom_occurrences.archived columns with values from sbom_occurrences.project.namespace.traversal_ids and sbom_occurrences.project.archived. This is being done to remove a subquery and a join from the dependency list query.

Relates to: #437638 (closed)

We are migrating the entire table because there is a risk that existing records could be wrong:

  1. !144765 (comment 1778796337)
  2. !143104 (comment 1749754350)

MR acceptance checklist

Please 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 Brian Williams

Merge request reports