Changeset 1268

Show
Ignore:
Timestamp:
09/13/06 10:04:28 (2 years ago)
Author:
sambloomquist
Message:

ScrumBurndownPlugin:

Changed database column names in burndown_job.py in order to integrate with the TimingAndEstimationPlugin (http://trac-hacks.org/wiki/TimingAndEstimationPlugin). fixes #498

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • scrumburndownplugin/burndown/burndown_job.py

    r1122 r1268  
    4848                sqlSelect =     "SELECT est.value AS estimate, ts.value AS spent "\ 
    4949                                    "FROM ticket t "\ 
    50                                     "    LEFT OUTER JOIN ticket_custom est ON (t.id = est.ticket AND est.name = 'current_estimate') "\ 
    51                                     "    LEFT OUTER JOIN ticket_custom ts ON (t.id = ts.ticket AND ts.name = 'time_spent') "\ 
     50                                    "    LEFT OUTER JOIN ticket_custom est ON (t.id = est.ticket AND est.name = 'estimatedhours') "\ 
     51                                    "    LEFT OUTER JOIN ticket_custom ts ON (t.id = ts.ticket AND ts.name = 'totalhours') "\ 
    5252                                    "WHERE t.component = '%s' AND t.milestone = '%s' " 
    53                 #print sqlSelect % (comp[0], mile[0]) 
    5453                cursor.execute(sqlSelect % (comp[0], mile[0])) 
    5554             
    …… 
    6564                            spent = 0 
    6665                     
    67                         hours += int(estimate) - int(spent) 
     66                        hours += float(estimate) - float(spent) 
    6867                         
    6968                else: 
    7069                    print "no results for %s component in %s milestone" % (comp[0], mile[0]) 
    71                 # print "last id was %s" % (db.get_last_id(cursor, 'burndown')) 
    7270                # Sometimes db.get_last_id(cursor, 'burndown') returns "None"..  
    7371                print 'burndown: %s, %s, %s, %s, %i' % (db.get_last_id(cursor, 'burndown'), comp[0], mile[0], today, hours) 

  • scrumburndownplugin/deploy.bat

    r870 r1268  
    1 copy c:\burndown-plugin\dist\TracBurndown-0.1-py2.3.egg C:\Python23\Lib\site-packages 
     1copy c:\burndown-plugin\dist\TracBurndown-01.00.10-py2.3.egg C:\Python23\Lib\site-packages 

  • scrumburndownplugin/setup.py

    r1126 r1268  
    22 
    33PACKAGE = 'TracBurndown' 
    4 VERSION = '0.2' 
     4VERSION = '01.00.10' 
    55 
    66setup(name=PACKAGE, 
     7      description='Plugin to provide a dynamic burndown chart in Trac.', 
     8      keywords='trac plugin scrum burndown', 
     9      url='http://www.trac-hacks.org/wiki/ScrumBurndownPlugin', 
    710      version=VERSION, 
    811      packages=['burndown'],