Add some extra indexes on issues

[rails.git] / app / models / issue.rb

diff --git a/app/models/issue.rb b/app/models/issue.rb
index d13f297a9a443e007540f9e8f15b1f38317d1ebb..dd068859a54dfb8bb8ded4abc4188605c9005a78 100644 (file)
--- a/app/models/issue.rb
+++ b/app/models/issue.rb
@@ -6,7 +6,7 @@
 #  reportable_type  :string           not null
 #  reportable_id    :integer          not null
 #  reported_user_id :integer
 #  reportable_type  :string           not null
 #  reportable_id    :integer          not null
 #  reported_user_id :integer

-#  status           :integer
+#  status           :enum             default("open"), not null

 #  assigned_role    :enum             not null
 #  resolved_at      :datetime
 #  resolved_by      :integer
 #  assigned_role    :enum             not null
 #  resolved_at      :datetime
 #  resolved_by      :integer


@@ -17,19 +17,23 @@
 #
 # Indexes
 #
 #
 # Indexes
 #

-#  index_issues_on_reportable_id_and_reportable_type  (reportable_id,reportable_type)
+#  index_issues_on_assigned_role                      (assigned_role)
+#  index_issues_on_reportable_type_and_reportable_id  (reportable_type,reportable_id)

 #  index_issues_on_reported_user_id                   (reported_user_id)
 #  index_issues_on_reported_user_id                   (reported_user_id)

+#  index_issues_on_status                             (status)

 #  index_issues_on_updated_by                         (updated_by)
 #
 # Foreign Keys
 #
 #  index_issues_on_updated_by                         (updated_by)
 #
 # Foreign Keys
 #

-#  issues_reported_user_id_fkey  (reported_user_id => users.id) ON DELETE => cascade
-#  issues_updated_by_fkey        (updated_by => users.id) ON DELETE => cascade
+#  issues_reported_user_id_fkey  (reported_user_id => users.id)
+#  issues_resolved_by_fkey       (resolved_by => users.id)
+#  issues_updated_by_fkey        (updated_by => users.id)

 #
 
 class Issue < ActiveRecord::Base
   belongs_to :reportable, :polymorphic => true
   belongs_to :reported_user, :class_name => "User", :foreign_key => :reported_user_id
 #
 
 class Issue < ActiveRecord::Base
   belongs_to :reportable, :polymorphic => true
   belongs_to :reported_user, :class_name => "User", :foreign_key => :reported_user_id

+  belongs_to :user_resolved, :class_name => "User", :foreign_key => :resolved_by

   belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
 
   has_many :reports, :dependent => :destroy
   belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
 
   has_many :reports, :dependent => :destroy


@@ -43,9 +47,6 @@ class Issue < ActiveRecord::Base
   before_validation :set_default_assigned_role
   before_validation :set_reported_user
 
   before_validation :set_default_assigned_role
   before_validation :set_reported_user
 

-  # Check if more statuses are needed
-  enum :status => %w[open ignored resolved]
-

   scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
 
   def read_reports
   scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
 
   def read_reports


@@ -93,7 +94,11 @@ class Issue < ActiveRecord::Base
   end
 
   def set_default_assigned_role
   end
 
   def set_default_assigned_role

-    role = %w[Note].include?(reportable.class.name) ? "moderator" : "administrator"
-    self.assigned_role = role if assigned_role.blank?
+    if assigned_role.blank?
+      self.assigned_role = case reportable
+                           when Note then "moderator"
+                           else "administrator"
+                           end
+    end

   end
 end
   end
 end