Create Test Case Tables

Q

How to create TestMan test case tables in MySQL server?

✍: FYIcenter.com

A

You can create TestMan test case tables in MySQL server by following this tutorial.

1. Create the following SQL file, CreateTestCase.sql:

-- CreateTestCase.sql

use TestMan; 

create table Test_Case (
   ID bigint,
   Name varchar(80),
   Status varchar(16),
   Description varchar(255),
   Priority varchar(16),
   Product varchar(80),
   Component varchar(80),
   Function varchar(80),
   Pre_Condition varchar(255),
   Post_Impact varchar(255)
);

create table Test_Case_Parameter (
   ID bigint,
   Test_Case_ID bigint,
   Name varchar(80),
   Description varchar(255),
   Value varchar(255)
);

create table Test_Case_Step (
   ID bigint,
   Test_Case_ID bigint,
   Name varchar(80),
   Description varchar(255)
);

create table Test_Case_Step_Input (
   ID bigint,
   Test_Case_Step_ID bigint,
   Name varchar(80),
   Description varchar(255)
);

create table Test_Case_Step_Assertion (
   ID bigint,
   Test_Case_Step_ID bigint,
   Name varchar(80),
   Description varchar(255)
);

create table Test_Case_Reference (
   ID bigint,
   Test_Case_ID bigint,
   Name varchar(80),
   Value varchar(255)
);

create table Test_Case_History (
   ID bigint,
   Test_Case_ID bigint,
   Timestamp timestamp null default null,
   Author varchar(80),
   Description varchar(255)
);

2. Run CreateTestCase.sql with MySQL client command tool:

>\fyicenter\mysql\bin\mysql -u fyicenter < CreateTestCase.sql

 

Implementing TestMan in MySQL

⇒⇒Test Management Tutorials

2017-12-21, 378👍, 0💬