Changeset 2581

Timestamp:

08/20/07 12:25:18 (1 year ago)

Author:

khundeen

Message:

NEW: Ticket#1601
- Add More project statistics (backlog metrics, changeset stats)

Files:

• tracmetrixplugin/0.11/tracmetrixplugin/mdashboard.py (modified) (4 diffs)
• tracmetrixplugin/0.11/tracmetrixplugin/model.py (modified) (10 diffs)
• tracmetrixplugin/0.11/tracmetrixplugin/templates/mdashboard.html (modified) (2 diffs)
• tracmetrixplugin/0.11/tracmetrixplugin/templates/pdashboard.html (modified) (2 diffs)
• tracmetrixplugin/0.11/tracmetrixplugin/web_ui.py (modified) (6 diffs)

tracmetrixplugin/0.11/tracmetrixplugin/mdashboard.py

@@ -117 +117 @@
-    event_history = cursor.fetchall()
-    
-
+#
-    
-    # TODO The tricky thing about this is that we have to deterimine 5 different type of ticket.
@@ -287 +287 @@
-    
-    matplotlib.use('Agg')
-
-
+#
+figsize = (6,4)
-    ax = fig.add_subplot(111) # Create supplot with key 111       
+    ax.cla()
-    ax.plot(numdates, tkt_cummulative_table['Enter'], 'b-')
-    ax.plot(numdates, tkt_cummulative_table['Leave'], 'r-') 
@@ -298 +299 @@
-    ax.fmt_xdata = DateFormatter('%Y-%m-%d %H:%M:%S')
-    labels = ax.get_xticklabels()
-8
+6
-    
-    xlabel('Dates (day)')
-    ylabel('Counts (times)')
-    title('Cummulative flow chart for ticket status history')
-upper lef
+bes
-    
-    filename = "cummulativeflow_%s" % (milestone.name,)
@@ -487 +488 @@
-            tkt_history = collect_tickets_status_history(self.env, db, everytickets, milestone)
-            
+            if tkt_history != {}:
-                            
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-        

tracmetrixplugin/0.11/tracmetrixplugin/model.py

