comparison test/functional/queries_controller_test.rb @ 1115:433d4f72a19b redmine-2.2

Update to Redmine SVN revision 11137 on 2.2-stable branch

 # Redmine - project management software
-# Copyright (C) 2006-2011  Jean-Philippe Lang
+# Copyright (C) 2006-2012  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.

 # 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 File.expand_path('../../test_helper', __FILE__)
-require 'queries_controller'
-
-# Re-raise errors caught by the controller.
-class QueriesController; def rescue_action(e) raise e end; end
 
 class QueriesControllerTest < ActionController::TestCase
-  fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries
+  fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries, :enabled_modules
 
   def setup
-    @controller = QueriesController.new
-    @request    = ActionController::TestRequest.new
-    @response   = ActionController::TestResponse.new
     User.current = nil
   end
 
-  def test_get_new_project_query
+  def test_new_project_query
     @request.session[:user_id] = 2
     get :new, :project_id => 1
     assert_response :success
     assert_template 'new'
     assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :checked => nil }
     assert_tag :tag => 'input', :attributes => { :type => 'checkbox',
                                                  :name => 'query_is_for_all',
                                                  :checked => nil,
                                                  :disabled => nil }
-  end
-
-  def test_get_new_global_query
+    assert_select 'select[name=?]', 'c[]' do
+      assert_select 'option[value=tracker]'
+      assert_select 'option[value=subject]'
+    end
+  end
+
+  def test_new_global_query
     @request.session[:user_id] = 2
     get :new
     assert_response :success
     assert_template 'new'
     assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :name => 'query_is_for_all',
                                                  :checked => 'checked',
                                                  :disabled => nil }
   end
 
-  def test_new_project_public_query
+  def test_new_on_invalid_project
+    @request.session[:user_id] = 2
+    get :new, :project_id => 'invalid'
+    assert_response 404
+  end
+
+  def test_create_project_public_query
     @request.session[:user_id] = 2
     post :create,
          :project_id => 'ecookbook',
          :default_columns => '1',
          :f => ["status_id", "assigned_to_id"],

     assert q.is_public?
     assert q.has_default_columns?
     assert q.valid?
   end
 
-  def test_new_project_private_query
+  def test_create_project_private_query
     @request.session[:user_id] = 3
     post :create,
          :project_id => 'ecookbook',
          :default_columns => '1',
          :fields => ["status_id", "assigned_to_id"],

     assert !q.is_public?
     assert q.has_default_columns?
     assert q.valid?
   end
 
-  def test_new_global_private_query_with_custom_columns
+  def test_create_global_private_query_with_custom_columns
     @request.session[:user_id] = 3
     post :create,
          :fields => ["status_id", "assigned_to_id"],
          :operators => {"assigned_to_id" => "=", "status_id" => "o"},
          :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},

     assert !q.has_default_columns?
     assert_equal [:tracker, :subject, :priority, :category], q.columns.collect {|c| c.name}
     assert q.valid?
   end
 
-  def test_new_global_query_with_custom_filters
+  def test_create_global_query_with_custom_filters
     @request.session[:user_id] = 3
     post :create,
          :fields => ["assigned_to_id"],
          :operators => {"assigned_to_id" => "="},
          :values => { "assigned_to_id" => ["me"]},

     assert !q.has_filter?(:status_id)
     assert_equal ['assigned_to_id'], q.filters.keys
     assert q.valid?
   end
 
-  def test_new_with_sort
+  def test_create_with_sort
     @request.session[:user_id] = 1
     post :create,
          :default_columns => '1',
          :operators => {"status_id" => "o"},
          :values => {"status_id" => ["1"]},

     query = Query.find_by_name("test_new_with_sort")
     assert_not_nil query
     assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria
   end
 
-  def test_get_edit_global_public_query
+  def test_create_with_failure
+    @request.session[:user_id] = 2
+    assert_no_difference '::Query.count' do
+      post :create, :project_id => 'ecookbook', :query => {:name => ''}
+    end
+    assert_response :success
+    assert_template 'new'
+    assert_select 'input[name=?]', 'query[name]'
+  end
+
+  def test_edit_global_public_query
     @request.session[:user_id] = 1
     get :edit, :id => 4
     assert_response :success
     assert_template 'edit'
     assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :name => 'query_is_for_all',
                                                  :checked => 'checked',
                                                  :disabled => 'disabled' }
   end
 
-  def test_edit_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"]},
-         :query => {"name" => "test_edit_global_public_query", "is_public" => "1"}
-
-    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_get_edit_global_private_query
+  def test_edit_global_private_query
     @request.session[:user_id] = 3
     get :edit, :id => 3
     assert_response :success
     assert_template 'edit'
     assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :name => 'query_is_for_all',
                                                  :checked => 'checked',
                                                  :disabled => 'disabled' }
   end
 
-  def test_edit_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"]},
-         :query => {"name" => "test_edit_global_private_query", "is_public" => "1"}
-
-    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_get_edit_project_private_query
+  def test_edit_project_private_query
     @request.session[:user_id] = 3
     get :edit, :id => 2
     assert_response :success
     assert_template 'edit'
     assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :name => 'query_is_for_all',
                                                  :checked => nil,
                                                  :disabled => nil }
   end
 
-  def test_get_edit_project_public_query
+  def test_edit_project_public_query
     @request.session[:user_id] = 2
     get :edit, :id => 1
     assert_response :success
     assert_template 'edit'
     assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                  :name => 'query_is_for_all',
                                                  :checked => nil,
                                                  :disabled => 'disabled' }
   end
 
-  def test_get_edit_sort_criteria
+  def test_edit_sort_criteria
     @request.session[:user_id] = 1
     get :edit, :id => 5
     assert_response :success
     assert_template 'edit'
     assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },

     assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },
                                  :child => { :tag => 'option', :attributes => { :value => 'desc',
                                                                                 :selected => 'selected' } }
   end
 
+  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"]},
+         :query => {"name" => "test_edit_global_private_query", "is_public" => "1"}
+
+    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"]},
+         :query => {"name" => "test_edit_global_public_query", "is_public" => "1"}
+
+    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
+    assert_template 'edit'
+  end
+
   def test_destroy
     @request.session[:user_id] = 2
     delete :destroy, :id => 1
     assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil
     assert_nil Query.find_by_id(1)
   end
+
+  def test_backslash_should_be_escaped_in_filters
+    @request.session[:user_id] = 2
+    get :new, :subject => 'foo/bar'
+    assert_response :success
+    assert_template 'new'
+    assert_include 'addFilter("subject", "=", ["foo\/bar"]);', response.body
+  end
 end