changeset 325:c193bb0a8819

Trackers: even more static fields definition
author Sylvain Beucler <beuc@beuc.net>
date Sat, 21 Aug 2010 13:45:48 +0200
parents 9275694cda61
children f34eba406e57
files doc/savane3_trackers.txt doc/scripts/tracker_defsgen.py savane/tracker/defs.py
diffstat 3 files changed, 64 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/doc/savane3_trackers.txt
+++ b/doc/savane3_trackers.txt
@@ -83,7 +83,7 @@
     +----------+---------------------+
     14 rows in set (0.00 sec)
     
-    So we could just set required=0,empty_ok=1 for those 2.
+    So we just set required=0,empty_ok=1 for those 2.
 
 - Field usage:
 
@@ -124,7 +124,7 @@
     102 -> (use_it,show_on_add,show_on_add_members=0)(patch,task) | (use_it,show_on_add,show_on_add_members=1)(bugs,support)
     107 -> (show_on_add,show_on_add_members=0)(patch,support) | (show_on_add,show_on_add_members=1)(bugs,task) [but use_it=0]
     201 -> (use_it,show_on_add,show_on_add_members=0)(bugs,patch,task) | (use_it,show_on_add,show_on_add_members=1)(support)
-    201 -> (use_it,show_on_add,show_on_add_members=0)(bugs,patch,support) | (use_it,show_on_add,show_on_add_members=1)(task)
+    206 -> (use_it,show_on_add,show_on_add_members=0)(bugs,patch,support) | (use_it,show_on_add,show_on_add_members=1)(task)
     211 -> (show_on_add,show_on_add_members,place)
            bugs: 0,1,200
            patch: 1,1,150
--- a/doc/scripts/tracker_defsgen.py
+++ b/doc/scripts/tracker_defsgen.py
@@ -15,7 +15,7 @@
 defs = {}
 field_names = []
 c.execute("""SELECT * FROM bugs_field""")
-def process_row(row):
+def process_field_row(row):
     name = row[1]
     field_names.append(name)
     defs[name] = ''
@@ -46,11 +46,11 @@
             defs[name] += "\n"
 
 for row in c.fetchall():
-    process_row(row)
+    process_field_row(row)
 
 c.execute("""SELECT * FROM task_field WHERE field_name IN ('planned_starting_date', 'planned_close_date')""")
 for row in c.fetchall():
-    process_row(row)
+    process_field_row(row)
 
 tfields = ['name','bug_field_id','group_id','use_it','show_on_add',
            'show_on_add_members','place','custom_label',
@@ -59,7 +59,7 @@
            'transition_default_auth']
 c.execute("""SELECT bugs_field.field_name,bugs_field_usage.*
   FROM bugs_field_usage JOIN bugs_field USING (bug_field_id) WHERE group_id=100""")
-for row in c.fetchall():
+def process_field_usage_row(row):
     name = row[0]
     for i,val in enumerate(row):
         if i <= 2:
@@ -84,6 +84,13 @@
                 defs[name] += "'"+val+"',"
             defs[name] += "\n"
     defs[name] += "    },\n"
+for row in c.fetchall():
+    process_field_usage_row(row)
+c.execute("""SELECT task_field.field_name,task_field_usage.*
+  FROM task_field_usage JOIN task_field USING (bug_field_id) WHERE group_id=100
+  AND field_name IN ('planned_starting_date', 'planned_close_date')""")
+for row in c.fetchall():
+    process_field_usage_row(row)
 
 for name in field_names:
     print defs[name],
--- a/savane/tracker/defs.py
+++ b/savane/tracker/defs.py
@@ -1293,6 +1293,12 @@
         'keep_history': 1,
         'special': 0,
         'custom': 0,
+        'use_it': 1,
+        'show_on_add': 1,
+        'show_on_add_members': 1,
+        'place': 56,
+        'transition_default_auth': 'A',
+    },
     'planned_starting_date' : {
         'field_name': 'planned_starting_date',
         'display_type': 'DF',
@@ -1305,9 +1311,54 @@
         'keep_history': 1,
         'special': 0,
         'custom': 0,
+        'use_it': 1,
+        'show_on_add': 1,
+        'show_on_add_members': 1,
+        'place': 55,
+        'transition_default_auth': 'A',
+    },
 }
 
 fields['bugs']    = common.copy()
 fields['patch']   = common.copy()
 fields['support'] = common.copy()
 fields['task']    = common.copy()
+
+# A couple changes per-tracker in the default configuration
+#submitted_by     92 -> (use_it=0)(patch,support) | (use_it=1)(bugs,task)
+fields['patch']['submitted_by']['use_it'] = fields['support']['submitted_by']['use_it'] = 0
+#severity    102 -> (use_it,show_on_add,show_on_add_members=0)(patch,task) | (use_it,show_on_add,show_on_add_members=1)(bugs,support)
+fields['patch']['severity']['use_it'] = fields['task']['severity']['use_it'] = 0
+fields['patch']['severity']['show_on_add'] = fields['task']['severity']['show_on_add'] = 0
+fields['patch']['severity']['show_on_add_members'] = fields['task']['severity']['show_on_add_members'] = 0
+#bug_group_id    107 -> (show_on_add,show_on_add_members=0)(patch,support) | (show_on_add,show_on_add_members=1)(bugs,task) [but use_it=0]
+#fields['patch']['bug_group_id']['show_on_add'] = fields['support']['bug_group_id']['show_on_add'] = 0
+#fields['patch']['bug_group_id']['show_on_add_members'] = fields['support']['bug_group_id']['show_on_add_members'] = 0
+#platform_version_id    201 -> (use_it,show_on_add,show_on_add_members=0)(bugs,patch,task) | (use_it,show_on_add,show_on_add_members=1)(support)
+fields['support']['platform_version_id']['use_it'] = 1
+fields['support']['platform_version_id']['show_on_add'] = 1
+fields['support']['platform_version_id']['show_on_add_members'] = 1
+#hours    201 -> (use_it,show_on_add,show_on_add_members=0)(bugs,patch,support) | (use_it,show_on_add,show_on_add_members=1)(task)
+fields['task']['hours']['use_it'] = 1
+fields['task']['hours']['show_on_add'] = 1
+fields['task']['hours']['show_on_add_members'] = 1
+#priority    211 -> (show_on_add,show_on_add_members,place)
+#           bugs: 0,1,200
+#           patch: 1,1,150
+fields['patch']['priority']['show_on_add'] = 1
+fields['patch']['priority']['show_on_add_members'] = 1
+fields['patch']['priority']['place'] = 150
+#           support: 0,0,150
+fields['support']['priority']['show_on_add'] = 0
+fields['support']['priority']['show_on_add_members'] = 0
+fields['support']['priority']['place'] = 150
+#           task: 1,1,200
+fields['task']['priority']['show_on_add'] = 1
+fields['task']['priority']['show_on_add_members'] = 1
+fields['task']['priority']['place'] = 200
+#originator_email    216 -> (use_it,show_on_add=0)(task) | (use_it=1,show_on_add=2)(bugs,patch,support)
+fields['task']['originator_email']['use_it'] = 0
+fields['task']['originator_email']['show_on_add'] = 0
+#percent_complete    220 -> (use_it,show_on_add_members=0)(bugs,patch,support) | (use_it,show_on_add_members=1)(task)
+fields['task']['originator_email']['use_it'] = 1
+fields['task']['originator_email']['show_on_add_members'] = 1