changeset 317:b89bb28a8c80

Regroup FieldValue ?
author Sylvain Beucler <beuc@beuc.net>
date Tue, 17 Aug 2010 23:54:28 +0200
parents e80f63d8ddc3
children 8d7c891dec61
files savane/tracker/models.py
diffstat 1 files changed, 25 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/savane/tracker/models.py
+++ b/savane/tracker/models.py
@@ -326,6 +326,31 @@
 class FieldValue(models.Model):
     """
     Choices overlay for a select-box (SB) field of a specific group
+
+    Values that change between trackers:
+          SELECT bug_field_id,group_id,value_id,value FROM bugs_field_value WHERE group_id=100
+    UNION SELECT bug_field_id,group_id,value_id,value FROM patch_field_value WHERE group_id=100
+    UNION SELECT bug_field_id,group_id,value_id,value FROM support_field_value WHERE group_id=100
+    UNION SELECT bug_field_id,group_id,value_id,value FROM task_field_value WHERE group_id=100
+    ORDER BY bug_field_id,group_id,value_id;
+
+    |          108 |      100 |        1 | Fixed             | bugs
+    |          108 |      100 |        1 | Done              | patch,support,task
+    
+    |          108 |      100 |        3 | Wont Fix          | bugs
+    |          108 |      100 |        3 | Wont Do           | patch,support
+    |          108 |      100 |        3 | Cancelled         | task
+    
+    Savannah and Gna!-specific:
+    |          201 |      100 |      120 | Microsoft Windows | bugs,task
+    |          201 |      100 |      120 | *BSD              | support
+                                                               patch: (None)
+    |          201 |      100 |      130 | *BSD              | bugs,task
+    |          201 |      100 |      130 | Microsoft Windows | support
+                                                               patch: (None)
+
+    => Regroup: put "Wont Do" everywhere, "Done" everywhere, and
+       manually revert woe/bsd in support.items
     """
     class Meta:
         unique_together = (('field', 'group', 'value_id'),)