def sa_obj_to_dict(obj, filtrate=None, rename=None):
    """
    sqlalchemy 對(duì)象轉(zhuǎn)為dict
    :param filtrate: 過(guò)濾的字段
    :type filtrate: list or tuple
    :param rename: 需要改名的,改名在過(guò)濾之后處理, key為原來(lái)對(duì)象的屬性名稱(chēng)，value為需要更改名稱(chēng)
    :type rename: dict
    :rtype: dict
    """

    if isinstance(obj.__class__, DeclarativeMeta):
        # an SQLAlchemy class
        #該類(lèi)的相關(guān)類(lèi)型，即直接與間接父類(lèi)
        cla = obj.__class__.__mro__
        #過(guò)濾不需要的父類(lèi)
        cla = filter(lambda c: hasattr(c, '__table__'), filter(lambda c: isinstance(c, DeclarativeMeta), cla))
        columns = []
        map(lambda c: columns.extend(c.__table__.columns), cla[::-1])
        # columns = obj.__table__.columns
        if filtrate and isinstance(filtrate, (list, tuple)):
            fields = dict(map(lambda c: (c.name, getattr(obj, c.name)), filter(lambda c: not c.name in filtrate, columns)))
        else:
            fields = dict(map(lambda c: (c.name, getattr(obj, c.name)), columns))
        # fields = dict([(c.name, getattr(obj, c.name)) for c in obj.__table__.columns])
        if rename and isinstance(rename, dict):
            #先移除key和value相同的項(xiàng)
            _rename = dict(filter(lambda (k, v): str(k) != str(v), rename.iteritems()))
            #如果原始key不存在，那么新的key對(duì)應(yīng)的值默認(rèn)為None
            #如果新的key已存在于原始key中，那么原始key的值將被新的key的值覆蓋
            # map(lambda (k, v): fields.setdefault(v, fields.pop(k, None)), _rename.iteritems())
            map(lambda (k, v): fields.update({v: fields.pop(k, None)}), _rename.iteritems())
        #
        return fields
    else:
        return {}