报错内容:
{StatementError}(sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter '0'
报错部分:
sql = "update qianzhi_model_peizhi_01 set qianzhi_json= '%s',qianzhi_xuqiu_json='%s',moxing_json='%s',moxie_json='%s' where shanghu_id='%s'" % (
qianzhi_json, qianzhi_xuqiu_json, moxing_json,moxie_json, str(9999999))
self.bd_session.execute(sql)
self.bd_session.commit()
编程思路:
将字符串数据(格式是json的字符串)存入数据库
报错原因:
字符串的格式不对(需要标准的json格式)