insert into "test".test_info(
contacts , telephone)
values('{"张三", "王五"}' , '{"13869880297","18205321788"}');
res = execute_sql(sql)
print(res)
# 使用array方法
sql = """
insert into "test".test_info(
contacts , telephone)
values(array['张三', '王五'] , array['123456789','562345687']);
res = execute_sql(sql)
print(res)
# 批量写入
sql = """
insert into "test".test_info(
contacts , telephone)
values(%s , %s);
rows = [[['张三', '王五'], ['123456789','562345687']],
[['赵四', '张三'], ['1232123123','12345678']]]
res = execute_many_sql(sql, rows)
print(res)
# execute_many_sql execute_sql是个人写的工具方法 具体可以使用executemany execute来实现
