https://blog.csdn.net/qq_45738151/article/details/121308122

1. 安装导入必要的库

from faker import Faker
import random
import pymysql

2. Coding

  2. ```python
  3. # -*- coding: utf-8 -*-#
  5. # -------------------------------------------------------------------------------
  6. # Name:         zh_name
  7. # Description:  
  8. # Author:       牙叔
  9. # Date:         2021/11/13  17:48 
  10. # -------------------------------------------------------------------------------
  11. from faker import Faker
  12. import random
  13. import pymysql
  15. province_id = [11, 12, 13, 14, 15, 21, 22, 23, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 44, 45, 46,
  16.                50, 51, 52, 53, 54, 61, 62, 63, 65, 65, 81, 82, 83]
  17. phone_number = [139, 138, 137, 136, 135, 134, 159, 158, 15, 150, 151, 152, 188,
  18.                 130, 131, 132, 156, 155, 133, 153, 189]
  21. # 随机生成出生日期
  22. def get_birthday():
  23.     # 随机生成年月日
  24.     year = random.randint(1960, 2000)
  25.     month = random.randint(1, 12)
  26.     # 判断每个月有多少天随机生成日
  27.     if year % 4 == 0:
  28.         if month in (1, 3, 5, 7, 8, 10, 12):
  29.             day = random.randint(1, 31)
  30.         elif month in (4, 6, 9, 11):
  31.             day = random.randint(1, 30)
  32.         else:
  33.             day = random.randint(1, 29)
  34.     else:
  35.         if month in (1, 3, 5, 7, 8, 10, 12):
  36.             day = random.randint(1, 31)
  37.         elif month in (4, 6, 9, 11):
  38.             day = random.randint(1, 30)
  39.         else:
  40.             day = random.randint(1, 28)
  41.     # 小于10的月份前面加0
  42.     if month < 10:
  43.         month = '0' + str(month)
  44.     if day < 10:
  45.         day = '0' + str(day)
  46.     birthday = str(year) + "-" + str(month) + "-" + str(day)
  47.     return birthday
  50. # 随机生成手机号
  51. def get_tel():
  52.     tel = ''
  53.     tel += str(random.choice(phone_number))
  54.     ran = ''
  55.     for i in range(8):
  56.         ran += str(random.randint(0, 9))
  57.     tel += ran
  58.     return tel
  61. get_sex = lambda: random.choice(['男', '女'])
  64. # 随机生成身份证号
  65. def get_idnum():
  66.     id_num = ''
  67.     # 随机选择地址码
  68.     id_num += str(random.choice(province_id))
  69.     # 随机生成4-6位地址码
  70.     for i in range(4):
  71.         ran_num = str(random.randint(0, 9))
  72.         id_num += ran_num
  73.     b = get_birthday()
  74.     id_num += b
  75.     # 生成15、16位顺序号
  76.     num = ''
  77.     for i in range(2):
  78.         num += str(random.randint(0, 9))
  79.     id_num += num
  80.     # 通过性别判断生成第十七位数字 男单 女双
  81.     s = get_sex()
  82.     # print("性别:", s)
  83.     if s == '男':
  84.         # 生成奇数
  85.         seventeen_num = random.randrange(1, 9, 2)
  86.     else:
  87.         seventeen_num = random.randrange(2, 9, 2)
  88.     id_num += str(seventeen_num)
  89.     eighteen_num = str(random.randint(1, 10))
  90.     if eighteen_num == '10':
  91.         eighteen_num = 'X'
  92.     id_num += eighteen_num
  93.     return id_num, s
  96. def get_DB_conn():
  97.     mysql_conn = pymysql.connect(host='127.0.0.1', port=3306, user='admin', password='admin',
  98.                                  db='persons', charset='utf8')
  99.     return mysql_conn
  102. def main():
  103.     mysql_conn = get_DB_conn()
  104.     fake = Faker("zh_CN")
  105.     for i in range(0, 10000):
  107.         s = get_idnum()
  108.         # tel = get_tel()
  109.         # print(fake.name(), tel, get_birthday(), s[0], s[1])
  110.         sql = "INSERT INTO persons (sname, stel, ssex, sprovince) VALUES ('{0}','{1}', '{2}','{3}')".format(fake.name(),
  111.                                                                                                             get_tel(),
  112.                                                                                                             s[1], s[0])
  113.         print(sql)
  114.         try:
  115.             with mysql_conn.cursor() as cursor:
  116.                 cursor.execute(sql)
  117.             mysql_conn.commit()
  118.         except Exception as e:
  119.             mysql_conn.rollback()
  120.     mysql_conn.close()
  123. if __name__ == '__main__':
  124.     main()
  125.     print("=========================完成============================")