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, 2590🔥, 0💬
Popular Posts:
How to generate currency test values? Currency test values are frequently needed in testing date and...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
How to find out my browser's identification information? To help you to see your browser identificat...
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
How to generate email addresses? To help you to obtain some email addresses for testing purpose, FYI...