spec/lib/gitlab/database/migration_helpers/loose_foreign_key_helpers_spec.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

# frozen_string_literal: true

require 'spec_helper'

RSpec.describe Gitlab::Database::MigrationHelpers::LooseForeignKeyHelpers do
  let_it_be(:migration) do
    ActiveRecord::Migration.new.extend(described_class)
  end

  let(:model) do
    Class.new(ApplicationRecord) do
      self.table_name = 'loose_fk_test_table'
    end
  end

  before(:all) do
    migration.create_table :loose_fk_test_table do |t|
      t.timestamps
    end
  end

  after(:all) do
    migration.drop_table :loose_fk_test_table
  end

  before do
    3.times { model.create! }
  end

  context 'when the record deletion tracker trigger is not installed' do
    it 'does store record deletions' do
      model.delete_all

      expect(LooseForeignKeys::DeletedRecord.count).to eq(0)
    end
  end

  context 'when the record deletion tracker trigger is installed' do
    before do
      migration.track_record_deletions(:loose_fk_test_table)
    end

    it 'stores the record deletion' do
      records = model.all
      record_to_be_deleted = records.last

      record_to_be_deleted.delete

      expect(LooseForeignKeys::DeletedRecord.count).to eq(1)
      deleted_record = LooseForeignKeys::DeletedRecord.all.first

      expect(deleted_record.primary_key_value).to eq(record_to_be_deleted.id)
      expect(deleted_record.fully_qualified_table_name).to eq('public.loose_fk_test_table')
      expect(deleted_record.partition).to eq(1)
    end

    it 'stores multiple record deletions' do
      model.delete_all

      expect(LooseForeignKeys::DeletedRecord.count).to eq(3)
    end
  end
end