Extract chat history from skype logs

gistfile1.rb

corpus = Hash.new {|h,k| h[k]=[]}
SQLite3::Database.new( "/Users/username/Library/Application Support/Skype/skypename/main.db", :readonly=>true ) do |db|
  db.execute("select timestamp,author, body_xml from messages") do  |row|
    ts, author, body   = row
    corpus[author]<<(body) if body
  end
end

corpus.each do |k,v|
  File.open("corpus_#{k}.txt", 'w') do |f|
    v.each{|k|f.puts(k)}
  end
end