Mercurial > hg > savane-forge
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