Chris@0: # redMine - project management software Chris@0: # Copyright (C) 2006-2008 Jean-Philippe Lang Chris@0: # Chris@0: # This program is free software; you can redistribute it and/or Chris@0: # modify it under the terms of the GNU General Public License Chris@0: # as published by the Free Software Foundation; either version 2 Chris@0: # of the License, or (at your option) any later version. Chris@0: # Chris@0: # This program is distributed in the hope that it will be useful, Chris@0: # but WITHOUT ANY WARRANTY; without even the implied warranty of Chris@0: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the Chris@0: # GNU General Public License for more details. Chris@0: # Chris@0: # You should have received a copy of the GNU General Public License Chris@0: # along with this program; if not, write to the Free Software Chris@0: # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. Chris@0: Chris@119: require File.expand_path('../../test_helper', __FILE__) Chris@0: require 'queries_controller' Chris@0: Chris@0: # Re-raise errors caught by the controller. Chris@0: class QueriesController; def rescue_action(e) raise e end; end Chris@0: Chris@0: class QueriesControllerTest < ActionController::TestCase Chris@0: fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries Chris@0: Chris@0: def setup Chris@0: @controller = QueriesController.new Chris@0: @request = ActionController::TestRequest.new Chris@0: @response = ActionController::TestResponse.new Chris@0: User.current = nil Chris@0: end Chris@0: Chris@0: def test_get_new_project_query Chris@0: @request.session[:user_id] = 2 Chris@0: get :new, :project_id => 1 Chris@0: assert_response :success Chris@0: assert_template 'new' Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]', Chris@0: :checked => nil } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => nil, Chris@0: :disabled => nil } Chris@0: end Chris@0: Chris@0: def test_get_new_global_query Chris@0: @request.session[:user_id] = 2 Chris@0: get :new Chris@0: assert_response :success Chris@0: assert_template 'new' Chris@0: assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]' } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => 'checked', Chris@0: :disabled => nil } Chris@0: end Chris@0: Chris@0: def test_new_project_public_query Chris@0: @request.session[:user_id] = 2 Chris@0: post :new, Chris@0: :project_id => 'ecookbook', Chris@0: :confirm => '1', Chris@0: :default_columns => '1', Chris@441: :f => ["status_id", "assigned_to_id"], Chris@441: :op => {"assigned_to_id" => "=", "status_id" => "o"}, Chris@441: :v => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, Chris@0: :query => {"name" => "test_new_project_public_query", "is_public" => "1"} Chris@0: Chris@0: q = Query.find_by_name('test_new_project_public_query') Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q Chris@0: assert q.is_public? Chris@0: assert q.has_default_columns? Chris@0: assert q.valid? Chris@0: end Chris@0: Chris@0: def test_new_project_private_query Chris@0: @request.session[:user_id] = 3 Chris@0: post :new, Chris@0: :project_id => 'ecookbook', Chris@0: :confirm => '1', Chris@0: :default_columns => '1', Chris@0: :fields => ["status_id", "assigned_to_id"], Chris@0: :operators => {"assigned_to_id" => "=", "status_id" => "o"}, Chris@0: :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, Chris@0: :query => {"name" => "test_new_project_private_query", "is_public" => "1"} Chris@0: Chris@0: q = Query.find_by_name('test_new_project_private_query') Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q Chris@0: assert !q.is_public? Chris@0: assert q.has_default_columns? Chris@0: assert q.valid? Chris@0: end Chris@0: Chris@0: def test_new_global_private_query_with_custom_columns Chris@0: @request.session[:user_id] = 3 Chris@0: post :new, Chris@0: :confirm => '1', Chris@0: :fields => ["status_id", "assigned_to_id"], Chris@0: :operators => {"assigned_to_id" => "=", "status_id" => "o"}, Chris@0: :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]}, Chris@441: :query => {"name" => "test_new_global_private_query", "is_public" => "1"}, Chris@441: :c => ["", "tracker", "subject", "priority", "category"] Chris@0: Chris@0: q = Query.find_by_name('test_new_global_private_query') Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q Chris@0: assert !q.is_public? Chris@0: assert !q.has_default_columns? Chris@0: assert_equal [:tracker, :subject, :priority, :category], q.columns.collect {|c| c.name} Chris@0: assert q.valid? Chris@0: end Chris@0: Chris@0: def test_new_with_sort Chris@0: @request.session[:user_id] = 1 Chris@0: post :new, Chris@0: :confirm => '1', Chris@0: :default_columns => '1', Chris@0: :operators => {"status_id" => "o"}, Chris@0: :values => {"status_id" => ["1"]}, Chris@0: :query => {:name => "test_new_with_sort", Chris@0: :is_public => "1", Chris@0: :sort_criteria => {"0" => ["due_date", "desc"], "1" => ["tracker", ""]}} Chris@0: Chris@0: query = Query.find_by_name("test_new_with_sort") Chris@0: assert_not_nil query Chris@0: assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria Chris@0: end Chris@0: Chris@0: def test_get_edit_global_public_query Chris@0: @request.session[:user_id] = 1 Chris@0: get :edit, :id => 4 Chris@0: assert_response :success Chris@0: assert_template 'edit' Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]', Chris@0: :checked => 'checked' } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => 'checked', Chris@0: :disabled => 'disabled' } Chris@0: end Chris@0: Chris@0: def test_edit_global_public_query Chris@0: @request.session[:user_id] = 1 Chris@0: post :edit, Chris@0: :id => 4, Chris@0: :confirm => '1', Chris@0: :default_columns => '1', Chris@0: :fields => ["status_id", "assigned_to_id"], Chris@0: :operators => {"assigned_to_id" => "=", "status_id" => "o"}, Chris@0: :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]}, Chris@0: :query => {"name" => "test_edit_global_public_query", "is_public" => "1"} Chris@0: Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 4 Chris@0: q = Query.find_by_name('test_edit_global_public_query') Chris@0: assert q.is_public? Chris@0: assert q.has_default_columns? Chris@0: assert q.valid? Chris@0: end Chris@0: Chris@0: def test_get_edit_global_private_query Chris@0: @request.session[:user_id] = 3 Chris@0: get :edit, :id => 3 Chris@0: assert_response :success Chris@0: assert_template 'edit' Chris@0: assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]' } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => 'checked', Chris@0: :disabled => 'disabled' } Chris@0: end Chris@0: Chris@0: def test_edit_global_private_query Chris@0: @request.session[:user_id] = 3 Chris@0: post :edit, Chris@0: :id => 3, Chris@0: :confirm => '1', Chris@0: :default_columns => '1', Chris@0: :fields => ["status_id", "assigned_to_id"], Chris@0: :operators => {"assigned_to_id" => "=", "status_id" => "o"}, Chris@0: :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]}, Chris@0: :query => {"name" => "test_edit_global_private_query", "is_public" => "1"} Chris@0: Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 3 Chris@0: q = Query.find_by_name('test_edit_global_private_query') Chris@0: assert !q.is_public? Chris@0: assert q.has_default_columns? Chris@0: assert q.valid? Chris@0: end Chris@0: Chris@0: def test_get_edit_project_private_query Chris@0: @request.session[:user_id] = 3 Chris@0: get :edit, :id => 2 Chris@0: assert_response :success Chris@0: assert_template 'edit' Chris@0: assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]' } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => nil, Chris@0: :disabled => nil } Chris@0: end Chris@0: Chris@0: def test_get_edit_project_public_query Chris@0: @request.session[:user_id] = 2 Chris@0: get :edit, :id => 1 Chris@0: assert_response :success Chris@0: assert_template 'edit' Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query[is_public]', Chris@0: :checked => 'checked' Chris@0: } Chris@0: assert_tag :tag => 'input', :attributes => { :type => 'checkbox', Chris@0: :name => 'query_is_for_all', Chris@0: :checked => nil, Chris@0: :disabled => 'disabled' } Chris@0: end Chris@0: Chris@0: def test_get_edit_sort_criteria Chris@0: @request.session[:user_id] = 1 Chris@0: get :edit, :id => 5 Chris@0: assert_response :success Chris@0: assert_template 'edit' Chris@0: assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' }, Chris@0: :child => { :tag => 'option', :attributes => { :value => 'priority', Chris@0: :selected => 'selected' } } Chris@0: assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' }, Chris@0: :child => { :tag => 'option', :attributes => { :value => 'desc', Chris@0: :selected => 'selected' } } Chris@0: end Chris@0: Chris@0: def test_destroy Chris@0: @request.session[:user_id] = 2 Chris@0: post :destroy, :id => 1 Chris@0: assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil Chris@0: assert_nil Query.find_by_id(1) Chris@0: end Chris@0: end