@@ -1 +1 @@
-import sys
+import os
+
-from datetime import timedelta, datetime
-from trac.core import *
-from trac.ticket import Ticket, model
-
+, to_timestamp, to_datetime
-from trac.ticket.roadmap import ITicketGroupStatsProvider, TicketGroupStats
+
+from bisect import bisect
+import matplotlib
+from pylab import *
+from matplotlib.dates import DayLocator, HourLocator, DateFormatter, drange
-
-
@@ -53 +60 @@
-        return stat
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-        
-        # ticket_ids is a list of ticket id as number.
@@ -79 +124 @@
-                    type_count.append({'name':type.name,'count':count})
-
+        else:
+            type_count = []
-        
-        stat = TicketGroupStats('ticket type', 'ticket')
+        
-        
-        for type in type_count:
@@ -96 +144 @@
-        return stat
-
+class TicketTypeGroupStatsProvider(Component):
+    implements(ITicketGroupStatsProvider)
+
+    def get_ticket_group_stats(self, ticket_ids):
+        
+        # ticket_ids is a list of ticket id as number.
+        total_cnt = len(ticket_ids)
+        if total_cnt:
+            str_ids = [str(x) for x in sorted(ticket_ids)] # create list of ticket id as string
+            cursor = self.env.get_db_cnx().cursor()  # get database connection    
+            
+            type_count = [] # list of dictionary with key name and count
+            
+            for type in model.Type.select(self.env):
+            
+                count = cursor.execute("SELECT count(1) FROM ticket "
+                                        "WHERE type = '%s' AND id IN "
+                                        "(%s)" % (type.name, ",".join(str_ids))) # execute query and get cursor obj.
+                count = 0
+                for cnt, in cursor:
+                    count = cnt
+
+                if count > 0:
+                    type_count.append({'name':type.name,'count':count})
+
+        else:
+            type_count = []
+        
+        stat = TicketGroupStats('ticket type', 'ticket')
+        
+        
+        for type in type_count:
+                
+            if type['name'] != 'defect': # default ticket type 'defect'
+        
+                stat.add_interval(type['name'], type['count'],
+                                  {'type': type['name']}, 'value', True)
+            
+            else:
+                stat.add_interval(type['name'], type['count'],
+                                  {'type': type['name']}, 'waste', False)
+                          
+        stat.refresh_calcs()
+        return stat
+
-class TicketGroupMetrics(object):
-    
@@ -151 +244 @@
-    def get_tickets_created_during(self, start_date, end_date):
-        
+        end_date = end_date.replace(hour=23, minute=59, second=59)
+        
-        tkt_ids = []
-        
@@ -161 +256 @@
-    def get_remaning_opened_ticket_on(self, end_date):
-     
+        end_date = end_date.replace(hour=23, minute=59, second=59)
+     
-        tkt_ids = []
-        
@@ -169 +266 @@
-            
-                if ticket.values['status'] == 'closed':        
-                    
-                    
-                    was_opened = True        
@@ -189 +285 @@
-                # Assume that ticket that is not closed are opened
-                else:
-modifi
-hang
+creat
+reat
-                        tkt_ids.append(ticket.id)
-
-
-
-
+
-        return tkt_ids
-
-
+
-    
-    def get_tickets_closed_during(self, start_date, end_date):
+        
+        end_date = end_date.replace(hour=23, minute=59, second=59)
-        
-        tkt_ids = []
@@ -228 +322 @@
-                closed_tickets,
-                float(len(closed_tickets)) * 100 / float(len(opened_tickets)))
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-class TicketMetrics(object):
-    
@@ -349 +578 @@
-            stdev = (sdsq / (len(self.sequence) - 1 or 1)) ** .5
-            return stdev
+        
+class ChangesetsStats:
+    
+    def __init__(self, env, start_date=None, stop_date=None):
+    
+        self.env = env
+        
+        self.start_date = start_date
+        self.stop_date = stop_date
+        self.first_rev = self.last_rev = None
+        
+        if start_date != None and stop_date !=None:
+            self.set_date_range(start_date, stop_date)
+    
+    def set_date_range(self, start_date, stop_date): 
+
+        cursor = self.env.get_db_cnx().cursor()
+        cursor.execute("SELECT rev, time, author FROM revision "
+                       "WHERE time >= %s AND time < %s ORDER BY time",
+                       (to_timestamp(start_date), to_timestamp(stop_date)))
+        
+        self.changesets = []
+        for rev, time, author in cursor:
+            self.changesets.append((rev,time,author))
+        
+        self.start_date = start_date
+        self.stop_date = stop_date    
+        self.first_rev = self.changesets[0][0]
+        self.last_rev = self.changesets[-1][0]
+    
+    def get_commit_by_date(self):
+        
+        numdates = drange(self.start_date, self.stop_date, timedelta(days=1))
+
+        numcommits = [0 for i in numdates]
+        
+        for rev, time, author in self.changesets:
+            
+            date = to_datetime(time, utc).date()
+            #get index of day in the dates list
+            index = bisect(numdates, date2num(date)) - 1     
+            
+            numcommits[index] += 1
+        
+        return (numdates, numcommits)
+    
+    
+    def get_commit_by_date_chart(self, commit_history):
+        
+        numdates = commit_history[0]
+        numcommits = commit_history[1]
+        
+        matplotlib.use('Agg')
+        #cla()
+        fig = figure(figsize = (6,4))
+        ax = fig.add_subplot(111) # Create supplot with key 111       
+        line1 = ax.bar(numdates, numcommits, 0.5, color='#9966ff') 
+        ax.set_xlim( numdates[0], numdates[-1] )
+        ax.xaxis.set_major_locator(DayLocator())
+        ax.xaxis.set_major_formatter( DateFormatter('%Y-%m-%d'))
+        labels = ax.get_xticklabels()
+        setp(labels, rotation=45, fontsize=6)
+        
+        xlabel('Dates (day)')
+        ylabel('Number of commits')
+        title('Commits by Date')
+        
+        filename = "commitsbydate"
+        path = os.path.join(self.env.path, 'cache', 'tracmetrixplugin', filename)
+        
+        fig.savefig(path)
+        
+        return path
+         
+        

