Merge lp:~toykeeper/qakit/add-actions-report into lp:~thomir-deactivatedaccount/qakit/trunk

[Selene ToyKeeper]

Added a basic report of card actions each person did over the past two weeks.

Added a basic report of card actions each person did over the past two weeks.

=== modified file 'qakit/commands.py'
--- qakit/commands.py	2014-10-08 01:30:28 +0000
+++ qakit/commands.py	2014-10-08 04:53:08 +0000
@@ -31,8 +31,12 @@
         "backlog.")
     subparsers.add_parser("silo-stats", help="Show statistics around completed "
         "silo testing.")
+    subparsers.add_parser("silo-actions", help="Show statistics about overall "
+        "activity per person.")
     args = parser.parse_args()
     if args.command == 'silo-backlog':
         trello.silo_backlog()
     elif args.command == 'silo-stats':
         trello.silo_stats()
+    elif args.command == 'silo-actions':
+        trello.silo_actions()

=== modified file 'qakit/format.py'
--- qakit/format.py	2014-10-08 01:30:28 +0000
+++ qakit/format.py	2014-10-08 04:53:08 +0000
@@ -53,6 +53,53 @@
     print(tbl)
 
 
+def print_actions_table(actions):
+    raw_actions = actions
+    actions = []
+    #period = _get_one_week_ago()
+    period = _get_one_fortnight_ago()
+    for a in raw_actions:
+        if period.contains(a.when):
+            actions.append(a)
+
+    # populate 'fields' and 'people'
+    fields = ['Name']
+    people = {}
+    for a in actions:
+        if a.what not in fields:
+            fields.append(a.what)
+        if a.who not in people:
+            people[a.who] = {'updateCard':0, 'commentCard':0}
+        if a.what not in people[a.who]:
+            people[a.who][a.what] = 0
+        people[a.who][a.what] += 1
+    fields.sort()
+    # put these fields first
+    fields.remove('updateCard')
+    fields.insert(1, 'updateCard')
+    fields.remove('commentCard')
+    fields.insert(2, 'commentCard')
+
+    foo = [(-v['updateCard'],-v['commentCard'],k,v) for k,v in people.items()]
+    foo.sort()
+    people = [(x[-2],x[-1]) for x in foo]
+
+    tbl = prettytable.PrettyTable(fields)
+    tbl.align["Name"] = 'l'
+
+    for person, actions in people:
+        row = []
+        row.append(termcolor.colored(person, **_card_title_opts))
+        for f in fields[1:]:
+            amount = 0
+            if f in actions:
+                amount = actions[f]
+            row.append(termcolor.colored(str(amount), **_card_lane_opts))
+        tbl.add_row(row)
+
+    print(tbl)
+
+
 def print_last_day_stats(cards):
     print_title("Last 24 Hours:")
     period = _get_24_hours_ago()

=== modified file 'qakit/trello.py'
--- qakit/trello.py	2014-10-08 01:30:28 +0000
+++ qakit/trello.py	2014-10-08 04:53:08 +0000
@@ -55,6 +55,17 @@
         self.name = name
 
 
+class CardAction(object):
+    who = u''
+    what = u''
+    when = u''
+
+    def __init__(self, who, what, when):
+        self.who = who
+        self.what = what
+        self.when = when
+
+
 def silo_backlog():
     api = trello.TrelloApi(TRELLO_API_KEY)
     open_cards = _get_open_cards(lambda: _get_all_silo_cards(api))
@@ -69,6 +80,14 @@
     format.print_last_week_stats(cards)
     format.print_meta_stats(cards)
 
+
+def silo_actions():
+    api = trello.TrelloApi(TRELLO_API_KEY)
+    actions = _get_all_actions(api)
+    format.print_title("Activity Summary:")
+    format.print_actions_table(actions)
+
+
 def test():
     api = trello.TrelloApi(TRELLO_API_KEY)
 
@@ -102,6 +121,34 @@
         yield c
 
 
+def _get_all_actions(trello_api):
+    actions = []
+    raw_actions = trello_api.boards.get_action(
+        TRELLO_SILO_TEST_BOARD,
+        limit=1000
+    )
+    for action in raw_actions:
+        list_before = action[u'data'].get('listBefore', None)
+        list_after = action[u'data'].get('listAfter', None)
+        user_name = action[u'memberCreator'][u'fullName']
+        time_string = action[u'date']
+        time_stamp = dateutil.parser.parse(time_string)
+
+        act = action[u'type']
+
+        # skip a few action types
+        if act in ('createCard','deleteCard','removeMemberFromCard',
+                'updateBoard',):
+            continue
+        # ignore updates which don't traverse lanes
+        # (not entirely sure what all these actions are though)
+        if act == 'updateCard' and (None in (list_before, list_after)):
+            continue
+
+        a = CardAction(user_name, act, time_stamp)
+        yield a
+
+
 def _get_all_silo_cards(trello_api):
     """Get a list of cards that are in the 'awaiting QA signoff' lane.