1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
# 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
set_language_if_valid 'en'
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
|
