Error: Macro BackLinksMenu(None) failed

compressed data is corrupt

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 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

SCS_ISSUE_TRACKER_SETUP_R1

How to demo

Show different ticket reports, ticket and explain usage.

Design

Implementation

This function from the 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

Error: Macro Include(wiki:SCS_ISSUE_TRACKER_MAINTENANCE_R1_LOG) failed

current transaction is aborted, commands ignored until end of transaction block