python 导出数据为insert 语句_python将json格式数据转换为insert into语句导入mysql数据库...

#-*- coding: UTF-8 -*-

import json

f = file('mongoUser.json')

source = f.read()

f.close()

target = json.JSONDecoder().decode(source)

i = 0

#tar=target[:10]

#for item in tar:

#    print "(" + item['email'],item['password'],item['username'] + ")"

str = "insert into user(account,password,name) values "

#target = target[:13]

for item in target:            i = i + 1        if i % 2000 == 0:         print i         str = str + "('%s','%s','%s');\r\n" % (item['email'],item['password'],item['username'])         str = str + "insert into user(account,password,name) values "     else:         str = str + "('%s','%s','%s')" % (item['email'],item['password'],item['username'])         import codecs file_object = codecs.open('thefile.txt', 'w' ,"utf-8") file_object.write(str) file_object.close() print "success"