From c5ac97682e3b4ca748541ace97cb37a2295bd81e Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 19 三月 2026 22:46:29 +0800
Subject: [PATCH] feat: 增加GPS清理后台任务
---
sql/clean_gps.sql | 37 +++++++++++++++++++++++--------------
1 files changed, 23 insertions(+), 14 deletions(-)
diff --git a/sql/clean_gps.sql b/sql/clean_gps.sql
index 692b8e8..1ec063b 100644
--- a/sql/clean_gps.sql
+++ b/sql/clean_gps.sql
@@ -1,27 +1,36 @@
+-- ----------------------------
+-- 娓呯悊杞﹁締GPS鍘嗗彶鏁版嵁瀹氭椂浠诲姟閰嶇疆
+-- 璇存槑锛氭瘡澶╁噷鏅�2鐐规墽琛岋紝淇濈暀鏈�杩�2涓湀鏁版嵁锛岃秴鍑洪儴鍒嗗垎鎵瑰垹闄わ紙姣忔壒1涓囨潯锛�
+-- ----------------------------
+
+-- 濡傛灉宸插瓨鍦ㄥ悓鍚嶄换鍔″厛鍒犻櫎锛岄伩鍏嶉噸澶嶆彃鍏�
+DELETE FROM sys_job
+WHERE job_name = '娓呯悊杞﹁締GPS鍘嗗彶鏁版嵁' AND job_group = 'DEFAULT';
+
INSERT INTO sys_job (
- job_name,
- job_group,
- invoke_target,
- cron_expression,
- misfire_policy,
- concurrent,
- status,
- create_by,
- create_time,
- update_by,
- update_time,
+ job_name,
+ job_group,
+ invoke_target,
+ cron_expression,
+ misfire_policy,
+ concurrent,
+ status,
+ create_by,
+ create_time,
+ update_by,
+ update_time,
remark
) VALUES (
'娓呯悊杞﹁締GPS鍘嗗彶鏁版嵁',
'DEFAULT',
'cleanVehicleGpsTask.cleanVehicleGpsData()',
- '0 0 1 * * ?',
- '1',
+ '0 0 2 * * ?',
+ '3',
'1',
'0',
'admin',
sysdate(),
'admin',
sysdate(),
- '姣忓ぉ鍑屾櫒1鐐规竻鐞嗚溅杈咷PS鍘嗗彶鏁版嵁锛屽彧淇濈暀姣忓彴杞︽渶鍚�2澶╃殑鏁版嵁'
+ '姣忓ぉ鍑屾櫒2鐐规墽琛岋紝鍒嗘壒鍒犻櫎tb_vehicle_gps涓秴杩�2涓湀鐨勫巻鍙叉暟鎹紙姣忔壒1涓囨潯锛屾壒娆￠棿闅�500ms锛夛紝鍒犻櫎瀹屾垚鍚庢墽琛孫PTIMIZE TABLE鍥炴敹纾佺洏绌洪棿'
);
\ No newline at end of file
--
Gitblit v1.9.1