docs: 认证授权服务部署文档
diff --git a/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json b/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json
new file mode 100644
index 0000000..a9c3705
--- /dev/null
+++ b/trans-datax-job/datax/job/1001.job_TMP_DM_GENDER.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ DM, MC
+from UIDS_DM_GENDER
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "DM",
+ "MC"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_DM_GENDER"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_DM_GENDER"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json b/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json
new file mode 100644
index 0000000..1b45b2c
--- /dev/null
+++ b/trans-datax-job/datax/job/1002.job_TMP_DM_ORGTYPE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ DM, MC
+from UIDS_DM_ORGTYPE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "DM",
+ "MC"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_DM_ORGTYPE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_DM_ORGTYPE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json b/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json
new file mode 100644
index 0000000..eee499e
--- /dev/null
+++ b/trans-datax-job/datax/job/1003.job_TMP_DM_ACCOUNTTYPE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ DM, MC
+from UIDS_DM_ACCOUNTTYPE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "DM",
+ "MC"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_DM_ACCOUNTTYPE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_DM_ACCOUNTTYPE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json b/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json
new file mode 100644
index 0000000..ca35cda
--- /dev/null
+++ b/trans-datax-job/datax/job/1004.job_TMP_DM_IDENTITYTYPE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ DM, MC
+from UIDS_DM_IDENTITYTYPE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "DM",
+ "MC"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_DM_IDENTITYTYPE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_DM_IDENTITYTYPE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json b/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json
new file mode 100644
index 0000000..4678389
--- /dev/null
+++ b/trans-datax-job/datax/job/2001.job_TMP_ORGANIZE.json
@@ -0,0 +1,68 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ ID, PID, CODE, NAME
+from T_ORGANIZE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "PID",
+ "CODE",
+ "NAME"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_ORGANIZE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_ORGANIZE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2002.job_TMP_PERSON.json b/trans-datax-job/datax/job/2002.job_TMP_PERSON.json
new file mode 100644
index 0000000..ab317aa
--- /dev/null
+++ b/trans-datax-job/datax/job/2002.job_TMP_PERSON.json
@@ -0,0 +1,80 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+select
+ ID, NAME, NICK, EMAIL, TEL, MOBILE, ID_CARD, REMARK, USERTYPEID, DICORGID, STAFFNO, STUDENTNO, IS_TEACHER, IS_NONGRADUATE, IS_GRADUATE, IS_PH_D_CANDIDATE
+from T_PERSON
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "NAME",
+ "NICK",
+ "EMAIL",
+ "TEL",
+ "MOBILE",
+ "ID_CARD",
+ "REMARK",
+ "USERTYPEID",
+ "DICORGID",
+ "STAFFNO",
+ "STUDENTNO",
+ "IS_TEACHER",
+ "IS_NONGRADUATE",
+ "IS_GRADUATE",
+ "IS_PH_D_CANDIDATE"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_PERSON"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_PERSON"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json b/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json
new file mode 100644
index 0000000..6b9388e
--- /dev/null
+++ b/trans-datax-job/datax/job/2003.job_TMP_ACCOUNT.json
@@ -0,0 +1,118 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT PASSWORD_POLICY_ID,
+ ID,
+ ACCOUNT_NAME,
+ PASSWORD,
+ ENCODED_PASSWORD,
+ IS_LOCKED,
+ IS_EXIPRED,
+ IS_ENABLED,
+ IS_PASSWORD_EXIPRED,
+ PERSON_ID,
+ CREATE_TIME,
+ LAST_LOGOUT_TIME,
+ LOGIN_IP,
+ LOGIN_TIME,
+ CREATE_ID,
+ IS_FIRST_CHANGE_PASS,
+ EXPIRED_DATE,
+ LAST_LOGIN_IP,
+ LAST_LOGIN_TIME,
+ LAST_UPDATE_TIME,
+ CREATE_ACCOUNT,
+ LAST_UPDATE_ACCOUNT,
+ CHECKSTATUES,
+ LOST_PASSWORD_POLICY_ID,
+ ACCOUNTTYPE_DM,
+ IS_ACTIVATED,
+ IS_DELETED,
+ IS_BLACKLISTED
+FROM T_ACCOUNT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "PASSWORD_POLICY_ID",
+ "ID",
+ "ACCOUNT_NAME",
+ "PASSWORD",
+ "ENCODED_PASSWORD",
+ "IS_LOCKED",
+ "IS_EXIPRED",
+ "IS_ENABLED",
+ "IS_PASSWORD_EXIPRED",
+ "PERSON_ID",
+ "CREATE_TIME",
+ "LAST_LOGOUT_TIME",
+ "LOGIN_IP",
+ "LOGIN_TIME",
+ "CREATE_ID",
+ "IS_FIRST_CHANGE_PASS",
+ "EXPIRED_DATE",
+ "LAST_LOGIN_IP",
+ "LAST_LOGIN_TIME",
+ "LAST_UPDATE_TIME",
+ "CREATE_ACCOUNT",
+ "LAST_UPDATE_ACCOUNT",
+ "CHECKSTATUES",
+ "LOST_PASSWORD_POLICY_ID",
+ "ACCOUNTTYPE_DM",
+ "IS_ACTIVATED",
+ "IS_DELETED",
+ "IS_BLACKLISTED"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_ACCOUNT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_ACCOUNT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json b/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json
new file mode 100644
index 0000000..6cf54e8
--- /dev/null
+++ b/trans-datax-job/datax/job/2004.job_TMP_REGISTERED_SERVICE.json
@@ -0,0 +1,116 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ID,
+ NAME,
+ SERVICE_PATTERN,
+ IS_USER_MAP,
+ IS_USER_MAP_PASS,
+ IS_EXTRA_LOGIN_PARAM,
+ IS_SSO_ENABLED,
+ IS_ENABLED,
+ IS_PROXY_ENABLED,
+ IS_ANOY,
+ ORDER_NUM,
+ IS_ATTRIBUTE_ENABLED,
+ AUTH_TYPE,
+ LOGIN_ADDRESS,
+ LOGOUT_ADDRESS,
+ IS_DEFAULT_LOGIN_SCREEN,
+ CODE,
+ CREATERUSER,
+ CREATETIME,
+ UPDATETIME,
+ VALIDATE_ADDRESS,
+ SEND_TYPE,
+ SIMULATIONTYPE,
+ IS_DELETED,
+ CLIENT_ID,
+ CLIENT_SECRET,
+ REDIRECT_URI
+FROM T_REGISTERED_SERVICE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "NAME",
+ "SERVICE_PATTERN",
+ "IS_USER_MAP",
+ "IS_USER_MAP_PASS",
+ "IS_EXTRA_LOGIN_PARAM",
+ "IS_SSO_ENABLED",
+ "IS_ENABLED",
+ "IS_PROXY_ENABLED",
+ "IS_ANOY",
+ "ORDER_NUM",
+ "IS_ATTRIBUTE_ENABLED",
+ "AUTH_TYPE",
+ "LOGIN_ADDRESS",
+ "LOGOUT_ADDRESS",
+ "IS_DEFAULT_LOGIN_SCREEN",
+ "CODE",
+ "CREATERUSER",
+ "CREATETIME",
+ "UPDATETIME",
+ "VALIDATE_ADDRESS",
+ "SEND_TYPE",
+ "SIMULATIONTYPE",
+ "IS_DELETED",
+ "CLIENT_ID",
+ "CLIENT_SECRET",
+ "REDIRECT_URI"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REGISTERED_SERVICE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REGISTERED_SERVICE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json b/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json
new file mode 100644
index 0000000..1632cc7
--- /dev/null
+++ b/trans-datax-job/datax/job/2005.job_TMP_WEAK_PASSWORD_DICT.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ID,
+ VALUE
+FROM T_WEAK_PASSWORD_DICT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "VALUE"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_WEAK_PASSWORD_DICT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_WEAK_PASSWORD_DICT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json b/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json
new file mode 100644
index 0000000..d18d9e3
--- /dev/null
+++ b/trans-datax-job/datax/job/2006.job_TMP_ACCOUNT_QQ.json
@@ -0,0 +1,82 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ID,
+ ACCOUNT_NAME,
+ QQ_OPENID,
+ QQ_ACCESS_TOKEN,
+ ACCESS_TOKEN_TIME,
+ EXPIRES_IN,
+ QQ_REFRESH_TOKEN,
+ QQ_NICKNAME,
+ IS_BINDED,
+ OPTLOCK
+FROM T_ACCOUNT_QQ
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "ACCOUNT_NAME",
+ "QQ_OPENID",
+ "QQ_ACCESS_TOKEN",
+ "ACCESS_TOKEN_TIME",
+ "EXPIRES_IN",
+ "QQ_REFRESH_TOKEN",
+ "QQ_NICKNAME",
+ "IS_BINDED",
+ "OPTLOCK"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_ACCOUNT_QQ"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_ACCOUNT_QQ"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json b/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json
new file mode 100644
index 0000000..5a5a268
--- /dev/null
+++ b/trans-datax-job/datax/job/2007.job_TMP_ACCOUNT_WECHAT.json
@@ -0,0 +1,86 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ID,
+ ACCOUNT_NAME,
+ WECHAT_OPENID,
+ WECHAT_UNIONID,
+ WECHAT_ACCESS_TOKEN,
+ ACCESS_TOKEN_TIME,
+ EXPIRES_IN,
+ WECHAT_REFRESH_TOKEN,
+ REFRESH_TOKEN_TIME,
+ WECHAT_NICKNAME,
+ IS_BINDED,
+ OPTLOCK
+FROM T_ACCOUNT_WECHAT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ID",
+ "ACCOUNT_NAME",
+ "WECHAT_OPENID",
+ "WECHAT_UNIONID",
+ "WECHAT_ACCESS_TOKEN",
+ "ACCESS_TOKEN_TIME",
+ "EXPIRES_IN",
+ "WECHAT_REFRESH_TOKEN",
+ "REFRESH_TOKEN_TIME",
+ "WECHAT_NICKNAME",
+ "IS_BINDED",
+ "OPTLOCK"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_ACCOUNT_WECHAT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_ACCOUNT_WECHAT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json b/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json
new file mode 100644
index 0000000..e2f75d9
--- /dev/null
+++ b/trans-datax-job/datax/job/3001.job_TMP_TB_ORGANIZE.json
@@ -0,0 +1,112 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ORGID,
+ ORGPARENTID,
+ ORGPATHID,
+ ORGCODE,
+ ORGNAME,
+ ORGTYPE,
+ ORGSTATUS,
+ ORGMEMO,
+ ORGCREATEUSER,
+ ORGCREATETIME,
+ ORGUPDATETIME,
+ ORGSHORTNAME,
+ ORGENNAME,
+ ORGSHORTENNAME,
+ ORGSHORTSPELLNAME,
+ ORGADDRESS,
+ ORGTYPECODE,
+ ORGEXPIREDATE,
+ ORGINESSE,
+ ORGESTABLISHYM,
+ ORGADMINUSERID,
+ ORGPARYTUSERID,
+ ORGISDELETED,
+ ORGDELETETIME,
+ ORGDELETEUSER
+FROM UIDS_TB_ORGANIZE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ORGID",
+ "ORGPARENTID",
+ "ORGPATHID",
+ "ORGCODE",
+ "ORGNAME",
+ "ORGTYPE",
+ "ORGSTATUS",
+ "ORGMEMO",
+ "ORGCREATEUSER",
+ "ORGCREATETIME",
+ "ORGUPDATETIME",
+ "ORGSHORTNAME",
+ "ORGENNAME",
+ "ORGSHORTENNAME",
+ "ORGSHORTSPELLNAME",
+ "ORGADDRESS",
+ "ORGTYPECODE",
+ "ORGEXPIREDATE",
+ "ORGINESSE",
+ "ORGESTABLISHYM",
+ "ORGADMINUSERID",
+ "ORGPARYTUSERID",
+ "ORGISDELETED",
+ "ORGDELETETIME",
+ "ORGDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_ORGANIZE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_ORGANIZE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json b/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json
new file mode 100644
index 0000000..ec2c259
--- /dev/null
+++ b/trans-datax-job/datax/job/3002.job_TMP_TB_USER.json
@@ -0,0 +1,114 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT USERID,
+ USERORGID,
+ USERNAME,
+ USERNICK,
+ USERSTATUS,
+ USERMEMO,
+ USERCREATEUSER,
+ USERCREATETIME,
+ USERUPDATETIME,
+ USERSTAFFNO,
+ USERSTUDENTNO,
+ USERIDENTITYTYPE,
+ USERIDENTITYNO,
+ USERGENDER,
+ USERBIRTHDATE,
+ USERPHONE,
+ USERMOBILE,
+ USERMAIL,
+ USERSERIALNO,
+ USERPASSWORD,
+ USERISDELETED,
+ USERISACTIVATED,
+ USERISEXPIRED,
+ USERDELETEUSER,
+ USERDELETETIME,
+ USERISBLACKLISTED
+FROM UIDS_TB_USER
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "USERID",
+ "USERORGID",
+ "USERNAME",
+ "USERNICK",
+ "USERSTATUS",
+ "USERMEMO",
+ "USERCREATEUSER",
+ "USERCREATETIME",
+ "USERUPDATETIME",
+ "USERSTAFFNO",
+ "USERSTUDENTNO",
+ "USERIDENTITYTYPE",
+ "USERIDENTITYNO",
+ "USERGENDER",
+ "USERBIRTHDATE",
+ "USERPHONE",
+ "USERMOBILE",
+ "USERMAIL",
+ "USERSERIALNO",
+ "USERPASSWORD",
+ "USERISDELETED",
+ "USERISACTIVATED",
+ "USERISEXPIRED",
+ "USERDELETEUSER",
+ "USERDELETETIME",
+ "USERISBLACKLISTED"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_USER"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_USER"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json b/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json
new file mode 100644
index 0000000..dc5e591
--- /dev/null
+++ b/trans-datax-job/datax/job/3003.job_TMP_TB_ACCOUNT.json
@@ -0,0 +1,112 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ACCOUNTID,
+ ACCOUNTUSERID,
+ ACCOUNTKEY,
+ ACCOUNTPWD,
+ ACCOUNTTYPE,
+ ACCOUNTSTATUS,
+ ACCOUNTCREATEUSER,
+ ACCOUNTCREATETIME,
+ ACCOUNTUPDATETIME,
+ ACCOUNTPWDSTRATEGYID,
+ ACCOUNTLOGINTIME,
+ ACCOUNTLOGINIP,
+ ACCOUNTLOGOUTTIME,
+ ACCOUNTFAILEDTIMES,
+ ACCOUNTKEYCREATETIME,
+ ACCOUNTKEYINVALIDTIME,
+ ACCOUNTPWDCHANGETIME,
+ ACCOUNTPWDINVALIDTIME,
+ ACCOUNTPWDSTRENGTH,
+ ACCOUNTISDELETED,
+ ACCOUNTDELETEUSER,
+ ACCOUNTDELETETIME,
+ ACCOUNTISACTIVATED,
+ ACCOUNTISEXPIRED,
+ ACCOUNTISBLACKLISTED
+FROM UIDS_TB_ACCOUNT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ACCOUNTID",
+ "ACCOUNTUSERID",
+ "ACCOUNTKEY",
+ "ACCOUNTPWD",
+ "ACCOUNTTYPE",
+ "ACCOUNTSTATUS",
+ "ACCOUNTCREATEUSER",
+ "ACCOUNTCREATETIME",
+ "ACCOUNTUPDATETIME",
+ "ACCOUNTPWDSTRATEGYID",
+ "ACCOUNTLOGINTIME",
+ "ACCOUNTLOGINIP",
+ "ACCOUNTLOGOUTTIME",
+ "ACCOUNTFAILEDTIMES",
+ "ACCOUNTKEYCREATETIME",
+ "ACCOUNTKEYINVALIDTIME",
+ "ACCOUNTPWDCHANGETIME",
+ "ACCOUNTPWDINVALIDTIME",
+ "ACCOUNTPWDSTRENGTH",
+ "ACCOUNTISDELETED",
+ "ACCOUNTDELETEUSER",
+ "ACCOUNTDELETETIME",
+ "ACCOUNTISACTIVATED",
+ "ACCOUNTISEXPIRED",
+ "ACCOUNTISBLACKLISTED"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_ACCOUNT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_ACCOUNT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json b/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json
new file mode 100644
index 0000000..ffee491
--- /dev/null
+++ b/trans-datax-job/datax/job/3004.job_TMP_TB_USERGROUP.json
@@ -0,0 +1,84 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT USERGRPID,
+ USERGRPCODE,
+ USERGRPNAME,
+ USERGRPMEMO,
+ USERGRPSTATUS,
+ USERGRPCREATEUSER,
+ USERGRPCREATETIME,
+ USERGRPUPDATETIME,
+ USERGRPISDELETED,
+ USERGRPDELETETIME,
+ USERGRPDELETEUSER
+FROM UIDS_TB_USERGROUP
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "USERGRPID",
+ "USERGRPCODE",
+ "USERGRPNAME",
+ "USERGRPMEMO",
+ "USERGRPSTATUS",
+ "USERGRPCREATEUSER",
+ "USERGRPCREATETIME",
+ "USERGRPUPDATETIME",
+ "USERGRPISDELETED",
+ "USERGRPDELETETIME",
+ "USERGRPDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_USERGROUP"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_USERGROUP"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json b/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json
new file mode 100644
index 0000000..5a3ee34
--- /dev/null
+++ b/trans-datax-job/datax/job/3005.job_TMP_TB_ROLE.json
@@ -0,0 +1,88 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ROLEID,
+ ROLECATEGORYID,
+ ROLECODE,
+ ROLENAME,
+ ROLEMEMO,
+ ROLESTATUS,
+ ROLECREATEUSER,
+ ROLECREATETIME,
+ ROLEUPDATETIME,
+ ROLEAPPIDS,
+ ROLEISDELETED,
+ ROLEDELETETIME,
+ ROLEDELETEUSER
+FROM UIDS_TB_ROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ROLEID",
+ "ROLECATEGORYID",
+ "ROLECODE",
+ "ROLENAME",
+ "ROLEMEMO",
+ "ROLESTATUS",
+ "ROLECREATEUSER",
+ "ROLECREATETIME",
+ "ROLEUPDATETIME",
+ "ROLEAPPIDS",
+ "ROLEISDELETED",
+ "ROLEDELETETIME",
+ "ROLEDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_ROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_ROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json b/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json
new file mode 100644
index 0000000..5bc685e
--- /dev/null
+++ b/trans-datax-job/datax/job/3006.job_TMP_TB_APPLICATION.json
@@ -0,0 +1,92 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT APPID,
+ APPCODE,
+ APPNAME,
+ APPMEMO,
+ APPSTATUS,
+ APPCREATEUSER,
+ APPCREATETIME,
+ APPUPDATETIME,
+ APPURI,
+ APPICON,
+ APPSEQUENCE,
+ APPDISPLAY,
+ APPISDELETED,
+ APPDELETETIME,
+ APPDELETEUSER
+FROM UIDS_TB_APPLICATION
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "APPID",
+ "APPCODE",
+ "APPNAME",
+ "APPMEMO",
+ "APPSTATUS",
+ "APPCREATEUSER",
+ "APPCREATETIME",
+ "APPUPDATETIME",
+ "APPURI",
+ "APPICON",
+ "APPSEQUENCE",
+ "APPDISPLAY",
+ "APPISDELETED",
+ "APPDELETETIME",
+ "APPDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_APPLICATION"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_APPLICATION"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json b/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json
new file mode 100644
index 0000000..5157242
--- /dev/null
+++ b/trans-datax-job/datax/job/3007.job_TMP_TB_FUNCTION.json
@@ -0,0 +1,96 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT FUNCID,
+ FUNCAPPID,
+ FUNCPARENTID,
+ FUNCCODE,
+ FUNCNAME,
+ FUNCMEMO,
+ FUNCSTATUS,
+ FUNCCREATEUSER,
+ FUNCCREATETIME,
+ FUNCUPDATETIME,
+ FUNCURI,
+ FUNCURIPATTERN,
+ FUNCATTRIBUTE,
+ FUNCSEQUENCE,
+ FUNCISDELETED,
+ FUNCDELETETIME,
+ FUNCDELETEUSER
+FROM UIDS_TB_FUNCTION
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "FUNCID",
+ "FUNCAPPID",
+ "FUNCPARENTID",
+ "FUNCCODE",
+ "FUNCNAME",
+ "FUNCMEMO",
+ "FUNCSTATUS",
+ "FUNCCREATEUSER",
+ "FUNCCREATETIME",
+ "FUNCUPDATETIME",
+ "FUNCURI",
+ "FUNCURIPATTERN",
+ "FUNCATTRIBUTE",
+ "FUNCSEQUENCE",
+ "FUNCISDELETED",
+ "FUNCDELETETIME",
+ "FUNCDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_FUNCTION"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_FUNCTION"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json b/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json
new file mode 100644
index 0000000..561d154
--- /dev/null
+++ b/trans-datax-job/datax/job/3008.job_TMP_TB_RIGHT.json
@@ -0,0 +1,90 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT RIGHTID,
+ RIGHTFUNCID,
+ RIGHTAPPID,
+ RIGHTCODE,
+ RIGHTNAME,
+ RIGHTMEMO,
+ RIGHTSTATUS,
+ RIGHTCREATEUSER,
+ RIGHTCREATETIME,
+ RIGHTUPDATETIME,
+ RIGHTATTRIBUTE,
+ RIGHTISDELETED,
+ RIGHTDELETETIME,
+ RIGHTDELETEUSER
+FROM UIDS_TB_RIGHT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "RIGHTID",
+ "RIGHTFUNCID",
+ "RIGHTAPPID",
+ "RIGHTCODE",
+ "RIGHTNAME",
+ "RIGHTMEMO",
+ "RIGHTSTATUS",
+ "RIGHTCREATEUSER",
+ "RIGHTCREATETIME",
+ "RIGHTUPDATETIME",
+ "RIGHTATTRIBUTE",
+ "RIGHTISDELETED",
+ "RIGHTDELETETIME",
+ "RIGHTDELETEUSER"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_RIGHT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_RIGHT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json b/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json
new file mode 100644
index 0000000..e118c1b
--- /dev/null
+++ b/trans-datax-job/datax/job/3011.job_TMP_TB_ACCOUNTSECURITYEMAIL.json
@@ -0,0 +1,80 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT EMAILID,
+ EMAILACCOUNTID,
+ EMAILINFO,
+ EMAILSECURITY,
+ EMAILCODE,
+ EMAILSTATUS,
+ EMAILCREATEUSER,
+ EMAILCREATETIME,
+ EMAILUPDATETIME
+FROM UIDS_TB_ACCOUNTSECURITYEMAIL
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "EMAILID",
+ "EMAILACCOUNTID",
+ "EMAILINFO",
+ "EMAILSECURITY",
+ "EMAILCODE",
+ "EMAILSTATUS",
+ "EMAILCREATEUSER",
+ "EMAILCREATETIME",
+ "EMAILUPDATETIME"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_ACCOUNTSECURITYEMAIL"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_ACCOUNTSECURITYEMAIL"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json b/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json
new file mode 100644
index 0000000..b80e81e
--- /dev/null
+++ b/trans-datax-job/datax/job/3012.job_TMP_TB_ACCOUNTSECURITYMOBILE.json
@@ -0,0 +1,80 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT MOBILEID,
+ MOBILEACCOUNTID,
+ MOBILEINFO,
+ MOBILESECURITY,
+ MOBILECODE,
+ MOBILESTATUS,
+ MOBILECREATEUSER,
+ MOBILECREATETIME,
+ MOBILEUPDATETIME
+FROM UIDS_TB_ACCOUNTSECURITYMOBILE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "MOBILEID",
+ "MOBILEACCOUNTID",
+ "MOBILEINFO",
+ "MOBILESECURITY",
+ "MOBILECODE",
+ "MOBILESTATUS",
+ "MOBILECREATEUSER",
+ "MOBILECREATETIME",
+ "MOBILEUPDATETIME"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_TB_ACCOUNTSECURITYMOBILE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_TB_ACCOUNTSECURITYMOBILE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json b/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json
new file mode 100644
index 0000000..262a36b
--- /dev/null
+++ b/trans-datax-job/datax/job/4001.job_TMP_REF_ORGANIZEUSER.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ORGID,
+ USERID
+FROM UIDS_REF_ORGANIZEUSER
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ORGID",
+ "USERID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_ORGANIZEUSER"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_ORGANIZEUSER"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json b/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json
new file mode 100644
index 0000000..dcc7fbb
--- /dev/null
+++ b/trans-datax-job/datax/job/4002.job_TMP_REF_USERGROUPACCOUNT.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 100,
+ "percentage": 1.0
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT USERGRPID,
+ ACCOUNTID
+FROM UIDS_REF_USERGROUPACCOUNT
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "USERGRPID",
+ "ACCOUNTID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_USERGROUPACCOUNT"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_USERGROUPACCOUNT"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json b/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json
new file mode 100644
index 0000000..f778b66
--- /dev/null
+++ b/trans-datax-job/datax/job/4003.job_TMP_REF_ACCOUNTROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT ACCOUNTID,
+ ROLEID
+FROM UIDS_REF_ACCOUNTROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "ACCOUNTID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_ACCOUNTROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_ACCOUNTROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json b/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json
new file mode 100644
index 0000000..1e032b4
--- /dev/null
+++ b/trans-datax-job/datax/job/4004.job_TMP_REF_USERGROUPROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT USERGRPID,
+ ROLEID
+FROM UIDS_REF_USERGROUPROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "USERGRPID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_USERGROUPROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_USERGROUPROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json b/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json
new file mode 100644
index 0000000..b6b74e7
--- /dev/null
+++ b/trans-datax-job/datax/job/4005.job_TMP_REF_USERROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT USERID,
+ ROLEID
+FROM UIDS_REF_USERROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "USERID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_USERROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_USERROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json b/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json
new file mode 100644
index 0000000..7739d89
--- /dev/null
+++ b/trans-datax-job/datax/job/4006.job_TMP_REF_APPLICATIONROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT APPID,
+ ROLEID
+FROM UIDS_REF_APPLICATIONROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "APPID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_APPLICATIONROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_APPLICATIONROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json b/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json
new file mode 100644
index 0000000..46951c0
--- /dev/null
+++ b/trans-datax-job/datax/job/4007.job_TMP_REF_FUNCTIONROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT FUNCID,
+ ROLEID
+FROM UIDS_REF_FUNCTIONROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "FUNCID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_FUNCTIONROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_FUNCTIONROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}
diff --git a/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json b/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json
new file mode 100644
index 0000000..b16b8e8
--- /dev/null
+++ b/trans-datax-job/datax/job/4008.job_TMP_REF_RIGHTROLE.json
@@ -0,0 +1,66 @@
+{
+ "job": {
+ "setting": {
+ "speed": {
+ "channel": 3
+ },
+ "errorLimit": {
+ "record": 0,
+ "percentage": 0.02
+ }
+ },
+ "content": [
+ {
+ "reader": {
+ "name": "oraclereader",
+ "parameter": {
+ "username": "${ORACLEREADER_UNIAUTH_USERNAME}",
+ "password": "${ORACLEREADER_UNIAUTH_PASSWORD}",
+ "connection": [
+ {
+ "querySql": [
+ "
+SELECT RIGHTID,
+ ROLEID
+FROM UIDS_REF_RIGHTROLE
+"
+ ],
+ "jdbcUrl": [
+ "${ORACLEREADER_UNIAUTH_JDBC_URL}"
+ ]
+ }
+ ]
+ }
+ },
+
+ "writer": {
+ "name": "mysqlwriter8",
+ "parameter": {
+ "username": "${MYSQLWRITER8_TMP_USERNAME}",
+ "password": "${MYSQLWRITER8_TMP_PASSWORD}",
+ "column": [
+ "RIGHTID",
+ "ROLEID"
+ ],
+ "session": [
+ "set session sql_log_bin=0",
+ "set session sql_mode='ANSI'"
+ ],
+ "preSql": [
+ "delete from TMP_REF_RIGHTROLE"
+ ],
+ "connection": [
+ {
+ "jdbcUrl": "${MYSQLWRITER8_TMP_JDBC_URL}",
+ "table": [
+ "TMP_REF_RIGHTROLE"
+ ]
+ }
+ ]
+ }
+ }
+
+ }
+ ]
+ }
+}