项目场景:python records mysql update报错 This result object does not return rows. It has been closed automatically.
提示:这里简述项目相关背景:
例如:项目场景:示例:通过蓝牙芯片(HC-05)与手机 APP 通信,每隔 5s 传输一批传感器数据(不是很大)
# 问题描述:
环境
records 0.5.3
SQLAlchemy 1.4.22
代码
sql = f"update test set limit_value = '{limit}'"
records_db._client.query(sql)
报错信息:
2021-08-27 10:55:14,764|ERROR|/root/code/envAdmin/trunk/api/webapi/src/api/__init__.py(75)|catch_error|代码错误:This result object does not return rows. It has been closed automatically., /usr/local/python3/lib/python3.7/site-packages/sqlalchemy/util/compat.py(207)[raise_]
原因分析:
SQLAlchemy 1.4版本有问题
解决方案:
pip3 uninstall SQLAlchemy
pip3 install SQLAlchemy==1.3