Adds CatalogResourceComponents table

What does this MR do and why?

This MR adds the catalog_resource_components table plus models and associations.

catalog_resource_components(
  name # component name
  inputs # specs of the inputs. JSON serialized
  catalog_version_id FK to catalog_resource_versions.id
  resource_type integer (enum { template: 1 })
  catalog_resource_id FK to catalog_resources.id
  project_id FK to projects.id
  created_at
)

UP

main:    -> 0.0011s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT fk_89fd1a3e33;")
main:    -> 0.0012s
main: -- execute("RESET statement_timeout")
main:    -> 0.0005s
main: == 20230727092035 AddCatalogVersionFkToCatalogResourceComponents: migrated (0.0326s)

main: == [advisory_lock_connection] object_id: 225120, pg_backend_pid: 25525
ci: == [advisory_lock_connection] object_id: 225320, pg_backend_pid: 25530
ci: == 20230727092035 AddCatalogVersionFkToCatalogResourceComponents: migrating ===
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- transaction_open?()
ci:    -> 0.0001s
ci: -- execute("ALTER TABLE catalog_resource_components ADD CONSTRAINT fk_89fd1a3e33 FOREIGN KEY (version_id) REFERENCES catalog_resource_versions (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0014s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT fk_89fd1a3e33;")
ci:    -> 0.0007s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0002s
ci: == 20230727092035 AddCatalogVersionFkToCatalogResourceComponents: migrated (0.0254s)

ci: == [advisory_lock_connection] object_id: 225320, pg_backend_pid: 25530
main: == [advisory_lock_connection] object_id: 227220, pg_backend_pid: 25536
main: == 20230727092425 AddProjectFkToCatalogResourceComponents: migrating ==========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- transaction_open?()
main:    -> 0.0000s
main: -- execute("ALTER TABLE catalog_resource_components ADD CONSTRAINT fk_85bb1d1e79 FOREIGN KEY (project_id) REFERENCES projects (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0013s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT fk_85bb1d1e79;")
main:    -> 0.0030s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: == 20230727092425 AddProjectFkToCatalogResourceComponents: migrated (0.0221s) =

main: == [advisory_lock_connection] object_id: 227220, pg_backend_pid: 25536
ci: == [advisory_lock_connection] object_id: 229180, pg_backend_pid: 25542
ci: == 20230727092425 AddProjectFkToCatalogResourceComponents: migrating ==========
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE catalog_resource_components ADD CONSTRAINT fk_85bb1d1e79 FOREIGN KEY (project_id) REFERENCES projects (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0013s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0004s
ci: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT fk_85bb1d1e79;")
ci:    -> 0.0028s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: == 20230727092425 AddProjectFkToCatalogResourceComponents: migrated (0.0265s) =

ci: == [advisory_lock_connection] object_id: 229180, pg_backend_pid: 25542

Down

main: == [advisory_lock_connection] object_id: 223720, pg_backend_pid: 34381
main: == 20230727084849 CreateCatalogResourceComponents: reverting ==================
main: -- drop_table(:catalog_resource_components)
main:    -> 0.0019s
main: == 20230727084849 CreateCatalogResourceComponents: reverted (0.0064s) =========

main: == [advisory_lock_connection] object_id: 223720, pg_backend_pid: 34381
main: == [advisory_lock_connection] object_id: 222880, pg_backend_pid: 33939
main: == 20230727091812 AddCatalogResourceFkToCatalogResourceComponents: reverting ==
main: -- transaction_open?()
main:    -> 0.0000s
main: -- remove_foreign_key(:catalog_resource_components, {:column=>:catalog_resource_id})
main:    -> 0.0817s
main: == 20230727091812 AddCatalogResourceFkToCatalogResourceComponents: reverted (0.0977s)

main: == [advisory_lock_connection] object_id: 222880, pg_backend_pid: 33939
main: == [advisory_lock_connection] object_id: 223720, pg_backend_pid: 33479
main: == 20230727092035 AddCatalogVersionFkToCatalogResourceComponents: reverting ===
main: -- transaction_open?()
main:    -> 0.0000s
main: -- remove_foreign_key(:catalog_resource_components, {:column=>:version_id})
main:    -> 0.0982s
main: == 20230727092035 AddCatalogVersionFkToCatalogResourceComponents: reverted (0.1223s)

main: == [advisory_lock_connection] object_id: 223720, pg_backend_pid: 33479
main: == [advisory_lock_connection] object_id: 223780, pg_backend_pid: 32998
main: == 20230727092425 AddProjectFkToCatalogResourceComponents: reverting ==========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- remove_foreign_key(:catalog_resource_components, {:column=>:project_id})
main:    -> 0.0801s
main: == 20230727092425 AddProjectFkToCatalogResourceComponents: reverted (0.0965s) =

main: == [advisory_lock_connection] object_id: 223780, pg_backend_pid: 32998

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.

Resolves: #415287 (closed)