1 files changed, 28 insertions, 0 deletions
diff --git a/spec/lib/gitlab/database/schema_validation/adapters/foreign_key_database_adapter_spec.rb b/spec/lib/gitlab/database/schema_validation/adapters/foreign_key_database_adapter_spec.rb
new file mode 100644
index 00000000000..cfe5572fb51
--- /dev/null
+++ b/spec/lib/gitlab/database/schema_validation/adapters/foreign_key_database_adapter_spec.rb
@@ -0,0 +1,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