##// END OF EJS Templates
jro_apps » redmine
RSS
Additional tests for QueriesController....
Jean-Philippe Lang -
r8145:199eaff14ea3
parent child
Show More
Side by Side Unified
Context file:
r8145:199eaff14ea3 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,250 +1,271
1 # Redmine - project management software
1 # Redmine - project management software
2 # Copyright (C) 2006-2011 Jean-Philippe Lang
2 # Copyright (C) 2006-2011 Jean-Philippe Lang
3 #
3 #
4 # This program is free software; you can redistribute it and/or
4 # This program is free software; you can redistribute it and/or
5 # modify it under the terms of the GNU General Public License
5 # modify it under the terms of the GNU General Public License
6 # as published by the Free Software Foundation; either version 2
6 # as published by the Free Software Foundation; either version 2
7 # of the License, or (at your option) any later version.
7 # of the License, or (at your option) any later version.
8 #
8 #
9 # This program is distributed in the hope that it will be useful,
9 # This program is distributed in the hope that it will be useful,
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 # GNU General Public License for more details.
12 # GNU General Public License for more details.
13 #
13 #
14 # You should have received a copy of the GNU General Public License
14 # You should have received a copy of the GNU General Public License
15 # along with this program; if not, write to the Free Software
15 # along with this program; if not, write to the Free Software
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17
17
18 require File.expand_path('../../test_helper', __FILE__)
18 require File.expand_path('../../test_helper', __FILE__)
19 require 'queries_controller'
20
21 # Re-raise errors caught by the controller.
22 class QueriesController; def rescue_action(e) raise e end; end
23
19
24 class QueriesControllerTest < ActionController::TestCase
20 class QueriesControllerTest < ActionController::TestCase
25 fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries
21 fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries
26
22
27 def setup
23 def setup
28 @controller = QueriesController.new
29 @request = ActionController::TestRequest.new
30 @response = ActionController::TestResponse.new
31 User.current = nil
24 User.current = nil
32 end
25 end
33
26
34 def test_get_new_project_query
27 def test_new_project_query
35 @request.session[:user_id] = 2
28 @request.session[:user_id] = 2
36 get :new, :project_id => 1
29 get :new, :project_id => 1
37 assert_response :success
30 assert_response :success
38 assert_template 'new'
31 assert_template 'new'
39 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
32 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
40 :name => 'query[is_public]',
33 :name => 'query[is_public]',
41 :checked => nil }
34 :checked => nil }
42 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
35 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
43 :name => 'query_is_for_all',
36 :name => 'query_is_for_all',
44 :checked => nil,
37 :checked => nil,
45 :disabled => nil }
38 :disabled => nil }
46 end
39 end
47
40
48 def test_get_new_global_query
41 def test_new_global_query
49 @request.session[:user_id] = 2
42 @request.session[:user_id] = 2
50 get :new
43 get :new
51 assert_response :success
44 assert_response :success
52 assert_template 'new'
45 assert_template 'new'
53 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
46 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
54 :name => 'query[is_public]' }
47 :name => 'query[is_public]' }
55 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
48 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
56 :name => 'query_is_for_all',
49 :name => 'query_is_for_all',
57 :checked => 'checked',
50 :checked => 'checked',
58 :disabled => nil }
51 :disabled => nil }
59 end
52 end
60
53
61 def test_new_project_public_query
54 def test_new_on_invalid_project
55 @request.session[:user_id] = 2
56 get :new, :project_id => 'invalid'
57 assert_response 404
58 end
59
60 def test_create_project_public_query
62 @request.session[:user_id] = 2
61 @request.session[:user_id] = 2
63 post :create,
62 post :create,
64 :project_id => 'ecookbook',
63 :project_id => 'ecookbook',
65 :default_columns => '1',
64 :default_columns => '1',
66 :f => ["status_id", "assigned_to_id"],
65 :f => ["status_id", "assigned_to_id"],
67 :op => {"assigned_to_id" => "=", "status_id" => "o"},
66 :op => {"assigned_to_id" => "=", "status_id" => "o"},
68 :v => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
67 :v => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
69 :query => {"name" => "test_new_project_public_query", "is_public" => "1"}
68 :query => {"name" => "test_new_project_public_query", "is_public" => "1"}
70
69
71 q = Query.find_by_name('test_new_project_public_query')
70 q = Query.find_by_name('test_new_project_public_query')
72 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q
71 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q
73 assert q.is_public?
72 assert q.is_public?
74 assert q.has_default_columns?
73 assert q.has_default_columns?
75 assert q.valid?
74 assert q.valid?
76 end
75 end
77
76
78 def test_new_project_private_query
77 def test_create_project_private_query
79 @request.session[:user_id] = 3
78 @request.session[:user_id] = 3
80 post :create,
79 post :create,
81 :project_id => 'ecookbook',
80 :project_id => 'ecookbook',
82 :default_columns => '1',
81 :default_columns => '1',
83 :fields => ["status_id", "assigned_to_id"],
82 :fields => ["status_id", "assigned_to_id"],
84 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
83 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
85 :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
84 :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
86 :query => {"name" => "test_new_project_private_query", "is_public" => "1"}
85 :query => {"name" => "test_new_project_private_query", "is_public" => "1"}
87
86
88 q = Query.find_by_name('test_new_project_private_query')
87 q = Query.find_by_name('test_new_project_private_query')
89 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q
88 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q
90 assert !q.is_public?
89 assert !q.is_public?
91 assert q.has_default_columns?
90 assert q.has_default_columns?
92 assert q.valid?
91 assert q.valid?
93 end
92 end
94
93
95 def test_new_global_private_query_with_custom_columns
94 def test_create_global_private_query_with_custom_columns
96 @request.session[:user_id] = 3
95 @request.session[:user_id] = 3
97 post :create,
96 post :create,
98 :fields => ["status_id", "assigned_to_id"],
97 :fields => ["status_id", "assigned_to_id"],
99 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
98 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
100 :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},
99 :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},
101 :query => {"name" => "test_new_global_private_query", "is_public" => "1"},
100 :query => {"name" => "test_new_global_private_query", "is_public" => "1"},
102 :c => ["", "tracker", "subject", "priority", "category"]
101 :c => ["", "tracker", "subject", "priority", "category"]
103
102
104 q = Query.find_by_name('test_new_global_private_query')
103 q = Query.find_by_name('test_new_global_private_query')
105 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q
104 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q
106 assert !q.is_public?
105 assert !q.is_public?
107 assert !q.has_default_columns?
106 assert !q.has_default_columns?
108 assert_equal [:tracker, :subject, :priority, :category], q.columns.collect {|c| c.name}
107 assert_equal [:tracker, :subject, :priority, :category], q.columns.collect {|c| c.name}
109 assert q.valid?
108 assert q.valid?
110 end
109 end
111
110
112 def test_new_global_query_with_custom_filters
111 def test_create_global_query_with_custom_filters
113 @request.session[:user_id] = 3
112 @request.session[:user_id] = 3
114 post :create,
113 post :create,
115 :fields => ["assigned_to_id"],
114 :fields => ["assigned_to_id"],
116 :operators => {"assigned_to_id" => "="},
115 :operators => {"assigned_to_id" => "="},
117 :values => { "assigned_to_id" => ["me"]},
116 :values => { "assigned_to_id" => ["me"]},
118 :query => {"name" => "test_new_global_query"}
117 :query => {"name" => "test_new_global_query"}
119
118
120 q = Query.find_by_name('test_new_global_query')
119 q = Query.find_by_name('test_new_global_query')
121 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q
120 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q
122 assert !q.has_filter?(:status_id)
121 assert !q.has_filter?(:status_id)
123 assert_equal ['assigned_to_id'], q.filters.keys
122 assert_equal ['assigned_to_id'], q.filters.keys
124 assert q.valid?
123 assert q.valid?
125 end
124 end
126
125
127 def test_new_with_sort
126 def test_create_with_sort
128 @request.session[:user_id] = 1
127 @request.session[:user_id] = 1
129 post :create,
128 post :create,
130 :default_columns => '1',
129 :default_columns => '1',
131 :operators => {"status_id" => "o"},
130 :operators => {"status_id" => "o"},
132 :values => {"status_id" => ["1"]},
131 :values => {"status_id" => ["1"]},
133 :query => {:name => "test_new_with_sort",
132 :query => {:name => "test_new_with_sort",
134 :is_public => "1",
133 :is_public => "1",
135 :sort_criteria => {"0" => ["due_date", "desc"], "1" => ["tracker", ""]}}
134 :sort_criteria => {"0" => ["due_date", "desc"], "1" => ["tracker", ""]}}
136
135
137 query = Query.find_by_name("test_new_with_sort")
136 query = Query.find_by_name("test_new_with_sort")
138 assert_not_nil query
137 assert_not_nil query
139 assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria
138 assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria
140 end
139 end
141
140
142 def test_get_edit_global_public_query
141 def test_create_with_failure
142 @request.session[:user_id] = 2
143 assert_no_difference 'Query.count' do
144 post :create, :project_id => 'ecookbook', :query => {:name => ''}
145 end
146 assert_response :success
147 assert_template 'new'
148 end
149
150 def test_edit_global_public_query
143 @request.session[:user_id] = 1
151 @request.session[:user_id] = 1
144 get :edit, :id => 4
152 get :edit, :id => 4
145 assert_response :success
153 assert_response :success
146 assert_template 'edit'
154 assert_template 'edit'
147 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
155 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
148 :name => 'query[is_public]',
156 :name => 'query[is_public]',
149 :checked => 'checked' }
157 :checked => 'checked' }
150 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
158 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
151 :name => 'query_is_for_all',
159 :name => 'query_is_for_all',
152 :checked => 'checked',
160 :checked => 'checked',
153 :disabled => 'disabled' }
161 :disabled => 'disabled' }
154 end
162 end
155
163
156 def test_edit_global_public_query
164 def test_edit_global_private_query
157 @request.session[:user_id] = 1
158 put :update,
159 :id => 4,
160 :default_columns => '1',
161 :fields => ["status_id", "assigned_to_id"],
162 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
163 :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
164 :query => {"name" => "test_edit_global_public_query", "is_public" => "1"}
165
166 assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 4
167 q = Query.find_by_name('test_edit_global_public_query')
168 assert q.is_public?
169 assert q.has_default_columns?
170 assert q.valid?
171 end
172
173 def test_get_edit_global_private_query
174 @request.session[:user_id] = 3
165 @request.session[:user_id] = 3
175 get :edit, :id => 3
166 get :edit, :id => 3
176 assert_response :success
167 assert_response :success
177 assert_template 'edit'
168 assert_template 'edit'
178 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
169 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
179 :name => 'query[is_public]' }
170 :name => 'query[is_public]' }
180 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
171 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
181 :name => 'query_is_for_all',
172 :name => 'query_is_for_all',
182 :checked => 'checked',
173 :checked => 'checked',
183 :disabled => 'disabled' }
174 :disabled => 'disabled' }
184 end
175 end
185
176
186 def test_edit_global_private_query
177 def test_edit_project_private_query
187 @request.session[:user_id] = 3
188 put :update,
189 :id => 3,
190 :default_columns => '1',
191 :fields => ["status_id", "assigned_to_id"],
192 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
193 :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},
194 :query => {"name" => "test_edit_global_private_query", "is_public" => "1"}
195
196 assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 3
197 q = Query.find_by_name('test_edit_global_private_query')
198 assert !q.is_public?
199 assert q.has_default_columns?
200 assert q.valid?
201 end
202
203 def test_get_edit_project_private_query
204 @request.session[:user_id] = 3
178 @request.session[:user_id] = 3
205 get :edit, :id => 2
179 get :edit, :id => 2
206 assert_response :success
180 assert_response :success
207 assert_template 'edit'
181 assert_template 'edit'
208 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
182 assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',
209 :name => 'query[is_public]' }
183 :name => 'query[is_public]' }
210 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
184 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
211 :name => 'query_is_for_all',
185 :name => 'query_is_for_all',
212 :checked => nil,
186 :checked => nil,
213 :disabled => nil }
187 :disabled => nil }
214 end
188 end
215
189
216 def test_get_edit_project_public_query
190 def test_edit_project_public_query
217 @request.session[:user_id] = 2
191 @request.session[:user_id] = 2
218 get :edit, :id => 1
192 get :edit, :id => 1
219 assert_response :success
193 assert_response :success
220 assert_template 'edit'
194 assert_template 'edit'
221 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
195 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
222 :name => 'query[is_public]',
196 :name => 'query[is_public]',
223 :checked => 'checked'
197 :checked => 'checked'
224 }
198 }
225 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
199 assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
226 :name => 'query_is_for_all',
200 :name => 'query_is_for_all',
227 :checked => nil,
201 :checked => nil,
228 :disabled => 'disabled' }
202 :disabled => 'disabled' }
229 end
203 end
230
204
231 def test_get_edit_sort_criteria
205 def test_edit_sort_criteria
232 @request.session[:user_id] = 1
206 @request.session[:user_id] = 1
233 get :edit, :id => 5
207 get :edit, :id => 5
234 assert_response :success
208 assert_response :success
235 assert_template 'edit'
209 assert_template 'edit'
236 assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },
210 assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },
237 :child => { :tag => 'option', :attributes => { :value => 'priority',
211 :child => { :tag => 'option', :attributes => { :value => 'priority',
238 :selected => 'selected' } }
212 :selected => 'selected' } }
239 assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },
213 assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },
240 :child => { :tag => 'option', :attributes => { :value => 'desc',
214 :child => { :tag => 'option', :attributes => { :value => 'desc',
241 :selected => 'selected' } }
215 :selected => 'selected' } }
242 end
216 end
243
217
218 def test_edit_invalid_query
219 @request.session[:user_id] = 2
220 get :edit, :id => 99
221 assert_response 404
222 end
223
224 def test_udpate_global_private_query
225 @request.session[:user_id] = 3
226 put :update,
227 :id => 3,
228 :default_columns => '1',
229 :fields => ["status_id", "assigned_to_id"],
230 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
231 :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},
232 :query => {"name" => "test_edit_global_private_query", "is_public" => "1"}
233
234 assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 3
235 q = Query.find_by_name('test_edit_global_private_query')
236 assert !q.is_public?
237 assert q.has_default_columns?
238 assert q.valid?
239 end
240
241 def test_update_global_public_query
242 @request.session[:user_id] = 1
243 put :update,
244 :id => 4,
245 :default_columns => '1',
246 :fields => ["status_id", "assigned_to_id"],
247 :operators => {"assigned_to_id" => "=", "status_id" => "o"},
248 :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},
249 :query => {"name" => "test_edit_global_public_query", "is_public" => "1"}
250
251 assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 4
252 q = Query.find_by_name('test_edit_global_public_query')
253 assert q.is_public?
254 assert q.has_default_columns?
255 assert q.valid?
256 end
257
258 def test_update_with_failure
259 @request.session[:user_id] = 1
260 put :update, :id => 4, :query => {:name => ''}
261 assert_response :success
262 assert_template 'edit'
263 end
264
244 def test_destroy
265 def test_destroy
245 @request.session[:user_id] = 2
266 @request.session[:user_id] = 2
246 delete :destroy, :id => 1
267 delete :destroy, :id => 1
247 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil
268 assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil
248 assert_nil Query.find_by_id(1)
269 assert_nil Query.find_by_id(1)
249 end
270 end
250 end
271 end
General Comments 0
You need to be logged in to leave comments. Login now