#-*- 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"