[MantisBT] how to use SQL to add version information in bulk

The tested products are divided into app and web, with a total of 7 subsystems. According to the company's test process, testers submit bugs to the current version; developers specify the version expected to be fixed when fixing, so there must be at least two sets of version numbers in MantisBT, that is, 14 version numbers must be added. Each time version information is added, it is considered a physical effort.

Very inefficient.

。

So try to use SQL to improve efficiency, after sorting out the MantisBT table, found that the tables that need to be operated are:

mantis_project_version_table ;

mantis_project_table ;

SQL is sorted out as:

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', --Version number of subsystem

'', --Subsystem Information Description

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

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

'1465264680' --version release time, Unix timestamp, you can use http://www.example.com to get any timestamp tool.chinaz.com/Tools/unixtime.aspx

);

After simply modifying the project_name, version, and date_order information, you can quickly add version information.