scrape_slack.py

#!/usr/bin/env python3.6
# -*- coding: utf-8 -*-
import argparse
import cortx_community as cc
import datetime
import json
import urllib
import os
import sys
import slack  # https://pypi.org/project/slackclient/

from time import sleep
from pprint import pprint

# import requests

# https://python-slackclient.readthedocs.io/en/latest/basic_usage.html
# https://api.slack.com/methods/users.getPresence is a member active

MESSAGES_PER_PAGE = 200
MAX_MESSAGES = 1000
GLOBAL='GLOBAL'

channel_repo_map = {
  'general'                    : 'cortx',
  'random'                     : 'cortx',
  'devops'                     : 'cortx-re', # this should change to 'cortx-re' when it becomes public
  'github-cortx'               : 'cortx',
  'se'                         : 'cortx',
  'tech-marketing-engineering' : 'cortx',
  'cortx-pm'                   : 'cortx',
  'cortx-get-started'          : 'cortx',
  'feedback'                   : 'cortx',
  'cortx-dps'                  : 'cortx-motr',
  'cortx-rgw'                  : 'cortx',
  'cortx-sspl'                 : 'cortx-monitor',
  'ops-and-implementation'     : 'cortx', # change to cortx-re when it becomes public
  'cortx-provisioner'          : 'cortx-prvsnr',
  'cortx-s3'                   : 'cortx-s3server',
  'cortx-csm'                  : 'cortx-management-portal',
  'announcements'              : 'cortx',
  'cortx-virtual-machines'     : 'cortx', # change to cortx-re when it becomes public
  'cortx-dashboard'            : 'cortx-management-portal',
  'cortx-motr-client'          : 'cortx-motr', # might change this to m0client-sample-apps
  'cortx-community-triage'     : 'cortx',
  'hackathon-general'          : 'cortx',
  'hackathon-announcements'    : 'cortx',
  'hackathon-support-and-mentorship'    : 'cortx',
}

# make a helper function to consolidate all calls to the api 
def call_api(client,method,data):
  try:
    response = client.api_call(api_method=method,data=data)
    sleep(1.1)
    if not response['ok']:
      print("WTF: call to %s failed" % method)
      assert response['ok']
      return None
    else:
      return response
  except urllib.error.URLError as e:
    print("WTF: call to %s failed: " % method, e)
    sys.exit(0)

# pass an optional limit to only get a few channels; useful for fast development
def get_channels(client,limit=None):
  channels={}
  print("Trying to get channels")
  print('curl -s -H "Authorization: Bearer $SLACK_OATH" https://slack.com/api/conversations.list | python -m json.tool')  # this works but the call here is not...
  # here is the old way which has stopped working
  #response = call_api(client=client,method="conversations.list",data={'types' : 'public_channel', 'exclude_archived' : 'true'})

  # instead try to call it directly . . . same error
  response = client.conversations_list(types="public_channel",exclude_archived=1)
  print("Response is ", response)
  for c in response.data['channels']:
    print("Got channel %s" % c['name'])
    channels[c['id']] = c['name']
    if limit and len(channels) >= limit:
      break 
  return channels

def join_channels(client,channels):
  for c in channels.keys():
    response = call_api(client=client,method="conversations.join",data={'channel' : c})
    if response.status_code != 200:
      print("Couldn't join channel %s: %d" % (c, response.status_code))

def get_member_count(client,channels):
  members={}
  global_count=0
  for cid,cname in channels.items():
    response = call_api(client=client,method="conversations.info",data={'channel' : cid, 'include_num_members' : 'true'})
    num_members = response.data['channel']['num_members']
    print("%s has %d members" % (cname,num_members))
    members[cname]=num_members
    global_count=max(global_count,num_members)
  members[GLOBAL]=global_count
  return members

    
