You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
770 B
34 lines
770 B
# 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() |