jro_apps/redmine Files · test/unit/time_entry_query_test.rb

Speeds up rendering of the project list for users who belong to hundreds of projects....

Speeds up rendering of the project list for users who belong to hundreds of projects. git-svn-id: http://svn.redmine.org/redmine/trunk@16123 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r15508:960b32238830


                r15741:f8df935dcada

Download file

             time_entry_query_test.rb
        
                    81 lines
            
             | 3.8 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / test / unit / time_entry_query_test.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
      # Redmine - project management software

        Jean-Philippe Lang
    
Updates copyright for 2016....

              r14856
            
      # Copyright (C) 2006-2016  Jean-Philippe Lang

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
      #

      # 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.

      #

      # 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.

      #

      # 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__)

      class TimeEntryQueryTest < ActiveSupport::TestCase

        Toshi MARUYAMA
    
add missing fixtures to TimeEntryQueryTest...

              r13022
            
        fixtures :issues, :projects, :users,

                 :members, :roles, :member_roles,

                 :trackers, :issue_statuses,

                 :projects_trackers,

                 :journals, :journal_details,

                 :issue_categories, :enumerations,

                 :groups_users,

                 :enabled_modules

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
        Jean-Philippe Lang
    
Include inactive activities in time entries filter (#20117)....

              r14244
            
        def test_cross_project_activity_filter_should_propose_non_active_activities

          activity = TimeEntryActivity.create!(:name => 'Disabled', :active => false)

          assert !activity.active?

          query = TimeEntryQuery.new(:name => '_')

          assert options = query.available_filters['activity_id']

          assert values = options[:values]

          assert_include ["Disabled", activity.id.to_s], values

        end

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
        def test_activity_filter_should_consider_system_and_project_activities

          TimeEntry.delete_all

          system = TimeEntryActivity.create!(:name => 'Foo')

        Jean-Philippe Lang
    
Fixed test failures introduced by r14288 (#19656)....

              r13909
            
          TimeEntry.generate!(:activity => system, :hours => 1.0)

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
          override = TimeEntryActivity.create!(:name => 'Foo', :parent_id => system.id, :project_id => 1)

          other = TimeEntryActivity.create!(:name => 'Bar')

          TimeEntry.generate!(:activity => override, :hours => 2.0)

          TimeEntry.generate!(:activity => other, :hours => 4.0)

          query = TimeEntryQuery.new(:name => '_')

          query.add_filter('activity_id', '=', [system.id.to_s])

          assert_equal 3.0, query.results_scope.sum(:hours)

          query = TimeEntryQuery.new(:name => '_')

          query.add_filter('activity_id', '!', [system.id.to_s])

          assert_equal 4.0, query.results_scope.sum(:hours)

        end

        Jean-Philippe Lang
    
Consider custom fields that correspond to the project only (#24014)....

              r15508
            
        def test_project_query_should_include_project_issue_custom_fields_only_as_filters

          global = IssueCustomField.generate!(:is_for_all => true, :is_filter => true)

          field_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [3], :is_filter => true)

          field_not_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [1,2], :is_filter => true)

          query = TimeEntryQuery.new(:project => Project.find(3))

          assert_include "issue.cf_#{global.id}", query.available_filters.keys

          assert_include "issue.cf_#{field_on_project.id}", query.available_filters.keys

          assert_not_include "issue.cf_#{field_not_on_project.id}", query.available_filters.keys

        end

        def test_project_query_should_include_project_issue_custom_fields_only_as_columns

          global = IssueCustomField.generate!(:is_for_all => true, :is_filter => true)

          field_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [3], :is_filter => true)

          field_not_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [1,2], :is_filter => true)

          query = TimeEntryQuery.new(:project => Project.find(3))

          assert_include "issue.cf_#{global.id}", query.available_columns.map(&:name).map(&:to_s)

          assert_include "issue.cf_#{field_on_project.id}", query.available_columns.map(&:name).map(&:to_s)

          assert_not_include "issue.cf_#{field_not_on_project.id}", query.available_columns.map(&:name).map(&:to_s)

        end

        Jean-Philippe Lang
    
Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....

              r12139
            
      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139	# Redmine - project management software
