aiomysql插入keyerror错误
async with self.engine.acquire() as conn:
async with conn.begin():
await conn.execute(insert_sql, args=item)
#执行以上代码在aiomysql中报错,keyerror
#进入报错的源代码,如下
if args is not None:
query = query % self._escape_args(args, conn)
#aiomysql/cursors.py
debug发现 self._escape_args(args, conn) 结构是一个{‘args’:{}}的字典,这就比较明显了,字典在args里面,拿出来就行了
改成下面这样:
if args is not None:
query = query % self._escape_args(args, conn)['args']
完美解决,成功插入!