Add vulnerabilities column to sbom_occurrences
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.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Zamir Martins