Create Test Run Tables

Q

How to create TestMan test run tables in MySQL server?

✍: FYIcenter.com

A

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

 

Implementing TestMan in MySQL

⇒⇒Test Management Tutorials

2017-12-21, 343👍, 0💬