Collections:
Truncate Test Case and Test Run Tables
How to Truncate Test Case and Test Run Tables? I want to remove old data and start it over from empty tables.
✍: FYIcenter.com
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, 2193🔥, 0💬
Popular Posts:
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to update hidden input value field value with WebDriver in Python? Normally, a hidden input valu...