Jean-Philippe Lang Updates copyright for 2016....	r14856	# Copyright (C) 2006-2016 Jean-Philippe Lang
Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139	#
		# 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.
		#
		# 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.
		#
		# 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__)

		class TimeEntryQueryTest < ActiveSupport::TestCase
Toshi MARUYAMA add missing fixtures to TimeEntryQueryTest...	r13022	fixtures :issues, :projects, :users,
		:members, :roles, :member_roles,
		:trackers, :issue_statuses,
		:projects_trackers,
		:journals, :journal_details,
		:issue_categories, :enumerations,
		:groups_users,
		:enabled_modules
Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139
Jean-Philippe Lang Include inactive activities in time entries filter (#20117)....	r14244	def test_cross_project_activity_filter_should_propose_non_active_activities
		activity = TimeEntryActivity.create!(:name => 'Disabled', :active => false)
		assert !activity.active?

		query = TimeEntryQuery.new(:name => '_')
		assert options = query.available_filters['activity_id']
		assert values = options[:values]
		assert_include ["Disabled", activity.id.to_s], values
		end

Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139	def test_activity_filter_should_consider_system_and_project_activities
		TimeEntry.delete_all
		system = TimeEntryActivity.create!(:name => 'Foo')
Jean-Philippe Lang Fixed test failures introduced by r14288 (#19656)....	r13909	TimeEntry.generate!(:activity => system, :hours => 1.0)
Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139	override = TimeEntryActivity.create!(:name => 'Foo', :parent_id => system.id, :project_id => 1)
		other = TimeEntryActivity.create!(:name => 'Bar')
		TimeEntry.generate!(:activity => override, :hours => 2.0)
		TimeEntry.generate!(:activity => other, :hours => 4.0)

		query = TimeEntryQuery.new(:name => '_')
		query.add_filter('activity_id', '=', [system.id.to_s])
		assert_equal 3.0, query.results_scope.sum(:hours)

		query = TimeEntryQuery.new(:name => '_')
		query.add_filter('activity_id', '!', [system.id.to_s])
		assert_equal 4.0, query.results_scope.sum(:hours)
		end
Jean-Philippe Lang Consider custom fields that correspond to the project only (#24014)....	r15508
		def test_project_query_should_include_project_issue_custom_fields_only_as_filters
		global = IssueCustomField.generate!(:is_for_all => true, :is_filter => true)
		field_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [3], :is_filter => true)
		field_not_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [1,2], :is_filter => true)

		query = TimeEntryQuery.new(:project => Project.find(3))

		assert_include "issue.cf_#{global.id}", query.available_filters.keys
		assert_include "issue.cf_#{field_on_project.id}", query.available_filters.keys
		assert_not_include "issue.cf_#{field_not_on_project.id}", query.available_filters.keys
		end

		def test_project_query_should_include_project_issue_custom_fields_only_as_columns
		global = IssueCustomField.generate!(:is_for_all => true, :is_filter => true)
		field_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [3], :is_filter => true)
		field_not_on_project = IssueCustomField.generate!(:is_for_all => false, :project_ids => [1,2], :is_filter => true)

		query = TimeEntryQuery.new(:project => Project.find(3))

		assert_include "issue.cf_#{global.id}", query.available_columns.map(&:name).map(&:to_s)
		assert_include "issue.cf_#{field_on_project.id}", query.available_columns.map(&:name).map(&:to_s)
		assert_not_include "issue.cf_#{field_not_on_project.id}", query.available_columns.map(&:name).map(&:to_s)
		end
Jean-Philippe Lang Fixed that filtering time entries on activity does not take care of activity overrides (#15623)....	r12139	end