Simple migration script for old ODT templates (refs #3602)

3 files changed, 145 insertions, 0 deletions

diff --git a/ishtar_common/management/commands/ishtar_migrate_odts.py b/ishtar_common/management/commands/ishtar_migrate_odts.py
index e69de29bb..49ed9f2d8 100644
--- a/ishtar_common/management/commands/ishtar_migrate_odts.py
+++ b/ishtar_common/management/commands/ishtar_migrate_odts.py
@@ -0,0 +1,91 @@
+#!/usr/bin/env python
+# -*- coding: utf-8 -*-
+# Copyright (C) 2017  Étienne Loks <etienne.loks_AT_peacefrogsDOTnet>
+
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+# See the file COPYING for details.
+
+from django.core.management.base import BaseCommand
+from optparse import make_option
+import sys
+
+from ishtar_common.models import DocumentTemplate
+from ishtar_common.utils import BColors
+
+try:
+    input = raw_input
+except NameError:
+    pass
+
+
+class Command(BaseCommand):
+    help = "Update ODT templates from v1 to v2"
+    option_list = BaseCommand.option_list + (
+        make_option('--quiet',
+                    action='store_true',
+                    dest='quiet',
+                    default=False,
+                    help='Proceed silently with no interactive input.'),
+    )
+
+    def interactive_start(self):
+        sys.stdout.write(
+            BColors.HEADER + BColors.BOLD +
+            "Update ODT templates from v1 to v2\n")
+        sys.stdout.write(
+            BColors.ENDC + BColors.WARNING +
+            "This script need to be run only once. Running it on already "
+            "migrated ODT files may be a source of error.\n")
+        sys.stdout.write(BColors.ENDC)
+        yes = None
+        while yes != "yes":
+            sys.stdout.write(
+                "Are you sure you want to proceed? (yes/[n])\n")
+            yes = input()
+            if not yes or yes == "n":
+                sys.stdout.write(BColors.FAIL + "Aborting\n")
+                sys.stdout.write(BColors.ENDC)
+                sys.exit()
+
+    def handle(self, *args, **options):
+        quiet = options['quiet']
+        if not quiet:
+            self.interactive_start()
+        q = DocumentTemplate.objects
+        nb = q.count()
+        len_of_nb = str(len(str(nb)))
+        if not quiet:
+            sys.stdout.write(BColors.OKGREEN)
+
+        errors = []
+        for idx, document in enumerate(q.all()):
+            if not quiet:
+                sys.stdout.write(
+                    ("Processing {:" + len_of_nb + "d}/{}\r").format(
+                        idx + 1, nb))
+                sys.stdout.flush()
+                try:
+                    document.convert_from_v1()
+                except IOError as e:
+                    errors.append("Document ({}): ".format(document.pk) +
+                                  str(e))
+        if errors:
+            sys.stdout.write(BColors.FAIL + "Error while processing:\n")
+            for error in errors:
+                sys.stdout.write("* {}\n".format(error))
+
+        sys.stdout.write(BColors.ENDC)
+        print("\n\n")
+
diff --git a/ishtar_common/models.py b/ishtar_common/models.py
index caf9be26c..2a7e386b2 100644
--- a/ishtar_common/models.py
+++ b/ishtar_common/models.py
@@ -1617,6 +1617,46 @@ class DocumentTemplate(models.Model):
         output.write(result)
         return output_name
 
+    def convert_from_v1(self):
+        """
+        Convert the current template from v1 to v2.
+        """
+        from old.ooo_replace import ooo_replace
+        from archaeological_operations.models import AdministrativeAct
+
+        old_dir = settings.MEDIA_ROOT + "/upload/templates/v1/"
+        if not os.path.exists(old_dir):
+            os.makedirs(old_dir)
+        shutil.copy(settings.MEDIA_ROOT + self.template.name, old_dir)
+
+        tempdir = tempfile.mkdtemp("-ishtardocs")
+        output_name = tempdir + os.path.sep + self.template.name.split(
+            os.sep)[-1]
+
+        objects = []
+        filters = [
+            {'operation__isnull': False},
+            {'associated_file__isnull': False},
+            {'treatment_file__isnull': False},
+            {'treatment__isnull': False},
+        ]
+        for filtr in filters:
+            q = AdministrativeAct.objects.filter(**filtr)
+            if q.count():
+                objects.append(q.all()[0])
+
+        if not objects:
+            return
+        values = {}
+        for obj in objects:
+            values.update(obj.get_values())
+        for key in values:
+            values[key] = "{{ " + key + " }}"
+
+        ooo_replace(self.template, output_name, values)
+        shutil.move(output_name, settings.MEDIA_ROOT + self.template.name)
+        return output_name
+
 
 class State(models.Model):
     label = models.CharField(_(u"Label"), max_length=30)
diff --git a/ishtar_common/utils.py b/ishtar_common/utils.py
index 555a338f8..19ff16394 100644
--- a/ishtar_common/utils.py
+++ b/ishtar_common/utils.py
@@ -32,6 +32,20 @@ from django.utils.translation import ugettext_lazy as _, ugettext
 from django.template.defaultfilters import slugify
 
 
+class BColors:
+    """
+    Bash colors. Don't forget to finish your colored string with ENDC.
+    """
+    HEADER = '\033[95m'
+    OKBLUE = '\033[94m'
+    OKGREEN = '\033[92m'
+    WARNING = '\033[93m'
+    FAIL = '\033[91m'
+    ENDC = '\033[0m'
+    BOLD = '\033[1m'
+    UNDERLINE = '\033[4m'
+
+
 def get_current_year():
     return datetime.datetime.now().year