接上篇：结婚礼金红白喜事记账系统源码分享~
为了测试网页源码是否正常读取数据库，写了一个利用faker随机生成中文名字的代码
第一步导入镜像源
pip install faker -i https://mirrors.aliyun.com/pypi/simple/
完整代码如下.
import random
from faker import Faker
# 创建一个Faker实例，指定locale为zh_CN以生成中文姓名
fake = Faker('zh_CN')
def generate_random_employee(num_records):
categories = ['一连', '二连', '三连', '四连', '五连']
insert_statements = []
for _ in range(num_records):
name = fake.name() # 使用Faker生成随机中文姓名
amount = random.randint(1, 200) * 10 # Ensure it's a multiple of 10 and under 2000
category = random.choice(categories)
note = '{:04d}'.format(random.randint(0, 9999)) # Generates a random 4-digit number
insert_statements.append(f"('{name}', {amount}, '{category}', '{note}')")
# Join all generated statements into one SQL command
sql_command = "INSERT INTO employees (name, amount, category, note) VALUES\n" + ",\n".join(insert_statements) + ";"
return sql_command
# 控制生成多少条记录
num_records_to_generate = 300
print(generate_random_employee(num_records_to_generate)) 
