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"