Skip to content

Add development widget to work item types

Mario Celi requested to merge 440851-add-development-widget into master

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

Merge request reports