"MANTISBT" How to use SQL batch to add version information

The products tested are divided into the app-side and web-side, a total of 7 subsystems, according to the company's testing process, the tester submits the bug to the current version, the developer in the repair, specify the version of the expected fix, so there are at least two sets of version number in MANTISBT, that is to increase the 14 version number, Each time the version information is added, it feels that it is a manual 650) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0060.gif "alt=" J_0060.gif "/> very low efficiency 650 ) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0065.gif "alt=" J_0065.gif "/>".

Then try to use SQL to improve efficiency, through the MANTISBT table, found that the need to manipulate the table is:

• mantis_project_version_table;

• mantis_project_table;

The compiled SQL is:

INSERT into ' mantis_project_version_table ' (

PROJECT_ID,

Version

Description

Released,

Obsolete

Date_order

)

VALUES

(

(

SELECT

a.ID

From

Mantis_project_table A

WHERE

A. Name = ' project_name '--subsystem name

),

' v1.0.4 ',--the version number of the subsystem

",--Subsystem information description

' 1 ',---whether the version is released, 1 is yes, 0 is no

' 0 ',--whether the version has been stopped maintenance, 1 is yes, 0 is no

' 1465264680 '--Version release time, Unix timestamp, can use http://tool.chinaz.com/Tools/unixtime.aspx to get timestamp of any time

);

By simply modifying the Project_Name, version, and date_order information, you can quickly add version information.

This article is from the "Le Gakuen" blog, please be sure to keep this source http://2338053.blog.51cto.com/2328053/1969473

"MANTISBT" How to use SQL batch to add version information