datafaker连Oracle造测试数据

资料

https://github.com/gangly/datafaker

安装 python 3

yum install python3 -y
rm -f /usr/bin/python
ln -s /usr/bin/python3 /usr/bin/python
sed -i “s::python2:g” /usr/bin/yum
sed -i “s::python2:g” /usr/libexec/urlgrabber-ext-down

安装 datafaker

pip3 install datafaker -i https://mirrors.aliyun.com/pypi/simple/

安装 cx-Oracle

pip3 install cx-Oracle -i https://mirrors.aliyun.com/pypi/simple/

创建测试用户和测试表

create tablespace test datafile '/u01/app/oracle/oradata/ORCLT/test02.dbf' size 1024M;
create user test identified by test default tablespace test;
grant connect,resource to test;
grant unlimited tablespace to test;

drop table test.stu purge;
create table test.stu (
	id NUMBER primary key,
	name varchar2(20) not null,
	school varchar2(20) not null,
	nickname varchar2(20) not null,
	age NUMBER not null,
	class_num NUMBER not null,
	score NUMBER(4,2) not null,
	phone NUMBER not null,
	email varchar2(64),
	ip varchar2(32),
	address CLOB
);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

编写元数据 meta.txt

编写文件