# pip install Faker -i https://pypi.douban.com/simple/
import random
import uuid

# 导入生成数据类
from faker import Faker
import datetime
from MySQLHelper import MySQLHelper

maxN = 1000000


# 黄海定义的输出信息的办法，带当前时间
def logInfo(msg):
    i = datetime.datetime.now()
    print(" %s            %s" % (i, msg))


# 设置显示的数据为中文
shuju = Faker("zh_CN")
db = MySQLHelper()

# 人员

for k in range(1, 21):
    sql = "insert into t_base_person_copy"+str(k)+"(person_name) values(%s)"
    data = []
    for i in range(maxN):
        obj = [shuju.name()]
        data.append(obj)
    db.executemany(sql, data)
    logInfo("成功完成人员信息填充,共%s条！" % maxN)

db.close()