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