[[BackLinksMenu]]

= Analysis =
== Overview ==
This task includes maintaining the issue tracker and testing the new workflow.
== Task requirements ==
The new fields must be consistent, and scripts for updating them must be provided.
New custom fields might be needed and they must be filled with auto-generated information from the [source:/manage/sched/sophie2-wbs.py] file.
These custom fields may be useful:
 * importance - this field will be useful for sorting our wiki pages.
 * effort - the effort planned for the issue.
Should discuss and test the new work flow at the end of this week (2008-10-19). Should be decided what will be the process.
Define rules for the unplanned tasks - what happens when unplanned task appears.
== Task result ==
An easily maintainable tracker. 
== Implementation idea ==
The new issue fields must be added into the trac.ini file into the [ticket-custom] section. The database must be updated, a python script that generates sql script might do the trick. In the next weekly should be discussed observations of the new workflow.
== Related ==
[wiki:SCS_ISSUE_TRACKER_SETUP_R1]

== How to demo ==
Show different ticket reports, ticket and explain usage.
= Design =
= Implementation =

This function from the [source:/manage/sched/sophie2-wbs.py] file generates a scrypt that inserts data into the custion fields: order and importance. 
{{{
def outImportancedEffort():
	for t in Task.all.values() :
		if isinstance(t,Rev) :
			print "sqlite3 /sophie-project/sophie2/db/trac.db \"INSERT INTO ticket_custom ( ticket,name,value ) SELECT id AS ticket, \'importance\' AS name, %s AS value FROM ticket where ticket.summary = \'%s\' AND id NOT IN (SELECT ticket FROM ticket_custom WHERE name = \'importance\');\""% (t.importance(), t.name)
			print "sqlite3 /sophie-project/sophie2/db/trac.db \"INSERT INTO ticket_custom ( ticket,name,value ) SELECT id AS ticket, \'effort\' AS name, %s AS value FROM ticket where ticket.summary = \'%s\' AND id NOT IN (SELECT ticket FROM ticket_custom WHERE name = \'effort\');\""% (t.effort, t.name)
}}}


= Testing =
= Comments =
This task should be implemented after 2008-10-19
= Log =
[[Include(wiki:SCS_ISSUE_TRACKER_MAINTENANCE_R1_LOG)]]