1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
# == Schema Information
#
# Table name: comments
#
# id :integer not null, primary key
# user_id :integer not null
# comment_type :string(255) default("internal_error"), not null
# info_request_id :integer
# body :text not null
# visible :boolean default(TRUE), not null
# created_at :datetime not null
# updated_at :datetime not null
# locale :text default(""), not null
#
# models/comments.rb:
# A comment by a user upon something.
#
# Copyright (c) 2008 UK Citizens Online Democracy. All rights reserved.
# Email: hello@mysociety.org; WWW: http://www.mysociety.org/
class Comment < ActiveRecord::Base
strip_attributes!
belongs_to :user
belongs_to :info_request
has_many :info_request_events # in practice only ever has one
#validates_presence_of :user # breaks during construction of new ones :(
validates_inclusion_of :comment_type, :in => [ 'request' ]
validate :check_body_has_content,
:check_body_uses_mixed_capitals
after_save :event_xapian_update
# When posting a new comment, use this to check user hasn't double
# submitted.
def self.find_existing(info_request_id, body)
# TODO: can add other databases here which have regexp_replace
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
# Exclude spaces from the body comparison using regexp_replace
regex_replace_sql = "regexp_replace(body, '[[:space:]]', '', 'g') = regexp_replace(?, '[[:space:]]', '', 'g')"
Comment.where(["info_request_id = ? AND #{ regex_replace_sql }", info_request_id, body ]).first
else
# For other databases (e.g. SQLite) not the end of the world being
# space-sensitive for this check
Comment.where(:info_request_id => info_request_id, :body => body).first
end
end
def body
ret = read_attribute(:body)
return ret if ret.nil?
ret = ret.strip
# remove excess linebreaks that unnecessarily space it out
ret = ret.gsub(/(?:\n\s*){2,}/, "\n\n")
ret
end
def raw_body
read_attribute(:body)
end
# So when takes changes it updates, or when made invisble it vanishes
def event_xapian_update
info_request_events.each { |event| event.xapian_mark_needs_index }
end
# Return body for display as HTML
def get_body_for_html_display
text = body.strip
text = CGI.escapeHTML(text)
text = MySociety::Format.make_clickable(text, :contract => 1)
text = text.gsub(/\n/, '<br>')
text.html_safe
end
def for_admin_column
self.class.content_columns.each do |column|
yield(column.human_name, send(column.name), column.type.to_s, column.name)
end
end
private
def check_body_has_content
if body.empty? || body =~ /^\s+$/
errors.add(:body, _("Please enter your annotation"))
end
end
def check_body_uses_mixed_capitals
unless MySociety::Validate.uses_mixed_capitals(body)
msg = _('Please write your annotation using a mixture of capital and ' \
'lower case letters. This makes it easier for others to read.')
errors.add(:body, msg)
end
end
end
|
