db/migrate/20160331133914_remove_todos_for_deleted_merge_requests.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

class RemoveTodosForDeletedMergeRequests < ActiveRecord::Migration
  def up
    execute <<-SQL
      DELETE FROM todos
      WHERE todos.target_type = 'MergeRequest'
        AND NOT EXISTS (
              SELECT *
              FROM merge_requests
              WHERE merge_requests.id = todos.target_id
                AND merge_requests.deleted_at IS NULL
            )
    SQL
  end

  def down
  end
end