- 注意语句里面的参数:
@_primaryIdV:19位雪花算法ID, 如 3924508243044339712
@targetDataTime:目标数据存储的条件
@fromDataTime:获取来源数据的条件
{
"diffTableNo": 0,
"isRESTful": true,
"base": {
"connName": "ConnIdc",
"isRearEnd": true,
"isFrontEnd": true
},
"responseField": {
"month": {
"copy": {
"connName": "ConnIdc",
"rules": [
{
"regex": "fromDataTime==null ||targetDataTime==null ",
"message": "来源年月和目标年月都必须填写",
"sortId": 1
},
{
//时间列 字符串转 时间,作为下一个研究条件参数
"dateField": "targetDataTime,fromDataTime",
"regex": "fromDataTime==targetDataTime",
"message": "来源年月和目标年月不能相同",
"sortId": 5
},
{
"regex": "fromDataTimeD>targetDataTimeD||targetDataTimeD>_currentDate",
"message": "来源年月必须小于目标年月且小于当前时间",
"sortId": 6
} ],
"sql": [
{
"value": "delete from idc_resource_statistics_warm_system where data_time=@fromDataTime; ",
"sortId": 15
},
{
"value": "insert into idc_resource_statistics_cool (audit_status,audit_time,audit_user_id,back_water_in,back_water_out,cooling_tower,create_time,create_user_id,data_date,group_id,modify_time,modify_user_id,opinion,res_enum_id,sys_id,water_storage,water_supply_in,water_supply_out) ",
"sortId": 20
},
{
"value": "select audit_status,audit_time,audit_user_id,back_water_in,back_water_out,cooling_tower,create_time,create_user_id,@targetDataTime,group_id,modify_time,modify_user_id,opinion,CONCAT(substring_index(res_enum_id, '-', 3),'-',FLOOR(RAND() * 100000),'-',@_primaryIdV) res_enum_id,sys_id,water_storage,water_supply_in,water_supply_out from idc_resource_statistics_cool where data_time=@fromDataTime;",
"sortId": 25
}
]
}
}
}
}
文档更新时间: 2022-01-03 22:55 作者:admin