configurationengine/source/cone/report/report_util.py
author m2lahtel
Tue, 10 Aug 2010 14:29:28 +0300
changeset 3 e7e0ae78773e
permissions -rw-r--r--
ConE 1.2.11 release
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
3
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     1
#
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     2
# Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     3
# All rights reserved.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     4
# This component and the accompanying materials are made available
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     5
# under the terms of "Eclipse Public License v1.0"
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     6
# which accompanies this distribution, and is available
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     7
# at the URL "http://www.eclipse.org/legal/epl-v10.html".
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     8
#
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
     9
# Initial Contributors:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    10
# Nokia Corporation - initial contribution.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    11
#
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    12
# Contributors:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    13
#
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    14
# Description:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    15
#
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    16
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    17
import os
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    18
import urllib
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    19
import logging
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    20
from jinja2 import Environment, FileSystemLoader
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    21
from cone.public import utils
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    22
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    23
ROOT_PATH = os.path.abspath(os.path.dirname(__file__))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    24
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    25
log = logging.getLogger('cone.report_util')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    26
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    27
class ReportShortcut(object):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    28
    def __init__(self, template_file, report_file, description):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    29
        self.template_file = template_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    30
        self.report_file = report_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    31
        self.description = description
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    32
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    33
class ReportShortcutContainer(object):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    34
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    35
    Container for report shortcuts.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    36
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    37
    A report shortcut describes a pre-defined report option that
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    38
    has a default template, report file and description. The shortcut
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    39
    container holds a set of shortcuts and can be used to generate
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    40
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    41
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    42
    def __init__(self, shortcuts, default_shortcut):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    43
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    44
        @param shortcuts: The shortcuts, a dictionary mapping shortcut
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    45
            names to ReportShortcut objects.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    46
        @param default_shortcut: The default shortcut name to use
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    47
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    48
        if not isinstance(shortcuts, dict):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    49
            raise ValueError("'shortcuts' must a dictionary (%s given)!" % type(shortcuts))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    50
        if default_shortcut is not None and default_shortcut not in shortcuts:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    51
            raise ValueError("'default_shortcut' must be either None or exist ing 'shortcuts'!")
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    52
        self.shortcuts = shortcuts
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    53
        self.default_shortcut = default_shortcut
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    54
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    55
    def get_shortcut_help_text(self):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    56
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    57
        Create the text to append to the option description for the
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    58
        option used to specify the used shortcut.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    59
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    60
        shortcuts_text = []
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    61
        refs = sorted(self.shortcuts.keys())
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    62
        if refs:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    63
            for ref in refs:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    64
                sc = self.shortcuts[ref]
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    65
                text = "%s - %s" % (ref, sc.description)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    66
                COLUMN_WIDTH = (80 - 25)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    67
                space_count = COLUMN_WIDTH - (len(text) % COLUMN_WIDTH)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    68
                shortcuts_text.append(text + space_count * ' ')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    69
        else:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    70
            shortcuts_text.append("None")
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    71
        shortcuts_text = '\n'.join(shortcuts_text)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    72
        return shortcuts_text
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    73
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    74
    def is_valid_shortcut(self, shortcut):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    75
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    76
        Return whether the given shortcut is valid within the context
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    77
        of this container.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    78
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    79
        return shortcut is None or shortcut in self.shortcuts
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    80
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    81
    def determine_template_and_report(self, shortcut, template_file, report_file, report_file_name_without_ext):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    82
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    83
        Determine the actual template and report files based on the shortcuts
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    84
        and given options.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    85
        @param shortcut: The used shortcut or None.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    86
        @param template_file: Explicitly given template file or None.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    87
        @param report_file: Explicitly given report file or None.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    88
        @param report_file_name_without_ext: Prefix used to determine the
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    89
            report file name if the template was explicitly given, but the
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    90
            report file was not. E.g. if this is 'test' and the explicitly
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    91
            given template file is 'my_template.html', the report file would
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    92
            be 'test.html'.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    93
        @return: Tuple (template_file, report_file) specifying the actual
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    94
            template and report files.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    95
        """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    96
        actual_shortcut      = None
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    97
        actual_template_file = None
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    98
        actual_report_file   = None
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
    99
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   100
        # Handle report shortcut (set to default or check the given one)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   101
        if not shortcut:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   102
            actual_shortcut = self.default_shortcut
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   103
        else:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   104
            actual_shortcut = shortcut
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   105
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   106
        # Determine template file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   107
        if template_file:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   108
            actual_template_file = template_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   109
        else:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   110
            actual_template_file = self.shortcuts[actual_shortcut].template_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   111
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   112
        # Determine report output file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   113
        if report_file:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   114
            actual_report_file = report_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   115
        else:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   116
            if template_file:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   117
                # Determine report file name based on the template file name
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   118
                # if the template was explicitly given
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   119
                actual_report_file = report_file_name_without_ext + os.path.splitext(template_file)[1]
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   120
            else:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   121
                actual_report_file = self.shortcuts[actual_shortcut].report_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   122
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   123
        return actual_template_file, actual_report_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   124
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   125
def generate_report(template_file, report_file, report_data, template_paths=[], extra_filters={}):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   126
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   127
    Generate a report based on the given template file, report file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   128
    and data dictionary.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   129
    @param template_file: Path to the template file to use.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   130
    @param report_file: Path to the output report file.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   131
    @param report_data: The report data dictionary used when rendering
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   132
        the report from the template.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   133
    @param template_paths: the additional search paths for templates. The default location cone.report is 
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   134
    always included.   
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   135
    @return: True if successful, False if not.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   136
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   137
    template_paths.insert(0, ROOT_PATH)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   138
    template_paths.insert(0, os.path.dirname(template_file))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   139
    template_paths = utils.distinct_array(template_paths)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   140
    log.debug('generate_report(template_file=%r, report_file=%r, <data>, template_paths=%s)' % (template_file, report_file, template_paths))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   141
    if not isinstance(report_data, dict):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   142
        raise ValueError("report_data must be a dictionary!")
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   143
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   144
    try:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   145
        template_file = os.path.abspath(template_file)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   146
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   147
        loader = FileSystemLoader(template_paths)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   148
        env = Environment(loader=loader)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   149
        set_filters(env,extra_filters)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   150
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   151
        template = env.get_template(os.path.basename(template_file))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   152
        file_string = template.render(report_data)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   153
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   154
        # Create directories for the report
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   155
        report_dir = os.path.dirname(report_file)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   156
        if report_dir != '' and not os.path.exists(report_dir):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   157
            os.makedirs(report_dir)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   158
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   159
        # Write the rendered report to file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   160
        f = open(report_file, 'wb')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   161
        try:        f.write(file_string.encode('utf-8'))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   162
        finally:    f.close()
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   163
        
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   164
        print "Generated report to '%s'" % report_file
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   165
        return True
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   166
    except Exception, e:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   167
        utils.log_exception(log, "Failed to generate report: %s %s" % (type(e), e))
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   168
        return False
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   169
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   170
def _set_default_filters(env):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   171
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   172
    Set default filters to the given Jinja environment
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   173
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   174
    env.filters['xml_charref_replace'] = lambda value: unicode(value).encode('ascii', 'xmlcharrefreplace')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   175
    env.filters['pathname_to_url'] = lambda value: urllib.pathname2url(value)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   176
    env.filters['csv_escape'] = _csv_escape
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   177
    env.filters['csv_escape_partial'] = lambda value: unicode(value).replace('"', '""')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   178
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   179
def set_filters(env, filters={}):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   180
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   181
    First set the default filters and then possible extra filters from filters dict
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   182
    @param filters: the filters dictionary where the key is the filter name and value the method pointer
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   183
     
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   184
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   185
    _set_default_filters(env)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   186
    for name, filter in filters.iteritems():
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   187
        env.filters[name]=filter
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   188
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   189
def _csv_escape(value):
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   190
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   191
    Escape a string value so that it can be used as a field in a CSV file.
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   192
    """
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   193
    value = unicode(value)
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   194
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   195
    needs_quoting = False
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   196
    for special_char in '",\n':
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   197
        if special_char in value:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   198
            needs_quoting = True
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   199
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   200
    if needs_quoting:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   201
        if '"' in value:
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   202
            value = value.replace('"', '""')
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   203
        value = '"' + value + '"'
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   204
    
e7e0ae78773e ConE 1.2.11 release
m2lahtel
parents:
diff changeset
   205
    return value