1 files changed, 61 insertions, 0 deletions
diff --git a/spec/migrations/20221102090943_create_second_partition_for_builds_metadata_spec.rb b/spec/migrations/20221102090943_create_second_partition_for_builds_metadata_spec.rb
new file mode 100644
index 00000000000..99754d609ed
--- /dev/null
+++ b/spec/migrations/20221102090943_create_second_partition_for_builds_metadata_spec.rb
@@ -0,0 +1,61 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+require_migration!
+
+RSpec.describe CreateSecondPartitionForBuildsMetadata, :migration do
+  let(:migration) { described_class.new }
+  let(:partitions) { table(:ci_partitions) }
+
+  describe '#up' do
+    context 'when on sass' do
+      before do
+        allow(Gitlab).to receive(:com?).and_return(true)
+      end
+
+      it 'creates a new partition' do
+        expect { migrate! }.to change { partitions_count }.by(1)
+      end
+    end
+
+    context 'when self-managed' do
+      before do
+        allow(Gitlab).to receive(:com?).and_return(false)
+      end
+
+      it 'does not create the partition' do
+        expect { migrate! }.not_to change { partitions_count }
+      end
+    end
+  end
+
+  describe '#down' do
+    context 'when on sass' do
+      before do
+        allow(Gitlab).to receive(:com?).and_return(true)
+      end
+
+      it 'removes the partition' do
+        migrate!
+
+        expect { migration.down }.to change { partitions_count }.by(-1)
+      end
+    end
+
+    context 'when self-managed' do
+      before do
+        allow(Gitlab).to receive(:com?).and_return(false)
+      end
+
+      it 'does not change the partitions count' do
+        migrate!
+
+        expect { migration.down }.not_to change { partitions_count }
+      end
+    end
+  end
+
+  def partitions_count
+    Gitlab::Database::PostgresPartition.for_parent_table(:p_ci_builds_metadata).size
+  end
+end