Changes between Version 12 and Version 13 of SCS_ISSUE_TRACKER_MAINTENANCE_R1

Timestamp:

10/14/08 16:52:14 (17 years ago)

Author:

astea

Comment:

--

SCS_ISSUE_TRACKER_MAINTENANCE_R1

@@ -41 +41 @@
  * rules about relationship with other tasks, if planned and unplanned overlap.
 = Implementation =
-^(Implementation results should be described and linked here (from the wiki or the repository)^
+These functions ware added into the [source:/manage/sched/sophie2-wbs.py] file:
+{{{
+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)
+}}}
+
+Overview:
+The function takes no arguments and generates SQL queries that insert data in the ticket_custom table. This is where the custom fields "importance" and "effort" are stored.
+
+Usage:
+ * Go to the sophie2-wbs.py file folder
+ * In the sophie2-wbs.py uncommnet the outImportancedEffort() call
+ * Execute: 
+{{{
+python sophie2-wbs.py | bash
+}}}
+
+
+{{{
+def outUpdateCustom(field): # field - "effort" or "importance" for now.
+        for t in Task.all.values() :
+                if isinstance(t,Rev) :
+                        if(field == "effort"):
+                                value = t.effort
+                        if(field == "importance"):
+                                value = t.importance()
+                        print "sqlite3 /sophie-project/sophie2/db/trac.db \"UPDATE ticket_custom SET value = \'%s\' WHERE name = \'%s\' and ticket = (SELECT id FROM ticket WHERE summary = \'%s\')\""% (value, field, t.name)
+}}}
+
+Overview:
+This function takes one argument: "importance" or "effort". It generates SQL queries that update the information in ticket_custom table according to the [source:/manage/sched/sophie2-wbs.py].
+Usage:
+ * Go to the sophie2-wbs.py file folder
+ * In the sophie2-wbs.py uncommnet the outUpdateCustom(sys.argv[1]) call
+ * Execute: 
+{{{
+python sophie2-wbs.py effort | bash
+//this will update the effort field
+python sophie2-wbs.py importance | bash
+//this will update the importance field
+}}}
+
 
 = Testing =