12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- # 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
|