1 # == Schema Information
5 # id :bigint(8) not null, primary key
6 # from_user_id :bigint(8) not null
7 # title :string not null
9 # sent_on :datetime not null
10 # message_read :boolean default(FALSE), not null
11 # to_user_id :bigint(8) not null
12 # to_user_visible :boolean default(TRUE), not null
13 # from_user_visible :boolean default(TRUE), not null
14 # body_format :enum default("markdown"), not null
18 # messages_from_user_id_idx (from_user_id)
19 # messages_to_user_id_idx (to_user_id)
23 # messages_from_user_id_fkey (from_user_id => users.id)
24 # messages_to_user_id_fkey (to_user_id => users.id)
27 class Message < ApplicationRecord
28 belongs_to :sender, :class_name => "User", :foreign_key => :from_user_id
29 belongs_to :recipient, :class_name => "User", :foreign_key => :to_user_id
31 validates :title, :presence => true, :utf8 => true, :length => 1..255
32 validates :body, :sent_on, :sender, :recipient, :presence => true
33 validates :title, :body, :characters => true
35 def self.from_mail(mail, from, to)
38 body = mail.text_part.decoded
40 body = HTMLEntities.new.decode(Sanitize.clean(mail.html_part.decoded))
42 elsif mail.text? && mail.sub_type == "html"
43 body = HTMLEntities.new.decode(Sanitize.clean(mail.decoded))
51 :sent_on => mail.date.new_offset(0),
52 :title => mail.subject.sub(/\[OpenStreetMap\] */, ""),
54 :body_format => "text"
59 RichText.new(self[:body_format], self[:body])
64 md5 << from_user_id.to_s
65 md5 << to_user_id.to_s
66 md5 << sent_on.xmlschema