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
2017-11-26, ∼3100🔥, 0💬
