1 # == Schema Information
3 # Table name: diary_comments
5 # id :bigint(8) not null, primary key
6 # diary_entry_id :bigint(8) not null
7 # user_id :bigint(8) not null
9 # created_at :datetime not null
10 # updated_at :datetime not null
11 # visible :boolean default(TRUE), not null
12 # body_format :enum default("markdown"), not null
16 # diary_comment_user_id_created_at_index (user_id,created_at)
17 # diary_comments_entry_id_idx (diary_entry_id,id) UNIQUE
21 # diary_comments_diary_entry_id_fkey (diary_entry_id => diary_entries.id)
22 # diary_comments_user_id_fkey (user_id => users.id)
25 class DiaryComment < ActiveRecord::Base
27 belongs_to :diary_entry
29 scope :visible, -> { where(:visible => true) }
31 validates :body, :presence => true, :invalid_chars => true
32 validates :diary_entry, :user, :associated => true
34 after_save :spam_check
37 RichText.new(self[:body_format], self[:body])
42 md5 << diary_entry_id.to_s
44 md5 << created_at.xmlschema