Hqman

sqlalchemy object json 序列化

def to_dict(self):

        """

        #序列华 sa 对象 json

        """

        def convert_datetime(value):

            return value.strftime("%Y-%m-%d %H:%M:%S")

        d = {}

        for c in self.__table__.columns:

            if isinstance(c.type, DateTime):

             value = convert_datetime(getattr(self, c.name))

            else:

                value = getattr(self, c.name)

            d[c.name] = value

        return d


    def from_dict(self, values):

        """

        反序列 json 到对象

        """

        for c in self.__table__.columns:

            if c.name in values:

                try:

                    setattr(self, c.name, values[c.name])

                except Exception, e:

                    raise e


上一篇 下一篇

© Hqman | Powered by LOFTER