mailmanager migration.py,1.5,1.5.2.1

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

Update of /cvsroot/mailmanager/mailmanager
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9717

Modified Files:
      Tag: RELENG_2_0_1
	migration.py 
Log Message:
Added in addition migration for 2.0-r7 release, which adds in additional
tables for categories and filters


Index: migration.py
===================================================================
RCS file: /cvsroot/mailmanager/mailmanager/migration.py,v
retrieving revision 1.5
retrieving revision 1.5.2.1
diff -u -d -r1.5 -r1.5.2.1
--- migration.py	18 Jul 2005 09:50:30 -0000	1.5
+++ migration.py	6 Sep 2005 15:00:33 -0000	1.5.2.1
@@ -1,5 +1,5 @@
 # (c) Copyright Logicalware Ltd 2002-2005
-# logicalware MailManager comes with ABSOLUTELY NO WARRANTY. Further details
+# Logicalware MailManager comes with ABSOLUTELY NO WARRANTY. Further details
 # including conditions of redistribution are contained in LICENSE.txt
 # http://www.logicalware.org/
 # $Id$
@@ -337,6 +337,52 @@
             # Add on text search capability
             get_transaction().commit()
             self.sql.addTextSearch()
+        
+    # Migration for categories and templates for 2.0-r7
+    if self.mversion < 11:
+        self.sql.createCategoryAndTemplateTables()
+
+        # Migrate the templates
+        for tempname in self.reply_templates:
+            
+            if self.reply_templates[tempname].has_key('body'):
+                body = self.reply_templates[tempname]['body']
+            else:
+                body = ''
+
+            if self.reply_templates[tempname].has_key('html'):
+                html = self.reply_templates[tempname]['html']
+            else:
+                html = ''
+
+            self.sql.addTemplate( 
+                name = tempname,
+                body = body,
+                html = (html == 'on') and 't' or 'f'
+            )
+
+        del self.reply_templates
+
+        # Migrate the category information
+        for catidx in [0,1,2]:
+            self.sql.addCategory(
+                id = catidx,
+                label = self.category_labels[catidx],
+                enabled = self.category_on[catidx]
+            )
+                
+            for choice in self.category_choices[catidx]:
+                self.sql.addCategoryChoice(
+                    category_id = catidx,
+                    choice = choice
+                )
+
+        del self.category_labels
+        del self.category_choices
+        del self.category_on
+
+        self._p_changed = 1
+    
 
     # Update the migration & display versions
     self.mversion = MailManager.mversion