Example #1
0
 def __init__(self, model, rels=None, **kw):
     BaseSqlaInspector.__init__(self, model, **kw)
     # We store the relations already treated by storing the primaryjoin that
     # they use, since the backref uses the same join string, we can avoid
     # recursive collection
     self.rels = rels or []
     self.columns = self.collect_columns()
Example #2
0
    def _collect_relationship(self, main_infos, prop, result):
        """
        collect a relationship header:

        * One To many : if {'export': {'reletad_key': 'remote_attr'}} is
            provided, we take all the related objects and join their remote
            attr's value with commas
            If an index is provided, only the related element of index 'index'
            is retrieved and it's attr value is returned
            In case of excel exports, a specific sheet is generated by table
            (see excel.py for more details)

        * Many To One :

            If a related_key is provided, we remove the associated foreign key
            from the output (we collect its associated title) and only the
            given key of the associated object will be exported
            If no related_key is provided, we use the relationship's title as
            prefix and for each attribute of the related object, we add a
            column
            If a callable is provided under the formatter key, it will be used
            to format the related object


        :param dict main_infos: The already collected datas about this column
        :param obj prop: The property mapper of the relationship
        :param list result: The actual collected headers
        :returns: a dict with the datas matching this header
        """
        # No handling of the uselist relationships for the moment
        # Maybe with indexes ? ( to see: on row add, append headers on the fly
        # if needed )
        if prop.uselist:
            # One to many
            pass
        else:
            if "related_key" in main_infos or 'formatter' in main_infos:
                self._merge_many_to_one_field(main_infos, prop, result)
            else:
                related_field_inspector = BaseSqlaInspector(prop.mapper)
                main_infos_list = []

                for column in related_field_inspector.get_columns_only():
                    infos = self._get_prop_infos(column)
                    if self._is_excluded(column, infos):
                        continue

                    infos['label'] = u"%s %s" % (
                        main_infos['label'], infos['label']
                    )
                    infos['__col__'] = main_infos['__col__']
                    infos['name'] = "%s %s" % (main_infos['name'], column.key)
                    infos['key'] = main_infos['key']
                    infos['related_key'] = column.key
                    main_infos_list.append(infos)
                return main_infos_list

        return main_infos
Example #3
0
 def __init__(self, model, excludes=(), exclude_relationships=False):
     BaseSqlaInspector.__init__(self, model)
     self.model = model
     self.excludes = excludes
     self.exclude_relationships = exclude_relationships
     self.columns = self._collect_columns()
Example #4
0
 def __init__(self, model, excludes=(), exclude_relationships=False):
     BaseSqlaInspector.__init__(self, model)
     self.model = model
     self.excludes = excludes
     self.exclude_relationships = exclude_relationships
     self.columns = self._collect_columns()
Example #5
0
 def __init__(self, model, excludes=()):
     BaseSqlaInspector.__init__(self, model)
     self.model = model
     self.excludes = excludes
     self.columns = self._collect_columns()
Example #6
0
 def __init__(self, model, excludes=()):
     BaseSqlaInspector.__init__(self, model)
     self.model = model
     self.excludes = excludes
     self.columns = self._collect_columns()
Example #7
0
 def __init__(self, model, **kw):
     BaseExporter.__init__(self)
     BaseSqlaInspector.__init__(self, model, **kw)
     self.set_headers(self._collect_headers())