Project

General

Profile

Feature #44363 ยป activity-n1-preload.patch

minsuk choi, 2026-08-21 06:52

View differences:

app/models/attachment.rb
"ON #{Version.table_name}.project_id = #{Project.table_name}.id " \
"OR ( #{Attachment.table_name}.container_type='Project' " \
"AND #{Attachment.table_name}.container_id = #{Project.table_name}.id )"
)
).
preload(:author, :container)
end
)
acts_as_activity_provider(
......
"AND #{Document.table_name}.id = #{Attachment.table_name}.container_id " \
"LEFT JOIN #{Project.table_name} " \
"ON #{Document.table_name}.project_id = #{Project.table_name}.id"
)
).
preload(:author, :container)
end
)
app/models/document.rb
:title => Proc.new {|o| "#{l(:label_document)}: #{o.title}"},
:author =>
Proc.new do |o|
o.attachments.reorder("#{Attachment.table_name}.created_on ASC").
first.try(:author)
o.attachments.min_by(&:created_on).try(:author)
end,
:url =>
Proc.new do |o|
{:controller => 'documents', :action => 'show', :id => o.id}
end
)
acts_as_activity_provider :scope => proc {preload(:project)}
acts_as_activity_provider :scope => proc {preload(:project, attachments: :author)}
validates_presence_of :project, :title, :category
validates_length_of :title, :maximum => 255
app/models/time_entry.rb
)
acts_as_activity_provider :timestamp => "#{table_name}.created_on",
:author_key => :user_id,
:scope => proc {joins(:project).preload(:project)}
:scope => proc {joins(:project).preload(:project, issue: [:tracker, :status])}
acts_as_webhookable
validates_presence_of :author_id, :user_id, :activity_id, :project_id, :hours, :spent_on
app/models/wiki_content_version.rb
"#{table_name}.id").
joins("LEFT JOIN #{WikiPage.table_name} ON #{WikiPage.table_name}.id = #{table_name}.page_id " \
"LEFT JOIN #{Wiki.table_name} ON #{Wiki.table_name}.id = #{WikiPage.table_name}.wiki_id " \
"LEFT JOIN #{Project.table_name} ON #{Project.table_name}.id = #{Wiki.table_name}.project_id")
"LEFT JOIN #{Project.table_name} ON #{Project.table_name}.id = #{Wiki.table_name}.project_id").
preload(:author, page: {wiki: :project})
end
)
after_destroy :page_update_after_destroy
    (1-1/1)