1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| {
"job": {
"setting": {
"speed": {
"channel": 1
}
},
"content": [
{
"reader": {
"name": "sqlserverreader",
"parameter": {
"username": "sa",
"password": "EIKYJnnifZgBRMa0",
"where": "1 = 1",
"column": ["[id]", "[agent_cd]", "[company_cd]", "[password]", "[contype]", "[subcod]", "[branch]", "[city]", "[ssc]", "[user_type]", "[user_id]", "[user_name]", "[user_status]", "[team_code]", "[team_name]", "[office_code]", "[office_name]", "[certiid]", "[date_of_birth]", "[gender]", "[contracted_date]", "[title]", "[dtleader]", "[agent_type]", "[mobile]", "[email]", "[title_describe]", "[ccc_menu]","[sb_role_id]", "[sub_admin_flag]", "[role_level]", "[delete_flag]", "[area]", "[city_zh]", "[last_login_time]" , "[insert_time]", "[update_time]"],
"connection": [
{
"jdbcUrl": [
"jdbc:sqlserver://sit.wai:21433;DatabaseName=AIAWEBSITE"
],
"table": ["tookeen_sb_admin"]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "develop",
"password": "e16078588fee866d",
"preSql": [
"delete from spmall_admin"
],
"column": ["`id`", "`agent_cd`", "`company_cd`", "`password`", "`contype`", "`subcod`", "`branch`", "`city`", "`ssc`", "`user_type`", "`user_id`", "`user_name`", "`user_status`", "`team_code`", "`team_name`", "`office_code`", "`office_name`", "`certiid`", "`date_of_birth`", "`gender`", "`contracted_date`", "`title`", "`dtleader`", "`agent_type`", "`mobile`", "`email`", "`title_describe`", "`ccc_menu`", "`sb_role_id`", "`sub_admin_flag`", "`role_level`", "`delete_flag`", "`area`", "`city_zh`", "`last_login_time`", "`insert_time`", "`update_time`"],
"connection": [
{
"jdbcUrl": "jdbc:mysql://sit.wai:23306/spmall?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8",
"table": ["spmall_admin"]
}
]
}
}
}
]
}
}
|
