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

replace depricated Net::LDAP::LdapError by Net::LDAP::Error (#24970)...

replace depricated Net::LDAP::LdapError by Net::LDAP::Error (#24970) git-svn-id: http://svn.redmine.org/redmine/trunk@16322 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r15788:fd3c08aaa107


                r15940:d37125dfe98b

Download file

             time_entry_query_test.rb
        
                    103 lines
            
             | 4.5 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
    
Don't preload all query filters (#24787)....

              r15788
            
        def test_filter_values_without_project_should_be_arrays

          q = TimeEntryQuery.new

          assert_nil q.project

          q.available_filters.each do |name, filter|

            values = filter.values

            assert (values.nil? || values.is_a?(Array)),

              "#values for #{name} filter returned a #{values.class.name}"

          end

        end

        def test_filter_values_with_project_should_be_arrays

          q = TimeEntryQuery.new(:project => Project.find(1))

          assert_not_nil q.project

          q.available_filters.each do |name, filter|

            values = filter.values

            assert (values.nil? || values.is_a?(Array)),

              "#values for #{name} filter returned a #{values.class.name}"

          end

        end

        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 Don't preload all query filters (#24787)....	r15788	def test_filter_values_without_project_should_be_arrays
		q = TimeEntryQuery.new
		assert_nil q.project

		q.available_filters.each do \|name, filter\|
		values = filter.values
		assert (values.nil? \|\| values.is_a?(Array)),
		"#values for #{name} filter returned a #{values.class.name}"
		end
		end

		def test_filter_values_with_project_should_be_arrays
		q = TimeEntryQuery.new(:project => Project.find(1))
		assert_not_nil q.project

		q.available_filters.each do \|name, filter\|
		values = filter.values
		assert (values.nil? \|\| values.is_a?(Array)),
		"#values for #{name} filter returned a #{values.class.name}"
		end
		end

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