##// END OF EJS Templates
jro_apps » redmine
RSS
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:

r8870:f1b26008b897
r9024:999a4ba30d7b
Show More
queries_helper.rb
131 lines | 4.6 KiB | text/x-ruby | RubyLexer
/ app / helpers / queries_helper.rb
History | Source | Raw |Copy content |Copy permalink
Jean-Philippe Lang
Added encoding comment to helpers (#9792)....
 r8090 # encoding: utf-8
#
Jean-Philippe Lang
Shortens filter param names....
 r5159 # Redmine - project management software
# Copyright (C) 2006-2011 Jean-Philippe Lang
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 #
# 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/helpers/queries_helper.rb....
 r6767 #
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 # 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/helpers/queries_helper.rb....
 r6767 #
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 # 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.
Jean-Philippe Lang
"queries" branch merged...
 r92
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 module QueriesHelper
Toshi MARUYAMA
remove trailing white-spaces from app/helpers/queries_helper.rb....
 r6767
Jean-Philippe Lang
"queries" branch merged...
 r92 def operators_for_select(filter_type)
Query.operators_by_filter_type[filter_type].collect {|o| [l(Query.operators[o]), o]}
end
Toshi MARUYAMA
remove trailing white-spaces from app/helpers/queries_helper.rb....
 r6767
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 def column_header(column)
Jean-Philippe Lang
Validates sort_key and sort_order params (#2378)....
 r2169 column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,
Toshi MARUYAMA
remove trailing white-spaces from app/helpers/queries_helper.rb....
 r6767 :default_order => column.default_order) :
Jean-Philippe Lang
Additional escaping....
 r6207 content_tag('th', h(column.caption))
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 end
Toshi MARUYAMA
remove trailing white-spaces from app/helpers/queries_helper.rb....
 r6767
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 def column_content(column, issue)
Jean-Philippe Lang
Fixed: "None" category issue count is empty while grouping by category (#4308)....
 r2998 value = column.value(issue)
Jean-Philippe Lang
Adds support for multiselect custom fields (#1189)....
 r8601 if value.is_a?(Array)
Jean-Philippe Lang
Fixed escaping issue with Rails 3.1....
 r8870 value.collect {|v| column_value(column, issue, v)}.compact.sort.join(', ').html_safe
Jean-Philippe Lang
Adds support for multiselect custom fields (#1189)....
 r8601 else
column_value(column, issue, value)
end
end
def column_value(column, issue, value)
Jean-Philippe Lang
Fixed: "None" category issue count is empty while grouping by category (#4308)....
 r2998 case value.class.name
when 'String'
if column.name == :subject
link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)
else
h(value)
end
when 'Time'
format_time(value)
when 'Date'
format_date(value)
when 'Fixnum', 'Float'
if column.name == :done_ratio
progress_bar(value, :width => '80px')
Jean-Philippe Lang
Makes spent time column available on the issue list (#971)....
 r7953 elsif column.name == :spent_hours
sprintf "%.2f", value
Jean-Philippe Lang
Roadmap: more accurate completion percentage calculation (done ratio of open issues is now taken into account)....
 r895 else
Toshi MARUYAMA
HTML escape at app/helpers/queries_helper.rb....
 r6233 h(value.to_s)
Jean-Philippe Lang
Custom fields can now be displayed as columns on the issue list....
 r876 end
Jean-Philippe Lang
Fixed: "None" category issue count is empty while grouping by category (#4308)....
 r2998 when 'User'
link_to_user value
when 'Project'
Jean-Baptiste Barth
Refactor: added link_to_project helper to handle links to projects...
 r3810 link_to_project value
Jean-Philippe Lang
Fixed: "None" category issue count is empty while grouping by category (#4308)....
 r2998 when 'Version'
link_to(h(value), :controller => 'versions', :action => 'show', :id => value)
when 'TrueClass'
l(:general_text_Yes)
when 'FalseClass'
l(:general_text_No)
Jean-Philippe Lang
Issue list improvements for subtasking (#5196):...
 r3504 when 'Issue'
link_to_issue(value, :subject => false)
Jean-Philippe Lang
Fixed: "None" category issue count is empty while grouping by category (#4308)....
 r2998 else
h(value)
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 end
end
Eric Davis
Refactor: move method to helper....
 r3577
# Retrieve query from session or build a new query
def retrieve_query
if !params[:query_id].blank?
cond = "project_id IS NULL"
cond << " OR project_id = #{@project.id}" if @project
@query = Query.find(params[:query_id], :conditions => cond)
Jean-Philippe Lang
Fixed: private queries should not be accessible to other users (#8729)....
 r6043 raise ::Unauthorized unless @query.visible?
Etienne Massip
Reverted removal of project assignment to query (#9108)....
 r7536 @query.project = @project
Eric Davis
Refactor: move method to helper....
 r3577 session[:query] = {:id => @query.id, :project_id => @query.project_id}
sort_clear
Etienne Massip
Refactor : convert queries to REST resources (also fixes #9108)....
 r7529 elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)
# Give it a name, required to be valid
@query = Query.new(:name => "_")
@query.project = @project
build_query_from_params
session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}
Eric Davis
Refactor: move method to helper....
 r3577 else
Etienne Massip
Refactor : convert queries to REST resources (also fixes #9108)....
 r7529 # retrieve from session
@query = Query.find_by_id(session[:query][:id]) if session[:query][:id]
Jean-Philippe Lang
Fixed that a cross-project custom query is not remembered inside project (#9738)....
 r7993 @query ||= Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
@query.project = @project
Etienne Massip
Refactor : convert queries to REST resources (also fixes #9108)....
 r7529 end
end
Etienne Massip
Reverted removal of project assignment to query (#9108)....
 r7536
Jean-Philippe Lang
Adds previous/next links to issue (#2850)....
 r8368 def retrieve_query_from_session
if session[:query]
Jean-Philippe Lang
Fixed previous/next links when navigating in a saved query....
 r8537 if session[:query][:id]
@query = Query.find_by_id(session[:query][:id])
return unless @query
else
@query = Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
end
Jean-Philippe Lang
Adds previous/next links to issue (#2850)....
 r8368 if session[:query].has_key?(:project_id)
@query.project_id = session[:query][:project_id]
else
@query.project = @project
end
@query
end
end
Etienne Massip
Refactor : convert queries to REST resources (also fixes #9108)....
 r7529 def build_query_from_params
if params[:fields] || params[:f]
@query.filters = {}
@query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v])
else
@query.available_filters.keys.each do |field|
@query.add_short_filter(field, params[field]) if params[field]
Eric Davis
Refactor: move method to helper....
 r3577 end
end
Etienne Massip
Refactor : convert queries to REST resources (also fixes #9108)....
 r7529 @query.group_by = params[:group_by] || (params[:query] && params[:query][:group_by])
@query.column_names = params[:c] || (params[:query] && params[:query][:column_names])
Eric Davis
Refactor: move method to helper....
 r3577 end
Jean-Philippe Lang
"queries" branch merged...
 r92 end