2 files changed, 46 insertions, 0 deletions
diff --git a/spec/migrations/20231019145202_add_status_to_packages_npm_metadata_caches_spec.rb b/spec/migrations/20231019145202_add_status_to_packages_npm_metadata_caches_spec.rb
new file mode 100644
index 00000000000..eeeafbdc277
--- /dev/null
+++ b/spec/migrations/20231019145202_add_status_to_packages_npm_metadata_caches_spec.rb
@@ -0,0 +1,22 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+require_migration!
+
+RSpec.describe AddStatusToPackagesNpmMetadataCaches, feature_category: :package_registry do
+  let(:npm_metadata_caches) { table(:packages_npm_metadata_caches) }
+
+  it 'correctly migrates up and down' do
+    reversible_migration do |migration|
+      migration.before -> {
+        expect(npm_metadata_caches.column_names).not_to include('status')
+      }
+
+      migration.after -> {
+        npm_metadata_caches.reset_column_information
+
+        expect(npm_metadata_caches.column_names).to include('status')
+      }
+    end
+  end
+end
diff --git a/spec/migrations/20231020181652_add_index_packages_npm_metadata_caches_on_id_and_project_id_and_status_spec.rb b/spec/migrations/20231020181652_add_index_packages_npm_metadata_caches_on_id_and_project_id_and_status_spec.rb
new file mode 100644
index 00000000000..412ea33cb4e
--- /dev/null
+++ b/spec/migrations/20231020181652_add_index_packages_npm_metadata_caches_on_id_and_project_id_and_status_spec.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+require_migration!
+
+RSpec.describe AddIndexPackagesNpmMetadataCachesOnIdAndProjectIdAndStatus, feature_category: :package_registry do
+  let(:index_name) { described_class::INDEX_NAME }
+
+  it 'correctly migrates up and down' do
+    reversible_migration do |migration|
+      migration.before -> {
+        expect(ActiveRecord::Base.connection.indexes(:packages_npm_metadata_caches).map(&:name))
+          .not_to include(index_name)
+      }
+
+      migration.after -> {
+        # npm_metadata_caches.reset_column_information
+
+        expect(ActiveRecord::Base.connection.indexes(:packages_npm_metadata_caches).map(&:name))
+          .to include(index_name)
+      }
+    end
+  end
+end