Python3运行报错TypeError: Object of type bytes is not JSON serializable

最新推荐文章于 2024-06-25 15:56:29 发布

Y丶yearns

最新推荐文章于 2024-06-25 15:56:29 发布

阅读量6.4w

点赞数 3

分类专栏： python python自我成长之路文章标签： python3

本文链接：https://blog.csdn.net/qq_24347541/article/details/89139095

版权

在Python3中，当尝试将包含中文的字节类型数据转换为JSON时，会遇到'Object of type bytes is not JSON serializable'的错误。解决方法是先将bytes类型数据解码为字符串。例如，使用`.decode('utf-8')`进行解码。通过chardet库检测数据编码，确保正确解码。

摘要由CSDN通过智能技术生成

dict类型的数据(存在中文)，在python2中是可以转化的，但是在python3中存在序列化问题：
TypeError: Object of type bytes is not JSON serializable

比较low的解决办法是：
print(result[‘title’])
print(result[‘title’].decode(‘utf-8’))
print(result.decode(‘utf-8’))
print(chardet.detect(result[‘title’]))

贴出源码：

#!/usr/bin/python3
# -*- coding:utf-8 -*-
import pymysql, os, configparser
from pymysql.cursors import DictCursor
from DBUtils.PooledDB import PooledDB
import chardet
import json





class Config(object):
    """
    # Config().get_content("user_information")
    配置文件里面的参数
    [dbMysql]
    host = 192.168.1.101
    port = 3306
    user = root
    password = python123
    """

    def __init__(self, config_filename="dbMysqlConfig.cnf"):
        file_path = os.path.join(os.path.dirname(__file__), config_filename)
        self.cf = configparser.ConfigParser()
        self.cf.read(file_path)

    def get_sections(self):
        return self.cf.sections()

    def get_options(self, section):
        return self.cf.options(section)

    def get_content(self, section):
        result = {}
        for option in self.get_options(section):
            value = self.cf.get(section, option)
            result[option] = int(value) if value.isdigit() else value
        return result


class BasePymysqlPool(object):
    def __init__(self, host, port, user, password, db_name):
        self.db_host = host
        self.db_port = int(port)
        self.user = user
        self.password = str(password)
        self.db = db_name
        self.conn = None
        self.cursor = None


class MyPymysqlPool(BasePymysqlPool):
    """
    MYSQL数据库对象，负责产生数据库连接 , 此类中的连接采用连接池实现
        获取连接对象：conn = Mysql.getConn()
        释放连接对象;conn.close()或del conn
    """
    # 连接池对象
    __pool = None

    def __init__(self, conf_name=None):
        self.conf = Config().get_content(conf_name)
        super(MyPymysqlPool, self).__init__(**self.conf)
        # 数据库构造函数，从连接池中取出连接，并生成操作游标
        self._conn = self.__getConn()
        self._cursor = self._conn.cursor()

    def __getConn(self):
        """
        @summary: 静态方法，从连接池中取出连接
        @return MySQLdb.connection
        """
        if MyPymysqlPool.__pool is None:
            __pool = PooledDB(creator=pymysql,
                              mincached=1,
                              maxcached=20,
                              host=self.db_host,
                              port=self.db_port,
                              user=self.user,
                              passwd=self.password,
                              db=self.db,
                              use_unicode=False,
                              charset="utf8mb4",
                              cursorclass=DictCursor)
        return __pool.connection()

    def getAll(self, sql, param=None):
        """