Truncate Test Case and Test Run Tables

Q

How to Truncate Test Case and Test Run Tables? I want to remove old data and start it over from empty tables.

✍: FYIcenter.com

A

You can follow this tutorials to truncate Test Case and Test Run Tables.

1. Create a SQL script file, TruncateTestMan.sql:

-- TruncateTestMan.sql

use TestMan; 

truncate table Test_Run_Case_Step_Input;
truncate table Test_Run_Case_Step_Assertion;
truncate table Test_Run_Case_Step;
truncate table Test_Run_Case_Parameter;
truncate table Test_Run_Case;
truncate table Test_Run;

truncate table Test_Case_Step_Input;
truncate table Test_Case_Step_Assertion;
truncate table Test_Case_Step;
truncate table Test_Case_Reference;
truncate table Test_Case_History;
truncate table Test_Case_Parameter;
truncate table Test_Case;

2. Run TruncateTestMan.sql:

>\fyicenter\mysql\bin\mysql -u fyicenter < TruncateTestMan.sql

 

Generating Reports from TestMan Database

Archive JMeter Test Result Data

Implementing TestMan in MySQL

⇑⇑ Test Management Tutorials

2017-11-26, 2371🔥, 0💬