Skip to content

Add source package name to component versions table

Tetiana Chupryna requested to merge 427095-add-column-source-package-name-to-sbom-component-versions into master

What does this MR do and why?

Info: !136241 (comment 1677179173)

Add source package name to component versions

Changelog: added

Migration

UP

rails db:migrate VERSION=20231211100717
main: == [advisory_lock_connection] object_id: 182640, pg_backend_pid: 78879
main: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: migrating ======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- add_column(:sbom_component_versions, :source_package_name, :text, {:if_not_exists=>true})
main:    -> 0.1084s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE sbom_component_versions\nADD CONSTRAINT check_39636b9a8a\nCHECK ( char_length(source_package_name) <= 255 )\nNOT VALID;\n")
main:    -> 0.0029s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE sbom_component_versions VALIDATE CONSTRAINT check_39636b9a8a;")
main:    -> 0.0005s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: migrated (0.1403s) 

main: == [advisory_lock_connection] object_id: 182640, pg_backend_pid: 78879
ci: == [advisory_lock_connection] object_id: 183000, pg_backend_pid: 78881
ci: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: migrating ======
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- add_column(:sbom_component_versions, :source_package_name, :text, {:if_not_exists=>true})
ci:    -> 0.0080s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE sbom_component_versions\nADD CONSTRAINT check_39636b9a8a\nCHECK ( char_length(source_package_name) <= 255 )\nNOT VALID;\n")
ci:    -> 0.0027s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0004s
ci: -- execute("ALTER TABLE sbom_component_versions VALIDATE CONSTRAINT check_39636b9a8a;")
ci:    -> 0.0011s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0002s
ci: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: migrated (0.0304s) 

ci: == [advisory_lock_connection] object_id: 183000, pg_backend_pid: 78881

DOWN

rails db:rollback:main VERSION=20231211100717
main: == [advisory_lock_connection] object_id: 183160, pg_backend_pid: 79556
main: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: reverting ======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_column(:sbom_component_versions, :source_package_name, {:if_exists=>true})
main:    -> 0.1210s
main: == 20231211100717 AddSourcePackageNameToSbomComponentVersions: reverted (0.1331s) 

main: == [advisory_lock_connection] object_id: 183160, pg_backend_pid: 79556

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

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

Related to #427095 (closed)

Edited by Tetiana Chupryna

Merge request reports