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