class SkypeSearch::DB
Public Class Methods
new(database)
click to toggle source
# File lib/skype_search/db.rb, line 5 def initialize database ActiveRecord::Base.establish_connection({ adapter: 'sqlite3', database: database }) end
Public Instance Methods
find_contacts()
click to toggle source
# File lib/skype_search/db.rb, line 12 def find_contacts Messages.select("distinct(dialog_partner)") end
find_conversation_by_id(conversation_id)
click to toggle source
# File lib/skype_search/db.rb, line 24 def find_conversation_by_id conversation_id Messages.where(:convo_id => conversation_id).order(:timestamp) end
find_conversations()
click to toggle source
# File lib/skype_search/db.rb, line 20 def find_conversations Conversations.all end
find_messages_between(user)
click to toggle source
# File lib/skype_search/db.rb, line 16 def find_messages_between user Messages.where(:dialog_partner => user).order(:timestamp) end
search_for(string)
click to toggle source
# File lib/skype_search/db.rb, line 28 def search_for string Messages.where('body_xml like ?', %{%#{string}%}).order(:timestamp) end