python 批量JSON数据，插入数据库

最新推荐文章于 2024-06-19 10:48:04 发布

weixin_33811961

最新推荐文章于 2024-06-19 10:48:04 发布

阅读量2.5k

点赞数

文章标签： python 数据库 json

原文链接：https://my.oschina.net/u/180293/blog/1929047

版权

2019独角兽企业重金招聘Python工程师标准>>>

newList=[{"link":"https://www.1.com/","ga_tag":"xvideos","image":"http://static.2.mobi/views/images/xvideos.png?x-oss-process=style/120"},{"link":"https://www.3.com/","ga_tag":"xnxx","image":"http://static.4.mobi/views/images/xnxx.png?x-oss-process=style/120"}]

for i in newList:
   key_list = []
   value_list = []
   for key,value in i.items():
       key_list.append(key)
       value_list.append(value)
INSERT_STRING = "INSERT INTO `%s` (`%s`) VALUE ('%s')" % (tableName, '`,`'.join(key_list),"', '".join(value_list))

转载于:https://my.oschina.net/u/180293/blog/1929047