tracmetrixplugin/0.11/tracmetrixplugin/templates/mdashboard.html

@@ -56 +56 @@
-
-      </div>
-
- 
+
+         <div> <img src="${href.mdashboard('%s/cummulativeflow.png' % (milestone.name,))}"/></div>
-      <div class="table">
-        <h2>Ticket History Table</h2>
@@ -81 +81 @@
-          </div>
-    </div>
-    
-    
-
-        <div>   <img src="${href.mdashboard('%s/cummulativeflow.png' % (milestone.name,))}"/></div>
-
-
-

tracmetrixplugin/0.11/tracmetrixplugin/templates/pdashboard.html

@@ -20 +20 @@
-
-          <div class="info">
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-      </div>
-      <br/>
@@ -138 +151 @@
-    </div>
-
+        <div>
+          <h2> Repository Statistics </h2>
+            <img src="${href.pdashboard('commitsbydate.png')}" alt="Commits by Date"/>
+        </div>
+
-    <div id="help"><strong>Note:</strong> See
-      <a href="${href.wiki('TracRoadmap')}">TracRoadmap</a> for help on using

tracmetrixplugin/0.11/tracmetrixplugin/web_ui.py

@@ -37 +37 @@
-    cursor = env.get_db_cnx().cursor()
-    
-
+ ORDER BY id
-
-    tkt_ids = [id for id , in cursor]
@@ -45 +45 @@
-def last_day_of_month(year, month):
-    
-
-
+
-
-class PDashboard(Component):
@@ -80 +79 @@
-        self.env.log.info("pdashboard match request %s" % (req.path_info,))  
-                
-
+
+
+
+
+
+
+
+
+
+
+
-
-    def process_request(self, req):
-        req.perm.require('ROADMAP_VIEW')
-
+        db = self.env.get_db_cnx()
+        
+        filename = req.args.get('imagename')
+                    
+        if filename != None:    
+            
+            self.env.log.info("request for image")
+            path = os.path.join(self.env.path, 'cache', 'tracmetrixplugin', filename)
+            req.send_file(path, mimeview.get_mimetype(path))
+            
+        else:
+            
+            self.env.log.info("request mdashboard")
+            add_stylesheet(req, 'pd/css/dashboard.css')  
+            
+            return self._render_view(req, db) 
+        
+
+    def _render_view(self, req, db):
+        
-        showall = req.args.get('show') == 'all'
-
-
-
+
-        # Get list of milestone object for the project
-        milestones = list(Milestone.select(self.env, showall, db))
@@ -104 +131 @@
-            'description': self.env.project_description
-        }
-
-        
-        
-        data = {
@@ -127 +152 @@
-                                                         for interval in proj_stat.intervals]}
-
-
+
+
+
+
+
+
+
+
-        tkt_group_metrics = TicketGroupMetrics(self.env, project_tickets)      
-        
@@ -145 +177 @@
-        last_day = last_day_of_month(today.year, today.month-1)
-        bmi_stats.append(tkt_group_metrics.get_bmi_monthly_stats(first_day, last_day))
+        
+        # get daily stat from today and a month back
+        last_day = datetime(today.year, today.month, today.day, tzinfo=utc)
+        first_day = datetime(today.year, today.month-1, today.day, tzinfo=utc)
+        
+        backlog_history = tkt_group_metrics.get_daily_backlog_history(first_day, last_day)
+        daily_backlog_chart_path = tkt_group_metrics.get_daily_backlog_chart(backlog_history)
+        
+        changeset_group_stats = ChangesetsStats(self.env, first_day, last_day)
+        commits_by_date = changeset_group_stats.get_commit_by_date()
+        commits_by_date_chart = changeset_group_stats.get_commit_by_date_chart(commits_by_date)
-        
-        data['project_bmi_stats'] = bmi_stats