Rename some columns and indexes in the bug tables

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

diff --git a/app/models/map_bug.rb b/app/models/map_bug.rb
index 440b64b78b3bd96b1af85b5339e0e8668f157196..2ae110bf2fcc897c30f56f8dde60f60c5e9641be 100644 (file)
--- a/app/models/map_bug.rb
+++ b/app/models/map_bug.rb
@@ -1,33 +1,28 @@
 class MapBug < ActiveRecord::Base
   include GeoRecord
 
-  has_many :map_bug_comment, :foreign_key => :bug_id, :order => :date_created, :conditions => "visible = true and comment is not null"
+  has_many :comments, :class_name => "MapBugComment",
+                      :foreign_key => :bug_id,
+                      :order => :created_at,
+                      :conditions => "visible = true AND body IS NOT NULL"
 
   validates_presence_of :id, :on => :update
   validates_uniqueness_of :id
   validates_numericality_of :latitude, :only_integer => true
   validates_numericality_of :longitude, :only_integer => true
-  validates_presence_of :date_created
-  validates_presence_of :last_changed
-  validates_presence_of :date_closed if :status == "closed"
+  validates_presence_of :closed_at if :status == "closed"
   validates_inclusion_of :status, :in => ["open", "closed", "hidden"]
 
   def self.create_bug(lat, lon)
-    bug = MapBug.new(:lat => lat, :lon => lon)
+    bug = MapBug.new(:lat => lat, :lon => lon, :status => "open")
     raise OSM::APIBadUserInput.new("The node is outside this world") unless bug.in_world?
 
-    bug.date_created = Time.now.getutc
-    bug.last_changed = Time.now.getutc
-    bug.status = "open"
-
     return bug
   end
 
   def close_bug
     self.status = "closed"
-    close_time = Time.now.getutc
-    self.last_changed = close_time
-    self.date_closed = close_time
+    self.closed_at = Time.now.getutc
 
     self.save
   end
@@ -35,13 +30,13 @@ class MapBug < ActiveRecord::Base
   def flatten_comment(separator_char, upto_timestamp = :nil)
     resp = ""
     comment_no = 1
-    self.map_bug_comment.each do |comment|
-      next if upto_timestamp != :nil and comment.date_created > upto_timestamp
+    self.comments.each do |comment|
+      next if upto_timestamp != :nil and comment.created_at > upto_timestamp
       resp += (comment_no == 1 ? "" : separator_char)
-      resp += comment.comment if comment.comment
+      resp += comment.body if comment.body
       resp += " [ " 
-      resp += comment.commenter_name if comment.commenter_name
-      resp += " " + comment.date_created.to_s + " ]"
+      resp += comment.author_name if comment.author_name
+      resp += " " + comment.created_at.to_s + " ]"
       comment_no += 1
     end