This tool provides a tool for automatically converting multiple databases from SQL to JSON format, and supports major databases such as MySQL, PostgreSQL, and Oracle. This tool converts SQL query results into structured JSON data, which facilitates JSON processing and data exchange, optimizes data management and integration processes, and improves work efficiency.
使用说明
feature introduction
- Table creation sql to json supporting multiple databases, including (pg, oracle, mysql) and other databases;table-building statements,table-building statements,table-building statements(important statements are said 3 times)
- When converting sql, you need to confirm whether you need to switch the processing type. Three processing methods are temporarily supported (normal,postgresql,oracle). Default:normal.
- Support custom filtering of unwanted fields. Multiple fields are separated by ,.
example
mysql table statement
CREATE TABLE if not exists user (
id int NOT NULL AUTO_INCREMENT,
name varchar(10) NOT NULL COMMENT 'name ',
gender tinyint NOT NULL DEFAULT 0 COMMENT 'Gender 0 -unknown 1 -male 2 -female ',
age int NOT NULL COMMENT 'age ',
created_date datetime DEFAULT CURRENT_TIMESTAMP,
updated_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);
After treatment
{
"id": "",
"name": "name",
"gender": "gender 0-unknown 1-male 2-female",
"age": "Age",
"created_date": "",
"updated_date": ""
}
pgsql table statement
CREATE TABLE if not exists user (
id character varying (32) NOT NULL DEFAULT sys_guid ()
name character varying (10) NOT NULL
gender tinyint NOT NULL
age tinyint NOT NULL
created_date timestamp without time zone DEFAULT now ()
updated_date timestamp without time zone DEFAULT now ()
CONSTRAINT user_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE user IS 'user Table'
COMMENT ON COLUMN user.id IS 'primary key'
COMMENT ON COLUMN user.name IS 'name'
COMMENT ON COLUMN user.gender IS 'Sex 0-unknown 1-male 2-female'
COMMENT ON COLUMN user.age IS 'age'
COMMENT ON COLUMN user.created_date IS 'creation time'
COMMENT ON COLUMN user.updated_date IS 'update time'
After treatment
{
"id": "",
"name": "name",
"gender": "gender 0-unknown 1-male 2-female",
"age": "Age",
"created_date": "",
"updated_date": ""
}
oracle table statement
CREATE TABLE if not exists user (
id character varying (32) NOT NULL DEFAULT sys_guid ()
name character varying (10) NOT NULL
gender tinyint NOT NULL
age tinyint NOT NULL
created_date date default sysdate
updated_date date default sysdate
CONSTRAINT user_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE user IS 'user Table'
COMMENT ON COLUMN user.id IS 'primary key'
COMMENT ON COLUMN user.name IS 'name'
COMMENT ON COLUMN user.gender IS 'Sex 0-unknown 1-male 2-female'
COMMENT ON COLUMN user.age IS 'age'
COMMENT ON COLUMN user.created_date IS 'creation time'
COMMENT ON COLUMN user.updated_date IS 'update time'
After treatment
{
"id": "",
"name": "name",
"gender": "gender 0-unknown 1-male 2-female",
"age": "Age",
"created_date": "",
"updated_date": ""
}