sed -i "s#'2022-08-01' and '2022-08-20'#'2022-07-01' and '2022-08-01'#g" `grep "'2022-08-01' and '2022-08-20'" -rl *.ktr`
sed -i "s/<commit>999/<commit>11/g" `grep '<commit>999' -rl /data/sh/wlhy/ktr`
sed -i "s#'2022-08-01' and '2022-08-20'#'2022-07-01' and '2022-08-01'#g" `grep "'2022-08-01' and '2022-08-20'" -rl *.ktr`
sed -i "s/FROM t_wlhy_driver/FROM t_wlhy_driver WHERE (CREATE_DATE IS NOT NULL AND DATE_SUB(CURDATE(), INTERVAL 30 DAY) \<\;= date(CREATE_DATE)) OR (UPDATE_DATE IS NOT NULL AND DATE_SUB(CURDATE(), INTERVAL 30 DAY) \<\;= date(UPDATE_DATE))/g" `grep 'FROM t_wlhy_driver' -rl wlhy-t_wlhy_driver_*.ktr`