[Bug] Built in MySQL function library query error, Object of type Decimal is not JSON serializable

[daai-7642]

Contact Information

764297968@qq.com

MaxKB Version

maxkb-pro:v1.10.7-lts

Problem Description

直接查询不包含金额字段是没有问题的，发现使用的默认的json包，因为 Python 的 json 模块默认不支持 Decimal 类型的序列化

Steps to Reproduce

查询带有金额的字段，即可复现

The expected correct result

正确返回不报错

Related log output

Additional Information

No response

[Shenguobin0102]

感谢反馈，已知问题，后续版本修复

[shaohuzhang1]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Thanks for feedback, known issues, subsequent version fixes

[daniel7230]

如果是初次安装就修改function_lib/migrations下的0003开头的那个文件，大概在第75去加一个类：class DecimalEncoder(json.JSONEncoder): def default(self, obj): if isinstance(obj, decimal.Decimal): return float(obj) if hasattr(obj, "isoformat"): return obj.isoformat() if isinstance(obj, bytes): return obj.decode("utf-8") return super().default(obj)

然后往下走 将原来的
json_data = json.dumps(data, ensure_ascii=False)

改成
json_data = json.dumps(data,cls=DecimalEncoder, ensure_ascii=False)

就可以了。如果是已经安装好了的，又不想做迁移，就直接改数据库里的对应内容就不会有问题了。

[shaohuzhang1]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

If it is the first installation, modify the file starting with 0003 under function_lib/migrations, add a class on 75: class DecimalEncoder(json.JSONEncoder): def default(self, obj): if isinstance(obj, decimal.Decimal): return float(obj) if hasattr(obj, "isoformat"): return obj.isoformat() if isinstance(obj, bytes): return obj.decode("utf-8") return super().default(obj)

Then go down and turn the original one
json_data = json.dumps(data, ensure_ascii=False)

Change to
json_data = json.dumps(data,cls=DecimalEncoder, ensure_ascii=False)

That's it. If it is already installed and does not want to do a migration, there will be no problem if you directly modify the corresponding content in the database.