# note that when our members exceeds 1000, we will have to start making multiple api calls to get the full list
# can borrow the code from get_conversations
def get_members(client,all_people,slack_people):
  members=set()
  active_members=set()
  request = call_api(client=client,method="users.list",data=None)
  for m in request['members']:
    # get presence    
    response = call_api(client=client,method="users.getPresence",data={'user' : m['id']})
    presence=response.data['presence']

    # get profile
    glogin=None
    if slack_people.find_person(m['id']):
      #print("Person %s is already in our slack pickle" % m['name']) # overly verbose
      glogin=slack_people.get_github(m['id'])
    else:
      response = call_api(client=client,method="users.profile.get",data={'user' : m['id']})
      try:
        email = response.data['profile']['email']
        real_name = response.data['profile']['real_name']
        found = all_people.find_person(email)
        if found:
          glogin = found.get_login()
        else:
          glogin = "GID_UNK_%s" % m['name']
          all_people.add_person(login=glogin,company=None,email=email,linkedin=None,org_name=None)
        print("Person %s [%s] (%s, %s) %s already in our people pickle" % (real_name,presence,m['name'],email, 'is' if found else 'is not'),found)
        slack_people.add_person(slack_id=m['id'], github=glogin, email=email, name=m['name'])
        all_people.add_note(glogin,{'slack_id' : m['id']})
      except KeyError:
        print("WTF: couldn't get meaningful info for profile of %s" % m['name'])

    if glogin:
      members.add(glogin)
      if presence == 'active':
        active_members.add(glogin)
  slack_people.persist()
  all_people.persist()
  return (members,active_members)

def get_channel_conversations(client,channel,cname):
    # get first page
    page = 1
    messages=[]
    print("Getting conversations for %s" % cname)
    while True:
      cursor=None
      if page > 1:
        cursor = response['response_metadata']['next_cursor']
      response = call_api(client=client,method='conversations.history',data={'channel' : channel, 'limit' : MESSAGES_PER_PAGE, 'cursor' : cursor})
      messages += response['messages']
      page += 1

      if len(messages) >= MAX_MESSAGES or not response['has_more']:
        break

    return messages

def add_activity(glogin,mdate,cname,author_activity):
  key="slack_comment.%s.%s.%s" % (cname,glogin,mdate)
  try:
    (login,url,created_at) = author_activity.get_activity(key)
  except KeyError:
    login = glogin 
    url = "slack_%s" % cname 
    created_at = mdate 
    author_activity.add_activity(key,login,url,created_at)

# conversation also has 'ts' value so we should be able to get only people talking in the last week
def get_conversations(client,channels,slack_people,author_activity,stats):
  warnings=set()
  week_ago = datetime.date.today() - datetime.timedelta(days=7)
  all_talkers_alltime=set()
  talkers_alltime={}
  all_talkers_weekly=set()
  talkers_weekly={}
  for cid,cname in channels.items():
    talkers_alltime[cname]=set()
    talkers_weekly[cname]=set()
    conversations = get_channel_conversations(client,cid,cname)
    print("Channel %s has %d conversations" % (cname,len(conversations)))
    stats[cname]['slack_conversation_count'] = len(conversations)
    for c in conversations:
      try:
        glogin=slack_people.get_github(c['user'])
        talkers_alltime[cname].add(glogin)
        all_talkers_alltime.add(glogin)
        mdate=datetime.datetime.fromtimestamp(int(float(c['ts'])))
        if mdate.date() >= week_ago:
          talkers_weekly[cname].add(glogin)
          all_talkers_weekly.add(glogin)
        add_activity(glogin,mdate,cname,author_activity)
      except KeyError:
        pass
      except TypeError:
        if c['user'] not in warnings:
          print("WTF, user %s not in slack people" % c['user'])
          warnings.add(c['user'])
  talkers_alltime[GLOBAL] = all_talkers_alltime
  talkers_weekly[GLOBAL] = all_talkers_weekly
  author_activity.persist()
  return (talkers_alltime,talkers_weekly)

def get_client():
  client = slack.WebClient(token=os.environ['SLACK_OATH'],timeout=30)
  print(client)
  return client

def merge_stat(slack_stats,ps,repo):
  (existing_stats,latest) = ps.get_latest(repo)
  print(repo,existing_stats.keys(),slack_stats.keys())
  for key,value in slack_stats.items():
    print("Need to merge %s into %s on %s" % (key,repo,latest))
    existing_value = ps.get_values(repo,key,[latest])[0]
    if existing_value:
      if isinstance(existing_value,int) and isinstance(value,int):
        print("Key %s needs to merge in %s using max" % (key,repo))
        new_value=max(existing_value,value) 
      else:
        if isinstance(existing_value,list):
          print("WTF: How did a list get into %s:%s?" % (repo,key))
          existing_value=set(existing_value)
        assert isinstance(existing_value,set) and isinstance(value,set), "Expecting sets for %s" % key
        print("Key %s needs to merge in %s using union" % (key,repo))
        new_value=value|existing_value
    else:
      new_value=value
    ps.add_stat(latest,repo,key,value)

