Changes between Version 6 and Version 7 of SCS_ISSUE_TRACKER_MAINTENANCE_R1

Timestamp:

10/14/08 13:37:48 (17 years ago)

Author:

astea

Comment:

--

SCS_ISSUE_TRACKER_MAINTENANCE_R1

@@ -23 +23 @@
 = Design =
 = Implementation =
-^(Implementation results should be described and linked here (from the wiki or the repository)^
+
+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 =