SF.net SVN: mailmanager: [3112] MailManager/branches/RELENG_2_1/support

[<ke...@us...>]

Revision: 3112
Author:   kevca
Date:     2006-05-30 12:06:35 -0700 (Tue, 30 May 2006)
ViewCVS:  http://svn.sourceforge.net/mailmanager/?rev=3112&view=rev

Log Message:
-----------
Migration fixes for
- Replied tickets are being marked as overdue (#1497428)

Modified Paths:
--------------
    MailManager/branches/RELENG_2_1/migrations/v2_1/__init__.py
    MailManager/branches/RELENG_2_1/support/login.py
Modified: MailManager/branches/RELENG_2_1/migrations/v2_1/__init__.py
===================================================================
--- MailManager/branches/RELENG_2_1/migrations/v2_1/__init__.py	2006-05-30 18:20:14 UTC (rev 3111)
+++ MailManager/branches/RELENG_2_1/migrations/v2_1/__init__.py	2006-05-30 19:06:35 UTC (rev 3112)
@@ -149,6 +149,37 @@
     self.mversion = 'v2_1_4'
 
 
+def migrate_v2_1_4_v2_1_5(self, migrationParams):
+    """ Fix overdue and viewed status on tickets
+        
+        Another late divergence fix for any datasets pre 2_1_4. Tickets
+        in the database will not have either the Responded or Viewed 
+        attributes set. These can be inferred from the existing data in
+        the database.
+
+        Fixes Replied tickets are being marked as overdue (#1497428)
+    """
+
+    # Add the Responded and Viewed attributes for each ticket
+    for t in self.sql.listTickets():
+        if t.date_responded:
+            self.sql.setTicketAttribute(
+                sqv_ticket_id = t.id,
+                sqv_attribute = 'Responded',
+                sqv_setting = self.mmobj.sql_true
+            )
+        
+        if not t.unread:
+            self.sql.setTicketAttribute(
+                sqv_ticket_id = t.id,
+                sqv_attribute = 'Viewed',
+                sqv_setting = self.mmobj.sql_true
+            )
+
+    # Update the mversion to show we are complete
+    self.mversion = 'v2_1_5'
+
+
 def migrate_convert_postgres_unicode(self, migrationParams):
     """ Convert postgres database to using unicode """
     
@@ -269,6 +300,11 @@
                      'Fixes Overdue status is lost on migration (#1493442)',
         'method' : migrate_v2_1_3_v2_1_4,
     },
+    'v2_1_4' : {
+        'targetstate' : 'v2_1_5',
+        'overview' : 'Fixes Replied tickets are being marked as overdue (#1497428)',
+        'method' : migrate_v2_1_4_v2_1_5,
+    },
 }
 
 

Modified: MailManager/branches/RELENG_2_1/support/login.py
===================================================================
--- MailManager/branches/RELENG_2_1/support/login.py	2006-05-30 18:20:14 UTC (rev 3111)
+++ MailManager/branches/RELENG_2_1/support/login.py	2006-05-30 19:06:35 UTC (rev 3112)
@@ -29,6 +29,7 @@
 
 from Products.MailManager.ruleset.common import NoTransitionError
 
+debug = False
 
 # Enable this to get debugging informatioin on stdout
 # debug = True


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.