def merge_stats(slack_stats):
  ps=cc.PersistentStats()
  repos=ps.get_repos()
  for channel in slack_stats.keys():
    try:
      repo = channel_repo_map[channel] 
    except KeyError:
      repo = channel
    assert repo in repos, "Do not have a repo into which to merge %s" % channel
    print("Can %s merge channel %s into corresponding repo" % ( '' if repo in repos else 'not', channel))
    merge_stat(slack_stats[channel],ps,repo)
  ps.persist()  # probably unnecessary since ps.add_stat does an internal persist
  return ps 

# a function that returns a set of domains by pulling them out of emails
def get_domains(people,slack_people):
  domains=set()
  for p in people:
    sid=slack_people.find_login(p)
    email=slack_people.get_email(sid)
    domain=email.split('@')[1]
    if 'seagate' not in domain.lower():
      domains.add(domain)
  return domains
  

# takes the stats structure after it has been scraped and after domains has been added and splits out external counts 
def add_external(stats):
  slack_people = cc.SlackCommunity()
  people       = cc.CortxCommunity()
  new_stats = {}
  # get al the domains
  for cname,cstats in stats.items():
    new_stats[cname] = {}
    for k,v in cstats.items():
      if isinstance(v,set) and 'domains' not in k and 'Type' not in k:
        for p in v:
          try:
            Type = 'Unknown' if people.get_type(p)==None else people.get_type(p)
            new_key=('%s_Type_%s' % (k,Type)).replace(' ','_')
            #print("%s type %s -> %s" % (p,Type,new_key))
            if new_key not in new_stats[cname]:
              new_stats[cname][new_key] = set()
            new_stats[cname][new_key].add(p)
          except KeyError:
            print("WTF: couldn't find github for %s" % p) # this shouldn't happen.

  # now merge them into the stats structure
  for cname in stats.keys():
    stats[cname].update(new_stats[cname])
  return stats


# takes the stats structure after it has been scraped and pulls all the emails and figures out the set of email domains
def add_domains(stats):
  slack_people = cc.SlackCommunity()
  new_stats = {}
  # get al the domains
  for cname,cstats in stats.items():
    new_stats[cname] = {}
    for k,v in cstats.items():
      if isinstance(v,set) and 'domains' not in k:
        new_key='%s_domains' % k
        domains=get_domains(v,slack_people)
        new_stats[cname][new_key]=domains
  # now merge them into the stats structure
  for cname in stats.keys():
    stats[cname].update(new_stats[cname])
  return stats


# create a stats structure similar to what is produced in scrape_metrics.py
def get_stats():

  stats={}

  # load up our people pickle
  author_activity = cc.CortxActivity()     
  all_people = cc.CortxCommunity()
  slack_people = cc.SlackCommunity()

  # init web client
  client = get_client()

  print("Getting channels")
  channels=get_channels(client,limit=None)
  for cname in channels.values():
    stats[cname] = {}
  stats[GLOBAL] = {}
  print(stats)

  print("Joining channels")
  join_channels(client,channels)

  print("Getting member lists")
  (all_members,active_members)=get_members(client,all_people,slack_people)
  print("%d members, %d active members" % (len(all_members),len(active_members)))
  stats[GLOBAL]['slack_members'] = all_members
  stats[GLOBAL]['slack_active_members'] = active_members

  print("Getting talkers lists")
  (all_talkers,weekly_talkers) = get_conversations(client,channels,slack_people,author_activity,stats)
  for cname in channels.values():
    stats[cname]['slack_participants'] = all_talkers[cname]
    stats[cname]['slack_weekly_participants'] = weekly_talkers[cname]
  stats[GLOBAL]['slack_participants'] = all_talkers[GLOBAL]
  stats[GLOBAL]['slack_weekly_participants'] = weekly_talkers[GLOBAL]
  print(stats)

  print("Getting member counts")
  member_counts = get_member_count(client,channels)
  print(member_counts)
  for cname in channels.values():
    stats[cname]['slack_member_count'] = member_counts[cname]
  stats[GLOBAL]['slack_member_count'] = member_counts[GLOBAL]

  return stats

def update_global_conversation_count(stats):
  gcc=0
  key='slack_conversation_count'
  for cname,cstats in stats.items():
    if cname != GLOBAL:
      gcc+=cstats[key]
  stats[GLOBAL][key]=gcc
  return stats

def main():

  stats = get_stats()
  stats=update_global_conversation_count(stats)
  stats=add_domains(stats)
  stats=add_external(stats)
  ps=merge_stats(stats)


if __name__ == '__main__':
  main()