faker : 李相赫 , 绰号“大魔王” LOL 玩得贼6......
我现在要说的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;
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。