一些测试场景的执行往往需要先往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
- 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
- -- 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博客 ” ,链接:http://blog.itpub.net/26855487/viewspace-753914/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26855487/viewspace-753914/