python FAKER 构造数据

pip3 install faker

from faker import Faker  
fake = Faker("zh_CN") 
fake.date()

dir(fake)       #查看其它包也是同理
dir(fake.date())

create table user_message(
id varchar2(18) primary key,
name varchar2(20) not null,
address varchar2(200),
birthday date,
email varchar2(200),
phone numbe
)

import cx_Oracle
from faker import Fake
import time
begin_time=time.time()
fake = Faker("zh_CN") 
userName="username"
password="passwd"
with cx_Oracle.connect(userName, password, "192.168.101.171/ddcwpdb",encoding="UTF-8") as connection:
    cursor = connection.cursor()
    for i in range(10000):
        shenfenz = fake.ssn()
        name = fake.name()
        address = fake.address()
        birthday = fake.date()
        email = fake.email()
        phone = int(fake.phone_number())
        try:
            cursor.execute("insert into user_message values (:1, :2, :3, to_date(:4,'yyyy/MM/dd'), :5, :6)" 
                           ,(shenfenz,name,address,birthday,email,phone))
        except:
            print('insert into user_messgae',(shenfenz,name,address,birthday,email,phone),'failed')
    connection.commit()
end_time=time.time()
print('cost ',end_time - begin_time , 'secconds')

select * from user_message;