Skip to content

Add column in database to support new conan metadata

  • Please check this box if this contribution uses AI-generated content (including content generated by GitLab Duo features) as outlined in the GitLab DCO & CLA

What does this MR do and why?

Add the database columns to support new Conan Metadata.

First step of issue #33892

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.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Database Review

rake db:migrate:up
main: == 20240626102543 AddExtraMetadataToPackagesConanMetadata: migrating ==========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- add_column(:packages_conan_metadata, :package_os, :text, {:if_not_exists=>true})
main:    -> 0.0036s
main: -- add_column(:packages_conan_metadata, :package_architecture, :text, {:if_not_exists=>true})
main:    -> 0.0035s
main: -- add_column(:packages_conan_metadata, :package_build_type, :text, {:if_not_exists=>true})
main:    -> 0.0027s
main: -- add_column(:packages_conan_metadata, :compiler, :text, {:if_not_exists=>true})
main:    -> 0.0034s
main: -- add_column(:packages_conan_metadata, :compiler_version, :text, {:if_not_exists=>true})
main:    -> 0.0028s
main: -- add_column(:packages_conan_metadata, :compiler_libcxx, :text, {:if_not_exists=>true})
main:    -> 0.0026s
main: -- add_column(:packages_conan_metadata, :compiler_cppstd, :text, {:if_not_exists=>true})
main:    -> 0.0028s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_45e700d44f\nCHECK ( char_length(package_os) <= 32 )\nNOT VALID;\n")
main:    -> 0.0009s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0005s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_45e700d44f;")
main:    -> 0.0007s
main: -- execute("RESET statement_timeout")
main:    -> 0.0005s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_a0b151fff9\nCHECK ( char_length(package_architecture) <= 32 )\nNOT VALID;\n")
main:    -> 0.0008s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_a0b151fff9;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_ec3285e806\nCHECK ( char_length(package_build_type) <= 32 )\nNOT VALID;\n")
main:    -> 0.0008s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_ec3285e806;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_e7f03884b8\nCHECK ( char_length(compiler) <= 32 )\nNOT VALID;\n")
main:    -> 0.0008s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_e7f03884b8;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_3dc474bc51\nCHECK ( char_length(compiler_version) <= 16 )\nNOT VALID;\n")
main:    -> 0.0009s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_3dc474bc51;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_52abd85dde\nCHECK ( char_length(compiler_libcxx) <= 32 )\nNOT VALID;\n")
main:    -> 0.0008s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_52abd85dde;")
main:    -> 0.0007s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE packages_conan_metadata\nADD CONSTRAINT check_e57d0def27\nCHECK ( char_length(compiler_cppstd) <= 32 )\nNOT VALID;\n")
main:    -> 0.0007s
main: -- execute("ALTER TABLE packages_conan_metadata VALIDATE CONSTRAINT check_e57d0def27;")
main:    -> 0.0007s
main: == 20240626102543 AddExtraMetadataToPackagesConanMetadata: migrated (0.0994s) =
rake db:migrate:down
main: == 20240626102543 AddExtraMetadataToPackagesConanMetadata: reverting ==========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_column(:packages_conan_metadata, :package_os, {:if_exists=>true})
main:    -> 0.0103s
main: -- remove_column(:packages_conan_metadata, :package_architecture, {:if_exists=>true})
main:    -> 0.0031s
main: -- remove_column(:packages_conan_metadata, :package_build_type, {:if_exists=>true})
main:    -> 0.0034s
main: -- remove_column(:packages_conan_metadata, :compiler, {:if_exists=>true})
main:    -> 0.0028s
main: -- remove_column(:packages_conan_metadata, :compiler_version, {:if_exists=>true})
main:    -> 0.0030s
main: -- remove_column(:packages_conan_metadata, :compiler_libcxx, {:if_exists=>true})
main:    -> 0.0026s
main: -- remove_column(:packages_conan_metadata, :compiler_cppstd, {:if_exists=>true})
main:    -> 0.0029s
main: == 20240626102543 AddExtraMetadataToPackagesConanMetadata: reverted (0.0515s) =

Related to #33892

Edited by Océane Legrand

Merge request reports