Backfill sbom_occurrences traversal_ids and archived columns
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:
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