想要使用sqlalchemy往数据库种插入一条数据
INSERT ignore INTO `test` VALUES ('{"cells":[{"position":{"x":60,"y":70}}]}\r\n')
报错:sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter '60'
排查发现:
'{"cells":[{"position":{"x":60,"y":70}}]}\r\n'
会被sqlalchemy当作特殊符号处理,转义成
'{"cells":[{"position":{"x"%(60)s,"y"%(70)s}}]}\r\n',
我的解决方法:
'{"cells"\:[{"position"\:{"x"\:60,"y"\:70}}]}\r\n'