Add development widget to work item types
What does this MR do and why?
Adds development
widget to the following types:
- Issue
- Task
- Incident
DB review
Console output
UP
bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 121360, pg_backend_pid: 38826
main: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: migrating ==============
main: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: migrated (0.0223s) =====
main: == [advisory_lock_connection] object_id: 121360, pg_backend_pid: 38826
ci: == [advisory_lock_connection] object_id: 121640, pg_backend_pid: 38828
ci: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: migrating ==============
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: migrated (0.0057s) =====
ci: == [advisory_lock_connection] object_id: 121640, pg_backend_pid: 38828
DOWN
bin/rails db:rollback:main db:rollback:ci
main: == [advisory_lock_connection] object_id: 120880, pg_backend_pid: 38141
main: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: reverting ==============
main: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: reverted (0.0156s) =====
main: == [advisory_lock_connection] object_id: 120880, pg_backend_pid: 38141
ci: == [advisory_lock_connection] object_id: 126580, pg_backend_pid: 38390
ci: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: reverting ==============
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20240327214545 AddDevelopmentWidgetToWorkItemTypes: reverted (0.0058s) =====
ci: == [advisory_lock_connection] object_id: 126580, pg_backend_pid: 38390
Query plans
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/27311/commands/84877
INSERT INTO "work_item_widget_definitions" (
"work_item_type_id", "name", "widget_type"
)
VALUES
(1, 'Development', 23),
(2, 'Development', 23),
(5, 'Development', 23) ON CONFLICT ("work_item_type_id", "name")
WHERE
(namespace_id IS NULL) DO
UPDATE
SET
"widget_type" = excluded."widget_type" RETURNING "id"
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.
Related to #452420 (closed)
Edited by Mario Celi