Adds missing files (#42352).

Patch by Holger Just (user:hjust).

git-svn-id: https://svn.redmine.org/redmine/trunk@23532 e93f8b46-1217-0410-a6f0-8f06a7374b81

1 files changed, 137 insertions, 0 deletions

diff --git a/test/unit/project_admin_query_test.rb b/test/unit/project_admin_query_test.rb
new file mode 100644
index 000000000..421b1f58d
--- /dev/null
+++ b/test/unit/project_admin_query_test.rb
@@ -0,0 +1,137 @@
+# frozen_string_literal: true
+
+# Redmine - project management software
+# Copyright (C) 2006-  Jean-Philippe Lang
+#
+# This program is free software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+
+require_relative '../test_helper'
+
+class ProjectAdminQueryTest < ActiveSupport::TestCase
+  include Redmine::I18n
+
+  def test_filter_values_be_arrays
+    q = ProjectAdminQuery.new
+    assert_nil q.project
+
+    q.available_filters.each do |name, filter|
+      values = filter.values
+      assert (values.nil? || values.is_a?(Array)),
+             "#values for #{name} filter returned a #{values.class.name}"
+    end
+  end
+
+  def test_project_statuses_filter_should_return_project_statuses
+    set_language_if_valid 'en'
+    query = ProjectAdminQuery.new(:name => '_')
+    query.filters = {'status' => {:operator => '=', :values => []}}
+    values = query.available_filters['status'][:values]
+    assert_equal ['active', 'closed', 'archived', 'scheduled for deletion'], values.map(&:first)
+    assert_equal ['1', '5', '9', '10'], values.map(&:second)
+  end
+
+  def test_default_columns
+    q = ProjectAdminQuery.new
+    assert q.columns.any?
+    assert q.inline_columns.any?
+    assert q.block_columns.empty?
+  end
+
+  def test_available_columns_should_include_project_custom_fields
+    query = ProjectAdminQuery.new
+    assert_include :cf_3, query.available_columns.map(&:name)
+  end
+
+  def test_available_display_types_should_always_returns_list
+    query = ProjectAdminQuery.new
+    assert_equal ['list'], query.available_display_types
+  end
+
+  def test_display_type_should_returns_list
+    ProjectAdminQuery.new.available_display_types.each do |t|
+      with_settings :project_list_display_type => t do
+        q = ProjectAdminQuery.new
+        assert_equal 'list', q.display_type
+      end
+    end
+  end
+
+  def test_no_default_project_admin_query
+    user = User.find(1)
+    query = ProjectQuery.find(11)
+    user_query = ProjectQuery.find(12)
+    user_query.update(visibility: Query::VISIBILITY_PUBLIC)
+
+    [nil, user, User.anonymous].each do |u|
+      assert_nil ProjectAdminQuery.default(user: u)
+    end
+
+    # ignore the default_project_query for admin queries
+    with_settings :default_project_query => query.id do
+      [nil, user, User.anonymous].each do |u|
+        assert_nil ProjectAdminQuery.default(user: u)
+      end
+    end
+
+    # user default, overrides global default
+    user.pref.default_project_query = user_query.id
+    user.pref.save
+
+    with_settings :default_project_query => query.id do
+      assert_nil ProjectAdminQuery.default(user: user)
+    end
+  end
+
+  def test_project_statuses_values_should_return_all_statuses
+    q = ProjectAdminQuery.new
+    assert_equal [
+      ["active", "1"],
+      ["closed", "5"],
+      ["archived", "9"],
+      ["scheduled for deletion", "10"]
+    ], q.project_statuses_values
+  end
+
+  def test_base_scope_should_return_all_projects
+    q = ProjectAdminQuery.new
+    assert_equal Project.all, q.base_scope
+  end
+
+  def test_results_scope_has_last_activity_date
+    q = ProjectAdminQuery.generate!(column_names: [:last_activity_date])
+    result_projects = q.results_scope({})
+
+    assert_kind_of ActiveRecord::Relation, result_projects
+    assert_equal Project, result_projects.klass
+
+    last_activitiy_date = result_projects.find{|p| p.id == 1}.instance_variable_get(:@last_activity_date)
+    assert_not_nil last_activitiy_date
+    assert_equal Redmine::Activity::Fetcher.new(User.current).events(nil, nil, :project => Project.find(1)).first.updated_on, last_activitiy_date
+  end
+
+  def test_results_scope_with_offset_and_limit
+    q = ProjectAdminQuery.new
+
+    ((q.results_scope.count / 2) + 1).times do |i|
+      limit = 2
+      offset = i * 2
+
+      scope_without = q.results_scope.offset(offset).limit(limit).ids
+      scope_with = q.results_scope(:offset => offset, :limit => limit).ids
+
+      assert_equal scope_without, scope_with
+    end
+  end
+end