1 files changed, 28 insertions, 0 deletions
diff --git a/spec/support/shared_examples/controllers/snippet_shared_examples.rb b/spec/support/shared_examples/controllers/snippet_shared_examples.rb
new file mode 100644
index 00000000000..f49cc979368
--- /dev/null
+++ b/spec/support/shared_examples/controllers/snippet_shared_examples.rb
@@ -0,0 +1,28 @@
+# frozen_string_literal: true
+
+RSpec.shared_examples 'snippets views' do
+  let(:params) { {} }
+
+  before do
+    sign_in(user)
+  end
+
+  context 'when rendered' do
+    render_views
+
+    it 'avoids N+1 database queries' do
+      # Warming call to load everything non snippet related
+      get(:index, params: params)
+
+      project = create(:project, namespace: user.namespace)
+      create(:project_snippet, project: project, author: user)
+
+      control_count = ActiveRecord::QueryRecorder.new { get(:index, params: params) }.count
+
+      project = create(:project, namespace: user.namespace)
+      create(:project_snippet, project: project, author: user)
+
+      expect { get(:index, params: params) }.not_to exceed_query_limit(control_count)
+    end
+  end
+end