jro_apps/redmine Files · app/models/principal.rb

scm: git: performance improvements in fetching revisions (#8857, #9472)...

scm: git: performance improvements in fetching revisions (#8857, #9472) Parse a revision for a given branch, just if we haven't parsed it for any branches before. Moved the db check to for existing revisions into a grouped search. Search for many revisions at once: this reduces db load. Revisions are grouped into sets of 100. This is to improve memory consumption. There will be just one query instead of each 100. The above two methods significantly increase parsing speed. Test case was a git repo with 6000+ commits on a master branch, and several other branches originating for master. Speed improved from 1.4h to 18min. Contributed by Gergely Fábián. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@9144 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r9008:6aad82e524c1


                r9024:999a4ba30d7b

Download file

             principal.rb
        
                    95 lines
            
             | 3.3 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / models / principal.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
      # Redmine - project management software

        Jean-Philippe Lang
    
Ability to assign issues to groups (#2964)....

              r6186
            
      # Copyright (C) 2006-2011  Jean-Philippe Lang

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
      #

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

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
      #

        Jean-Philippe Lang
    
Adds missing native eol properties....

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

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
      #

        Jean-Philippe Lang
    
Adds missing native eol properties....

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

      class Principal < ActiveRecord::Base

        Jean-Philippe Lang
    
Fixed: Error on db:migrate with table prefix set (#5335)....

              r3564
            
        set_table_name "#{table_name_prefix}users#{table_name_suffix}"

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
        has_many :members, :foreign_key => 'user_id', :dependent => :destroy

        has_many :memberships, :class_name => 'Member', :foreign_key => 'user_id', :include => [ :project, :roles ], :conditions => "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}", :order => "#{Project.table_name}.name"

        has_many :projects, :through => :memberships

        Jean-Philippe Lang
    
Ability to assign issues to groups (#2964)....

              r6186
            
        has_many :issue_categories, :foreign_key => 'assigned_to_id', :dependent => :nullify

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
        # Groups and active users

        Jean-Philippe Lang
    
Simplifies Principal.active scope (status defaults to 1 for groups)....

              r8626
            
        named_scope :active, :conditions => "#{Principal.table_name}.status = 1"

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
        named_scope :like, lambda {|q|

        Jean-Philippe Lang
    
Makes user autocompleters work with firstname and lastname....

              r8755
            
          if q.blank?

            {}

          else

            q = q.to_s.downcase

            pattern = "%#{q}%"

            sql = "LOWER(login) LIKE :p OR LOWER(firstname) LIKE :p OR LOWER(lastname) LIKE :p OR LOWER(mail) LIKE :p"

            params = {:p => pattern}

            if q =~ /^(.+)\s+(.+)$/

              a, b = "#{$1}%", "#{$2}%"

              sql << " OR (LOWER(firstname) LIKE :a AND LOWER(lastname) LIKE :b) OR (LOWER(firstname) LIKE :b AND LOWER(lastname) LIKE :a)"

              params.merge!(:a => a, :b => b)

            end

            {:conditions => [sql, params]}

          end

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
        }

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
        Jean-Philippe Lang
    
Adds members of subprojects in assignee and author filters (#10126)....

              r8627
            
        # Principals that are members of a collection of projects

        named_scope :member_of, lambda {|projects|

        Jean-Philippe Lang
    
Fixed that the proposed users list may be empty when adding a project member (#10374)....

              r9008
            
          projects = [projects] unless projects.is_a?(Array)

        Jean-Philippe Lang
    
Adds members of subprojects in assignee and author filters (#10126)....

              r8627
            
          if projects.empty?

            {:conditions => "1=0"}

          else

            ids = projects.map(&:id)

            {:conditions => ["#{Principal.table_name}.status = 1 AND #{Principal.table_name}.id IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids]}

          end

        }

        Jean-Philippe Lang
    
Fixed that the proposed users list may be empty when adding a project member (#10374)....

              r9008
            
        # Principals that are not members of projects

        named_scope :not_member_of, lambda {|projects|

          projects = [projects] unless projects.is_a?(Array)

          if projects.empty?

            {:conditions => "1=0"}

          else

            ids = projects.map(&:id)

            {:conditions => ["#{Principal.table_name}.id NOT IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids]}

          end

        }

        Jean-Philippe Lang
    
Adds members of subprojects in assignee and author filters (#10126)....

              r8627
            
        Jean-Philippe Lang
    
Fixed: NOT NULL constraint error when adding a group (#4632)....

              r3229
            
        before_create :set_default_empty_values

        Eric Davis
    
Define Principal#name so all subclasses will have some sort of name when printed....

              r3962
            
        def name(formatter = nil)

          to_s

        end

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
        def <=>(principal)

        Jean-Philippe Lang
    
Fixed potential error when sorting members without role (#10053)....

              r8743
            
          if principal.nil?

            -1

          elsif self.class.name == principal.class.name

        Jean-Philippe Lang
    
Display users then groups on project memberships view (#4389)....

              r3047
            
            self.to_s.downcase <=> principal.to_s.downcase

          else

            # groups after users

            principal.class.name <=> self.class.name

          end

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
        end

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
        Jean-Philippe Lang
    
Fixed: NOT NULL constraint error when adding a group (#4632)....

              r3229
            
        protected

        Toshi MARUYAMA
    
remove trailing white-spaces from app/models/principal.rb....

              r6755
            
        Jean-Philippe Lang
    
Fixed: NOT NULL constraint error when adding a group (#4632)....

              r3229
            
        # Make sure we don't try to insert NULL values (see #4632)

        def set_default_empty_values

          self.login ||= ''

          self.hashed_password ||= ''

          self.firstname ||= ''

          self.lastname ||= ''

          self.mail ||= ''

          true

        end

        Jean-Philippe Lang
    
Adds missing native eol properties....

              r2781
            
      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 Adds missing native eol properties....	r2781	# Redmine - project management software
Jean-Philippe Lang Ability to assign issues to groups (#2964)....	r6186	# Copyright (C) 2006-2011 Jean-Philippe Lang
Jean-Philippe Lang Adds missing native eol properties....	r2781	#
		# 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.
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755	#
Jean-Philippe Lang Adds missing native eol properties....	r2781	# 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.
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755	#
Jean-Philippe Lang Adds missing native eol properties....	r2781	# 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.

		class Principal < ActiveRecord::Base
Jean-Philippe Lang Fixed: Error on db:migrate with table prefix set (#5335)....	r3564	set_table_name "#{table_name_prefix}users#{table_name_suffix}"
Jean-Philippe Lang Adds missing native eol properties....	r2781
		has_many :members, :foreign_key => 'user_id', :dependent => :destroy
		has_many :memberships, :class_name => 'Member', :foreign_key => 'user_id', :include => [ :project, :roles ], :conditions => "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}", :order => "#{Project.table_name}.name"
		has_many :projects, :through => :memberships
Jean-Philippe Lang Ability to assign issues to groups (#2964)....	r6186	has_many :issue_categories, :foreign_key => 'assigned_to_id', :dependent => :nullify
Jean-Philippe Lang Adds missing native eol properties....	r2781
		# Groups and active users
Jean-Philippe Lang Simplifies Principal.active scope (status defaults to 1 for groups)....	r8626	named_scope :active, :conditions => "#{Principal.table_name}.status = 1"
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755
		named_scope :like, lambda {\|q\|
Jean-Philippe Lang Makes user autocompleters work with firstname and lastname....	r8755	if q.blank?
		{}
		else
		q = q.to_s.downcase
		pattern = "%#{q}%"
		sql = "LOWER(login) LIKE :p OR LOWER(firstname) LIKE :p OR LOWER(lastname) LIKE :p OR LOWER(mail) LIKE :p"
		params = {:p => pattern}
		if q =~ /^(.+)\s+(.+)$/
		a, b = "#{$1}%", "#{$2}%"
		sql << " OR (LOWER(firstname) LIKE :a AND LOWER(lastname) LIKE :b) OR (LOWER(firstname) LIKE :b AND LOWER(lastname) LIKE :a)"
		params.merge!(:a => a, :b => b)
		end
		{:conditions => [sql, params]}
		end
Jean-Philippe Lang Adds missing native eol properties....	r2781	}
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755
Jean-Philippe Lang Adds members of subprojects in assignee and author filters (#10126)....	r8627	# Principals that are members of a collection of projects
		named_scope :member_of, lambda {\|projects\|
Jean-Philippe Lang Fixed that the proposed users list may be empty when adding a project member (#10374)....	r9008	projects = [projects] unless projects.is_a?(Array)
Jean-Philippe Lang Adds members of subprojects in assignee and author filters (#10126)....	r8627	if projects.empty?
		{:conditions => "1=0"}
		else
		ids = projects.map(&:id)
		{:conditions => ["#{Principal.table_name}.status = 1 AND #{Principal.table_name}.id IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids]}
		end
		}
Jean-Philippe Lang Fixed that the proposed users list may be empty when adding a project member (#10374)....	r9008	# Principals that are not members of projects
		named_scope :not_member_of, lambda {\|projects\|
		projects = [projects] unless projects.is_a?(Array)
		if projects.empty?
		{:conditions => "1=0"}
		else
		ids = projects.map(&:id)
		{:conditions => ["#{Principal.table_name}.id NOT IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids]}
		end
		}
Jean-Philippe Lang Adds members of subprojects in assignee and author filters (#10126)....	r8627
Jean-Philippe Lang Fixed: NOT NULL constraint error when adding a group (#4632)....	r3229	before_create :set_default_empty_values
Eric Davis Define Principal#name so all subclasses will have some sort of name when printed....	r3962
		def name(formatter = nil)
		to_s
		end

Jean-Philippe Lang Adds missing native eol properties....	r2781	def <=>(principal)
Jean-Philippe Lang Fixed potential error when sorting members without role (#10053)....	r8743	if principal.nil?
		-1
		elsif self.class.name == principal.class.name
Jean-Philippe Lang Display users then groups on project memberships view (#4389)....	r3047	self.to_s.downcase <=> principal.to_s.downcase
		else
		# groups after users
		principal.class.name <=> self.class.name
		end
Jean-Philippe Lang Adds missing native eol properties....	r2781	end
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755
Jean-Philippe Lang Fixed: NOT NULL constraint error when adding a group (#4632)....	r3229	protected
Toshi MARUYAMA remove trailing white-spaces from app/models/principal.rb....	r6755
Jean-Philippe Lang Fixed: NOT NULL constraint error when adding a group (#4632)....	r3229	# Make sure we don't try to insert NULL values (see #4632)
		def set_default_empty_values
		self.login \|\|= ''
		self.hashed_password \|\|= ''
		self.firstname \|\|= ''
		self.lastname \|\|= ''
		self.mail \|\|= ''
		true
		end
Jean-Philippe Lang Adds missing native eol properties....	r2781	end