| Index: third_party/logilab/common/table.py | 
| diff --git a/third_party/logilab/common/table.py b/third_party/logilab/common/table.py | 
| new file mode 100644 | 
| index 0000000000000000000000000000000000000000..744bb785f2bf947329bf689fee8bba0343311bfd | 
| --- /dev/null | 
| +++ b/third_party/logilab/common/table.py | 
| @@ -0,0 +1,923 @@ | 
| +# copyright 2003-2011 LOGILAB S.A. (Paris, FRANCE), all rights reserved. | 
| +# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr | 
| +# | 
| +# This file is part of logilab-common. | 
| +# | 
| +# logilab-common is free software: you can redistribute it and/or modify it under | 
| +# the terms of the GNU Lesser General Public License as published by the Free | 
| +# Software Foundation, either version 2.1 of the License, or (at your option) any | 
| +# later version. | 
| +# | 
| +# logilab-common 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 Lesser General Public License for more | 
| +# details. | 
| +# | 
| +# You should have received a copy of the GNU Lesser General Public License along | 
| +# with logilab-common.  If not, see <http://www.gnu.org/licenses/>. | 
| +"""Table management module.""" | 
| +__docformat__ = "restructuredtext en" | 
| + | 
| + | 
| +class Table(object): | 
| +    """Table defines a data table with column and row names. | 
| +    inv: | 
| +        len(self.data) <= len(self.row_names) | 
| +        forall(self.data, lambda x: len(x) <= len(self.col_names)) | 
| +    """ | 
| + | 
| +    def __init__(self, default_value=0, col_names=None, row_names=None): | 
| +        self.col_names = [] | 
| +        self.row_names = [] | 
| +        self.data = [] | 
| +        self.default_value = default_value | 
| +        if col_names: | 
| +            self.create_columns(col_names) | 
| +        if row_names: | 
| +            self.create_rows(row_names) | 
| + | 
| +    def _next_row_name(self): | 
| +        return 'row%s' % (len(self.row_names)+1) | 
| + | 
| +    def __iter__(self): | 
| +        return iter(self.data) | 
| + | 
| +    def __eq__(self, other): | 
| +        if other is None: | 
| +            return False | 
| +        else: | 
| +            return list(self) == list(other) | 
| + | 
| +    def __ne__(self, other): | 
| +        return not self == other | 
| + | 
| +    def __len__(self): | 
| +        return len(self.row_names) | 
| + | 
| +    ## Rows / Columns creation ################################################# | 
| +    def create_rows(self, row_names): | 
| +        """Appends row_names to the list of existing rows | 
| +        """ | 
| +        self.row_names.extend(row_names) | 
| +        for row_name in row_names: | 
| +            self.data.append([self.default_value]*len(self.col_names)) | 
| + | 
| +    def create_columns(self, col_names): | 
| +        """Appends col_names to the list of existing columns | 
| +        """ | 
| +        for col_name in col_names: | 
| +            self.create_column(col_name) | 
| + | 
| +    def create_row(self, row_name=None): | 
| +        """Creates a rowname to the row_names list | 
| +        """ | 
| +        row_name = row_name or self._next_row_name() | 
| +        self.row_names.append(row_name) | 
| +        self.data.append([self.default_value]*len(self.col_names)) | 
| + | 
| + | 
| +    def create_column(self, col_name): | 
| +        """Creates a colname to the col_names list | 
| +        """ | 
| +        self.col_names.append(col_name) | 
| +        for row in self.data: | 
| +            row.append(self.default_value) | 
| + | 
| +    ## Sort by column ########################################################## | 
| +    def sort_by_column_id(self, col_id, method = 'asc'): | 
| +        """Sorts the table (in-place) according to data stored in col_id | 
| +        """ | 
| +        try: | 
| +            col_index = self.col_names.index(col_id) | 
| +            self.sort_by_column_index(col_index, method) | 
| +        except ValueError: | 
| +            raise KeyError("Col (%s) not found in table" % (col_id)) | 
| + | 
| + | 
| +    def sort_by_column_index(self, col_index, method = 'asc'): | 
| +        """Sorts the table 'in-place' according to data stored in col_index | 
| + | 
| +        method should be in ('asc', 'desc') | 
| +        """ | 
| +        sort_list = sorted([(row[col_index], row, row_name) | 
| +                     for row, row_name in zip(self.data, self.row_names)]) | 
| +        # Sorting sort_list will sort according to col_index | 
| +        # If we want reverse sort, then reverse list | 
| +        if method.lower() == 'desc': | 
| +            sort_list.reverse() | 
| + | 
| +        # Rebuild data / row names | 
| +        self.data = [] | 
| +        self.row_names = [] | 
| +        for val, row, row_name in sort_list: | 
| +            self.data.append(row) | 
| +            self.row_names.append(row_name) | 
| + | 
| +    def groupby(self, colname, *others): | 
| +        """builds indexes of data | 
| +        :returns: nested dictionaries pointing to actual rows | 
| +        """ | 
| +        groups = {} | 
| +        colnames = (colname,) + others | 
| +        col_indexes = [self.col_names.index(col_id) for col_id in colnames] | 
| +        for row in self.data: | 
| +            ptr = groups | 
| +            for col_index in col_indexes[:-1]: | 
| +                ptr = ptr.setdefault(row[col_index], {}) | 
| +            ptr = ptr.setdefault(row[col_indexes[-1]], | 
| +                                 Table(default_value=self.default_value, | 
| +                                       col_names=self.col_names)) | 
| +            ptr.append_row(tuple(row)) | 
| +        return groups | 
| + | 
| +    def select(self, colname, value): | 
| +        grouped = self.groupby(colname) | 
| +        try: | 
| +            return grouped[value] | 
| +        except KeyError: | 
| +            return [] | 
| + | 
| +    def remove(self, colname, value): | 
| +        col_index = self.col_names.index(colname) | 
| +        for row in self.data[:]: | 
| +            if row[col_index] == value: | 
| +                self.data.remove(row) | 
| + | 
| + | 
| +    ## The 'setter' part ####################################################### | 
| +    def set_cell(self, row_index, col_index, data): | 
| +        """sets value of cell 'row_indew', 'col_index' to data | 
| +        """ | 
| +        self.data[row_index][col_index] = data | 
| + | 
| + | 
| +    def set_cell_by_ids(self, row_id, col_id, data): | 
| +        """sets value of cell mapped by row_id and col_id to data | 
| +        Raises a KeyError if row_id or col_id are not found in the table | 
| +        """ | 
| +        try: | 
| +            row_index = self.row_names.index(row_id) | 
| +        except ValueError: | 
| +            raise KeyError("Row (%s) not found in table" % (row_id)) | 
| +        else: | 
| +            try: | 
| +                col_index = self.col_names.index(col_id) | 
| +                self.data[row_index][col_index] = data | 
| +            except ValueError: | 
| +                raise KeyError("Column (%s) not found in table" % (col_id)) | 
| + | 
| + | 
| +    def set_row(self, row_index, row_data): | 
| +        """sets the 'row_index' row | 
| +        pre: | 
| +            type(row_data) == types.ListType | 
| +            len(row_data) == len(self.col_names) | 
| +        """ | 
| +        self.data[row_index] = row_data | 
| + | 
| + | 
| +    def set_row_by_id(self, row_id, row_data): | 
| +        """sets the 'row_id' column | 
| +        pre: | 
| +            type(row_data) == types.ListType | 
| +            len(row_data) == len(self.row_names) | 
| +        Raises a KeyError if row_id is not found | 
| +        """ | 
| +        try: | 
| +            row_index = self.row_names.index(row_id) | 
| +            self.set_row(row_index, row_data) | 
| +        except ValueError: | 
| +            raise KeyError('Row (%s) not found in table' % (row_id)) | 
| + | 
| + | 
| +    def append_row(self, row_data, row_name=None): | 
| +        """Appends a row to the table | 
| +        pre: | 
| +            type(row_data) == types.ListType | 
| +            len(row_data) == len(self.col_names) | 
| +        """ | 
| +        row_name = row_name or self._next_row_name() | 
| +        self.row_names.append(row_name) | 
| +        self.data.append(row_data) | 
| +        return len(self.data) - 1 | 
| + | 
| +    def insert_row(self, index, row_data, row_name=None): | 
| +        """Appends row_data before 'index' in the table. To make 'insert' | 
| +        behave like 'list.insert', inserting in an out of range index will | 
| +        insert row_data to the end of the list | 
| +        pre: | 
| +            type(row_data) == types.ListType | 
| +            len(row_data) == len(self.col_names) | 
| +        """ | 
| +        row_name = row_name or self._next_row_name() | 
| +        self.row_names.insert(index, row_name) | 
| +        self.data.insert(index, row_data) | 
| + | 
| + | 
| +    def delete_row(self, index): | 
| +        """Deletes the 'index' row in the table, and returns it. | 
| +        Raises an IndexError if index is out of range | 
| +        """ | 
| +        self.row_names.pop(index) | 
| +        return self.data.pop(index) | 
| + | 
| + | 
| +    def delete_row_by_id(self, row_id): | 
| +        """Deletes the 'row_id' row in the table. | 
| +        Raises a KeyError if row_id was not found. | 
| +        """ | 
| +        try: | 
| +            row_index = self.row_names.index(row_id) | 
| +            self.delete_row(row_index) | 
| +        except ValueError: | 
| +            raise KeyError('Row (%s) not found in table' % (row_id)) | 
| + | 
| + | 
| +    def set_column(self, col_index, col_data): | 
| +        """sets the 'col_index' column | 
| +        pre: | 
| +            type(col_data) == types.ListType | 
| +            len(col_data) == len(self.row_names) | 
| +        """ | 
| + | 
| +        for row_index, cell_data in enumerate(col_data): | 
| +            self.data[row_index][col_index] = cell_data | 
| + | 
| + | 
| +    def set_column_by_id(self, col_id, col_data): | 
| +        """sets the 'col_id' column | 
| +        pre: | 
| +            type(col_data) == types.ListType | 
| +            len(col_data) == len(self.col_names) | 
| +        Raises a KeyError if col_id is not found | 
| +        """ | 
| +        try: | 
| +            col_index = self.col_names.index(col_id) | 
| +            self.set_column(col_index, col_data) | 
| +        except ValueError: | 
| +            raise KeyError('Column (%s) not found in table' % (col_id)) | 
| + | 
| + | 
| +    def append_column(self, col_data, col_name): | 
| +        """Appends the 'col_index' column | 
| +        pre: | 
| +            type(col_data) == types.ListType | 
| +            len(col_data) == len(self.row_names) | 
| +        """ | 
| +        self.col_names.append(col_name) | 
| +        for row_index, cell_data in enumerate(col_data): | 
| +            self.data[row_index].append(cell_data) | 
| + | 
| + | 
| +    def insert_column(self, index, col_data, col_name): | 
| +        """Appends col_data before 'index' in the table. To make 'insert' | 
| +        behave like 'list.insert', inserting in an out of range index will | 
| +        insert col_data to the end of the list | 
| +        pre: | 
| +            type(col_data) == types.ListType | 
| +            len(col_data) == len(self.row_names) | 
| +        """ | 
| +        self.col_names.insert(index, col_name) | 
| +        for row_index, cell_data in enumerate(col_data): | 
| +            self.data[row_index].insert(index, cell_data) | 
| + | 
| + | 
| +    def delete_column(self, index): | 
| +        """Deletes the 'index' column in the table, and returns it. | 
| +        Raises an IndexError if index is out of range | 
| +        """ | 
| +        self.col_names.pop(index) | 
| +        return [row.pop(index) for row in self.data] | 
| + | 
| + | 
| +    def delete_column_by_id(self, col_id): | 
| +        """Deletes the 'col_id' col in the table. | 
| +        Raises a KeyError if col_id was not found. | 
| +        """ | 
| +        try: | 
| +            col_index = self.col_names.index(col_id) | 
| +            self.delete_column(col_index) | 
| +        except ValueError: | 
| +            raise KeyError('Column (%s) not found in table' % (col_id)) | 
| + | 
| + | 
| +    ## The 'getter' part ####################################################### | 
| + | 
| +    def get_shape(self): | 
| +        """Returns a tuple which represents the table's shape | 
| +        """ | 
| +        return len(self.row_names), len(self.col_names) | 
| +    shape = property(get_shape) | 
| + | 
| +    def __getitem__(self, indices): | 
| +        """provided for convenience""" | 
| +        rows, multirows = None, False | 
| +        cols, multicols = None, False | 
| +        if isinstance(indices, tuple): | 
| +            rows = indices[0] | 
| +            if len(indices) > 1: | 
| +                cols = indices[1] | 
| +        else: | 
| +            rows = indices | 
| +        # define row slice | 
| +        if isinstance(rows, str): | 
| +            try: | 
| +                rows = self.row_names.index(rows) | 
| +            except ValueError: | 
| +                raise KeyError("Row (%s) not found in table" % (rows)) | 
| +        if isinstance(rows, int): | 
| +            rows = slice(rows, rows+1) | 
| +            multirows = False | 
| +        else: | 
| +            rows = slice(None) | 
| +            multirows = True | 
| +        # define col slice | 
| +        if isinstance(cols, str): | 
| +            try: | 
| +                cols = self.col_names.index(cols) | 
| +            except ValueError: | 
| +                raise KeyError("Column (%s) not found in table" % (cols)) | 
| +        if isinstance(cols, int): | 
| +            cols = slice(cols, cols+1) | 
| +            multicols = False | 
| +        else: | 
| +            cols = slice(None) | 
| +            multicols = True | 
| +        # get sub-table | 
| +        tab = Table() | 
| +        tab.default_value = self.default_value | 
| +        tab.create_rows(self.row_names[rows]) | 
| +        tab.create_columns(self.col_names[cols]) | 
| +        for idx, row in enumerate(self.data[rows]): | 
| +            tab.set_row(idx, row[cols]) | 
| +        if multirows : | 
| +            if multicols: | 
| +                return tab | 
| +            else: | 
| +                return [item[0] for item in tab.data] | 
| +        else: | 
| +            if multicols: | 
| +                return tab.data[0] | 
| +            else: | 
| +                return tab.data[0][0] | 
| + | 
| +    def get_cell_by_ids(self, row_id, col_id): | 
| +        """Returns the element at [row_id][col_id] | 
| +        """ | 
| +        try: | 
| +            row_index = self.row_names.index(row_id) | 
| +        except ValueError: | 
| +            raise KeyError("Row (%s) not found in table" % (row_id)) | 
| +        else: | 
| +            try: | 
| +                col_index = self.col_names.index(col_id) | 
| +            except ValueError: | 
| +                raise KeyError("Column (%s) not found in table" % (col_id)) | 
| +        return self.data[row_index][col_index] | 
| + | 
| +    def get_row_by_id(self, row_id): | 
| +        """Returns the 'row_id' row | 
| +        """ | 
| +        try: | 
| +            row_index = self.row_names.index(row_id) | 
| +        except ValueError: | 
| +            raise KeyError("Row (%s) not found in table" % (row_id)) | 
| +        return self.data[row_index] | 
| + | 
| +    def get_column_by_id(self, col_id, distinct=False): | 
| +        """Returns the 'col_id' col | 
| +        """ | 
| +        try: | 
| +            col_index = self.col_names.index(col_id) | 
| +        except ValueError: | 
| +            raise KeyError("Column (%s) not found in table" % (col_id)) | 
| +        return self.get_column(col_index, distinct) | 
| + | 
| +    def get_columns(self): | 
| +        """Returns all the columns in the table | 
| +        """ | 
| +        return [self[:, index] for index in range(len(self.col_names))] | 
| + | 
| +    def get_column(self, col_index, distinct=False): | 
| +        """get a column by index""" | 
| +        col = [row[col_index] for row in self.data] | 
| +        if distinct: | 
| +            col = list(set(col)) | 
| +        return col | 
| + | 
| +    def apply_stylesheet(self, stylesheet): | 
| +        """Applies the stylesheet to this table | 
| +        """ | 
| +        for instruction in stylesheet.instructions: | 
| +            eval(instruction) | 
| + | 
| + | 
| +    def transpose(self): | 
| +        """Keeps the self object intact, and returns the transposed (rotated) | 
| +        table. | 
| +        """ | 
| +        transposed = Table() | 
| +        transposed.create_rows(self.col_names) | 
| +        transposed.create_columns(self.row_names) | 
| +        for col_index, column in enumerate(self.get_columns()): | 
| +            transposed.set_row(col_index, column) | 
| +        return transposed | 
| + | 
| + | 
| +    def pprint(self): | 
| +        """returns a string representing the table in a pretty | 
| +        printed 'text' format. | 
| +        """ | 
| +        # The maximum row name (to know the start_index of the first col) | 
| +        max_row_name = 0 | 
| +        for row_name in self.row_names: | 
| +            if len(row_name) > max_row_name: | 
| +                max_row_name = len(row_name) | 
| +        col_start = max_row_name + 5 | 
| + | 
| +        lines = [] | 
| +        # Build the 'first' line <=> the col_names one | 
| +        # The first cell <=> an empty one | 
| +        col_names_line = [' '*col_start] | 
| +        for col_name in self.col_names: | 
| +            col_names_line.append(col_name.encode('iso-8859-1') + ' '*5) | 
| +        lines.append('|' + '|'.join(col_names_line) + '|') | 
| +        max_line_length = len(lines[0]) | 
| + | 
| +        # Build the table | 
| +        for row_index, row in enumerate(self.data): | 
| +            line = [] | 
| +            # First, build the row_name's cell | 
| +            row_name = self.row_names[row_index].encode('iso-8859-1') | 
| +            line.append(row_name + ' '*(col_start-len(row_name))) | 
| + | 
| +            # Then, build all the table's cell for this line. | 
| +            for col_index, cell in enumerate(row): | 
| +                col_name_length = len(self.col_names[col_index]) + 5 | 
| +                data = str(cell) | 
| +                line.append(data + ' '*(col_name_length - len(data))) | 
| +            lines.append('|' + '|'.join(line) + '|') | 
| +            if len(lines[-1]) > max_line_length: | 
| +                max_line_length = len(lines[-1]) | 
| + | 
| +        # Wrap the table with '-' to make a frame | 
| +        lines.insert(0, '-'*max_line_length) | 
| +        lines.append('-'*max_line_length) | 
| +        return '\n'.join(lines) | 
| + | 
| + | 
| +    def __repr__(self): | 
| +        return repr(self.data) | 
| + | 
| +    def as_text(self): | 
| +        data = [] | 
| +        # We must convert cells into strings before joining them | 
| +        for row in self.data: | 
| +            data.append([str(cell) for cell in row]) | 
| +        lines = ['\t'.join(row) for row in data] | 
| +        return '\n'.join(lines) | 
| + | 
| + | 
| + | 
| +class TableStyle: | 
| +    """Defines a table's style | 
| +    """ | 
| + | 
| +    def __init__(self, table): | 
| + | 
| +        self._table = table | 
| +        self.size = dict([(col_name, '1*') for col_name in table.col_names]) | 
| +        # __row_column__ is a special key to define the first column which | 
| +        # actually has no name (<=> left most column <=> row names column) | 
| +        self.size['__row_column__'] = '1*' | 
| +        self.alignment = dict([(col_name, 'right') | 
| +                               for col_name in table.col_names]) | 
| +        self.alignment['__row_column__'] = 'right' | 
| + | 
| +        # We shouldn't have to create an entry for | 
| +        # the 1st col (the row_column one) | 
| +        self.units = dict([(col_name, '') for col_name in table.col_names]) | 
| +        self.units['__row_column__'] = '' | 
| + | 
| +    # XXX FIXME : params order should be reversed for all set() methods | 
| +    def set_size(self, value, col_id): | 
| +        """sets the size of the specified col_id to value | 
| +        """ | 
| +        self.size[col_id] = value | 
| + | 
| +    def set_size_by_index(self, value, col_index): | 
| +        """Allows to set the size according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL : the '0' column is the '__row_column__' one ! | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        self.size[col_id] = value | 
| + | 
| + | 
| +    def set_alignment(self, value, col_id): | 
| +        """sets the alignment of the specified col_id to value | 
| +        """ | 
| +        self.alignment[col_id] = value | 
| + | 
| + | 
| +    def set_alignment_by_index(self, value, col_index): | 
| +        """Allows to set the alignment according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL : the '0' column is the '__row_column__' one ! | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        self.alignment[col_id] = value | 
| + | 
| + | 
| +    def set_unit(self, value, col_id): | 
| +        """sets the unit of the specified col_id to value | 
| +        """ | 
| +        self.units[col_id] = value | 
| + | 
| + | 
| +    def set_unit_by_index(self, value, col_index): | 
| +        """Allows to set the unit according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL :  the '0' column is the '__row_column__' one ! | 
| +        (Note that in the 'unit' case, you shouldn't have to set a unit | 
| +        for the 1st column (the __row__column__ one)) | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        self.units[col_id] = value | 
| + | 
| + | 
| +    def get_size(self, col_id): | 
| +        """Returns the size of the specified col_id | 
| +        """ | 
| +        return self.size[col_id] | 
| + | 
| + | 
| +    def get_size_by_index(self, col_index): | 
| +        """Allows to get the size  according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL : the '0' column is the '__row_column__' one ! | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        return self.size[col_id] | 
| + | 
| + | 
| +    def get_alignment(self, col_id): | 
| +        """Returns the alignment of the specified col_id | 
| +        """ | 
| +        return self.alignment[col_id] | 
| + | 
| + | 
| +    def get_alignment_by_index(self, col_index): | 
| +        """Allors to get the alignment according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL : the '0' column is the '__row_column__' one ! | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        return self.alignment[col_id] | 
| + | 
| + | 
| +    def get_unit(self, col_id): | 
| +        """Returns the unit of the specified col_id | 
| +        """ | 
| +        return self.units[col_id] | 
| + | 
| + | 
| +    def get_unit_by_index(self, col_index): | 
| +        """Allors to get the unit according to the column index rather than | 
| +        using the column's id. | 
| +        BE CAREFUL : the '0' column is the '__row_column__' one ! | 
| +        """ | 
| +        if col_index == 0: | 
| +            col_id = '__row_column__' | 
| +        else: | 
| +            col_id = self._table.col_names[col_index-1] | 
| + | 
| +        return self.units[col_id] | 
| + | 
| + | 
| +import re | 
| +CELL_PROG = re.compile("([0-9]+)_([0-9]+)") | 
| + | 
| +class TableStyleSheet: | 
| +    """A simple Table stylesheet | 
| +    Rules are expressions where cells are defined by the row_index | 
| +    and col_index separated by an underscore ('_'). | 
| +    For example, suppose you want to say that the (2,5) cell must be | 
| +    the sum of its two preceding cells in the row, you would create | 
| +    the following rule : | 
| +        2_5 = 2_3 + 2_4 | 
| +    You can also use all the math.* operations you want. For example: | 
| +        2_5 = sqrt(2_3**2 + 2_4**2) | 
| +    """ | 
| + | 
| +    def __init__(self, rules = None): | 
| +        rules = rules or [] | 
| +        self.rules = [] | 
| +        self.instructions = [] | 
| +        for rule in rules: | 
| +            self.add_rule(rule) | 
| + | 
| + | 
| +    def add_rule(self, rule): | 
| +        """Adds a rule to the stylesheet rules | 
| +        """ | 
| +        try: | 
| +            source_code = ['from math import *'] | 
| +            source_code.append(CELL_PROG.sub(r'self.data[\1][\2]', rule)) | 
| +            self.instructions.append(compile('\n'.join(source_code), | 
| +                'table.py', 'exec')) | 
| +            self.rules.append(rule) | 
| +        except SyntaxError: | 
| +            print "Bad Stylesheet Rule : %s [skipped]"%rule | 
| + | 
| + | 
| +    def add_rowsum_rule(self, dest_cell, row_index, start_col, end_col): | 
| +        """Creates and adds a rule to sum over the row at row_index from | 
| +        start_col to end_col. | 
| +        dest_cell is a tuple of two elements (x,y) of the destination cell | 
| +        No check is done for indexes ranges. | 
| +        pre: | 
| +            start_col >= 0 | 
| +            end_col > start_col | 
| +        """ | 
| +        cell_list = ['%d_%d'%(row_index, index) for index in range(start_col, | 
| +                                                                   end_col + 1)] | 
| +        rule = '%d_%d=' % dest_cell + '+'.join(cell_list) | 
| +        self.add_rule(rule) | 
| + | 
| + | 
| +    def add_rowavg_rule(self, dest_cell, row_index, start_col, end_col): | 
| +        """Creates and adds a rule to make the row average (from start_col | 
| +        to end_col) | 
| +        dest_cell is a tuple of two elements (x,y) of the destination cell | 
| +        No check is done for indexes ranges. | 
| +        pre: | 
| +            start_col >= 0 | 
| +            end_col > start_col | 
| +        """ | 
| +        cell_list = ['%d_%d'%(row_index, index) for index in range(start_col, | 
| +                                                                   end_col + 1)] | 
| +        num = (end_col - start_col + 1) | 
| +        rule = '%d_%d=' % dest_cell + '('+'+'.join(cell_list)+')/%f'%num | 
| +        self.add_rule(rule) | 
| + | 
| + | 
| +    def add_colsum_rule(self, dest_cell, col_index, start_row, end_row): | 
| +        """Creates and adds a rule to sum over the col at col_index from | 
| +        start_row to end_row. | 
| +        dest_cell is a tuple of two elements (x,y) of the destination cell | 
| +        No check is done for indexes ranges. | 
| +        pre: | 
| +            start_row >= 0 | 
| +            end_row > start_row | 
| +        """ | 
| +        cell_list = ['%d_%d'%(index, col_index) for index in range(start_row, | 
| +                                                                   end_row + 1)] | 
| +        rule = '%d_%d=' % dest_cell + '+'.join(cell_list) | 
| +        self.add_rule(rule) | 
| + | 
| + | 
| +    def add_colavg_rule(self, dest_cell, col_index, start_row, end_row): | 
| +        """Creates and adds a rule to make the col average (from start_row | 
| +        to end_row) | 
| +        dest_cell is a tuple of two elements (x,y) of the destination cell | 
| +        No check is done for indexes ranges. | 
| +        pre: | 
| +            start_row >= 0 | 
| +            end_row > start_row | 
| +        """ | 
| +        cell_list = ['%d_%d'%(index, col_index) for index in range(start_row, | 
| +                                                                   end_row + 1)] | 
| +        num = (end_row - start_row + 1) | 
| +        rule = '%d_%d=' % dest_cell + '('+'+'.join(cell_list)+')/%f'%num | 
| +        self.add_rule(rule) | 
| + | 
| + | 
| + | 
| +class TableCellRenderer: | 
| +    """Defines a simple text renderer | 
| +    """ | 
| + | 
| +    def __init__(self, **properties): | 
| +        """keywords should be properties with an associated boolean as value. | 
| +        For example : | 
| +            renderer = TableCellRenderer(units = True, alignment = False) | 
| +        An unspecified property will have a 'False' value by default. | 
| +        Possible properties are : | 
| +            alignment, unit | 
| +        """ | 
| +        self.properties = properties | 
| + | 
| + | 
| +    def render_cell(self, cell_coord, table, table_style): | 
| +        """Renders the cell at 'cell_coord' in the table, using table_style | 
| +        """ | 
| +        row_index, col_index = cell_coord | 
| +        cell_value = table.data[row_index][col_index] | 
| +        final_content = self._make_cell_content(cell_value, | 
| +                                                table_style, col_index  +1) | 
| +        return self._render_cell_content(final_content, | 
| +                                         table_style, col_index + 1) | 
| + | 
| + | 
| +    def render_row_cell(self, row_name, table, table_style): | 
| +        """Renders the cell for 'row_id' row | 
| +        """ | 
| +        cell_value = row_name.encode('iso-8859-1') | 
| +        return self._render_cell_content(cell_value, table_style, 0) | 
| + | 
| + | 
| +    def render_col_cell(self, col_name, table, table_style): | 
| +        """Renders the cell for 'col_id' row | 
| +        """ | 
| +        cell_value = col_name.encode('iso-8859-1') | 
| +        col_index = table.col_names.index(col_name) | 
| +        return self._render_cell_content(cell_value, table_style, col_index +1) | 
| + | 
| + | 
| + | 
| +    def _render_cell_content(self, content, table_style, col_index): | 
| +        """Makes the appropriate rendering for this cell content. | 
| +        Rendering properties will be searched using the | 
| +        *table_style.get_xxx_by_index(col_index)' methods | 
| + | 
| +        **This method should be overridden in the derived renderer classes.** | 
| +        """ | 
| +        return content | 
| + | 
| + | 
| +    def _make_cell_content(self, cell_content, table_style, col_index): | 
| +        """Makes the cell content (adds decoration data, like units for | 
| +        example) | 
| +        """ | 
| +        final_content = cell_content | 
| +        if 'skip_zero' in self.properties: | 
| +            replacement_char = self.properties['skip_zero'] | 
| +        else: | 
| +            replacement_char = 0 | 
| +        if replacement_char and final_content == 0: | 
| +            return replacement_char | 
| + | 
| +        try: | 
| +            units_on = self.properties['units'] | 
| +            if units_on: | 
| +                final_content = self._add_unit( | 
| +                    cell_content, table_style, col_index) | 
| +        except KeyError: | 
| +            pass | 
| + | 
| +        return final_content | 
| + | 
| + | 
| +    def _add_unit(self, cell_content, table_style, col_index): | 
| +        """Adds unit to the cell_content if needed | 
| +        """ | 
| +        unit = table_style.get_unit_by_index(col_index) | 
| +        return str(cell_content) + " " + unit | 
| + | 
| + | 
| + | 
| +class DocbookRenderer(TableCellRenderer): | 
| +    """Defines how to render a cell for a docboook table | 
| +    """ | 
| + | 
| +    def define_col_header(self, col_index, table_style): | 
| +        """Computes the colspec element according to the style | 
| +        """ | 
| +        size = table_style.get_size_by_index(col_index) | 
| +        return '<colspec colname="c%d" colwidth="%s"/>\n' % \ | 
| +               (col_index, size) | 
| + | 
| + | 
| +    def _render_cell_content(self, cell_content, table_style, col_index): | 
| +        """Makes the appropriate rendering for this cell content. | 
| +        Rendering properties will be searched using the | 
| +        table_style.get_xxx_by_index(col_index)' methods. | 
| +        """ | 
| +        try: | 
| +            align_on = self.properties['alignment'] | 
| +            alignment = table_style.get_alignment_by_index(col_index) | 
| +            if align_on: | 
| +                return "<entry align='%s'>%s</entry>\n" % \ | 
| +                       (alignment, cell_content) | 
| +        except KeyError: | 
| +            # KeyError <=> Default alignment | 
| +            return "<entry>%s</entry>\n" % cell_content | 
| + | 
| + | 
| +class TableWriter: | 
| +    """A class to write tables | 
| +    """ | 
| + | 
| +    def __init__(self, stream, table, style, **properties): | 
| +        self._stream = stream | 
| +        self.style = style or TableStyle(table) | 
| +        self._table = table | 
| +        self.properties = properties | 
| +        self.renderer = None | 
| + | 
| + | 
| +    def set_style(self, style): | 
| +        """sets the table's associated style | 
| +        """ | 
| +        self.style = style | 
| + | 
| + | 
| +    def set_renderer(self, renderer): | 
| +        """sets the way to render cell | 
| +        """ | 
| +        self.renderer = renderer | 
| + | 
| + | 
| +    def update_properties(self, **properties): | 
| +        """Updates writer's properties (for cell rendering) | 
| +        """ | 
| +        self.properties.update(properties) | 
| + | 
| + | 
| +    def write_table(self, title = ""): | 
| +        """Writes the table | 
| +        """ | 
| +        raise NotImplementedError("write_table must be implemented !") | 
| + | 
| + | 
| + | 
| +class DocbookTableWriter(TableWriter): | 
| +    """Defines an implementation of TableWriter to write a table in Docbook | 
| +    """ | 
| + | 
| +    def _write_headers(self): | 
| +        """Writes col headers | 
| +        """ | 
| +        # Define col_headers (colstpec elements) | 
| +        for col_index in range(len(self._table.col_names)+1): | 
| +            self._stream.write(self.renderer.define_col_header(col_index, | 
| +                                                              self.style)) | 
| + | 
| +        self._stream.write("<thead>\n<row>\n") | 
| +        # XXX FIXME : write an empty entry <=> the first (__row_column) column | 
| +        self._stream.write('<entry></entry>\n') | 
| +        for col_name in self._table.col_names: | 
| +            self._stream.write(self.renderer.render_col_cell( | 
| +                col_name, self._table, | 
| +                self.style)) | 
| + | 
| +        self._stream.write("</row>\n</thead>\n") | 
| + | 
| + | 
| +    def _write_body(self): | 
| +        """Writes the table body | 
| +        """ | 
| +        self._stream.write('<tbody>\n') | 
| + | 
| +        for row_index, row in enumerate(self._table.data): | 
| +            self._stream.write('<row>\n') | 
| +            row_name = self._table.row_names[row_index] | 
| +            # Write the first entry (row_name) | 
| +            self._stream.write(self.renderer.render_row_cell(row_name, | 
| +                                                            self._table, | 
| +                                                            self.style)) | 
| + | 
| +            for col_index, cell in enumerate(row): | 
| +                self._stream.write(self.renderer.render_cell( | 
| +                    (row_index, col_index), | 
| +                    self._table, self.style)) | 
| + | 
| +            self._stream.write('</row>\n') | 
| + | 
| +        self._stream.write('</tbody>\n') | 
| + | 
| + | 
| +    def write_table(self, title = ""): | 
| +        """Writes the table | 
| +        """ | 
| +        self._stream.write('<table>\n<title>%s></title>\n'%(title)) | 
| +        self._stream.write( | 
| +            '<tgroup cols="%d" align="left" colsep="1" rowsep="1">\n'% | 
| +            (len(self._table.col_names)+1)) | 
| +        self._write_headers() | 
| +        self._write_body() | 
| + | 
| +        self._stream.write('</tgroup>\n</table>\n') | 
| + | 
| + | 
|  |