最近做项目标时辰计划天天定点执行的剧本,以是在这 马克一下,利便查找
set time_zone = '+8:00';
set GLOBAL event_scheduler = 1;
-- 配置该变乱行使或所属的数据库base数据库
use nitrogenates;
# 假如原本存在该名字的使命打算则先删除
drop event if exists upload_to_sdmp;
# 配置脱离符为 '$$' ,mysql默认的语句脱离符为 ';' ,这样在后续的 create 到 end 这段代码城市当作是一条语句来执行
DELIMITER $$
# 建设打算使命,配置第一次执行时刻为'2014-07-30 10:00:00',而且天天执行一次
create event upload_to_sdmp
on schedule every 1 day starts timestamp '2017-01-17 07:16:00'
#on schedule every 1 SECOND
do
# 开始该打算使命要做的事
begin
-- do something 编写你的打算使命要做的事
# INSERT test_group(name,project_id) VALUES ("haha",1);
# 获取最后一次执行的 Case_ALL,并复制到新ID中
#变动时刻为当前时刻
#将最后一次执行的 Case对应的 ID 酿成新ID。
Insert into execution(name,project_id,test_suite_id) select name,project_id,test_suite_id from execution WHERE test_suite_id=3 ORDER BY created_time DESC LIMIT 1;
UPDATE execution SET created_time=(select CURRENT_TIMESTAMP) WHERE created_time="0000-00-00 00:00:00";
#UPDATE queue_entry SET execution_id=(SELECT id FROM execution ORDER BY id DESC LIMIT 1) WHERE execution_id=(select id from execution WHERE test_suite_id=3 ORDER BY created_time DESC LIMIT 1,1);
Insert into queue_entry(test_case_id,project_id) select test_case_id,project_id from queue_entry WHERE execution_id=(select id from execution WHERE test_suite_id=3 ORDER BY created_time DESC LIMIT 1,1);
UPDATE queue_entry SET execution_id=(SELECT id FROM execution ORDER BY id DESC LIMIT 1) WHERE execution_id=0;
#获取倒数第二条
#select id from execution WHERE test_suite_id=3 ORDER BY created_time DESC LIMIT 1,1;
#最新的 ID
#SELECT id FROM execution ORDER BY id DESC LIMIT 1;
-- 竣事打算使命
end $$
# 将语句支解符配置回 ';'
DELIMITER ;
来历: http://www.cnblogs.com/zhongmeizhi/p/6339971.html (编辑:厦门网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|