# 导入faker模块
from faker import Factory
fake = Factory().create(locale="zh_CN")
# print(dir(fake))
for i in range(1, 11):
print("第{0}次随机产生的数据:".format(i))
print("用户姓名:{0}".format(fake.name()))
print("用户名:{0}".format(fake.user_name()))
print("密码:{0}".format(fake.password()))
print("电子信箱:{0}".format(fake.email()))
print("电话号码:{0}".format(fake.phone_number()))
print("住址:{0}".format(fake.address()))
print("所在城市:{0}".format(fake.city()))
print("段落:{0}".format(fake.paragraph()))
print("文本:{0}".format(fake.text()))
print("IPv4:{0}".format(fake.ipv4()))
print("网址:{0}".format(fake.url()))
print("指定长度的字符串:{0}".format(fake.pystr(min_chars=6, max_chars=12)))
temp_shop = ['已勾选', '未勾选']
temp_order = ['已付款', '未付款']
temp_pay_en = ['淘宝', '京东', '拼多多', '唯品会']
temp_pay = ['支付成功', '支付失败']
temp_obj = ['衣', '食', '住', '行']
fake = Factory().create('zh_CN')
users, shops, orders, orders_chl, pays, objs = [], [], [], [], [], []
obj_name_ = []
for _ in range(30):
name = fake.name()
while True:
obj_name = fake.color_name()
if obj_name not in obj_name_:
obj_name_.append(obj_name)
break
users.append(User(name, fake.password(), fake.email(), fake.address()))
objs.append(
Obj(temp_obj[random.randint(0, 3)], obj_name, random.randint(1, 1000)))
shops.append(
Shop(name=name,
obj_name='None',
number=random.randint(1, 500),
status=temp_shop[random.randint(0, 1)]))
#print("INSERT INTO `用户` (`用户名`, `密码`, `邮箱`) VALUES ",end="")
for index in range(30):
i = random.randint(0, 29)
id = fake.ean8()
shops[index].obj_name = objs[i].obj_name
orders.append(
Order(id, users[i].name, users[i].address, random.randint(1, 1000),
