Collections:
Create Test Run Tables
How to create TestMan test run tables in MySQL server?
✍: FYIcenter.com
You can create TestMan test run tables in MySQL server by following this tutorial.
1. Create the following SQL file, CreateTestRun.sql:
-- CreateTestRun.sql use TestMan; create table Test_Run ( ID int not null auto_increment, Name varchar(80), Success boolean, Timestamp timestamp null default null, Duration int, Total int, failed int, Description varchar(255), Reference varchar(80), Primary Key (ID) ); create table Test_Run_Case ( ID int not null auto_increment, Test_Run_ID int, Test_Case_ID int, Name varchar(80), Success boolean, Priority varchar(16), Product varchar(80), Component varchar(80), Function varchar(80), Timestamp timestamp null default null, Duration int, Total int, Failed int, Method varchar(80), Target varchar(80), Version varchar(16), Station varchar(80), Tester varchar(80), Description varchar(255), Reference varchar(80), Primary Key (ID) ); create table Test_Run_Case_Parameter ( ID int not null auto_increment, Test_Run_Case_ID int, Test_Case_Parameter_ID int, Name varchar(80), Description varchar(255), Value varchar(255), Primary Key (ID) ); create table Test_Run_Case_Step ( ID int not null auto_increment, Test_Run_Case_ID int, Test_Case_Step_ID int, Name varchar(80), Success boolean, Timestamp timestamp null default null, Duration int, Output varchar(255), Description varchar(255), Primary Key (ID) ); create table Test_Run_Case_Step_Input ( ID int not null auto_increment, Test_Run_Case_Step_ID int, Test_Case_Step_Input_ID int, Name varchar(80), Value varchar(255), Primary Key (ID) ); create table Test_Run_Case_Step_Assertion ( ID int not null auto_increment, Test_Run_Case_Step_ID int, Test_Case_Step_Assertion_ID int, Name varchar(80), Expectation varchar(255), Result varchar(255), Primary Key (ID) );
2. Run CreateTestRun.sql with MySQL client command tool:
>\fyicenter\mysql\bin\mysql -u fyicenter < CreateTestRun.sql
⇒ Create JMeter Test Result Table
2017-12-21, 2642🔥, 0💬
Popular Posts:
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...