class Skygrepe::Condition
Public Class Methods
new(keyword)
click to toggle source
# File lib/skygrepe.rb, line 81 def initialize(keyword) @keyword = keyword end
Public Instance Methods
count_sql()
click to toggle source
# File lib/skygrepe.rb, line 94 def count_sql sql = "SELECT count(*) FROM Messages" sql << " WHERE body_xml like '%#{@keyword}%'" sql << ';' end
grep_sql(limit, offset)
click to toggle source
# File lib/skygrepe.rb, line 85 def grep_sql(limit, offset) sql = "SELECT m.id, m.timestamp, c.displayname, m.author, substr(m.body_xml, 1, 50) FROM Messages as m inner join Conversations as c on m.convo_id = c.id" sql << " WHERE body_xml like '%#{@keyword}%'" sql << " ORDER BY m.timestamp" sql << " LIMIT #{limit} OFFSET #{offset}" sql << ';' end