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