X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/b8b9c3d1e9e412178426e9ba1b612e14e09f2320..9a1ba12c81f7c79c362e36f14ed7955f5765e833:/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