diff options
| author | Stan Hu <stanhu@gmail.com> | 2016-05-26 19:19:11 -0700 |
|---|---|---|
| committer | Stan Hu <stanhu@gmail.com> | 2016-05-31 08:50:18 -0700 |
| commit | 4da07781573d830244c001f606fa30260e38c472 (patch) | |
| tree | 9c4a9c95b55a8c8285ee455877716f6ea5c84082 /db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb | |
| parent | ef4fedc18f5e2475aa36cc4327a76a496567c6fc (diff) | |
| download | gitlab-ce-4da07781573d830244c001f606fa30260e38c472.tar.gz | |
Remove project notification settings associated with deleted projects
On GitLab.com, there are 1560 project notification settings with no valid project
all created on 2016-04-15 10:38:53 for some reason. This migration should purge
those entries.
b8f38437 should prevent this issue from occurring in the first place.
Closes gitlab-com/support-forum#678
Diffstat (limited to 'db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb')
| -rw-r--r-- | db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb b/db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb new file mode 100644 index 00000000000..7910120b4e0 --- /dev/null +++ b/db/migrate/20160527020117_remove_notification_settings_for_deleted_projects.rb @@ -0,0 +1,13 @@ +class RemoveNotificationSettingsForDeletedProjects < ActiveRecord::Migration + def up + execute <<-SQL + DELETE FROM notification_settings + WHERE notification_settings.source_type = 'Project' + AND NOT EXISTS ( + SELECT * + FROM projects + WHERE projects.id = notification_settings.source_id + ) + SQL + end +end |