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"