company_base_info_staff_job

时间:2023-03-09 17:49:05
company_base_info_staff_job
    "company_base_info_staff_job": {
"engine": "python script", # datax or python script
"update_priority": 2,
"insert_priority": 1,
"insert_schedule_time": [
{"hou": "", "min": "*", "sec": "*",
"end_time": "2019-03-14 10:00"}],
"update_schedule_time": [
{"day_of_week": "*", "start_date": "2019-03-18 11:40:00",
"hou": "", "min": "", "sec": ""}],
"mongo_read": {
"address": [mongo_cfg["raw_data"]["addr"]],
"dbName": mongo_cfg["raw_data"]["db_name"],
"collectionName": "company_base_info",
"userName": mongo_cfg["raw_data"]["user"],
"userPassword": mongo_cfg["raw_data"]["pwd"],
"query": '',
"column": [('string', 'company_name'),
('string', 'main_staff.position'),
('string', 'main_staff.name'),
]
},
"mysql_write": {
"host": mysql_cfg["seeyiidatabase"]["host"],
"port": mysql_cfg["seeyiidatabase"]["port"],
"username": mysql_cfg["seeyiidatabase"]["user"],
"password": mysql_cfg["seeyiidatabase"]["pwd"],
"dbName": mysql_cfg["seeyiidatabase"]["db_name"],
"table": ["company_base_info_staff"],
"session": [],
"preSql": [],
"postSql": [],
"column": [
"company_name",
"staff_position",
"staff_name",
],
},
"setting": {},
"create_table_column": [
{"name": "company_name", "type": "varchar", "size": 2555,
"unique": False, "default_null": True, "COMMENT": "公司名称"},
{"name": "staff_position", "type": "varchar", "size": 200,
"unique": False, "default_null": True, "COMMENT": "职位名称"},
{"name": "staff_name", "type": "varchar", "size": 2555,
"unique": False, "default_null": True, "COMMENT": "高管人员名"},
],
"query_cfg": { },
"reader_type": "mongodb_read"
}