1 files changed, 37 insertions, 0 deletions
diff --git a/spec/lib/gitlab/database/transaction_timeout_settings_spec.rb b/spec/lib/gitlab/database/transaction_timeout_settings_spec.rb
new file mode 100644
index 00000000000..5b68f9a3757
--- /dev/null
+++ b/spec/lib/gitlab/database/transaction_timeout_settings_spec.rb
@@ -0,0 +1,37 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+
+RSpec.describe Gitlab::Database::TransactionTimeoutSettings, feature_category: :pods do
+  let(:connection) { ActiveRecord::Base.connection }
+
+  subject { described_class.new(connection) }
+
+  after(:all) do
+    described_class.new(ActiveRecord::Base.connection).restore_timeouts
+  end
+
+  describe '#disable_timeouts' do
+    it 'sets timeouts to 0' do
+      subject.disable_timeouts
+
+      expect(current_timeout).to eq("0")
+    end
+  end
+
+  describe '#restore_timeouts' do
+    before do
+      subject.disable_timeouts
+    end
+
+    it 'resets value' do
+      expect(connection).to receive(:execute).with('RESET idle_in_transaction_session_timeout').and_call_original
+
+      subject.restore_timeouts
+    end
+  end
+
+  def current_timeout
+    connection.execute("show idle_in_transaction_session_timeout").first['idle_in_transaction_session_timeout']
+  end
+end