spec/lib/gitlab/database/schema_validation/adapters/foreign_key_database_adapter_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

# frozen_string_literal: true

require 'spec_helper'

RSpec.describe Gitlab::Database::SchemaValidation::Adapters::ForeignKeyDatabaseAdapter, feature_category: :database do
  subject(:adapter) { described_class.new(query_result) }

  let(:query_result) do
    {
      'schema' => 'public',
      'foreign_key_name' => 'fk_2e88fb7ce9',
      'table_name' => 'members',
      'foreign_key_definition' => 'FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE'
    }
  end

  describe '#name' do
    it { expect(adapter.name).to eq('public.fk_2e88fb7ce9') }
  end

  describe '#table_name' do
    it { expect(adapter.table_name).to eq('members') }
  end

  describe '#statement' do
    it { expect(adapter.statement).to eq('FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE') }
  end
end