1 files changed, 97 insertions, 0 deletions
diff --git a/spec/finders/deployments_finder_spec.rb b/spec/finders/deployments_finder_spec.rb
new file mode 100644
index 00000000000..be35a705b0d
--- /dev/null
+++ b/spec/finders/deployments_finder_spec.rb
@@ -0,0 +1,97 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+
+describe DeploymentsFinder do
+  subject { described_class.new(project, params).execute }
+
+  let(:project) { create(:project, :public, :repository) }
+  let(:params) { {} }
+
+  describe "#execute" do
+    it 'returns all deployments by default' do
+      deployments = create_list(:deployment, 2, :success, project: project)
+      is_expected.to match_array(deployments)
+    end
+
+    describe 'filtering' do
+      context 'when updated_at filters are specified' do
+        let(:params) { { updated_before: 1.day.ago, updated_after: 3.days.ago } }
+        let!(:deployment_1) { create(:deployment, :success, project: project, updated_at: 2.days.ago) }
+        let!(:deployment_2) { create(:deployment, :success, project: project, updated_at: 4.days.ago) }
+        let!(:deployment_3) { create(:deployment, :success, project: project, updated_at: 1.hour.ago) }
+
+        it 'returns deployments with matched updated_at' do
+          is_expected.to match_array([deployment_1])
+        end
+      end
+    end
+
+    describe 'ordering' do
+      using RSpec::Parameterized::TableSyntax
+
+      let(:params) { { order_by: order_by, sort: sort } }
+
+      let!(:deployment_1) { create(:deployment, :success, project: project, iid: 11, ref: 'master', created_at: 2.days.ago, updated_at: Time.now) }
+      let!(:deployment_2) { create(:deployment, :success, project: project, iid: 12, ref: 'feature', created_at: 1.day.ago, updated_at: 2.hours.ago) }
+      let!(:deployment_3) { create(:deployment, :success, project: project, iid: 8, ref: 'patch', created_at: Time.now, updated_at: 1.hour.ago) }
+
+      where(:order_by, :sort, :ordered_deployments) do
+        'created_at' | 'asc'  | [:deployment_1, :deployment_2, :deployment_3]
+        'created_at' | 'desc' | [:deployment_3, :deployment_2, :deployment_1]
+        'id'         | 'asc'  | [:deployment_1, :deployment_2, :deployment_3]
+        'id'         | 'desc' | [:deployment_3, :deployment_2, :deployment_1]
+        'iid'        | 'asc'  | [:deployment_3, :deployment_1, :deployment_2]
+        'iid'        | 'desc' | [:deployment_2, :deployment_1, :deployment_3]
+        'ref'        | 'asc'  | [:deployment_2, :deployment_1, :deployment_3]
+        'ref'        | 'desc' | [:deployment_3, :deployment_1, :deployment_2]
+        'updated_at' | 'asc'  | [:deployment_2, :deployment_3, :deployment_1]
+        'updated_at' | 'desc' | [:deployment_1, :deployment_3, :deployment_2]
+        'invalid'    | 'asc'  | [:deployment_1, :deployment_2, :deployment_3]
+        'iid'        | 'err'  | [:deployment_3, :deployment_1, :deployment_2]
+      end
+
+      with_them do
+        it 'returns the deployments ordered' do
+          expect(subject).to eq(ordered_deployments.map { |name| public_send(name) })
+        end
+      end
+    end
+
+    describe 'transform `created_at` sorting to `id` sorting' do
+      let(:params) { { order_by: 'created_at', sort: 'asc' } }
+
+      it 'sorts by only one column' do
+        expect(subject.order_values.size).to eq(1)
+      end
+
+      it 'sorts by `id`' do
+        expect(subject.order_values.first.to_sql).to eq(Deployment.arel_table[:id].asc.to_sql)
+      end
+    end
+
+    describe 'tie-breaker for `updated_at` sorting' do
+      let(:params) { { order_by: 'updated_at', sort: 'asc' } }
+
+      it 'sorts by two columns' do
+        expect(subject.order_values.size).to eq(2)
+      end
+
+      it 'adds `id` sorting as the second order column' do
+        order_value = subject.order_values[1]
+
+        expect(order_value.to_sql).to eq(Deployment.arel_table[:id].desc.to_sql)
+      end
+
+      it 'uses the `id DESC` as tie-breaker when ordering' do
+        updated_at = Time.now
+
+        deployment_1 = create(:deployment, :success, project: project, updated_at: updated_at)
+        deployment_2 = create(:deployment, :success, project: project, updated_at: updated_at)
+        deployment_3 = create(:deployment, :success, project: project, updated_at: updated_at)
+
+        expect(subject).to eq([deployment_3, deployment_2, deployment_1])
+      end
+    end
+  end
+end