summaryrefslogtreecommitdiff
path: root/spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb
diff options
context:
space:
mode:
Diffstat (limited to 'spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb')
-rw-r--r--spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb115
1 files changed, 0 insertions, 115 deletions
diff --git a/spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb b/spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb
deleted file mode 100644
index eecdaa3409f..00000000000
--- a/spec/lib/gitlab/graphql/pagination/keyset/conditions/not_null_condition_spec.rb
+++ /dev/null
@@ -1,115 +0,0 @@
-# frozen_string_literal: true
-
-require 'spec_helper'
-
-RSpec.describe Gitlab::Graphql::Pagination::Keyset::Conditions::NotNullCondition do
- describe '#build' do
- let(:operators) { ['>', '>'] }
- let(:before_or_after) { :after }
- let(:condition) { described_class.new(arel_table, order_list, values, operators, before_or_after) }
-
- context 'when there is only one ordering field' do
- let(:arel_table) { Issue.arel_table }
- let(:order_list) { [double(named_function: nil, attribute_name: 'id')] }
- let(:values) { [500] }
- let(:operators) { ['>'] }
-
- it 'generates a single condition sql' do
- expected_sql = <<~SQL
- ("issues"."id" > 500)
- SQL
-
- expect(condition.build.squish).to eq expected_sql.squish
- end
- end
-
- context 'when ordering by a column attribute' do
- let(:arel_table) { Issue.arel_table }
- let(:order_list) { [double(named_function: nil, attribute_name: 'relative_position'), double(named_function: nil, attribute_name: 'id')] }
- let(:values) { [1500, 500] }
-
- shared_examples ':after condition' do
- it 'generates :after sql' do
- expected_sql = <<~SQL
- ("issues"."relative_position" > 1500)
- OR (
- "issues"."relative_position" = 1500
- AND
- "issues"."id" > 500
- )
- OR ("issues"."relative_position" IS NULL)
- SQL
-
- expect(condition.build.squish).to eq expected_sql.squish
- end
- end
-
- context 'when :after' do
- it_behaves_like ':after condition'
- end
-
- context 'when :before' do
- let(:before_or_after) { :before }
-
- it 'generates :before sql' do
- expected_sql = <<~SQL
- ("issues"."relative_position" > 1500)
- OR (
- "issues"."relative_position" = 1500
- AND
- "issues"."id" > 500
- )
- SQL
-
- expect(condition.build.squish).to eq expected_sql.squish
- end
- end
-
- context 'when :foo' do
- let(:before_or_after) { :foo }
-
- it_behaves_like ':after condition'
- end
- end
-
- context 'when ordering by LOWER' do
- let(:arel_table) { Project.arel_table }
- let(:relation) { Project.order(arel_table['name'].lower.asc).order(:id) }
- let(:order_list) { Gitlab::Graphql::Pagination::Keyset::OrderInfo.build_order_list(relation) }
- let(:values) { ['Test', 500] }
-
- context 'when :after' do
- it 'generates :after sql' do
- expected_sql = <<~SQL
- (LOWER("projects"."name") > 'test')
- OR (
- LOWER("projects"."name") = 'test'
- AND
- "projects"."id" > 500
- )
- OR (LOWER("projects"."name") IS NULL)
- SQL
-
- expect(condition.build.squish).to eq expected_sql.squish
- end
- end
-
- context 'when :before' do
- let(:before_or_after) { :before }
-
- it 'generates :before sql' do
- expected_sql = <<~SQL
- (LOWER("projects"."name") > 'test')
- OR (
- LOWER("projects"."name") = 'test'
- AND
- "projects"."id" > 500
- )
- SQL
-
- expect(condition.build.squish).to eq expected_sql.squish
- end
- end
- end
- end
-end