faker批量生成测试数据

import pymysql
from faker import Faker

faker = Faker("zh_CN")  # 中文数据


def insert_data():
    conn = pymysql.connect(host=‘localhost‘, port=3306, user=‘root‘, password=‘root‘, database=‘school‘)
    cursor = conn.cursor()
    # SQL 插入语句
    sql = "INSERT INTO person(name,address,birthdate)VALUES (%s,%s,%s)"
    person_data = []
    for i in range(100):
        person_info = (faker.name(), faker.address(), faker.date())
        person_data.append(person_info)
    print(person_data)
    try:
        # 执行sql语句
        cursor.executemany(sql, person_data)  # todo 批量生成数据用executemany
        # 提交到数据库执行
        conn.commit()
        print("插入数据完成...")
    except Exception as e:
        # 如果发生错误则回滚
        conn.rollback()
        raise e
    finally:
        conn.close()  # 关闭数据库连接


insert_data()