queries_controller_test.rb
400 lines
| 14.1 KiB
| text/x-ruby
|
RubyLexer
Toshi MARUYAMA
|
r6805 | # Redmine - project management software | ||
Jean-Philippe Lang
|
r14856 | # Copyright (C) 2006-2016 Jean-Philippe Lang | ||
|
Jean-Philippe Lang
|
r1296 | # | ||
| # 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. | ||||
|
Toshi MARUYAMA
|
r6805 | # | ||
|
Jean-Philippe Lang
|
r1296 | # 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. | ||||
|
Toshi MARUYAMA
|
r6805 | # | ||
|
Jean-Philippe Lang
|
r1296 | # 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. | ||||
Jean-Baptiste Barth
|
r4395 | require File.expand_path('../../test_helper', __FILE__) | ||
|
Jean-Philippe Lang
|
r1296 | |||
|
Jean-Philippe Lang
|
r15279 | class QueriesControllerTest < Redmine::ControllerTest | ||
|
Jean-Baptiste Barth
|
r10565 | fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries, :enabled_modules | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r1296 | def setup | ||
| User.current = nil | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r10758 | def test_index | ||
| get :index | ||||
| # HTML response not implemented | ||||
| assert_response 406 | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8145 | def test_new_project_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 2 | ||
| get :new, :project_id => 1 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r13237 | assert_select 'input[name=?][value="0"][checked=checked]', 'query[visibility]' | ||
|
Jean-Philippe Lang
|
r13242 | assert_select 'input[name=query_is_for_all][type=checkbox]:not([checked]):not([disabled])' | ||
|
Jean-Philippe Lang
|
r9519 | assert_select 'select[name=?]', 'c[]' do | ||
| assert_select 'option[value=tracker]' | ||||
| assert_select 'option[value=subject]' | ||||
| end | ||||
|
Jean-Philippe Lang
|
r1296 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_new_global_query | ||
|
Jean-Philippe Lang
|
r1297 | @request.session[:user_id] = 2 | ||
| get :new | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r11764 | assert_select 'input[name=?]', 'query[visibility]', 0 | ||
|
Jean-Philippe Lang
|
r13242 | assert_select 'input[name=query_is_for_all][type=checkbox][checked]:not([disabled])' | ||
|
Jean-Philippe Lang
|
r1297 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_new_on_invalid_project | ||
| @request.session[:user_id] = 2 | ||||
| get :new, :project_id => 'invalid' | ||||
| assert_response 404 | ||||
| end | ||||
|
Jean-Philippe Lang
|
r15257 | def test_new_time_entry_query | ||
| @request.session[:user_id] = 2 | ||||
| get :new, :project_id => 1, :type => 'TimeEntryQuery' | ||||
| assert_response :success | ||||
| assert_select 'input[name=type][value=?]', 'TimeEntryQuery' | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8145 | def test_create_project_public_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 2 | ||
Etienne Massip
|
r7529 | post :create, | ||
|
Toshi MARUYAMA
|
r6805 | :project_id => 'ecookbook', | ||
|
Jean-Philippe Lang
|
r1296 | :default_columns => '1', | ||
|
Jean-Philippe Lang
|
r5159 | :f => ["status_id", "assigned_to_id"], | ||
| :op => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :v => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, | ||||
|
Jean-Philippe Lang
|
r11764 | :query => {"name" => "test_new_project_public_query", "visibility" => "2"} | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r1296 | q = Query.find_by_name('test_new_project_public_query') | ||
Eric Davis
|
r2773 | assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q | ||
|
Jean-Philippe Lang
|
r1296 | assert q.is_public? | ||
| assert q.has_default_columns? | ||||
| assert q.valid? | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_create_project_private_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 3 | ||
|
Etienne Massip
|
r7529 | post :create, | ||
|
Toshi MARUYAMA
|
r6805 | :project_id => 'ecookbook', | ||
|
Jean-Philippe Lang
|
r1296 | :default_columns => '1', | ||
| :fields => ["status_id", "assigned_to_id"], | ||||
| :operators => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, | ||||
|
Jean-Philippe Lang
|
r14006 | :query => {"name" => "test_new_project_private_query", "visibility" => "0"} | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r1296 | q = Query.find_by_name('test_new_project_private_query') | ||
|
Eric Davis
|
r2773 | assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q | ||
|
Jean-Philippe Lang
|
r1296 | assert !q.is_public? | ||
| assert q.has_default_columns? | ||||
| assert q.valid? | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r14090 | def test_create_project_roles_query | ||
| @request.session[:user_id] = 2 | ||||
| post :create, | ||||
| :project_id => 'ecookbook', | ||||
| :default_columns => '1', | ||||
| :fields => ["status_id", "assigned_to_id"], | ||||
| :operators => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, | ||||
| :query => {"name" => "test_create_project_roles_query", "visibility" => "1", "role_ids" => ["1", "2", ""]} | ||||
| q = Query.find_by_name('test_create_project_roles_query') | ||||
| assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q | ||||
| assert_equal Query::VISIBILITY_ROLES, q.visibility | ||||
| assert_equal [1, 2], q.roles.ids.sort | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8145 | def test_create_global_private_query_with_custom_columns | ||
|
Jean-Philippe Lang
|
r1297 | @request.session[:user_id] = 3 | ||
|
Etienne Massip
|
r7529 | post :create, | ||
|
Jean-Philippe Lang
|
r1297 | :fields => ["status_id", "assigned_to_id"], | ||
| :operators => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]}, | ||||
|
Jean-Philippe Lang
|
r14006 | :query => {"name" => "test_new_global_private_query", "visibility" => "0"}, | ||
|
Jean-Philippe Lang
|
r5184 | :c => ["", "tracker", "subject", "priority", "category"] | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r1297 | q = Query.find_by_name('test_new_global_private_query') | ||
|
Eric Davis
|
r2773 | assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q | ||
|
Jean-Philippe Lang
|
r1297 | assert !q.is_public? | ||
| assert !q.has_default_columns? | ||||
|
Jean-Philippe Lang
|
r11217 | assert_equal [:id, :tracker, :subject, :priority, :category], q.columns.collect {|c| c.name} | ||
|
Jean-Philippe Lang
|
r1297 | assert q.valid? | ||
| end | ||||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_create_global_query_with_custom_filters | ||
|
Etienne Massip
|
r7529 | @request.session[:user_id] = 3 | ||
| post :create, | ||||
| :fields => ["assigned_to_id"], | ||||
| :operators => {"assigned_to_id" => "="}, | ||||
| :values => { "assigned_to_id" => ["me"]}, | ||||
| :query => {"name" => "test_new_global_query"} | ||||
| q = Query.find_by_name('test_new_global_query') | ||||
| assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q | ||||
|
Jean-Philippe Lang
|
r14006 | assert !q.is_public? | ||
|
Etienne Massip
|
r7529 | assert !q.has_filter?(:status_id) | ||
| assert_equal ['assigned_to_id'], q.filters.keys | ||||
| assert q.valid? | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8145 | def test_create_with_sort | ||
|
Jean-Philippe Lang
|
r2504 | @request.session[:user_id] = 1 | ||
|
Etienne Massip
|
r7529 | post :create, | ||
|
Jean-Philippe Lang
|
r2504 | :default_columns => '1', | ||
| :operators => {"status_id" => "o"}, | ||||
| :values => {"status_id" => ["1"]}, | ||||
| :query => {:name => "test_new_with_sort", | ||||
|
Jean-Philippe Lang
|
r11764 | :visibility => "2", | ||
|
Jean-Philippe Lang
|
r2504 | :sort_criteria => {"0" => ["due_date", "desc"], "1" => ["tracker", ""]}} | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r2504 | query = Query.find_by_name("test_new_with_sort") | ||
| assert_not_nil query | ||||
| assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_create_with_failure | ||
| @request.session[:user_id] = 2 | ||||
|
Jean-Philippe Lang
|
r9346 | assert_no_difference '::Query.count' do | ||
|
Jean-Philippe Lang
|
r8145 | post :create, :project_id => 'ecookbook', :query => {:name => ''} | ||
| end | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r9528 | assert_select 'input[name=?]', 'query[name]' | ||
|
Jean-Philippe Lang
|
r8145 | end | ||
|
Jean-Philippe Lang
|
r11790 | def test_create_global_query_from_gantt | ||
| @request.session[:user_id] = 1 | ||||
| assert_difference 'IssueQuery.count' do | ||||
| post :create, | ||||
| :gantt => 1, | ||||
| :operators => {"status_id" => "o"}, | ||||
| :values => {"status_id" => ["1"]}, | ||||
| :query => {:name => "test_create_from_gantt", | ||||
| :draw_relations => '1', | ||||
| :draw_progress_line => '1'} | ||||
| assert_response 302 | ||||
| end | ||||
| query = IssueQuery.order('id DESC').first | ||||
| assert_redirected_to "/issues/gantt?query_id=#{query.id}" | ||||
| assert_equal true, query.draw_relations | ||||
| assert_equal true, query.draw_progress_line | ||||
| end | ||||
| def test_create_project_query_from_gantt | ||||
| @request.session[:user_id] = 1 | ||||
| assert_difference 'IssueQuery.count' do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', | ||||
| :gantt => 1, | ||||
| :operators => {"status_id" => "o"}, | ||||
| :values => {"status_id" => ["1"]}, | ||||
| :query => {:name => "test_create_from_gantt", | ||||
| :draw_relations => '0', | ||||
| :draw_progress_line => '0'} | ||||
| assert_response 302 | ||||
| end | ||||
| query = IssueQuery.order('id DESC').first | ||||
| assert_redirected_to "/projects/ecookbook/issues/gantt?query_id=#{query.id}" | ||||
| assert_equal false, query.draw_relations | ||||
| assert_equal false, query.draw_progress_line | ||||
| end | ||||
|
Jean-Philippe Lang
|
r14006 | def test_create_project_public_query_should_force_private_without_manage_public_queries_permission | ||
| @request.session[:user_id] = 3 | ||||
| query = new_record(Query) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', | ||||
| :query => {"name" => "name", "visibility" => "2"} | ||||
| assert_response 302 | ||||
| end | ||||
| assert_not_nil query.project | ||||
| assert_equal Query::VISIBILITY_PRIVATE, query.visibility | ||||
| end | ||||
| def test_create_global_public_query_should_force_private_without_manage_public_queries_permission | ||||
| @request.session[:user_id] = 3 | ||||
| query = new_record(Query) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', :query_is_for_all => '1', | ||||
| :query => {"name" => "name", "visibility" => "2"} | ||||
| assert_response 302 | ||||
| end | ||||
| assert_nil query.project | ||||
| assert_equal Query::VISIBILITY_PRIVATE, query.visibility | ||||
| end | ||||
| def test_create_project_public_query_with_manage_public_queries_permission | ||||
| @request.session[:user_id] = 2 | ||||
| query = new_record(Query) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', | ||||
| :query => {"name" => "name", "visibility" => "2"} | ||||
| assert_response 302 | ||||
| end | ||||
| assert_not_nil query.project | ||||
| assert_equal Query::VISIBILITY_PUBLIC, query.visibility | ||||
| end | ||||
| def test_create_global_public_query_should_force_private_with_manage_public_queries_permission | ||||
| @request.session[:user_id] = 2 | ||||
| query = new_record(Query) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', :query_is_for_all => '1', | ||||
| :query => {"name" => "name", "visibility" => "2"} | ||||
| assert_response 302 | ||||
| end | ||||
| assert_nil query.project | ||||
| assert_equal Query::VISIBILITY_PRIVATE, query.visibility | ||||
| end | ||||
| def test_create_global_public_query_by_admin | ||||
| @request.session[:user_id] = 1 | ||||
| query = new_record(Query) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', :query_is_for_all => '1', | ||||
| :query => {"name" => "name", "visibility" => "2"} | ||||
| assert_response 302 | ||||
| end | ||||
| assert_nil query.project | ||||
| assert_equal Query::VISIBILITY_PUBLIC, query.visibility | ||||
| end | ||||
|
Jean-Philippe Lang
|
r15257 | def test_create_project_public_time_entry_query | ||
| @request.session[:user_id] = 2 | ||||
| q = new_record(TimeEntryQuery) do | ||||
| post :create, | ||||
| :project_id => 'ecookbook', | ||||
| :type => 'TimeEntryQuery', | ||||
| :default_columns => '1', | ||||
| :f => ["spent_on"], | ||||
| :op => {"spent_on" => "="}, | ||||
| :v => { "spent_on" => ["2016-07-14"]}, | ||||
| :query => {"name" => "test_new_project_public_query", "visibility" => "2"} | ||||
| end | ||||
| assert_redirected_to :controller => 'timelog', :action => 'index', :project_id => 'ecookbook', :query_id => q.id | ||||
| assert q.is_public? | ||||
| assert q.has_default_columns? | ||||
| assert q.valid? | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8145 | def test_edit_global_public_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 1 | ||
| get :edit, :id => 4 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r13237 | assert_select 'input[name=?][value="2"][checked=checked]', 'query[visibility]' | ||
|
Jean-Philippe Lang
|
r14006 | assert_select 'input[name=query_is_for_all][type=checkbox][checked=checked]' | ||
|
Jean-Philippe Lang
|
r1296 | end | ||
|
Jean-Philippe Lang
|
r8145 | def test_edit_global_private_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 3 | ||
| get :edit, :id => 3 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r11764 | assert_select 'input[name=?]', 'query[visibility]', 0 | ||
|
Jean-Philippe Lang
|
r14006 | assert_select 'input[name=query_is_for_all][type=checkbox][checked=checked]' | ||
|
Jean-Philippe Lang
|
r1296 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_edit_project_private_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 3 | ||
| get :edit, :id => 2 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r11764 | assert_select 'input[name=?]', 'query[visibility]', 0 | ||
|
Jean-Philippe Lang
|
r14006 | assert_select 'input[name=query_is_for_all][type=checkbox]:not([checked])' | ||
|
Jean-Philippe Lang
|
r1296 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_edit_project_public_query | ||
|
Jean-Philippe Lang
|
r1296 | @request.session[:user_id] = 2 | ||
| get :edit, :id => 1 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r13237 | assert_select 'input[name=?][value="2"][checked=checked]', 'query[visibility]' | ||
|
Jean-Philippe Lang
|
r14006 | assert_select 'input[name=query_is_for_all][type=checkbox]:not([checked])' | ||
|
Jean-Philippe Lang
|
r1296 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_edit_sort_criteria | ||
|
Jean-Philippe Lang
|
r2504 | @request.session[:user_id] = 1 | ||
| get :edit, :id => 5 | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | |||
|
Jean-Philippe Lang
|
r13242 | assert_select 'select[name=?]', 'query[sort_criteria][0][]' do | ||
| assert_select 'option[value=priority][selected=selected]' | ||||
| assert_select 'option[value=desc][selected=selected]' | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2504 | end | ||
|
Toshi MARUYAMA
|
r6805 | |||
|
Jean-Philippe Lang
|
r8145 | def test_edit_invalid_query | ||
| @request.session[:user_id] = 2 | ||||
| get :edit, :id => 99 | ||||
| assert_response 404 | ||||
| end | ||||
| def test_udpate_global_private_query | ||||
| @request.session[:user_id] = 3 | ||||
| put :update, | ||||
| :id => 3, | ||||
| :default_columns => '1', | ||||
| :fields => ["status_id", "assigned_to_id"], | ||||
| :operators => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]}, | ||||
|
Jean-Philippe Lang
|
r11764 | :query => {"name" => "test_edit_global_private_query", "visibility" => "2"} | ||
|
Jean-Philippe Lang
|
r8145 | |||
| assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 3 | ||||
| q = Query.find_by_name('test_edit_global_private_query') | ||||
| assert !q.is_public? | ||||
| assert q.has_default_columns? | ||||
| assert q.valid? | ||||
| end | ||||
| def test_update_global_public_query | ||||
| @request.session[:user_id] = 1 | ||||
| put :update, | ||||
| :id => 4, | ||||
| :default_columns => '1', | ||||
| :fields => ["status_id", "assigned_to_id"], | ||||
| :operators => {"assigned_to_id" => "=", "status_id" => "o"}, | ||||
| :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, | ||||
|
Jean-Philippe Lang
|
r11764 | :query => {"name" => "test_edit_global_public_query", "visibility" => "2"} | ||
|
Jean-Philippe Lang
|
r8145 | |||
| assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 4 | ||||
| q = Query.find_by_name('test_edit_global_public_query') | ||||
| assert q.is_public? | ||||
| assert q.has_default_columns? | ||||
| assert q.valid? | ||||
| end | ||||
| def test_update_with_failure | ||||
| @request.session[:user_id] = 1 | ||||
| put :update, :id => 4, :query => {:name => ''} | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r15333 | assert_select_error /Name cannot be blank/ | ||
|
Jean-Philippe Lang
|
r8145 | end | ||
|
Jean-Philippe Lang
|
r1296 | def test_destroy | ||
| @request.session[:user_id] = 2 | ||||
|
Etienne Massip
|
r7529 | delete :destroy, :id => 1 | ||
|
Jean-Philippe Lang
|
r1296 | assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil | ||
| assert_nil Query.find_by_id(1) | ||||
| end | ||||
|
Jean-Philippe Lang
|
r10260 | |||
| def test_backslash_should_be_escaped_in_filters | ||||
| @request.session[:user_id] = 2 | ||||
| get :new, :subject => 'foo/bar' | ||||
| assert_response :success | ||||
| assert_include 'addFilter("subject", "=", ["foo\/bar"]);', response.body | ||||
| end | ||||
|
Jean-Philippe Lang
|
r1296 | end | ||