Skip to content

Add vulnerabilities column to sbom_occurrences

Zamir Martins requested to merge add_vulnerabilities_to_sbom_occurrences into master

What does this MR do and why?

Related issue: #426121 (closed)

Add vulnerabilities column to sbom_occurrences table.

This PoC MR can provide some context into this change.

EE: true Changelog: added

DB migrate

bundle exec rails db:migrate:redo:main VERSION=20230915100513
main: == [advisory_lock_connection] object_id: 226960, pg_backend_pid: 83873
main: == 20230915100513 AddVulnerabilitiesToSbomOccurrences: reverting ==============
main: -- remove_column(:sbom_occurrences, :vulnerabilities, :jsonb, {:default=>[]})
main:    -> 0.0033s
main: == 20230915100513 AddVulnerabilitiesToSbomOccurrences: reverted (0.0088s) =====

main: == [advisory_lock_connection] object_id: 226960, pg_backend_pid: 83873
main: == [advisory_lock_connection] object_id: 227760, pg_backend_pid: 84130
main: == 20230915100513 AddVulnerabilitiesToSbomOccurrences: migrating ==============
main: -- add_column(:sbom_occurrences, :vulnerabilities, :jsonb, {:default=>[]})
main:    -> 0.0042s
main: == 20230915100513 AddVulnerabilitiesToSbomOccurrences: migrated (0.0075s) =====

main: == [advisory_lock_connection] object_id: 227760, pg_backend_pid: 84130

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Zamir Martins

Merge request reports