Changeset 2199

Timestamp:

04/26/07 15:39:48 (1 year ago)

Author:

sambloomquist

Message:

ScrumBurndownPlugin:

refs #1248, #1219

Files:

• scrumburndownplugin/burndown/burndown.py (modified) (8 diffs)
• scrumburndownplugin/burndown/templates/burndown.cs (modified) (1 diff)
• scrumburndownplugin/setup.py (modified) (1 diff)

scrumburndownplugin/burndown/burndown.py

@@ -10 +10 @@
-
-import time
+import datetime
-import sys
-
@@ -21 +22 @@
-class BurndownComponent(Component):
-    implements(IEnvironmentSetupParticipant, INavigationContributor,
-
+, ITicketChangeListener
-    
-    #---------------------------------------------------------------------------
@@ -30 +31 @@
-
-    def environment_needs_upgrade(self, db):
+        self.log.debug('burndown plugin - environment needs upgrade')
-        needsUpgrade = False
-        
@@ -112 +114 @@
-        for s in sqlMilestone:
-            cursor.execute(s)
+            
+    #---------------------------------------------------------------------------
+    # ITicketChangeListener methods
+    #---------------------------------------------------------------------------
+    
+    def ticket_created(self, ticket):
+        update_burndown_data()
+        
+    def ticket_changed(self, ticket, comment, author, old_values):
+        update_burndown_data()
+        
+    def ticket_deleted(self, ticket):
+        update_burndown_data()
-
-    #---------------------------------------------------------------------------
@@ -117 +132 @@
-    #---------------------------------------------------------------------------
-    def get_active_navigation_item(self, req):
-
-
+
+
+
+
+
-    def get_navigation_items(self, req):
-
-
+
+
+
-    #---------------------------------------------------------------------------
-    # IPermissionRequestor methods
@@ -170 +189 @@
-        
-        if req.args.has_key('start'):
-M
+_m
-        else:
-            req.hdf['draw_graph'] = True
-BurndownD
+_burndown_d
-        
-        add_stylesheet(req, 'hw/css/burndown.css')
-        return 'burndown.cs', None
-        
-BurndownD
+_burndown_d
-        cursor = db.cursor()
-        
@@ -214 +233 @@
-        return burndown_data
-        
-M
+_m
-        cursor = db.cursor()
-        cursor.execute("SELECT started FROM milestone WHERE name = '%s'" % milestone)
@@ -250 +269 @@
-        from pkg_resources import resource_filename
-        return [('hw', resource_filename(__name__, 'htdocs'))]
+
+
+    #------------------------------------------------------------------------
+    # update_burndown_data
+    #  - add up the hours remaining for the open tickets for each open milestone and put the sums into the burndown table
+    #------------------------------------------------------------------------
+    def update_burndown_data():
+        is_weekly = BoolOption('burndown', 'is_weekly', False, """Boolean for whether the unit of time for the burndown chart is a week or a day.""")
+        
+        db = self.env.get_db_cnx()
+        cursor = db.cursor()
+        
+        # today's date
+        if is_weekly:
+            today = datetime.date.today()
+            today_year = today.strftime("%Y")
+            today_week = today.strftime("%W")
+            
+            # make sure that there isn't already an entry for this week in the burndown table
+            cursor.execute("SELECT id FROM burndown WHERE week = '%s' and year = '%s'" % (today_week, today_year))
+        else:
+            today = format_date(int(time.time()))
+            
+            # make sure that there isn't already an entry for today in the burndown table
+            cursor.execute("SELECT id FROM burndown WHERE date = '%s'" % today)
+            
+        row = cursor.fetchone()
+        needs_update = False
+        if row:
+            print >> sys.stderr, 'update_burndown_data has already been run - update needed'
+            needs_update = True
+        else:
+            print >> sys.stderr, 'first run of update_burndown_data - insert needed'
+        
+        # get arrays of the various components and milestones in the trac environment
+        cursor.execute("SELECT name AS comp FROM component")
+        components = cursor.fetchall()
+        cursor.execute("SELECT name, started, completed FROM milestone")
+        milestones = cursor.fetchall()
+        
+        for mile in milestones:
+            if mile[1] and not mile[2]: # milestone started, but not completed
+                for comp in components:
+                    sqlSelect =     "SELECT est.value AS estimate, ts.value AS spent "\
+                                        "FROM ticket t "\
+                                        "    LEFT OUTER JOIN ticket_custom est ON (t.id = est.ticket AND est.name = 'estimatedhours') "\
+                                        "    LEFT OUTER JOIN ticket_custom ts ON (t.id = ts.ticket AND ts.name = 'totalhours') "\
+                                        "WHERE t.component = '%s' AND t.milestone = '%s'"\
+                                        "    AND status IN ('new', 'assigned', 'reopened') "
+                    cursor.execute(sqlSelect % (comp[0], mile[0]))
+                
+                    rows = cursor.fetchall()
+                    hours = 0
+                    estimate = 0
+                    spent = 0
+                    if rows:
+                        for estimate, spent in rows:
+                            if not estimate:
+                                estimate = 0
+                            if not spent:
+                                spent = 0
+                        
+                            hours += float(estimate) - float(spent)
+                    
+                    if needs_update:
+                        if is_weekly:
+                            cursor.execute("UPDATE burndown SET hours_remaining = '%f' WHERE week = '%s' AND year = '%s' AND milestone_name = '%s'"\
+                                            "AND component_name = '%s'" % (hours, today_week, today_year, mile[0], comp[0]))
+                        else:
+                            cursor.execute("UPDATE burndown SET hours_remaining = '%f' WHERE date = '%s' AND milestone_name = '%s'"\
+                                            "AND component_name = '%s'" % (hours, today, mile[0], comp[0]))
+                    else:
+                        if is_weekly:
+                            cursor.execute("INSERT INTO burndown(id,component_name, milestone_name, week, year, hours_remaining) "\
+                                            "    VALUES(NULL,'%s','%s','%s','%s',%f)" % (comp[0], mile[0], today_week, today_year, hours))
+                        else:
+                            cursor.execute("INSERT INTO burndown(id,component_name, milestone_name, date, hours_remaining) "\
+                                            "    VALUES(NULL,'%s','%s','%s',%f)" % (comp[0], mile[0], today, hours))
+                                         
+        db.commit()

scrumburndownplugin/burndown/templates/burndown.cs

@@ -6 +6 @@
-</div>
-
-pos
+ge
-    <label for="selected_milestone">Select milestone:</label>
-    <select id="selected_milestone" name="selected_milestone">

scrumburndownplugin/setup.py

@@ -2 +2 @@
-
-PACKAGE = 'TracBurndown'
-7
+8
-
-setup(name=PACKAGE,