Script to download Slack DMs

get-slack-dms.rb

require 'slack-ruby-client'
require 'pg'

Slack.configure do |config|
  config.token = File.read(File.expand_path('~/.slack/token')).strip
end

client = Slack::Web::Client.new

me = client.auth_test
puts "retrieving DMs for #{me.user} (#{me.user_id})"

print "listing users: "
users = {}
client.users_list do |page|
  page.members.each do |user|
    users[user.id] = user.name
  end
end
puts users.size

print "finding DM conversations: "
ims = {}
client.conversations_list(types: 'im') do |page|
  page.channels.each do |channel|
    ims[channel.user] = channel.id
  end
end
puts ims.size

# CREATE TABLE messages (username TEXT, from_me BOOLEAN, timestamp TIMESTAMP, text TEXT);
# CREATE INDEX ON messages(username);
# CREATE INDEX ON messages(timestamp);
db = PG::Connection.open(:dbname => 'slack-dms')
ims.each do |user_id, channel_id|
  username = users[user_id]
  print "#{username}: "
  n = 0
  client.conversations_history(channel: channel_id) do |page|
    page.messages.each do |message|
      next unless message.type == 'message'
      db.exec_params('INSERT INTO messages(username, from_me, timestamp, text) VALUES ($1, $2, $3, $4)', [username, message.user == me.user_id, Time.at(message.ts.to_f), message.text])
      n += 1
    end
  end
  puts "#{n} messages"
end