X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/ab4f96261fe043ba704616e8b6f7cf77e79817bf..121ef82e2c8ad79bfc8dc06249e162c8a2f4e857:/app/models/note.rb diff --git a/app/models/note.rb b/app/models/note.rb index 2ec72a03a..6a83b6b01 100644 --- a/app/models/note.rb +++ b/app/models/note.rb @@ -16,10 +16,11 @@ # # Indexes # -# index_notes_on_description (to_tsvector('english'::regconfig, description)) USING gin -# notes_created_at_idx (created_at) -# notes_tile_status_idx (tile,status) -# notes_updated_at_idx (updated_at) +# index_notes_on_description (to_tsvector('english'::regconfig, description)) USING gin +# index_notes_on_user_id_and_created_at (user_id,created_at) WHERE (user_id IS NOT NULL) +# notes_created_at_idx (created_at) +# notes_tile_status_idx (tile,status) +# notes_updated_at_idx (updated_at) # # Foreign Keys # @@ -92,22 +93,9 @@ class Note < ApplicationRecord closed_at + DEFAULT_FRESHLY_CLOSED_LIMIT end - # Return the note's description, derived from the first comment + # Return the note's description def description - if user_ip.nil? && user_id.nil? - all_comments.first.body if all_comments.first&.event == "opened" - else - RichText.new("text", super) - end - end - - # Return the note's author object, derived from the first comment - def author - if user_ip.nil? && user_id.nil? - all_comments.first.author if all_comments.first&.event == "opened" - else - super - end + RichText.new("text", super) end private