zammad/spec/db/migrate/issue_1977_remove_invalid_user_foreign_keys_spec.rb

# Copyright (C) 2012-2024 Zammad Foundation, https://zammad-foundation.org/

require 'rails_helper'

RSpec.describe Issue1977RemoveInvalidUserForeignKeys, type: :db_migration do

  context 'no online_notifications foreign key' do

    let(:existing_user_id) { User.first.id }

    context 'invalid User foreign key columns' do

      it 'cleans up OnlineNotification#user_id', db_strategy: :reset do
        without_foreign_key(:online_notifications, column: :user_id)

        OnlineNotification.without_callback :commit, :after, :trigger_subscriptions do
          create(:online_notification, user_id: 1337)
          create(:online_notification, user_id: existing_user_id)
        end

        expect do
          migrate
        end.to change(OnlineNotification, :count).by(-1)
      end

      it 'cleans up RecentView#created_by_id', db_strategy: :reset do
        without_foreign_key(:online_notifications, column: :user_id)
        without_foreign_key(:recent_views, column: :created_by_id)

        record = build(:recent_view, created_by_id: 1337)
        record.save(validate: false)
        create(:recent_view, created_by_id: existing_user_id)

        expect do
          migrate
        end.to change(RecentView, :count).by(-1)
      end

      it 'cleans up Avatar#o_id', db_strategy: :reset do
        without_foreign_key(:online_notifications, column: :user_id)

        create(:avatar, object_lookup_id: ObjectLookup.by_name('User'), o_id: 1337)
        create(:avatar, object_lookup_id: ObjectLookup.by_name('Ticket'), o_id: 1337)
        create(:avatar, object_lookup_id: ObjectLookup.by_name('User'), o_id: existing_user_id)

        expect do
          migrate
        end.to change(Avatar, :count).by(-1)
      end

    end

    it 'adds OnlineNotification#user_id foreign key' do
      adds_foreign_key(:online_notifications, column: :user_id)
    end
  end

end