一些测试场景的执行往往需要先往DB中注入一些测试数据，一般可以通过sql脚本来实现

drop procedure if exists init_QB_Static_Info;
delimiter //
create procedure init_QB_Static_Info ()
begin
declare i int default 0;
delete from tQuestionBank_Static_Info;
while(i < 1000) do
insert into tQuestionBank_Static_Info values(i, mod(i, 10), CONCAT('Test', i), 'filepath:xxxxxx', i, 10.1, 'Test Question', now(), 0);
set i = i + 1;
end while;
end;
drop procedure if exists init_QB_Access_Info;
create procedure init_QB_Access_Info ()
begin
declare i int default 0;
delete from tQuestionBank_Access_Info;
while(i < 100000) do
-- if (mod(i , 2) = 0) then
insert into tQuestionBank_Access_Info values(1, mod(i, 1000), mod(i, 10), 1, now());
-- end if;
set i = i + 1;
end while;
end;
//
delimiter ;

ITPub博客

mysql的存储过程